468,257 Members | 1,469 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

DB2 connectivity

Hi
i am new to DB2 and i am working on a java application on windows ,backend for this is DB2,

i am trying to access the db2 server which is on Mainframes from the java application on Windows...,i don't have db2 client installed on windows..

the jdbc driver used for the connectivity is jdbc type 4 .

at present i am using the following connection string in the application:

"jdbc:db2://Hostname:portnumber/DatabaseName","UID","PWD"

i think i am able to cnnect to the DB2 database
using the following condition i am checking the same:

if(conn!=null) then
System.out.prinltn("Connection successful");

where conn Connection object

after this i have tried to access the a table in the database (User has access to all the tables in the database)
String query = "select * from schema.emp");
resultSet = st1.executeQuery(query);

i am getting the folowing error while accessing the table:
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -551, SQLSTATE: null, SQLERRMC: null

-551 is a privilege error but the User has access to all the tables in the database.
let me know the solution to this if any of u knows or let me know if any other inforamtion or clarification needed from my side...


Thanks in Advance
Sujatha N
Jul 30 '07 #1
0 1019

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Axel Dachtler | last post: by
1 post views Thread by Darren McDowell via .NET 247 | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.