July 2008 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Created: (HHH-3364) Missing table name + alias in FROM clause of generated SQL

by Istvan Kovacs (JIRA)

Missing table name + alias in FROM clause of generated SQL ---------------------------------------------------------- Key: HHH-3364 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3364 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.3.0.CR1, 3.2.6 Environment: hsqldb Reporter: Istvan Kovacs Same sources as HHH-3362 and HHH-3363 select emp.name from Employee emp, Product p where emp.shop.stock[p] > 5 and p.name='Product_10' SQL (missing the table SHOP, aliased as shop_2) select employee0_.name as col_0_0_ from Employee employee0_, PRODUCT product1_, SHOP_PRODUCT_STOCK stock3_ where employee0_.SHOP_ID=shop2_.SHOP_ID and shop2_.SHOP_ID=stock3_.SHOP_ID and stock3_.PRODUCT_ID = product1_.PRODUCT_ID and stock3_.AMOUNT>5 and product1_.name='Product_10' Stack trace is from 3.3.0.CR1, but problem is also present in 3.2.6 java.sql.SQLException: Column not found: SHOP2_.SHOP_ID in statement [select employee0_.name as col_0_0_ from Employee employee0_, PRODUCT product1_, SHOP_PRODUCT_STOCK stock3_ where employee0_.SHOP_ID=shop2_.SHOP_ID and shop2_.SHOP_ID=stock3_.SHOP_ID and stock3_.PRODUCT_ID = product1_.PRODUCT_ID and stock3_.AMOUNT>5 and product1_.name='Product_10'] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source) at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547) at org.hibernate.loader.Loader.doQuery(Loader.java:673) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) at org.hibernate.console.HQLQueryPage.getList(HQLQueryPage.java:50) at org.hibernate.eclipse.console.views.QueryPageViewer$ContentProviderImpl.getElements(QueryPageViewer.java:114) at org.eclipse.jface.viewers.StructuredViewer.getRawChildren(StructuredViewer.java:937) at org.eclipse.jface.viewers.ColumnViewer.getRawChildren(ColumnViewer.java:693) at org.eclipse.jface.viewers.AbstractTableViewer.getRawChildren(AbstractTableViewer.java:1071) at org.eclipse.jface.viewers.StructuredViewer.getFilteredChildren(StructuredViewer.java:871) at org.eclipse.jface.viewers.StructuredViewer.getSortedChildren(StructuredViewer.java:994) at org.eclipse.jface.viewers.AbstractTableViewer.internalRefreshAll(AbstractTableViewer.java:685) at org.eclipse.jface.viewers.AbstractTableViewer.internalRefresh(AbstractTableViewer.java:633) at org.eclipse.jface.viewers.AbstractTableViewer.internalRefresh(AbstractTableViewer.java:620) at org.eclipse.jface.viewers.AbstractTableViewer$2.run(AbstractTableViewer.java:576) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1368) at org.eclipse.jface.viewers.StructuredViewer.preservingSelection(StructuredViewer.java:1330) at org.eclipse.jface.viewers.AbstractTableViewer.inputChanged(AbstractTableViewer.java:574) at org.eclipse.jface.viewers.ContentViewer.setInput(ContentViewer.java:251) at org.eclipse.jface.viewers.StructuredViewer.setInput(StructuredViewer.java:1606) at org.hibernate.eclipse.console.views.QueryPageViewer.createTable(QueryPageViewer.java:218) at org.hibernate.eclipse.console.views.QueryPageViewer.createControl(QueryPageViewer.java:197) at org.hibernate.eclipse.console.views.QueryPageViewer.<init>(QueryPageViewer.java:154) at org.hibernate.eclipse.console.views.QueryPageTabView.rebuild(QueryPageTabView.java:114) at org.hibernate.eclipse.console.views.QueryPageTabView$1.contentsChanged(QueryPageTabView.java:78) at org.hibernate.eclipse.console.views.QueryPageTabView$1.intervalAdded(QueryPageTabView.java:88) at javax.swing.AbstractListModel.fireIntervalAdded(Unknown Source) at org.hibernate.console.QueryPageModel.add(QueryPageModel.java:67) at org.hibernate.console.KnownConfigurations$1.queryPageCreated(KnownConfigurations.java:90) at org.hibernate.console.ConsoleConfiguration.fireQueryPageCreated(ConsoleConfiguration.java:419) at org.hibernate.console.ConsoleConfiguration.access$5(ConsoleConfiguration.java:415) at org.hibernate.console.ConsoleConfiguration$4.execute(ConsoleConfiguration.java:391) at org.hibernate.console.execution.DefaultExecutionContext.execute(DefaultExecutionContext.java:65) at org.hibernate.console.ConsoleConfiguration.executeHQLQuery(ConsoleConfiguration.java:383) at org.hibernate.eclipse.hqleditor.HQLEditor.executeQuery(HQLEditor.java:406) at org.hibernate.eclipse.console.actions.ExecuteQueryAction.execute(ExecuteQueryAction.java:72) at org.hibernate.eclipse.console.actions.ExecuteQueryAction.run(ExecuteQueryAction.java:52) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.hibernate.eclipse.console.actions.ExecuteQueryAction.runWithEvent(ExecuteQueryAction.java:56) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:546) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$6.handleEvent(ActionContributionItem.java:443) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219) at org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:106) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447) at org.eclipse.equinox.launcher.Main.run(Main.java:1173) -- 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

17 years, 8 months

2
3
0 / 0

[Hibernate-JIRA] Created: (HHH-3386) Hibernate 3.3.0 CR1 has a dependency of java 1.5. Integer.valueOf(int) is called in some places.

by Dimitri Lubenskyy (JIRA)

Hibernate 3.3.0 CR1 has a dependency of java 1.5. Integer.valueOf(int) is called in some places. ------------------------------------------------------------------------------------------------ Key: HHH-3386 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3386 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.3.0.CR1 Environment: java 1.4 Reporter: Dimitri Lubenskyy Hibernate 3.3.0 CR1 has a dependency of java 1.5. Integer.valueOf(int) is called in some places. -- 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

17 years, 8 months

2
5
0 / 0

[Hibernate-JIRA] Created: (HHH-3376) Subqueries in Criteria-API use wrong table alias

by Gerald Glocker (JIRA)

Subqueries in Criteria-API use wrong table alias ------------------------------------------------ Key: HHH-3376 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3376 Project: Hibernate3 Issue Type: Bug Components: query-criteria Affects Versions: 3.3.0.CR1 Reporter: Gerald Glocker Priority: Blocker Subqueries (exists, notExists, and probably others) are formulated using table alias "this_" but the outer query also uses the same table alias. Bug HHHH-3114 also applies for 3.3.0 CR1: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3114 -- 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

17 years, 8 months

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-3396) minus sign in entity name causes invalid SQL

by Stefan Wachter (JIRA)

minus sign in entity name causes invalid SQL -------------------------------------------- Key: HHH-3396 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3396 Project: Hibernate3 Issue Type: Improvement Components: core Affects Versions: 3.2.6 Environment: MySQL 5.0 Reporter: Stefan Wachter An entity name that contains a minus sign leads to invalid SQL. The reason is that the minus signs are not replaced when alias names are derived from entity names. Maybe the org.hibernate.util.StringHelper.generateAliasRoot(String description) could replace minus signs by underscores? At the moment only "/" and "$" characters are replaced. -- 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

17 years, 8 months

2
1
0 / 0

[Hibernate-JIRA] Created: (ANN-749) Generated Annotation can not generate Date automatically

by yuanqingfei (JIRA)

Generated Annotation can not generate Date automatically -------------------------------------------------------- Key: ANN-749 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-749 Project: Hibernate Annotations Issue Type: Bug Affects Versions: 3.4.0.CR1, 3.3.1.GA Environment: OS: Windows XP DB: HSQL Reporter: yuanqingfei @Before public void setup() { order = new Order(); // enter all required fields order.setName("order1"); order = orderDAO.save(order); //Hibernate should generate a timestamp here } @Test public void testSave() { assertTrue(orderDAO.exists(order.getId())); System.out.println(order.getCreateTime()); //here should get a date. } Annotation part in Order: @Temporal(TemporalType.TIMESTAMP) @Column(insertable = false,updatable=false) @org.hibernate.annotations.Generated(org.hibernate.annotations.GenerationTime.INSERT) private Date createTime; Save part in OrderDAO. @SuppressWarnings("unchecked") public T save(T object) { return (T) super.getHibernateTemplate().merge(object); } every time, I just only get null. -- 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

17 years, 8 months

3
3
0 / 0

[Hibernate-JIRA] Created: (HHH-2021) org.hibernate.cache.QueryKey has a fragile equals() method

by Kenny MacLeod (JIRA)

org.hibernate.cache.QueryKey has a fragile equals() method ---------------------------------------------------------- Key: HHH-2021 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2021 Project: Hibernate3 Type: Bug Components: core Versions: 3.1.3 Reporter: Kenny MacLeod Priority: Trivial This one is no great shakes, but the first line of QueryKey.equals() casts the argument to QueryKey without checking for its type. As such, the method is fragile. It should be consistent with CacheKey, which does an instanceof check before the cast. -- 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

17 years, 8 months

7
15
0 / 0

[Hibernate-JIRA] Created: (HHH-2442) ClassCastException loading from second level cache

by Marcio Moraes (JIRA)

ClassCastException loading from second level cache -------------------------------------------------- Key: HHH-2442 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2442 Project: Hibernate3 Type: Bug Components: core Versions: 3.2.1, 3.2.2, 3.2.0.ga Environment: Linux 2.6.15-27-686 #1 SMP PREEMPT Fri Dec 8 18:00:07 UTC 2006 i686 GNU/Linux Reporter: Marcio Moraes Priority: Blocker I'm getting a error when using hibernate 3.2.2.ga with cache (JBoss-Cache) cluster. When hibernate get a entity from second level cache it confuses the arrays of values against array of types. So in some situations i got ClassCastException ... Looking up CacheEntry code at assemble method i saw: private static Object[] assemble( final Serializable[] values, final Object result, final Serializable id, final EntityPersister persister, final Interceptor interceptor, final EventSource session) throws HibernateException { //assembled state gets put in a new array (we read from cache by value!) Object[] assembledProps = TypeFactory.assemble( values, persister.getPropertyTypes(), session, result ); The issue is values (Serializeble[]) is in wrong order compared with persister.getPropertyTypes() (Type[]). If only one cache instance is running it doesnt occurs ... I am using Linux. Att, Márcio Moraes -- 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

17 years, 8 months

6
12
0 / 0

[Hibernate-JIRA] Created: (HHH-2926) Patch for Pre*Event inherit AbstractEvent

by Chatellier Eric (JIRA)

Patch for Pre*Event inherit AbstractEvent ----------------------------------------- Key: HHH-2926 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2926 Project: Hibernate3 Issue Type: Patch Components: core Affects Versions: 3.2.5 Environment: 3.2.5.ga; all platform Reporter: Chatellier Eric Attachments: patch.patch Pre*Event classes are only classes that don't implements AbstractEvent. Here is the patch that correct that. -- 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

17 years, 8 months

4
8
0 / 0

[Hibernate-JIRA] Created: (HHH-3247) Provide more information in TypeMismatchException message

by Szczepan Kuzniarz (JIRA)

Provide more information in TypeMismatchException message --------------------------------------------------------- Key: HHH-3247 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3247 Project: Hibernate3 Issue Type: Improvement Components: core Affects Versions: 3.2.6 Reporter: Szczepan Kuzniarz When DefaultLoadEventListener throws TypeMismatchException it provides information about expected and actual id types: "Provided id of the wrong type. Expected: " + idClass + ", got " + event.getEntityId().getClass() but it says nothing about the offending class. It is not always the class which is loaded by client (it may be one of associated classes) and sometimes it's not easy to track it down. It would be nice if DefaultLoadEventListener would report something like this: "Provided id of the wrong type for class " + persister.getEntityName() + ". Expected: " + idClass + ", got " + event.getEntityId().getClass() -- 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

17 years, 8 months

3
6
0 / 0

[Hibernate-JIRA] Created: (HHH-3141) Move to JBoss Cache 2.1.0.GA

by Brian Stansberry (JIRA)

Move to JBoss Cache 2.1.0.GA ---------------------------- Key: HHH-3141 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3141 Project: Hibernate3 Issue Type: Sub-task Components: caching (L2) Reporter: Brian Stansberry Assignee: Brian Stansberry Fix For: 3.3 The current Hibernate/JBC2 integration is using JBC 2.1.0.CR4. Need to switch to the GA when it comes out. OptimisticBulkOperationsTest has a "failure expected" test that will pass with the GA; need to get rid of the failure expected bit. -- 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

17 years, 8 months

2
5
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues July 2008