On 7/6/03 3:56 PM, Adrian Brock <[EMAIL PROTECTED]> wrote:
>On Sun, 2003-07-06 at 15:27, Magesh Prabhu wrote:
>
>> 1) WARN [TxConnectionManager$LocalXAResource] Prepare called
>on a local tx. Use of localtransactions on a jta transaction with
>more than one branch may result in inconsistent data in some cases
>of failure.
>>
>
>It is telling you your local-tx-datasource doesn't have a prepare(),
>the commit() could fail leaving your data in an inconsistent state.
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'
>
>> 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);
}
}
}
Thanks very much for your response,
Magesh
>
>--
>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
