Join tables that has fields with same name

2003-09-09 Thread Viczin Istvn
Hi, I would like to join two table, and they are in 1:n relation, and they have a field with same name. If I add a criteria to this, I get an exception. This exception says, that the field is _ambiguous_. I've logged the SQL query with P6Spy, and it is true, the name of the field appears in the

Deadlocks during OJB internal table access

2003-09-09 Thread Guido Beutler
Hello, I'm using OJB 1.0 rc4 inside of jboss3.2.2rc3 and db2. OJB is running into self generated deadlocks if I access ojb with concurrent ejb clients when using SequenceManagerNextValImpl As a workaround I use SequenceManagerInMemoryImpl but I think this won't work with sequences. If ojb could

Re: Deadlocks during OJB internal table access

2003-09-09 Thread Armin Waibel
Hi Guido, Hello, I'm using OJB 1.0 rc4 inside of jboss3.2.2rc3 and db2. OJB is running into self generated deadlocks if I access ojb with concurrent ejb clients when using SequenceManagerNextValImpl As a workaround I use SequenceManagerInMemoryImpl but I think this won't work with

what is xdoclet-ojb-module status?

2003-09-09 Thread LYNX mail
Hello! I'm interested in xdoclet-ojb module status. I've tried to use it and was a little bit confused due to a set of errors. Environment I used: xdoclet-ojb-module-1.2b3-dev.jar torque-3.0.2.jar MsAccess 2002 The goal of my investigations was to reside xdoclet-ojb tags in java source code,

OrderBy on m:n relationship

2003-09-09 Thread Duma Rolando
I would like to know if it's possible to order the elements retrieved inside a collection reference.If the question is not clear, that's my problem: I have the following code: Query query = new QueryByCriteria(Utr.class, null); _broker.beginTransaction(); Collection allUtr = (Collection)

Re: Deadlocks during OJB internal table access

2003-09-09 Thread Guido Beutler
Hi Armin, Armin Waibel wrote: Hi Guido, Hello, I'm using OJB 1.0 rc4 inside of jboss3.2.2rc3 and db2. OJB is running into self generated deadlocks if I access ojb with concurrent ejb clients when using SequenceManagerNextValImpl As a workaround I use SequenceManagerInMemoryImpl but I think

Re: Repost : NullPointerException in hashCode

2003-09-09 Thread Christian Pesch
Sebastien Cesbron wrote: Am I the only one that have this problem ? No :-) Can anybody tell me what I can do in this situation ? I removed hashCode() and waited for a wise suggestion, what to do :-) -- Christian - To

Re: OrderBy on m:n relationship

2003-09-09 Thread Duma Rolando
Sorry,I'm using OJB 1.0rc3. - Original Message - From: Duma Rolando [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 1:35 PM Subject: OrderBy on m:n relationship I would like to know if it's possible to order the elements retrieved inside a

Collection Descriptors Interfaces

2003-09-09 Thread Thomas Cornet
Hello I've got a problem with collection descriptors and interfaces. My class hierarchy is something like this : class-descriptor class=package.interfaces.InterfaceEntity extent-class class-ref=package.interfaces.InterfacePlace / extent-class

Re: OrderBy on m:n relationship

2003-09-09 Thread Duma Rolando
Sorry again for the post, I found an orderby attribute for the collection-descriptor tag. - Original Message - From: Duma Rolando [EMAIL PROTECTED] To: OJB Users List [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 2:19 PM Subject: Re: OrderBy on m:n relationship Sorry,I'm using

RE: ReportQueryByCriteria and Extents problem

2003-09-09 Thread Charles Anthony
Hi Edson, [snip] When I execute this command, I'm expecting that OJB will issue select max(nu_ordem) from (select nu_ordem from tb_compttpessoa_taxa union select nu_ordem from tb_compttpessoa_percent union select nu_ordem from tb_compttpessoa_script ) that works fine in

Re: what is xdoclet-ojb-module status?

2003-09-09 Thread Thomas Dudziak
The xdoclet ojb module is intended to produce the repository and torque schemas from javadoc tags (your first step). In your second step the problem is that the torque folks decided to include the version number in the names of newer dtd versions which of course breaks older table schemas (which

Re: ReportQueryByCriteria and Extents problem

2003-09-09 Thread Edson Carlos Ericksson Richter
I think UNION is not a problem, but using a SELECT in a FROM clause could be. In any way, I've changed my code to expect more than one value when issuing max() in areas I have extents. Thanks, Edson Richter - Original Message - From: Charles Anthony To: 'OJB Users List'

Re: How to use DUAL

2003-09-09 Thread Roland Carlsson
Hi Edson! The simplest way to do this is to set the date in your value-object. Eg setMyDate(new Date()); and then store the object. Since most databases I tested support higher time-resolutions than whole seconds or in your case (guessing oracle) 1/10 of a second if I remember correctly it

RE: Optimistic Locking Problem

2003-09-09 Thread Mitch Norby
Never mind. Stupid user error. -Original Message- From: Mitch Norby [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 11:49 PM To: '[EMAIL PROTECTED]' Subject: Optimistic Locking Problem We are using 1.0.rc4. It seems as though the optimistic locking attributes (integer) are

Re: How to use DUAL

2003-09-09 Thread Edson Carlos Ericksson Richter
About secure messages, you are right. Excuses to mail list users. About using new Date(), this works fine if my app is j2ee based (like JSP, web services and so on), but my app is Swing (by now client-server) based, and I need to guarantee that workstation (if I use new Date()) has date/time

Re: How to use DUAL

2003-09-09 Thread Roland Carlsson
Hi Edson! I think you should be able to use QueryBySQL to solve the problem. It doesn't require you to return a key. But I'm not sure that will work... i know I can create an object of an already existing mapped class... but i'm not sure if it works for this purpose. If you have the time to make