Hi Neil, your code seems ok. You could find sample beans under jakarta-ojb\src\ejb\org\apache\ojb\ejb in CVS (or shipped with OJB >=0.97)
Seems a configuration problem. - (Only use datasources from the AppServer within the jdbc-connection-descriptor) - use Version >=0.97 - Do you follow the instructions (deployment in EJB based applications / OJB.properties settings) of the 'deployment' doc shipped with OJB? OJB.properties: ConnectionFactoryClass=org.apache.ojb.broker.accesslayer.ConnectionFacto ryPassThroughImpl useAutoCommit=0 ignoreAutoCommitExceptions=true OJBTxManagerClass=org.apache.ojb.odmg.JTATxManager JTATransactionManagerClass=org.apache.ojb.otm.transaction.factory.JBossT ransactionManagerFactory And when using JBoss set eager-release to true: <jdbc-connection-descriptor platform="Hsqldb" jdbc-level="2.0" jndi-datasource-name="java:DefaultDS" username="sa" password="" eager-release="true" /> HTH regards, Armin ----- Original Message ----- From: "Neil Blue" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 15, 2002 1:14 PM Subject: basic database problem using odmg interface from JBoss > Hello, > > I have got a session bean running using the broker in JBoss, to insert data > into an oracle database. The problem however is that when I use the ODMG > interface, the process completes but does not save the data. > > Here is my bean code: > > System.out.println( "Testing bean insert..." ); > > Context context = new InitialContext(); > ODMGFactory factory = ( ODMGFactory ) > context.lookup( "java:/ojb/defaultODMG" ); > Implementation odmg = factory.getInstance(); > String ojbRepository = "repository.xml"; > Database db = odmg.newDatabase(); > db.open( ojbRepository, Database.OPEN_READ_WRITE ); > System.err.println( "Database created" ); > > // make minimol > Simple simple = new Simple(); > simple.setName( "simon" ); > > Transaction tx = odmg.currentTransaction(); > System.err.println( "got transaction" ); > tx.lock( simple, Transaction.WRITE ); > > System.err.println( "closing db" ); > db.close(); > System.err.println( "db closed" ); > > System.out.println( "Done." ); > > is this the right thing to do? > > -- > To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org> > > > -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>