COM.ibm.db2.jdbc.appDB2Exception

COM.ibm.db2.jdbc.appDB2Exception

Post by Patric O'Hooliga » Sat, 04 Nov 2000 23:41:53



Hi,

I have tried to make my CMP beans to run and actually fill a DB2
Personal Database. There is something which raises an exception in the
remote interface.
The whole exception is:

    ERROR: Exception thrown by method.
ERROR: Exception is: java.rmi.ServerException: RemoteException occurred
in server thread; nested exception is:
 com.ibm.ejs.persistence.EJSPersistenceException:
COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0198N
The statement string of the PREPARE or EXECUTE IMMEDIATE statement is
blank or empty.  SQLSTATE=42617; nested exception is:
 COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0198N
The statement string of the PREPARE or EXECUTE IMMEDIATE statement is
blank or empty.  SQLSTATE=42617

I am using VAJ for programming. Anyone has any idea where to start
looking a remedy? I am not a great connoisseur of databases anyway.

Thanks P.O

 
 
 

COM.ibm.db2.jdbc.appDB2Exception

Post by Rolf Garsk » Mon, 06 Nov 2000 04:00:00


Hello Patric,

without an example of your code it is difficult to help you, but
the error message is obvious. It seems you are trying to execute a prepared
Statement with a null string. Instead you should the using a string with an
SQL command that tells the DB2 database what you want to do.

:>Hi,
:>
:>I have tried to make my CMP beans to run and actually fill a DB2
:>Personal Database. There is something which raises an exception in the
:>remote interface.
:>The whole exception is:
:>
:>    ERROR: Exception thrown by method.
:>ERROR: Exception is: java.rmi.ServerException: RemoteException occurred
:>in server thread; nested exception is:
:> com.ibm.ejs.persistence.EJSPersistenceException:
:>COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0198N
:>The statement string of the PREPARE or EXECUTE IMMEDIATE statement is
:>blank or empty.  SQLSTATE=42617; nested exception is:
:> COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0198N
:>The statement string of the PREPARE or EXECUTE IMMEDIATE statement is
:>blank or empty.  SQLSTATE=42617
:>
:>I am using VAJ for programming. Anyone has any idea where to start
:>looking a remedy? I am not a great connoisseur of databases anyway.
:>
:>Thanks P.O
:>

_____________________________________________________________________________
Phone: +49 211 6914777  Mobile Phone: +49 172 2117822          Fax: +49 211 6914778