SQL Server JDBC - Exception generated during defered local transaction handling.

Author

Exception generated during defered local transaction handling.

Khyati

2006-03-30, 7:23 am

Hello,

We are using MS SQL DB Server 2005 with Weblogic Server 8.1 SP2 and at times
we are facing error of "Exception generated during defered local transaction
handling".

Attach below is the stack trace for the same::

====================
====================
======

[2006-03-30 15:13:42,812] ERROR 10701234 - java.sql.SQLException:
[BEA][SQLServer JDBC Driver]No more data available to read.
java.sql.SQLException: [BEA][SQLServer JDBC Driver]No more data available to
read.
at weblogic.jdbc.base.BaseExceptions. createException(Unkn
own Source)
at weblogic.jdbc.base.BaseExceptions. getException(Unknown
Source)
at weblogic.jdbc.sqlserver.tds.TDSExecuteRequest. submitRequest(Unknow
n
Source)
at weblogic.jdbc.sqlserver. SQLServerImplStateme
nt.execute(Unknown Source)
at weblogic.jdbc.base.BaseStatement. commonExecute(Unknow
n Source)
at weblogic.jdbc.base.BaseStatement. executeQueryInternal
(Unknown Source)
at weblogic.jdbc.base.BaseStatement. executeQuery(Unknown
Source)
at weblogic.jdbc.wrapper.Statement. executeQuery(Stateme
nt.java:324)

-----------------------------------------------------------------------------------------

[2006-03-30 15:13:46,421] ERROR ClassificationSchedu
ler_Worker-4 10704843 -
SQLException
java.sql.SQLException: [BEA][SQLServer JDBC Driver]Exception generated
during defered local transaction handling. See next exception via
SQLException.getNextException for details.
at weblogic.jdbc.base.BaseExceptions. createException(Unkn
own Source)
at weblogic.jdbc.base.BaseExceptions. getException(Unknown
Source)
at weblogic.jdbc.base.BaseExceptions. getException(Unknown
Source)
at weblogic.jdbc.base.BaseConnection. transactionableWorkS
tarting(Unknown
Source)
at weblogic.jdbc.base.BaseStatement. commonExecute(Unknow
n Source)
at weblogic.jdbc.base.BaseStatement. executeInternal(Unkn
own Source)
at weblogic.jdbc.base. BasePreparedStatemen
t.execute(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement. execute(PreparedStat
ement.java:68)

====================
====================
======

Are the above two related to each other?

I came across the following link and tried the fix mentioned in it:
http://forum.java.sun.com/thread.js...#24
64074

But it doesnt seem to be working.

Is this something to do with MS SQL Server Transaction Handling??

Any ideas in this regards would be highly appreciated.

Thanks,
Khyati

Joe Weinstein

2006-03-30, 11:23 am

Khyati wrote:
> Hello,
>
> We are using MS SQL DB Server 2005 with Weblogic Server 8.1 SP2 and at times
> we are facing error of "Exception generated during defered local transaction
> handling".
>
> Attach below is the stack trace for the same::
>
> ====================
====================
======
>
> [2006-03-30 15:13:42,812] ERROR 10701234 - java.sql.SQLException:
> [BEA][SQLServer JDBC Driver]No more data available to read.
> java.sql.SQLException: [BEA][SQLServer JDBC Driver]No more data available to
> read.
> at weblogic.jdbc.base.BaseExceptions. createException(Unkn
own Source)
> at weblogic.jdbc.base.BaseExceptions. getException(Unknown
Source)
> at weblogic.jdbc.sqlserver.tds.TDSExecuteRequest. submitRequest(Unknow
n
> Source)
> at weblogic.jdbc.sqlserver. SQLServerImplStateme
nt.execute(Unknown Source)
> at weblogic.jdbc.base.BaseStatement. commonExecute(Unknow
n Source)
> at weblogic.jdbc.base.BaseStatement. executeQueryInternal
(Unknown Source)
> at weblogic.jdbc.base.BaseStatement. executeQuery(Unknown
Source)
> at weblogic.jdbc.wrapper.Statement. executeQuery(Stateme
nt.java:324)
>
>
> -----------------------------------------------------------------------------------------
>
> [2006-03-30 15:13:46,421] ERROR ClassificationSchedu
ler_Worker-4 10704843 -
> SQLException
> java.sql.SQLException: [BEA][SQLServer JDBC Driver]Exception generated
> during defered local transaction handling. See next exception via
> SQLException.getNextException for details.
> at weblogic.jdbc.base.BaseExceptions. createException(Unkn
own Source)
> at weblogic.jdbc.base.BaseExceptions. getException(Unknown
Source)
> at weblogic.jdbc.base.BaseExceptions. getException(Unknown
Source)
> at weblogic.jdbc.base.BaseConnection. transactionableWorkS
tarting(Unknown
> Source)
> at weblogic.jdbc.base.BaseStatement. commonExecute(Unknow
n Source)
> at weblogic.jdbc.base.BaseStatement. executeInternal(Unkn
own Source)
> at weblogic.jdbc.base. BasePreparedStatemen
t.execute(Unknown Source)
> at weblogic.jdbc.wrapper.PreparedStatement. execute(PreparedStat
ement.java:68)
>
> ====================
====================
======
>
> Are the above two related to each other?

Hi. It seems so. The first seems to be a DBMS-side problem where the
driver discovers that the data reading it was doing from the DBMS
halted in-flight. The second exception is vague and implies that a
different exception (likely the first) has the true details.
I suggest:
1 - Check your DBMS error log to see if there is a fatal session-level
error recorded at the same time.
2 - Contact BEA support and get the latest driver package.
3 - How easily/regularly/quickly can this be reproduced? We may
have other debug suggestions.
4 - Find the weblogic.developer.interest.jdbc newsgroup from the bea site.
It will get you the quickest help for weblogic jdbc issues.
Joe Weinstein at BEA Systems

> I came across the following link and tried the fix mentioned in it:
> http://forum.java.sun.com/thread.js...#24
64074
>
> But it doesnt seem to be working.
>
> Is this something to do with MS SQL Server Transaction Handling??
>
> Any ideas in this regards would be highly appreciated.
>
> Thanks,
> Khyati
>
>

Sponsored Links