Thanks Joe. It might be helpful to get the corrected example usage onto the web page.
-Marc On Oct 25, 1:45 pm, Joe Wilson <[EMAIL PROTECTED]> wrote: > --- Marc Siegel <[EMAIL PROTECTED]> wrote: > > > I don't think that the usage example for SQLiteJDBC (at > >http://www.zentus.com/sqlitejdbc/) is correct. > > > Specifically, the insert syntax should be changed from: > > stat.executeUpdate("create table people (name, occupation);"); > > To: > > stat.executeUpdate("create table people values(name, occupation);"); > > > The current syntax fails for me in the sqlite3 commandline client as > > well (3.1.3 on OS X). The proposed syntax works, and fits what is > > described in the SQLite docs: > > http://www.sqlite.org/lang_insert.html > > > Thanks, > > -Marc > > I think you copied and pasted the create line instead of the insert line. > The CREATE statement is correct in the example. > > But yes, the JDBC example on the home page appears to have a few errors. > Here's a corrected version: > > import java.sql.*; > public class Test { > public static void main(String[] args) { > try { > Class.forName("org.sqlite.JDBC"); > Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db"); > Statement stat = conn.createStatement(); > stat.executeUpdate("create table people (name, occupation);"); > stat.executeUpdate("insert into people values ('Gandhi', 'politics');"); > stat.executeUpdate("insert into people values ('Turing', > 'computers');"); > stat.executeUpdate("insert into people values ('Wittgenstein', > 'smartypants');"); > ResultSet rs = stat.executeQuery("select * from people;"); > while (rs.next()) { > System.out.println("name = " + rs.getString("name")); > System.out.println("occupation = " + rs.getString("occupation")); > } > rs.close(); > conn.close(); > } catch (Exception e) { System.err.println(e); } > } > > } > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection > aroundhttp://mail.yahoo.com --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
