InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

The ";" isn't part of InstantDB's SQL dialect. It appears in ScriptTool
files to tell ScriptTool that this is the end of the SQL statement.
ScriptTool strips off the ";" before sending the SQL to InstantDB.

Regards

Peter Hearty
Lutris Technologies (UK)
----- Original Message -----
From: <Exceptionraised@aol.com>
To: <instantdb@enhydra.org>
Sent: Sunday, August 27, 2000 1:57 AM
Subject: InstantDB: Don't understand SQL after: ";"


> This topic was brought up 17 May 2000 but I'm not certain why there is a
> problem in this case.
>
> (I'm new to both SQL and JDBC and have been fooling around with InstantDB
> 3.20 beta 1 with MRJ 2.2.2/MacOS 9.0.4 with one of the tutorials from Java
> Developer Connection. Please forgive me if this has an obvious solution.)
>
> When I make all the appropriate changes to CreateJoltData.java (*.prp
file,
> JDBC driver), compile and run the CreateJoltData program, I get the
following
> error:
>
> problems with SQL sent to jdbc:idb:cafejolt.prp: create table JoltData
> (programmer varchar (32), day varchar (3), cups integer);
>  Don't understand SQL after: ";"
>  Expected: "UNIQUE" found: ";"
>
> If I take out all of the ";" from all the statements in the source code
(see
> below), it compiles and runs perfectly. This also happens when reading
> examples that have a prepared *.sql file; if I take out the ";", then
> everything runs okay...otherwise I get a single or multiple errors such as
> the one above.
>
> This doesn't make any sense to me based on what I've read. Does someone
have
> an idea as to what might be wrong? The prp file is the same as sample.prp
> with the name modified.
>
> Here is the offending CreateJoltData.java file:
>
> import java.sql.*;  file://import all the JDBC classes
>
> public class CreateJoltData {
>
>     static String[] SQL = {
>         "create table JoltData ("+
>             "programmer varchar (32), "+
>             "day varchar (3), "+
>             "cups integer);",
>         "insert into JoltData values ('Gilbert', 'Mon', 1);",
>         "insert into JoltData values ('Wally', 'Mon', 2);",
>         "insert into JoltData values ('Edgar', 'Tue', 8);",
>         "insert into JoltData values ('Wally', 'Tue', 2);",
>         "insert into JoltData values ('Eugene', 'Tue', 3);",
>         "insert into JoltData values ('Josephine', 'Wed', 2);",
>         "insert into JoltData values ('Eugene', 'Thu', 3);",
>         "insert into JoltData values ('Gilbert', 'Thu', 1);",
>         "insert into JoltData values ('Clarence', 'Fri', 9);",
>         "insert into JoltData values ('Edgar', 'Fri', 3);",
>         "insert into JoltData values ('Josephine', 'Fri', 4);",
>     };
>
>     public static void main(String[] args) {
>         String URL = "jdbc:idb:cafejolt.prp";
>         String username = "";
>         String password = "";
>
>         try {
>             Class.forName("org.enhydra.instantdb.jdbc.idbDriver");
>         } catch (Exception e) {
>             System.out.println("Failed to load instantDB JDBC driver.");
>             return;
>         }
>
>         Statement stmt = null;
>         Connection con=null;
>         try {
>             con = DriverManager.getConnection (
>                 URL,
>                 username,
>                 password);
>             stmt = con.createStatement();
>         } catch (Exception e) {
>             System.err.println("problems connecting to " + URL);
>         }
>
>         try {
>             for (int i = 0; i < SQL.length; i ++) {
>                 stmt.execute( SQL[ i ] );
>             }
>             con.close();
>         } catch (Exception e) {
>             System.err.println("problems with SQL sent to " + URL +
>                 ": "+e.getMessage());
>         }
>
>     }
> }
>
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.