Re: Fw: help on saving obj using relations

2008-04-17 Thread Gustav Weber
> I never said that "demo36" is an example of a > program that has the issue > I've described in past news! > That sample correctly operates, because it does not > use relationships > defined as you described! I applogize. That was my error :( : I falsely supposed it's the same example because of

Re: Fw: Fw: help on saving obj using relations

2008-04-17 Thread Michael Gentry
Well, it sounds like you did something like "task = dataContext.newObject(Task.class)" and then "employee.setTask(task)", which would definitely cause an insert of a new task (and the same for department). If you have an existing task, it should only define the relationship between the employee an

Fw: Fw: help on saving obj using relations

2008-04-17 Thread Mauro Carniel
I'll try to provide the app but... not for today. Anyway thanks for now. Cheers, Mauro - Original Message - From: "Michael Gentry" <[EMAIL PROTECTED]> To: Sent: Thursday, April 17, 2008 6:04 PM Subject: Re: Fw: help on saving obj using relations Could you include a snippet of your

Re: Fw: help on saving obj using relations

2008-04-17 Thread Michael Gentry
Could you include a snippet of your code? On Thu, Apr 17, 2008 at 12:00 PM, Mauro Carniel <[EMAIL PROTECTED]> wrote: > I never said that "demo36" is an example of a program that has the issue > I've described in past news! > That sample correctly operates, because it does not use relationships >

Fw: help on saving obj using relations

2008-04-17 Thread Mauro Carniel
I never said that "demo36" is an example of a program that has the issue I've described in past news! That sample correctly operates, because it does not use relationships defined as you described! When I tried to define relationships using Cayenne modeler the problem on inserting arised. I fo

Re: help on saving obj using relations

2008-04-17 Thread Michael Gentry
I looked at: http://oswing.svn.sourceforge.net/viewvc/oswing/trunk/srcdemo/demo36/auto/_EmpVO.java?revision=214&view=markup And I don't believe you have modeled your relationships correctly. You manually created a get/setDept() and get/setTask() in the subclass: http://oswing.svn.sourceforge.net

Re: help on saving obj using relations

2008-04-17 Thread Gustav Weber
I guess Mauro forgot to mention an important aspect: The situation appeared while integrating Cayenne with OpenSwing: http://oswing.sourceforge.net/ and the problem he describes can be seen/reproduced from the code example in "srcdemo/demo36" from the project's Sourceforge SVN repository: http://

Re: Cayenne Modeler Plugin State Changes?

2008-04-17 Thread Michael Gentry
Hi Gustav, You are completely right. I've wanted to do a DBEdit clone for Cayenne (since DBEdit no longer runs on OS X/Leopard). I find that tool to be amazingly valuable. The two options are to make a standalone or to hack it into CM (which has a lot of good plumbing needed already). Maybe th

Re: Cayenne Modeler Plugin State Changes?

2008-04-17 Thread Gustav Weber
> AFAIK no work has been done on that to date. No > spare bandwidth :-/ I undersand :(. It's a pitty that JPA seems to have a higher priority than cayenne modeler :( . Gustav. P.S. Plug-ins would open the way to many contributions that are not possible right now. __

help on saving obj using relations

2008-04-17 Thread Mauro Carniel
Hi! Maybe someone in the past has already met this issue, so sorry if I ask it again! I've got 3 tables: employee, depts and tasks having 2 fk: one from employees to depts and one from employees to tasks. I've modeled both tables and relations using modeler. After that I created a simple appli

Re: Cayenne Modeler Plugin State Changes?

2008-04-17 Thread Andrus Adamchik
AFAIK no work has been done on that to date. No spare bandwidth :-/ Andrus On Apr 17, 2008, at 4:44 PM, Gustav Weber wrote: Are there any changes to the state of the plugin support in cayenne modeler? Is there a final framework decided? Or maybe an internal solution? Or maybe there are new p

Cayenne Modeler Plugin State Changes?

2008-04-17 Thread Gustav Weber
Are there any changes to the state of the plugin support in cayenne modeler? Is there a final framework decided? Or maybe an internal solution? Or maybe there are new players(plug-in frameworks) in the mean time? More users (me included) would have improvements to cayenne modeler if it would be p

Re: Stored proc returning result set (and output params) with MS SQL server

2008-04-17 Thread Andrus Adamchik
So Cayenne calls the sp in the following format: {? = call spXXX(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} In your JDBC test you do it like this: { call spXXX(?, ?, ?, ?, ?, ?, ?, ?, ?, ?) } I.e. no return value is specified. So what if you uncheck "returning value" checkbox for this stored proc

Re: Hollow Object issue

2008-04-17 Thread Malcolm Edgar
OK I found my problem it, I had the foreign key in a related DbEntity defined as a BINARY. I will close the issue. regards Malcolm Edgar On Thu, Apr 17, 2008 at 8:18 PM, Andrus Adamchik <[EMAIL PROTECTED]> wrote: > > On Apr 17, 2008, at 1:13 PM, Malcolm Edgar wrote: > > Hi Andrus, > > > > the

Re: Hollow Object issue

2008-04-17 Thread Andrus Adamchik
On Apr 17, 2008, at 1:13 PM, Malcolm Edgar wrote: Hi Andrus, the column is a MySQL 5.0 BIGINT, I have tried changing this to an INTEGER and I still had the same problem. regards Malcolm Edgar So it is BIGINT on MySQL end and in the Cayenne model? Please doublecheck that you don't map i

Re: Hollow Object issue

2008-04-17 Thread Malcolm Edgar
Hi Andrus, the column is a MySQL 5.0 BIGINT, I have tried changing this to an INTEGER and I still had the same problem. regards Malcolm Edgar On Thu, Apr 17, 2008 at 8:08 PM, Andrus Adamchik <[EMAIL PROTECTED]> wrote: > > On Apr 17, 2008, at 12:48 PM, Malcolm Edgar wrote: > > Caused by: java.s

Re: Hollow Object issue

2008-04-17 Thread Andrus Adamchik
On Apr 17, 2008, at 12:48 PM, Malcolm Edgar wrote: Caused by: java.sql.SQLException: Cannot convert class [B to SQL type requested due to java.lang.ClassCastException - [B at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java: 2744) So I assume that "schema_config_oid" is

Re: Hollow Object issue

2008-04-17 Thread Malcolm Edgar
Some more analysis on this problem the ObjectId singleValue value is a byte[] of the table primary key value "3456", and the ObjectId is returning the raw byte array as the single primary key value. This is making a mess of Cayenne refreshing objects, lazy loading, etc. The environment I am using