Hi Michele,
2013/4/30 <[email protected]> > Hi all > > I have problems inserting a record into a SQLite database. This works: > > create().insertInto(PROJECT) > .set(PROJECT.CODE, obj.getCode()) > .set(PROJECT.COMPANY, obj.getCompany()) > .set(PROJECT.NAME, obj.getName()) > .execute(); > > However, If I do something like the following, I get a null pointer > exception (I get the same exception also for other queries...): > > ProjectRecord record = create().newRecord(PROJECT); > record.setCode(obj.getCode()); > record.setCompany(obj.getCompany()); > record.setName(obj.getName()); > record.insert(); > > java.lang.NullPointerException > at org.sqlite.PrepStmt.<init>(PrepStmt.java:42) > at org.sqlite.Conn.prepareStatement(Conn.java:404) > at org.sqlite.Conn.prepareStatement(Conn.java:399) > at org.sqlite.Conn.prepareStatement(Conn.java:383) > at > org.jooq.impl.ProviderEnabledConnection.prepareStatement(ProviderEnabledConnection.java:103) > at > org.jooq.impl.SettingsEnabledConnection.prepareStatement(SettingsEnabledConnection.java:71) > at > org.jooq.impl.ProviderEnabledConnection.prepareStatement(ProviderEnabledConnection.java:103) > at > org.jooq.impl.SettingsEnabledConnection.prepareStatement(SettingsEnabledConnection.java:71) > at org.jooq.impl.AbstractResultQuery.prepare(AbstractResultQuery.java:184) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:265) > at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:309) > at > org.jooq.impl.AbstractResultQuery.fetchInto(AbstractResultQuery.java:596) > at org.jooq.impl.SelectImpl.fetchInto(SelectImpl.java:1203) > at org.jooq.impl.AbstractStoreQuery.execute(AbstractStoreQuery.java:260) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:283) > at > org.jooq.impl.UpdatableRecordImpl.storeInsert(UpdatableRecordImpl.java:176) > at org.jooq.impl.UpdatableRecordImpl.store(UpdatableRecordImpl.java:139) > at ch.test.service.model.ProjectDAOImpl.persist(ProjectDAOImpl.java:46) > at ch.test.service.model.ProjectDAOImpl.persist(ProjectDAOImpl.java:1) > at > ch.test.service.model.ProjectDAOImplTest.shouldPersistNewMealItem(ProjectDAOImplTest.java:43) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:601) > at > org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) > at > org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > at > org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) > at > org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) > at > org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:74) > at > org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:83) > at > org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72) > at > org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:231) > at > org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:88) > at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) > at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) > at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) > at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) > at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) > at > org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) > at > org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71) > at org.junit.runners.ParentRunner.run(ParentRunner.java:309) > at > org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:174) > at > org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) > at > org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) > > Any ideas what the problem could be? Thanks a lot for any help! > Regards, Michele > That looks quite surprising. - What JDBC driver are you using? - What log4j TRACE output do you get when running that query? Info about logging can be found here [1]. A sample log4j.xml file is here [2] Cheers Lukas [1]: http://blog.jooq.org/2011/10/20/debug-logging-sql-with-jooq [2]: https://github.com/jOOQ/jOOQ/blob/master/jOOQ-test/src/log4j.xml -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
