Your example runs for me here without error. I suspect you are running
it on a database that already contains the table named blah, with a
slightly different primary key column type.
d.
2008/7/7 Ramesh <[EMAIL PROTECTED]>:
>
> My code goes like this:
> //database connection
> statement.executeUpdate(" CREATE TABLE if not exists h041 ( h041001
> integer PRIMARY KEY , h041002 varchar(10)," +
> "h041003 date, h041004
> integer, h041005 numeric(20,2), h041006
> numeric(20,2), h041007 boolean, h041008 varchar(15), h041009
> timestamp , h041010 varchar(250)," +
> "h041011 date, h041012 text,
> h041013 smallint DEFAULT 0,
> h041014 smallint, h041015 boolean DEFAULT false, h041022
> varchar(30), h041023 boolean DEFAULT true," +
> "h041024 timestamp, h041025
> varchar(60), h041016 integer,
> h041017 integer,h041018 integer, h041019 integer, h041020 integer,
> h041021 integer," +
> "h041026 varchar(10), h041027
> date, h041028 numeric(20,2),
> h041029 integer DEFAULT -1," +
> "h041030 integer DEFAULT -1 )
> ");
>
>
> statement.executeUpdate("
> insert into h041 ( h041003 , h041013 , h041004 , h041014 , h041002 ,
> h041005 ,h041012 , h041010 , h041016 ,h041017 ) values
> ( '01/01/2008','insurance','test test test test test test test test
> test ','cash','1234','100' , 'test' , 'test' , '00001' , '00ADJ' )");
>
>
>
>
> it is giving me the error
> java.sql.SQLException: h041.h041001 may not be NULL
> at org.sqlite.DB.execute(DB.java:275)
> at org.sqlite.DB.executeUpdate(DB.java:281)
> at org.sqlite.Stmt.executeUpdate(Stmt.java:103)
>
>
>
>
> But when i insert through command line it's not throwing me an error
>
> For your information i am using v052 (native)
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
