Eclipse Community Forums: EMF "Technology" (Ecore Tools, EMFatic, etc)

Help

Home

Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » Teneo with JPOX-1.1.2

Show: Today's Messages :: Show Polls :: Message Navigator

Teneo with JPOX-1.1.2 [message #51133]

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)

Report message to a moderator

Re: Teneo with JPOX-1.1.2 [message #51217 is a reply to message #51133]

Wed, 20 September 2006 14:52

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

Hi Steffen,
I have worked yesterday on the change to jpox 1.1.2 but I am not finished with it yet. At this point
I do not know if I am ready with it this or next week.

gr. Martin

Steffen Neumann wrote:
> 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)

--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org

Report message to a moderator

Re: Teneo with JPOX-1.1.2 [message #51349 is a reply to message #51217]

Thu, 21 September 2006 06:14

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

Hi Steffen,
I have upgraded Teneo to work with jpox 1.1.2. This is available from cvs.
Probably next week there will be a build which includes this.

gr. Martin

Martin Taal wrote:
> Hi Steffen,
> I have worked yesterday on the change to jpox 1.1.2 but I am not
> finished with it yet. At this point I do not know if I am ready with it
> this or next week.
>
> gr. Martin
>
> Steffen Neumann wrote:
>> 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)
>
>

--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org

Report message to a moderator