File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes the problem of DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "the problem of DB2" Watch "the problem of DB2" New topic
Author

the problem of DB2

Porky Liu
Greenhorn

Joined: Jan 30, 2002
Posts: 22
Now one Java class is expected to access DB2 database through JDBC. And when I retrieve the table list, there is error existed:
SYSIBM:CLI:-954,SQLSTATE=38553
It seems related with the attribute of APPLHEAPSIZE, when it belows some degree, such as 20(I think it's related with the size of your table space), you can see the above error, but if updating it bigger, the error will disappear
So what's the key of the problem?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

IBM says(not very descriptive!):
SQLSTATE 38553: A routine in a system schema has terminated with an error.
I'm having trouble understanding your problem. It would me if you could post the code throwing the exception ( identifying the problem line and including any other relevant lines of code ).
Jamie
Porky Liu
Greenhorn

Joined: Jan 30, 2002
Posts: 22
I don't think it's related code itself,and the same one just like this:
try{
rs=dmd.getTables(null,schemaName,null);
}
catch(SQLException se){
........
}
By the way, your signature is very cool!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: the problem of DB2