|
| i5/OS IBM Data Server for JDBC and SQLJ driver error |
 |
Fri, 21 Mar 2008 12:08:46 EDT |
Hi<br />
<br />
I use a IBM Data Studio and want to use this specific JDBC driver for my
project, couse 'AS/400 toolbox for Java' driver doesn't support sql stored
procedures debgging. So in connections->new connection i choose 'IBM Data
Server for JDBC and SQLJ' driver, set all parameters and finally connection test
is succesfull.<br />
<br />
But when i want to deploy any stored procedure to server i catch an
exception:<br />
com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002,
SQLERRMC=NULLID.SYSSH200;<br />
<br />
I'm not familiar with java. I found somewhere that NULLID.SYSSH200 could be
caused if the user does not have the appropriate authority to create some
packages, but when i'm connecting as a QSECOFR I handle the same error :/<br
/>
<br />
I post this message on IBM Data Studio forum also, they adviced me that i have
to bind the JDBC packages to the server using the DB2Binder utility, when i'm
using the Universal Driver for the first time, but I don't know how to do
it!<br />
<br />
any suggestion?<br />
<br />
thanks in advance<br />
|
| Post Reply
|
|
|
|
|
|
|
|
|
|