i have problems running my application on a linux environment. The jasper reports are embedded into a web application. when clicking a report however i get a stacktrace.
It seems nothing can be insert into the jasper database, I use jboss510GA and oracleXE112
below part of the stacktrace.. I saw some topic on wrong dialect or so, but i have set it to Oracle10g dialect, should be ok....
10:20:02,118 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/apps/mars/jasperserver].[dwr]] Servlet.service() for servlet dwr threw exception org.springframework.dao.DataIntegrityViolationException: could not insert: [com.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [com.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:636) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
etc etc
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [com.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2176) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656)
ORA-01400: cannot insert NULL into ... issue
in Products
Posted
Hi,
i have problems running my application on a linux environment. The jasper reports are embedded into a web application. when clicking a report however i get a stacktrace.
It seems nothing can be insert into the jasper database, I use jboss510GA and oracleXE112
below part of the stacktrace.. I saw some topic on wrong dialect or so, but i have set it to Oracle10g dialect, should be ok....
Anyone a clue? Any more info needed?
10:20:02,117 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1400, SQLState: 23000
10:20:02,117 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-01400: cannot insert NULL into ("JASPERSERVER"."JIACCESSEVENT"."ID")
10:20:02,118 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/apps/mars/jasperserver].[dwr]] Servlet.service() for servlet dwr threw exception
org.springframework.dao.DataIntegrityViolationException: could not insert: [com.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [com.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent]
at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:636)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
etc etc
Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [com.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2176)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656)
etc etc