RE: Unnecesery INNER JOIN

2010-07-16 Thread Russell Collins
In other words, instead of saying this SELECT b.a.id FROM B where B.id = 123 You should have SELECT b.a_id FROM B where B.id = 123 -Original Message- From: Russell Collins [mailto:russell.coll...@mclaneat.com] Sent: Friday, July 16, 2010 9:08 AM To: 'users@openjpa.apache.org

RE: Unnecesery INNER JOIN

2010-07-16 Thread Russell Collins
I guess what I am saying is that this join is necessary. In standard SQL the only way you are going to get relational data from two tables is by joining the tables or performing nested selects. I think the thing you want to do is to just look for the column on table "B" that corresponds to th

RE: Unnecesery INNER JOIN

2010-07-15 Thread Russell Collins
>From the looks of what you have in your query, there has to be a join of some >kind. You are trying to get the "id" of class "A" that is associated with >class "B". If this is not your desire, what are you trying to do? -Original Message- From: QkI [mailto:kukis...@gmail.com] Sent: Th

RE: JPA 3.0

2010-06-26 Thread Russell Collins
I have never tried to use JPA with Stored Procedures so excuse my ignorance. If it is difficult or not available, it would benefit the spec if JPA would easily use stored procedures and views just like it uses tables. The only thing I think would need to be added to a marked-up Entity Object i

RE: OpenJPA 2.0 vs 1.2

2010-03-22 Thread Russell Collins
g/builds/latest/docs/manual/manual.html#jpa_2.0_incompatibilities On Mon, Mar 22, 2010 at 3:02 PM, Russell Collins < russell.coll...@mclaneat.com> wrote: > I could not find this information so I apologize if there has been a > discussion and I missed it. Basically what I am wonde

OpenJPA 2.0 vs 1.2

2010-03-22 Thread Russell Collins
the new 2.0 specification? Russell Collins Sr. Software Engineer McLane Advanced Technology 254.771.6419 [cid:image001.jpg@01CAC9D0.B0DBB610] "Do or do not, there is no try." - Yoda CONFIDENTIALITY NOTICE: The information contained in this elect

RE: MySQL 4.1.22 + Native Query = Callable statements not supported

2010-02-28 Thread Russell Collins
Have you tried using a different MySQL driver? I ran into general database issues when trying to use MySQL 4.X with the latest greatest MySQL Driver. I now use MySQL connector 3.0.17 and have not had database issues and that includes working with OpenJPA 1.2.1 -Original Message- From:

RE: ClassCastException in pcReplaceField

2010-01-22 Thread Russell Collins
.@sun.com [mailto:craig.russ...@sun.com] Sent: Thursday, January 21, 2010 9:45 PM To: users@openjpa.apache.org Subject: Re: ClassCastException in pcReplaceField Hi, On Jan 21, 2010, at 7:23 PM, Russell Collins wrote: > While the initial thought is that the "equals()" method would work, >

RE: ClassCastException in pcReplaceField

2010-01-21 Thread Russell Collins
thrown for another reason. -Original Message- From: yoavsc [mailto:yoa...@gmail.com] Sent: Thursday, January 21, 2010 12:57 AM To: users@openjpa.apache.org Subject: RE: ClassCastException in pcReplaceField Hello, I'm afraid I misunderstand something. Russell Collins wrote: > > Therefore the

RE: ClassCastException in pcReplaceField

2010-01-19 Thread Russell Collins
Based on the code that has been provided I am making the assumption that you are mapping your OneToMany to a Set collection. If this is the case, a Set collection will not allow duplicates. In order to check for duplicates, an object that is getting placed in the Set needs to show how it is un

RE: ClassCastException in pcReplaceField

2010-01-15 Thread Russell Collins
It looks like you are trying to add items to a Set. You will get these casting exceptions if your classes do not implement the IComparable interface. If they do implement the interface, then it is another issue. -Original Message- From: Rick Curtis [mailto:curti...@gmail.com] Sent: Thu

RE: openJPA with EJB3 MySQL on WAS7

2009-12-04 Thread Russell Collins
Just a quick question. Is the table already created or are you trying to use OpenJPA to create the table? -Original Message- From: kpsuk [mailto:keithsec...@yahoo.co.uk] Sent: Friday, December 04, 2009 9:32 AM To: users@openjpa.apache.org Subject: openJPA with EJB3 MySQL on WAS7 Havin

EAO Pattern

2009-09-22 Thread Russell Collins
This is an open-ended question for everyone on the panel. What is your thoughts on the EAO pattern in a JEE environment? Is it useful? Is it just too much overhead? I am trying to really analyze if this is a viable solution for an enterprise system. Russell Collins Sr. Software Engineer

RE: JPA issue [RESOLVED]

2009-07-23 Thread Russell Collins
changing this to openjpa.jdbc.SynchronizeMappings=validate. This still did not work as it was still trying to synchronize schema. I then went into the persistence.xml and explicitly added the property . From then on, everything worked the way it should. Russell Collins Sr. Software Engineer

JPA issue

2009-07-22 Thread Russell Collins
I am having a problem that I believe is associated with the JPA module. I have created some entity objects and EJB's. When I run through the continuous build process, it deploys the objects to Geronimo (where OpenJPA is the persistence layer). The first time I try to access the object, the v

RE: FW: Memory leak

2009-07-22 Thread Russell Collins
Correct. Russell Collins Sr. Software Engineer McLane Advanced Technology "Do or do not, there is no try." - Yoda -Original Message- From: Patrick Linskey [mailto:plins...@gmail.com] Sent: Wednesday, July 22, 2009 9:43 PM To: users@openjpa.apache.org Subject: Re: FW: Memory

RE: FW: Memory leak

2009-07-22 Thread Russell Collins
I am using Geronimo to create my EntityManager. Russell Collins Sr. Software Engineer McLane Advanced Technology "Do or do not, there is no try." - Yoda -Original Message- From: Patrick Linskey [mailto:plins...@gmail.com] Sent: Wednesday, July 22, 2009 7:49 PM

RE: FW: Memory leak

2009-07-22 Thread Russell Collins
I am using the openjpa within the Geronimo container. Is there a way that I can tell Geronimo to do this or is this a question for the Geronimo group? Russell Collins Sr. Software Engineer McLane Advanced Technology "Do or do not, there is no try." - Yoda -Original Message

RE: FW: Memory leak

2009-07-22 Thread Russell Collins
Is there a configuration setting or work around for this in the meantime? Russell Collins Sr. Software Engineer McLane Advanced Technology "Do or do not, there is no try." - Yoda -Original Message- From: David Minor [mailto:davemi...@gmail.com] Sent: Wednesday, July 22, 200

RE: Date Problem

2009-05-20 Thread Russell Collins
Thanks Mike. I included openjpa-1.2.1.jar in my client app and everything works great. Russell Collins Sr. Software Engineer McLane Advanced Technology "Do or do not, there is no try." - Yoda -Original Message- From: Michael Dick [mailto:michael.d.d...@gmail.com] Sent:

Date Problem

2009-05-19 Thread Russell Collins
ing and removing @Temporal etc. Oh one more thing, this is a MySQL database that I am trying to access. Please give me any help you can. Thanks. Russell Collins