[jboss-user] [JCA/JBoss] - JBOSS 3.22 Sybase DB, I Got An Warning Message From WrappedCo
realvalkyrie
do-not-reply at jboss.com
Wed Nov 28 20:10:58 EST 2007
The Detail Info in below:
[WrappedConnection] WARN Closing a statement you left open, please do your own housekeeping.
I got connection from the DataSource.
this is my sybase-ds.xml configuration
<local-tx-datasource>
<jndi-name>jdbc/eusr</jndi-name>
<connection-url>jdbc:sybase:Tds:127.0.0.1:2638?ServiceName=eusr</connection-url>
<driver-class>com.sybase.jdbc2.jdbc.SybDataSource</driver-class>
<user-name>TTT</user-name>
TTT
<idle-timeout-minutes>5000</idle-timeout-minutes>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>
<min-pool-size>5</min-pool-size>
<max-pool-size>30</max-pool-size>
<type-mapping>Sybase</type-mapping>
</local-tx-datasource>
<local-tx-datasource>
<jndi-name>jdbc/esys</jndi-name>
<connection-url>jdbc:sybase:Tds:127.0.0.1:2638?ServiceName=esys</connection-url>
<driver-class>com.sybase.jdbc2.jdbc.SybDataSource</driver-class>
<user-name>TTT</user-name>
TTT
<idle-timeout-minutes>5000</idle-timeout-minutes>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.SybaseExceptionSorter</exception-sorter-class-name>
<min-pool-size>5</min-pool-size>
<max-pool-size>30</max-pool-size>
<type-mapping>Sybase</type-mapping>
</local-tx-datasource>
Call the Connection code below:
InitialContext initial = new InitialContext();
DataSource dataSource=null;
if(name.indexOf("usr")!=-1)
dataSource =(DataSource) initial.lookup("java:/jdbc/eusr");
else{
dataSource =(DataSource) initial.lookup("java:/jdbc/esys");
}
Connection con = dataSource.getConnection();
return con;
BTW, I got another WARN
[TxConnectionManager$LocalXAResource] Prepare called on a local tx. Use of local transactions on a jta transaction with more than one branch may result in inconsistent data in some cases of failure.
Maybe the solution that is to configure a tx DataSource
I wonder ,did Sybase has tx Datasouce , my sybase version is 12.5.0
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4108740#4108740
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4108740
More information about the jboss-user
mailing list