[Hibernate-JIRA] Commented: (HHH-1900) Prepared Statement closed before executed by AbstractBatcher - similar to HHH-876
by Gail Badner (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1900?page=c... ]
Gail Badner commented on HHH-1900:
----------------------------------
My guess is that a corrupt prepared statement gets cached and reused.
What version of Hibernate are you using?
Please attach mappings and any queries (e.g., criteria, HQL, named, native) that are involved with this exception.
> Prepared Statement closed before executed by AbstractBatcher - similar to HHH-876
> ---------------------------------------------------------------------------------
>
> Key: HHH-1900
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1900
> Project: Hibernate3
> Issue Type: Bug
> Components: core
> Affects Versions: 3.1.3
> Environment: hibernate 3.1.3, MS SQL Server, Apache DBCP, JSQLConnect
> Reporter: Greg Burcher
> Priority: Critical
>
> Using Hibernate v3.1.3, I am experiencing symptoms that sound like bug HHH-876. Problem has been intermittent, may be related to timing/latency. Problem happens less frequently when lots of hibernate debug logging is turned on. Using JDBC drivers from jnetdirect, get com.jnetdirect.jsql.JSQLException with message of "The statement is closed".
> Failure occurs on a variety of queries, but only occasionally for any given query. Once the problem has occurred for a particular query (prepared statement), problem will occur every time from that point on for that query.
> Here is debug trace pattern of successful query:
> 10:05:40,099 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
> 10:05:40,099 DEBUG ConnectionManager:358 - opening JDBC connection
> 10:05:40,109 DEBUG DBCPConnectionProvider:? - active: 1 (max: 20) idle: 0(max: 20)
> Hibernate: select this_.id as id27_0_, this_.language as language27_0_, this_.enabled as enabled27_0_, this_.sourceID as sourceID27_0_, this_.focusQuestion as focusQue5_27_0_, this_.markedFocusQuestion as markedFo6_27_0_ from WebInquiryFocusQuestion this_ where this_.id=? and this_.enabled=? and this_.language=?
> 10:05:40,109 DEBUG AbstractBatcher:424 - preparing statement
> 10:05:40,109 DEBUG AbstractBatcher:327 - about to open ResultSet (open ResultSets: 0, globally: 0)
> 10:05:40,109 DEBUG AbstractBatcher:334 - about to close ResultSet (open ResultSets: 1, globally: 1)
> 10:05:40,109 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
> 10:05:40,109 DEBUG AbstractBatcher:470 - closing statement
> 10:05:40,119 DEBUG JDBCContext:213 - after autocommit
> 10:05:40,119 DEBUG ConnectionManager:341 - aggressively releasing JDBC connection
> 10:05:40,119 DEBUG ConnectionManager:378 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
> 10:05:40,119 DEBUG DBCPConnectionProvider:? - active: 0 (max: 20) idle: 1(max: 20)
> versus trace when error occurs:
> 10:05:41,481 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
> 10:05:41,481 DEBUG ConnectionManager:358 - opening JDBC connection
> 10:05:41,481 DEBUG DBCPConnectionProvider:? - active: 1 (max: 20) idle: 0(max: 20)
> Hibernate: select this_.id as id27_0_, this_.language as language27_0_, this_.enabled as enabled27_0_, this_.sourceID as sourceID27_0_, this_.focusQuestion as focusQue5_27_0_, this_.markedFocusQuestion as markedFo6_27_0_ from WebInquiryFocusQuestion this_ where this_.id=? and this_.enabled=? and this_.language=?
> 10:05:41,481 DEBUG AbstractBatcher:424 - preparing statement
> 10:05:41,481 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
> 10:05:41,481 DEBUG AbstractBatcher:470 - closing statement
> 10:05:41,501 WARN JDBCExceptionReporter:71 - SQL Error: 0, SQLState: null
> 10:05:41,501 ERROR JDBCExceptionReporter:72 - The statement is closed
> 10:05:41,511 DEBUG JDBCContext:213 - after autocommit
> 10:05:41,511 DEBUG ConnectionManager:341 - aggressively releasing JDBC connection
> 10:05:41,511 DEBUG ConnectionManager:378 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
> 10:05:41,511 DEBUG DBCPConnectionProvider:? - active: 0 (max: 20) idle: 1(max: 20)
> 10:05:41,511 DEBUG ConnectionManager:312 - connection already null in cleanup : no action
> Partial stack trace:
> [0] com.jnetdirect.jsql.JSQLException.makeFromDriverError:70 (in file JSQLException.java)
> [1] com.jnetdirect.jsql.JSQLStatement.setParam:1223 (in file JSQLStatement.java)
> [2] com.jnetdirect.jsql.JSQLPreparedStatement.setInt:693 (in file JSQLPreparedStatement.java)
> [3] org.apache.commons.dbcp.DelegatingPreparedStatement.setInt:116 (in file DelegatingPreparedStatement.java)
> [4] org.apache.commons.dbcp.DelegatingPreparedStatement.setInt:116 (in file DelegatingPreparedStatement.java)
> [5] org.hibernate.type.IntegerType.set:41 (in file IntegerType.java)
> [6] org.hibernate.type.NullableType.nullSafeSet:85 (in file NullableType.java)
> [7] org.hibernate.type.NullableType.nullSafeSet:63 (in file NullableType.java)
> [8] org.hibernate.loader.Loader.bindPositionalParameters:1514 (in file Loader.java)
> [9] org.hibernate.loader.Loader.prepareQueryStatement:1576 (in file Loader.java)
> [10] org.hibernate.loader.Loader.doQuery:661 (in file Loader.java)
> [11] org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections:224 (in file Loader.java)
> [12] org.hibernate.loader.Loader.doList:2145 (in file Loader.java)
> [13] org.hibernate.loader.Loader.listIgnoreQueryCache:2029 (in file Loader.java)
> [14] org.hibernate.loader.Loader.list:2024 (in file Loader.java)
> [15] org.hibernate.loader.criteria.CriteriaLoader.list:94 (in file CriteriaLoader.java)
> [16] org.hibernate.impl.SessionImpl.list:1552 (in file SessionImpl.java)
> [17] org.hibernate.impl.CriteriaImpl.list:283 (in file CriteriaImpl.java)
> [18] org.hibernate.impl.CriteriaImpl.uniqueResult:305 (in file CriteriaImpl.java)
> Stack trace will differ depending on which query triggers the problem.
--
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, 4 months
[Hibernate-JIRA] Commented: (HHH-1900) Prepared Statement closed before executed by AbstractBatcher - similar to HHH-876
by breako (JIRA)
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1900?page=c... ]
breako commented on HHH-1900:
-----------------------------
Hi Nicolas,
I am experiencing similar issue, any idea for fix.
Thanks
> Prepared Statement closed before executed by AbstractBatcher - similar to HHH-876
> ---------------------------------------------------------------------------------
>
> Key: HHH-1900
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1900
> Project: Hibernate3
> Issue Type: Bug
> Components: core
> Affects Versions: 3.1.3
> Environment: hibernate 3.1.3, MS SQL Server, Apache DBCP, JSQLConnect
> Reporter: Greg Burcher
> Priority: Critical
>
> Using Hibernate v3.1.3, I am experiencing symptoms that sound like bug HHH-876. Problem has been intermittent, may be related to timing/latency. Problem happens less frequently when lots of hibernate debug logging is turned on. Using JDBC drivers from jnetdirect, get com.jnetdirect.jsql.JSQLException with message of "The statement is closed".
> Failure occurs on a variety of queries, but only occasionally for any given query. Once the problem has occurred for a particular query (prepared statement), problem will occur every time from that point on for that query.
> Here is debug trace pattern of successful query:
> 10:05:40,099 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
> 10:05:40,099 DEBUG ConnectionManager:358 - opening JDBC connection
> 10:05:40,109 DEBUG DBCPConnectionProvider:? - active: 1 (max: 20) idle: 0(max: 20)
> Hibernate: select this_.id as id27_0_, this_.language as language27_0_, this_.enabled as enabled27_0_, this_.sourceID as sourceID27_0_, this_.focusQuestion as focusQue5_27_0_, this_.markedFocusQuestion as markedFo6_27_0_ from WebInquiryFocusQuestion this_ where this_.id=? and this_.enabled=? and this_.language=?
> 10:05:40,109 DEBUG AbstractBatcher:424 - preparing statement
> 10:05:40,109 DEBUG AbstractBatcher:327 - about to open ResultSet (open ResultSets: 0, globally: 0)
> 10:05:40,109 DEBUG AbstractBatcher:334 - about to close ResultSet (open ResultSets: 1, globally: 1)
> 10:05:40,109 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
> 10:05:40,109 DEBUG AbstractBatcher:470 - closing statement
> 10:05:40,119 DEBUG JDBCContext:213 - after autocommit
> 10:05:40,119 DEBUG ConnectionManager:341 - aggressively releasing JDBC connection
> 10:05:40,119 DEBUG ConnectionManager:378 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
> 10:05:40,119 DEBUG DBCPConnectionProvider:? - active: 0 (max: 20) idle: 1(max: 20)
> versus trace when error occurs:
> 10:05:41,481 DEBUG AbstractBatcher:311 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
> 10:05:41,481 DEBUG ConnectionManager:358 - opening JDBC connection
> 10:05:41,481 DEBUG DBCPConnectionProvider:? - active: 1 (max: 20) idle: 0(max: 20)
> Hibernate: select this_.id as id27_0_, this_.language as language27_0_, this_.enabled as enabled27_0_, this_.sourceID as sourceID27_0_, this_.focusQuestion as focusQue5_27_0_, this_.markedFocusQuestion as markedFo6_27_0_ from WebInquiryFocusQuestion this_ where this_.id=? and this_.enabled=? and this_.language=?
> 10:05:41,481 DEBUG AbstractBatcher:424 - preparing statement
> 10:05:41,481 DEBUG AbstractBatcher:319 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
> 10:05:41,481 DEBUG AbstractBatcher:470 - closing statement
> 10:05:41,501 WARN JDBCExceptionReporter:71 - SQL Error: 0, SQLState: null
> 10:05:41,501 ERROR JDBCExceptionReporter:72 - The statement is closed
> 10:05:41,511 DEBUG JDBCContext:213 - after autocommit
> 10:05:41,511 DEBUG ConnectionManager:341 - aggressively releasing JDBC connection
> 10:05:41,511 DEBUG ConnectionManager:378 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
> 10:05:41,511 DEBUG DBCPConnectionProvider:? - active: 0 (max: 20) idle: 1(max: 20)
> 10:05:41,511 DEBUG ConnectionManager:312 - connection already null in cleanup : no action
> Partial stack trace:
> [0] com.jnetdirect.jsql.JSQLException.makeFromDriverError:70 (in file JSQLException.java)
> [1] com.jnetdirect.jsql.JSQLStatement.setParam:1223 (in file JSQLStatement.java)
> [2] com.jnetdirect.jsql.JSQLPreparedStatement.setInt:693 (in file JSQLPreparedStatement.java)
> [3] org.apache.commons.dbcp.DelegatingPreparedStatement.setInt:116 (in file DelegatingPreparedStatement.java)
> [4] org.apache.commons.dbcp.DelegatingPreparedStatement.setInt:116 (in file DelegatingPreparedStatement.java)
> [5] org.hibernate.type.IntegerType.set:41 (in file IntegerType.java)
> [6] org.hibernate.type.NullableType.nullSafeSet:85 (in file NullableType.java)
> [7] org.hibernate.type.NullableType.nullSafeSet:63 (in file NullableType.java)
> [8] org.hibernate.loader.Loader.bindPositionalParameters:1514 (in file Loader.java)
> [9] org.hibernate.loader.Loader.prepareQueryStatement:1576 (in file Loader.java)
> [10] org.hibernate.loader.Loader.doQuery:661 (in file Loader.java)
> [11] org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections:224 (in file Loader.java)
> [12] org.hibernate.loader.Loader.doList:2145 (in file Loader.java)
> [13] org.hibernate.loader.Loader.listIgnoreQueryCache:2029 (in file Loader.java)
> [14] org.hibernate.loader.Loader.list:2024 (in file Loader.java)
> [15] org.hibernate.loader.criteria.CriteriaLoader.list:94 (in file CriteriaLoader.java)
> [16] org.hibernate.impl.SessionImpl.list:1552 (in file SessionImpl.java)
> [17] org.hibernate.impl.CriteriaImpl.list:283 (in file CriteriaImpl.java)
> [18] org.hibernate.impl.CriteriaImpl.uniqueResult:305 (in file CriteriaImpl.java)
> Stack trace will differ depending on which query triggers the problem.
--
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, 4 months
[Hibernate-JIRA] Created: (ANN-768) Getting org.hibernate.MappingException for basic Hibernate annotations application
by Mandar Shukla (JIRA)
Getting org.hibernate.MappingException for basic Hibernate annotations application
----------------------------------------------------------------------------------
Key: ANN-768
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-768
Project: Hibernate Annotations
Issue Type: New Feature
Affects Versions: 3.3.0.ga
Environment: Hibernate 3.3, MySql 5, Eclipse 3
Reporter: Mandar Shukla
Hi,
I'm trying Hibernate annotations program along with a business object having 4 attributes.
I referred one of the online tutorial and created BO class with annotations, HibernateUtil.java, hibernate.cfg.xml, and .java with main method in it for execution.
Everything compiled successfully in eclipse but while executing I got below mentioned exception:
Exception in thread "main" org.hibernate.MappingException: Unknown entity: com.flylite.ticketing.model.FlightMaster
at org.hibernate.impl.SessionFactoryImpl.getEntityPersister(SessionFactoryImpl.java:557)
at org.hibernate.impl.SessionImpl.getEntityPersister(SessionImpl.java:1342)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:98)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:539)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:527)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:318)
at $Proxy9.save(Unknown Source)
at com.flylite.ticketing.application.TestFlightManager.main(TestFlightManager.java:23)
I followed all the steps as per given in tutorial apart from @Table (name="") as we have to use appliesTo in latest version.
I doubt (I may be wrong) on @Table(appliesTo="") tag, as I tried similar program couple of months back with lower version of Hibernate where tag was @Table(name=""), and it ran successfully.
Please helpe me in this issue. Let me know in case I need to upload my files.
Regards
Mandar
--
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, 4 months
[Hibernate-JIRA] Created: (HHH-3443) Cannot get UTF-8 Strings from MySQL DB
by Chris Welz (JIRA)
Cannot get UTF-8 Strings from MySQL DB
--------------------------------------
Key: HHH-3443
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3443
Project: Hibernate3
Issue Type: Bug
Affects Versions: 3.2.6
Environment: MySQL 5, JRE 1.6
Reporter: Chris Welz
Hi,
I've tried now for 2 days to get my Hibernate Application reading UTF-8 Strings from the Database with no success.
I created my Database with the following SQL Script:
CREATE TABLE IF NOT EXISTS `t_gvz_type_name` (
`ID_GVZ_Type_Name_intern` int(11) NOT NULL,
`Type_GVZ` int(11) default NULL COMMENT 'Typ der Gebietskörperschaft',
`Name_GVZ_Type` varchar(50) default NULL COMMENT 'Name des Types der Gebietskörperschaft',
`LanguageID` int(11) default NULL,
PRIMARY KEY (`ID_GVZ_Type_Name_intern`),
KEY `FK_GVZ_Type_Name_Language` (`LanguageID`),
KEY `FK_GVZ_Type_Name` (`Type_GVZ`)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COMMENT='Name des Gebietskörperschaftstypes';
My hibernate.cfg.xml:
<property name="hibernate.bytecode.use_reflection_optimizer">false</property>
<property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
<property name="hibernate.connection.password">christian</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/vzf_net?useUnicode=true&characterEncoding=utf8</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.current_session_context_class">org.hibernate.context.ThreadLocalSessionContext</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
This is, how I try to get the values from DB:
List result = session.createQuery("from TGvzTypeName where TGzvType="+TypeGvz).list();
What do I have to do to get the Strings in UTF-8 ?
--
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, 4 months