jdbc driver exeption in windows

John

unread,

Feb 9, 2003, 12:00:11 PM2/9/03

to

I'm using db2 8 for windows 2000 with jdk1.4.1, when using
COM.ibm.db2.jdbc.app.DB2Driver or
COM.ibm.db2.jdbc.net.DB2Driver trying to access data for select * from
table, it said

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0805N
Package
"NULLID.SYSSH200 0X5359534C564C3031" was not found. SQLSTATE=51002

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Un
known Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Un
known Source)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unk
nown Source)
at COM.ibm.db2.jdbc.app.DB2Statement.execute2(Unknown Source)
at COM.ibm.db2.jdbc.app.DB2Statement.executeQuery(Unknown
Source)

Can any help this out?

Thanks

--
John Wu
Toronto

Ian D. Bjorhovde

unread,

Feb 9, 2003, 1:46:38 PM2/9/03

to

John wrote:
> I'm using db2 8 for windows 2000 with jdk1.4.1, when using
> COM.ibm.db2.jdbc.app.DB2Driver or
> COM.ibm.db2.jdbc.net.DB2Driver trying to access data for select * from
> table, it said
>
> COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0805N
> Package
> "NULLID.SYSSH200 0X5359534C564C3031" was not found. SQLSTATE=51002

Try binding the CLI packages against your database from the client
machine. You can do this with the Configuration Assistant. Choose
your database, and then go to "Selected...Bind"

Good luck,

ian

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----

John

unread,

Feb 9, 2003, 10:03:47 PM2/9/03

to

"Ian D. Bjorhovde" <ian...@mobileaudio.com> wrote in message news:<3e46a1aa$1...@corp.newsgroups.com>...

> John wrote:
> > I'm using db2 8 for windows 2000 with jdk1.4.1, when using
> > COM.ibm.db2.jdbc.app.DB2Driver or
> > COM.ibm.db2.jdbc.net.DB2Driver trying to access data for select * from
> > table, it said
> >
> > COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0805N
> > Package
> > "NULLID.SYSSH200 0X5359534C564C3031" was not found. SQLSTATE=51002
>
> Try binding the CLI packages against your database from the client
> machine. You can do this with the Configuration Assistant. Choose
> your database, and then go to "Selected...Bind"
>
> Good luck,
>
>
> ian
>
>

Thanks lots ian.
The further problem is when I tried to run java-code:

connection.prepareStatement(selectsql,ResultSet.TYPE_SCROLL_SENSITIVE
,ResultSet.CONCUR_UPDATABLE );

it said

java.sql.SQLException: [IBM][JDBC Driver] CLI0626E Updatable result
set is
not supported in this version of DB2 JDBC 2.0 driver.
at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throwNotSupportedByDB
2(Unknown Source)
at COM.ibm.db2.jdbc.net.DB2Statement.checkResultSetType(Unknown
Sou
rce)
at COM.ibm.db2.jdbc.net.DB2PreparedStatement.<init>(Unknown
Source)

at COM.ibm.db2.jdbc.net.DB2Connection.prepareStatement(Unknown
Sour
ce)

What db2-driver support this?

Thanks again
--
John
Toronto

Maor71

unread,

Feb 10, 2003, 5:44:38 PM2/10/03

to

Originally posted by John
> "Ian D. Bjorhovde" wrote in message news:news:...

> at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throwNotSupport-

> edByDB
> 2(Unknown Source)
> at
> COM.ibm.db2.jdbc.net.DB2Statement.checkResultSetType(Unknown
> Sou
> rce)

> at COM.ibm.db2.jdbc.net.DB2PreparedStatement.(Unknown

> Source)
>
> at COM.ibm.db2.jdbc.net.DB2Connection.prepareStatement(Unknown
> Sour
> ce)
>
> What db2-driver support this?
>
> Thanks again
> --
> John
> Toronto

are you using JDBC type 2 drivers ?

marcos oliva

--
Posted via http://dbforums.com

John

unread,

Feb 10, 2003, 11:14:30 PM2/10/03

to

Maor71 <membe...@dbforums.com> wrote in message news:<2510111.1...@dbforums.com>...

I've tried type2 COM.ibm.db2.jdbc.app.DB2Driver
and type 3 COM.ibm.db2.jdbc.net.DB2Driver
running in the same machine which installed db2 8 for windows. but the
result is same it seemed these two driver didn't support
preparestatement.

--
John Wu
Toronto

Larry Menard

unread,

Feb 11, 2003, 8:02:59 AM2/11/03

to

Um, just a minor correction... it is updatable result sets that are not
supported... not prepareStatement.

Please see the "Programming in Java" section in the Application
Development Guide.
--
Larry Menard
IBM Workstation Database (DB2) Performance Team
Defender of Geese and of All Things Natural

"John" <joh...@yorku.ca> wrote in message
news:1673c1fd.03021...@posting.google.com...