Can you create an example program that goes wrong?

d.

2008/5/7 [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
>
>  Hi,
>
>  I'm trying to insert a simple data set into my sqlite database. I
>  tried using a SQLite Database Browser program to execute the command,
>  and it works fine there. But when I tried to use the SQLiteJDBC, it
>  gives me the following errors.
>
>  I tried both native and nested version, on windows and mac platform
>  and all give me the same error.
>
>  Help??
>
>  The specific command is
>          "INSERT INTO databases VALUES ('/Users/*****/
>  withNucleus.sqlite','1H',124.0,3);"
>
>  and the table is created by
>               "CREATE TABLE `databases` ("
>         + "  `filename` varchar(255) default NULL,"
>         + "  `nucleus` varchar(30) default NULL,"
>         + "  `B0_field` float(10,2) NOT NULL default '0.00',"
>         + "  `pulseq_id` int(10)  NOT NULL "
>         + "  )"
>
>
>
>
>
>  when using statment.executeBatch();
>
>  java.lang.NullPointerException
>         at org.sqlite.NestedDB.prepare(NestedDB.java:118)
>         at org.sqlite.DB.prepare(DB.java:117)
>         at org.sqlite.Stmt.executeBatch(Stmt.java:122)
>
>
>
>
>
>
>
>  and when using statment.executeUpdate(string);
>
>  java.sql.SQLException: out of memory
>         at org.sqlite.DB.throwex(DB.java:291)
>         at org.sqlite.NestedDB.prepare(NestedDB.java:124)
>         at org.sqlite.DB.prepare(DB.java:117)
>         at org.sqlite.Stmt.executeUpdate(Stmt.java:96)
>
>  >
>

--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---

Reply via email to