[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2587) There is an attempt to set more parameters on a prepared statement than the latter can hold

Zied Hamdi (JIRA) noreply at atlassian.com
Wed Apr 25 15:50:04 EDT 2007


    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_26813 ] 

Zied Hamdi commented on HHH-2587:
---------------------------------

Sorry I forgot to mention for those who have trouble intalling hibernate on netBeans, follow these steps:
http://www.netbeans.org/kb/articles/hibernate-javaee.html

If you don't see your hibernate log, and you don't want to bother your self with log4j setup, just remove the log4j.jar file from your server (and restart "for dummies" ;-p).

> There is an attempt to set more parameters on a prepared statement than the latter can hold
> -------------------------------------------------------------------------------------------
>
>                 Key: HHH-2587
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2587
>             Project: Hibernate3
>          Issue Type: Bug
>          Components: query-sql
>    Affects Versions: 3.2.3
>         Environment: JPA through hibernate
>            Reporter: Zied Hamdi
>            Priority: Blocker
>         Attachments: IntoCore.zip
>
>   Original Estimate: 3 hours
>  Remaining Estimate: 3 hours
>
> You can directly import the zip content into netBeans 5.5 the just launch: the test is executed at the home page servlet call.
> I have an index that doesn't exist : 11 (the total count of columns is 10) :
> 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 $Proxy49.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
> EJB5018: An exception was thrown during an ejb invocation on [ArchivableFacadeStatelessBean]
> javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException: Transaction marked for rollback.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        



More information about the hibernate-issues mailing list