Hello,
I have create file PEOPLE having three fields/columns ID, FIRSTNAME,
LASTNAME
I have written a program like follow
import java.sql.*;
public class jbaseTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
System.out.println("Inside main method");
try
{
Class.forName("com.jbase.jdbc.driver.JBaseJDBCDriver");
Connection con =
DriverManager.getConnection("jdbc:jbase:thin:@192.168.1.22:20002:PLAY","jbaseuser","jbaseuser");
Statement stmnt = con.createStatement();
ResultSet rs = stmnt.executeQuery("SELECT FIRSTNAME FROM PEOPLE WHERE
FIRSTNAME = 'ASHISH'");
int i = 0;
while(rs.next())
{
//System.out.println(rs.getString("FIRSTNAME"));
i++;
}
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
System.out.println("Complete Program Execution");
}
}
But I got following error
java.sql.SQLException: SQLSTATE IE000 80045024?SELECT FIRSTNAME FROM PEOPLE
WHERE FIRSTNAME = 'ASHISH'?Base table not found while compiling 'SELECT
FIRSTNAME FROM PEOPLE WHERE FIRSTNAME = 'ASHISH''
at com.jbase.jdbc.JBaseJDBCSocketConnection.getResponse(Unknown Source)
at com.jbase.jdbc.JBaseJDBCSocketConnection.sendRequest(Unknown Source)
at com.jbase.jdbc.JBaseJDBCSocketConnection.compile(Unknown Source)
at com.jbase.jdbc.JBaseJDBCSocketConnection.execute(Unknown Source)
at com.jbase.jdbc.JBaseJDBCSocketStatement.executeQuery(Unknown Source)
at jbaseTest.main(jbaseTest.java:13)
I also use query like "SQLSELECT * FROM PEOPLE"
but in this case I got error like "NOT A QUERY".
Please help me to overcome this.
thanks,
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google Groups
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
