js 2.0 on oracle

[kidice]

hi,

 

i tried the oracle-patch for js but it didn't work.

 

i changed the dialect to oracle and the connection setting in context.xml .. but the server tries anyway to connect to the mysql-database...

 

are there any other settings that i must change??

 

thx for help

 

 

//edit: solved that problem. i forgot to change the mysql-ds.xml

Post edited by: kidice, at: 2007/07/06 11:58

[alum]

It would be highly appreciated if you could share the oracle patch.

[kidice]

look here

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=27858&catid=10

 

 

and here

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=10&id=18698#18698

 

Post edited by: kidice, at: 2007/07/30 11:40

[alum]

Thanks! I had to do some fixing on it to make it work (sequences, triggers..), but now I think it's ok (see attachment).

[file name=oracle.zip size=3842]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/oracle.zip[/file]

 

However, when I try to add an object (user, data source etc) from the screen, I get this error:

Code:

2007-08-01 12:15:29,322 DEBUG [org.hibernate.SQL] insert into JIResource (version, name, parent_folder, childrenFolder, label, description, creation_d
ate) values (?, ?, ?, ?, ?, ?, ?)
2007-08-01 12:15:29,338 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2007-08-01 12:15:29,338 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.im
pl.hibernate.persistent.RepoFileResource] [insert into JIResource (version, name, parent_folder, childrenFolder, label, description, creation_date) va
lues (?, ?, ?, ?, ?, ?, ?)]
java.sql.SQLException: Invalid column type: getLong not implemented for class oracle.jdbc.driver.T4CRowidAccessor
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
        at oracle.jdbc.driver.Accessor.unimpl(Accessor.java:358)
        at oracle.jdbc.driver.Accessor.getLong(Accessor.java:496)
        at oracle.jdbc.driver.OracleReturnResultSet.getLong(OracleReturnResultSet.java:411)
        at org.jboss.resource.adapter.jdbc.WrappedResultSet.getLong(WrappedResultSet.java:703)
        at org.hibernate.id.IdentifierGeneratorFactory.get(IdentifierGeneratorFactory.java:47)
        at org.hibernate.id.IdentifierGeneratorFactory.getGeneratedIdentity(IdentifierGeneratorFactory.java:35)
        at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:74)
        at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)

 

Maby it is it because all the id columns in oracle are of type NUMBER (BIGINT on mysql)?

 

Post edited by: alum, at: 2007/08/01 12:28

Post edited by: alum, at: 2007/08/01 14:22

[lucianc]

Which Hibernate dialect are you using?

 

Regards,

Lucian

[alum]

lucianc wrote:

Which Hibernate dialect are you using? Regards, Lucian

 

You are right. I'm running mysql. However, when switching to oracle (metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect), I can't even login, and I get this error.

Code:

2007-08-02 06:24:19,560 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-08-02 06:24:19,560 DEBUG [org.hibernate.SQL] select users0_.roleId as roleId1_, users0_.userId as userId1_, repouser1_.id as id3_0_, repouser1_.u
sername as username3_0_, repouser1_.fullname as fullname3_0_, repouser1_.emailAddress as emailAdd4_3_0_, repouser1_.password as password3_0_, repouser
1_.externallyDefined as external6_3_0_, repouser1_.enabled as enabled3_0_ from JIUserRole users0_, JIUser repouser1_ where users0_.userId=repouser1_.i
d(+) and users0_.roleId=?
2007-08-02 06:24:19,560 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2007-08-02 06:24:19,560 DEBUG [org.hibernate.loader.Loader] result set contains (possibly empty) collection: [com.jaspersoft.jasperserver.api.metadata
.user.domain.impl.hibernate.RepoRole.users#4]
2007-08-02 06:24:19,560 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.
RepoUser#3]
2007-08-02 06:24:19,560 DEBUG [org.hibernate.loader.Loader] found row of collection: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibern
ate.RepoRole.users#4]
2007-08-02 06:24:19,560 DEBUG [org.hibernate.loader.Loader] result row: null
2007-08-02 06:24:19,560 DEBUG [org.hibernate.loader.Loader] found row of collection: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibern
ate.RepoRole.users#4]
2007-08-02 06:24:19,560 DEBUG [org.hibernate.loader.Loader] loading entity: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoU
ser#10]
2007-08-02 06:24:19,560 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 1, globally: 1)
2007-08-02 06:24:19,560 DEBUG [org.hibernate.SQL] select repouser0_.id as id3_0_, repouser0_.username as username3_0_, repouser0_.fullname as fullname
3_0_, repouser0_.emailAddress as emailAdd4_3_0_, repouser0_.password as password3_0_, repouser0_.externallyDefined as external6_3_0_, repouser0_.enabl
ed as enabled3_0_ from JIUser repouser0_ where repouser0_.id=?
2007-08-02 06:24:19,560 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 1, globally: 1)
2007-08-02 06:24:19,560 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 2, globally: 2)
2007-08-02 06:24:19,560 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 2, globally: 2)
2007-08-02 06:24:19,560 DEBUG [org.hibernate.loader.Loader] done entity load
2007-08-02 06:24:19,560 INFO  [org.hibernate.event.def.DefaultLoadEventListener] Error performing load command
org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.R
epoUser#10]
        at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:375)
        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:145)
        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
        at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
        at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:557)
        at org.hibernate.type.EntityType.resolve(EntityType.java:379)
        at org.hibernate.type.EntityType.nullSafeGet(EntityType.java:204)
        at org.hibernate.persister.collection.AbstractCollectionPersister.readElement(AbstractCollectionPersister.java:703)
        at org.hibernate.collection.PersistentSet.readFrom(PersistentSet.java:318)
        at org.hibernate.loader.Loader.readCollectionElement(Loader.java:994)
        at org.hibernate.loader.Loader.readCollectionElements(Loader.java:634)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:579)
        at org.hibernate.loader.Loader.doQuery(Loader.java:689)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
        at org.hibernate.loader.Loader.loadCollection(Loader.java:1985)
        at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
        at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
        at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
        at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
        at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:454)
        at org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:755)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:229)
        at org.hibernate.loader.Loader.doList(Loader.java:2211)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
        at org.hibernate.loader.Loader.list(Loader.java:2090)
        at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:95)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at org.springframework.orm.hibernate3.HibernateTemplate$35.doInHibernate(HibernateTemplate.java:979)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
        at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:969)
        at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:962)
        at com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.getRepoUser(UserAuthorityServiceImpl.java:90)

[alum]

I deleted the content of all tables and re-inserted the default security stuff, and now I was able to login. But when inserting any object (e.g. a data source) I get the following error.

Code:

2007-08-02 06:45:45,439 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hib
ernate3.SessionHolder@5a41ec] for key [org.hibernate.impl.SessionFactoryImpl@13d556f] bound to thread [http-0.0.0.0-80-2]
2007-08-02 06:45:45,439 DEBUG [org.springframework.orm.hibernate3.HibernateTemplate] Found thread-bound Session for HibernateTemplate
2007-08-02 06:45:45,439 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Retrieved value [org.springframework.orm.hib
ernate3.SessionHolder@5a41ec] for key [org.hibernate.impl.SessionFactoryImpl@13d556f] bound to thread [http-0.0.0.0-80-2]
2007-08-02 06:45:45,439 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-08-02 06:45:45,439 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2007-08-02 06:45:45,439 DEBUG [org.hibernate.SQL] select this_.id as id2_1_, this_.version as version2_1_, this_.name as name2_1_, this_.parent_folder
 as parent4_2_1_, this_.childrenFolder as children5_2_1_, this_.label as label2_1_, this_.description as descript7_2_1_, this_.creation_date as creati
on8_2_1_, this_1_.type as type17_1_, this_1_.mandatory as mandatory17_1_, this_1_.readOnly as readOnly17_1_, this_1_.visible as visible17_1_, this_1_.
data_type as data6_17_1_, this_1_.list_of_values as list7_17_1_, this_1_.list_query as list8_17_1_, this_1_.query_value_column as query9_17_1_, this_1
_.defaultValue as default10_17_1_, this_2_.catalog as catalog19_1_, this_2_.mondrianConnection as mondrian3_19_1_, this_3_.reportDataSource as reportD
a2_20_1_, this_3_.query as query20_1_, this_3_.mainReport as mainReport20_1_, this_3_.controlrenderer as controlr5_20_1_, this_3_.reportrenderer as re
portre6_20_1_, this_3_.promptcontrols as promptco7_20_1_, this_3_.controlslayout as controls8_20_1_, this_4_.data as data23_1_, this_4_.file_type as f
ile3_23_1_, this_6_.reportDataSource as reportDa2_25_1_, this_6_.mondrianSchema as mondrian3_25_1_, this_7_.olapClientConnection as olapClie2_26_1_, t
his_7_.mdx_query as mdx3_26_1_, this_7_.view_options as view4_26_1_, this_8_.driver as driver27_1_, this_8_.password as password27_1_, this_8_.connect
ionUrl as connecti4_27_1_, this_8_.username as username27_1_, this_8_.timezone as timezone27_1_, this_9_.catalog as catalog28_1_, this_9_.username as
username28_1_, this_9_.password as password28_1_, this_9_.datasource as datasource28_1_, this_9_.uri as uri28_1_, this_10_.dataSource as dataSource29_
1_, this_10_.query_language as query3_29_1_, this_10_.sql_query as sql4_29_1_, this_11_.jndiName as jndiName30_1_, this_11_.timezone as timezone30_1_,
 this_12_.serviceClass as serviceC2_31_1_, this_14_.type as type35_1_, this_14_.maxLength as maxLength35_1_, this_14_.decimals as decimals35_1_, this_
14_.regularExpr as regularE5_35_1_, this_14_.minValue as minValue35_1_, this_14_.maxValue as maxValue35_1_, this_14_.strictMin as strictMin35_1_, this
_14_.strictMax as strictMax35_1_, this_15_.data as data36_1_, this_15_.file_type as file3_36_1_, this_15_.reference as reference36_1_, this_16_.beanNa
me as beanName37_1_, this_16_.beanMethod as beanMethod37_1_, decode(this_.id, this_6_.id, 6, this_9_.id, 9, this_1_.id, 1, this_2_.id, 2, this_3_.id,
3, this_4_.id, 4, this_5_.id, 5, this_7_.id, 7, this_8_.id, 8, this_10_.id, 10, this_11_.id, 11, this_12_.id, 12, this_13_.id, 13, this_14_.id, 14, th
is_15_.id, 15, this_16_.id, 16, 0) as clazz_1_, parent1_.id as id1_0_, parent1_.version as version1_0_, parent1_.uri as uri1_0_, parent1_.hidden as hi
dden1_0_, parent1_.name as name1_0_, parent1_.label as label1_0_, parent1_.description as descript7_1_0_, parent1_.parent_folder as parent8_1_0_, pare
nt1_.creation_date as creation9_1_0_ from JIResource this_, JIInputControl this_1_, JIMondrianXMLADefinition this_2_, JIReportUnit this_3_, JIContentR
esource this_4_, JIOlapClientConnection this_5_, JIMondrianConnection this_6_, JIOlapUnit this_7_, JIJdbcDatasource this_8_, JIXMLAConnection this_9_,
 JIQuery this_10_, JIJNDIJdbcDatasource this_11_, JICustomDatasource this_12_, JIListOfValues this_13_, JIDataType this_14_, JIFileResource this_15_,
JIBeanDatasource this_16_, JIResourceFolder parent1_ where this_.parent_folder=parent1_.id and this_.id=this_1_.id(+) and this_.id=this_2_.id(+) and t
his_.id=this_3_.id(+) and this_.id=this_4_.id(+) and this_.id=this_5_.id(+) and this_.id=this_6_.id(+) and this_.id=this_7_.id(+) and this_.id=this_8_
.id(+) and this_.id=this_9_.id(+) and this_.id=this_10_.id(+) and this_.id=this_11_.id(+) and this_.id=this_12_.id(+) and this_.id=this_13_.id(+) and
this_.id=this_14_.id(+) and this_.id=this_15_.id(+) and this_.id=this_16_.id(+) and parent1_.hidden=? and (parent1_.uri=?)
2007-08-02 06:45:45,579 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2007-08-02 06:45:45,579 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[com.jaspersoft.jasperserver.api.metadata.common.service.impl.hiberna
te.persistent.RepoFolder#21], EntityKey[com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource#41]
2007-08-02 06:45:45,595 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
2007-08-02 06:45:45,595 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2007-08-02 06:45:45,595 DEBUG [org.hibernate.jdbc.ConnectionManager] transaction completed on session with on_close connection release mode; be sure t
o close the session to release JDBC resources!
2007-08-02 06:45:45,595 DEBUG [org.springframework.orm.hibernate3.HibernateTemplate] Not closing pre-bound Hibernate Session after HibernateTemplate
2007-08-02 06:45:45,595 DEBUG [org.acegisecurity.afterinvocation.BasicAclEntryAfterInvocationCollectionFilteringProvider] Return object is null, skipp
ing
2007-08-02 06:45:45,595 DEBUG [org.acegisecurity.afterinvocation.BasicAclEntryAfterInvocationCollectionFilteringProvider] Return object is null, skipp
ing
2007-08-02 06:45:45,595 DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor] Completing transaction for [com.jaspersoft.jasperse
rver.api.metadata.common.service.RepositoryService.loadResourcesList] after exception: org.springframework.orm.hibernate3.HibernateSystemException: Ca
nnot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested e
xception is org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.serv
ice.impl.hibernate.persistent.RepoResource
2007-08-02 06:45:45,595 DEBUG [org.springframework.transaction.interceptor.RuleBasedTransactionAttribute] Applying rules to determine whether transact
ion should rollback on org.springframework.orm.hibernate3.HibernateSystemException: Cannot instantiate abstract class or interface: com.jaspersoft.jas
perserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: Cannot instant
iate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
2007-08-02 06:45:45,595 DEBUG [org.springframework.transaction.interceptor.RuleBasedTransactionAttribute] Winning rollback rule is: null
2007-08-02 06:45:45,595 DEBUG [org.springframework.transaction.interceptor.RuleBasedTransactionAttribute] No relevant rollback rule found: applying su
perclass default
2007-08-02 06:45:45,595 DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] Should roll back transaction but cannot - no transactio
n available
2007-08-02 06:45:45,595 DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor] Completing transaction for [com.jaspersoft.jasperse
rver.api.metadata.common.service.RepositoryService.loadResourcesList] after exception: org.springframework.orm.hibernate3.HibernateSystemException: Ca
nnot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested e
xception is org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.serv
ice.impl.hibernate.persistent.RepoResource
2007-08-02 06:45:45,595 DEBUG [org.springframework.transaction.interceptor.RuleBasedTransactionAttribute] Applying rules to determine whether transact
ion should rollback on org.springframework.orm.hibernate3.HibernateSystemException: Cannot instantiate abstract class or interface: com.jaspersoft.jas
perserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: Cannot instant
iate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
2007-08-02 06:45:45,595 DEBUG [org.springframework.transaction.interceptor.RuleBasedTransactionAttribute] Winning rollback rule is: null
2007-08-02 06:45:45,595 DEBUG [org.springframework.transaction.interceptor.RuleBasedTransactionAttribute] No relevant rollback rule found: applying su
perclass default
2007-08-02 06:45:45,595 DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] Triggering beforeCompletion synchronization
2007-08-02 06:45:45,595 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Removed value [org.springframework.orm.hiber
nate3.SessionHolder@5a41ec] for key [org.hibernate.impl.SessionFactoryImpl@13d556f] from thread [http-0.0.0.0-80-2]
2007-08-02 06:45:45,595 DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] Should roll back transaction but cannot - no transactio
n available
2007-08-02 06:45:45,595 DEBUG [org.springframework.orm.hibernate3.HibernateTransactionManager] Triggering afterCompletion synchronization
2007-08-02 06:45:45,595 DEBUG [org.springframework.orm.hibernate3.SessionFactoryUtils] Closing Hibernate Session
2007-08-02 06:45:45,595 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open Resul
tSets: 0, globally: 0)]
2007-08-02 06:45:45,595 DEBUG [org.hibernate.jdbc.ConnectionManager] transaction completed on session with on_close connection release mode; be sure t
o close the session to release JDBC resources!
2007-08-02 06:45:45,595 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Clearing transaction synchronization
2007-08-02 06:45:45,595 DEBUG [org.springframework.util.CachingMapDecorator] For key 'class org.springframework.core.style.DefaultValueStyler', return
ing cached value: org.springframework.core.ReflectiveVisitorHelper$ClassVisitMethods@1c17f5a
2007-08-02 06:45:45,595 DEBUG [org.springframework.util.CachingMapDecorator] For key 'class com.jaspersoft.jasperserver.war.action.RepoAdminAction', r
eturning cached value: java.lang.String org.springframework.core.style.DefaultValueStyler.visit(java.lang.Object)
2007-08-02 06:45:45,595 DEBUG [org.springframework.util.CachingMapDecorator] For key 'class org.springframework.core.style.DefaultValueStyler', return
ing cached value: org.springframework.core.ReflectiveVisitorHelper$ClassVisitMethods@1c17f5a
2007-08-02 06:45:45,595 DEBUG [org.springframework.util.CachingMapDecorator] For key 'class org.springframework.webflow.core.collection.LocalAttribute
Map', returning cached value: java.lang.String org.springframework.core.style.DefaultValueStyler.visit(java.lang.Object)
2007-08-02 06:45:45,595 DEBUG [org.springframework.util.CachingMapDecorator] For key 'class org.springframework.core.style.DefaultValueStyler', return
ing cached value: org.springframework.core.ReflectiveVisitorHelper$ClassVisitMethods@1c17f5a
2007-08-02 06:45:45,595 DEBUG [org.springframework.util.CachingMapDecorator] For key 'class java.util.HashMap', returning cached value: java.lang.Stri
ng org.springframework.core.style.DefaultValueStyler.visit(java.util.Map)
2007-08-02 06:45:45,595 DEBUG [org.springframework.util.CachingMapDecorator] For key 'class org.springframework.core.style.DefaultValueStyler', return
ing cached value: org.springframework.core.ReflectiveVisitorHelper$ClassVisitMethods@1c17f5a
2007-08-02 06:45:45,595 DEBUG [org.springframework.util.CachingMapDecorator] For key 'class java.util.HashMap', returning cached value: java.lang.Stri
ng org.springframework.core.style.DefaultValueStyler.visit(java.util.Map)
2007-08-02 06:45:45,595 DEBUG [org.springframework.webflow.engine.impl.FlowExecutionImpl] Attempting to handle [org.springframework.webflow.engine.Act
ionExecutionException: Exception thrown executing [AnnotatedAction@17e9fe8 targetAction = com.jaspersoft.jasperserver.war.action.RepoAdminAction@34498
6, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow' -- action execution attributes were 'map[[empty]]'; nested exception is or
g.springframework.orm.hibernate3.HibernateSystemException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.co
mmon.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: Cannot instantiate abstract class or in
terface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource]
2007-08-02 06:45:45,595 DEBUG [org.springframework.webflow.engine.support.TransitionExecutingStateExceptionHandler] Handling state exception org.sprin
gframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@17e9fe8 targetAction = com.jaspersoft.jasperserver.war
.action.RepoAdminAction@344986, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow' -- action execution attributes were 'map[[emp
ty]]'; nested exception is org.springframework.orm.hibernate3.HibernateSystemException: Cannot instantiate abstract class or interface: com.jaspersoft
.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: Cannot ins
tantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
org.springframework.webflow.engine.ActionExecutionException: Exception thrown executing [AnnotatedAction@17e9fe8 targetAction = com.jaspersoft.jaspers
erver.war.action.RepoAdminAction@344986, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow' -- action execution attributes were
'map[[empty]]'; nested exception is org.springframework.orm.hibernate3.HibernateSystemException: Cannot instantiate abstract class or interface: com.j
aspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: C
annot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
Caused by:
org.springframework.orm.hibernate3.HibernateSystemException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.
common.service.impl.hibernate.persistent.RepoResource; nested exception is org.hibernate.InstantiationException: Cannot instantiate abstract class or
interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource
Caused by:
org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hib
ernate.persistent.RepoResource
        at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:78)
        at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:100)
        at org.hibernate.tuple.entity.AbstractEntityTuplizer.instantiate(AbstractEntityTuplizer.java:351)
        at org.hibernate.persister.entity.AbstractEntityPersister.instantiate(AbstractEntityPersister.java:3554)
        at org.hibernate.impl.SessionImpl.instantiate(SessionImpl.java:1275)
        at org.hibernate.impl.SessionImpl.instantiate(SessionImpl.java:1264)
        at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1290)
        at org.hibernate.loader.Loader.getRow(Loader.java:1197)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:568)
        at org.hibernate.loader.Loader.doQuery(Loader.java:689)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
        at org.hibernate.loader.Loader.doList(Loader.java:2211)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
        at org.hibernate.loader.Loader.list(Loader.java:2090)
        at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:95)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
        at org.springframework.orm.hibernate3.HibernateTemplate$35.doInHibernate(HibernateTemplate.java:979)
        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)
        at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:969)
        at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:962)

[lucianc]

alum wrote:

Caused by: org.hibernate.InstantiationException: Cannot instantiate abstract class or interface: com.jaspersoft.jasperserver.api.metadata.common.service.impl.hib ernate.persistent.RepoResource

 

This usually happens when the JasperServer schema includes inconsistent data. Since you say that the schema was clean, this means that the inconsistent data was somehow inserted by JS itself.

 

If you have Oracle >= 9, could you try org.hibernate.dialect.Oracle9Dialect (again on a clean schema)?

 

Regards,

Lucian

[alum]

I'm running Oracle 10.2.0. I updated the dialect as you proposed, refreshed the schema, and restarted the server. I got this error when inserting a user:

Code:

2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] loading collection: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.R
epoRole.users#42]
2007-08-02 08:46:54,104 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-08-02 08:46:54,104 DEBUG [org.hibernate.SQL] select users0_.roleId as roleId1_, users0_.userId as userId1_, repouser1_.id as id3_0_, repouser1_.u
sername as username3_0_, repouser1_.fullname as fullname3_0_, repouser1_.emailAddress as emailAdd4_3_0_, repouser1_.password as password3_0_, repouser
1_.externallyDefined as external6_3_0_, repouser1_.enabled as enabled3_0_ from JIUserRole users0_ left outer join JIUser repouser1_ on users0_.userId=
repouser1_.id where users0_.roleId=?
2007-08-02 08:46:54,104 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] result set contains (possibly empty) collection: [com.jaspersoft.jasperserver.api.metadata
.user.domain.impl.hibernate.RepoRole.users#42]
2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.
RepoUser#62]
2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] found row of collection: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibern
ate.RepoRole.users#42]
2007-08-02 08:46:54,104 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 1, globally: 1)
2007-08-02 08:46:54,104 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2007-08-02 08:46:54,104 DEBUG [org.hibernate.engine.CollectionLoadContext] 1 collections were found in result set for role: com.jaspersoft.jasperserve
r.api.metadata.user.domain.impl.hibernate.RepoRole.users
2007-08-02 08:46:54,104 DEBUG [org.hibernate.engine.CollectionLoadContext] collection fully initialized: [com.jaspersoft.jasperserver.api.metadata.use
r.domain.impl.hibernate.RepoRole.users#42]
2007-08-02 08:46:54,104 DEBUG [org.hibernate.engine.CollectionLoadContext] 1 collections initialized for role: com.jaspersoft.jasperserver.api.metadat
a.user.domain.impl.hibernate.RepoRole.users
2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] done loading collection
2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] loading collection: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.R
epoRole.users#41]
2007-08-02 08:46:54,104 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-08-02 08:46:54,104 DEBUG [org.hibernate.SQL] select users0_.roleId as roleId1_, users0_.userId as userId1_, repouser1_.id as id3_0_, repouser1_.u
sername as username3_0_, repouser1_.fullname as fullname3_0_, repouser1_.emailAddress as emailAdd4_3_0_, repouser1_.password as password3_0_, repouser
1_.externallyDefined as external6_3_0_, repouser1_.enabled as enabled3_0_ from JIUserRole users0_ left outer join JIUser repouser1_ on users0_.userId=
repouser1_.id where users0_.roleId=?
2007-08-02 08:46:54,104 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] result set contains (possibly empty) collection: [com.jaspersoft.jasperserver.api.metadata
.user.domain.impl.hibernate.RepoRole.users#41]
2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] result row: null
2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] found row of collection: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibern
ate.RepoRole.users#41]
2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] loading entity: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoU
ser#30]
2007-08-02 08:46:54,104 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 1, globally: 1)
2007-08-02 08:46:54,104 DEBUG [org.hibernate.SQL] select repouser0_.id as id3_0_, repouser0_.username as username3_0_, repouser0_.fullname as fullname
3_0_, repouser0_.emailAddress as emailAdd4_3_0_, repouser0_.password as password3_0_, repouser0_.externallyDefined as external6_3_0_, repouser0_.enabl
ed as enabled3_0_ from JIUser repouser0_ where repouser0_.id=?
2007-08-02 08:46:54,104 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 1, globally: 1)
2007-08-02 08:46:54,104 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close ResultSet (open ResultSets: 2, globally: 2)
2007-08-02 08:46:54,104 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 2, globally: 2)
2007-08-02 08:46:54,104 DEBUG [org.hibernate.loader.Loader] done entity load
2007-08-02 08:46:54,104 INFO  [org.hibernate.event.def.DefaultLoadEventListener] Error performing load command
org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.R
epoUser#30]
        at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:375)
        at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:145)
        at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
        at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
        at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:846)
        at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:557)
        at org.hibernate.type.EntityType.resolve(EntityType.java:379)
        at org.hibernate.type.EntityType.nullSafeGet(EntityType.java:204)
        at org.hibernate.persister.collection.AbstractCollectionPersister.readElement(AbstractCollectionPersister.java:703)
        at org.hibernate.collection.PersistentSet.readFrom(PersistentSet.java:318)
        at org.hibernate.loader.Loader.readCollectionElement(Loader.java:994)
        at org.hibernate.loader.Loader.readCollectionElements(Loader.java:634)
        at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:579)
        at org.hibernate.loader.Loader.doQuery(Loader.java:689)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
        at org.hibernate.loader.Loader.loadCollection(Loader.java:1985)
        at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
        at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
        at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
        at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
        at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:454)
        at org.hibernate.engine.StatefulPersistenceContext.initializeNonLazyCollections(StatefulPersistenceContext.java:755)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:229)
        at org.hibernate.loader.Loader.doList(Loader.java:2211)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
        at org.hibernate.loader.Loader.list(Loader.java:2090)
        at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:95)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
        at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)

Post edited by: alum, at: 2007/08/02 08:50

[lucianc]

According to Hibernate documentation, Oracle9Dialect works on 10g as well.

[alum]

My lack of hibernate knowlegde lead me to add sequences and triggers to the oracle dll. So when I started using oracle dialect, obviously the system got a bit confused. But now I have re-installed the schema (without sequences/triggers), running it with oracle dialect, and it works!