ChannelDB2

Error query db2 BLU with java

Hello:

I have a java application to query db2 blu but I get the following error:

com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-955, SQLSTATE=57011, SQLERRMC=3

The java connection and code is:

String url;

Connection con = null;
Statement stmt;
ResultSet rs = null;

url = "jdbc:db2://localhost:50001/testdb:user=userdb2;password=4&DDSG%;specialRegisters=CURRENT QUERY ACCELERATION=ELIGIBLE;";

try {
      Class.forName("com.ibm.db2.jcc.DB2Driver");

      con = DriverManager.getConnection(url);

      stmt = con.createStatement();

      rs = stmt.executeQuery("SELECT * FROM tablename");

}

Connection to db2 is OK but the error occure in this line: 

rs = stmt.executeQuery("SELECT * FROM tablename");

Could you help me please?

Regards.

Views: 1221

▶ Reply to This

Replies to This Discussion

Permalink Reply by Joachim Müller on May 13, 2014 at 2:45am

Hi Emmanuel,

try this:

String query = "SELECT COUNT(*) FROM SYSCAT.TABLES";

rs = stmt.executeQuery(query);

Best regards

Joachim

Permalink Reply by Emmanuel Garcia on May 13, 2014 at 3:03am

Thanks Joachim:

Execution is OK but fails if I do it for my database with column organized tables.

Permalink Reply by Joachim Müller on May 13, 2014 at 3:41am

Hi Emmanuel,

you have not enough memory. Please look at db2 '? SQL0955' for further Information.

Best regards

Joachim

Permalink Reply by Emmanuel Garcia on May 13, 2014 at 3:50am

I've changed SHEAPTHRES_SHR but the error occure when i execute query from java or data studio. If I execute query from command line in the datbase server, it is ok.

Regards.

Permalink Reply by Joachim Müller on May 13, 2014 at 4:04am

Please run "db2 autoconfigure apply none" for a suggestion what DB2 tries to set.

Best regards

Joachim

RSS

Featured Downloads

Download DB2

More downloads


FREE Book: Getting started with DB2

Try BLU Acceleration on Cloud

www.BLUforCloud.com

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service