Re: named query

2008-11-19 Thread Håkon Sagehaug
Hi It did not seem to do the trick, but I'm a little confused, since it's working fine when I just have it in a simple client, and not in a web service. Also if I create the query like this Query query = getEm().createQuery( "SELECT w FROM WorkflowInstance w where w.workflowId=:input");

Re: Firebird issues

2008-11-19 Thread Kevin Sutter
Alexey, Thank you for the great analysis and proposed patches and solutions! We'll attempt to incorporate these shortly. Kevin On Tue, Nov 18, 2008 at 10:23 PM, Alexey Ousov <[EMAIL PROTECTED]> wrote: > Hello Simone and Kevin, > Thanks for replies. After some days of debugging I successfully ex

Re: named query

2008-11-19 Thread Håkon Sagehaug
Hi all My issue was that the web sevice/server was not able to see the jar that I had with my entity files. I had my jar containing the entities inside my web service archive file, then I moved it to the to level apache-tomcat library with my other openjpa jar and dependency, then all worked fine.

Re: @OneToMany/@ManyToOne, Bidirectional, Composite Key

2008-11-19 Thread Fay Wang
Hi, In your test case, you have OneToMany relation from Activity to AssignedActivity. The mappedBy attribute in the OneToMany relation should be the name of the many-to-one field in the related entity that maps this bidirectional relation. Could you change mappedBy to "activity" and try again

Re: @OneToMany/@ManyToOne, Bidirectional, Composite Key

2008-11-19 Thread piltrafeta
Hi Fay, I've done the modification you told me but it's still not working... when i insert new registers the pactId from assignedActivities remains null. I copy the class activity with the modification: @Entity @Table (name="PROJECT_ACTIVITIES") @SequenceGenerator(name = "SEQ_PACT_ID", sequenceN

Re: @OneToMany/@ManyToOne, Bidirectional, Composite Key

2008-11-19 Thread Fay Wang
Hi, Eli, It seems that you want to have pactId as a primary key and join column in the assigned_activities (child) table, and you want the pactId automatically generated in the project_activities (parent) table to fill in the pactId column (it is a primary key column) in the child table. I go

Foreign key field doesn't set populated in descendant class in Join Inheritance

2008-11-19 Thread ruslan
Hi guys. I have a question about join table inheritance. In few words the problem is that foreign key field doesn't get set in descendant class in Join Inheritance. I have 3 tables: authors, books and electronic_books. Here is SQL script: http://pastebin.ca/1259927 AuthorsEntity: http://pastebi

Re: Foreign key field doesn't set populated in descendant class in Join Inheritance

2008-11-19 Thread Pinaki Poddar
Please post the domain classes and test case. Better still, create your JUnit Tests so that they can be included in OpenJPA test corpus. The instructions on how to write a test case for OpenJPA is available in its website [1] [1] http://openjpa.apache.org/howtowritetestcaseforopenjpa.html -- Vi