My question is in the code of java the links qith the table is correct but the call to the database is not correct. The code is:
String url = "jdbc:jdbcprogress:T:localhost:4000:\\Dlc\\sports.db";
Connection con;
String query = "select Item.Item-Num " +
"from Item";
Statement stmt;
try {
Class.forName ( "com.progress.sql.jdbc.JdbcProgressDriver" );
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
con = DriverManager.getConnection(url, "sysprogress", "s");
stmt = con.createStatement( );
//the error is this
ResultSet rs = stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
}
catch{}
All is correct before the line ResultSet rs = stmt.executeQuery(query); the java error is the table or column is not exist but this exist. The conexion is well. Tell me please what is the error and that library of progress i have agregate to code.
Thanks for yur answer.
String url = "jdbc:jdbcprogress:T:localhost:4000:\\Dlc\\sports.db";
Connection con;
String query = "select Item.Item-Num " +
"from Item";
Statement stmt;
try {
Class.forName ( "com.progress.sql.jdbc.JdbcProgressDriver" );
} catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
con = DriverManager.getConnection(url, "sysprogress", "s");
stmt = con.createStatement( );
//the error is this
ResultSet rs = stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
}
catch{}
All is correct before the line ResultSet rs = stmt.executeQuery(query); the java error is the table or column is not exist but this exist. The conexion is well. Tell me please what is the error and that library of progress i have agregate to code.
Thanks for yur answer.