On 7/6/03 5:09 PM, Adrian Brock <[EMAIL PROTECTED]> wrote:
>On Sun, 2003-07-06 at 16:40, Magesh Prabhu wrote:
>
>> I could'nt understand this Adrian, I'm using Oracle 8.1.6 database
>with the following datasource configuration:
>>
>> <datasources>
>> <local-tx-datasource>
>> <jndi-name>OracleDS</jndi-name>
>> <connection-url>jdbc:oracle:thin:@193.16.18.126:1521:clipper</connection-url>
>> <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
>> <user-name>test</user-name>
>> <password>test</password>
>>
>> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
>> </local-tx-datasource>
>> </datasources>
>>
>> Could you please give more explanation on your comment.. Should
>my jdbc driver support this prepare() method.... My transaction
>is all Container managed and I run on Commit Option 'B'
>>
>
>You need the xa datasource for prepare()
When I'm not using an xa datasource why is it expecting for a prepare(); My app
does'nt involve any XA datasource. In fact, the configuration above is the only
datasource configured for my app.
>
>> >
>> >> 2) WARN [WrappedConnection] Closing a statement you left open,
>
>> >please do your own housekeeping
>> >>
>> >
>> >You are not closing a statement. Closing a pooled connection
>> >just returns the connection to the pool.
>
>>
>> In all my Entity Beans, I have this following code to clean up
>the resources they use and I've double checked all my beans so that
>they dont leave any connections open.
>>
>> private void releaseResources(ResultSet rs, Statement stmt, Connection>
conn) {
>> if (rs != null) {
>> try {
>> rs.close();
>> } catch (SQLException e) {
>> log.fatal(e);
>> }
>> }
>>
>> if (stmt != null) {
>> try {
>> stmt.close();
>> } catch (SQLException e) {
>> log.fatal(e);
>> }
>> }
>>
>> if (conn != null) {
>> try {
>> conn.close();
>> } catch (SQLException e) {
>> log.fatal(e);
>> }
>> }
>> }
>
>JBoss disagrees with you.
>
>Maybe you have:
>
>Statement stmt = conn.prepareStatement(...);
>...
>stmt = conn.prepareStatement(...);
>...
>releaseResources(rs, stmt, conn);
>
>The first statement won't be closed.
>
>Or maybe your releaseResources is not in a finally block.
Thanks for your advice on this, I will double check my app again.
>
>--
>xxxxxxxxxxxxxxxxxxxxxxxx
>Adrian Brock
>Director of Support
>Back Office
>JBoss Group, LLC
>xxxxxxxxxxxxxxxxxxxxxxxx
>
>
>
>-------------------------------------------------------
>This SF.Net email sponsored by: Free pre-built ASP.NET sites including
>Data Reports, E-commerce, Portals, and Forums are available now.
>Download today and enter to win an XBOX or Visual Studio .NET.
>http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
>_______________________________________________
>JBoss-user mailing list
>[EMAIL PROTECTED]
>https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
**********************************************************************
This email and its attachments are intended for the above
named only and may be confidential. If they have come to
you in error, you must take no action based on them, nor
must you copy or show them to anyone; please reply to this
email and highlight the error.
Security Warning: Please note that this email has been
created in the knowledge that the internet email is not a
100% secure communications medium. We advise that you
understand and observe this lack of security when emailing us.
Viruses: Although we have taken steps to ensure that this
email and attachments are free from any virus, we advise
that in keeping with good computing practice the recipient
should ensure they are actually virus free.
If you have received this email in error please notify:
[EMAIL PROTECTED]
**********************************************************************
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
