December 2009 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Created: (HHH-2845) "Another ORA-00907: missing right parenthesis" bug with Oracle

by Dean Pullen (JIRA)

"Another ORA-00907: missing right parenthesis" bug with Oracle -------------------------------------------------------------- Key: HHH-2845 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2845 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.5 Environment: hibernate-entitymanager.jar (3.3.1ga) hibernate-annotations.jar (v 3.3.0ga) hibernate-commons-annotations.jar (within Hibernate Annotations.rar\lib) ejb3-persistence.jar (within Hibernate Annotations.rar\lib) hibernate3.jar (v 3.2.5.ga) Oracle 10g Reporter: Dean Pullen I'm using JBoss 4.2.1GA, with the Hibernate environment described above, using Oracle 10g, and attempting to perform a query. I've been receiving a "ORA-00907: missing right parenthesis" error when attempting to perform the query. Now a similar bug had this down to Hibernate using the 'as' keyword in the query, aliasing the table name - something that has been fixed in Hibernate 3.3.0ga. (Aliasing a table in the SQL spec is optional, Oracle doesn't support it) But I still get the same error. The query still contains the 'as' keyword (but not aliasing a table) Here is an example: I have two tables. CSIUsers and CSIUserSurveys. There is a one-to-many mapping between CSIUsers to CSIUserSurveys. Query query = entityManager.createQuery("FROM " + CSIUser.class.getSimpleName() + " cu LEFT JOIN cu.csiUserSurveys us" + " WHERE NOT EXISTS (SELECT us FROM cu.csiUserSurveys us WHERE us.csiUserId = cu.csiUserId)"); Result: [[14 Sep 2007 15:43:52] DEBUG org.hibernate.util.JDBCExceptionReporter - could n ot execute query [select csiuser0_.CSI_USER_ID as CSI1_15_0_, csiusersur1_.CSI_U SER_ID as CSI1_16_1_, csiusersur1_.SURVEY_TYPE_CODE as SURVEY2_16_1_, csiuser0_. COMPANY_CODE as COMPANY2_15_0_, csiuser0_.EMAIL_ADDRESS as EMAIL3_15_0_, csiuser 0_.FAILED_LOGINS as FAILED4_15_0_, csiuser0_.LOCALE as LOCALE15_0_, csiuser0_.PA SSWORD as PASSWORD15_0_, csiuser0_.PURCHASE_DATE as PURCHASE7_15_0_, csiuser0_.S TATUS as STATUS15_0_, csiuser0_.USER_NAME as USER9_15_0_, csiuser0_.USER_PRIVILE GE as USER10_15_0_, csiusersur1_.SURVEY_INVITE_DATE as SURVEY3_16_1_ from CSI_US ERS csiuser0_ left outer join CSI_USER_SURVEYS csiusersur1_ on csiuser0_.CSI_USE R_ID=csiusersur1_.CSI_USER_ID where not (exists (select (csiusersur2_.CSI_USER_ ID, csiusersur2_.SURVEY_TYPE_CODE) from CSI_USER_SURVEYS csiusersur2_ where csiu ser0_.CSI_USER_ID=csiusersur2_.CSI_USER_ID and csiusersur2_.CSI_USER_ID=csiuser0 _.CSI_USER_ID))] java.sql.SQLException: ORA-00907: missing right parenthesis -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years

3
4
0 / 0

[Hibernate-JIRA] Created: (HHH-4671) Derby is one of those dialects that should not support "cross join"

by Steve Ebersole (JIRA)

Derby is one of those dialects that should not support "cross join" ------------------------------------------------------------------- Key: HHH-4671 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4671 Project: Hibernate Core Issue Type: Improvement Components: core, query-hql Reporter: Steve Ebersole Assignee: Steve Ebersole Fix For: 3.5 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years

1
2
0 / 0

[Hibernate-JIRA] Created: (HHH-4621) Trunk build fails due to maven plugins having been moved

by Chris Wilson (JIRA)

Trunk build fails due to maven plugins having been moved -------------------------------------------------------- Key: HHH-4621 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4621 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.5 Environment: Ubuntu 8.04, maven 2.0.8 Reporter: Chris Wilson Downloading: http://repo1.maven.org/maven2/org/jboss/maven/plugins/maven-jdocbook-styl... Downloading: http://repo1.maven.org/maven2/org/jboss/maven/plugins/maven-jdocbook-styl... [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Error building POM (may not be this project's POM). Project ID: org.jboss.maven.plugins:maven-jdocbook-style-plugin Reason: POM 'org.jboss.maven.plugins:maven-jdocbook-style-plugin' not found in repository: Unable to download the artifact from any repository org.jboss.maven.plugins:maven-jdocbook-style-plugin:pom:2.0.0 from the specified remote repositories: central (http://repo1.maven.org/maven2) for project org.jboss.maven.plugins:maven-jdocbook-style-plugin Seems to be the same issue as HHH-3204. I'm not sure how that was fixed, as the <pluginRepository> was not added to parent/pom.xml. Adding the following to parent/pom.xml fixes it for me: <pluginRepositories> <pluginRepository> <id>jboss</id> <url>http://repository.jboss.org/maven2/</url> </pluginRepository> </pluginRepositories> -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years

2
2
0 / 0

[Hibernate-JIRA] Created: (HHH-4673) Upgrade JPA Static Metamodel Generator dependency to 1.0.0.Beta1

by Steve Ebersole (JIRA)

Upgrade JPA Static Metamodel Generator dependency to 1.0.0.Beta1 ---------------------------------------------------------------- Key: HHH-4673 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4673 Project: Hibernate Core Issue Type: Task Reporter: Steve Ebersole Assignee: Steve Ebersole Fix For: 3.5 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years

1
1
0 / 0

[Hibernate-JIRA] Created: (METAGEN-11) Upgrade JPA dependency to hibernate-jpa-2.0-api-1.0.0-CR-1

by Steve Ebersole (JIRA)

Upgrade JPA dependency to hibernate-jpa-2.0-api-1.0.0-CR-1 ---------------------------------------------------------- Key: METAGEN-11 URL: http://opensource.atlassian.com/projects/hibernate/browse/METAGEN-11 Project: Hibernate StaticMetamodel Generator Issue Type: Task Reporter: Steve Ebersole Assignee: Steve Ebersole -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years

1
1
0 / 0

[Hibernate-JIRA] Created: (HHH-4672) Upgrade JPA dependency to hibernate-jpa-2.0-api-1.0.0-CR-1

by Steve Ebersole (JIRA)

Upgrade JPA dependency to hibernate-jpa-2.0-api-1.0.0-CR-1 ---------------------------------------------------------- Key: HHH-4672 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4672 Project: Hibernate Core Issue Type: Task Components: annotations, entity-manager Reporter: Steve Ebersole Assignee: Steve Ebersole Fix For: 3.5 Update the JPA API dependency to hibernate-jpa-2.0-api-1.0.0-CR-1 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years

1
1
0 / 0

[Hibernate-JIRA] Created: (HHH-4670) Incorrect revision types when in a add-flush-mod-flush sequence

by Adam Warski (JIRA)

Incorrect revision types when in a add-flush-mod-flush sequence --------------------------------------------------------------- Key: HHH-4670 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4670 Project: Hibernate Core Issue Type: Bug Components: envers Reporter: Adam Warski Assignee: Adam Warski Fix For: 3.5 The revision type in such case is MOD, should be ADD. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years

1
1
0 / 0

[Hibernate-JIRA] Created: (HHH-2480) Unify join fetch behavior or HQL and Criteria APIs

by Christian Bauer (JIRA)

Unify join fetch behavior or HQL and Criteria APIs -------------------------------------------------- Key: HHH-2480 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2480 Project: Hibernate3 Type: Improvement Components: query-hql, query-criteria Reporter: Christian Bauer Priority: Critical Fix For: 3.3 Can we consider changing the criteria API in 3.3 so that DISTINCT_ROOT_ENTITY is the default transformer? 10:28 I remember that detecting "fetch" in HQL and applying this transformer is already on the list, right? 10:29 or introduce config options for both APIs, so users can switch the default transformer 10:30 also, verify this please: http://www.hibernate.org/117.html#A12 Steve 2:31 we should try to detect if any fetches are present 2:31 otherwise DISTINCT_ROOT_ENTITY presents unecessary overhead 2:31 i dont recall such a discussion regarding that feature in HQL 2:32 another option is sorta like i'm planning in other areas: fallback to subselect fetching -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years

4
5
0 / 0

[Hibernate-JIRA] Created: (HHH-4636) Persist NonAuditedEntity Identifier in AuditedEntity_AUD

by Juta Sirakas (JIRA)

Persist NonAuditedEntity Identifier in AuditedEntity_AUD -------------------------------------------------------- Key: HHH-4636 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4636 Project: Hibernate Core Issue Type: New Feature Components: envers Reporter: Juta Sirakas In bug HHH-3779 one asked about that - "But the NonAuditedEntity Identifier should be persisted in AuditedEntity_AUD". I think it would be a needed feature. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years

2
1
0 / 0

[Hibernate-JIRA] Created: (HV-151) The mongolian validation message translation patch.

by Batbayar Bazarragchaa (JIRA)

The mongolian validation message translation patch. --------------------------------------------------- Key: HV-151 URL: http://opensource.atlassian.com/projects/hibernate/browse/HV-151 Project: Hibernate Validator Issue Type: Patch Components: validators Affects Versions: 3.1.0.GA Environment: Windows Vista Home Premium 32bit Reporter: Batbayar Bazarragchaa Attachments: DefaultValidatorMessages_mn_MN.properties Hello hibernate team. I'd like to include Mongolian language translation of validation message. I've translated the messages and converted to unicode characters code. Also tested with following code: ClassValidator(obj.getClass(), ResourceBundle.getBundle("org.hibernate.validator.resources.DefaultValidatorMessages", new Locale("mn", "MN"))); -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

15 years

3
9
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues December 2009