Hi Yuri, we had a problem with sequence key generator that apears in 0.9.9 and 0.9.9.1 releases of Castor. The problem is tracked by:
http://jira.codehaus.org/browse/CASTOR-1264 and has been resolved in CVS some days ago. As the exception you get is a different one and max key generator also failed for you i think you are hit by something else. I can not see any mistake in the information you provided. For me it looks like your mapping have not been loaded. Can you please also post your jdo-conf.xml and the code how you initialized 'connection' which should be an instance of Database interface? Regards Ralf Yuri Green schrieb: > Hi everyone, > > As a simple test before I wired up the rest of my code to use Castor I set > up a simple table in my Oracle server with two columns in it to test JDO and > make sure everything was copasetic. As it stands, I can't seem to get a > class defined in my mapping file to use a key-generator I defined for an > existing sequence in Oracle. I even tried all of the other algorithms like > MAX with no success. I'm in a real bind here because without the ability to > create or use a built-in auto-incrimination system here it renders the > persistence framework useless. Here's the SQL for my test table and the > related sequence: > > CREATE TABLE test ( > id VARCHAR2(32) PRIMARY KEY, > test_field VARCHAR2(32) NOT NULL > ); > > CREATE SEQUENCE test_id_seq INCREMENT BY 1 START WITH 1; > > Here's what's in my mapping.xml file: > > <key-generator name="SEQUENCE" alias="A"> > <param name="sequence" value="test_id_seq"/> > </key-generator> > > <class name="com.sourceout.db.object.Test" identity="id" key-generator="A"> > <description>test table</description> > <map-to table="test" /> > <field name="id" type="string"> > <sql name="id" type="varchar" /> > </field> > <field name="testField" type="string"> > <sql name="test_field" type="varchar" /> > </field> > </class> > > Here's the contents of com.sourceout.db.object.Test: > > public class Test > { > String id = null; > String testField = null; > > public Test() { > > } > > /** > * @return Returns the id. > */ > public String getId() { > return id; > } > > /** > * @param id The id to set. > */ > public void setId(String id) { > this.id = id; > } > > /** > * @return Returns the testField. > */ > public String getTestField() { > return testField; > } > > /** > * @param testField The testField to set. > */ > public void setTestField(String testField) { > this.testField = testField; > } > } > > When I try to run my test code: > > Test test = new Test(); > test.setTestField("some test data"); > > connection.begin(); > connection.create(test); > connection.commit(); > connection.close(); > > I get: > > PersistenceException: non persistence capable: com.sourceout.db.object.Test > > Now this seems like the most vanilla test I can run and I've been sifting > through bug reports and the documentation all day trying to find an answer > but with no luck at all. The idea here seems simple, just set the "id" field > using a key-generator or a predefined Oracle trigger so that the coder > doesn't have to know about the current value of the id field to do a simple > insert with the interesting data. I can't even get the pre-existing Oracle > side trigger approach to work by sticking in a <param name="trigger" > value="true"/> info my <key-generator> definition and loading up the trigger > PL/SQL. > > I'm in a real bind here. Is this a known bug that's getting worked on > because I didn't see anything specific to my example in the bug database. No > one else seems to be experiencing this so am I doing something wrong or am I > the first to try this in this environment? > > Yuri Green > CTO > sourceOut Inc. > e: [EMAIL PROTECTED] > c: 510.305.8634 > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- -- Syscon Ingenieurbüro für Meß- und Datentechnik GmbH Ralf Joachim Raiffeisenstraße 11 D-72127 Kusterdingen Germany Tel. +49 7071 3690 52 Mobil: +49 173 9630135 Fax +49 7071 3690 98 Email: [EMAIL PROTECTED] Web: www.syscon-world.de ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
