Hi Daniel,
Thanks for reply. Problem is in jShell its running properly giving result
also as I want but in JDBC Program I am using query like,
SELECT FIRSTNAME FROM PEOPLE WHERE FIRSTNAME = 'ASHISH'
but it throwing error
java.sql.SQLException: SQLSTATE JB000 80045024�SELECT FIRSTNAME FROM
PEOPLE�Base table not found
at com.jbase.jdbc.JBaseJDBCSocketConnection.getResponse(Unknown
Source)
at com.jbase.jdbc.JBaseJDBCSocketConnection.sendRequest(Unknown
Source)
at com.jbase.jdbc.JBaseJDBCSocketConnection.precompile(Unknown
Source)
at com.jbase.jdbc.JBaseJDBCPreparedStatement.<init>(Unknown Source)
at
com.jbase.jdbc.JBaseJDBCSocketConnection.prepareStatement(Unknown Source)
at JDBCTest.main(JDBCTest.java:14)
I have also started jbase-agent.
Please help me to solve this issue.
Thanks,
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.
