July 2007 - hibernate-issues - Jboss List Archives

[Hibernate-JIRA] Created: (HHH-2734) PreparedStatement leak with lazy properties

by Christian Gruber (JIRA)

PreparedStatement leak with lazy properties ------------------------------------------- Key: HHH-2734 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2734 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.4 Environment: Hibernate 3.2.4 Oracle 10g Sun Java 1.5.0 Reporter: Christian Gruber Priority: Critical Hello! When iterating through more than 300 elements that have lazy properties, I get an ORA-01000 JDBC error ("maximum open cursors exceeded"). I found out that the root cause for this are unclosed prepared statements in AbstractBatcher.prepareSelectStatement(String). When I add the generated prepared statement to the statementsToClose set in this method, the problem vanishes. But I don't have an idea what other effects this might have, and why the prepared statement was not added to the statements to close in the first place. How to reproduce: - Make a class with at least one lazy property; instrument the byte code - Create an Oracle database with at least 300 entries in the table for this class - Execute the following code: Iterator<MyClass> it = session.createQuery("from MyClass mc").iterate(); while (it.hasNext()) { MyClass mc = it.next(); String la = mc.getLazyAttribute(); session.evict(mc); } - Watch the log for org.hibernate.jdbc.AbstractBatcher entries containing "about to open ResultSet" and see the numbers increase As already mentioned, a simple fix for this is adding "statementsToClose.add( ps );" into AbstractBatcher.java, around line 133 (assigning the PreparedStatement to a new variable "ps" first, of course), but as I don't understand the differences between the various PreparedStatement generating methods there, that might give rise to other problems. Thanks for looking at it, Christian -- 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

2
2
0 / 0

[Hibernate-JIRA] Created: (HHH-2433) Use of an id together with a natural-id results in an ArraIndexOutOfBoundsException

by Danny Bols (JIRA)

Use of an id together with a natural-id results in an ArraIndexOutOfBoundsException ------------------------------------------------------------------------------------ Key: HHH-2433 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2433 Project: Hibernate3 Type: Bug Components: core Versions: 3.2.1 Environment: MySql, Cocoon, WindowsXp Reporter: Danny Bols Attachments: hb-issue.txt Use of a natural-id in combination with a generated id results in an ArrayOutOfBoundsException. The table in the database has 2 unique keys, a natural-id and an internal id (UUID). A record is loaded in a separate transaction and send to a user form. When the user hits the save button the changes are committed in a new transaction. If this transaction doesn't contain a new load of the record the commit will result in an ArrayIndexOutOfBoundsException. If we leave out the natural-id definition in the config file we don't get an exception. See attachement for details. -- Danny -- 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

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-2593) Keyword UNION is prefixed with "this_." in filter conditions

by Frederic Leitenberger (JIRA)

Keyword UNION is prefixed with "this_." in filter conditions ------------------------------------------------------------ Key: HHH-2593 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2593 Project: Hibernate3 Issue Type: Bug Components: query-hql, query-sql Affects Versions: 3.2.1 Environment: Oracle 10g: org.hibernate.dialect.OracleDialect Suse Linux Hibernate: 3.2.1.ga Hibernate Annotations: 3.2.1.GA Reporter: Frederic Leitenberger Priority: Trivial I need to use a UNION-Subquery in a Filter condition unless HHH-298 is solved. But anyway, when using the keyword "union" in the Filter condition it is prefixed with "this_.". For instance, this ... @Filter(name = "resellerFilter", condition = "(select cu.resellerId from Customer cu, GeoNumber gn where (cu.id = gn.customerId and gn.id = this_.geoNumberId) UNION select cu.resellerId from Customer cu where cu.detemeTemplateId = this_.id) in (null, :resellerIds)") ... produces this ... select ... from DeTeMe this_ where ( select cu.resellerId from Customer cu, GeoNumber gn where ( cu.id = gn.customerId and gn.id = this_.geoNumberId ) this_.UNION select cu.resellerId from Customer cu where cu.detemeTemplateId = this_.id ) in ( null, ? ) and 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

17 years

2
5
0 / 0

[Hibernate-JIRA] Created: (HHH-2667) 'illegal attempt to dereference collection' when using auto-join

by Martin Kouba (JIRA)

'illegal attempt to dereference collection' when using auto-join ---------------------------------------------------------------- Key: HHH-2667 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2667 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.4.sp1, 3.2.4, 3.2.3 Environment: I have found that behaviour in version 3.2.4.sp1 and 3.2.3 (I didn't test 3.2.4 pre sp1) Database: ORACLE 10g Reporter: Martin Kouba After upgrading to the latest Hibernate version I got this error. I try to use a statement like this from cat c where c.mate.id = 13 the expected resulting SQL should be something like SELECT * FROM CAT C WHERE C.MATE_ID = 13 which is much more performant than making a join from cat c join c.mate m where m.id = 13 which would result in something like that SELECT * FROM CAT C INNER JOIN MATE M ON C.MATE_ID = M.ID WHERE M.ID = 13 This works as expected in 3.1.3, 3.2.0 and 3.2.2 It doesn't work with version 3.2.3 and with 3.2.4.sp1. -- 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
25
0 / 0

[Hibernate-JIRA] Created: (HHH-2750) Oracle9i dialect do not support SequenceStyleGenerator

by Richard Lee (JIRA)

Oracle9i dialect do not support SequenceStyleGenerator ------------------------------------------------------ Key: HHH-2750 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2750 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.3 Environment: Oracle9i Reporter: Richard Lee Attachments: dynamicMap.hbm.xml In the hibernate.cfg.xml set : <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property> <property name="hbm2ddl.auto">update</property> Java Code: private void createSubnet() { Session session = HibernateSessionFactory.getSession(); HashMap<String, Object> subNet = new HashMap<String, Object>(); subNet.put("ISDELETE", Boolean.FALSE); Timestamp now = DateUtil.getNow(); subNet.put("CREATE_TIME", now); subNet.put("LAST_MODIFY_TIME", now); Transaction tx = session.beginTransaction(); session.save("SUB_NET", subNet); tx.commit(); session.flush(); HibernateSessionFactory.closeSession(); } Exception: Exception in thread "main" java.lang.NoSuchMethodError: org.hibernate.dialect.Dialect.getCreateSequenceStrings(Ljava/lang/String;II)[Ljava/lang/String; at org.hibernate.id.enhanced.SequenceStructure.sqlCreateStrings(SequenceStructure.java:97) at org.hibernate.id.enhanced.SequenceStyleGenerator.sqlCreateStrings(SequenceStyleGenerator.java:168) at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:1051) at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1291) at com.ultrapower.oe.util.HibernateSessionFactory.rebuildSessionFactory(HibernateSessionFactory.java:89) at com.ultrapower.oe.util.HibernateSessionFactory.getSession(HibernateSessionFactory.java:63) -- 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

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-2475) Split lib directory

by Christian Bauer (JIRA)

Split lib directory ------------------- Key: HHH-2475 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2475 Project: Hibernate3 Type: Improvement Components: build Reporter: Christian Bauer I've read again that Hibernate "requires 40 JARs" and that the fantastic Oracle reference implementation does not. This nonsense can only be stopped by splitting the lib/ subdirectory of our distribution into /lib/required, lib/optional, and lib/buildtime. Consider for 3.3. -- 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

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-2682) support for H2 in DialectFactory

by Dan Allen (JIRA)

support for H2 in DialectFactory -------------------------------- Key: HHH-2682 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2682 Project: Hibernate3 Issue Type: Improvement Components: core Affects Versions: 3.2.4.sp1 Environment: Hibernate 3 EJB3 JPA Reporter: Dan Allen For some reason, the H2 database is not included in the dialect factory map, even though there is a Hibernate dialect available for this database. Please add the following to org.hibernate.dialect.DialectFactory MAPPERS.put( "H2", new VersionInsensitiveMapper( "org.hibernate.dialect.H2Dialect" ) ); -- 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

3
6
0 / 0

[Hibernate-JIRA] Created: (HHH-2070) Improvement for DialectFactory

by Martin Renner (JIRA)

Improvement for DialectFactory ------------------------------ Key: HHH-2070 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2070 Project: Hibernate3 Type: Patch Components: core Versions: 3.2.0.cr4 Reporter: Martin Renner Attachments: DialectFactory.patch I would like to have more entries for autodetecting DB2 dialects. According to HHH-1467 I created a patch. At the moment, DialectFactory knows just "DB2/NT". We are currently using DB2Dialect for "DB2/6000" and "DB2/LINUX", but we would like to have Hibernate autodetect these dialects. So the patch simply adds two new lines to DialectFactory. It would be really helpful for us, if this patch would make it into 3.1.x and 3.2.x. The patch works for 3.1.3 and 3.2.0cr4. -- 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

3
4
0 / 0

[Hibernate-JIRA] Created: (HHH-2297) invalid id type error message doesn't report which entity

by Kelly Campbell (JIRA)

invalid id type error message doesn't report which entity --------------------------------------------------------- Key: HHH-2297 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2297 Project: Hibernate3 Type: Patch Components: metamodel Versions: 3.2.0.ga Reporter: Kelly Campbell Priority: Minor Attachments: hibernate-id-type.patch The error message given here makes it very hard to determine what entity has the problem. Simple patch is attached. java.lang.UnsupportedOperationException: not a valid id type at org.hibernate.type.CharacterType.getDefaultValue(CharacterType.java:20) at org.hibernate.engine.UnsavedValueFactory.getUnsavedIdentifierValue(UnsavedValueFactory.java:48) at org.hibernate.tuple.PropertyFactory.buildIdentifierProperty(PropertyFactory.java:44) at org.hibernate.tuple.EntityMetamodel.(EntityMetamodel.java:114) at org.hibernate.persister.entity.AbstractEntityPersister.(AbstractEntityPersister.java:418) at org.hibernate.persister.entity.SingleTableEntityPersister.(SingleTableEntityPersister.java:108) at org.hibernate.persister.PersisterFactory.createClassPersister(PersisterFactory.java:55) at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:223) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1213) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:631) at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:760) at org.hibernate.ejb.Ejb3Configuration.createFactory(Ejb3Configuration.java:151) at org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:205) -- 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

2
1
0 / 0

[Hibernate-JIRA] Created: (HHH-2261) Setting hibernate.hbm2ddl.auto=validate causes problems on mySQL with numeric fields

by Christian Sprajc (JIRA)

Setting hibernate.hbm2ddl.auto=validate causes problems on mySQL with numeric fields ------------------------------------------------------------------------------------ Key: HHH-2261 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2261 Project: Hibernate3 Type: Bug Components: core Versions: 3.2.1 Reporter: Christian Sprajc Hello, We got a Problem when using the following setup: 1) JBoss 4.0.4A with Hibernate 3.2.0 / mySQl 4.x AND 5.x 2) Set hibernate.hbm2ddl.auto=validate 3) Using a usertype which uses the SQL type: Types.NUMERIC When deploying our application I got the following error: 12:43:21,985 INFO [TableMetadata] columns: [paymenttype, amount, oid, remarks, currency, ae_date] 12:43:21,985 WARN [ServiceController] Problem starting service persistence.units:jar=com.riege.pogo_0.1.4.jar,unitName=PogoEntityManager org.hibernate.HibernateException: Wrong column type: amount, expected: numeric(19,2) at org.hibernate.mapping.Table.validateColumns(Table.java:251) at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1002) The Problem is: 1) When hibernate creates (e.g. hibernate.hbm2ddl.auto=update) through the columns in the mySQL database it creates it as "numeric(x,y)" field. 2) mySQL always converts "numeric(x,y)" to "decimal(x,y)". The metadata returns "decimal(x,y)" 3) When deploying with "hibernate.hbm2ddl.auto=validate" to error above is thrown. The problem is that hibernate expects a "numeric(x,y)" type but mysql returns a "decimal(x,y)" A workaround I'm now using is a fixed mySQL dialect which correctly handles Types.DECIMAL / "decimal(x,y)": public class FixedMySQLDialect extends org.hibernate.dialect.MySQLDialect { public FixedMySQLDialect() { super(); registerColumnType(Types.NUMERIC, "decimal(19, $l)"); registerColumnType(Types.DECIMAL, "decimal(19, $l)"); } } -- 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

2
3
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues July 2007