Menu
▾
▴
hibernate-issues — Hibernate JIRA Notifications
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(32) |
Jun
(175) |
Jul
(209) |
Aug
(302) |
Sep
(287) |
Oct
(339) |
Nov
(314) |
Dec
(329) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(479) |
Feb
(389) |
Mar
(599) |
Apr
(307) |
May
(390) |
Jun
(300) |
Jul
(410) |
Aug
(458) |
Sep
(299) |
Oct
(315) |
Nov
(363) |
Dec
(529) |
| 2005 |
Jan
(568) |
Feb
(434) |
Mar
(1004) |
Apr
(823) |
May
(767) |
Jun
(763) |
Jul
(854) |
Aug
(862) |
Sep
(560) |
Oct
(853) |
Nov
(763) |
Dec
(731) |
| 2006 |
Jan
(776) |
Feb
(608) |
Mar
(657) |
Apr
(424) |
May
(559) |
Jun
(440) |
Jul
(448) |
Aug
(58) |
Sep
|
Oct
(17) |
Nov
(16) |
Dec
(8) |
| 2007 |
Jan
(1) |
Feb
(8) |
Mar
(2) |
Apr
(5) |
May
(3) |
Jun
(3) |
Jul
(3) |
Aug
(16) |
Sep
(10) |
Oct
(4) |
Nov
(4) |
Dec
(4) |
| 2008 |
Jan
(8) |
Feb
(1) |
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
|
From: <leg...@at...> - 2003-12-30 23:21:26
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Tue, 30 Dec 2003 5:21 PM
Body:
As posted in the forum - this error is INSIDE the jdbc driver while it's trying to load something - probably a native dll file or something (look at at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1744)...this has NOTHING to do with Hibernate - it is a configuration issue of jdbc driver.
Please analyse it better! Step through the code or something!
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-590
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-590
Summary: Websphere 4.x and hibernate 2.1 incompatibility
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Versions:
2.1
Assignee:
Reporter: Niraj
Created: Tue, 30 Dec 2003 5:01 PM
Updated: Tue, 30 Dec 2003 5:21 PM
Environment: Websphere 4.x / Db2 version 7.2
Description:
Cannot build the Session Factory in Websphere 4.x with hibernate 2.1
Steps :
1. use the config file as shown below
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">COM.ibm.db2.jdbc.app.DB2Driver</property>
<property name="connection.url">jdbc:db2:ENTDB</property>
<property name="connection.username">db2admin</property>
<property name="connection.password">db2admin</property>
<property name="show_sql">true</property>
<property name="dialect">net.sf.hibernate.dialect.DB2Dialect</property>
<!--
<property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">net.sf.hibernate.transaction.WebSphereTransactionManagerLookup</property>
<property name="jta.UserTransaction">UserTransaction</property>
-->
<mapping resource="resources/xml/BankInformation.hbm.xml"/>
</session-factory>
</hibernate-configuration>
2. Call the method
sessionFactory = new Configuration().configure().buildSessionFactory();
3. We see a Stack trace like this
2003-12-30 15:01:07,973 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
java.lang.ExceptionInInitializerError: java.lang.NullPointerException
at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code))
at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code))
at java.io.Win32FileSystem.getUserPath(Win32FileSystem.java:283)
at java.io.Win32FileSystem.resolve(Win32FileSystem.java:299)
at java.io.File.getCanonicalPath(File.java:454)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1744)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1685)
at java.lang.Runtime.loadLibrary0(Runtime.java:780)
at java.lang.System.loadLibrary(System.java:865)
at COM.ibm.db2.jdbc.app.DB2Driver.<init>(DB2Driver.java:227)
at COM.ibm.db2.jdbc.app.DB2Driver.<clinit>(DB2Driver.java:130)
at java.lang.Class.forName1(Native Method)
at java.lang.Class.forName(Class.java:142)
at net.sf.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:53)
at net.sf.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:83)
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:64)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1091)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:737)
at com.i21.autopay.framework.persist.HibernateManager.init(HibernateManager.java:39)
at test.workarea.TestHibernate.testHibernate(TestHibernate.java:42)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:166)
at junit.framework.TestCase.runBare(TestCase.java:140)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:131)
at junit.framework.TestSuite.runTest(TestSuite.java:173)
at junit.framework.TestSuite.run(TestSuite.java:168)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:329)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:218)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:151)
4. Please note that I recompiled the code with jdk1.3
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 23:06:25
|
The following comment has been added to this issue:
Author: Niraj
Created: Tue, 30 Dec 2003 5:04 PM
Body:
Please note that I dont see the problem in hibernate 2.03
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-590
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-590
Summary: Websphere 4.x and hibernate 2.1 incompatibility
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Versions:
2.1
Assignee:
Reporter: Niraj
Created: Tue, 30 Dec 2003 5:01 PM
Updated: Tue, 30 Dec 2003 5:04 PM
Environment: Websphere 4.x / Db2 version 7.2
Description:
Cannot build the Session Factory in Websphere 4.x with hibernate 2.1
Steps :
1. use the config file as shown below
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">COM.ibm.db2.jdbc.app.DB2Driver</property>
<property name="connection.url">jdbc:db2:ENTDB</property>
<property name="connection.username">db2admin</property>
<property name="connection.password">db2admin</property>
<property name="show_sql">true</property>
<property name="dialect">net.sf.hibernate.dialect.DB2Dialect</property>
<!--
<property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">net.sf.hibernate.transaction.WebSphereTransactionManagerLookup</property>
<property name="jta.UserTransaction">UserTransaction</property>
-->
<mapping resource="resources/xml/BankInformation.hbm.xml"/>
</session-factory>
</hibernate-configuration>
2. Call the method
sessionFactory = new Configuration().configure().buildSessionFactory();
3. We see a Stack trace like this
2003-12-30 15:01:07,973 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
java.lang.ExceptionInInitializerError: java.lang.NullPointerException
at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code))
at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code))
at java.io.Win32FileSystem.getUserPath(Win32FileSystem.java:283)
at java.io.Win32FileSystem.resolve(Win32FileSystem.java:299)
at java.io.File.getCanonicalPath(File.java:454)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1744)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1685)
at java.lang.Runtime.loadLibrary0(Runtime.java:780)
at java.lang.System.loadLibrary(System.java:865)
at COM.ibm.db2.jdbc.app.DB2Driver.<init>(DB2Driver.java:227)
at COM.ibm.db2.jdbc.app.DB2Driver.<clinit>(DB2Driver.java:130)
at java.lang.Class.forName1(Native Method)
at java.lang.Class.forName(Class.java:142)
at net.sf.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:53)
at net.sf.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:83)
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:64)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1091)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:737)
at com.i21.autopay.framework.persist.HibernateManager.init(HibernateManager.java:39)
at test.workarea.TestHibernate.testHibernate(TestHibernate.java:42)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:166)
at junit.framework.TestCase.runBare(TestCase.java:140)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:131)
at junit.framework.TestSuite.runTest(TestSuite.java:173)
at junit.framework.TestSuite.run(TestSuite.java:168)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:329)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:218)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:151)
4. Please note that I recompiled the code with jdk1.3
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 23:04:26
|
The following issue has been updated:
Updater: Niraj (mailto:nj...@ho...)
Date: Tue, 30 Dec 2003 5:04 PM
Changes:
Attachment changed to HibernateManager.java
---------------------------------------------------------------------
For a full history of the issue, see:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-590&page=history
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-590
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-590
Summary: Websphere 4.x and hibernate 2.1 incompatibility
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Versions:
2.1
Assignee:
Reporter: Niraj
Created: Tue, 30 Dec 2003 5:01 PM
Updated: Tue, 30 Dec 2003 5:04 PM
Environment: Websphere 4.x / Db2 version 7.2
Description:
Cannot build the Session Factory in Websphere 4.x with hibernate 2.1
Steps :
1. use the config file as shown below
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">COM.ibm.db2.jdbc.app.DB2Driver</property>
<property name="connection.url">jdbc:db2:ENTDB</property>
<property name="connection.username">db2admin</property>
<property name="connection.password">db2admin</property>
<property name="show_sql">true</property>
<property name="dialect">net.sf.hibernate.dialect.DB2Dialect</property>
<!--
<property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">net.sf.hibernate.transaction.WebSphereTransactionManagerLookup</property>
<property name="jta.UserTransaction">UserTransaction</property>
-->
<mapping resource="resources/xml/BankInformation.hbm.xml"/>
</session-factory>
</hibernate-configuration>
2. Call the method
sessionFactory = new Configuration().configure().buildSessionFactory();
3. We see a Stack trace like this
2003-12-30 15:01:07,973 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
java.lang.ExceptionInInitializerError: java.lang.NullPointerException
at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code))
at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code))
at java.io.Win32FileSystem.getUserPath(Win32FileSystem.java:283)
at java.io.Win32FileSystem.resolve(Win32FileSystem.java:299)
at java.io.File.getCanonicalPath(File.java:454)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1744)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1685)
at java.lang.Runtime.loadLibrary0(Runtime.java:780)
at java.lang.System.loadLibrary(System.java:865)
at COM.ibm.db2.jdbc.app.DB2Driver.<init>(DB2Driver.java:227)
at COM.ibm.db2.jdbc.app.DB2Driver.<clinit>(DB2Driver.java:130)
at java.lang.Class.forName1(Native Method)
at java.lang.Class.forName(Class.java:142)
at net.sf.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:53)
at net.sf.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:83)
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:64)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1091)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:737)
at com.i21.autopay.framework.persist.HibernateManager.init(HibernateManager.java:39)
at test.workarea.TestHibernate.testHibernate(TestHibernate.java:42)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:166)
at junit.framework.TestCase.runBare(TestCase.java:140)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:131)
at junit.framework.TestSuite.runTest(TestSuite.java:173)
at junit.framework.TestSuite.run(TestSuite.java:168)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:329)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:218)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:151)
4. Please note that I recompiled the code with jdk1.3
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 23:04:26
|
The following issue has been updated:
Updater: Niraj (mailto:nj...@ho...)
Date: Tue, 30 Dec 2003 5:03 PM
Changes:
Attachment changed to TestHibernate.java
---------------------------------------------------------------------
For a full history of the issue, see:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-590&page=history
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-590
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-590
Summary: Websphere 4.x and hibernate 2.1 incompatibility
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Versions:
2.1
Assignee:
Reporter: Niraj
Created: Tue, 30 Dec 2003 5:01 PM
Updated: Tue, 30 Dec 2003 5:03 PM
Environment: Websphere 4.x / Db2 version 7.2
Description:
Cannot build the Session Factory in Websphere 4.x with hibernate 2.1
Steps :
1. use the config file as shown below
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">COM.ibm.db2.jdbc.app.DB2Driver</property>
<property name="connection.url">jdbc:db2:ENTDB</property>
<property name="connection.username">db2admin</property>
<property name="connection.password">db2admin</property>
<property name="show_sql">true</property>
<property name="dialect">net.sf.hibernate.dialect.DB2Dialect</property>
<!--
<property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">net.sf.hibernate.transaction.WebSphereTransactionManagerLookup</property>
<property name="jta.UserTransaction">UserTransaction</property>
-->
<mapping resource="resources/xml/BankInformation.hbm.xml"/>
</session-factory>
</hibernate-configuration>
2. Call the method
sessionFactory = new Configuration().configure().buildSessionFactory();
3. We see a Stack trace like this
2003-12-30 15:01:07,973 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
java.lang.ExceptionInInitializerError: java.lang.NullPointerException
at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code))
at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code))
at java.io.Win32FileSystem.getUserPath(Win32FileSystem.java:283)
at java.io.Win32FileSystem.resolve(Win32FileSystem.java:299)
at java.io.File.getCanonicalPath(File.java:454)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1744)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1685)
at java.lang.Runtime.loadLibrary0(Runtime.java:780)
at java.lang.System.loadLibrary(System.java:865)
at COM.ibm.db2.jdbc.app.DB2Driver.<init>(DB2Driver.java:227)
at COM.ibm.db2.jdbc.app.DB2Driver.<clinit>(DB2Driver.java:130)
at java.lang.Class.forName1(Native Method)
at java.lang.Class.forName(Class.java:142)
at net.sf.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:53)
at net.sf.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:83)
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:64)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1091)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:737)
at com.i21.autopay.framework.persist.HibernateManager.init(HibernateManager.java:39)
at test.workarea.TestHibernate.testHibernate(TestHibernate.java:42)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:166)
at junit.framework.TestCase.runBare(TestCase.java:140)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:131)
at junit.framework.TestSuite.runTest(TestSuite.java:173)
at junit.framework.TestSuite.run(TestSuite.java:168)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:329)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:218)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:151)
4. Please note that I recompiled the code with jdk1.3
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 23:04:26
|
The following issue has been updated:
Updater: Niraj (mailto:nj...@ho...)
Date: Tue, 30 Dec 2003 5:03 PM
Comment:
configuration file
Changes:
Attachment changed to hibernate.cfg.xml
---------------------------------------------------------------------
For a full history of the issue, see:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-590&page=history
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-590
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-590
Summary: Websphere 4.x and hibernate 2.1 incompatibility
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Versions:
2.1
Assignee:
Reporter: Niraj
Created: Tue, 30 Dec 2003 5:01 PM
Updated: Tue, 30 Dec 2003 5:03 PM
Environment: Websphere 4.x / Db2 version 7.2
Description:
Cannot build the Session Factory in Websphere 4.x with hibernate 2.1
Steps :
1. use the config file as shown below
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">COM.ibm.db2.jdbc.app.DB2Driver</property>
<property name="connection.url">jdbc:db2:ENTDB</property>
<property name="connection.username">db2admin</property>
<property name="connection.password">db2admin</property>
<property name="show_sql">true</property>
<property name="dialect">net.sf.hibernate.dialect.DB2Dialect</property>
<!--
<property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>
<property name="transaction.manager_lookup_class">net.sf.hibernate.transaction.WebSphereTransactionManagerLookup</property>
<property name="jta.UserTransaction">UserTransaction</property>
-->
<mapping resource="resources/xml/BankInformation.hbm.xml"/>
</session-factory>
</hibernate-configuration>
2. Call the method
sessionFactory = new Configuration().configure().buildSessionFactory();
3. We see a Stack trace like this
2003-12-30 15:01:07,973 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
java.lang.ExceptionInInitializerError: java.lang.NullPointerException
at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code))
at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code))
at java.io.Win32FileSystem.getUserPath(Win32FileSystem.java:283)
at java.io.Win32FileSystem.resolve(Win32FileSystem.java:299)
at java.io.File.getCanonicalPath(File.java:454)
at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1744)
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1685)
at java.lang.Runtime.loadLibrary0(Runtime.java:780)
at java.lang.System.loadLibrary(System.java:865)
at COM.ibm.db2.jdbc.app.DB2Driver.<init>(DB2Driver.java:227)
at COM.ibm.db2.jdbc.app.DB2Driver.<clinit>(DB2Driver.java:130)
at java.lang.Class.forName1(Native Method)
at java.lang.Class.forName(Class.java:142)
at net.sf.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:53)
at net.sf.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:83)
at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:64)
at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1091)
at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:737)
at com.i21.autopay.framework.persist.HibernateManager.init(HibernateManager.java:39)
at test.workarea.TestHibernate.testHibernate(TestHibernate.java:42)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:166)
at junit.framework.TestCase.runBare(TestCase.java:140)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:131)
at junit.framework.TestSuite.runTest(TestSuite.java:173)
at junit.framework.TestSuite.run(TestSuite.java:168)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:329)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:218)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:151)
4. Please note that I recompiled the code with jdk1.3
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 23:02:25
|
Message: A new issue has been created in JIRA. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-590 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-590 Summary: Websphere 4.x and hibernate 2.1 incompatibility Type: Bug Status: Unassigned Priority: Major Project: Hibernate2 Versions: 2.1 Assignee: Reporter: Niraj Created: Tue, 30 Dec 2003 5:01 PM Updated: Tue, 30 Dec 2003 5:01 PM Environment: Websphere 4.x / Db2 version 7.2 Description: Cannot build the Session Factory in Websphere 4.x with hibernate 2.1 Steps : 1. use the config file as shown below <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd"> <hibernate-configuration> <session-factory> <property name="connection.driver_class">COM.ibm.db2.jdbc.app.DB2Driver</property> <property name="connection.url">jdbc:db2:ENTDB</property> <property name="connection.username">db2admin</property> <property name="connection.password">db2admin</property> <property name="show_sql">true</property> <property name="dialect">net.sf.hibernate.dialect.DB2Dialect</property> <!-- <property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property> <property name="transaction.manager_lookup_class">net.sf.hibernate.transaction.WebSphereTransactionManagerLookup</property> <property name="jta.UserTransaction">UserTransaction</property> --> <mapping resource="resources/xml/BankInformation.hbm.xml"/> </session-factory> </hibernate-configuration> 2. Call the method sessionFactory = new Configuration().configure().buildSessionFactory(); 3. We see a Stack trace like this 2003-12-30 15:01:07,973 [main] INFO net.sf.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20 java.lang.ExceptionInInitializerError: java.lang.NullPointerException at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code)) at java.io.Win32FileSystem.normalize(Win32FileSystem.java(Compiled Code)) at java.io.Win32FileSystem.getUserPath(Win32FileSystem.java:283) at java.io.Win32FileSystem.resolve(Win32FileSystem.java:299) at java.io.File.getCanonicalPath(File.java:454) at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1744) at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1685) at java.lang.Runtime.loadLibrary0(Runtime.java:780) at java.lang.System.loadLibrary(System.java:865) at COM.ibm.db2.jdbc.app.DB2Driver.<init>(DB2Driver.java:227) at COM.ibm.db2.jdbc.app.DB2Driver.<clinit>(DB2Driver.java:130) at java.lang.Class.forName1(Native Method) at java.lang.Class.forName(Class.java:142) at net.sf.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:53) at net.sf.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:83) at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:64) at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1091) at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:737) at com.i21.autopay.framework.persist.HibernateManager.init(HibernateManager.java:39) at test.workarea.TestHibernate.testHibernate(TestHibernate.java:42) at java.lang.reflect.Method.invoke(Native Method) at junit.framework.TestCase.runTest(TestCase.java:166) at junit.framework.TestCase.runBare(TestCase.java:140) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:131) at junit.framework.TestSuite.runTest(TestSuite.java:173) at junit.framework.TestSuite.run(TestSuite.java:168) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:329) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:218) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:151) 4. Please note that I recompiled the code with jdk1.3 --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
|
From: <leg...@at...> - 2003-12-30 21:17:25
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Tue, 30 Dec 2003 3:15 PM
Body:
Please do - i guess it is just a another "try to look up class, if not availablet try the next option"
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-589
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-589
Summary: websphere 5.1 transaction manager lookup
Type: Bug
Status: Unassigned
Priority: Major
Project: Hibernate2
Components:
core
Versions:
2.1.1
Assignee:
Reporter: Edina Pimp
Created: Tue, 30 Dec 2003 1:38 PM
Updated: Tue, 30 Dec 2003 3:15 PM
Environment: websphere 5.1
Description:
WebSphere 5.1 changed the name of the TransactionManagerFactory class. Class is now:
com.ibm.ws.Transaction.TransactionManagerFactory
As a result, the net.sf.hibernate.transaction.WebSphereTransactionManagerLookup strategy will need to be updated to look for this class. I can provide working patch if needed.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 19:40:26
|
Message: A new issue has been created in JIRA. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-589 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-589 Summary: websphere 5.1 transaction manager lookup Type: Bug Status: Unassigned Priority: Major Project: Hibernate2 Components: core Versions: 2.1.1 Assignee: Reporter: Edina Pimp Created: Tue, 30 Dec 2003 1:38 PM Updated: Tue, 30 Dec 2003 1:38 PM Environment: websphere 5.1 Description: WebSphere 5.1 changed the name of the TransactionManagerFactory class. Class is now: com.ibm.ws.Transaction.TransactionManagerFactory As a result, the net.sf.hibernate.transaction.WebSphereTransactionManagerLookup strategy will need to be updated to look for this class. I can provide working patch if needed. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
|
From: <leg...@at...> - 2003-12-30 17:35:25
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Tue, 30 Dec 2003 11:34 AM
Body:
I have now committed the parts of Informix9Dialect about the foreign and primary key constraints generation.
The type stuff I won't do anything about before someone confirms that it is really necessary ;)
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-414
Summary: Informix dialect creates syntax errors in IDS 9.4
Type: Bug
Status: Open
Priority: Major
Project: Hibernate2
Versions:
2.0.2
Assignee: Max Rydahl Andersen
Reporter: Finn McCann
Created: Tue, 21 Oct 2003 11:01 AM
Updated: Tue, 30 Dec 2003 11:34 AM
Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box.
Description:
Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues:
1. Serial ids:
<id name="id" column="ID" length="32" unsaved-value="null">
<generator class="uuid.hex"/>
</id>
creates a data type:
INT8 SERIAL
instead of:
SERIAL8
The "INT8 SERIAL" causes a syntax error in IDS 9.4.
2. Foreign Key constraint names:
<set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc">
<key column="NETWORK_ID" length="32"/>
<one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/>
</set>
creates this ALTER TABLE statement:
alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK
instead of:
alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC
Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error.
This also applies to adding UNIQUE CONSTRAINTs.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 17:32:26
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Tue, 30 Dec 2003 11:32 AM
Body:
whoops - sorry that method is just old and now removed ;)
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-414
Summary: Informix dialect creates syntax errors in IDS 9.4
Type: Bug
Status: Open
Priority: Major
Project: Hibernate2
Versions:
2.0.2
Assignee: Max Rydahl Andersen
Reporter: Finn McCann
Created: Tue, 21 Oct 2003 11:01 AM
Updated: Tue, 30 Dec 2003 11:32 AM
Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box.
Description:
Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues:
1. Serial ids:
<id name="id" column="ID" length="32" unsaved-value="null">
<generator class="uuid.hex"/>
</id>
creates a data type:
INT8 SERIAL
instead of:
SERIAL8
The "INT8 SERIAL" causes a syntax error in IDS 9.4.
2. Foreign Key constraint names:
<set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc">
<key column="NETWORK_ID" length="32"/>
<one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/>
</set>
creates this ALTER TABLE statement:
alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK
instead of:
alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC
Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error.
This also applies to adding UNIQUE CONSTRAINTs.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 17:28:25
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Tue, 30 Dec 2003 11:27 AM
Body:
And the new method hasImplicitIndexForForeignKey() is not called from anywhere ? am i missing some parts of the code ?
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-414
Summary: Informix dialect creates syntax errors in IDS 9.4
Type: Bug
Status: Open
Priority: Major
Project: Hibernate2
Versions:
2.0.2
Assignee: Max Rydahl Andersen
Reporter: Finn McCann
Created: Tue, 21 Oct 2003 11:01 AM
Updated: Tue, 30 Dec 2003 11:27 AM
Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box.
Description:
Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues:
1. Serial ids:
<id name="id" column="ID" length="32" unsaved-value="null">
<generator class="uuid.hex"/>
</id>
creates a data type:
INT8 SERIAL
instead of:
SERIAL8
The "INT8 SERIAL" causes a syntax error in IDS 9.4.
2. Foreign Key constraint names:
<set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc">
<key column="NETWORK_ID" length="32"/>
<one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/>
</set>
creates this ALTER TABLE statement:
alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK
instead of:
alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC
Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error.
This also applies to adding UNIQUE CONSTRAINTs.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 17:24:26
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Tue, 30 Dec 2003 11:23 AM
Body:
See that's much better - now i can see what you want changed ;)
One question though: the INT8 issue.
Is it not generally wrong that a column with type BigInt should be SERIAL8 instead of INT8 ?
Then I would say the change is instead to do a
registerColumnType(Types.BIGINT, "SERIAL8"); in the constructor instead of having a special identitytype method.
As I cannot test this, i have to rely on you answering me - so please do ;)
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-414
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-414
Summary: Informix dialect creates syntax errors in IDS 9.4
Type: Bug
Status: Open
Priority: Major
Project: Hibernate2
Versions:
2.0.2
Assignee: Max Rydahl Andersen
Reporter: Finn McCann
Created: Tue, 21 Oct 2003 11:01 AM
Updated: Tue, 30 Dec 2003 11:23 AM
Environment: Hibernate2 on JDK1.4 on Win2000, talking via Informix JDBC 2.21.JC5 driver to Informix IDS 9.4 on another Windows 2000 box.
Description:
Having tested Informix dialect in Hibernate2 against Informix IDS v9.4, we found a couple of issues:
1. Serial ids:
<id name="id" column="ID" length="32" unsaved-value="null">
<generator class="uuid.hex"/>
</id>
creates a data type:
INT8 SERIAL
instead of:
SERIAL8
The "INT8 SERIAL" causes a syntax error in IDS 9.4.
2. Foreign Key constraint names:
<set name="upliftRates" lazy="true" cascade="all" order-by="EFFECTIVE_DATE desc">
<key column="NETWORK_ID" length="32"/>
<one-to-many class="com.capetechnologies.multinet.domain.UpliftRate"/>
</set>
creates this ALTER TABLE statement:
alter table MULTINET_TAX_RATES add constraint FKE1700D046924EC foreign key (NETWORK_ID) references MULTINET_NETWORK
instead of:
alter table MULTINET_TAX_RATES add constraint foreign key (NETWORK_ID) references MULTINET_NETWORK constraint FKE1700D046924EC
Having "CONSTRAINT <constraint name>" within the statement instead of at the end causes a syntax error.
This also applies to adding UNIQUE CONSTRAINTs.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 17:05:25
|
Message:
The following issue has been closed.
Resolver: Max Rydahl Andersen
Date: Tue, 30 Dec 2003 11:04 AM
now in cvs
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-588
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-588
Summary: Sybase 11.9.2 Dialect
Type: Patch
Status: Closed
Priority: Minor
Resolution: FIXED
Project: Hibernate2
Components:
core
Fix Fors:
2.1.1
Versions:
2.1
Assignee:
Reporter: Colm O' Flaherty
Created: Tue, 30 Dec 2003 10:06 AM
Updated: Tue, 30 Dec 2003 11:04 AM
Environment: Developed on Hibernate 2.0.3 against Sybase ASE 11.9.2 on Winn NT6a, modified for Hibernate 2.1.1 (JoinFragment changes).
Description:
Sybase 11.9.2 does not support ANSI-style joins. Instead, it supports "=", "*=", and "*=" type joins. The existing Hibernate SybaseDialect produces ANSI-style joins.
This patch allows Hibernate to operate correctly (in terms of joins, at least) with Sybase 11.9.2.
Note that Sybase 12.5 *does* support the ANSI-style join, and will work with the existing SybaseDialect.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 16:11:25
|
The following issue has been updated:
Updater: Colm O' Flaherty (mailto:col...@kb...)
Date: Tue, 30 Dec 2003 10:09 AM
Comment:
uses =, *= and =* in place of ANSI style joins, which Sybase 11.9.2 does not support.
Changes:
Attachment changed to Sybase11_9_2JoinFragment.java
---------------------------------------------------------------------
For a full history of the issue, see:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-588&page=history
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-588
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-588
Summary: Sybase 11.9.2 Dialect
Type: Patch
Status: Unassigned
Priority: Minor
Project: Hibernate2
Components:
core
Versions:
2.1
Assignee:
Reporter: Colm O' Flaherty
Created: Tue, 30 Dec 2003 10:06 AM
Updated: Tue, 30 Dec 2003 10:09 AM
Environment: Developed on Hibernate 2.0.3 against Sybase ASE 11.9.2 on Winn NT6a, modified for Hibernate 2.1.1 (JoinFragment changes).
Description:
Sybase 11.9.2 does not support ANSI-style joins. Instead, it supports "=", "*=", and "*=" type joins. The existing Hibernate SybaseDialect produces ANSI-style joins.
This patch allows Hibernate to operate correctly (in terms of joins, at least) with Sybase 11.9.2.
Note that Sybase 12.5 *does* support the ANSI-style join, and will work with the existing SybaseDialect.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 16:09:25
|
The following issue has been updated:
Updater: Colm O' Flaherty (mailto:col...@kb...)
Date: Tue, 30 Dec 2003 10:08 AM
Comment:
The Dialect itself (which does little other than attach to the relevant Sybase11_9_2JoinFragment to do the work)
Changes:
Attachment changed to Sybase11_9_2Dialect.java
---------------------------------------------------------------------
For a full history of the issue, see:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-588&page=history
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-588
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-588
Summary: Sybase 11.9.2 Dialect
Type: Patch
Status: Unassigned
Priority: Minor
Project: Hibernate2
Components:
core
Versions:
2.1
Assignee:
Reporter: Colm O' Flaherty
Created: Tue, 30 Dec 2003 10:06 AM
Updated: Tue, 30 Dec 2003 10:08 AM
Environment: Developed on Hibernate 2.0.3 against Sybase ASE 11.9.2 on Winn NT6a, modified for Hibernate 2.1.1 (JoinFragment changes).
Description:
Sybase 11.9.2 does not support ANSI-style joins. Instead, it supports "=", "*=", and "*=" type joins. The existing Hibernate SybaseDialect produces ANSI-style joins.
This patch allows Hibernate to operate correctly (in terms of joins, at least) with Sybase 11.9.2.
Note that Sybase 12.5 *does* support the ANSI-style join, and will work with the existing SybaseDialect.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 16:06:25
|
Message: A new issue has been created in JIRA. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-588 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-588 Summary: Sybase 11.9.2 Dialect Type: Patch Status: Unassigned Priority: Minor Project: Hibernate2 Components: core Versions: 2.1 Assignee: Reporter: Colm O' Flaherty Created: Tue, 30 Dec 2003 10:06 AM Updated: Tue, 30 Dec 2003 10:06 AM Environment: Developed on Hibernate 2.0.3 against Sybase ASE 11.9.2 on Winn NT6a, modified for Hibernate 2.1.1 (JoinFragment changes). Description: Sybase 11.9.2 does not support ANSI-style joins. Instead, it supports "=", "*=", and "*=" type joins. The existing Hibernate SybaseDialect produces ANSI-style joins. This patch allows Hibernate to operate correctly (in terms of joins, at least) with Sybase 11.9.2. Note that Sybase 12.5 *does* support the ANSI-style join, and will work with the existing SybaseDialect. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
|
From: <leg...@at...> - 2003-12-30 14:54:27
|
Message: A new issue has been created in JIRA. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-587 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-587 Summary: Lazy collections not lazy when used with second level cache Type: Bug Status: Unassigned Priority: Major Project: Hibernate2 Components: core Versions: 2.1.1 Assignee: Reporter: Juho Snellman Created: Tue, 30 Dec 2003 8:53 AM Updated: Tue, 30 Dec 2003 8:53 AM Environment: Hibernate 2.1.1 ehcache Description: When an object is loaded from the second level cache, any of its collections that are found from the cache are immediately initialized. This happens for both lazy and non-lazy collections. These initializations then cascade on to the contents of the collection, and their child-collections. For a sufficiently large and interconnected graph of objects this results in a disastrous performance loss when caching is enabled. In my particular case a test enabling caching increases the runtime of a test from about 12 minutes to over 40 minutes. In the latter case SessionImpl.getCachedCollection() takes up 68% of the runtime. Disabling caching only for collections brings the runtime back down. Aside from the performance issue, it seems to me that initializing lazy collections is also conceptually wrong. Shouldn't laziness mean "no work is done unless it's neccessary", instead of "nothing is fetched from the DB unless it's neccessary"? I'm pretty sure this didn't happen with Hibernate 2.0 and JCS. --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
|
From: <leg...@at...> - 2003-12-30 11:46:26
|
Message:
The following issue has been closed.
Resolver: Max Rydahl Andersen
Date: Tue, 30 Dec 2003 5:45 AM
Fixed. Thanks for spotting it.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-586
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-586
Summary: documentation typo
Type: Bug
Status: Closed
Priority: Trivial
Resolution: FIXED
Project: Hibernate2
Components:
core
Fix Fors:
2.1.1
Versions:
2.1.1
Assignee:
Reporter: Eelco Hillenius
Created: Tue, 30 Dec 2003 5:39 AM
Updated: Tue, 30 Dec 2003 5:45 AM
Environment: hibernate documentation
Description:
In chapter 3.5.7, the line:
You may integrate a JVM-level (or clustered) cache by implementing the interface net.sf.hibernate.connection.ConnectionProvider
should be:
You may integrate a JVM-level (or clustered) cache by implementing the interface net.sf.hibernate.cache.CacheProvider
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-30 11:40:26
|
Message: A new issue has been created in JIRA. --------------------------------------------------------------------- View the issue: http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-586 Here is an overview of the issue: --------------------------------------------------------------------- Key: HB-586 Summary: documentation typo Type: Bug Status: Unassigned Priority: Trivial Project: Hibernate2 Components: core Versions: 2.1.1 Assignee: Reporter: Eelco Hillenius Created: Tue, 30 Dec 2003 5:39 AM Updated: Tue, 30 Dec 2003 5:39 AM Environment: hibernate documentation Description: In chapter 3.5.7, the line: You may integrate a JVM-level (or clustered) cache by implementing the interface net.sf.hibernate.connection.ConnectionProvider should be: You may integrate a JVM-level (or clustered) cache by implementing the interface net.sf.hibernate.cache.CacheProvider --------------------------------------------------------------------- JIRA INFORMATION: 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.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |
|
From: <leg...@at...> - 2003-12-29 10:33:25
|
The following comment has been added to this issue:
Author: tom quas
Created: Mon, 29 Dec 2003 4:33 AM
Body:
Max, I might not have made myself clear enough. The point is not to access information under META-INF but to bundle a mappings.jar with a WAR (under WEB-INF/classes) or EAR and access it from there--preferably via Class.getResource() or getResourceAsStream since those methods are guaranteed to work on the classpath.
I agree with you that java.io.File is not appropriate for this case. This is exactly the point why I'm asking for a convenience API to retrieve such a bundled mappings archive. Configration.addJar(String resource) provided that API till it's been deprecated.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-580
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-580
Summary: Undo deprecation of Configuration.addJar(String)
Type: Improvement
Status: Closed
Priority: Critical
Resolution: WON'T FIX
Project: Hibernate2
Components:
core
Versions:
2.1.1
Assignee:
Reporter: tom quas
Created: Fri, 26 Dec 2003 3:51 PM
Updated: Mon, 29 Dec 2003 4:33 AM
Environment: API
Description:
I just realized that Configuration.addJar( String filename ) has been deprecated. I regularly use it to load mappings from the classpath.
Could you please leave it in for convenience?
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-29 08:55:26
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Mon, 29 Dec 2003 2:55 AM
Body:
Yes ? And when you have chosen "char" as your key you have "agreed" to do that. That field contains "1 " not just "1".
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-582
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-582
Summary: Extra ' ' when read char type field in SQLServer 2000
Type: Bug
Status: Closed
Priority: Critical
Resolution: REJECTED
Project: Hibernate2
Components:
core
Versions:
2.1.1
Assignee: Gavin King
Reporter: Shining
Created: Sat, 27 Dec 2003 7:33 AM
Updated: Mon, 29 Dec 2003 2:55 AM
Environment: Windows2000 Professional with SP4, JDK 1.4.2_02, Eclipse 2.1.2 Hibernate 2.1.1 SQLServer 2000 Desktop with SP2, Microsoft SQLServer JDBC Driver SP2
Description:
There's a strange phenomenon when using SQLServer2000. When you read a char field through JDBC(ODBC is the same), the result were padded with extra blankspace, the length of blank space is equal to the length of data character subtract from the length of the field. for example:
field type is: char(10), data character is '1', the result of read will be '1 '. The same reading operator in MySQL is correct. Other Database server have not been tested.
When I test the sample code(figure 1) with hibernate 2.1.1, I found a bug that course collection lost when load a class with the char type id and a collection field with the same id as the id column.
Hibernate 2.1.1 DEBUG&OUTPUT Information
----------------------------------------------------------------------------------------------------------------------------------------
19:49:19,902 INFO Environment:432 - Hibernate 2.1.1
19:49:19,952 INFO Environment:461 - hibernate.properties not found
19:49:20,042 INFO Environment:481 - using CGLIB reflection optimizer
19:49:20,102 INFO Configuration:843 - configuring from resource: /hibernate.cfg.xml
19:49:20,112 INFO Configuration:815 - Configuration resource: /hibernate.cfg.xml
......
19:49:37,428 DEBUG SessionFactoryImpl:196 - instantiated session factory
19:49:37,729 DEBUG SessionImpl:528 - opened session
19:49:37,739 DEBUG SessionImpl:1913 - loading [test.Group#1]
19:49:37,739 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1]
19:49:37,759 DEBUG SessionImpl:2043 - object not resolved in any cache [test.Group#1]
19:49:37,759 DEBUG EntityPersister:417 - Materializing entity: [test.Group#1]
19:49:37,779 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:49:37,779 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
19:49:37,789 DEBUG DriverManagerConnectionProvider:84 - using pooled JDBC connection, pool size: 0
19:49:37,789 DEBUG SQL:223 - select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
19:49:37,789 DEBUG BatcherImpl:227 - preparing statement
19:49:38,239 DEBUG StringType:46 - binding '1' to parameter: 1
19:49:38,590 DEBUG Loader:196 - processing result set
19:49:38,590 DEBUG Loader:404 - result row: 1
19:49:38,610 DEBUG Loader:535 - Initializing object from ResultSet: 1
19:49:38,630 DEBUG Loader:604 - Hydrating entity: test.Group#1
19:49:38,650 DEBUG StringType:68 - returning 'group1 ' as column: group_name0_
19:49:38,660 DEBUG Loader:225 - done processing result set (1 rows)
19:49:38,680 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:49:38,680 DEBUG BatcherImpl:240 - closing statement
19:49:38,690 DEBUG Loader:238 - total objects hydrated: 1
19:49:38,700 DEBUG SessionImpl:2129 - resolving associations for [test.Group#1]
19:49:38,720 DEBUG SessionImpl:3746 - collection not cached
19:49:38,760 DEBUG SessionImpl:2153 - done materializing entity [test.Group#1]
19:49:38,760 DEBUG SessionImpl:3000 - initializing non-lazy collections
19:49:38,760 DEBUG SessionImpl:3132 - initializing collection [test.Group.persons#1]
19:49:38,770 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:49:38,770 DEBUG SQL:223 - select persons0_.person_id as person_id__, persons0_.group_id as group_id__, persons0_.person_id as person_id0_, persons0_.person_name as person_n2_0_, persons0_.group_id as group_id0_ from tbl_person persons0_ where persons0_.group_id=?
Hibernate: select persons0_.person_id as person_id__, persons0_.group_id as group_id__, persons0_.person_id as person_id0_, persons0_.person_name as person_n2_0_, persons0_.group_id as group_id0_ from tbl_person persons0_ where persons0_.group_id=?
19:49:38,790 DEBUG BatcherImpl:227 - preparing statement
19:49:38,790 DEBUG StringType:46 - binding '1' to parameter: 1
19:49:38,810 DEBUG Loader:326 - result set contains (possibly empty) collection: [test.Group.persons#1]
19:49:38,810 DEBUG SessionImpl:2902 - uninitialized collection: initializing
19:49:38,830 DEBUG Loader:196 - processing result set
19:49:38,840 DEBUG StringType:68 - returning '11 ' as column: person_id0_
19:49:38,840 DEBUG Loader:404 - result row: 11
19:49:38,850 DEBUG Loader:535 - Initializing object from ResultSet: 11
19:49:38,850 DEBUG Loader:604 - Hydrating entity: test.Person#11
19:49:38,860 DEBUG StringType:68 - returning 'person11 ' as column: person_n2_0_
19:49:38,860 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:38,860 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:38,870 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:38,870 DEBUG SessionImpl:2914 - new collection: instantiating
19:49:38,870 DEBUG StringType:68 - returning '11 ' as column: person_id__
19:49:38,880 DEBUG SessionImpl:1913 - loading [test.Person#11 ]
19:49:38,890 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#11 ]
19:49:38,910 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#11 ]
19:49:38,910 DEBUG StringType:68 - returning '12 ' as column: person_id0_
19:49:38,910 DEBUG Loader:404 - result row: 12
19:49:38,920 DEBUG Loader:535 - Initializing object from ResultSet: 12
19:49:38,920 DEBUG Loader:604 - Hydrating entity: test.Person#12
19:49:38,930 DEBUG StringType:68 - returning 'person12 ' as column: person_n2_0_
19:49:38,930 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:38,960 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:38,960 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:38,960 DEBUG SessionImpl:2925 - reading row
19:49:38,960 DEBUG StringType:68 - returning '12 ' as column: person_id__
19:49:39,001 DEBUG SessionImpl:1913 - loading [test.Person#12 ]
19:49:39,001 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#12 ]
19:49:39,011 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#12 ]
19:49:39,011 DEBUG StringType:68 - returning '13 ' as column: person_id0_
19:49:39,011 DEBUG Loader:404 - result row: 13
19:49:39,021 DEBUG Loader:535 - Initializing object from ResultSet: 13
19:49:39,021 DEBUG Loader:604 - Hydrating entity: test.Person#13
19:49:39,021 DEBUG StringType:68 - returning 'person13 ' as column: person_n2_0_
19:49:39,021 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:39,031 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:39,031 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:39,041 DEBUG SessionImpl:2925 - reading row
19:49:39,041 DEBUG StringType:68 - returning '13 ' as column: person_id__
19:49:39,051 DEBUG SessionImpl:1913 - loading [test.Person#13 ]
19:49:39,071 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#13 ]
19:49:39,071 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#13 ]
19:49:39,081 DEBUG StringType:68 - returning '14 ' as column: person_id0_
19:49:39,091 DEBUG Loader:404 - result row: 14
19:49:39,091 DEBUG Loader:535 - Initializing object from ResultSet: 14
19:49:39,091 DEBUG Loader:604 - Hydrating entity: test.Person#14
19:49:39,091 DEBUG StringType:68 - returning 'person14 ' as column: person_n2_0_
19:49:39,101 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:39,101 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:39,111 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:39,111 DEBUG SessionImpl:2925 - reading row
19:49:39,111 DEBUG StringType:68 - returning '14 ' as column: person_id__
19:49:39,131 DEBUG SessionImpl:1913 - loading [test.Person#14 ]
19:49:39,131 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#14 ]
19:49:39,131 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#14 ]
19:49:39,131 DEBUG StringType:68 - returning '15 ' as column: person_id0_
19:49:39,141 DEBUG Loader:404 - result row: 15
19:49:39,141 DEBUG Loader:535 - Initializing object from ResultSet: 15
19:49:39,151 DEBUG Loader:604 - Hydrating entity: test.Person#15
19:49:39,151 DEBUG StringType:68 - returning 'person15 ' as column: person_n2_0_
19:49:39,161 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:39,161 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:39,161 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:39,171 DEBUG SessionImpl:2925 - reading row
19:49:39,201 DEBUG StringType:68 - returning '15 ' as column: person_id__
19:49:39,201 DEBUG SessionImpl:1913 - loading [test.Person#15 ]
19:49:39,211 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#15 ]
19:49:39,211 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#15 ]
19:49:39,221 DEBUG Loader:225 - done processing result set (5 rows)
19:49:39,221 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:49:39,221 DEBUG BatcherImpl:240 - closing statement
19:49:39,231 DEBUG Loader:238 - total objects hydrated: 5
19:49:39,231 DEBUG SessionImpl:2129 - resolving associations for [test.Person#11 ]
{****
19:49:39,241 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,241 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,241 DEBUG SessionImpl:2043 - object not resolved in any cache [test.Group#1 ]
***}
19:49:39,241 DEBUG EntityPersister:417 - Materializing entity: [test.Group#1 ]
19:49:39,251 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:49:39,251 DEBUG SQL:223 - select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
19:49:39,261 DEBUG BatcherImpl:227 - preparing statement
19:49:39,261 DEBUG StringType:46 - binding '1 ' to parameter: 1
19:49:39,281 DEBUG Loader:196 - processing result set
19:49:39,281 DEBUG Loader:404 - result row: 1
19:49:39,281 DEBUG Loader:535 - Initializing object from ResultSet: 1
19:49:39,291 DEBUG Loader:604 - Hydrating entity: test.Group#1
19:49:39,321 DEBUG StringType:68 - returning 'group1 ' as column: group_name0_
19:49:39,321 DEBUG Loader:225 - done processing result set (1 rows)
19:49:39,331 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:49:39,331 DEBUG BatcherImpl:240 - closing statement
19:49:39,331 DEBUG Loader:238 - total objects hydrated: 1
19:49:39,341 DEBUG SessionImpl:2129 - resolving associations for [test.Group#1 ]
19:49:39,341 DEBUG SessionImpl:2153 - done materializing entity [test.Group#1 ]
19:49:39,351 DEBUG SessionImpl:2153 - done materializing entity [test.Person#11 ]
19:49:39,351 DEBUG SessionImpl:2129 - resolving associations for [test.Person#12 ]
19:49:39,351 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,361 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,361 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,371 DEBUG SessionImpl:2153 - done materializing entity [test.Person#12 ]
19:49:39,371 DEBUG SessionImpl:2129 - resolving associations for [test.Person#13 ]
19:49:39,381 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,381 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,381 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,381 DEBUG SessionImpl:2153 - done materializing entity [test.Person#13 ]
19:49:39,391 DEBUG SessionImpl:2129 - resolving associations for [test.Person#14 ]
19:49:39,391 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,401 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,401 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,411 DEBUG SessionImpl:2153 - done materializing entity [test.Person#14 ]
19:49:39,411 DEBUG SessionImpl:2129 - resolving associations for [test.Person#15 ]
19:49:39,441 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,441 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,441 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,451 DEBUG SessionImpl:2153 - done materializing entity [test.Person#15 ]
19:49:39,451 DEBUG SessionImpl:2961 - 2 collections were found in result set
19:49:39,461 DEBUG SessionImpl:2979 - collection fully initialized: [test.Group.persons#1 ]
19:49:39,461 DEBUG SessionImpl:2979 - collection fully initialized: [test.Group.persons#1]
19:49:39,461 DEBUG SessionImpl:2982 - 2 collections initialized
----------------------------------------------------------------------------------------------------------------------------------------
The message in {**** ***} show the problem reson. Because of the strange behavior of the jdbc driver of SQLServer, the object id in the cache is "1"(load(group.class, "1")), the id read through jdbc is "1 ", hibernate can not got the group object from the cache.
I have test the same code with the hibernate version 2.0.3, the result is correct, the debug information is:
Hibernate 2.0.3 DEBUG&OUTPUT Information
----------------------------------------------------------------------------------------------------------------------------------------
19:40:48,701 INFO Environment:403 - Hibernate 2.0.3
19:40:48,721 INFO Environment:432 - hibernate.properties not found
19:40:48,751 INFO Environment:452 - using CGLIB reflection optimizer
19:40:48,761 INFO Environment:462 - JVM proxy support: true
19:40:48,791 INFO Configuration:703 - Configuration resource: /hibernate.cfg.xml
19:41:00,579 INFO SessionFactoryImpl:269 - Query language substitutions: {}
......
19:41:00,589 DEBUG SessionFactoryImpl:281 - instantiated session factory
19:41:00,749 DEBUG SessionImpl:413 - opened session
19:41:00,769 DEBUG SessionImpl:1752 - loading [test.Group#1]
19:41:00,769 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1]
19:41:00,789 DEBUG SessionImpl:1887 - object not resolved in any cache [test.Group#1]
19:41:00,789 DEBUG EntityPersister:394 - Materializing entity: test.Group#1
19:41:00,799 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:00,799 DEBUG DriverManagerConnectionProvider:77 - total checked-out connections: 0
19:41:00,799 DEBUG DriverManagerConnectionProvider:83 - using pooled JDBC connection, pool size: 0
19:41:00,809 DEBUG SessionFactoryImpl:526 - prepared statement get: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
19:41:00,809 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,160 DEBUG StringType:44 - binding '1' to parameter: 1
19:41:01,300 DEBUG Loader:148 - processing result set
19:41:01,310 DEBUG Loader:260 - result row: 1
19:41:01,310 DEBUG Loader:357 - Initializing object from ResultSet: 1
19:41:01,320 DEBUG Loader:413 - Hydrating entity: test.Group#1
19:41:01,320 DEBUG StringType:65 - returning 'group1 ' as column: group_name
19:41:01,330 DEBUG Loader:182 - done processing result set (1 rows)
19:41:01,340 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,350 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,350 DEBUG Loader:195 - total objects hydrated: 1
19:41:01,350 DEBUG SessionImpl:1954 - resolving associations for [test.Group#1]
19:41:01,390 DEBUG SessionImpl:2888 - initializing collection [test.Group.persons#1]
19:41:01,390 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:01,400 DEBUG SessionFactoryImpl:526 - prepared statement get: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
Hibernate: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
19:41:01,400 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,400 DEBUG StringType:44 - binding '1' to parameter: 1
19:41:01,430 DEBUG Loader:148 - processing result set
19:41:01,440 DEBUG StringType:65 - returning '11 ' as column: person_id
19:41:01,440 DEBUG Loader:260 - result row: 11
19:41:01,440 DEBUG Loader:357 - Initializing object from ResultSet: 11
19:41:01,440 DEBUG Loader:413 - Hydrating entity: test.Person#11
19:41:01,450 DEBUG StringType:65 - returning 'person11 ' as column: person_n2_
19:41:01,450 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,450 DEBUG StringType:65 - returning '11 ' as column: person_id__
19:41:01,460 DEBUG SessionImpl:1752 - loading [test.Person#11 ]
19:41:01,460 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#11 ]
19:41:01,470 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#11 ]
19:41:01,470 DEBUG StringType:65 - returning '12 ' as column: person_id
19:41:01,470 DEBUG Loader:260 - result row: 12
19:41:01,480 DEBUG Loader:357 - Initializing object from ResultSet: 12
19:41:01,480 DEBUG Loader:413 - Hydrating entity: test.Person#12
19:41:01,480 DEBUG StringType:65 - returning 'person12 ' as column: person_n2_
19:41:01,480 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,490 DEBUG StringType:65 - returning '12 ' as column: person_id__
19:41:01,500 DEBUG SessionImpl:1752 - loading [test.Person#12 ]
19:41:01,500 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#12 ]
19:41:01,500 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#12 ]
19:41:01,510 DEBUG StringType:65 - returning '13 ' as column: person_id
19:41:01,510 DEBUG Loader:260 - result row: 13
19:41:01,510 DEBUG Loader:357 - Initializing object from ResultSet: 13
19:41:01,530 DEBUG Loader:413 - Hydrating entity: test.Person#13
19:41:01,540 DEBUG StringType:65 - returning 'person13 ' as column: person_n2_
19:41:01,540 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,540 DEBUG StringType:65 - returning '13 ' as column: person_id__
19:41:01,550 DEBUG SessionImpl:1752 - loading [test.Person#13 ]
19:41:01,550 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#13 ]
19:41:01,550 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#13 ]
19:41:01,560 DEBUG StringType:65 - returning '14 ' as column: person_id
19:41:01,560 DEBUG Loader:260 - result row: 14
19:41:01,560 DEBUG Loader:357 - Initializing object from ResultSet: 14
19:41:01,570 DEBUG Loader:413 - Hydrating entity: test.Person#14
19:41:01,570 DEBUG StringType:65 - returning 'person14 ' as column: person_n2_
19:41:01,570 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,580 DEBUG StringType:65 - returning '14 ' as column: person_id__
19:41:01,580 DEBUG SessionImpl:1752 - loading [test.Person#14 ]
19:41:01,580 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#14 ]
19:41:01,590 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#14 ]
19:41:01,590 DEBUG StringType:65 - returning '15 ' as column: person_id
19:41:01,600 DEBUG Loader:260 - result row: 15
19:41:01,600 DEBUG Loader:357 - Initializing object from ResultSet: 15
19:41:01,600 DEBUG Loader:413 - Hydrating entity: test.Person#15
19:41:01,600 DEBUG StringType:65 - returning 'person15 ' as column: person_n2_
19:41:01,610 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,610 DEBUG StringType:65 - returning '15 ' as column: person_id__
19:41:01,620 DEBUG SessionImpl:1752 - loading [test.Person#15 ]
19:41:01,620 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#15 ]
19:41:01,630 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#15 ]
19:41:01,650 DEBUG Loader:182 - done processing result set (5 rows)
19:41:01,650 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,650 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,650 DEBUG Loader:195 - total objects hydrated: 5
19:41:01,660 DEBUG SessionImpl:1954 - resolving associations for [test.Person#11 ]
19:41:01,660 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:01,660 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:01,671 DEBUG SessionImpl:1887 - object not resolved in any cache [test.Group#1 ]
19:41:01,671 DEBUG EntityPersister:394 - Materializing entity: test.Group#1
19:41:01,681 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:01,681 DEBUG SessionFactoryImpl:526 - prepared statement get: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
19:41:01,681 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,691 DEBUG StringType:44 - binding '1 ' to parameter: 1
19:41:01,691 DEBUG Loader:148 - processing result set
19:41:01,711 DEBUG Loader:260 - result row: 1
19:41:01,711 DEBUG Loader:357 - Initializing object from ResultSet: 1
19:41:01,711 DEBUG Loader:413 - Hydrating entity: test.Group#1
19:41:01,721 DEBUG StringType:65 - returning 'group1 ' as column: group_name
19:41:01,721 DEBUG Loader:182 - done processing result set (1 rows)
19:41:01,721 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,731 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,731 DEBUG Loader:195 - total objects hydrated: 1
19:41:01,741 DEBUG SessionImpl:1954 - resolving associations for [test.Group#1 ]
19:41:01,741 DEBUG SessionImpl:2888 - initializing collection [test.Group.persons#1 ]
19:41:01,741 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:01,771 DEBUG SessionFactoryImpl:526 - prepared statement get: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
Hibernate: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
19:41:01,791 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,791 DEBUG StringType:44 - binding '1 ' to parameter: 1
19:41:01,811 DEBUG Loader:148 - processing result set
19:41:01,811 DEBUG StringType:65 - returning '11 ' as column: person_id
19:41:01,821 DEBUG Loader:260 - result row: 11
19:41:01,821 DEBUG StringType:65 - returning '11 ' as column: person_id__
19:41:01,821 DEBUG SessionImpl:1752 - loading [test.Person#11 ]
19:41:01,831 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#11 ]
19:41:01,831 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#11 ]
19:41:01,841 DEBUG StringType:65 - returning '12 ' as column: person_id
19:41:01,841 DEBUG Loader:260 - result row: 12
19:41:01,841 DEBUG StringType:65 - returning '12 ' as column: person_id__
19:41:01,841 DEBUG SessionImpl:1752 - loading [test.Person#12 ]
19:41:01,851 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#12 ]
19:41:01,851 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#12 ]
19:41:01,861 DEBUG StringType:65 - returning '13 ' as column: person_id
19:41:01,871 DEBUG Loader:260 - result row: 13
19:41:01,881 DEBUG StringType:65 - returning '13 ' as column: person_id__
19:41:01,881 DEBUG SessionImpl:1752 - loading [test.Person#13 ]
19:41:01,881 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#13 ]
19:41:01,901 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#13 ]
19:41:01,901 DEBUG StringType:65 - returning '14 ' as column: person_id
19:41:01,911 DEBUG Loader:260 - result row: 14
19:41:01,911 DEBUG StringType:65 - returning '14 ' as column: person_id__
19:41:01,911 DEBUG SessionImpl:1752 - loading [test.Person#14 ]
19:41:01,921 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#14 ]
19:41:01,921 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#14 ]
19:41:01,931 DEBUG StringType:65 - returning '15 ' as column: person_id
19:41:01,931 DEBUG Loader:260 - result row: 15
19:41:01,931 DEBUG StringType:65 - returning '15 ' as column: person_id__
19:41:01,941 DEBUG SessionImpl:1752 - loading [test.Person#15 ]
19:41:01,941 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#15 ]
19:41:01,951 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#15 ]
19:41:01,951 DEBUG Loader:182 - done processing result set (5 rows)
19:41:01,951 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,961 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,961 DEBUG Loader:195 - total objects hydrated: 0
19:41:01,961 DEBUG SessionImpl:1975 - done materializing entity [test.Group#1 ]
19:41:01,971 DEBUG SessionImpl:1975 - done materializing entity [test.Person#11 ]
19:41:01,991 DEBUG SessionImpl:1954 - resolving associations for [test.Person#12 ]
19:41:01,991 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:01,991 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:01,991 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,001 DEBUG SessionImpl:1975 - done materializing entity [test.Person#12 ]
19:41:02,001 DEBUG SessionImpl:1954 - resolving associations for [test.Person#13 ]
19:41:02,001 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:02,011 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:02,011 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,011 DEBUG SessionImpl:1975 - done materializing entity [test.Person#13 ]
19:41:02,021 DEBUG SessionImpl:1954 - resolving associations for [test.Person#14 ]
19:41:02,021 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:02,021 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:02,021 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,031 DEBUG SessionImpl:1975 - done materializing entity [test.Person#14 ]
19:41:02,031 DEBUG SessionImpl:1954 - resolving associations for [test.Person#15 ]
19:41:02,041 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:02,041 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:02,041 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,051 DEBUG SessionImpl:1975 - done materializing entity [test.Person#15 ]
19:41:02,051 DEBUG SessionImpl:1975 - done materializing entity [test.Group#1]
----------------------------------------------------------------------------------------------------------------------------------------
If hibernate have a trim() operator when dealing with SQLServerDialect, the problem will be corrected perfectly.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-29 02:17:26
|
The following comment has been added to this issue:
Author: Shining
Created: Sun, 28 Dec 2003 8:16 PM
Body:
I do not think to use varchar type as primary key is a good idea.
The terrible thing is that I must write code like this to get a object, session.load(Group.class, "1 ") correctly, the padding stuff must have the correct length according to the define of the char field.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-582
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-582
Summary: Extra ' ' when read char type field in SQLServer 2000
Type: Bug
Status: Closed
Priority: Critical
Resolution: REJECTED
Project: Hibernate2
Components:
core
Versions:
2.1.1
Assignee: Gavin King
Reporter: Shining
Created: Sat, 27 Dec 2003 7:33 AM
Updated: Sun, 28 Dec 2003 8:16 PM
Environment: Windows2000 Professional with SP4, JDK 1.4.2_02, Eclipse 2.1.2 Hibernate 2.1.1 SQLServer 2000 Desktop with SP2, Microsoft SQLServer JDBC Driver SP2
Description:
There's a strange phenomenon when using SQLServer2000. When you read a char field through JDBC(ODBC is the same), the result were padded with extra blankspace, the length of blank space is equal to the length of data character subtract from the length of the field. for example:
field type is: char(10), data character is '1', the result of read will be '1 '. The same reading operator in MySQL is correct. Other Database server have not been tested.
When I test the sample code(figure 1) with hibernate 2.1.1, I found a bug that course collection lost when load a class with the char type id and a collection field with the same id as the id column.
Hibernate 2.1.1 DEBUG&OUTPUT Information
----------------------------------------------------------------------------------------------------------------------------------------
19:49:19,902 INFO Environment:432 - Hibernate 2.1.1
19:49:19,952 INFO Environment:461 - hibernate.properties not found
19:49:20,042 INFO Environment:481 - using CGLIB reflection optimizer
19:49:20,102 INFO Configuration:843 - configuring from resource: /hibernate.cfg.xml
19:49:20,112 INFO Configuration:815 - Configuration resource: /hibernate.cfg.xml
......
19:49:37,428 DEBUG SessionFactoryImpl:196 - instantiated session factory
19:49:37,729 DEBUG SessionImpl:528 - opened session
19:49:37,739 DEBUG SessionImpl:1913 - loading [test.Group#1]
19:49:37,739 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1]
19:49:37,759 DEBUG SessionImpl:2043 - object not resolved in any cache [test.Group#1]
19:49:37,759 DEBUG EntityPersister:417 - Materializing entity: [test.Group#1]
19:49:37,779 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:49:37,779 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
19:49:37,789 DEBUG DriverManagerConnectionProvider:84 - using pooled JDBC connection, pool size: 0
19:49:37,789 DEBUG SQL:223 - select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
19:49:37,789 DEBUG BatcherImpl:227 - preparing statement
19:49:38,239 DEBUG StringType:46 - binding '1' to parameter: 1
19:49:38,590 DEBUG Loader:196 - processing result set
19:49:38,590 DEBUG Loader:404 - result row: 1
19:49:38,610 DEBUG Loader:535 - Initializing object from ResultSet: 1
19:49:38,630 DEBUG Loader:604 - Hydrating entity: test.Group#1
19:49:38,650 DEBUG StringType:68 - returning 'group1 ' as column: group_name0_
19:49:38,660 DEBUG Loader:225 - done processing result set (1 rows)
19:49:38,680 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:49:38,680 DEBUG BatcherImpl:240 - closing statement
19:49:38,690 DEBUG Loader:238 - total objects hydrated: 1
19:49:38,700 DEBUG SessionImpl:2129 - resolving associations for [test.Group#1]
19:49:38,720 DEBUG SessionImpl:3746 - collection not cached
19:49:38,760 DEBUG SessionImpl:2153 - done materializing entity [test.Group#1]
19:49:38,760 DEBUG SessionImpl:3000 - initializing non-lazy collections
19:49:38,760 DEBUG SessionImpl:3132 - initializing collection [test.Group.persons#1]
19:49:38,770 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:49:38,770 DEBUG SQL:223 - select persons0_.person_id as person_id__, persons0_.group_id as group_id__, persons0_.person_id as person_id0_, persons0_.person_name as person_n2_0_, persons0_.group_id as group_id0_ from tbl_person persons0_ where persons0_.group_id=?
Hibernate: select persons0_.person_id as person_id__, persons0_.group_id as group_id__, persons0_.person_id as person_id0_, persons0_.person_name as person_n2_0_, persons0_.group_id as group_id0_ from tbl_person persons0_ where persons0_.group_id=?
19:49:38,790 DEBUG BatcherImpl:227 - preparing statement
19:49:38,790 DEBUG StringType:46 - binding '1' to parameter: 1
19:49:38,810 DEBUG Loader:326 - result set contains (possibly empty) collection: [test.Group.persons#1]
19:49:38,810 DEBUG SessionImpl:2902 - uninitialized collection: initializing
19:49:38,830 DEBUG Loader:196 - processing result set
19:49:38,840 DEBUG StringType:68 - returning '11 ' as column: person_id0_
19:49:38,840 DEBUG Loader:404 - result row: 11
19:49:38,850 DEBUG Loader:535 - Initializing object from ResultSet: 11
19:49:38,850 DEBUG Loader:604 - Hydrating entity: test.Person#11
19:49:38,860 DEBUG StringType:68 - returning 'person11 ' as column: person_n2_0_
19:49:38,860 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:38,860 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:38,870 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:38,870 DEBUG SessionImpl:2914 - new collection: instantiating
19:49:38,870 DEBUG StringType:68 - returning '11 ' as column: person_id__
19:49:38,880 DEBUG SessionImpl:1913 - loading [test.Person#11 ]
19:49:38,890 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#11 ]
19:49:38,910 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#11 ]
19:49:38,910 DEBUG StringType:68 - returning '12 ' as column: person_id0_
19:49:38,910 DEBUG Loader:404 - result row: 12
19:49:38,920 DEBUG Loader:535 - Initializing object from ResultSet: 12
19:49:38,920 DEBUG Loader:604 - Hydrating entity: test.Person#12
19:49:38,930 DEBUG StringType:68 - returning 'person12 ' as column: person_n2_0_
19:49:38,930 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:38,960 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:38,960 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:38,960 DEBUG SessionImpl:2925 - reading row
19:49:38,960 DEBUG StringType:68 - returning '12 ' as column: person_id__
19:49:39,001 DEBUG SessionImpl:1913 - loading [test.Person#12 ]
19:49:39,001 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#12 ]
19:49:39,011 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#12 ]
19:49:39,011 DEBUG StringType:68 - returning '13 ' as column: person_id0_
19:49:39,011 DEBUG Loader:404 - result row: 13
19:49:39,021 DEBUG Loader:535 - Initializing object from ResultSet: 13
19:49:39,021 DEBUG Loader:604 - Hydrating entity: test.Person#13
19:49:39,021 DEBUG StringType:68 - returning 'person13 ' as column: person_n2_0_
19:49:39,021 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:39,031 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:39,031 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:39,041 DEBUG SessionImpl:2925 - reading row
19:49:39,041 DEBUG StringType:68 - returning '13 ' as column: person_id__
19:49:39,051 DEBUG SessionImpl:1913 - loading [test.Person#13 ]
19:49:39,071 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#13 ]
19:49:39,071 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#13 ]
19:49:39,081 DEBUG StringType:68 - returning '14 ' as column: person_id0_
19:49:39,091 DEBUG Loader:404 - result row: 14
19:49:39,091 DEBUG Loader:535 - Initializing object from ResultSet: 14
19:49:39,091 DEBUG Loader:604 - Hydrating entity: test.Person#14
19:49:39,091 DEBUG StringType:68 - returning 'person14 ' as column: person_n2_0_
19:49:39,101 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:39,101 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:39,111 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:39,111 DEBUG SessionImpl:2925 - reading row
19:49:39,111 DEBUG StringType:68 - returning '14 ' as column: person_id__
19:49:39,131 DEBUG SessionImpl:1913 - loading [test.Person#14 ]
19:49:39,131 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#14 ]
19:49:39,131 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#14 ]
19:49:39,131 DEBUG StringType:68 - returning '15 ' as column: person_id0_
19:49:39,141 DEBUG Loader:404 - result row: 15
19:49:39,141 DEBUG Loader:535 - Initializing object from ResultSet: 15
19:49:39,151 DEBUG Loader:604 - Hydrating entity: test.Person#15
19:49:39,151 DEBUG StringType:68 - returning 'person15 ' as column: person_n2_0_
19:49:39,161 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:39,161 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:39,161 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:39,171 DEBUG SessionImpl:2925 - reading row
19:49:39,201 DEBUG StringType:68 - returning '15 ' as column: person_id__
19:49:39,201 DEBUG SessionImpl:1913 - loading [test.Person#15 ]
19:49:39,211 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#15 ]
19:49:39,211 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#15 ]
19:49:39,221 DEBUG Loader:225 - done processing result set (5 rows)
19:49:39,221 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:49:39,221 DEBUG BatcherImpl:240 - closing statement
19:49:39,231 DEBUG Loader:238 - total objects hydrated: 5
19:49:39,231 DEBUG SessionImpl:2129 - resolving associations for [test.Person#11 ]
{****
19:49:39,241 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,241 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,241 DEBUG SessionImpl:2043 - object not resolved in any cache [test.Group#1 ]
***}
19:49:39,241 DEBUG EntityPersister:417 - Materializing entity: [test.Group#1 ]
19:49:39,251 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:49:39,251 DEBUG SQL:223 - select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
19:49:39,261 DEBUG BatcherImpl:227 - preparing statement
19:49:39,261 DEBUG StringType:46 - binding '1 ' to parameter: 1
19:49:39,281 DEBUG Loader:196 - processing result set
19:49:39,281 DEBUG Loader:404 - result row: 1
19:49:39,281 DEBUG Loader:535 - Initializing object from ResultSet: 1
19:49:39,291 DEBUG Loader:604 - Hydrating entity: test.Group#1
19:49:39,321 DEBUG StringType:68 - returning 'group1 ' as column: group_name0_
19:49:39,321 DEBUG Loader:225 - done processing result set (1 rows)
19:49:39,331 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:49:39,331 DEBUG BatcherImpl:240 - closing statement
19:49:39,331 DEBUG Loader:238 - total objects hydrated: 1
19:49:39,341 DEBUG SessionImpl:2129 - resolving associations for [test.Group#1 ]
19:49:39,341 DEBUG SessionImpl:2153 - done materializing entity [test.Group#1 ]
19:49:39,351 DEBUG SessionImpl:2153 - done materializing entity [test.Person#11 ]
19:49:39,351 DEBUG SessionImpl:2129 - resolving associations for [test.Person#12 ]
19:49:39,351 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,361 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,361 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,371 DEBUG SessionImpl:2153 - done materializing entity [test.Person#12 ]
19:49:39,371 DEBUG SessionImpl:2129 - resolving associations for [test.Person#13 ]
19:49:39,381 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,381 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,381 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,381 DEBUG SessionImpl:2153 - done materializing entity [test.Person#13 ]
19:49:39,391 DEBUG SessionImpl:2129 - resolving associations for [test.Person#14 ]
19:49:39,391 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,401 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,401 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,411 DEBUG SessionImpl:2153 - done materializing entity [test.Person#14 ]
19:49:39,411 DEBUG SessionImpl:2129 - resolving associations for [test.Person#15 ]
19:49:39,441 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,441 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,441 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,451 DEBUG SessionImpl:2153 - done materializing entity [test.Person#15 ]
19:49:39,451 DEBUG SessionImpl:2961 - 2 collections were found in result set
19:49:39,461 DEBUG SessionImpl:2979 - collection fully initialized: [test.Group.persons#1 ]
19:49:39,461 DEBUG SessionImpl:2979 - collection fully initialized: [test.Group.persons#1]
19:49:39,461 DEBUG SessionImpl:2982 - 2 collections initialized
----------------------------------------------------------------------------------------------------------------------------------------
The message in {**** ***} show the problem reson. Because of the strange behavior of the jdbc driver of SQLServer, the object id in the cache is "1"(load(group.class, "1")), the id read through jdbc is "1 ", hibernate can not got the group object from the cache.
I have test the same code with the hibernate version 2.0.3, the result is correct, the debug information is:
Hibernate 2.0.3 DEBUG&OUTPUT Information
----------------------------------------------------------------------------------------------------------------------------------------
19:40:48,701 INFO Environment:403 - Hibernate 2.0.3
19:40:48,721 INFO Environment:432 - hibernate.properties not found
19:40:48,751 INFO Environment:452 - using CGLIB reflection optimizer
19:40:48,761 INFO Environment:462 - JVM proxy support: true
19:40:48,791 INFO Configuration:703 - Configuration resource: /hibernate.cfg.xml
19:41:00,579 INFO SessionFactoryImpl:269 - Query language substitutions: {}
......
19:41:00,589 DEBUG SessionFactoryImpl:281 - instantiated session factory
19:41:00,749 DEBUG SessionImpl:413 - opened session
19:41:00,769 DEBUG SessionImpl:1752 - loading [test.Group#1]
19:41:00,769 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1]
19:41:00,789 DEBUG SessionImpl:1887 - object not resolved in any cache [test.Group#1]
19:41:00,789 DEBUG EntityPersister:394 - Materializing entity: test.Group#1
19:41:00,799 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:00,799 DEBUG DriverManagerConnectionProvider:77 - total checked-out connections: 0
19:41:00,799 DEBUG DriverManagerConnectionProvider:83 - using pooled JDBC connection, pool size: 0
19:41:00,809 DEBUG SessionFactoryImpl:526 - prepared statement get: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
19:41:00,809 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,160 DEBUG StringType:44 - binding '1' to parameter: 1
19:41:01,300 DEBUG Loader:148 - processing result set
19:41:01,310 DEBUG Loader:260 - result row: 1
19:41:01,310 DEBUG Loader:357 - Initializing object from ResultSet: 1
19:41:01,320 DEBUG Loader:413 - Hydrating entity: test.Group#1
19:41:01,320 DEBUG StringType:65 - returning 'group1 ' as column: group_name
19:41:01,330 DEBUG Loader:182 - done processing result set (1 rows)
19:41:01,340 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,350 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,350 DEBUG Loader:195 - total objects hydrated: 1
19:41:01,350 DEBUG SessionImpl:1954 - resolving associations for [test.Group#1]
19:41:01,390 DEBUG SessionImpl:2888 - initializing collection [test.Group.persons#1]
19:41:01,390 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:01,400 DEBUG SessionFactoryImpl:526 - prepared statement get: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
Hibernate: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
19:41:01,400 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,400 DEBUG StringType:44 - binding '1' to parameter: 1
19:41:01,430 DEBUG Loader:148 - processing result set
19:41:01,440 DEBUG StringType:65 - returning '11 ' as column: person_id
19:41:01,440 DEBUG Loader:260 - result row: 11
19:41:01,440 DEBUG Loader:357 - Initializing object from ResultSet: 11
19:41:01,440 DEBUG Loader:413 - Hydrating entity: test.Person#11
19:41:01,450 DEBUG StringType:65 - returning 'person11 ' as column: person_n2_
19:41:01,450 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,450 DEBUG StringType:65 - returning '11 ' as column: person_id__
19:41:01,460 DEBUG SessionImpl:1752 - loading [test.Person#11 ]
19:41:01,460 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#11 ]
19:41:01,470 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#11 ]
19:41:01,470 DEBUG StringType:65 - returning '12 ' as column: person_id
19:41:01,470 DEBUG Loader:260 - result row: 12
19:41:01,480 DEBUG Loader:357 - Initializing object from ResultSet: 12
19:41:01,480 DEBUG Loader:413 - Hydrating entity: test.Person#12
19:41:01,480 DEBUG StringType:65 - returning 'person12 ' as column: person_n2_
19:41:01,480 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,490 DEBUG StringType:65 - returning '12 ' as column: person_id__
19:41:01,500 DEBUG SessionImpl:1752 - loading [test.Person#12 ]
19:41:01,500 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#12 ]
19:41:01,500 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#12 ]
19:41:01,510 DEBUG StringType:65 - returning '13 ' as column: person_id
19:41:01,510 DEBUG Loader:260 - result row: 13
19:41:01,510 DEBUG Loader:357 - Initializing object from ResultSet: 13
19:41:01,530 DEBUG Loader:413 - Hydrating entity: test.Person#13
19:41:01,540 DEBUG StringType:65 - returning 'person13 ' as column: person_n2_
19:41:01,540 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,540 DEBUG StringType:65 - returning '13 ' as column: person_id__
19:41:01,550 DEBUG SessionImpl:1752 - loading [test.Person#13 ]
19:41:01,550 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#13 ]
19:41:01,550 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#13 ]
19:41:01,560 DEBUG StringType:65 - returning '14 ' as column: person_id
19:41:01,560 DEBUG Loader:260 - result row: 14
19:41:01,560 DEBUG Loader:357 - Initializing object from ResultSet: 14
19:41:01,570 DEBUG Loader:413 - Hydrating entity: test.Person#14
19:41:01,570 DEBUG StringType:65 - returning 'person14 ' as column: person_n2_
19:41:01,570 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,580 DEBUG StringType:65 - returning '14 ' as column: person_id__
19:41:01,580 DEBUG SessionImpl:1752 - loading [test.Person#14 ]
19:41:01,580 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#14 ]
19:41:01,590 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#14 ]
19:41:01,590 DEBUG StringType:65 - returning '15 ' as column: person_id
19:41:01,600 DEBUG Loader:260 - result row: 15
19:41:01,600 DEBUG Loader:357 - Initializing object from ResultSet: 15
19:41:01,600 DEBUG Loader:413 - Hydrating entity: test.Person#15
19:41:01,600 DEBUG StringType:65 - returning 'person15 ' as column: person_n2_
19:41:01,610 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,610 DEBUG StringType:65 - returning '15 ' as column: person_id__
19:41:01,620 DEBUG SessionImpl:1752 - loading [test.Person#15 ]
19:41:01,620 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#15 ]
19:41:01,630 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#15 ]
19:41:01,650 DEBUG Loader:182 - done processing result set (5 rows)
19:41:01,650 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,650 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,650 DEBUG Loader:195 - total objects hydrated: 5
19:41:01,660 DEBUG SessionImpl:1954 - resolving associations for [test.Person#11 ]
19:41:01,660 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:01,660 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:01,671 DEBUG SessionImpl:1887 - object not resolved in any cache [test.Group#1 ]
19:41:01,671 DEBUG EntityPersister:394 - Materializing entity: test.Group#1
19:41:01,681 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:01,681 DEBUG SessionFactoryImpl:526 - prepared statement get: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
19:41:01,681 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,691 DEBUG StringType:44 - binding '1 ' to parameter: 1
19:41:01,691 DEBUG Loader:148 - processing result set
19:41:01,711 DEBUG Loader:260 - result row: 1
19:41:01,711 DEBUG Loader:357 - Initializing object from ResultSet: 1
19:41:01,711 DEBUG Loader:413 - Hydrating entity: test.Group#1
19:41:01,721 DEBUG StringType:65 - returning 'group1 ' as column: group_name
19:41:01,721 DEBUG Loader:182 - done processing result set (1 rows)
19:41:01,721 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,731 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,731 DEBUG Loader:195 - total objects hydrated: 1
19:41:01,741 DEBUG SessionImpl:1954 - resolving associations for [test.Group#1 ]
19:41:01,741 DEBUG SessionImpl:2888 - initializing collection [test.Group.persons#1 ]
19:41:01,741 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:01,771 DEBUG SessionFactoryImpl:526 - prepared statement get: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
Hibernate: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
19:41:01,791 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,791 DEBUG StringType:44 - binding '1 ' to parameter: 1
19:41:01,811 DEBUG Loader:148 - processing result set
19:41:01,811 DEBUG StringType:65 - returning '11 ' as column: person_id
19:41:01,821 DEBUG Loader:260 - result row: 11
19:41:01,821 DEBUG StringType:65 - returning '11 ' as column: person_id__
19:41:01,821 DEBUG SessionImpl:1752 - loading [test.Person#11 ]
19:41:01,831 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#11 ]
19:41:01,831 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#11 ]
19:41:01,841 DEBUG StringType:65 - returning '12 ' as column: person_id
19:41:01,841 DEBUG Loader:260 - result row: 12
19:41:01,841 DEBUG StringType:65 - returning '12 ' as column: person_id__
19:41:01,841 DEBUG SessionImpl:1752 - loading [test.Person#12 ]
19:41:01,851 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#12 ]
19:41:01,851 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#12 ]
19:41:01,861 DEBUG StringType:65 - returning '13 ' as column: person_id
19:41:01,871 DEBUG Loader:260 - result row: 13
19:41:01,881 DEBUG StringType:65 - returning '13 ' as column: person_id__
19:41:01,881 DEBUG SessionImpl:1752 - loading [test.Person#13 ]
19:41:01,881 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#13 ]
19:41:01,901 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#13 ]
19:41:01,901 DEBUG StringType:65 - returning '14 ' as column: person_id
19:41:01,911 DEBUG Loader:260 - result row: 14
19:41:01,911 DEBUG StringType:65 - returning '14 ' as column: person_id__
19:41:01,911 DEBUG SessionImpl:1752 - loading [test.Person#14 ]
19:41:01,921 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#14 ]
19:41:01,921 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#14 ]
19:41:01,931 DEBUG StringType:65 - returning '15 ' as column: person_id
19:41:01,931 DEBUG Loader:260 - result row: 15
19:41:01,931 DEBUG StringType:65 - returning '15 ' as column: person_id__
19:41:01,941 DEBUG SessionImpl:1752 - loading [test.Person#15 ]
19:41:01,941 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#15 ]
19:41:01,951 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#15 ]
19:41:01,951 DEBUG Loader:182 - done processing result set (5 rows)
19:41:01,951 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,961 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,961 DEBUG Loader:195 - total objects hydrated: 0
19:41:01,961 DEBUG SessionImpl:1975 - done materializing entity [test.Group#1 ]
19:41:01,971 DEBUG SessionImpl:1975 - done materializing entity [test.Person#11 ]
19:41:01,991 DEBUG SessionImpl:1954 - resolving associations for [test.Person#12 ]
19:41:01,991 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:01,991 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:01,991 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,001 DEBUG SessionImpl:1975 - done materializing entity [test.Person#12 ]
19:41:02,001 DEBUG SessionImpl:1954 - resolving associations for [test.Person#13 ]
19:41:02,001 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:02,011 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:02,011 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,011 DEBUG SessionImpl:1975 - done materializing entity [test.Person#13 ]
19:41:02,021 DEBUG SessionImpl:1954 - resolving associations for [test.Person#14 ]
19:41:02,021 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:02,021 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:02,021 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,031 DEBUG SessionImpl:1975 - done materializing entity [test.Person#14 ]
19:41:02,031 DEBUG SessionImpl:1954 - resolving associations for [test.Person#15 ]
19:41:02,041 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:02,041 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:02,041 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,051 DEBUG SessionImpl:1975 - done materializing entity [test.Person#15 ]
19:41:02,051 DEBUG SessionImpl:1975 - done materializing entity [test.Group#1]
----------------------------------------------------------------------------------------------------------------------------------------
If hibernate have a trim() operator when dealing with SQLServerDialect, the problem will be corrected perfectly.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-28 22:54:28
|
The following comment has been added to this issue:
Author: Eric Pugh
Created: Sun, 28 Dec 2003 4:53 PM
Body:
Benoit, Can you share the result set proxy that you have? I have the same problem, and am getting around it by not loading all my data in one sql statement. While debugging this problem, I found quite a few posts on the net about it. It sounds like something we should update in the wiki (http://www.hibernate.org/80.html). MS SQL's JDBC driver may be buggy, but it is very popular because it is free and from Microsoft...
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-484
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-484
Summary: ResultSet can not re-read row data for column 2
Type: Bug
Status: Closed
Priority: Major
Resolution: WON'T FIX
Project: Hibernate2
Assignee:
Reporter: Benoit Menendez
Created: Thu, 20 Nov 2003 12:24 PM
Updated: Sun, 28 Dec 2003 4:53 PM
Description:
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-28 20:49:26
|
The following issue has been updated:
Updater: Nick Heudecker (mailto:ni...@sy...)
Date: Sun, 28 Dec 2003 2:47 PM
Comment:
Here is the patch file for AbstractQueryImpl.java. Generated with: diff -C 5 from-file to-file
Changes:
Attachment changed to AbstractQueryImpl.patch
---------------------------------------------------------------------
For a full history of the issue, see:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-579&page=history
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-579
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-579
Summary: Patch AbstractQuery so that it supports parameter lists
Type: Improvement
Status: Unassigned
Priority: Minor
Project: Hibernate2
Components:
core
Versions:
2.1
2.0 final
2.1.1
Assignee:
Reporter: Nick Heudecker
Created: Fri, 26 Dec 2003 11:42 AM
Updated: Sun, 28 Dec 2003 2:47 PM
Environment: Any
Description:
Currently, the AbstractQuery class doesn't take into account setting parameter lists when using the 'setProperties(Object)' method. This would be extremely helpful to me. A patch is below.
public Query setProperties(Object bean) throws HibernateException {
Class clazz = bean.getClass();
String[] params = getNamedParameters();
for (int i = 0; i < params.length; i++) {
String namedParam = params[i];
try {
Getter getter = ReflectHelper.getter(clazz, namedParam);
Class retType = getter.getReturnType();
if (retType.isArray() ||
retType instanceof java.util.Collection) {
setParameterList( namedParam, getter.get(bean) );
}
else {
setParameter( namedParam, getter.get(bean),
guessType( getter.getReturnType() ) );
}
}
catch (PropertyNotFoundException pnfe) {
// shouldn't something be logged here....?
}
}
return this;
}
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
|
From: <leg...@at...> - 2003-12-28 12:02:31
|
The following comment has been added to this issue:
Author: Max Rydahl Andersen
Created: Sun, 28 Dec 2003 6:01 AM
Body:
Yup - but the "weird" thing is that the bug seems to indicate that it worked in previous versions of hibernate ?
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-582
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-582
Summary: Extra ' ' when read char type field in SQLServer 2000
Type: Bug
Status: Closed
Priority: Critical
Resolution: REJECTED
Project: Hibernate2
Components:
core
Versions:
2.1.1
Assignee: Gavin King
Reporter: Shining
Created: Sat, 27 Dec 2003 7:33 AM
Updated: Sun, 28 Dec 2003 6:01 AM
Environment: Windows2000 Professional with SP4, JDK 1.4.2_02, Eclipse 2.1.2 Hibernate 2.1.1 SQLServer 2000 Desktop with SP2, Microsoft SQLServer JDBC Driver SP2
Description:
There's a strange phenomenon when using SQLServer2000. When you read a char field through JDBC(ODBC is the same), the result were padded with extra blankspace, the length of blank space is equal to the length of data character subtract from the length of the field. for example:
field type is: char(10), data character is '1', the result of read will be '1 '. The same reading operator in MySQL is correct. Other Database server have not been tested.
When I test the sample code(figure 1) with hibernate 2.1.1, I found a bug that course collection lost when load a class with the char type id and a collection field with the same id as the id column.
Hibernate 2.1.1 DEBUG&OUTPUT Information
----------------------------------------------------------------------------------------------------------------------------------------
19:49:19,902 INFO Environment:432 - Hibernate 2.1.1
19:49:19,952 INFO Environment:461 - hibernate.properties not found
19:49:20,042 INFO Environment:481 - using CGLIB reflection optimizer
19:49:20,102 INFO Configuration:843 - configuring from resource: /hibernate.cfg.xml
19:49:20,112 INFO Configuration:815 - Configuration resource: /hibernate.cfg.xml
......
19:49:37,428 DEBUG SessionFactoryImpl:196 - instantiated session factory
19:49:37,729 DEBUG SessionImpl:528 - opened session
19:49:37,739 DEBUG SessionImpl:1913 - loading [test.Group#1]
19:49:37,739 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1]
19:49:37,759 DEBUG SessionImpl:2043 - object not resolved in any cache [test.Group#1]
19:49:37,759 DEBUG EntityPersister:417 - Materializing entity: [test.Group#1]
19:49:37,779 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:49:37,779 DEBUG DriverManagerConnectionProvider:78 - total checked-out connections: 0
19:49:37,789 DEBUG DriverManagerConnectionProvider:84 - using pooled JDBC connection, pool size: 0
19:49:37,789 DEBUG SQL:223 - select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
19:49:37,789 DEBUG BatcherImpl:227 - preparing statement
19:49:38,239 DEBUG StringType:46 - binding '1' to parameter: 1
19:49:38,590 DEBUG Loader:196 - processing result set
19:49:38,590 DEBUG Loader:404 - result row: 1
19:49:38,610 DEBUG Loader:535 - Initializing object from ResultSet: 1
19:49:38,630 DEBUG Loader:604 - Hydrating entity: test.Group#1
19:49:38,650 DEBUG StringType:68 - returning 'group1 ' as column: group_name0_
19:49:38,660 DEBUG Loader:225 - done processing result set (1 rows)
19:49:38,680 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:49:38,680 DEBUG BatcherImpl:240 - closing statement
19:49:38,690 DEBUG Loader:238 - total objects hydrated: 1
19:49:38,700 DEBUG SessionImpl:2129 - resolving associations for [test.Group#1]
19:49:38,720 DEBUG SessionImpl:3746 - collection not cached
19:49:38,760 DEBUG SessionImpl:2153 - done materializing entity [test.Group#1]
19:49:38,760 DEBUG SessionImpl:3000 - initializing non-lazy collections
19:49:38,760 DEBUG SessionImpl:3132 - initializing collection [test.Group.persons#1]
19:49:38,770 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:49:38,770 DEBUG SQL:223 - select persons0_.person_id as person_id__, persons0_.group_id as group_id__, persons0_.person_id as person_id0_, persons0_.person_name as person_n2_0_, persons0_.group_id as group_id0_ from tbl_person persons0_ where persons0_.group_id=?
Hibernate: select persons0_.person_id as person_id__, persons0_.group_id as group_id__, persons0_.person_id as person_id0_, persons0_.person_name as person_n2_0_, persons0_.group_id as group_id0_ from tbl_person persons0_ where persons0_.group_id=?
19:49:38,790 DEBUG BatcherImpl:227 - preparing statement
19:49:38,790 DEBUG StringType:46 - binding '1' to parameter: 1
19:49:38,810 DEBUG Loader:326 - result set contains (possibly empty) collection: [test.Group.persons#1]
19:49:38,810 DEBUG SessionImpl:2902 - uninitialized collection: initializing
19:49:38,830 DEBUG Loader:196 - processing result set
19:49:38,840 DEBUG StringType:68 - returning '11 ' as column: person_id0_
19:49:38,840 DEBUG Loader:404 - result row: 11
19:49:38,850 DEBUG Loader:535 - Initializing object from ResultSet: 11
19:49:38,850 DEBUG Loader:604 - Hydrating entity: test.Person#11
19:49:38,860 DEBUG StringType:68 - returning 'person11 ' as column: person_n2_0_
19:49:38,860 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:38,860 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:38,870 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:38,870 DEBUG SessionImpl:2914 - new collection: instantiating
19:49:38,870 DEBUG StringType:68 - returning '11 ' as column: person_id__
19:49:38,880 DEBUG SessionImpl:1913 - loading [test.Person#11 ]
19:49:38,890 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#11 ]
19:49:38,910 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#11 ]
19:49:38,910 DEBUG StringType:68 - returning '12 ' as column: person_id0_
19:49:38,910 DEBUG Loader:404 - result row: 12
19:49:38,920 DEBUG Loader:535 - Initializing object from ResultSet: 12
19:49:38,920 DEBUG Loader:604 - Hydrating entity: test.Person#12
19:49:38,930 DEBUG StringType:68 - returning 'person12 ' as column: person_n2_0_
19:49:38,930 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:38,960 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:38,960 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:38,960 DEBUG SessionImpl:2925 - reading row
19:49:38,960 DEBUG StringType:68 - returning '12 ' as column: person_id__
19:49:39,001 DEBUG SessionImpl:1913 - loading [test.Person#12 ]
19:49:39,001 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#12 ]
19:49:39,011 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#12 ]
19:49:39,011 DEBUG StringType:68 - returning '13 ' as column: person_id0_
19:49:39,011 DEBUG Loader:404 - result row: 13
19:49:39,021 DEBUG Loader:535 - Initializing object from ResultSet: 13
19:49:39,021 DEBUG Loader:604 - Hydrating entity: test.Person#13
19:49:39,021 DEBUG StringType:68 - returning 'person13 ' as column: person_n2_0_
19:49:39,021 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:39,031 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:39,031 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:39,041 DEBUG SessionImpl:2925 - reading row
19:49:39,041 DEBUG StringType:68 - returning '13 ' as column: person_id__
19:49:39,051 DEBUG SessionImpl:1913 - loading [test.Person#13 ]
19:49:39,071 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#13 ]
19:49:39,071 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#13 ]
19:49:39,081 DEBUG StringType:68 - returning '14 ' as column: person_id0_
19:49:39,091 DEBUG Loader:404 - result row: 14
19:49:39,091 DEBUG Loader:535 - Initializing object from ResultSet: 14
19:49:39,091 DEBUG Loader:604 - Hydrating entity: test.Person#14
19:49:39,091 DEBUG StringType:68 - returning 'person14 ' as column: person_n2_0_
19:49:39,101 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:39,101 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:39,111 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:39,111 DEBUG SessionImpl:2925 - reading row
19:49:39,111 DEBUG StringType:68 - returning '14 ' as column: person_id__
19:49:39,131 DEBUG SessionImpl:1913 - loading [test.Person#14 ]
19:49:39,131 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#14 ]
19:49:39,131 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#14 ]
19:49:39,131 DEBUG StringType:68 - returning '15 ' as column: person_id0_
19:49:39,141 DEBUG Loader:404 - result row: 15
19:49:39,141 DEBUG Loader:535 - Initializing object from ResultSet: 15
19:49:39,151 DEBUG Loader:604 - Hydrating entity: test.Person#15
19:49:39,151 DEBUG StringType:68 - returning 'person15 ' as column: person_n2_0_
19:49:39,161 DEBUG StringType:68 - returning '1 ' as column: group_id0_
19:49:39,161 DEBUG StringType:68 - returning '1 ' as column: group_id__
19:49:39,161 DEBUG Loader:288 - found row of collection: [test.Group.persons#1 ]
19:49:39,171 DEBUG SessionImpl:2925 - reading row
19:49:39,201 DEBUG StringType:68 - returning '15 ' as column: person_id__
19:49:39,201 DEBUG SessionImpl:1913 - loading [test.Person#15 ]
19:49:39,211 DEBUG SessionImpl:2010 - attempting to resolve [test.Person#15 ]
19:49:39,211 DEBUG SessionImpl:2026 - resolved object in session cache [test.Person#15 ]
19:49:39,221 DEBUG Loader:225 - done processing result set (5 rows)
19:49:39,221 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:49:39,221 DEBUG BatcherImpl:240 - closing statement
19:49:39,231 DEBUG Loader:238 - total objects hydrated: 5
19:49:39,231 DEBUG SessionImpl:2129 - resolving associations for [test.Person#11 ]
{****
19:49:39,241 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,241 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,241 DEBUG SessionImpl:2043 - object not resolved in any cache [test.Group#1 ]
***}
19:49:39,241 DEBUG EntityPersister:417 - Materializing entity: [test.Group#1 ]
19:49:39,251 DEBUG BatcherImpl:192 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:49:39,251 DEBUG SQL:223 - select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id0_, group0_.group_name as group_name0_ from tbl_group group0_ where group0_.group_id=?
19:49:39,261 DEBUG BatcherImpl:227 - preparing statement
19:49:39,261 DEBUG StringType:46 - binding '1 ' to parameter: 1
19:49:39,281 DEBUG Loader:196 - processing result set
19:49:39,281 DEBUG Loader:404 - result row: 1
19:49:39,281 DEBUG Loader:535 - Initializing object from ResultSet: 1
19:49:39,291 DEBUG Loader:604 - Hydrating entity: test.Group#1
19:49:39,321 DEBUG StringType:68 - returning 'group1 ' as column: group_name0_
19:49:39,321 DEBUG Loader:225 - done processing result set (1 rows)
19:49:39,331 DEBUG BatcherImpl:199 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:49:39,331 DEBUG BatcherImpl:240 - closing statement
19:49:39,331 DEBUG Loader:238 - total objects hydrated: 1
19:49:39,341 DEBUG SessionImpl:2129 - resolving associations for [test.Group#1 ]
19:49:39,341 DEBUG SessionImpl:2153 - done materializing entity [test.Group#1 ]
19:49:39,351 DEBUG SessionImpl:2153 - done materializing entity [test.Person#11 ]
19:49:39,351 DEBUG SessionImpl:2129 - resolving associations for [test.Person#12 ]
19:49:39,351 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,361 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,361 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,371 DEBUG SessionImpl:2153 - done materializing entity [test.Person#12 ]
19:49:39,371 DEBUG SessionImpl:2129 - resolving associations for [test.Person#13 ]
19:49:39,381 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,381 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,381 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,381 DEBUG SessionImpl:2153 - done materializing entity [test.Person#13 ]
19:49:39,391 DEBUG SessionImpl:2129 - resolving associations for [test.Person#14 ]
19:49:39,391 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,401 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,401 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,411 DEBUG SessionImpl:2153 - done materializing entity [test.Person#14 ]
19:49:39,411 DEBUG SessionImpl:2129 - resolving associations for [test.Person#15 ]
19:49:39,441 DEBUG SessionImpl:1913 - loading [test.Group#1 ]
19:49:39,441 DEBUG SessionImpl:2010 - attempting to resolve [test.Group#1 ]
19:49:39,441 DEBUG SessionImpl:2026 - resolved object in session cache [test.Group#1 ]
19:49:39,451 DEBUG SessionImpl:2153 - done materializing entity [test.Person#15 ]
19:49:39,451 DEBUG SessionImpl:2961 - 2 collections were found in result set
19:49:39,461 DEBUG SessionImpl:2979 - collection fully initialized: [test.Group.persons#1 ]
19:49:39,461 DEBUG SessionImpl:2979 - collection fully initialized: [test.Group.persons#1]
19:49:39,461 DEBUG SessionImpl:2982 - 2 collections initialized
----------------------------------------------------------------------------------------------------------------------------------------
The message in {**** ***} show the problem reson. Because of the strange behavior of the jdbc driver of SQLServer, the object id in the cache is "1"(load(group.class, "1")), the id read through jdbc is "1 ", hibernate can not got the group object from the cache.
I have test the same code with the hibernate version 2.0.3, the result is correct, the debug information is:
Hibernate 2.0.3 DEBUG&OUTPUT Information
----------------------------------------------------------------------------------------------------------------------------------------
19:40:48,701 INFO Environment:403 - Hibernate 2.0.3
19:40:48,721 INFO Environment:432 - hibernate.properties not found
19:40:48,751 INFO Environment:452 - using CGLIB reflection optimizer
19:40:48,761 INFO Environment:462 - JVM proxy support: true
19:40:48,791 INFO Configuration:703 - Configuration resource: /hibernate.cfg.xml
19:41:00,579 INFO SessionFactoryImpl:269 - Query language substitutions: {}
......
19:41:00,589 DEBUG SessionFactoryImpl:281 - instantiated session factory
19:41:00,749 DEBUG SessionImpl:413 - opened session
19:41:00,769 DEBUG SessionImpl:1752 - loading [test.Group#1]
19:41:00,769 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1]
19:41:00,789 DEBUG SessionImpl:1887 - object not resolved in any cache [test.Group#1]
19:41:00,789 DEBUG EntityPersister:394 - Materializing entity: test.Group#1
19:41:00,799 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:00,799 DEBUG DriverManagerConnectionProvider:77 - total checked-out connections: 0
19:41:00,799 DEBUG DriverManagerConnectionProvider:83 - using pooled JDBC connection, pool size: 0
19:41:00,809 DEBUG SessionFactoryImpl:526 - prepared statement get: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
19:41:00,809 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,160 DEBUG StringType:44 - binding '1' to parameter: 1
19:41:01,300 DEBUG Loader:148 - processing result set
19:41:01,310 DEBUG Loader:260 - result row: 1
19:41:01,310 DEBUG Loader:357 - Initializing object from ResultSet: 1
19:41:01,320 DEBUG Loader:413 - Hydrating entity: test.Group#1
19:41:01,320 DEBUG StringType:65 - returning 'group1 ' as column: group_name
19:41:01,330 DEBUG Loader:182 - done processing result set (1 rows)
19:41:01,340 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,350 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,350 DEBUG Loader:195 - total objects hydrated: 1
19:41:01,350 DEBUG SessionImpl:1954 - resolving associations for [test.Group#1]
19:41:01,390 DEBUG SessionImpl:2888 - initializing collection [test.Group.persons#1]
19:41:01,390 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:01,400 DEBUG SessionFactoryImpl:526 - prepared statement get: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
Hibernate: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
19:41:01,400 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,400 DEBUG StringType:44 - binding '1' to parameter: 1
19:41:01,430 DEBUG Loader:148 - processing result set
19:41:01,440 DEBUG StringType:65 - returning '11 ' as column: person_id
19:41:01,440 DEBUG Loader:260 - result row: 11
19:41:01,440 DEBUG Loader:357 - Initializing object from ResultSet: 11
19:41:01,440 DEBUG Loader:413 - Hydrating entity: test.Person#11
19:41:01,450 DEBUG StringType:65 - returning 'person11 ' as column: person_n2_
19:41:01,450 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,450 DEBUG StringType:65 - returning '11 ' as column: person_id__
19:41:01,460 DEBUG SessionImpl:1752 - loading [test.Person#11 ]
19:41:01,460 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#11 ]
19:41:01,470 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#11 ]
19:41:01,470 DEBUG StringType:65 - returning '12 ' as column: person_id
19:41:01,470 DEBUG Loader:260 - result row: 12
19:41:01,480 DEBUG Loader:357 - Initializing object from ResultSet: 12
19:41:01,480 DEBUG Loader:413 - Hydrating entity: test.Person#12
19:41:01,480 DEBUG StringType:65 - returning 'person12 ' as column: person_n2_
19:41:01,480 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,490 DEBUG StringType:65 - returning '12 ' as column: person_id__
19:41:01,500 DEBUG SessionImpl:1752 - loading [test.Person#12 ]
19:41:01,500 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#12 ]
19:41:01,500 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#12 ]
19:41:01,510 DEBUG StringType:65 - returning '13 ' as column: person_id
19:41:01,510 DEBUG Loader:260 - result row: 13
19:41:01,510 DEBUG Loader:357 - Initializing object from ResultSet: 13
19:41:01,530 DEBUG Loader:413 - Hydrating entity: test.Person#13
19:41:01,540 DEBUG StringType:65 - returning 'person13 ' as column: person_n2_
19:41:01,540 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,540 DEBUG StringType:65 - returning '13 ' as column: person_id__
19:41:01,550 DEBUG SessionImpl:1752 - loading [test.Person#13 ]
19:41:01,550 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#13 ]
19:41:01,550 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#13 ]
19:41:01,560 DEBUG StringType:65 - returning '14 ' as column: person_id
19:41:01,560 DEBUG Loader:260 - result row: 14
19:41:01,560 DEBUG Loader:357 - Initializing object from ResultSet: 14
19:41:01,570 DEBUG Loader:413 - Hydrating entity: test.Person#14
19:41:01,570 DEBUG StringType:65 - returning 'person14 ' as column: person_n2_
19:41:01,570 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,580 DEBUG StringType:65 - returning '14 ' as column: person_id__
19:41:01,580 DEBUG SessionImpl:1752 - loading [test.Person#14 ]
19:41:01,580 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#14 ]
19:41:01,590 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#14 ]
19:41:01,590 DEBUG StringType:65 - returning '15 ' as column: person_id
19:41:01,600 DEBUG Loader:260 - result row: 15
19:41:01,600 DEBUG Loader:357 - Initializing object from ResultSet: 15
19:41:01,600 DEBUG Loader:413 - Hydrating entity: test.Person#15
19:41:01,600 DEBUG StringType:65 - returning 'person15 ' as column: person_n2_
19:41:01,610 DEBUG StringType:65 - returning '1 ' as column: group_id
19:41:01,610 DEBUG StringType:65 - returning '15 ' as column: person_id__
19:41:01,620 DEBUG SessionImpl:1752 - loading [test.Person#15 ]
19:41:01,620 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#15 ]
19:41:01,630 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#15 ]
19:41:01,650 DEBUG Loader:182 - done processing result set (5 rows)
19:41:01,650 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,650 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,650 DEBUG Loader:195 - total objects hydrated: 5
19:41:01,660 DEBUG SessionImpl:1954 - resolving associations for [test.Person#11 ]
19:41:01,660 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:01,660 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:01,671 DEBUG SessionImpl:1887 - object not resolved in any cache [test.Group#1 ]
19:41:01,671 DEBUG EntityPersister:394 - Materializing entity: test.Group#1
19:41:01,681 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:01,681 DEBUG SessionFactoryImpl:526 - prepared statement get: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
Hibernate: select group0_.group_id as group_id, group0_.group_name as group_name from tbl_group group0_ where group0_.group_id=?
19:41:01,681 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,691 DEBUG StringType:44 - binding '1 ' to parameter: 1
19:41:01,691 DEBUG Loader:148 - processing result set
19:41:01,711 DEBUG Loader:260 - result row: 1
19:41:01,711 DEBUG Loader:357 - Initializing object from ResultSet: 1
19:41:01,711 DEBUG Loader:413 - Hydrating entity: test.Group#1
19:41:01,721 DEBUG StringType:65 - returning 'group1 ' as column: group_name
19:41:01,721 DEBUG Loader:182 - done processing result set (1 rows)
19:41:01,721 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,731 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,731 DEBUG Loader:195 - total objects hydrated: 1
19:41:01,741 DEBUG SessionImpl:1954 - resolving associations for [test.Group#1 ]
19:41:01,741 DEBUG SessionImpl:2888 - initializing collection [test.Group.persons#1 ]
19:41:01,741 DEBUG BatcherImpl:166 - about to open: 0 open PreparedStatements, 0 open ResultSets
19:41:01,771 DEBUG SessionFactoryImpl:526 - prepared statement get: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
Hibernate: select tbl_pers0_.person_id as person_id__, tbl_pers0_.person_id as person_id, tbl_pers0_.person_name as person_n2_, tbl_pers0_.group_id as group_id from tbl_person tbl_pers0_ where tbl_pers0_.group_id=?
19:41:01,791 DEBUG SessionFactoryImpl:536 - preparing statement
19:41:01,791 DEBUG StringType:44 - binding '1 ' to parameter: 1
19:41:01,811 DEBUG Loader:148 - processing result set
19:41:01,811 DEBUG StringType:65 - returning '11 ' as column: person_id
19:41:01,821 DEBUG Loader:260 - result row: 11
19:41:01,821 DEBUG StringType:65 - returning '11 ' as column: person_id__
19:41:01,821 DEBUG SessionImpl:1752 - loading [test.Person#11 ]
19:41:01,831 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#11 ]
19:41:01,831 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#11 ]
19:41:01,841 DEBUG StringType:65 - returning '12 ' as column: person_id
19:41:01,841 DEBUG Loader:260 - result row: 12
19:41:01,841 DEBUG StringType:65 - returning '12 ' as column: person_id__
19:41:01,841 DEBUG SessionImpl:1752 - loading [test.Person#12 ]
19:41:01,851 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#12 ]
19:41:01,851 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#12 ]
19:41:01,861 DEBUG StringType:65 - returning '13 ' as column: person_id
19:41:01,871 DEBUG Loader:260 - result row: 13
19:41:01,881 DEBUG StringType:65 - returning '13 ' as column: person_id__
19:41:01,881 DEBUG SessionImpl:1752 - loading [test.Person#13 ]
19:41:01,881 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#13 ]
19:41:01,901 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#13 ]
19:41:01,901 DEBUG StringType:65 - returning '14 ' as column: person_id
19:41:01,911 DEBUG Loader:260 - result row: 14
19:41:01,911 DEBUG StringType:65 - returning '14 ' as column: person_id__
19:41:01,911 DEBUG SessionImpl:1752 - loading [test.Person#14 ]
19:41:01,921 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#14 ]
19:41:01,921 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#14 ]
19:41:01,931 DEBUG StringType:65 - returning '15 ' as column: person_id
19:41:01,931 DEBUG Loader:260 - result row: 15
19:41:01,931 DEBUG StringType:65 - returning '15 ' as column: person_id__
19:41:01,941 DEBUG SessionImpl:1752 - loading [test.Person#15 ]
19:41:01,941 DEBUG SessionImpl:1843 - attempting to resolve [test.Person#15 ]
19:41:01,951 DEBUG SessionImpl:1858 - resolved object in session cache [test.Person#15 ]
19:41:01,951 DEBUG Loader:182 - done processing result set (5 rows)
19:41:01,951 DEBUG BatcherImpl:173 - done closing: 0 open PreparedStatements, 0 open ResultSets
19:41:01,961 DEBUG SessionFactoryImpl:554 - closing statement
19:41:01,961 DEBUG Loader:195 - total objects hydrated: 0
19:41:01,961 DEBUG SessionImpl:1975 - done materializing entity [test.Group#1 ]
19:41:01,971 DEBUG SessionImpl:1975 - done materializing entity [test.Person#11 ]
19:41:01,991 DEBUG SessionImpl:1954 - resolving associations for [test.Person#12 ]
19:41:01,991 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:01,991 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:01,991 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,001 DEBUG SessionImpl:1975 - done materializing entity [test.Person#12 ]
19:41:02,001 DEBUG SessionImpl:1954 - resolving associations for [test.Person#13 ]
19:41:02,001 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:02,011 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:02,011 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,011 DEBUG SessionImpl:1975 - done materializing entity [test.Person#13 ]
19:41:02,021 DEBUG SessionImpl:1954 - resolving associations for [test.Person#14 ]
19:41:02,021 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:02,021 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:02,021 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,031 DEBUG SessionImpl:1975 - done materializing entity [test.Person#14 ]
19:41:02,031 DEBUG SessionImpl:1954 - resolving associations for [test.Person#15 ]
19:41:02,041 DEBUG SessionImpl:1752 - loading [test.Group#1 ]
19:41:02,041 DEBUG SessionImpl:1843 - attempting to resolve [test.Group#1 ]
19:41:02,041 DEBUG SessionImpl:1858 - resolved object in session cache [test.Group#1 ]
19:41:02,051 DEBUG SessionImpl:1975 - done materializing entity [test.Person#15 ]
19:41:02,051 DEBUG SessionImpl:1975 - done materializing entity [test.Group#1]
----------------------------------------------------------------------------------------------------------------------------------------
If hibernate have a trim() operator when dealing with SQLServerDialect, the problem will be corrected perfectly.
---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
93 messages has been excluded from this view by a project administrator.
