Dropping down to JDBC.
Hi all, we have a need to drop down to a JDBC query at some point in our application. Is it possible to get a connection from the SimpleDataSource pool. (I see that this is a method on SimpleDataSource). If so how does one return the connection to the SimpleDataSource object? Regards, Wesley Acheson. - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
Re: Dropping down to JDBC.
sqlMapClient.getDataSource(); On Wed, Jan 20, 2010 at 7:05 AM, Wesley Acheson wesley.ache...@gmail.com wrote: Hi all, we have a need to drop down to a JDBC query at some point in our application. Is it possible to get a connection from the SimpleDataSource pool. (I see that this is a method on SimpleDataSource). If so how does one return the connection to the SimpleDataSource object? Regards, Wesley Acheson. - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
Re: Dropping down to JDBC.
Yes thats what I suspected. When the JDBC queries run do I close the connection object returned by this SimpleDataSource object? or is there some other way to return the connection back to the pool? Regards, Wesley Acheson On Wed, Jan 20, 2010 at 3:12 PM, Larry Meadors larry.mead...@gmail.com wrote: sqlMapClient.getDataSource(); On Wed, Jan 20, 2010 at 7:05 AM, Wesley Acheson wesley.ache...@gmail.com wrote: Hi all, we have a need to drop down to a JDBC query at some point in our application. Is it possible to get a connection from the SimpleDataSource pool. (I see that this is a method on SimpleDataSource). If so how does one return the connection to the SimpleDataSource object? Regards, Wesley Acheson. - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
Re: Dropping down to JDBC.
Just close the connection when you're done - that won't REALLY close it, it will just return it to the pool (just like any other connection pool). Larry On Wed, Jan 20, 2010 at 7:17 AM, Wesley Acheson wesley.ache...@gmail.com wrote: Yes thats what I suspected. When the JDBC queries run do I close the connection object returned by this SimpleDataSource object? or is there some other way to return the connection back to the pool? Regards, Wesley Acheson On Wed, Jan 20, 2010 at 3:12 PM, Larry Meadors larry.mead...@gmail.com wrote: sqlMapClient.getDataSource(); On Wed, Jan 20, 2010 at 7:05 AM, Wesley Acheson wesley.ache...@gmail.com wrote: Hi all, we have a need to drop down to a JDBC query at some point in our application. Is it possible to get a connection from the SimpleDataSource pool. (I see that this is a method on SimpleDataSource). If so how does one return the connection to the SimpleDataSource object? Regards, Wesley Acheson. - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
Re: Dropping down to JDBC.
Okay thats great. When we do this and call SimpleDataSource.getStatus() after attempting this. Each time we attempt this. We get badConnectionCount incremented. Trying to find the source for this at the moment to see if this is just a counter or if its iterating through its connection object to say it has bad connections. Although if anyone knows then this would be great. Regards, Wesley Acheson On Wed, Jan 20, 2010 at 3:58 PM, Larry Meadors larry.mead...@gmail.com wrote: Just close the connection when you're done - that won't REALLY close it, it will just return it to the pool (just like any other connection pool). Larry On Wed, Jan 20, 2010 at 7:17 AM, Wesley Acheson wesley.ache...@gmail.com wrote: Yes thats what I suspected. When the JDBC queries run do I close the connection object returned by this SimpleDataSource object? or is there some other way to return the connection back to the pool? Regards, Wesley Acheson On Wed, Jan 20, 2010 at 3:12 PM, Larry Meadors larry.mead...@gmail.com wrote: sqlMapClient.getDataSource(); On Wed, Jan 20, 2010 at 7:05 AM, Wesley Acheson wesley.ache...@gmail.com wrote: Hi all, we have a need to drop down to a JDBC query at some point in our application. Is it possible to get a connection from the SimpleDataSource pool. (I see that this is a method on SimpleDataSource). If so how does one return the connection to the SimpleDataSource object? Regards, Wesley Acheson. - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org