- This topic has 5 replies, 2 voices, and was last updated 16 years, 4 months ago by
.
-
Posts
-
I’m facing on issue with DBTools to get the table columns… I’m receiving one error that told me the problem is in the JDBC driver, although we decompile the IBM driver and did some tests. And with tests we could see that the stored procedure are there and responding, but the catalog always came as empty. The most interesting is that I can get connected, do selects, see the datas although when I’do have use the reverse engenering it don’t simple work, and if I do the entitys and DAO without the DBTools, I can’t get connected as well.
My app server is JBOSS 4.2.2 and the Data Source is created as usual.
The DB2 version is 8.1.
I dont know where look for answers anymore, because on IBM site, they don’t mention about JDBC type 4 issues on 8.1 version.
Someone can help me ?
Thanks in advance.Since the error suggests a driver problem, I guess you can try using a different build version of the driver that your already using.
Can you paste the error message here for me.
Here is the error message:
An internal error occurred during: “Generating Artifacts”.
Could not get list of tables from database. Probably a JDBC driver problem.
Configured schema:PMESP
Configured catalog:null
Available schemas:
<SQLException while getting schemas>
Available catalogs:And I’m using the latest driver provide from IBM, I did the download again today and re-tested.
We based our DB tools on the JDBC specification, and if the driver is returning an empty list for the schemas there has got to be something wrong with it, so when that information gets back to the DB tools it has the wrong information.
Hi gyus,
I’d have resolved the issue!
I leave the link here for who need as well. The issue was some PTFs missing on DB2 into iZ series!
Here is the links :
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.apdv.java.doc/doc/t0024156.html
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.apdv.java.doc/doc/r0023708.html
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.apdv.java.doc/doc/rjvxindt.htmlThanks
