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