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" pa

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 SQLServerDictio

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: VarcharT

AW: [jira] Commented: (OPENJPA-117) Collection of TransactionListeners registered to a Broker should be available as unmodifiable collection

2007-01-31 Thread Thierling, Marcus \(Salt Solutions\)
Hello, the request from Pinaki regarding the transactionlistener also are in our business need. The actual possibility of Transactionlistener API are to small in OPEN-JPA/Kodo. It would be great when the folloing apsects could be considered. 1. Why could the Transactionlister not have the same

RE: [jira] Commented: (OPENJPA-117) Collection of TransactionListeners registered to a Broker should be available as unmodifiable collection

2007-01-31 Thread Patrick Linskey
> 1. Why could the Transactionlister not have the same > structure of API as the Instancelifecycle Listener. That mean > configuring a Default Transactionlister with the > brokerfactory, reading actual transactionlistener's in the > broker and manipulating actual transactionlisterners (that >

AW: [jira] Commented: (OPENJPA-117) Collection of TransactionListeners registered to a Broker should be available as unmodifiable collection

2007-01-31 Thread Thierling, Marcus \(Salt Solutions\)
Hello Abe, in our use Case we need the Transactionlister to implement an audit-log on PC-Object and PC-Object-Attributelevel. Because were a building a item/masterdata-Management-system. One of the main targets is to track every change on the Masterdata and then to export the Change to over 100

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 wo

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 .. 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 PROTECTED]> w

[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

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

2007-01-31 Thread David Ezzio (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Ezzio updated OPENJPA-118: Attachment: TestFixesForOpenJPA-118.zip Tests and fixes for the bug. Not sure if the tests are in

[jira] Commented: (OPENJPA-117) Collection of TransactionListeners registered to a Broker should be available as unmodifiable collection

2007-01-31 Thread Pinaki Poddar (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12469093 ] Pinaki Poddar commented on OPENJPA-117: --- > Adding listeners should generally either be done as an initializati

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

Re: EntityManager.clear() semantics

2007-01-31 Thread Kevin Sutter
Understood, Abe. I just wanted to get some agreement with you and/or Patrick before pursuing this type of change. Thanks! Kevin On 1/31/07, Abe White <[EMAIL PROTECTED]> wrote: > Basically, if we have dirtied the Persistence Context, then do a > flush() > followed by the detachAllInternal().

[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

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

2007-01-31 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12469126 ] Patrick Linskey commented on OPENJPA-118: - Sadly, due to some maven environment issues, all tests that need

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 20

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 1

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:

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. ___ Notice

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 su

[jira] Resolved: (OPENJPA-94) Allow MappingTool and persistence.xml to support drop-create for database schema

2007-01-31 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-94?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Patrick Linskey resolved OPENJPA-94. Resolution: Fixed > Allow MappingTool and persistence.xml to support drop-create for databa

Re: log create table statements?

2007-01-31 Thread Dain Sundstrom
I'm dumb. I thought I was using hsqldb in memory only mode, but instead it was in file mode. -dain On Jan 31, 2007, at 6:33 AM, Kevin Sutter wrote: Another possibility is that you need to explicitly declare the classes that you want processed for automatic table creation via the ..class> e

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

2007-01-31 Thread Marc Prud'hommeaux (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Marc Prud'hommeaux resolved OPENJPA-118. Resolution: Fixed I've corrected a couple minior problems with the patch (no ASF l

[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 Type

Re: FishEye indexing of OpenJPA source code

2007-01-31 Thread Marc Prud'hommeaux
FYI, the indexing finished finally (their settings for the Apache repositories are very slow so that they don't unnecessarily load down the servers). You can see the up-to-date index at: http://fisheye3.cenqua.com/changelog/openjpa/ On Jan 24, 2007, at 9:12 AM, Patrick Linskey wrote

[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 correl

[jira] Closed: (OPENJPA-27) SQL Parameter markers generated for literals causes DB2 SQL error SQLCODE -417(SQLSTATE 42609), 418(SQLSTATE 42610)

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-27?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-27. - Resolution: Duplicate duplicate of OPENJPA-22 > SQL Parameter markers generated for literals cau

[jira] Closed: (OPENJPA-52) bad sql pushdown, puts group by in outer select

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-52?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-52. - Resolution: Duplicate duplicate of OPENJPA-28 > bad sql pushdown, puts group by in outer select

[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 parsin

[jira] Closed: (OPENJPA-45) pushdown sql uses outer join when it should use inner join

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-45?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-45. - Resolution: Duplicate duplicate of OPENJPA-49 > pushdown sql uses outer join when it should use

[jira] Closed: (OPENJPA-56) in derby concat with input parameter needs a cast, otherwise becomes long varchar and some operations do not work

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-56?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-56. - Resolution: Fixed already fixed in latest code > in derby concat with input parameter needs a ca

[jira] Closed: (OPENJPA-53) bad sql pushdown for nested subselects, missing nested subselect

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-53?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-53. - Resolution: Fixed not a problem anymore > bad sql pushdown for nested subselects, missing neste

[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 tha

[jira] Closed: (OPENJPA-55) Allow executeUpdate() invocations on native queries

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-55?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-55. - Resolution: Fixed fixed by revision 497605 > Allow executeUpdate() invocations on native queries

[jira] Closed: (OPENJPA-48) parsing error - cast of subselect does not work

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-48?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-48. - Resolution: Fixed fixed in recent code > parsing error - cast of subselect does not work >

[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] Created: (OPENJPA-120) For Multi Table Entity subselect with field in second table gets DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601

2007-01-31 Thread George Hongell (JIRA)
For Multi Table Entity subselect with field in second table gets DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601 -- Key: OPENJPA-120 URL: https://issues.apac

[jira] Created: (OPENJPA-121) Table name defaults to the class name instead of the entity name

2007-01-31 Thread Marc Prud'hommeaux (JIRA)
Table name defaults to the class name instead of the entity name Key: OPENJPA-121 URL: https://issues.apache.org/jira/browse/OPENJPA-121 Project: OpenJPA Issue Type: Bug

[jira] Closed: (OPENJPA-110) Every NamedNativeQuery using ResultSetMapping fails at runtime with class cast exception when try to iterate over list

2007-01-31 Thread David Wisneski (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-110. -- Resolution: Fixed already fixed in current code > Every NamedNativeQuery using ResultSetMappi

[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 Ty

[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: TestEntityManagerMethodsThrowAfterClose.java This test cannot be checked in until

[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 diag

[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] Commented: (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:comment-tabpanel#action_12469346 ] Patrick Linskey commented on OPENJPA-36: Resolved with Marc's synchronization between the wiki and the site.

[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 Spri

[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] Updated: (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:all-tabpanel ] Patrick Linskey updated OPENJPA-123: Priority: Major > Test framework should allow tests that are expected to fail to be checke

[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 co