Re: Is it possible to extend SchemaTool with MS SQL Server collation setting?

2007-01-31 Thread Marc Prud'hommeaux
William- I don't know how you specify collation, but if it is expressible via the column type name, you could always set the type-name of the column in the schema file (e.g., setting the type-name to be VARCHAR WITH ASCII COLLATION). If it needs to be specific in the CREATE TABLE part,

Re: Is it possible to extend SchemaTool with MS SQL Server collation setting?

2007-01-31 Thread William Cai
Marc, In SQL Server, we specify Collation with below code. Therefore, we can't set the option in type-name. In our project, there are hundreds of columns need case-sensitive collation support. It's really painful to set all of them in generated script. The best solution is custom

Re: Is it possible to extend SchemaTool with MS SQL Server collation setting?

2007-01-31 Thread Marc Prud'hommeaux
William- If you wanted to have all your varchar columns be specified as varchar(SIZE) COLLATE French_CI_AS, you could specify the property: openjpa.jdbc.DBDictionary: VarcharTypeName=varchar{0} COLLATE French_CI_AS On Jan 31, 2007, at 12:39 AM, William Cai wrote: Marc, In SQL

Re: Is it possible to extend SchemaTool with MS SQL Server collation setting?

2007-01-31 Thread William Cai
Wow~~~ You're the man, Marc! The problem is resolved! On 1/31/07, Marc Prud'hommeaux [EMAIL PROTECTED] wrote: William- If you wanted to have all your varchar columns be specified as varchar(SIZE) COLLATE French_CI_AS, you could specify the property: openjpa.jdbc.DBDictionary:

Re: EntityManager.clear() semantics

2007-01-31 Thread Kevin Sutter
Craig, If anybody would have a channel to the CTS team, I would think it would be you. :-) I have also passed on this request to our CTS rep to see where it takes us. Good idea. Thanks. Kevin On 1/30/07, Craig L Russell [EMAIL PROTECTED] wrote: Hi Kevin, I agree with your analysis. I

Re: log create table statements?

2007-01-31 Thread Kevin Sutter
Another possibility is that you need to explicitly declare the classes that you want processed for automatic table creation via the class../class elements. Scanning for available Entity classes won't work when attempting to auto create the tables. Kevin On 1/30/07, Marc Prud'hommeaux [EMAIL

[jira] Created: (OPENJPA-118) AutoDetach property has no effect

2007-01-31 Thread David Ezzio (JIRA)
AutoDetach property has no effect - Key: OPENJPA-118 URL: https://issues.apache.org/jira/browse/OPENJPA-118 Project: OpenJPA Issue Type: Bug Components: lib Environment: Java SE

Re: EntityManager.clear() semantics

2007-01-31 Thread Abe White
Basically, if we have dirtied the Persistence Context, then do a flush() followed by the detachAllInternal(). I don't think the clear() should be doing this flush() operation. Any disagreement? I agree. But note that just removing the flush call won't work for a couple of reasons: it's

[jira] Commented: (OPENJPA-93) Sequence generation in a JTA environment should not require non-JTA datasource

2007-01-31 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-93?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12469123 ] Patrick Linskey commented on OPENJPA-93: Has anyone tested this on non-WLS appservers? Sequence generation

Re: svn commit: r501955 - /incubator/openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/simple/TestPersistence.java

2007-01-31 Thread Craig L Russell
This commit is way too big for its changes. I recommend that everyone do an svn diff prior to commit to make sure that you don't have a line-end problem, such as this appears to have. Craig On Jan 31, 2007, at 11:27 AM, [EMAIL PROTECTED] wrote: Author: kwsutter Date: Wed Jan 31 11:27:11

Re: svn commit: r501955 - /incubator/openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/simple/TestPersistence.java

2007-01-31 Thread Craig L Russell
I'd prefer to see a separate test that tests all of the em methods that are supposed to throw an exception (all of them except isOpen and getTransaction). Putting this new test here is awkward. Craig On Jan 31, 2007, at 11:27 AM, [EMAIL PROTECTED] wrote: Author: kwsutter Date: Wed Jan 31

Re: svn commit: r501955 - /incubator/openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/simple/TestPersistence.java

2007-01-31 Thread Kevin Sutter
Yeah, I tend to agree. Just wanted to get something out there for the fix that was provided... And, doing it this way allows me to experiment more with getting these line ending characters correct... :-) JK! On 1/31/07, Craig L Russell [EMAIL PROTECTED] wrote: I'd prefer to see a separate

Re: Perform automatic drop and create db schema

2007-01-31 Thread Dain Sundstrom
What version of OpenJPA will this be in and did dropTable get implemented? -dain On Jan 2, 2007, at 6:50 PM, Patrick Linskey wrote: -Original Message- From: Shay Banon [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 02, 2007 2:33 PM To: open-jpa-dev@incubator.apache.org Subject:

RE: svn commit: r501955 - /incubator/openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/simple/TestPersistence.java

2007-01-31 Thread Patrick Linskey
I seem to recall deciding to not use the SVN eclipse integration a few months ago -- I do all my svn work from the command line. Maybe this was why I made that decision. -Patrick -- Patrick Linskey BEA Systems, Inc. ___

Re: svn commit: r501955 - /incubator/openjpa/trunk/openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/simple/TestPersistence.java

2007-01-31 Thread Craig L Russell
Hi Kevin, Sorry for commenting before reading this... On Jan 31, 2007, at 11:39 AM, Kevin Sutter wrote: Sorry about the whole changed file thing again. I thought I had found the problem with a doubly defined [miscellany] section in my svn config file. But, I changed that and I still have

RE: Perform automatic drop and create db schema

2007-01-31 Thread Patrick Linskey
It's in 0.9.7-snapshot; I don't remember the change number. -Patrick -- Patrick Linskey BEA Systems, Inc. ___ Notice: This email message, together with any attachments, may contain information of BEA Systems, Inc., its

[jira] Created: (OPENJPA-119) EntityManager.clear() should not implicitly invoke the flush operation

2007-01-31 Thread Kevin Sutter (JIRA)
EntityManager.clear() should not implicitly invoke the flush operation -- Key: OPENJPA-119 URL: https://issues.apache.org/jira/browse/OPENJPA-119 Project: OpenJPA Issue

[jira] Closed: (OPENJPA-16) NPE in createQuery for EJB QL with nested correlated subqueries

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-16?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-16. - Resolution: Fixed This problem has been fixed NPE in createQuery for EJB QL with nested

[jira] Closed: (OPENJPA-47) 143 arithmetic unary operator (+,-) gives parsing error

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-47?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-47. - Resolution: Duplicate duplicate of OPENJPA-26 143 arithmetic unary operator (+,-) gives

[jira] Closed: (OPENJPA-54) bad sql pushdown, should use all syntax

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-54?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-54. - Resolution: Fixed already fixed bad sql pushdown, should use all syntax

[jira] Closed: (OPENJPA-25) Incorrect SQL generated for queries involving more than one AbstractSchemaNames, generated SQL FROM clause is missing 'Table alias'

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-25?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-25. - Resolution: Fixed not a problem anymore Incorrect SQL generated for queries involving more

[jira] Closed: (OPENJPA-50) bad sql pushdown, cast changes datatype

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-50?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-50. - Resolution: Fixed fixed in recent code bad sql pushdown, cast changes datatype

[jira] Closed: (OPENJPA-62) Ejbql join queries show invalid null Entities when run in a new persistence context where no entity instances exist.

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-62?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-62. - Resolution: Fixed fixed in recent code Ejbql join queries show invalid null Entities when run

[jira] Created: (OPENJPA-122) EntityManager does not throw exceptions after close() in required cases

2007-01-31 Thread Craig Russell (JIRA)
EntityManager does not throw exceptions after close() in required cases --- Key: OPENJPA-122 URL: https://issues.apache.org/jira/browse/OPENJPA-122 Project: OpenJPA Issue

[jira] Updated: (OPENJPA-122) EntityManager does not throw exceptions after close() in required cases

2007-01-31 Thread Craig Russell (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Craig Russell updated OPENJPA-122: -- Attachment: EntityManagerImpl.patch.txt Please review this patch. This patch fixes the issue

[jira] Resolved: (OPENJPA-10) persistence unit name should be default diagnostic context for standard OpenJPA log impl

2007-01-31 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-10?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Patrick Linskey resolved OPENJPA-10. Resolution: Fixed persistence unit name should be default diagnostic context for standard

[jira] Commented: (OPENJPA-10) persistence unit name should be default diagnostic context for standard OpenJPA log impl

2007-01-31 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-10?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12469345 ] Patrick Linskey commented on OPENJPA-10: Resolved with 475084 persistence unit name should be default

[jira] Resolved: (OPENJPA-36) Add cwiki url to incubator status page

2007-01-31 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-36?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Patrick Linskey resolved OPENJPA-36. Resolution: Fixed Add cwiki url to incubator status page

[jira] Resolved: (OPENJPA-40) Testing OpenJPA and Spring integration fails

2007-01-31 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-40?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Patrick Linskey resolved OPENJPA-40. Resolution: Fixed Testing OpenJPA and Spring integration fails

[jira] Commented: (OPENJPA-40) Testing OpenJPA and Spring integration fails

2007-01-31 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-40?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12469347 ] Patrick Linskey commented on OPENJPA-40: To my knowledge, this has been resolved. Testing OpenJPA and

[jira] Created: (OPENJPA-123) Test framework should allow tests that are expected to fail to be checked in

2007-01-31 Thread Patrick Linskey (JIRA)
Test framework should allow tests that are expected to fail to be checked in Key: OPENJPA-123 URL: https://issues.apache.org/jira/browse/OPENJPA-123 Project: OpenJPA

[jira] Commented: (OPENJPA-123) Test framework should allow tests that are expected to fail to be checked in

2007-01-31 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12469355 ] Patrick Linskey commented on OPENJPA-123: - OPENJPA-122 is an example of a test case that should have been