[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