After Changing MSSQL 2005 Driver From Version 1.1 to 2.0 DynamicSQL.executeQuery() Fails With A "SQLServerException: The statement did not return a result set error" (Doc ID 1059718.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle Business Process Management Suite - Version 5.7.3 to 10.3.1
Information in this document applies to any platform.
***Checked for relevance on 25-Sep-2012***

Symptoms

After changing MSSQL 2005 JDBC Driver from version 1.1 to 2.0 the execution of DynamicSQL.executeQuery() method fails.

The code being executed is:

query2 = "INSERT INTO [tst] ([desc]) VALUES ( ? ); SELECT SCOPE_IDENTITY() as id;"
params2[] = "Test-"
result4 = executeQuery(DynamicSQL, sentence : query2, implname : "db", inParameters : params2)


The exception thrown is:

The statement did not return a result set.

com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:392)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)
at fuego.jdbc.FaultTolerantPreparedStatement.executeQuery(FaultTolerantPreparedStatement.java:584)
at fuegoblock.sql.DynamicSQL.executeQuery(DynamicSQL.java:342)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at fuego.lang.JavaClass.invokeMethod(JavaClass.java:1477)
at fuego.lang.ObjectTypeDescription.invokeMethod(ObjectTypeDescription.java:1247)
at fuego.lang.MethodTypeDescription.invoke(MethodTypeDescription.java:1133)
at fuego.compiler.Invoke$MethodCall.run(Invoke.java:1580)
at fuego.compiler.Invoke.runCall(Invoke.java:710)
at fuego.compiler.Invoke.run(Invoke.java:694)
at fuego.compiler.Node.value(Node.java:2279)
at fuego.compiler.Node.value(Node.java:2313)
at fuego.compiler.Assignment.run(Assignment.java:308)
at fuego.compiler.Block.run(Block.java:317)
at fuego.compiler.DoBlock.run(DoBlock.java:676)
at fuego.compiler.Method.run(Method.java:1223)
at fuego.compiler.Method$Adaptor.run(Method.java:1894)
at fuego.compiler.FuegoInvokeable.invoke(FuegoInvokeable.java:426)
at fuego.compiler.CodeRunner$DebuggerRunnable.runMethod(CodeRunner.java:756)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at fuego.lang.JavaClass.invokeMethod(JavaClass.java:1477)
at fuego.lang.JavaObject.invoke(JavaObject.java:185)
at fuego.component.Message.process(Message.java:585)
at fuego.component.ExecutionThread.processMessage(ExecutionThread.java:765)
at fuego.component.ExecutionThread.processBatch(ExecutionThread.java:740)
at fuego.component.ExecutionThread.doProcessBatch(ExecutionThread.java:139)
at fuego.component.ExecutionThread.doProcessBatch(ExecutionThread.java:131)
at fuego.compiler.DebuggerPrincipal.processBatch(DebuggerPrincipal.java:62)
at fuego.component.ExecutionThread.work(ExecutionThread.java:824)
at fuego.component.ExecutionThread.run(ExecutionThread.java:396)

Changes

Updated MSSQL 2005 JDBC driver from version 1.1 to 2.0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms