Re: [JBoss-user] AS400-ds datasource blocking on first transaction

[David J. <dav...@ad...>]

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>

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
>