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]> 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] > 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. > -- -- 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.
