Hibernate version:3.1
Hi, I am trying to run open source Alfresco content management system with Ingres and I am getting following errors:
1. ------------------------------------------------
11:44:51,706 WARN [org.springframework.jdbc.support.SQLErrorCodesFact ory] Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessExc eption: Could not access DatabaseMetaData method 'getDatabaseProductName'; nested exception is java.lang.IllegalAccessException: Class org.springframework.jdbc.support.JdbcUtils$1 can not access a member of class com.ingres.gcf.jdbc.JdbcDBMD with modifiers "public"
java.lang.IllegalAccessException: Class org.springframework.jdbc.support.JdbcUtils$1 can not access a member of class com.ingres.gcf.jdbc.JdbcDBMD with modifiers "public"
at sun.reflect.Reflection.ensureMemberAccess(Reflecti on.java:65)
at java.lang.reflect.Method.invoke(Method.java:578)
at org.springframework.jdbc.support.JdbcUtils$1.proce ssMetaData(JdbcUtils.java:209)
at org.springframework.jdbc.support.JdbcUtils.extract DatabaseMetaData(JdbcUtils.java:174)
2. ------------------------------------------------
11:46:43,191 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
at org.alfresco.repo.importer.ImporterBootstrap.boots trap(ImporterBootstrap.java:448)
at org.alfresco.repo.importer.ImporterBootstrap.onBoo tstrap(ImporterBootstrap.java:670)
at org.alfresco.util.AbstractLifecycleBean.onApplicat ionEvent(AbstractLifecycleBean.java:54)
at org.springframework.context.event.SimpleApplicatio nEventMulticaster.multicastEvent(SimpleApplication EventMulticaster.java:45)
at org.springframework.context.support.AbstractApplic ationContext.publishEvent(AbstractApplicationConte xt.java:225)
at org.springframework.context.support.AbstractApplic ationContext.refresh(AbstractApplicationContext.ja va:323)
at org.springframework.web.context.support.AbstractRe freshableWebApplicationContext.refresh(AbstractRef reshableWebApplicationContext.java:134)
at org.springframework.web.context.ContextLoader.crea teWebApplicationContext(ContextLoader.java:246)
at org.springframework.web.context.ContextLoader.init WebApplicationContext(ContextLoader.java:184)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to import package at line 113; column 22 due to error: Hibernate operation: Could not execute JDBC batch update; uncategorized SQLException for SQL [insert into alf_node_properties (node_id, qname, actual_type, multi_valued, persisted_type, boolean_value, long_value, float_value, double_value, string_value, serializable_value) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [40001]; error code [4708]; The query has been aborted.; nested exception is java.sql.BatchUpdateException: The query has been aborted.
at org.alfresco.repo.importer.view.ViewParser.parse(V iewParser.java:171)
at org.alfresco.repo.importer.ImporterComponent.parse rImport(ImporterComponent.java:344)
at org.alfresco.repo.importer.ImporterComponent.impor tView(ImporterComponent.java:211)
at org.alfresco.repo.importer.ImporterBootstrap.boots trap(ImporterBootstrap.java:429)
... 33 more
Caused by: org.springframework.jdbc.UncategorizedSQLException : Hibernate operation: Could not execute JDBC batch update; uncategorized SQLException for SQL [insert into alf_node_properties (node_id, qname, actual_type, multi_valued, persisted_type, boolean_value, long_value, float_value, double_value, string_value, serializable_value) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [40001]; error code [4708]; The query has been aborted.; nested exception is java.sql.BatchUpdateException: The query has been aborted.
at org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.translate(SQLStateSQLExceptionTransl ator.java:96)
at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.translate(SQLErrorCodeSQLExcepti onTranslator.java:257)
at org.springframework.orm.hibernate3.HibernateAccess or.convertJdbcAccessException(HibernateAccessor.ja va:424)
at org.springframework.orm.hibernate3.HibernateAccess or.convertHibernateAccessException(HibernateAccess or.java:411)
at org.springframework.orm.hibernate3.HibernateTempla te.execute(HibernateTemplate.java:370)
Above two stack traces are coming at different points of time
The first stack trace is discussed in thread
http://forum.springframework.org/showthread.php?t=16207, but second one i could not find any thing about, are they both related? second one is failing at an INSERT statement.
Name and version of the database:Ingres 2006 community edition
-------------------------------------------------
Thanks & Regards,
Advait Trivedi