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