November 2007 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Created: (HHH-2016) Oracle9Dialect registers last_day() function as "lastday"

by Carl Lindberg (JIRA)

Oracle9Dialect registers last_day() function as "lastday" --------------------------------------------------------- Key: HHH-2016 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2016 Project: Hibernate3 Type: Bug Components: core Versions: 3.0 alpha, 3.0 beta 1, 3.0 beta 2, 3.0 beta 3, 3.0 beta 4, 3.0 rc 1, 3.0 final, 3.0.1, 3.0.2, 3.0.3, 3.0.4, 3.0.5, 3.1 beta 1, 3.1 beta 2, 3.1 rc 1, 3.1 rc2, 3.1 rc3, 3.1, 3.1.1, 3.1.2, 3.2.0.alpha1, 3.2.0.alpha2, 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3 Environment: Hibernate 2.x, 3.x with an Oracle database Reporter: Carl Lindberg Priority: Minor Attachments: Oracle9DialectPatch.diff, Oracle9DialectPatchOption2.diff Oracle9Dialect.java registers a "lastday" function, however the actual Oracle function is last_day() (with the underscore). This results in a SQL error if the function is used in HQL (and obviously, HQL will not accept use of "last_day"). The patch is basically: - registerFunction( "lastday", new StandardSQLFunction("lastday", Hibernate.DATE) ); + registerFunction( "last_day", new StandardSQLFunction("last_day", Hibernate.DATE) ); or, if support for the incorrect "lastday" usage should still be supported: - registerFunction( "lastday", new StandardSQLFunction("lastday", Hibernate.DATE) ); + registerFunction( "last_day", new StandardSQLFunction("last_day", Hibernate.DATE) ); + registerFunction( "lastday", new StandardSQLFunction("last_day", Hibernate.DATE) ); Both patch options are attached. -- 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

16 years, 6 months

3
3
0 / 0

[Hibernate-JIRA] Commented: (HHH-1930) QuerySyntaxException "with-clause expressions did not reference from-clause element to which the with-clause was associated"

by Sandeep Tamhankar (JIRA)

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1930?page=c... ] Sandeep Tamhankar commented on HHH-1930: ---------------------------------------- I have a different flavor of this bug: select foo.id from Foo foo left join foo.bar.baz b1 with b1.name = 'jack' Assume 'bar' is of type 'Bar' and 'baz' is of type 'Baz'. Hibernate knows how to traverse the relationships, but the code in HqlSqlWalker.handleWIthFragment yells because it thinks the 'from' node is a Bar, not a Baz. The workaround is to do something like this: select foo.id from Foo foo inner join foo.bar as mybar left join mybar.baz b1 with b1.name = 'jack' > QuerySyntaxException "with-clause expressions did not reference from-clause element to which the with-clause was associated" > ---------------------------------------------------------------------------------------------------------------------------- > > Key: HHH-1930 > URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1930 > Project: Hibernate3 > Issue Type: Bug > Components: query-hql > Affects Versions: 3.1.3, 3.2.0 cr1, 3.2.0.cr2, 3.2.0.cr3 > Reporter: Manfred Geiler > > In Version 3.1.2 the following "EventManager" HQL query worked fine: > select p from Person p join p.emailAddresses as email with email = 'xyz' > and produced an SQL query like this: > select person0_.PERSON_ID as PERSON1_2_, person0_.age as age2_, person0_.firstname as firstname2_, person0_.lastname as lastname2_ > from PERSON person0_ > inner join PERSON_EMAIL_ADDR emailaddre1_ > on person0_.PERSON_ID=emailaddre1_.PERSON_ID and (emailaddre1_.EMAIL_ADDR='xyz') > From Version 3.1.3 on this HQL throws the following QuerySyntaxException: > "with-clause expressions did not reference from-clause element to which the with-clause was associated" -- 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

16 years, 6 months

1
0
0 / 0

[Hibernate-JIRA] Created: (HHH-2899) Allow users to access their own parameters enables for count operations

by Roberto Lo Giacco (JIRA)

Allow users to access their own parameters enables for count operations ----------------------------------------------------------------------- Key: HHH-2899 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2899 Project: Hibernate3 Issue Type: Improvement Components: core, query-hql Affects Versions: 3.2.5 Environment: All versions on all dtabases Reporter: Roberto Lo Giacco Priority: Minor We at SmartWeb project (http://smartweb.sourceforge.net) need to access the valorized parameters on a Query object. We know there is a getNamedParams() method on AbstractQueryImpl but that method is protected so not accessible from our classes. We ask to have that method access modifier moved to public to solve an entire set of problems we encountered during our own framework development. -- 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

16 years, 6 months

1
2
0 / 0

[Hibernate-JIRA] Created: (HBX-995) Queryeditor throws exception when opening files (e.g. .hql files)

by Max Rydahl Andersen (JIRA)

Queryeditor throws exception when opening files (e.g. .hql files) ----------------------------------------------------------------- Key: HBX-995 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-995 Project: Hibernate Tools Issue Type: Bug Components: eclipse Affects Versions: 3.2.beta11, 3.2beta10, 3.2beta9 Reporter: Max Rydahl Andersen Fix For: 3.2.beta12 -- 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

16 years, 6 months

1
1
0 / 0

[Hibernate-JIRA] Created: (HBX-961) invalid column name in H2MetaDataDialect getSuggestedPrimaryKeyStrategyName query

by Dan Allen (JIRA)

invalid column name in H2MetaDataDialect getSuggestedPrimaryKeyStrategyName query --------------------------------------------------------------------------------- Key: HBX-961 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-961 Project: Hibernate Tools Issue Type: Bug Components: reverse-engineer Affects Versions: 3.2beta10 Environment: H2, version: 1.0 (2007-06-17) Reporter: Dan Allen There is an invalid column name used in the query to get the primary keys for a table. The query uses the column name TABLE_CATNAME but the appropriate name of the column is TABLE_CATALOG. A patch is supplied. -- 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

16 years, 6 months

2
17
0 / 0

[Hibernate-JIRA] Created: (HBX-755) incorrect genreated code for many-to-many relationship

by azamjalali (JIRA)

incorrect genreated code for many-to-many relationship ------------------------------------------------------- Key: HBX-755 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-755 Project: Hibernate Tools Type: Bug Components: ant Versions: 3.2beta7 Reporter: azamjalali The following code is generated for Table rolea and roleb( these tables have many-to-many relation). Both of entities use ManytoMany annotation without jointable annotation. ///////////////////////////////////////////////////////////////////// package trce.impr.subsystem.entity; // Generated Sep 17, 2006 1:04:06 AM by Hibernate Tools 3.2.0.beta7 import java.util.HashSet; import java.util.Set; import javax.persistence.CascadeType; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.ManyToMany; import javax.persistence.Table; /** * RoleB generated by hbm2java */ @Entity @Table(name="roleb" ,catalog="registration" , uniqueConstraints = { } ) public class RoleB implements java.io.Serializable { // Fields private int rolebId; private Set<RoleA> roleas = new HashSet<RoleA>(0); // Constructors /** default constructor */ public RoleB() { } /** minimal constructor */ public RoleB(int rolebId) { this.rolebId = rolebId; } /** full constructor */ public RoleB(int rolebId, Set<RoleA> roleas) { this.rolebId = rolebId; this.roleas = roleas; } // Property accessors @Id @Column(name="roleb_id", unique=true, nullable=false, insertable=true, updatable=true) public int getRolebId() { return this.rolebId; } public void setRolebId(int rolebId) { this.rolebId = rolebId; } @ManyToMany(cascade={CascadeType.ALL}, fetch=FetchType.LAZY, mappedBy="rolebs") public Set<RoleA> getRoleas() { return this.roleas; } public void setRoleas(Set<RoleA> roleas) { this.roleas = roleas; } } //////////////////////////////////////////////////////////////////////////////////// package trce.impr.subsystem.entity; // Generated Sep 17, 2006 1:04:06 AM by Hibernate Tools 3.2.0.beta7 import java.util.HashSet; import java.util.Set; import javax.persistence.CascadeType; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.FetchType; import javax.persistence.Id; import javax.persistence.ManyToMany; import javax.persistence.Table; /** * RoleA generated by hbm2java */ @Entity @Table(name="rolea" ,catalog="registration" , uniqueConstraints = { } ) public class RoleA implements java.io.Serializable { // Fields private int roleaId; private Set<RoleB> rolebs = new HashSet<RoleB>(0); // Constructors /** default constructor */ public RoleA() { } /** minimal constructor */ public RoleA(int roleaId) { this.roleaId = roleaId; } /** full constructor */ public RoleA(int roleaId, Set<RoleB> rolebs) { this.roleaId = roleaId; this.rolebs = rolebs; } // Property accessors @Id @Column(name="rolea_id", unique=true, nullable=false, insertable=true, updatable=true) public int getRoleaId() { return this.roleaId; } y public void setRoleaId(int roleaId) { this.roleaId = roleaId; } @ManyToMany(cascade={CascadeType.ALL}, fetch=FetchType.LAZY, mappedBy="roleas") public Set<RoleB> getRolebs() { return this.rolebs; } public void setRolebs(Set<RoleB> rolebs) { this.rolebs = rolebs; } } ////////////////////////////////////////////////////////////////////// -- 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

16 years, 6 months

5
18
0 / 0

[Hibernate-JIRA] Created: (HBX-846) Needed a method that finds Table by TableIdentifier

by Alexey Sonarov (JIRA)

Needed a method that finds Table by TableIdentifier --------------------------------------------------- Key: HBX-846 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-846 Project: Hibernate Tools Type: Task Components: hbm2java Versions: 3.2beta8 Reporter: Alexey Sonarov Needed the ability to get a correct org.hibernate.mapping.Table object by org.hibernate.cfg.reveng.TableIdentifier inside the method org.hibernate.cfg.reveng.DefaultReverseEngineeringStrategy.isForeignKeyCollectionInverse(...) Original Hibernate forum post: http://forum.hibernate.org/viewtopic.php?p=2335670 -- 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

16 years, 6 months

2
5
0 / 0

[Hibernate-JIRA] Created: (HBX-774) ClassCastException by create/open/execute a *.hql file

by Damir Isanbirdin (JIRA)

ClassCastException by create/open/execute a *.hql file ------------------------------------------------------ Key: HBX-774 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-774 Project: Hibernate Tools Type: Bug Components: visualizations, eclipse, consoleconfiguration Versions: 3.1.beta5, 3.1beta5a, 3.2beta6, 3.2beta7, 3.2beta8 Environment: 3.1.0 beta 5. Eclipse-plugin, DB: HSQLDB Reporter: Damir Isanbirdin Priority: Blocker !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:14.265 !MESSAGE Unhandled event loop exception !ENTRY org.eclipse.ui 4 0 2006-10-04 04:17:14.265 !MESSAGE Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) !STACK 0 org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) .... !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:16.921 !MESSAGE Save Failed !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.doSave(HQLEditor.java:430) at org.eclipse.ui.internal.SaveableHelper$1.run(SaveableHelper.java:95) at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:116) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291) !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:17.296 !MESSAGE Unhandled event loop exception !ENTRY org.eclipse.ui 4 0 2006-10-04 04:17:17.296 !MESSAGE Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) !STACK 0 org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput) at org.eclipse.swt.SWT.error(SWT.java:2942) at org.eclipse.swt.SWT.error(SWT.java:2865) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:126) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:3102) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2761) at org.eclipse.jface.window.Window.runEventLoop(Window.java:809) ... 51 more !ENTRY org.hibernate.eclipse.console 4 150 2006-10-04 04:17:29.687 !MESSAGE Exception while executing HQL Query !SUBENTRY 1 org.hibernate.eclipse.console 4 150 2006-10-04 04:17:29.703 !MESSAGE org.hibernate.QueryException: unexpected char: ';' [select s from mapping.ScaleData s, mapping.ScalesMappingData sm, mapping.AgencyRatingData ar, mapping.AgencyData a where s.scaleid=sm.scale.scaleid and sm.agencyrating.ratingid=ar.ratingid and ar.agency.agencyid=a.agencyid and a.agencyname=: param1 and ar.rating= :param2;] !STACK 0 org.hibernate.QueryException: unexpected char: ';' [select s from mapping.ScaleData s, mapping.ScalesMappingData sm, mapping.AgencyRatingData ar, mapping.AgencyData a where s.scaleid=sm.scale.scaleid and sm.agencyrating.ratingid=ar.ratingid and ar.agency.agencyid=a.agencyid and a.agencyname=: param1 and ar.rating= :param2;] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:203) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:110) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1586) at org.hibernate.console.HQLQueryPage.setSession(HQLQueryPage.java:77) at org.hibernate.console.ConsoleConfiguration$3.execute(ConsoleConfiguration.java:292) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:35) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:287) at org.hibernate.eclipse.console.actions.ExecuteHQLAction.execute(ExecuteHQLAction.java:134) at org.hibernate.eclipse.console.actions.ExecuteHQLAction$2.run(ExecuteHQLAction.java:104) at org.eclipse.jface.action.Action.runWithEvent(Action.java:996) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:538) ... !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:36.171 !MESSAGE Save Failed !ENTRY org.eclipse.ui 2 0 2006-10-04 04:17:36.171 !MESSAGE Save Failed !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.doSave(HQLEditor.java:430) at org.eclipse.ui.internal.SaveableHelper$1.run(SaveableHelper.java:95) at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:116) ... !ENTRY org.eclipse.ui 4 4 2006-10-04 04:17:42.484 !MESSAGE Save Failed !ENTRY org.eclipse.ui 2 0 2006-10-04 04:17:42.500 !MESSAGE Save Failed !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.doSave(HQLEditor.java:430) at org.eclipse.ui.internal.SaveableHelper$1.run(SaveableHelper.java:95) at org.eclipse.ui.internal.SaveableHelper$2.run(SaveableHelper.java:116) at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:346) at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:291) at org.eclipse.jface.window.ApplicationWindow$1.run(ApplicationWindow.java:624) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:69) at org.eclipse.jface.window.ApplicationWindow.run(ApplicationWindow.java:621) at org.eclipse.ui.internal.WorkbenchWindow.run(WorkbenchWindow.java:2134) ... !ENTRY org.eclipse.ui.workbench 4 2 2006-10-04 04:17:48.78 !MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.ui.workbench". !STACK 0 java.lang.ClassCastException: org.eclipse.ui.part.FileEditorInput at org.hibernate.eclipse.hqleditor.HQLEditor.getConsoleConfiguration(HQLEditor.java:438) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.updateText(DynamicSQLPreviewView.java:115) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.setCurrentEditor(DynamicSQLPreviewView.java:108) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.hookIntoEditor(DynamicSQLPreviewView.java:92) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView.access$2(DynamicSQLPreviewView.java:85) at org.hibernate.eclipse.console.views.DynamicSQLPreviewView$1.partBroughtToTop(DynamicSQLPreviewView.java:70) at org.eclipse.ui.internal.PartListenerList2$2.run(PartListenerList2.java:83) at org.eclipse.core.internal.runtime.InternalPlatform.run(InternalPlatform.java:1044) at org.eclipse.core.runtime.Platform.run(Platform.java:783) at org.eclipse.ui.internal.PartListenerList2.fireEvent(PartListenerList2.java:54) ... -- 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

16 years, 6 months

2
3
0 / 0

[Hibernate-JIRA] Created: (HBX-1002) Pass ReverseEngineeringRuntimeInfo to MetaDataDialect to give access to needed info

by Max Rydahl Andersen (JIRA)

Pass ReverseEngineeringRuntimeInfo to MetaDataDialect to give access to needed info ----------------------------------------------------------------------------------- Key: HBX-1002 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1002 Project: Hibernate Tools Issue Type: Improvement Affects Versions: 3.2.beta11 Reporter: Max Rydahl Andersen Fix For: 3.2.beta12 -- 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

16 years, 6 months

1
2
0 / 0

[Hibernate-JIRA] Created: (HBX-1009) @JoinColumn on association with composite foreign key needs referencedColumnName

by Gavin King (JIRA)

@JoinColumn on association with composite foreign key needs referencedColumnName -------------------------------------------------------------------------------- Key: HBX-1009 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1009 Project: Hibernate Tools Issue Type: Bug Components: hbm2java Reporter: Gavin King Its not ok to generate this: @JoinColumns( { @JoinColumn(name = "make"), @JoinColumn(name = "model"), @JoinColumn(name = "year") }) You need the referencedColumnNames. Incidently, is all this noisy crap really necessary? @EmbeddedId @AttributeOverrides( { @AttributeOverride(name = "make", column = @Column(name = "make", nullable = false, length = 20)), @AttributeOverride(name = "model", column = @Column(name = "model", nullable = false, length = 30)), @AttributeOverride(name = "year", column = @Column(name = "year", nullable = false)) }) @NotNull public ModelYearId getId() { return this.id; } -- 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

16 years, 6 months

3
8
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues November 2007