|
Home > Archive > SQL Server JDBC > September 2005 > Getting with 'Select statements included within a function cannot,return
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Getting with 'Select statements included within a function cannot,return
|
|
| Radovan Biciste 2005-09-14, 1:23 pm |
| 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. VistaPreparedStateme
nt"
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. VistaPreparedStateme
nt
METHOD: executeUpdate
DB Investigation Log ]]></log4j:message>
<log4j:throwable><![CDATA[java.sql.SQLException: [BEA][SQLServer JDBC
Driver]& #91;SQLServer]Select
statements included within a function cannot
return data to a client.
at weblogic.jdbc.base.BaseExceptions. createException(Unkn
own Source)
at weblogic.jdbc.base.BaseExceptions. getException(Unknown
Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest. processErrorToken(Un
known Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest. processReplyToken(Un
known Source)
at weblogic.jdbc.sqlserver.tds.TDSRPCRequest. processReplyToken(Un
known
Source)
at weblogic.jdbc.sqlserver.tds.TDSRequest. processReply(Unknown
Source)
at
weblogic.jdbc.sqlserver. SQLServerImplStateme
nt. getNextResultType(Un
known
Source)
at weblogic.jdbc.base.BaseStatement. commonTransitionToSt
ate(Unknown Source)
at weblogic.jdbc.base.BaseStatement. postImplExecute(Unkn
own Source)
at weblogic.jdbc.base. BasePreparedStatemen
t. postImplExecute(Unkn
own Source)
at weblogic.jdbc.base.BaseStatement. commonExecute(Unknow
n Source)
at weblogic.jdbc.base.BaseStatement. executeUpdateInterna
l(Unknown Source)
at weblogic.jdbc.base. BasePreparedStatemen
t. executeUpdate(Unknow
n Source)
at
weblogic.jdbc.wrapper.PreparedStatement. executeUpdate(Prepar
edStatement.java:147)
at
com.webct.platform.framework.dataaccess.sql.common. VistaPreparedStateme
nt. executeUpdate(VistaP
reparedStatement.java:94)
at
com.webct.platform.framework.dataaccess.sql.common. VistaPreparedStateme
nt. executeUpdate(VistaP
reparedStatement.java:85)
at
com.webct.platform.coreservice.archive.restore. GenericArchiveRestor
eDao. restorePerson(Generi
cArchiveRestoreDao.java:1195)
at
com.webct.platform.coreservice.archive.restore. RestorePersonRoutine
. execute(RestorePerso
nRoutine.java:14)
at
com.webct.platform.coreservice.archive.restore. GenericArchiveRestor
eDao. restoreSection(Gener
icArchiveRestoreDao.java:155)
at
com.webct.platform.coreservice.archive.restore. ArchiveRestoreManage
r. restoreSectionFromUn
marshal(ArchiveResto
reManager.java:64)
at
com.webct.platform.coreservice.archive.ejb.ArchiveServiceImpl. restoreFromFile(Arch
iveServiceImpl.java:130)
at
com.webct.platform.coreservice.archive.ejb. ArchiveService_ncjvx
3_ELOImpl. restoreFromFile(Arch
iveService_ncjvx3_EL
OImpl.java:207)
at
com.webct.platform.coreservice.archive.actions. ProcessRestoreAction
. restoreFile(ProcessR
estoreAction.java:305)
at
com.webct.platform.coreservice.archive.actions. ProcessRestoreAction
$RestoreFileDelegato
r. delegate(ProcessRest
oreAction.java:479)
at
com.webct.platform.coreservice.progressbar.common. AsynchronousMethod$1
. run(AsynchronousMeth
od.java:95)
at
com.webct.platform.framework.scheduler.impl.PooledThreadImpl. run(PooledThreadImpl
.java:152)
]]></log4j:throwable>
</log4j:event>
| |
| Joe Weinstein 2005-09-14, 1:23 pm |
|
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+p
arameter
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.
>
>
> <log4j:event
> logger="com.webct.platform.framework.dataaccess.sql.common. VistaPreparedStateme
nt"
>
> 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. VistaPreparedStateme
nt
> METHOD: executeUpdate
> DB Investigation Log ]]></log4j:message>
> <log4j:throwable><![CDATA[java.sql.SQLException: [BEA][SQLServer JDBC
> Driver]& #91;SQLServer]Select
statements included within a function cannot
> return data to a client.
> at weblogic.jdbc.base.BaseExceptions. createException(Unkn
own Source)
> at weblogic.jdbc.base.BaseExceptions. getException(Unknown
Source)
> at weblogic.jdbc.sqlserver.tds.TDSRequest. processErrorToken(Un
known
> Source)
> at weblogic.jdbc.sqlserver.tds.TDSRequest. processReplyToken(Un
known
> Source)
> at weblogic.jdbc.sqlserver.tds.TDSRPCRequest. processReplyToken(Un
known
> Source)
> at weblogic.jdbc.sqlserver.tds.TDSRequest. processReply(Unknown
Source)
> at
> weblogic.jdbc.sqlserver. SQLServerImplStateme
nt. getNextResultType(Un
known
> Source)
> at weblogic.jdbc.base.BaseStatement. commonTransitionToSt
ate(Unknown
> Source)
> at weblogic.jdbc.base.BaseStatement. postImplExecute(Unkn
own Source)
> at weblogic.jdbc.base. BasePreparedStatemen
t. postImplExecute(Unkn
own
> Source)
> at weblogic.jdbc.base.BaseStatement. commonExecute(Unknow
n Source)
> at weblogic.jdbc.base.BaseStatement. executeUpdateInterna
l(Unknown
> Source)
> at weblogic.jdbc.base. BasePreparedStatemen
t. executeUpdate(Unknow
n
> Source)
> at
> weblogic.jdbc.wrapper.PreparedStatement. executeUpdate(Prepar
edStatement.java:147)
>
> at
> com.webct.platform.framework.dataaccess.sql.common. VistaPreparedStateme
nt. executeUpdate(VistaP
reparedStatement.java:94)
>
> at
> com.webct.platform.framework.dataaccess.sql.common. VistaPreparedStateme
nt. executeUpdate(VistaP
reparedStatement.java:85)
>
> at
> com.webct.platform.coreservice.archive.restore. GenericArchiveRestor
eDao. restorePerson(Generi
cArchiveRestoreDao.java:1195)
>
> at
> com.webct.platform.coreservice.archive.restore. RestorePersonRoutine
. execute(RestorePerso
nRoutine.java:14)
>
> at
> com.webct.platform.coreservice.archive.restore. GenericArchiveRestor
eDao. restoreSection(Gener
icArchiveRestoreDao.java:155)
>
> at
> com.webct.platform.coreservice.archive.restore. ArchiveRestoreManage
r. restoreSectionFromUn
marshal(ArchiveResto
reManager.java:64)
>
> at
> com.webct.platform.coreservice.archive.ejb.ArchiveServiceImpl. restoreFromFile(Arch
iveServiceImpl.java:130)
>
> at
> com.webct.platform.coreservice.archive.ejb. ArchiveService_ncjvx
3_ELOImpl. restoreFromFile(Arch
iveService_ncjvx3_EL
OImpl.java:207)
>
> at
> com.webct.platform.coreservice.archive.actions. ProcessRestoreAction
. restoreFile(ProcessR
estoreAction.java:305)
>
> at
> com.webct.platform.coreservice.archive.actions. ProcessRestoreAction
$RestoreFileDelegato
r. delegate(ProcessRest
oreAction.java:479)
>
> at
> com.webct.platform.coreservice.progressbar.common. AsynchronousMethod$1
. run(AsynchronousMeth
od.java:95)
>
> at
> com.webct.platform.framework.scheduler.impl.PooledThreadImpl. run(PooledThreadImpl
.java:152)
>
> ]]></log4j:throwable>
> </log4j:event>
| |
| Radovan Biciste 2005-09-14, 8:23 pm |
| 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
Joe Weinstein wrote:
>
>
> Radovan Biciste wrote:
>
>
>
> 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+p
arameter
> 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 2005-09-14, 8:23 pm |
| Hello,
It is an issue in SQL 2005. It is suppose to be fixed in the September
preview version.
Thank you,
Radovan
Joe Weinstein wrote:
>
>
> Radovan Biciste wrote:
>
>
>
> 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+p
arameter
> 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.
|
|
|
|
|