Re: Wrong SQL statement being generated

2012-04-27 Thread mwalter
** push ** -- View this message in context: http://openjpa.208410.n2.nabble.com/Wrong-SQL-statement-being-generated-tp7470306p7505761.html Sent from the OpenJPA Users mailing list archive at Nabble.com.

Re: element column of the associated table is null

2012-04-27 Thread CarpathianAnonymous
Hi Rick, Thank's a lot for you help. For the moment I will implement the 2nd solution. I've also added the bug to JIRA. https://issues.apache.org/jira/browse/OPENJPA-2181 https://issues.apache.org/jira/browse/OPENJPA-2181 -- View this message in context:

Re: column already exists....column reserved word

2012-04-27 Thread Jason
Rick, When I set that property, I get the following build time error: [ERROR] Failed to execute goal org.codehaus.mojo:openjpa-maven-plugin:1.2:sql (enhancer) on project mapseq-dao-api: Execution enhancer of goal org.codehaus.mojo:openjpa-maven-plugin:1.2:sql failed:

Re: column already exists....column reserved word

2012-04-27 Thread Rick Curtis
Jason - What do you have set for properties in your persistence.xml file? Thanks, Rick On Fri, Apr 27, 2012 at 9:52 AM, Jason jdr0...@renci.org wrote: Rick, When I set that property, I get the following build time error: [ERROR] Failed to execute goal

Re: column already exists....column reserved word

2012-04-27 Thread Jason
Rick, Here are my properties: property name=openjpa.jdbc.MappingDefaults value=ForeignKeyDeleteAction=restrict, JoinForeignKeyDeleteAction=restrict / property name=openjpa.Log value=DefaultLevel=WARN, Runtime=INFO, Tool=INFO, SQL=WARN / property

Re: column already exists....column reserved word

2012-04-27 Thread Rick Curtis
How are you configuring your database connection? On Fri, Apr 27, 2012 at 10:46 AM, Jason jdr0...@renci.org wrote: Rick, Here are my properties: property name=openjpa.jdbc.**MappingDefaults value=ForeignKeyDeleteAction=**restrict, JoinForeignKeyDeleteAction=**restrict /

Re: column already exists....column reserved word

2012-04-27 Thread Jason
Rick, I have an application that sits on top of a Karaf container. One of my maven projects is an osgi bundle which deploys a datasource as a service. I, then, have the following in the persistence.xml file to get that datasource:

Re: column already exists....column reserved word

2012-04-27 Thread Rick Curtis
Jason - Sorry, try the following property[1] looks like I had you try the wrong value for this prop before(sorry). I'll try to load postgres up on my machine this afternoon if it doesn't work. Thanks, Rick [1] property name=openjpa.jdbc.DBDictionary

Re: Wrong SQL statement being generated

2012-04-27 Thread Rick Curtis
I'm unable to recreate this problem on MySQL... are there any Oracle experts that want to give this one a crack? On Fri, Apr 27, 2012 at 6:01 AM, mwalter marc.wal...@sbb.ch wrote: ** push ** -- -- *Rick Curtis*

RE: Wrong SQL statement being generated

2012-04-27 Thread Ravi Palacherla
Rick, I will take a look, can you please share the test case that you already have. So I don't have to start from scratch. Ravi. -Original Message- From: Rick Curtis [mailto:curti...@gmail.com] Sent: Friday, April 27, 2012 10:32 AM To: users@openjpa.apache.org Subject: Re: Wrong SQL

Re: Wrong SQL statement being generated

2012-04-27 Thread Rick Curtis
Ravi - Sorry but I don't have an OpenJPA proper unit test... I hacked something to an environment that I was testing some other things on. I was able to copy / paste and tweak a few things pretty easily to get a test going. Let me know if you have any issues. Thanks, Rick On Fri, Apr 27, 2012