} catch(ClassNotFoundException e) { e.printStackTrace(); System.err.println("Could not load DB2 driver \n"); System.err.println(e.getMessage()); System.exit(1); } try { String u="jdbc:db2://localhost:50000/EXAMPLE1"; //Connect to a database conn = DriverManager.getConnection(u,"gururaj","sdmcet"); // check on URl try with blank or google it // we connect to remote server. i am not sure abt local connection System.out.println("Connected"); String query="select * from example1.sample"; DataRequest = conn.createStatement();
run-main: LOADED DB2 DRIVER Connected com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: EXAMPLE1.SAMPLE SQL Exception: at com.ibm.db2.jcc.c.fg.e(fg.java:1596) at com.ibm.db2.jcc.c.fg.a(fg.java:1206) at com.ibm.db2.jcc.b.gb.g(gb.java:140) at com.ibm.db2.jcc.b.gb.a(gb.java:39) at com.ibm.db2.jcc.b.w.a(w.java:34) at com.ibm.db2.jcc.b.vb.g(vb.java:139) at com.ibm.db2.jcc.c.fg.n(fg.java:1177) at com.ibm.db2.jcc.c.fg.a(fg.java:1832) at com.ibm.db2.jcc.c.fg.a(fg.java:473) at com.ibm.db2.jcc.c.fg.executeQuery(fg.java:457) at connect.getConnection(connect.java:61) at connect.main(connect.java:82) DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: EXAMPLE1.SAMPLE BUILD SUCCESSFUL (total time: 1 second)