error in JBoss/OJB but not standalone

2004-01-06 Thread Gunnar Hilling
Hello! I got an application which writes some data to the database. when running in standalone mode, all works fine thought I have to put one tx.flush() statement into my code because I would get a foreign key violation otherwise (I think this has to do with the order in that the inserts are

problem running in jboss

2004-01-05 Thread Gunnar Hilling
Hello, when using identical code, working in standalone environment in jboss, the following error is thrown: 12:30:32,012 INFO [TxConnectionManager] throwable from unregister connection java.lang.IllegalStateException: Trying to return an unknown connection2! [EMAIL PROTECTED] ... ...

Query for java.util.Date

2004-01-04 Thread Gunnar Hilling
Hello, How can I do a PBQuery for a field of Type java.sql.Date in the DB, java.util.Date in Java. criteria.add(date, new Date()); won't work (see also stack trace) Thanks a lot, -Gunnar [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException during the execution of the query

Re: Query for java.util.Date

2004-01-04 Thread Gunnar Hilling
Ok, after some reflection I came to the conclusion that using java.sql.Timestamp is the solution. -Gunnar - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

identical code fails one place, works in an other

2004-01-03 Thread Gunnar Hilling
Hello, I got a serious problem with a strange class cast exception: Collection ress=tipp.getReservierungen(); Iterator j=ress.iterator(); causes a ClassCassException in the second line, but only in one program, an other one works with the same repository (snippet): collection-descriptor

additional info

2004-01-03 Thread Gunnar Hilling
when using an odmg-query instead of a pb-Query (in the code that fails to execute), I get the following error: What is the reason for this? I have the db openend read-write, Transaction is is also open, Any clue? -Gunnar [org.apache.ojb.odmg.TransactionImpl] ERROR: Locking obj [EMAIL

Re: Strange error.../more info

2004-01-02 Thread Gunnar Hilling
Sorry folk, I think the reason was that I had Implicit Locking set to false... Perhapts nevertheless interesting to know the cause... Regards, -Gunnar - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

out of memory

2004-01-02 Thread Gunnar Hilling
Hello, what can I do to prevent Out of Memory-Errors when working on large datasets? I tried to do tx.commit(); tx.begin(); after doing part of the (big) job, but I didn't succeed. Do I have to empty the Cache explicitly? What is recommended? I create the objects that cause the error in my

Re: out of memory

2004-01-02 Thread Gunnar Hilling
On Fri, 02 Jan 2004 16:21:06 +0100, Armin Waibel wrote: Hi, Gunnar Hilling wrote: Hello, what can I do to prevent Out of Memory-Errors when working on large datasets? I tried to do tx.commit(); tx.begin(); after doing part of the (big) job, but I didn't succeed. Do I have to empty

Strange error...

2004-01-01 Thread Gunnar Hilling
Hello, Could please anyone help me in finding the reason for the following error: It occurs when creating a bunch of new objects ... [org.apache.ojb.broker.accesslayer.JdbcAccessImpl] ERROR: SQLException during the execution of the insert (for a org.apache.ojb.odmg.collections.DListEntry_2):

Re: Strange error...

2004-01-01 Thread Gunnar Hilling
Is it possible that the reason is a change in my datamodel: I added an additional ojb collection, backed by a DList. My old objects in the db don't have this dlist. I assume, ojb tries to load the dlist and doesn't find it. Am I right? How can I fix this?? Thanks a lot. -Gunnar

Re: Strange error.../more info

2004-01-01 Thread Gunnar Hilling
I've developed a simple code snippet to reproduce the error: Produkt prod=(Produkt)res.get(0); Zertifikat zert=new Zertifikat(); TextData xml=new TextData(xml, tach); TextData plain=new TextData(plain, tach);

Rollback not working

2004-01-01 Thread Gunnar Hilling
When trying code i catch exception and do a tx.abort() when an error occurs. But when the error is caused by an SQLException during tx.commit() all changes done are written to the database... this is a real problem for me. Shouldn't the db-commit be all or nothing (rc5, postgres). -Gunnar

ODMG update

2003-12-30 Thread Gunnar Hilling
Hello! I got the following serious problem (RC5): Using the following code, only one (the last) of the Zertifikat-Objects is updated (it has two foreignkeys pointing to TextData). Any clue? This ist a 1:1-Relation from Zertifikat to TextData. There is currently no foreign key constraint for the

ODMG update (additional info)

2003-12-30 Thread Gunnar Hilling
following a snippet from the generated xml-descriptor: reference-descriptor name=schein class-ref=de.infomantis.lotto.business.Zertifikatschein auto-retrieve=true foreignkey field-ref=scheinId/ /reference-descriptor reference-descriptor

questions about tx.lock() and a feature request

2003-12-30 Thread Gunnar Hilling
Hello, 1.) I was just trying to update data with odmg and found that using implicit locking is quite tricky because it seems to result in locking the same Objects multiple times eventually. Is this assumption correct? If so, is it a good advice to turn implicit locking off with

Re: ODMG update

2003-12-30 Thread Gunnar Hilling
Hi! Hi Gunnar, I will try to write a test case for your problem. By the way, does your test pass when you switch back to old DList implementation class in OJB.properties? I think I found the problems in my code. It was caused by implicit locking. All worked well when I turned implicit

Jboss (3.2.3) Session Bean with RC5

2003-12-30 Thread Gunnar Hilling
Hello all! I got serious problems integrating ojb-rc5 (using odmg) into jboss. All works fine when testing with MBeans. In a stateless session bean selecting data I get an error: [org.jboss.resource.connectionmanager.CachedConnectionManager] Closing a connection for you. Please close them

postgresql clob

2003-11-30 Thread Gunnar Hilling
I know this has been asked before but I couldn't find a satisfying answer: What do I have to do to use CLOBs in PostgreSQL? Is the patched driver enough? Do I have to follow the the proposal on db.apache for postgresql/CLOB (It is sometimes referred to as outdated). Thanks a lot, -Gunnar

postgresql clob/alternatives

2003-11-30 Thread Gunnar Hilling
...or are there alternatives for storing long character data (working in postgreSQL again. Loading VARBINARY seems also not to work correctly). -Gunnar - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

xdoclet bug

2003-11-18 Thread Gunnar Hilling
Hello, when generating my schema file xdoclet will always close index-tags with /unique so I have to fix this afterwards. I would fix it myself but the sources for the doclet module don't seem to be available via CVS. Could anyone help me? Regards, -Gunnar

Re: xdoclet bug

2003-11-18 Thread Gunnar Hilling
Thanks, runs OK now, -Gunnar - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

m:n mapping, referential integrity

2003-11-09 Thread Gunnar Hilling
Hello, I just tried m:n anonymous mapping, using xdoclet generated descriptors. Seems to work fine except it's possible to delete from object from one side of the relation whithout cascading or foreign key constraint being thrown althoug this is definetly a violation of the DB-Rules. This will

Re: very strange problem with foreign keys

2003-11-07 Thread Gunnar Hilling
On Tue, 04 Nov 2003 22:45:43 +, Oleg Nitz wrote: Hi, Gunnar, Are you using ODMG or OTM? Is it fresh CVS version of OJB or one of the releases? Which one? ODMG, the version (CVS) is now (7.11.) about 4 days old. -Gunnar

very strange problem with foreign keys

2003-11-03 Thread Gunnar Hilling
Hello! I got the following code: for (int i = 0; i 10; i++) { Zertifikat zertifikat = new Zertifikat(); tree.addZertifikat(zertifikat); Iterator iter=tipps.iterator(); while(iter.hasNext()){ AbstractTipp tipp=(AbstractTipp)iter.next(); new Reservierung(new Date(),

query hangs

2003-11-03 Thread Gunnar Hilling
I just stepped into another problem. In the following scenario the query hangs. postmaster (postgresql) and java are running on 100%, I got to stop the process manually: tx=(TransactionExt)odmg.newTransaction(); tx.begin(); System.out.print(\none!\n); OQLQuery query = odmg.newOQLQuery();

Re: query hangs

2003-11-03 Thread Gunnar Hilling
Sorry, after short investigation I found that I needed to delete my refresh=true tags in my repository.xml. Now all queries work fine (seemed to be a problem caused by circular updates). I think refresh=true isn't usually necessary anyway or is it? Thanks, -Gunnar

Re: odmg/foreign key contraint fails

2003-10-30 Thread Gunnar Hilling
By the Way: I'm using ManageableSet for my Collections (both) and ojb from cvs (maybe one week old). -Gunnar - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: odmg/foreign key contraint fails

2003-10-30 Thread Gunnar Hilling
Hi Gerhard, At first I'd like to thank You for the hints! Hi again, According to the docs, the auto-xy options should be left at their defaults for ODMG to work correctly. I'm not sure how this really affects things, but obviously something goes wrong with auto-update=true. The

native db inheritance

2003-10-30 Thread Gunnar Hilling
Hello, and now for something completely different: are there any plans to support the native inheritance feature of e.g. postgres for mapping of object hierarchies? Is there any O/R-Mapper that supports this feature? Are there special reasons not to work this way? Thanks -Gunnar

odmg/foreign key contraint fails

2003-10-29 Thread Gunnar Hilling
Hello, I got a problem with the following code snippet: tx.begin(); System.out.println(creating +3*NUM+ records); t0=System.currentTimeMillis(); for(int i=0; iNUM; i++){ customer=new Customer(no, one, here, +System.currentTimeMillis(), eternity, 2, new Date());

RE: odmg/caching problem?

2003-10-10 Thread Gunnar Hilling
On Fri, 10 Oct 2003 14:50:44 +1300, Shane Mingins wrote: -Original Message- From: Gunnar Hilling [mailto:[EMAIL PROTECTED] Shane said: By using the auto-insert/update settings and the PersistenceBroker I get what I expect. So far this is also working with odmg in my test

odmg/caching problem?

2003-10-09 Thread Gunnar Hilling
Hello, I got the following small program (snippet): Customer customer=new Customer(no, one, here, 0, , 2, null); tx = odmg.newTransaction(); tx.begin(); db.makePersistent(new Certificate(Z1\n, customer)); db.makePersistent(customer); tx.commit();

Re: odmg/caching problem?

2003-10-09 Thread Gunnar Hilling
Additional Detail: Bothe the customer and the certificate are available when being created, only the relation (Collection) of the newly created customer is not updated when querying ... Hello, I got the following small program (snippet): Customer customer=new Customer(no, one,

Collections/ODMG

2003-10-08 Thread Gunnar Hilling
Hello! Why does the following Code: Customer customer=new Customer(no, one, here,0, , 2, new Date()); for(int i=0; i3; i++){ Transaction tx = odmg.newTransaction(); tx.begin(); tx.lock(customer, Transaction.WRITE); customer.addSchein(new certificate(%PS1\n, customer));