Menu
▾
▴
Re: [JBoss-user] AS400-ds datasource blocking on first transaction
|
From: David J. <dav...@ad...> - 2003-05-23 16:14:04
|
I still have no idea what the problem is. I'd try modifying the code that actually gets the connection and printing out exactly what parameters are being used, and making sure those exact parameters work standalone. david jencks On 2003.05.23 09:15 Davide Pozza wrote: > > > Since I don't have a as400 system there's not much I can do to try > > anything. > > The connection url is not modified by jboss. > > > > Can you write a small standalone program to see what works and doesn't > work > > to get a connection using getConnection(props)? > > > > Hi David, > > I 've written a small standalone program, which tries to open a > connection and a xaconnection in various modes and I've found that the > problem seems not to be related to the "getConnection(props)". > In fact all my tests outside Jboss 3.2.1 run properly whitout any block > (as Jboss 3.2.1 ): moreover I've found that the two libraries are > correcly found and loaded by Jboss 3.2.1. > Perarphs Jboss3.21 does "something new" ( compared to Jboss 3.0.6) > during an sql transaction and to perform this operation another library > has to be specified? > > Thanks in advance > > Davide > > > I don't know if it is significant but I notice your url had "libraries" > and > > your xa example has "Libraries" > > > > david jencks > > > > On 2003.05.22 09:53 Davide Pozza wrote: > > > > This is a guess... > > > > Perhaps as400 ignores properties specified in the url if > > > > getConnection(props) is used? I think that I changed from using > > > > getConnection(user,pw) to getConnection(props) at some point. > > > > > > > > If so, you can specify the libraries in > > > > > > > > <connection-property name="libraries">CRPDTA,G8_CNVOW</connection-property> > > > > > > > > > > Unfortunatly, nothing changed. > > > I tried the following XA configuration also,but the problem is the > same: > > > > > > <datasources> > > > <xa-datasource> > > > <jndi-name>XAAS400DS</jndi-name> > > > <track-connection-by-tx>true</track-connection-by-tx> > > > <isSameRM-override-value>false</isSameRM-override-value> > > > <xa-datasource-class>com.ibm.as400.access.AS400JDBCXADataSource</xa-datasource-class> > > > <xa-datasource-property > > > name="ServerName">10.1.1.5</xa-datasource-property> > > > <xa-datasource-property > > > name="Libraries">CRPDTA,G8_CNVOW</xa-datasource-property> > > > <xa-datasource-property name="User">usr</xa-datasource-property> > > > <xa-datasource-property name="Password">pwd</xa-datasource-property> > > > </xa-datasource> > > > </datasources> > > > > > > Please help me! > > > > > > Davide > > > > > > > > > > david jencks > > > > > > > > > > > > On 2003.05.22 03:42 Davide Pozza wrote: > > > > > > > > > > I have a problem configuring my AS400 Datasource using the new > > > Jboss3.2.x > > > > > simplified syntax. > > > > > It seems that the "libraries" which I define in the connection > url > > > (es. > > > > > "jdbc:as400://10.1.1.5;libraries=CRPDTA,G8_CNVOW") > > > > > are ignored. > > > > > The server.log file says that the datasource is successfully > loaded > > > and > > > > > bounded to its JNDI name. > > > > > The problem is that al the first query, the system blocks, until > the > > > > > transaction timeout is reached. > > > > > > > > > > In the previous versions of Jboss, my AS400-service.xml (old > syntax) > > > > > didn't ever had problems and > > > > > I could reproduce the AS400-ds-xml problem just removing the > > > libraries > > > > > definition. > > > > > > > > > > > > > > > > > > > > This is my Jboss3.0.6 correctly running configuration file > > > > > AS400-service.xml: > > > > > > > > > > --------------------------------------------- > > > > > <?xml version="1.0" encoding="UTF-8"?> > > > > > <server> > > > > > <mbean code="org.jboss.resource.connectionmanager.LocalTxConnectionManager" > > > > > name="jboss.jca:service=LocalTxCM,name=AS400DS"> > > > > > <depends optional-attribute-name="ManagedConnectionFactoryName"> > > > > > <mbean code="org.jboss.resource.connectionmanager.RARDeployment" > > > > > name="jboss.jca:service=LocalTxDS,name=AS400DS"> > > > > > <attribute name="JndiName">AS400DS</attribute> > > > > > <attribute name="ManagedConnectionFactoryProperties"> > > > > > <properties> > > > > > <config-property name="ConnectionURL" > > > > > type="java.lang.String">jdbc:as400://10.1.1.5;libraries=CRPDTA,G8_CNVOW</config-property> > > > > > <config-property name="DriverClass" > > > > > type="java.lang.String">com.ibm.as400.access.AS400JDBCDriver</config-property> > > > > > <config-property name="UserName" > > > > > type="java.lang.String">user</config-property> > > > > > <config-property name="Password" > > > > > type="java.lang.String">pwd</config-property> > > > > > </properties> > > > > > </attribute> > > > > > <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=JBoss > > > > > LocalTransaction JDBC Wrapper</depends> > > > > > </mbean> > > > > > </depends> > > > > > <depends optional-attribute-name="ManagedConnectionPool"> > > > > > <mbean code="org.jboss.resource.connectionmanager.JBossManagedConnectionPool" > > > > > name="jboss.jca:service=LocalTxPool,name=AS400DS"> > > > > > <attribute name="MinSize">0</attribute> > > > > > <attribute name="MaxSize">50</attribute> > > > > > <attribute name="BlockingTimeoutMillis">5000</attribute> > > > > > <attribute name="IdleTimeoutMinutes">15</attribute> > > > > > <attribute name="Criteria">ByApplication</attribute> > > > > > </mbean> > > > > > </depends> > > > > > <depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedConnectionManager</depends> > > > > > <depends optional-attribute-name="JaasSecurityManagerService">jboss.security:service=JaasSecurityManager</depends> > > > > > <attribute name="TransactionManager">java:/TransactionManager</attribute> > > > > > <depends>jboss.jca:service=RARDeployer</depends> > > > > > </mbean> > > > > > </server> > > > > > --------------------------------------------- > > > > > > > > > > > > > > > This is my new Jboss3.2.1 configuration file AS400-ds.xml which > > > blocks on > > > > > the first query and which is correctly bounded > > > > > --------------------------------------------- > > > > > <datasources> > > > > > <local-tx-datasource> > > > > > <jndi-name>AS400DS</jndi-name> > > > > > <connection-url>jdbc:as400://10.1.1.5;libraries=CRPDTA,G8_CNVOW</connection-url> > > > > > <driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class> > > > > > <user-name>user</user-name> > > > > > <password>pwd</password> > > > > > <min-pool-size>0</min-pool-size> > > > > > </local-tx-datasource> > > > > > </datasources> > > > > > > > > > > > > > > > Thanks > > > > > > > > > > Davide > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > This SF.net email is sponsored by: ObjectStore. > > > > If flattening out C++ or Java code to make your application fit in > a > > > > relational database is painful, don't do it! Check out ObjectStore. > > > > Now part of Progress Software. > http://www.objectstore.net/sourceforge > > > > _______________________________________________ > > > > JBoss-user mailing list > > > > JBo...@li... > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: ObjectStore. > > If flattening out C++ or Java code to make your application fit in a > > relational database is painful, don't do it! Check out ObjectStore. > > Now part of Progress Software. http://www.objectstore.net/sourceforge > > _______________________________________________ > > JBoss-user mailing list > > JBo...@li... > > https://lists.sourceforge.net/lists/listinfo/jboss-user > |
