Welcome Guest  |  Register  |  Login
Login Name Password
  Search  
  Index  | Recent Threads  | Unanswered Threads  | Who's Online  | User List  | Help

  DataNucleus Forum
  Category: DataNucleus Support
  Forum: RDBMS Datastores
  Thread: Error adding class .... to list of persistence-managed classes

Quick Go »

No member browsing this thread
Thread Status: Active
Total posts in this thread: 5
[ Jump to Last Post ]
Post new Thread
Author
Previous Thread This topic has been viewed 917 times and has 4 replies Next Thread
Male dino
Newbie




Joined: Dec 22, 2006
Post Count: 4
Status: Offline
Reply to this Post  Reply with Quote 
Error adding class .... to list of persistence-managed classes
hi everybody,

I have an error using JPOX (jpox-1.1.2.jar). I got the following exception:

javax.jdo.JDODataStoreException: Error adding class com.crif.shuttle.persistence.classes.CS_DOCUMENT to list of persistence-managed classes : Invalid object name 'JPOX_TABLES'.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'JPOX_TABLES'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
at org.jpox.store.rdbms.RDBMSManager.executeStatementUpdate(RDBMSManager.java:489)
at org.jpox.store.rdbms.table.SchemaTable.addClass(SchemaTable.java:248)
at org.jpox.store.rdbms.SchemaAutoStarter.addClass(SchemaAutoStarter.java:254)
at org.jpox.store.StoreManager.registerStoreData(StoreManager.java:256)
at org.jpox.store.rdbms.RDBMSManager.access$1900(RDBMSManager.java:160)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTable(RDBMSManager.java:2662)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTables(RDBMSManager.java:2729)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3227)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2476)
at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2328)
at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:738)
at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:752)
at org.jpox.store.StoreManager.manageClassForIdentity(StoreManager.java:693)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2534)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2495)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2475)
at com.crif.shuttle.persistence.ShuttleManager.insertPhase(ShuttleManager.java:127)
at com.crif.sap.invoicetopostel.InvoiceToPostelManager.main(InvoiceToPostelManager.java:105)

at org.jpox.store.rdbms.SchemaAutoStarter.addClass(SchemaAutoStarter.java:260)
at org.jpox.store.StoreManager.registerStoreData(StoreManager.java:256)
at org.jpox.store.rdbms.RDBMSManager.access$1900(RDBMSManager.java:160)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTable(RDBMSManager.java:2662)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTables(RDBMSManager.java:2729)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3227)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2476)
at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2328)
at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:738)
at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:752)
at org.jpox.store.StoreManager.manageClassForIdentity(StoreManager.java:693)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2534)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2495)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2475)
at com.crif.shuttle.persistence.ShuttleManager.insertPhase(ShuttleManager.java:127)
at com.crif.sap.invoicetopostel.InvoiceToPostelManager.main(InvoiceToPostelManager.java:105)
NestedThrowablesStackTrace:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'JPOX_TABLES'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
at org.jpox.store.rdbms.RDBMSManager.executeStatementUpdate(RDBMSManager.java:489)
at org.jpox.store.rdbms.table.SchemaTable.addClass(SchemaTable.java:248)
at org.jpox.store.rdbms.SchemaAutoStarter.addClass(SchemaAutoStarter.java:254)
at org.jpox.store.StoreManager.registerStoreData(StoreManager.java:256)
at org.jpox.store.rdbms.RDBMSManager.access$1900(RDBMSManager.java:160)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTable(RDBMSManager.java:2662)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTables(RDBMSManager.java:2729)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3227)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2476)
at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2328)
at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:738)
at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:752)
at org.jpox.store.StoreManager.manageClassForIdentity(StoreManager.java:693)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2534)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2495)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2475)
at com.crif.shuttle.persistence.ShuttleManager.insertPhase(ShuttleManager.java:127)
at com.crif.sap.invoicetopostel.InvoiceToPostelManager.main(InvoiceToPostelManager.java:105)

I'm using MS SqlServer 2000

I take the error when I try to give to the 'JPOX_TABLES' table the same owner of all the managed tables. Using the configuration:

... <class name="CS_APPLICATION" table="OTHEROWNER.CS_APPLICATION" identity-type="application"> ....

I solve the problem for the managed tables. I don't know how to solve it for the 'JPOX_TABLES' table. It works only if I give as owner to this table the user specified in the connection URL. But I've not this faculty in a production environtment

Someone had this problem before me?

thanks in advance
Dino
[Dec 22, 2006 2:58:32 PM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest [Link] Report threatening or abusive post: please login first  Go to top 
Male andy
Expert
Member's Avatar

UK
Joined: Mar 13, 2004
Post Count: 5232
Status: Offline
Reply to this Post  Reply with Quote 
Re: Error adding class .... to list of persistence-managed classes
You dont bother quoting the log so we have no idea what SQL is being invoked. Suggest that you look at using "javax.jdo.mapping.Schema", and "javax.jdo.mapping.Catalog", and that you use a recent version of JPOX.
----------------------------------------
-Andy smile
[Dec 22, 2006 3:10:32 PM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male dino
Newbie




Joined: Dec 22, 2006
Post Count: 4
Status: Offline
Reply to this Post  Reply with Quote 
Re: Error adding class .... to list of persistence-managed classes
I changed the versione of JPOX to the 1.1.5 one. I set the 2 properties:

javax.jdo.mapping.Catalog=SJS (this is the database name, isn't it?)
javax.jdo.mapping.Schema=SAPSJSDB

with this connection string:

javax.jdo.PersistenceManagerFactoryClass=org.jpox.PersistenceManagerFactoryImpl
javax.jdo.option.ConnectionDriverName=com.microsoft.sqlserver.jdbc.SQLServerDriver
javax.jdo.option.ConnectionURL=jdbc:sqlserver://sapjavasvl:1433;databaseName=SJS;SelectMethod=cursor
javax.jdo.option.ConnectionUserName=fondau

but I take the same exception; this is the log:

16:26:11,610 (main) INFO [JPOX.JDO] - PersistenceManagerFactory - Vendor: JPOX Version: 1.1.2
16:26:11,641 (main) INFO [JPOX.JDO] - PersistenceManagerFactory initialised for datastore URL=jdbc:sqlserver://sapjavasvl:1433;databaseName=SJS;SelectMethod=cursor driver=com.microsoft.sqlserver.jdbc.SQLServerDriver userName=fondau
16:26:12,360 (main) INFO [JPOX.RDBMS] - ================ DatabaseAdapter ==================
16:26:12,360 (main) INFO [JPOX.RDBMS] - Adapter : org.jpox.store.rdbms.adapter.MSSQLServerAdapter
16:26:12,360 (main) INFO [JPOX.RDBMS] - Datastore : name="Microsoft SQL Server" version="8.00.2040" (major=8, minor=0, revision=2040)
16:26:12,360 (main) INFO [JPOX.RDBMS] - Driver : name="Microsoft SQL Server 2005 JDBC Driver" version="1.1.1501.101" (major=1, minor=1)
16:26:12,360 (main) INFO [JPOX.RDBMS] - ===================================================
16:26:12,454 (main) INFO [JPOX.RDBMS.Schema] - Initialising Catalog "SJS", Schema "" using "SchemaTable" auto-start option
16:26:12,860 (main) ERROR [JPOX.RDBMS.Schema] - Failed to retrieve classes from SchemaTable
16:26:12,860 (main) INFO [JPOX.RDBMS.Schema] - Catalog "SJS", Schema "" initialised - managing 0 classes
16:26:16,704 (main) INFO [JPOX.MetaData] - Parsing MetaData from file "file:/D:/_WA/SAPJ2EE/Source/CrifShuttle/bin/com/crif/shuttle/persistence/classes/package.jdo"
16:26:17,141 (main) INFO [JPOX.MetaData] - Class com.crif.shuttle.persistence.classes.CS_APPLICATION specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.LongIdentity
16:26:17,220 (main) INFO [JPOX.MetaData] - Class com.crif.shuttle.persistence.classes.CS_PHASE specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.LongIdentity
16:26:17,282 (main) INFO [JPOX.MetaData] - Class com.crif.shuttle.persistence.classes.CS_DOCUMENT specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.LongIdentity
16:26:17,345 (main) INFO [JPOX.MetaData] - The class "CS_INVOICE" has had its persistence-capable-superclass set to "com.crif.shuttle.persistence.classes.CS_DOCUMENT" - it wasnt specified in the MetaData.
16:26:17,407 (main) INFO [JPOX.MetaData] - The class "CS_DUNNING" has had its persistence-capable-superclass set to "com.crif.shuttle.persistence.classes.CS_DOCUMENT" - it wasnt specified in the MetaData.
16:26:17,485 (main) INFO [JPOX.MetaData] - Class com.crif.shuttle.persistence.classes.CS_DUNN_INVOICE specified to use "application identity" but no "objectid-class" was specified. Reverting to javax.jdo.identity.LongIdentity
16:26:17,876 (main) INFO [JPOX.RDBMS.Schema] - Managing Persistence of Class : com.crif.shuttle.persistence.classes.CS_DOCUMENT [Table : SAPSJSDB.CS_DOCUMENT, InheritanceStrategy : new-table]
16:26:18,735 (main) ERROR [JPOX.RDBMS.Schema] - Error adding class com.crif.shuttle.persistence.classes.CS_DOCUMENT to list of persistence-managed classes : Invalid object name 'JPOX_TABLES'.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'JPOX_TABLES'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
at org.jpox.store.rdbms.RDBMSManager.executeStatementUpdate(RDBMSManager.java:489)
at org.jpox.store.rdbms.table.SchemaTable.addClass(SchemaTable.java:248)
at org.jpox.store.rdbms.SchemaAutoStarter.addClass(SchemaAutoStarter.java:254)
at org.jpox.store.StoreManager.registerStoreData(StoreManager.java:256)
at org.jpox.store.rdbms.RDBMSManager.access$1900(RDBMSManager.java:160)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTable(RDBMSManager.java:2662)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTables(RDBMSManager.java:2729)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3227)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2476)
at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2328)
at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:738)
at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:752)
at org.jpox.store.StoreManager.manageClassForIdentity(StoreManager.java:693)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2534)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2495)
at org.jpox.AbstractPersistenceManager.getObjectById(AbstractPersistenceManager.java:2475)
at com.crif.shuttle.persistence.ShuttleManager.insertPhase(ShuttleManager.java:127)
at com.crif.sap.invoicetopostel.InvoiceToPostelManager.main(InvoiceToPostelManager.java:105)
[Dec 22, 2006 5:39:31 PM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest [Link] Report threatening or abusive post: please login first  Go to top 
Male andy
Expert
Member's Avatar

UK
Joined: Mar 13, 2004
Post Count: 5232
Status: Offline
Reply to this Post  Reply with Quote 
Re: Error adding class .... to list of persistence-managed classes
javax.jdo.mapping.Catalog=SJS (this is the database name, isn't it?)
javax.jdo.mapping.Schema=SAPSJSDB

This is the log if you ignore setting it to give DEBUG info. That tells you what catalog/schema is supported by the RDBMS, and much more.
----------------------------------------
-Andy smile
[Dec 22, 2006 6:29:21 PM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male dino
Newbie




Joined: Dec 22, 2006
Post Count: 4
Status: Offline
Reply to this Post  Reply with Quote 
Re: Error adding class .... to list of persistence-managed classes
thanx a lot, Andy

I solved my problem. Using the DEBUG level I've found out that the JPOX version was still the 1.1.2 one. I've changed it to the 1.1.5 and now it works

dino
[Dec 27, 2006 11:47:51 AM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest [Link] Report threatening or abusive post: please login first  Go to top 
[ Jump to Last Post ]
Show Printable Version of Thread  Post new Thread

RSS feeds Current timezone is GMT
Mar 11, 2010 7:53:01 AM

Powered by mvnForum 1.2.1 GA (Build: 20 November 2008)
Copyright © 2002-2008 by MyVietnam.net