How to start javaOBjEX Server? I am getting error like -*ksh: javaOBjEXServer: not found [No such file or directory]*
Is there any file related to this that I missed? thanks, Ashish On Monday, July 27, 2015 at 2:13:42 PM UTC+5:30, Ashish Kopre wrote: > > 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]> 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.
