Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error SQL1031N when using JDBC

131 views
Skip to first unread message

fo...@my-deja.com

unread,
Nov 27, 2000, 3:00:00 AM11/27/00
to
We have been using JDBC to connect to DB2 v6.1 on AIX. Everything
was working fine until we had a database crash. Now we continually
receive the following when trying to connect via JDBC.

Got NO connection
COM.ibm.db2.jdbc.net.DB2Exception: [IBM][CLI Driver] SQL1031N The
database directory cannot be found on the indicated file system.
SQLSTATE=58031
at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throw_SQLException
(SQLExceptionGenerator.java:142)
at
COM.ibm.db2.jdbc.net.SQLExceptionGenerator.check_return_code
(SQLExceptionGenerator.java:325)
at
COM.ibm.db2.jdbc.net.DB2Connection.SQLConnect(DB2Connection.java:280)
at
COM.ibm.db2.jdbc.net.DB2Connection.create(DB2Connection.java:233)
at
COM.ibm.db2.jdbc.net.DB2Connection.<init>(DB2Connection.java:161)
at COM.ibm.db2.jdbc.net.DB2Driver.connect(DB2Driver.java:191)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:106)
at recode.deletor1.Connector(deletor1.java:22)
at recode.deletor1.main(deletor1.java:45)


Sent via Deja.com http://www.deja.com/
Before you buy.

bernd hohmann

unread,
Nov 27, 2000, 8:47:54 PM11/27/00
to
On Mon, 27 Nov 2000 23:34:25 GMT, fo...@my-deja.com wrote:

> We have been using JDBC to connect to DB2 v6.1 on AIX. Everything
> was working fine until we had a database crash. Now we continually
> receive the following when trying to connect via JDBC.
>

> COM.ibm.db2.jdbc.net.DB2Exception: [IBM][CLI Driver] SQL1031N

can you access the database via the command-prompt ?

you may try to uncatalog and then catalog the database again. the
'catalog databse' command has a path parameter which specifies the
directory where the database resides.

bernd

--
the DB2 faq: http://www.harddiskcafe.de/db2faq/index.html
job: java, os/2, nt, internet ? http://www.conacom.de

0 new messages