Re: [Treebase-devel] Data access failure for dev.

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

It seems that hibernate assigned the primary key (54 here). I thought  
the database would do that, not hibernate?

	-hilmar

On Mar 10, 2010, at 3:15 PM, William Piel wrote:

>
>
> When we try to upload a rowsegment metadata, we're getting a data  
> access failure.
>
>
> http://treebasedb-dev.nescent.org/treebase-web/user/rowSegmentDataTable.html
>
>
>
> Data Access Failure
>
> could not insert: [org.cipres.treebase.domain.matrix.RowSegment];  
> nested exception is  
> org.hibernate.exception.ConstraintViolationException: could not  
> insert: [org.cipres.treebase.domain.matrix.RowSegment]
>
> org.springframework.dao.DataIntegrityViolationException: could not  
> insert: [org.cipres.treebase.domain.matrix.RowSegment]; nested  
> exception is org.hibernate.exception.ConstraintViolationException:  
> could not insert: [org.cipres.treebase.domain.matrix.RowSegment]  
> Caused by: org.hibernate.exception.ConstraintViolationException:  
> could not insert: [org.cipres.treebase.domain.matrix.RowSegment] at  
> org 
> .hibernate 
> .exception.SQLStateConverter.convert(SQLStateConverter.java:71) at  
> org 
> .hibernate 
> .exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)  
> at  
> org 
> .hibernate 
> .persister 
> .entity.AbstractEntityPersister.insert(AbstractEntityPersister.java: 
> 2272) at  
> org 
> .hibernate 
> .persister 
> .entity.AbstractEntityPersister.insert(AbstractEntityPersister.java: 
> 2665) at  
> org 
> .hibernate.action.EntityInsertAction.execute(EntityInsertAction.java: 
> 60) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java: 
> 279) at  
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java: 
> 263) at  
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java: 
> 167) 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.transaction.JDBCTransaction.commit(JDBCTransaction.java: 
> 106) at  
> org 
> .springframework 
> .orm 
> .hibernate3 
> .HibernateTransactionManager 
> .doCommit(HibernateTransactionManager.java:578) at  
> org 
> .springframework 
> .transaction 
> .support 
> .AbstractPlatformTransactionManager 
> .processCommit(AbstractPlatformTransactionManager.java:662) at  
> org 
> .springframework 
> .transaction 
> .support 
> .AbstractPlatformTransactionManager 
> .commit(AbstractPlatformTransactionManager.java:632) at  
> org 
> .springframework 
> .transaction 
> .interceptor 
> .TransactionAspectSupport 
> .commitTransactionAfterReturning(TransactionAspectSupport.java:314)  
> at  
> org 
> .springframework 
> .transaction 
> .interceptor 
> .TransactionInterceptor.invoke(TransactionInterceptor.java:116) at  
> org 
> .springframework 
> .aop 
> .framework 
> .ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java: 
> 171) at  
> org 
> .springframework 
> .aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java: 
> 204) at $Proxy75.createSegments(Unknown Source) at  
> org.cipres.treebase.web.controllers.RowSegmentDataTableController.onSubmit 
> (RowSegmentDataTableController.java:112) at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission 
> (SimpleFormController.java:267) at org.springframework.web.servlet.mvc.CancellableFormController.processFormSubmission 
> (CancellableFormController.java:140) at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal 
> (AbstractFormController.java:265) at org.springframework.web.servlet.mvc.AbstractController.handleRequest 
> (AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle 
> (SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch 
> (DispatcherServlet.java:858) at org.springframework.web.servlet.DispatcherServlet.doService 
> (DispatcherServlet.java:792) at org.springframework.web.servlet.FrameworkServlet.processRequest 
> (FrameworkServlet.java:476) at org.springframework.web.servlet.FrameworkServlet.doPost 
> (FrameworkServlet.java:441) at  
> javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at  
> javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at  
> org 
> .apache 
> .catalina 
> .core 
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
> 269) at  
> org 
> .apache 
> .catalina 
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
> 188) at  
> org 
> .displaytag 
> .filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java: 
> 125) at  
> org 
> .apache 
> .catalina 
> .core 
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
> 215) at  
> org 
> .apache 
> .catalina 
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
> 188) at  
> org 
> .springframework 
> .orm 
> .hibernate3 
> .support 
> .OpenSessionInViewFilter 
> .doFilterInternal(OpenSessionInViewFilter.java:198) at  
> org 
> .springframework 
> .web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: 
> 75) at  
> org 
> .apache 
> .catalina 
> .core 
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
> 215) at  
> org 
> .apache 
> .catalina 
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
> 188) at  
> com 
> .opensymphony 
> .module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at  
> com 
> .opensymphony 
> .module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at  
> org 
> .apache 
> .catalina 
> .core 
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
> 215) at  
> org 
> .apache 
> .catalina 
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
> 188) at org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:264) at  
> org 
> .acegisecurity 
> .intercept 
> .web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java: 
> 107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter 
> (FilterSecurityInterceptor.java:72) at  
> org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at  
> org 
> .acegisecurity 
> .ui 
> .ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java: 
> 110) at org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at  
> org 
> .acegisecurity 
> .wrapper 
> .SecurityContextHolderAwareRequestFilter 
> .doFilter(SecurityContextHolderAwareRequestFilter.java:81) at  
> org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at  
> org 
> .acegisecurity 
> .ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java: 
> 217) at org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at  
> org 
> .acegisecurity 
> .context 
> .HttpSessionContextIntegrationFilter 
> .doFilter(HttpSessionContextIntegrationFilter.java:191) at  
> org.acegisecurity.util.FilterChainProxy 
> $VirtualFilterChain.doFilter(FilterChainProxy.java:274) at  
> org 
> .acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java: 
> 148) at  
> org 
> .acegisecurity 
> .util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at  
> org 
> .apache 
> .catalina 
> .core 
> .ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 
> 215) at  
> org 
> .apache 
> .catalina 
> .core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 
> 188) at  
> org 
> .apache 
> .catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 
> 213) at  
> org 
> .apache 
> .catalina.core.StandardContextValve.invoke(StandardContextValve.java: 
> 172) at  
> org 
> .apache 
> .catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  
> at  
> org 
> .apache 
> .catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)  
> at  
> org 
> .apache 
> .catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 
> 108) at  
> org 
> .apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 
> 174) at  
> org 
> .apache 
> .coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java: 
> 837) at org.apache.coyote.http11.Http11AprProtocol 
> $Http11ConnectionHandler.process(Http11AprProtocol.java:640) at  
> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java: 
> 1286) at java.lang.Thread.run(Thread.java:636) Caused by:  
> java.sql.BatchUpdateException: Batch entry 0 insert into ROWSEGMENT  
> (VERSION, EndIndex, MATRIXROW_ID, CatalogNum, CollectionCode,  
> Collector, Country, Elevation, GenBAccession, InstAcronym, Latitude,  
> Locality, Longitude, Notes, OtherAccession, SampleDate, State,  
> StartIndex, TAXONLABEL_ID, Title, ROWSEGMENT_ID) values (0, 4485,  
> 224329, NULL, NULL, NULL, NULL, NULL, AY3242354, NULL, NULL, NULL,  
> NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 54) was aborted. Call  
> getNextException to see the cause. at  
> org.postgresql.jdbc2.AbstractJdbc2Statement 
> $BatchResultHandler.handleError(AbstractJdbc2Statement.java:2537) at  
> org 
> .postgresql 
> .core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java: 
> 1328) at  
> org 
> .postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: 
> 351) at  
> org 
> .postgresql 
> .jdbc2 
> .AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java: 
> 2674) at  
> org 
> .apache 
> .tomcat 
> .dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java: 
> 297) at  
> org 
> .hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java: 
> 48) at  
> org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java: 
> 34) at  
> org 
> .hibernate 
> .persister 
> .entity.AbstractEntityPersister.insert(AbstractEntityPersister.java: 
> 2252) ... 69 more « Back
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev_______________________________________________
> Treebase-devel mailing list
> Tre...@li...
> https://lists.sourceforge.net/lists/listinfo/treebase-devel

-- 
===========================================================
: Hilmar Lapp  -:- Durham, NC -:- informatics.nescent.org :
===========================================================