[
https://issues.apache.org/jira/browse/DERBY-2590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12491658
]
Dyre Tjeldvoll commented on DERBY-2590:
---------------------------------------
I won't rule out anything, but I would be very surprised if Derby "just
happened" to change 10 to 11 in this case.
But this should be easy enough for you to verify. Just stop at the place in the
Hibernate code where it makes the call to
PreparedStatement.setLong() and see which index is used... (in the variables
tab in NetBeans).
> error in error message
> ----------------------
>
> Key: DERBY-2590
> URL: https://issues.apache.org/jira/browse/DERBY-2590
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.1.3.1
> Environment: nothing special, the request is totally generated by JPA
> through hibernate
> Reporter: Zied Hamdi
> Attachments: persistence bug.PNG
>
>
> I have an index that doesn't exist : 11 (the total count of columns is 10): I
> think the error is just in the index : id is infact of type long
> Hibernate: insert into BasicPersonArchiveEntry (endDate,
> entryPerformer_revision, entryPerformer_id, lastOccurence, note, startDate,
> source_revision, source_id, revision, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?)
> could not bind value '0' to parameter: 11; Invalid argument: parameter index
> 11 is out of range.
> SQL Error: -99999, SQLState: null
> Invalid argument: parameter index 11 is out of range.
> Could not synchronize database state with session
> org.hibernate.exception.GenericJDBCException: could not insert:
> [com.homeservices.model.impl.BasicPersonArchiveEntry]
> at
> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
> at
> org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:52)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
> at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
> at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
> at
> org.hibernate.ejb.AbstractEntityManagerImpl$1.beforeCompletion(AbstractEntityManagerImpl.java:516)
> at
> com.sun.enterprise.distributedtx.J2EETransaction.commit(J2EETransaction.java:395)
> at
> com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:357)
> at
> com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3653)
> at
> com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3431)
> at
> com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1247)
> at
> com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:192)
> at
> com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:118)
> at $Proxy48.create(Unknown Source)
> at
> tests.entities.TestArchiveServlet.processRequest(TestArchiveServlet.java:46)
> at tests.entities.TestArchiveServlet.doGet(TestArchiveServlet.java:61)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at
> org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:397)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:278)
> at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
> at
> org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:240)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:179)
> at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
> at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:73)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:182)
> at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
> at
> com.sun.enterprise.web.VirtualServerPipeline.invoke(VirtualServerPipeline.java:120)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:137)
> at
> org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:566)
> at
> org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:536)
> at
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:939)
> at
> org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:231)
> at
> com.sun.enterprise.web.connector.grizzly.ProcessorTask.invokeAdapter(ProcessorTask.java:667)
> at
> com.sun.enterprise.web.connector.grizzly.ProcessorTask.processNonBlocked(ProcessorTask.java:574)
> at
> com.sun.enterprise.web.connector.grizzly.ProcessorTask.process(ProcessorTask.java:844)
> at
> com.sun.enterprise.web.connector.grizzly.ReadTask.executeProcessorTask(ReadTask.java:287)
> at
> com.sun.enterprise.web.connector.grizzly.ReadTask.doTask(ReadTask.java:212)
> at
> com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:252)
> at
> com.sun.enterprise.web.connector.grizzly.WorkerThread.run(WorkerThread.java:75)
> Caused by: org.apache.derby.client.am.SqlException: Invalid argument:
> parameter index 11 is out of range.
> at
> org.apache.derby.client.am.PreparedStatement.checkForValidParameterIndex(Unknown
> Source)
> at
> org.apache.derby.client.am.PreparedStatement.checkSetterPreconditions(Unknown
> Source)
> at org.apache.derby.client.am.PreparedStatement.setLong(Unknown
> Source)
> at org.hibernate.type.LongType.set(LongType.java:42)
> at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136)
> at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:116)
> at
> org.hibernate.type.ComponentType.nullSafeSet(ComponentType.java:284)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2008)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2243)
> ... 46 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
