[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4020) Unable to load PersistentMap with the schema attribute define in the annotation @Table

Mon Jul 6 11:58:13 EDT 2009

Unable to load PersistentMap with the schema attribute define in the annotation @Table
--------------------------------------------------------------------------------------

                 Key: HHH-4020
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4020
             Project: Hibernate Core
          Issue Type: Bug
    Affects Versions: 3.3.1
            Reporter: Xavier Jodoin
         Attachments: entities.zip

Hibernate: select permission0_.SecureItem_id as SecureItem1_4_, permission0_.permissions_id as permissi2_4_, (select a11.owner_id from Permission a11 where a11.id=permission0_.permissions_id) as formula0_4_, permission1_.id as id88_0_, permission1_.factoryDefault as factoryD2_88_0_, permission1_.owner_id as owner7_88_0_, permission1_.propertyCreate as property3_88_0_, permission1_.propertyDelete as property4_88_0_, permission1_.propertyEdit as property5_88_0_, permission1_.propertyReadOnly as property6_88_0_, permission1_.secureItem_id as secureItem8_88_0_, secureacce2_.id as id29_1_, secureacce2_.factoryDefault as factoryD2_29_1_, secureacce2_.code as code29_1_, secureacce2_.upperCode as upperCode29_1_, secureacce2_.version as version29_1_, secureacce2_1_.password as password30_1_, secureacce2_2_.activate as activate31_1_, secureacce2_2_.admin as admin31_1_, secureacce2_2_.configurator as configur3_31_1_, secureacce2_2_.email as email31_1_, secureacce2_2_.firstName as firstName31_1_, secureacce2_2_.language_id as language10_31_1_, secureacce2_2_.lastName as lastName31_1_, secureacce2_2_.middleName as middleName31_1_, secureacce2_2_.readOnly as readOnly31_1_, secureacce2_2_.salesRep_id as salesRep11_31_1_, case when secureacce2_2_.id is not null then 2 when secureacce2_1_.id is not null then 1 when secureacce2_3_.id is not null then 3 when secureacce2_.id is not null then 0 else -1 end as clazz_1_, secureitem3_.id as id87_2_, secureitem3_.factoryDefault as factoryD2_87_2_, secureitem3_.name as name87_2_, secureitem3_.parent_id as parent6_87_2_, secureitem3_.securityKey as security4_87_2_, secureitem3_.securityOverride as security5_87_2_, secureitem4_.id as id87_3_, secureitem4_.factoryDefault as factoryD2_87_3_, secureitem4_.name as name87_3_, secureitem4_.parent_id as parent6_87_3_, secureitem4_.securityKey as security4_87_3_, secureitem4_.securityOverride as security5_87_3_ from naid_security.SecureItem_Permission permission0_ left outer join naid_security.Permission permission1_ on permission0_.permissions_id=permission1_.id left outer join naid_security.SecureAccess secureacce2_ on permission1_.owner_id=secureacce2_.id left outer join naid_security.SecurityUser secureacce2_1_ on secureacce2_.id=secureacce2_1_.id left outer join Users secureacce2_2_ on secureacce2_.id=secureacce2_2_.id left outer join naid_security.SecurityGroup secureacce2_3_ on secureacce2_.id=secureacce2_3_.id left outer join naid_security.SecureItem secureitem3_ on permission1_.secureItem_id=secureitem3_.id left outer join naid_security.SecureItem secureitem4_ on secureitem3_.parent_id=secureitem4_.id where permission0_.SecureItem_id=?
33033 [Thread-7] ERROR com.netappsid.services.beans.LoaderBean  - Class Loaded : SecureItem
Id : 32768
could not initialize a collection: [com.netappsid.security.bo.SecureItem.permissions#32770]
org.hibernate.exception.SQLGrammarException: could not initialize a collection: [com.netappsid.security.bo.SecureItem.permissions#32770]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.loader.Loader.loadCollection(Loader.java:2022)
	at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:59)
	at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:587)
	at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:83)
	at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1743)
	at org.hibernate.collection.AbstractPersistentCollection.forceInitialization(AbstractPersistentCollection.java:476)
	at org.hibernate.Hibernate.initialize(Hibernate.java:332)
	at com.netappsid.dao.GenericDAO.initializeProxy(GenericDAO.java:1200)
	at com.netappsid.security.bo.dao.SecureItemDAO.loadSecureItemAssociation(SecureItemDAO.java:29)
	at com.netappsid.security.bo.dao.SecureItemDAO.loadSecureItemAssociation(SecureItemDAO.java:26)
	at com.netappsid.security.bo.dao.SecureItemDAO.loadAssociations(SecureItemDAO.java:16)
	at com.netappsid.services.beans.LoaderBean.findById(LoaderBean.java:140)
	at com.netappsid.services.beans.LoaderBean_$$_javassist_43._d27findById(LoaderBean_$$_javassist_43.java)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.netappsid.ejb3.naming.AbstractService$2.invoke(AbstractService.java:140)
	at com.netappsid.services.beans.LoaderBean_$$_javassist_43.findById(LoaderBean_$$_javassist_43.java)
	at com.netappsid.security.gui.SecurityAdminGUI$1$1.run(SecurityAdminGUI.java:101)
Caused by: java.sql.SQLSyntaxErrorException: Table/View 'PERMISSION' does not exist.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
	at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
	at org.hibernate.loader.Loader.doQuery(Loader.java:696)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
	at org.hibernate.loader.Loader.loadCollection(Loader.java:2015)
	... 19 more
Caused by: java.sql.SQLException: Table/View 'PERMISSION' does not exist.
	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
	at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
	... 39 more

-- 
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