Skip to content

XAware Community

Get the Flash Player to see this player.
Flash Image Rotator Module by Joomlashack.
XAware 5.6
Need Help
Webinars and Events
Advanced Tutorials
Webinars and Events

You are here: Home arrow Forums
XAware Community Forums
Welcome, Guest
Please Login or Register.    Lost Password?
jdbc connection and connection pooling (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 1
TOPIC: jdbc connection and connection pooling
#5980
kilyas (User)
XAware user
Posts: 27
User Offline Click here to see the profile of this user
jdbc connection and connection pooling 9 Years, 2 Months ago Karma: 13  
I am using XAware for my database transactions, using the following driver:-

<?XML version="1.0" encoding="UTF-8"?>
<xa:BizDriver xmlns:xa="http://xaware.org/xas/ns1" xa:bizdrivertype="SQL_JNDI" xa:version="5.2">
<xa:description />
<xa:poolingparams />
<xa:initialContext xa:type="default">
<xa:url>jnp://localhost:1099</xa:url>
<xa:user /
><xa:pwd />
<xa:factory>org.jnp.interfaces.NamingContextFactory</xa:factory>
<xa:properties />
<xa:lookupName>java:TradeTestOracleDS</xa:lookupName>
<xa:userTransactionLookupName>UserTransaction</xa:userTransactionLookupName>
<xa:transactionManagerLookupName />
</xa:initialContext>
</xa:bizDriver>


I am running XAware using JBoss as the container. So far so good. The problem arises when for certain transactions I don't want to use this driver and rather use another one.

<?xml version="1.0" encoding="UTF-8"?>
<xa:bizDriver xmlns:xa="http://xaware.org/xas/ns1" xa:bizdrivertype="SQL_JDBC" xa:version="5.2">
<xa:description />
<xa:poolingparams />
<xa:connection>
<xa:url>jdbc:oracle:thin:@prxxxx.xxxx.com:1521:prodd</xa:url>
<xa:user>$xavar:userName$</xa:user>
<xa:pwd>$xavar:password$</xa:pwd>
<xa:factory>oracle.jdbc.driver.OracleDriver</xa:factory>
<xa:properties />
</xa:connection>
<xa:designer>
<xa:wizard_step xa:name="Jars Info">
<JarsInfo />
</xa:wizard_step>
<xa:wizard_step xa:name="Biz Driver" />
</xa:designer>
</xa:bizDriver>


Now what happens is that it seems to work fine for the first user whoever it is and he successfully logs in and does the transaction but as soon as the second user tries to login he gets connection pool errors.

Any suggestions?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
      Topics Author Date
    thread link
jdbc connection and connection pooling
kilyas 2010/06/15 11:14
    thread link
thread linkthread link Re:jdbc connection and connection pooling
kilyas 2010/06/15 11:27
    thread link
thread linkthread link Re:jdbc connection and connection pooling
prichards 2010/07/07 11:30
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Community Login

Get the Flash Player to see this player.
Flash Image Rotator Module by Joomlashack.
Commercial
Free Training
QuickStart Packages
Image 4 Title
Image 5 Title

Visit XAware.com