Hi list, I wanted to test SQLite to use it with WebObjects and almost make it. I can connect and I can query, but I can't insert. Actually what I found out was that all SQL statements go through executeQuery method which expects a Result Set otherwise will throw a SQLException. I think I can tweak the code (Stmt.java:112) to just return an empty set. I can then validate in WebObjects for an empty Collection or List or NSArray and in that way find that my INSERT went ok.
I still don't find (I haven't done a deep plunge into the classes) where I could modify the code to make SQLite execute an executeUpdate method instead of the executeQuery. The first doesn't expect a Result Set for what I understand. Any help would be appreciated, -Carlos _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
