I am trying to use hsqldb in jboss-4.0.5.GA .I tried the following small jdbc
code .
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
class JDBC_test
{
public static void main(String args[])
{
Connection conn=null;
Statement select=null;
try
{
Class.forName("org.hsqldb.jdbcDriver");
System.out.println("Driver loaded...");
}
catch(Exception e)
{
System.out.println("Failed to load hsql driver.");
return;
}
try
{
conn =
DriverManager.getConnection("jdbc:hsqldb:file:db/anu","sa","");
System.out.println("connected to hsql..");
select = conn.createStatement();
System.out.println("after create statement..");
}
catch(Exception e) {System.out.println("create statement
failed");}
try
{
ResultSet result = select.executeQuery("SELECT custid,firstname
FROM customer_details");
System.out.println("Got results:");
while (result.next())
{ // process results one row at a time
int key = result.getInt(1);
String val = result.getString(2);
System.out.println("key = " + key);
System.out.println("val = " + val);
}
} catch (Exception e) {
e.printStackTrace();}
finally
{
if(conn!=null)
{
try { conn.close(); }
catch(Exception e){e.printStackTrace();}
}
}
}
}
I have a table customer_details created with few columns in the stand alone
mode.
But I am getting the following error while running the code
Driver loaded...
connected to hsql..
after create statement..
java.sql.SQLException: Table not found in statement [SELECT custid,firstname FRO
M customer_details]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
at JDBC_test.main(JDBC_test.java:36)
Can anyone help me out with this error?
thanks and regards,
java_dev.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4099965#4099965
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4099965
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
