Hi,
I have a problem -->I get a sql statement generates a rowcount error on using
executeQuery and a select. The query executes fine in SQLStudio and even as a
Standalone test JDBC program. But it generates an error as a part of my Application.
See the relevant part of the JDBC trace below. Any assistance will be appreciated.
Thanks
-Ajit
(Note the jdbc driver is sapdb-jdbc-bin-7.3.00.28a.jar)
Note: There is a bug(?) in the this driver where CallableStatement.setString() cannot
be called passing a null in SQLMODE Oracle.It Generates a null pointer exception.
JDBCtrace-->
package com.sap.dbtech.jdbc, null, null, null on Java 1.3.0_02
new Connection 'jdbc:sapdb://172.25.186.171/mmp'
using com.sap.dbtech.rte.comm.SocketComm@54f9f1 on
Socket[addr=blrkec21149.ad.infosys.com/172.25.186.171,port=7210,localport=2769]
=> com.sap.dbtech.jdbc.ConnectionSapDB@6576d4
[EMAIL PROTECTED] (2)
[EMAIL PROTECTED] ()
=> com.sap.dbtech.jdbc.StatementSapDB@12b1a1
[EMAIL PROTECTED] ( SELECT * FROM MOVIES ORDER
BY LANGUAGE DESC , POPULARITY DESC)
<-!
com.sap.dbtech.jdbc.exceptions.SQLExceptionSapDB: SQL Statement generates a row count
at com.sap.dbtech.jdbc.StatementSapDB.executeQuery(StatementSapDB.java:311)
at com.sap.dbtech.jdbc.trace.Statement.executeQuery(Statement.java:67)
at
com.onmobile.apps.movies.content.MovieDBManager.getMovies_Theatre_Range(MovieDBManager.java:210)
at
com.onmobile.apps.movies.content.MovieDBManager.getAllMovies(MovieDBManager.java:276)
at
com.onmobile.apps.movies.voice.SOMovieInitial.onEntry(SOMovieInitial.java:135)
at nuance.so.SODialog.invoke(SODialog.java:1698)
at nuance.so.SODialogManager$State.run(SODialogManager.java:1286)
at nuance.so.SODialogManager.invoke(SODialogManager.java:757)
at
com.onmobile.apps.commonx.speech_general.SoOnvAppManager.invoke(SoOnvAppManager.java:52)
at
com.onmobile.apps.movies.voice.SOMovieManager.invoke(SOMovieManager.java:160)
at com.onmobile.platform.voice.cm.OnvSCThread.runService(OnvSCThread.java:1697)
at com.onmobile.platform.voice.cm.OnvSCThread.run(OnvSCThread.java:1863)
at java.lang.Thread.run(Thread.java:484)
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@7918f0
[EMAIL PROTECTED] ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@546dbc
[EMAIL PROTECTED] ()
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
