| Teneo with JPOX-1.1.2 [message #591429] |
Wed, 20 September 2006 11:48 |
 Steffen Neumann
Messages: 41
Registered: July 2009 |
Member |
|
|
Hi,
after a pause I am updateing my project from some oldish
elver-0.7.x version to teneo. Here is the summary what works,
and where I encountered problems:
If I use inheritance strategy superclass, I get an error
from the database, this might be related to bug #154757:
13505 INFO JPOX.RDBMS - Creating table "SEQUENCE_TABLE"
javax.jdo.JDODataStoreException: Insert request failed: INSERT IGNORE INTO
"PARAMTYPE"
("PARAMTYPE_ID","MZ_RANGE_STOP","MZ_RANGE_START_ESET", "MZ_RANGE_STOP_ESET","MS_LEVEL","MZ_RANGE_START","MS_LEVEL_ESET ","DTYPE","ACQSPECIFICATIONTYPE_ACQUISITION_IDX","ANALYZERLISTTYPE_ANALYZER_IDX ")
VALUES (?,?,?,?,?,?,?,?,?,?)
at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertReq uest.java:412)
...
at de.ipb.msbi.Mzdata.commandline.BatchImport.main(BatchImport. java:124)
NestedThrowablesStackTrace:
org.postgresql.util.PSQLException: ERROR: null value in column
"ACQ_NUMBER" violates not-null constraint
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorRespons e(QueryExecutorImpl.java:1512)
So I use the joined-subclass, and things work fine
against an 8.x postgres database.
With JPOX-1.1.1 against an Oracle Database using ojdbc14.jar I get
155248 INFO JPOX.Store.Poid - Creating Repository for IDs in
the datastore
155248 INFO JPOX.RDBMS - Creating table SEQUENCE_TABLE
javax.jdo.JDOFatalInternalException: Somehow
org.jpox.store.rdbms.mapping.oracle.OracleBlobRDBMSMapping.s etObject()
was called, which should have been impossible!
at
org.jpox.store.rdbms.mapping.RDBMSMapping.setObject(RDBMSMap ping.java:217)
at
org.jpox.store.mapping.SerialisedReferenceMapping.setObject( SerialisedReferenceMapping.java:117)
width classes12.jar it is
Trying to persist
/home/sneumann/eclipse-3.2/de.ipbhalle.msbi.mzdata/tt4_Batch 1_1 1.mzdata
javax.jdo.JDODataStoreException: postInsert() failed: SELECT
THIS."VALUE" FROM DATATYPE THIS WHERE (THIS.DATATYPE_ID = ?) FOR UPDATE
at
org.jpox.store.rdbms.mapping.oracle.OracleArrayMapping.postI nsert(OracleArrayMapping.java:272)
at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertReq uest.java:421)
....
NestedThrowablesStackTrace:
java.sql.SQLException: Unsupported feature
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java: 269)
at
oracle.jdbc.dbaccess.DBError.throwUnsupportedFeatureSqlExcep tion(DBError.java:690)
at oracle.sql.BLOB.setBytes(BLOB.java:963)
at
org.jpox.store.rdbms.mapping.oracle.OracleArrayMapping.postI nsert(OracleArrayMapping.java:252)
at
org.jpox.store.rdbms.request.InsertRequest.execute(InsertReq uest.java:421)
With the 10g JDBC driver (both classes12 and ojdbc14) I get
> 2256 ERROR JPOX.RDBMS.SCHEMA - Failed initialising database. Exception : Error accessing database MetaData
> javax.jdo.JDODataStoreException: Error accessing database MetaData
> at org.jpox.store.rdbms.adapter.DatabaseAdapter.<init>(DatabaseAdapter.java:434)
> at org.jpox.store.rdbms.adapter.OracleAdapter.<init>(OracleAdapter.java:135)
....
> at de.ipb.msbi.Mzdata.commandline.BatchImport.main(BatchImport. java:62)
> NestedThrowablesStackTrace:
> java.sql.SQLException: ORA-01722: invalid number
>
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseE rror.java:112)
....
So this is why I really need JPOX-1.1.2, which has fixes
on Oracle Handling: Jpox-Bugs and
Teneo with JPOX-1.1.2 doesn't work, afaics the signature
of the org.jpox.store.StoreManager.addClasses() changed,
it has an additional attribute now, therefore the exception:
NoSuchMethodError: org.jpox.store.StoreManager.addClasses
1715 [main] INFO
org.eclipse.emf.teneo.classloader.ClassClassLoaderStrategy - Class
loader strategy set to:
org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
2195 [main] INFO JPOX.RDBMS - ================ DatabaseAdapter
==================
2195 [main] INFO JPOX.RDBMS - Adapter :
org.jpox.store.rdbms.adapter.PostgreSQLAdapter
2195 [main] INFO JPOX.RDBMS - Datastore : name="PostgreSQL"
version="8.1.4" (major=8, minor=1, revision=4)
2195 [main] INFO JPOX.RDBMS - Driver : name="PostgreSQL Native Driver"
version="PostgreSQL 8.1 JDBC3 with SSL (build 404)" (major=8, minor=1)
2195 [main] INFO JPOX.RDBMS -
===================================================
2238 [main] WARN JPOX.RDBMS - Default Catalog name "mzdata" has been
specified yet the Database Adapter (JDBC driver) doesnt support
specification of catalog name in table definitions !
2311 [main] INFO JPOX.RDBMS - Creating table "DELETEME1158748607362"
2359 [main] INFO JPOX.RDBMS.Schema - Catalog Name could not be
determined for this datastore
2359 [main] INFO JPOX.RDBMS - Dropping table "DELETEME1158748607362"
2366 [main] INFO JPOX.RDBMS.Schema - Initialising Catalog "", Schema
"public" using "SchemaTable" auto-start option
2435 [main] INFO JPOX.RDBMS.Schema - Catalog "", Schema "public"
initialised - managing 0 classes
Exception in thread "main" java.lang.NoSuchMethodError:
org.jpox.store.StoreManager.addClasses([Ljava/lang/String;Lo rg/jpox/ClassLoaderResolver;)V
at
org.eclipse.emf.teneo.jpox.JpoxDataStore.createSchema(JpoxDa taStore.java:420)
at
org.eclipse.emf.teneo.jpox.JpoxDataStore.initialize(JpoxData Store.java:183)
at
de.ipb.msbi.Mzdata.commandline.BatchImport.createPersistence Manager(BatchImport.java:160)
at de.ipb.msbi.Mzdata.commandline.BatchImport.main(BatchImport. java:62)
|
|
|
Powered by
FUDForum. Page generated in 1.77309 seconds
] 
Search
Help
Register
Login
Home
