Help me OOo Base Connection to Java Error!!!
Driver = org.hsqldb.jdbcDriver
Url = D:\Myjava\Java\Notebbook\build\classes\notebook
user = sa
pass =
table = login
Quote:
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
class main{
public static void main(String[] args){
try{
Statement stm;
Connection con = null;
ResultSet rs;
String db_file_name="D:\\Myjava\\Java\\Notebbook\\build\\classes\\notebook";
Class.forName("org.hsqldb.jdbcDriver");
System.out.println("load Driver OK");
con = DriverManager.getConnection("jdbc:hsqldb:file:"+db_file_name+, "sa", "");
System.out.println(con.toString());
stm = con.createStatement();
System.out.println("On Con");
System.out.println(stm.toString());
rs= stm.executeQuery("SELECT * FROM login");
System.out.println(rs.toString());
}
catch (SQLException ex)
{
Logger.getLogger(main.class.getName()).log(Level.SEVERE, null, ex);
System.err.println(ex);
}
catch (ClassNotFoundException ex)
{
Logger.getLogger(main.class.getName()).log(Level.SEVERE, null, ex);
System.err.println(ex);
}
catch (Exception ex)
{
Logger.getLogger(main.class.getName()).log(Level.SEVERE, null, ex);
ex.printStackTrace();
System.err.println(ex);
}
}
}
Compiler Run
load Driver OK
org.hsqldb.jdbc.JDBCConnection@1358f03
On Con
org.hsqldb.jdbc.JDBCStatement@747fa2
SEVERE: null
java.sql.SQLException: user lacks privilege or object not found: LOGIN
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 main.main(main.java:22)
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: LOGIN
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.SchemaManager.getTable(Unknown Source)
at org.hsqldb.ParserDQL.readTableName(Unknown Source)
at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 3 more
BUILD SUCCESSFUL (total time: 3 seconds)
ผมลองทำเองมา 4 วัน แล้ว ครับ ตอนนี้ไม่ไหวจริงๆ T^T
