Menu
▾
▴
Re: [JBoss-user] AS400-ds datasource blocking on first transaction
|
From: David J. <dav...@ad...> - 2003-05-22 15:05:44
|
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)? 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 > |