Getting with 'Select statements included within a function cannot,return data to a client.' with SQL 2005

[Radovan Biciste]

Hello,
We are trying to run our application against SQL 2005 using Weblogic
JDBC driver in Weblogic 8.1SP4. The application works fine on SQL 2000
SP4 but some calls fails on 2005 with an error below.
Is it a JDBC driver issue?
Thank you,
Radovan

<log4j:event
logger="com.webct.platform.framework.dataaccess.sql.common.VistaPreparedStatement"
timestamp="1126587702593" time="Mon Sep 12 22:01:42 PDT 2005"
level="ERROR" thread="VistaPooledThread-0:0">
<log4j:message><![CDATA[CLASS:
com.webct.platform.framework.dataaccess.sql.common.VistaPreparedStatement
METHOD: executeUpdate
DB Investigation Log ]]></log4j:message>
<log4j:throwable><![CDATA[java.sql.SQLException: [BEA][SQLServer JDBC
Driver][SQLServer]Select statements included within a function cannot
return data to a client.
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at
weblogic.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown
Source)
at weblogic.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at weblogic.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)
at
weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:147)
at
com.webct.platform.framework.dataaccess.sql.common.VistaPreparedStatement.executeUpdate(VistaPreparedStatement.java:94)
at
com.webct.platform.framework.dataaccess.sql.common.VistaPreparedStatement.executeUpdate(VistaPreparedStatement.java:85)
at
com.webct.platform.coreservice.archive.restore.GenericArchiveRestoreDao.restorePerson(GenericArchiveRestoreDao.java:1195)
at
com.webct.platform.coreservice.archive.restore.RestorePersonRoutine.execute(RestorePersonRoutine.java:14)
at
com.webct.platform.coreservice.archive.restore.GenericArchiveRestoreDao.restoreSection(GenericArchiveRestoreDao.java:155)
at
com.webct.platform.coreservice.archive.restore.ArchiveRestoreManager.restoreSectionFromUnmarshal(ArchiveRestoreManager.java:64)
at
com.webct.platform.coreservice.archive.ejb.ArchiveServiceImpl.restoreFromFile(ArchiveServiceImpl.java:130)
at
com.webct.platform.coreservice.archive.ejb.ArchiveService_ncjvx3_ELOImpl.restoreFromFile(ArchiveService_ncjvx3_ELOImpl.java:207)
at
com.webct.platform.coreservice.archive.actions.ProcessRestoreAction.restoreFile(ProcessRestoreAction.java:305)
at
com.webct.platform.coreservice.archive.actions.ProcessRestoreAction$RestoreFileDelegator.delegate(ProcessRestoreAction.java:479)
at
com.webct.platform.coreservice.progressbar.common.AsynchronousMethod$1.run(AsynchronousMethod.java:95)
at
com.webct.platform.framework.scheduler.impl.PooledThreadImpl.run(PooledThreadImpl.java:152)
]]></log4j:throwable>
</log4j:event>

[Joe Weinstein]

Radovan Biciste wrote:

> Hello,
> We are trying to run our application against SQL 2005 using Weblogic
> JDBC driver in Weblogic 8.1SP4. The application works fine on SQL 2000
> SP4 but some calls fails on 2005 with an error below.
> Is it a JDBC driver issue?
> Thank you,
> Radovan

Hi. I haven't seen this before... And there is no difference
between the procedure/SQL being called in the SQL 2000 DBMS
and SQL 2005 DBMS? The first thing I would do is to contact
BEA support and get the very latest driver package for 81sp4,
and if this doesn't fix it, let me know and I'll see what we can
do. If it's not too hard to show me the procedure+SQL+JDBC+parameter
values, so I can try to duplicate it, that would be great.

Joe Weinstein at BEA

PS: You should probably post any followups to the BEA JDBC newsgroup.

[Radovan Biciste]

Hello,
It is not a driver issue. I've tried the same procedure with different
drivers with the same result.
It must a problem with SQL 2005 itself.
Thank you,
Radovan

[Radovan Biciste]

Hello,
It is an issue in SQL 2005. It is suppose to be fixed in the September
preview version.
Thank you,
Radovan