JPOX

JPOx 1.2.3 maps Java boolean to DB2 (9.1) char and PostGreSQL (8.3.3) bool, while the JDO specification (2.1 page 218 "Table 8: Default jdbc-type") specifies the default is BIT. The consequence is our direct queries such as "where ... [More] boolean_column=0" fail (which work for other JDO impl). I don't see any JDO/JPOx/RDBMS property to generate JDO specification compliant ... [Less]

DB2 has a known limitation of using CLOB, LongVarChar & long VarChar in ". A SELECT DISTINCT statement . A GROUP BY clause . An ORDER BY clause . A column function with DISTINCT . A SELECT or VALUES statement of a set operator other ... [More] than UNION ALL" JPOx 1.2.3 doesn't seem taking that into account: javax.jdo.JDODataStoreException: Error executing JDOQL query ... [Less]

after a few teething problems i now have the basic persistence framework up and running. i have two simple classes, lets call them Cass1 and Class2 if i persist an instance of Class1 by itself, it works just fine. if i persist an instance of ... [More] Class1 followed by an instance of Class2, this also works just fine. [code]Class1 object1 = new Class1(args); Class2 object2 = new Class2(args); ... [Less]

Given SchemaTool 1.2.3 generates DESCRIPTION_X CLOB(1073741824) for DB2 (9.1). However DB2 9.1 complains Error Code: -355 state: 42993 How to limit CLOB length please? JPOx 1.2.3 doesn't seem taking "column/@length", and no RDBMS property silimar to ...

We have about 1200 tables, however "SchemaTool -create" misses 30 tables or so. I've tried on PostGreSQL (8.3.3), DB2 (9.1) & Oracle, same result :-( My current work-around is to run the exactly very same Schema Creation 10 times and merge all ... [More] 10 DDLs. However, I'm still concerned by potential table missing in theory. Any better solution/work-around/suggestion please? [Less]

I'm trying to migrate from eclipse 3.2 to eclipse 3.4 and from jpox to datanucleus. My app is an rcp application and i have deployed all datanucleus jars as eclipse plugins like i did on 3.2, however i have a plugin (jdo2) that doesn't get recognized ... [More] when i try adding it on plugin.xml under "required plugins". This worked like a charm on eclipse 3.2. Has anyone have a workaround or ... [Less]

The manual describes how to store data in Excel sheets, but nothing is said about reading from Excel sheets. Is this now a one-way process, or can I acces information in existing Excel datastores? If so, is there a way of iterating over rows, and ... [More] specifying columns symbolically? I have several spread sheets, where hundreds of rows are arranged in a table-like format and would like to read ... [Less]

When validating an existing schema (in a Firebird DB) I get the following error [quote]13:44:13,644 (main) DEBUG [DataNucleus.Datastore.Schema] - Validating table : X_COWORKERS 13:44:13,654 (main) DEBUG [DataNucleus.Datastore.Schema] - Execution ... [More] Time = 10 ms 13:44:13,664 (main) ERROR [DataNucleus.Datastore] - An exception was thrown while adding/validating class(es) : Expected primary key ... [Less]

Hello Andy, we have already for quite a while a [color=red]JDOObjectNotFoundException[/color] that occurs only with some certain objects while it does not occur with hundreds of other objects (same code, other data). When retrying with the same ... [More] data again (in a new transaction), the exception usually does not occur again. The code location where the exception occurs should never throw a ... [Less]

See http://forums.oracle.com/forums/thread.jspa?threadID=676899&tstart=45 [quote]Oracle's strategic Java persistence product going forward is TopLink. Kodo support and maintenance will continue to be available until the product is eventually retired.[/quote] Another great persistence tool bites the dust seemingly