Sorry i am pointing to a different database ...
Thanks for your reply...
On Jul 8, 4:23 am, "David Crawshaw" <[EMAIL PROTECTED]> wrote:
> 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]
-~----------~----~----~----~------~----~------~--~---
