How to Configure JBoss using Inet opta drivers for SQLServer

[snanduri]

Hi Guys,

I am trying to port a working EJB application from Borland Application Server to JBoss 3.2.1 version.

I used the sample example that came with jboss distribution and configured the datasource with inet drivers.
I get the following mesgs, when i tried to run a client against a deployed EJB's. Any idea what is wrong.

07:00:46,014 WARN [WrappedConnection] Closing a statement you left open, please do your own housekeeping

Thx for the help
Sri

Here's the contents of mssql-ds.xml file.


<local-tx-datasource>
<jndi-name>TASDataSource</jndi-name>
<connection-url>jdbc:inetdae7:patframsql02:1433</connection-url>
<driver-class>com.inet.tds.TdsDriver</driver-class>
srini_paycalc
<user-name>snanduri</user-name>
snanduri
<min-pool-size>100</min-pool-size>
<max-pool-size>1000</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
</local-tx-datasource>

[juhalindfors]

This is a warning that some of the code that uses the datasource directly is not properly closing its JDBC statements/connections. Usually you should try to find the cause of such a warning in your own code but if it is generated by a sample application (and not production code) then you can ignore it.

[snanduri]

I had changed the code to close the preparedstatements and the ResultSet too.
Still getting these messages and my transactions dosent seem to go thru.
- Sri