Re: 2 classes, same table name, different database

2004-11-11 Thread Joose Vettenranta
I forgot to say, that I have different dbuser and different connection for both of dabases. And both connection is described with jdbc-connection-descriptor -element and using :

2 classes, same table name, different database

2004-11-11 Thread Joose Vettenranta
Hi, I have 2 databases, let's call them db1 and db2 in db1 I have table called admin in db2 I have also table called admin but they are not like each other, they have different kind of table structure. for db1 I have a class to access table admin, let's call it net.vettenranta.db1.AdminImpl; for

Re: Re: Simple Inheritance problem with multiple class to one table mapping

2004-11-11 Thread Sylvain Juge
the XDoclet output is the following In fact now it doesn't process the Apartement.java file, and I don't know why because It used to process the file before. However, even if the file was processed by xdoclet, there was no result in the repository file, like now when it's not processed, that's w

Re: LIMIT timeframe?

2004-11-11 Thread jeichels
Thank you for your post Jakob. It sounds like a bit of an effort. I was thinking based on other code perviously posted on the board to get around the problem that it might be a bit easier. I was about to test code people placed on the board previously to get around the problem. I am not su

Recommended ObjectCache for ODMG

2004-11-11 Thread Ashish Rangole
Hi! Which is the recommended Object cache implementation to be used with ODMG. I need something that supports circular references. It's support for transaction isolation should be known, strictest level will also do. How can one disable cache with ODMG, if so desired (when circular references are t

Re: LIMIT timeframe?

2004-11-11 Thread Jakob Braeuchi
hi john, to be hones, my version of the sql-limit stuff was rather basic and didn't work correctly for extents. before we can really use the sql-LIMIT we'll have to change ojb to use a _single_ query for all extents (using the UNION clause). with the current solution using one select for each ex

locking

2004-11-11 Thread David Morales de Frias
Hello¡ i need to update some values in my database, and i want to do something like 'select for update'. As i read, ojb has some locking implemetations, but i don't know how to use it, and i didn't find any documentation. I'm very confused, because i've seen fields in class-descriptor with lock=t

help with locking

2004-11-11 Thread David Morales de Frias
Hello¡ i need to update some values in my database, and i want to do something like 'select for update'. As i read, ojb has some locking implemetations, but i don't know how to use it, and i didn't find any documentation. I'm very confused, because i've seen fields in class-descriptor with lock=t

Re: Simple Inheritance problem with multiple class to one table mapping

2004-11-11 Thread Thomas Dudziak
Sylvain Juge wrote: Here is the XDoclet schema output (repository_user.xml) I removed all irrelevant data to keep it clear. Ahem, I meant the console output when running Ant. The XDoclet module should write out all classes that it processes. Tom

OJB (ODMG) deleting entries in mapping tables by itself- help

2004-11-11 Thread Ashish Rangole
Hi! I have several m:n relationships mapped using intermediate mapping table. I am using version 1.0.rc6. My m:n objects have references to each other via collections of each other. I noticed that after running for sometime most of the entries in such mapping tables got deleted, although I am not d

Re: Re: Simple Inheritance problem with multiple class to one table mapping

2004-11-11 Thread Sylvain Juge
Here is the XDoclet schema output (repository_user.xml) I removed all irrelevant data to keep it clear. Sylvain Juge wrote: > Hi, I'm quite newbie to OJB, and I really need help. > > I've go

Re: arbitrary SQL

2004-11-11 Thread Anthony E. Carlos
Thanks for the help, Robert and Gerhard! I'm pleasantly shocked at how timely your responses were. I wish this was in the FAQs because it's implied that only queries that return something can be done using QueryBySQL. I guess we're doing an end-around with this new code. I must confess also, th

Re: Simple Inheritance problem with multiple class to one table mapping

2004-11-11 Thread Thomas Dudziak
Sylvain Juge wrote: Hi, I'm quite newbie to OJB, and I really need help. I've got one base class "AbstractRoom" and two derived classes "Room" and "Apartement", and I need to store them in one table named "abstract_rooms". The problem is that when I generate repository schema for the database, it's

Re: arbitrary SQL

2004-11-11 Thread Gerhard Grosse
On Thu, 11 Nov 2004 08:33:39 -0600, "Robert r. Sanders" <[EMAIL PROTECTED]> wrote: >I believe you need to do something like: > >java.sql.Connection connection = >persistenceBroker.serviceConnectionManager().getConnection(); >Statement statement = connection.createStatement(); >

Re: arbitrary SQL

2004-11-11 Thread Robert r. Sanders
I believe you need to do something like: java.sql.Connection connection = persistenceBroker.serviceConnectionManager().getConnection(); Statement statement = connection.createStatement(); statement.executeUpdate(...); Anthony E. Carlos wrote: Hello, How do I fire off a an

Re: ODMG - delete referenced objects.

2004-11-11 Thread Grzegorz Pypec
Dnia czwartek, 11 listopada 2004 13:49, Gerhard Grosse napisał: > Instead of tx.checkpoint() you can use ((TransactionExt) tx).flush(), > which flushes all SQL to the DB without commit. > > However, normally OJB does a pretty good job in ordering the SQL > correctly. Could it be that you have some

arbitrary SQL

2004-11-11 Thread Anthony E. Carlos
Hello, How do I fire off a an arbitrary SQL statement that doesn't require a return value? For example, (I already know how to do this using O/R mapping-- this is just a simple example) INSERT INTO colors VALUES ('red'); I've looked at the FAQs, but the only example is for SELECT statem

RE: validation query for connection failed

2004-11-11 Thread Ribi Roland
Hi Thomas I don't know, but perhaps this helps: http://www.websina.com/bugzero/kb/oracle-connection.html This was one problem in our installation. An other problem could be that some Broker stay open after use. I had this behavior in my tomcat-application. After I checked the code where a Persi

Re: ODMG - delete referenced objects.

2004-11-11 Thread Gerhard Grosse
On Wed, 10 Nov 2004 21:26:22 +0100, Grzegorz Pypec <[EMAIL PROTECTED]> wrote: >Hi, > >I have two persistent object in my database: 'film' and 'title'. >The object 'film' has reference to object 'title'. (1:1 relation) > >When I try delete object 'title' in the following way: > > >(...) >

Re: ODMG questions

2004-11-11 Thread Gerhard Grosse
On Wed, 10 Nov 2004 16:15:16 +0100, £ukasz Korzybski <[EMAIL PROTECTED]> wrote: >Dnia ¶roda, 10 listopada 2004 10:02, Gerhard Grosse napisa³: >> On Wed, 10 Nov 2004 01:51:59 +0100, £ukasz Korzybski <[EMAIL PROTECTED]> >> >> wrote: >> >Thanks for reply, >> > >> >Dnia ¶roda, 10 listopada 2004 00:19,

Re: Read locks not released in ReadCommittedStrategy

2004-11-11 Thread Gerhard Grosse
On Wed, 10 Nov 2004 16:14:36 +0100, Armin Waibel <[EMAIL PROTECTED]> wrote: > >ok, will patch the LockStrategy classes to release the read-locks too. >Additionally I will try to make some modifications for better >performance, e.g. in your code snip is done > > >>if (hasReadLock(tx, obj)) > >

Simple Inheritance problem with multiple class to one table mapping

2004-11-11 Thread Sylvain Juge
Hi, I'm quite newbie to OJB, and I really need help. I've got one base class "AbstractRoom" and two derived classes "Room" and "Apartement", and I need to store them in one table named "abstract_rooms". The problem is that when I generate repository schema for the database, it's like if the Apar

Re: validation query for connection failed

2004-11-11 Thread Thomas Franke
Armin Waibel wrote: which version of OJB do you use? We still use db-ojb-1.0.rc6 but we are going to use the current realease. Normally ConnectionFactoryPooledImpl tries 100 times to lookup a valid connection from the DB, so you should get the warning several times before the pool break. Could yo