disable connection pool

[gedel]

Hello

I configure LocalTxDataSource in my jboss-beans.xml

<bean name="StagingDSBootstrap" class="org.jboss.resource.adapter.jdbc.local.LocalTxDataSource">
 <property name="driverClass">org.hsqldb.jdbcDriver</property>
 <property name="connectionURL">jdbc:hsqldb:file:test-output/staging</property>
 <property name="userName">sa</property>

My test accesses to Datatasource through JNDI:
datasource = (DataSource) new InitialContext().lookup(jdbcUrl);

and then to connection warper:
connection = datasource.getConnection();

connection instanceof WrappedConnection

and when I close it by
connection.close()

WrappedConnection puts real JDBC connection to the connection pool.
But I need to close JDBC connection!!!

How i can to do this? or How I can disable the connection pooling in jboss-beans.xml? or In which forum I should post this question?

thanks

[weston.price]

Can you tell me where you got the class

org.jboss.resource.adapter.jdbc.local.LocalTxDataSource

and what version of JBoss you are using.

[weston.price]

Ok, I see, this is an custom class used for POJO/EJB3 based deployments. This was never really meant to be used in this manner.

If you do not want the connection pooled you would need to use some other form for acquiring your connection. DriverManager.getConnection() would be the most appropriate. A simple wrapper for this functionality should be sufficient. Also, most JDBC vendors provide non-pooled DataSource implementations that you can use directly. You would just set this up as a bean and set the properties that you need.