I have attached a screen shot for this error.... On Sunday, July 26, 2015 at 1:15:50 AM UTC+5:30, Daniel Klein wrote: > > SQLSELECT should have worked. > > Try running it in a jShell. If you can't get it to work there then it is > never going to work in Java code. > > Daniel > > On Fri, Jul 24, 2015 at 8:59 AM, Ashish Kopre < > [email protected] <javascript:>> wrote: > >> 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] <javascript:> >> To unsubscribe, send email to [email protected] <javascript:> >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > >
-- -- 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.
