[sqlitejdbc] NullPointerException and out of memory error during INSERT

[[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]
-~----------~----~----~----~------~----~------~--~---