Menu
▾
▴
springframework-developer
|
From: Alef A. <al...@jt...> - 2004-11-13 13:07:59
|
Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
2.0.2 I think) in its server/default/lib directory. They recently
introduced Hibernate archives (HARs), maybe that's why the jars are in
there. I would expect some weird classnotfoundexception because of this,
not a server hang, but it might be related.
Maybe you could try to cleanup the server/default/lib directory or
create yourself a separate server config.
Alef
> -----Original Message-----
> From: spr...@li...=20
> [mailto:spr...@li...]
> On Behalf Of Colin Sampaleanu
> Sent: Saturday, November 13, 2004 1:15 AM
> To: spr...@li...
> Subject: [Springframework-developer] Spring + MySQL + JDBC or=20
> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>=20
> I am seeing extremely strange, completely repeatable=20
> behaviour, where Petclinc in both the JDBC and the hibernate=20
> deployment, using HSQL, starts up ok in JBoss 3.2.5, but=20
> hangs after a certain point in JBoss 3.2.6. The ejbtest=20
> sample does exactly the same thing. Weird thing in
> 3.2.6 is that if I shut down the external HSQL db (started=20
> with the server.bat file), then the app starts fine (getting=20
> some obvious errors since it can't actually talk to the db,=20
> but doesn't hang). This means the issues are somehow related=20
> to HSQL in the 3.2.6 environment.
>=20
> Here's the sequence from the JDBC version:
>=20
> 18:51:31,218 INFO [DefaultListableBeanFactory] Creating=20
> shared instance of sing leton bean 'dataSource'
> 18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC=20
> driver: org.hsqldb.jdbc Driver
> 18:51:31,234 INFO [DefaultListableBeanFactory] Creating=20
> shared instance of sing leton bean 'transactionManager'
> 18:51:31,250 INFO [DefaultListableBeanFactory] Creating=20
> shared instance of sing leton bean 'clinic'
> 18:51:31,296 INFO [DefaultListableBeanFactory] Creating=20
> shared instance of sing leton bean 'hsqlClinic'
> 18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean=20
> definitions from c lass path resource=20
> [org/springframework/jdbc/support/sql-error-codes.xml]
> 18:51:31,421 INFO [XmlBeanFactory] Creating shared instance=20
> of singleton bean '
> DB2'
> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance=20
> of singleton bean '
> HSQL'
> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance=20
> of singleton bean '
> MS-SQL'
> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance=20
> of singleton bean '
> MySQL'
> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance=20
> of singleton bean '
> Oracle'
> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance=20
> of singleton bean '
> Informix'
> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance=20
> of singleton bean '
> PostgreSQL'
> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance=20
> of singleton bean '
> Sybase'
> 18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes=20
> loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,=20
> Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,=20
> MySQL, DB2*]
>=20
> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5=20
> continues with items below:
>=20
> 18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]=20
> RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM=20
> vets ORDER BY last_name,first_name] compiled 18:51:31,500=20
> INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation=20
> with SQL [SELECT id,name FROM specialties] compiled
> 18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]=20
> RdbmsOperation with SQL [SELECT specialty_id FROM=20
> vet_specialties WHERE vet_id=3D?] compiled
>=20
> ... and so on
>=20
> The Hibernate version has this sequence:
>=20
> 18:55:57,421 INFO [DefaultListableBeanFactory] Creating=20
> shared instance of sing leton bean 'dataSource'
> 18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC=20
> driver: org.hsqldb.jdbc Driver
> 18:55:57,437 INFO [DefaultListableBeanFactory] Creating=20
> shared instance of sing leton bean 'sessionFactory'
> 18:55:57,468 INFO [Environment] Hibernate 2.1.6
> 18:55:57,468 INFO [Environment] hibernate.properties not found
> 18:55:57,484 INFO [Environment] using CGLIB reflection=20
> optimizer 18:55:57,640 INFO [Binder] Mapping class:=20
> org.springframework.samples.petclinic
> .Vet -> vets
> 18:55:57,812 INFO [Binder] Mapping collection:=20
> org.springframework.samples.petc=20
> linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890=20
> INFO [Binder] Mapping class: org.springframework.samples.petclinic
> .Specialty -> specialties
> 18:55:57,890 INFO [Binder] Mapping class:=20
> org.springframework.samples.petclinic
> .Owner -> owners
> 18:55:57,906 INFO [Binder] Mapping class:=20
> org.springframework.samples.petclinic
> .Pet -> pets
> 18:55:57,906 INFO [Binder] Mapping class:=20
> org.springframework.samples.petclinic
> .PetType -> types
> 18:55:57,906 INFO [Binder] Mapping class:=20
> org.springframework.samples.petclinic
> .Visit -> visits
> 18:55:57,906 INFO [LocalSessionFactoryBean] Building new=20
> Hibernate SessionFacto ry
> 18:55:57,906 INFO [Configuration] processing one-to-many=20
> association mappings
> 18:55:57,906 INFO [Binder] Mapping collection:=20
> org.springframework.samples.petc linic.Owner.petsInternal -> pets
> 18:55:57,906 INFO [Binder] Mapping collection:=20
> org.springframework.samples.petc linic.Pet.visitsInternal -> visits
> 18:55:57,906 INFO [Configuration] processing one-to-one=20
> association property re ferences
> 18:55:57,906 INFO [Configuration] processing foreign key constraints
> 18:55:57,953 INFO [Dialect] Using dialect:=20
> net.sf.hibernate.dialect.HSQLDialect
>=20
> 18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
> 18:55:57,968 INFO [ConnectionProviderFactory] Initializing=20
> connection provider:
> org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
> 18:55:57,968 INFO [TransactionManagerLookupFactory] No=20
> TransactionManagerLookup configured (in JTA environment, use=20
> of process level read-write cache is not re
> commended)
>=20
> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5=20
> continues with items below:
>=20
> 18:55:57,984 INFO [SettingsFactory] Use scrollable result sets: true
> 18:55:57,984 INFO [SettingsFactory] Use JDBC3=20
> getGeneratedKeys(): false
> 18:55:57,984 INFO [SettingsFactory] Optimize cache for=20
> minimal puts: false
> 18:55:57,984 INFO [SettingsFactory] Query language substitutions: {}
> 18:55:57,984 INFO [SettingsFactory] cache provider:=20
> net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO =20
> [Configuration] instantiating and configuring caches
> 18:55:58,234 INFO [SessionFactoryImpl] building session factory
> 18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding=20
> factory to JNDI, no JNDI name configured
> 18:55:58,671 INFO [DefaultListableBeanFactory] Creating=20
> shared instance of sing leton bean 'transactionManager'
>=20
> 18:55:58,734 INFO [HibernateTransactionManager] Using=20
> DataSource [org.springfra=20
> mework.jdbc.datasource.DriverManagerDataSource@139491b] of=20
> Hibernate SessionFact ory for HibernateTransactionManager
> 18:55:58,734 INFO [DefaultListableBeanFactory] Creating=20
> shared instance of sing leton bean 'clinic'
> 18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean=20
> definitions from c lass path resource=20
> [org/springframework/jdbc/support/sql-error-codes.xml]
> 18:55:58,875 INFO [XmlBeanFactory] Creating shared instance=20
> of singleton bean '
> DB2'
>=20
> ... and so on
>=20
>=20
> Can anybody else duplicate this?
>=20
> Colin
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE FREE=20
> OODBMS DOWNLOAD - A multidimensional database that combines=20
> robust object and relational technologies, making it a=20
> perfect match for Java, C++,COM, XML, ODBC and JDBC.=20
> www.intersystems.com/match8=20
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>=20
>=20
>=20
>=20
|
|
From: <jue...@we...> - 2004-11-13 15:09:02
|
I guess it's better to stick with HSQLDB 1.7.1 for the Spring 1.1.x =
branch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we need to =
point out that this incompatibility issue exists.
=20
Why does JBoss ship tons of optional third-party jars in the server lib =
directory in the first place?? Could cause issues with newer Hibernate =
versions used in applications too, unless the JBoss-provided jars get =
removed from the server lib directory...
=20
Juergen
=20
________________________________
Von: spr...@li... im Auftrag =
von Colin Sampaleanu
Gesendet: Sa 13.11.2004 15:47
An: spr...@li...
Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or =
Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is only a
week or so after 2.1.4 came out, and almost 2 months before 2.1.5/2.1.6
came out.
But this is not Hibernate related. The hang happens with JDBC too. As I
mentioned in my other email, I think the problem is simply trying to mix
HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running, there is
no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
Colin
Alef Arendsen wrote:
>Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
>2.0.2 I think) in its server/default/lib directory. They recently
>introduced Hibernate archives (HARs), maybe that's why the jars are in
>there. I would expect some weird classnotfoundexception because of =
this,
>not a server hang, but it might be related.
>
>Maybe you could try to cleanup the server/default/lib directory or
>create yourself a separate server config.
>
>Alef
>
>
>=20
>
>>-----Original Message-----
>>From: spr...@li...
>>[mailto:spr...@li...]
>> On Behalf Of Colin Sampaleanu
>>Sent: Saturday, November 13, 2004 1:15 AM
>>To: spr...@li...
>>Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>
>>I am seeing extremely strange, completely repeatable
>>behaviour, where Petclinc in both the JDBC and the hibernate
>>deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>hangs after a certain point in JBoss 3.2.6. The ejbtest
>>sample does exactly the same thing. Weird thing in
>>3.2.6 is that if I shut down the external HSQL db (started
>>with the server.bat file), then the app starts fine (getting
>>some obvious errors since it can't actually talk to the db,
>>but doesn't hang). This means the issues are somehow related
>>to HSQL in the 3.2.6 environment.
>>
>>Here's the sequence from the JDBC version:
>>
>>18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'dataSource'
>>18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>driver: org.hsqldb.jdbc Driver
>>18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'transactionManager'
>>18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'clinic'
>>18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'hsqlClinic'
>>18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>definitions from c lass path resource
>>[org/springframework/jdbc/support/sql-error-codes.xml]
>>18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>DB2'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>HSQL'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>MS-SQL'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>MySQL'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>Oracle'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>Informix'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>PostgreSQL'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>Sybase'
>>18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>MySQL, DB2*]
>>
>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>continues with items below:
>>
>>18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>with SQL [SELECT id,name FROM specialties] compiled
>>18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>RdbmsOperation with SQL [SELECT specialty_id FROM
>>vet_specialties WHERE vet_id=3D?] compiled
>>
>>... and so on
>>
>>The Hibernate version has this sequence:
>>
>>18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'dataSource'
>>18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>driver: org.hsqldb.jdbc Driver
>>18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'sessionFactory'
>>18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>18:55:57,468 INFO [Environment] hibernate.properties not found
>>18:55:57,484 INFO [Environment] using CGLIB reflection
>>optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>org.springframework.samples.petclinic
>>.Vet -> vets
>>18:55:57,812 INFO [Binder] Mapping collection:
>>org.springframework.samples.petc
>>linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>INFO [Binder] Mapping class: org.springframework.samples.petclinic
>>.Specialty -> specialties
>>18:55:57,890 INFO [Binder] Mapping class:
>>org.springframework.samples.petclinic
>>.Owner -> owners
>>18:55:57,906 INFO [Binder] Mapping class:
>>org.springframework.samples.petclinic
>>.Pet -> pets
>>18:55:57,906 INFO [Binder] Mapping class:
>>org.springframework.samples.petclinic
>>.PetType -> types
>>18:55:57,906 INFO [Binder] Mapping class:
>>org.springframework.samples.petclinic
>>.Visit -> visits
>>18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>Hibernate SessionFacto ry
>>18:55:57,906 INFO [Configuration] processing one-to-many
>>association mappings
>>18:55:57,906 INFO [Binder] Mapping collection:
>>org.springframework.samples.petc linic.Owner.petsInternal -> pets
>>18:55:57,906 INFO [Binder] Mapping collection:
>>org.springframework.samples.petc linic.Pet.visitsInternal -> visits
>>18:55:57,906 INFO [Configuration] processing one-to-one
>>association property re ferences
>>18:55:57,906 INFO [Configuration] processing foreign key constraints
>>18:55:57,953 INFO [Dialect] Using dialect:
>>net.sf.hibernate.dialect.HSQLDialect
>>
>>18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
>>18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>connection provider:
>> org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>TransactionManagerLookup configured (in JTA environment, use
>>of process level read-write cache is not re
>>commended)
>>
>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>continues with items below:
>>
>>18:55:57,984 INFO [SettingsFactory] Use scrollable result sets: true
>>18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>getGeneratedKeys(): false
>>18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>minimal puts: false
>>18:55:57,984 INFO [SettingsFactory] Query language substitutions: {}
>>18:55:57,984 INFO [SettingsFactory] cache provider:
>>net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO=20
>>[Configuration] instantiating and configuring caches
>>18:55:58,234 INFO [SessionFactoryImpl] building session factory
>>18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>factory to JNDI, no JNDI name configured
>>18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'transactionManager'
>>
>>18:55:58,734 INFO [HibernateTransactionManager] Using
>>DataSource [org.springfra
>>mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>Hibernate SessionFact ory for HibernateTransactionManager
>>18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'clinic'
>>18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>definitions from c lass path resource
>>[org/springframework/jdbc/support/sql-error-codes.xml]
>>18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>DB2'
>>
>>... and so on
>>
>>
>>Can anybody else duplicate this?
>>
>>Colin
>>
>>
>>
>>-------------------------------------------------------
>>This SF.Net email is sponsored by: InterSystems CACHE FREE
>>OODBMS DOWNLOAD - A multidimensional database that combines
>>robust object and relational technologies, making it a
>>perfect match for Java, C++,COM, XML, ODBC and JDBC.
>>www.intersystems.com/match8
>>_______________________________________________
>>Springframework-developer mailing list
>>Spr...@li...
>>https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>
>>
>>
>>
>> =20
>>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: InterSystems CACHE
>FREE OODBMS DOWNLOAD - A multidimensional database that combines
>robust object and relational technologies, making it a perfect match
>for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>_______________________________________________
>Springframework-developer mailing list
>Spr...@li...
>https://lists.sourceforge.net/lists/listinfo/springframework-developer
>=20
>
-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
_______________________________________________
Springframework-developer mailing list
Spr...@li...
https://lists.sourceforge.net/lists/listinfo/springframework-developer
|
|
From: Colin S. <col...@ex...> - 2004-11-13 15:18:17
|
I don't have any problems either way. If switching to 1.7.2 is just a
few tweaks to some of the saved db scripts in CVS I don't see a big
issue with it, but whatever makes sense.
As for JBoss, they've shipped HSQLDB all along, since their queue used
it by default, for example. Hibernate they just added recently,
inlcuding a deployer service which deploys it automatically. For sure
somebody wanting to use Hibernate with JBoss needs to either take out
the JBoss incldued one (along with the older cglib) and the deployer, or
alternately upgrade the jars in JBoss...
jürgen höller [werk3AT] wrote:
>I guess it's better to stick with HSQLDB 1.7.1 for the Spring 1.1.x branch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we need to point out that this incompatibility issue exists.
>
>Why does JBoss ship tons of optional third-party jars in the server lib directory in the first place?? Could cause issues with newer Hibernate versions used in applications too, unless the JBoss-provided jars get removed from the server lib directory...
>
>Juergen
>
>
>________________________________
>
>Von: spr...@li... im Auftrag von Colin Sampaleanu
>Gesendet: Sa 13.11.2004 15:47
>An: spr...@li...
>Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>
>
>
>Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
>2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is only a
>week or so after 2.1.4 came out, and almost 2 months before 2.1.5/2.1.6
>came out.
>
>But this is not Hibernate related. The hang happens with JDBC too. As I
>mentioned in my other email, I think the problem is simply trying to mix
>HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running, there is
>no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
>
>Colin
>
>Alef Arendsen wrote:
>
>
>
>>Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
>>2.0.2 I think) in its server/default/lib directory. They recently
>>introduced Hibernate archives (HARs), maybe that's why the jars are in
>>there. I would expect some weird classnotfoundexception because of this,
>>not a server hang, but it might be related.
>>
>>Maybe you could try to cleanup the server/default/lib directory or
>>create yourself a separate server config.
>>
>>Alef
>>
>>
>>
>>
>>
>>
>>>-----Original Message-----
>>>From: spr...@li...
>>>[mailto:spr...@li...]
>>>On Behalf Of Colin Sampaleanu
>>>Sent: Saturday, November 13, 2004 1:15 AM
>>>To: spr...@li...
>>>Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>>Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>
>>>I am seeing extremely strange, completely repeatable
>>>behaviour, where Petclinc in both the JDBC and the hibernate
>>>deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>>hangs after a certain point in JBoss 3.2.6. The ejbtest
>>>sample does exactly the same thing. Weird thing in
>>>3.2.6 is that if I shut down the external HSQL db (started
>>>with the server.bat file), then the app starts fine (getting
>>>some obvious errors since it can't actually talk to the db,
>>>but doesn't hang). This means the issues are somehow related
>>>to HSQL in the 3.2.6 environment.
>>>
>>>Here's the sequence from the JDBC version:
>>>
>>>18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>>shared instance of sing leton bean 'dataSource'
>>>18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>>driver: org.hsqldb.jdbc Driver
>>>18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>>shared instance of sing leton bean 'transactionManager'
>>>18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>>shared instance of sing leton bean 'clinic'
>>>18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>>shared instance of sing leton bean 'hsqlClinic'
>>>18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>definitions from c lass path resource
>>>[org/springframework/jdbc/support/sql-error-codes.xml]
>>>18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>>of singleton bean '
>>>DB2'
>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>of singleton bean '
>>>HSQL'
>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>of singleton bean '
>>>MS-SQL'
>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>of singleton bean '
>>>MySQL'
>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>of singleton bean '
>>>Oracle'
>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>of singleton bean '
>>>Informix'
>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>of singleton bean '
>>>PostgreSQL'
>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>of singleton bean '
>>>Sybase'
>>>18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>>loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>>Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>>MySQL, DB2*]
>>>
>>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>continues with items below:
>>>
>>>18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>>RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>>vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>>INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>>with SQL [SELECT id,name FROM specialties] compiled
>>>18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>>RdbmsOperation with SQL [SELECT specialty_id FROM
>>>vet_specialties WHERE vet_id=?] compiled
>>>
>>>... and so on
>>>
>>>The Hibernate version has this sequence:
>>>
>>>18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>>shared instance of sing leton bean 'dataSource'
>>>18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>>driver: org.hsqldb.jdbc Driver
>>>18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>>shared instance of sing leton bean 'sessionFactory'
>>>18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>>18:55:57,468 INFO [Environment] hibernate.properties not found
>>>18:55:57,484 INFO [Environment] using CGLIB reflection
>>>optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>>org.springframework.samples.petclinic
>>>.Vet -> vets
>>>18:55:57,812 INFO [Binder] Mapping collection:
>>>org.springframework.samples.petc
>>>linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>>INFO [Binder] Mapping class: org.springframework.samples.petclinic
>>>.Specialty -> specialties
>>>18:55:57,890 INFO [Binder] Mapping class:
>>>org.springframework.samples.petclinic
>>>.Owner -> owners
>>>18:55:57,906 INFO [Binder] Mapping class:
>>>org.springframework.samples.petclinic
>>>.Pet -> pets
>>>18:55:57,906 INFO [Binder] Mapping class:
>>>org.springframework.samples.petclinic
>>>.PetType -> types
>>>18:55:57,906 INFO [Binder] Mapping class:
>>>org.springframework.samples.petclinic
>>>.Visit -> visits
>>>18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>>Hibernate SessionFacto ry
>>>18:55:57,906 INFO [Configuration] processing one-to-many
>>>association mappings
>>>18:55:57,906 INFO [Binder] Mapping collection:
>>>org.springframework.samples.petc linic.Owner.petsInternal -> pets
>>>18:55:57,906 INFO [Binder] Mapping collection:
>>>org.springframework.samples.petc linic.Pet.visitsInternal -> visits
>>>18:55:57,906 INFO [Configuration] processing one-to-one
>>>association property re ferences
>>>18:55:57,906 INFO [Configuration] processing foreign key constraints
>>>18:55:57,953 INFO [Dialect] Using dialect:
>>>net.sf.hibernate.dialect.HSQLDialect
>>>
>>>18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
>>>18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>>connection provider:
>>>org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>>18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>>TransactionManagerLookup configured (in JTA environment, use
>>>of process level read-write cache is not re
>>>commended)
>>>
>>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>continues with items below:
>>>
>>>18:55:57,984 INFO [SettingsFactory] Use scrollable result sets: true
>>>18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>>getGeneratedKeys(): false
>>>18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>>minimal puts: false
>>>18:55:57,984 INFO [SettingsFactory] Query language substitutions: {}
>>>18:55:57,984 INFO [SettingsFactory] cache provider:
>>>net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
>>>[Configuration] instantiating and configuring caches
>>>18:55:58,234 INFO [SessionFactoryImpl] building session factory
>>>18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>>factory to JNDI, no JNDI name configured
>>>18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>>shared instance of sing leton bean 'transactionManager'
>>>
>>>18:55:58,734 INFO [HibernateTransactionManager] Using
>>>DataSource [org.springfra
>>>mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>>Hibernate SessionFact ory for HibernateTransactionManager
>>>18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>>shared instance of sing leton bean 'clinic'
>>>18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>definitions from c lass path resource
>>>[org/springframework/jdbc/support/sql-error-codes.xml]
>>>18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>>of singleton bean '
>>>DB2'
>>>
>>>... and so on
>>>
>>>
>>>Can anybody else duplicate this?
>>>
>>>Colin
>>>
>>>
|
|
From: Patrick B. <pbu...@gm...> - 2004-11-13 16:15:49
|
<wishfulthinking>
Or JBoss could make their classloader behave like every other app
server without jumping through hoops.
</wishfulthinking>
I can't wait for the J2EE 1.5/5.0 spec to clarify classloader
behavior, as I understand they are going to.
Patrick
On Sat, 13 Nov 2004 10:17:46 -0500, Colin Sampaleanu <col...@ex...> wr=
ote:
> I don't have any problems either way. If switching to 1.7.2 is just a
> few tweaks to some of the saved db scripts in CVS I don't see a big
> issue with it, but whatever makes sense.
>=20
> As for JBoss, they've shipped HSQLDB all along, since their queue used
> it by default, for example. Hibernate they just added recently,
> inlcuding a deployer service which deploys it automatically. For sure
> somebody wanting to use Hibernate with JBoss needs to either take out
> the JBoss incldued one (along with the older cglib) and the deployer, or
> alternately upgrade the jars in JBoss...
>=20
>=20
>=20
> j=FCrgen h=F6ller [werk3AT] wrote:
>=20
> >I guess it's better to stick with HSQLDB 1.7.1 for the Spring 1.1.x bran=
ch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we need to point =
out that this incompatibility issue exists.
> >
> >Why does JBoss ship tons of optional third-party jars in the server lib =
directory in the first place?? Could cause issues with newer Hibernate vers=
ions used in applications too, unless the JBoss-provided jars get removed f=
rom the server lib directory...
> >
> >Juergen
> >
> >
> >________________________________
> >
> >Von: spr...@li... im Auftrag vo=
n Colin Sampaleanu
> >Gesendet: Sa 13.11.2004 15:47
> >An: spr...@li...
> >Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or Hibern=
ate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
> >
> >
> >
> >Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
> >2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is only a
> >week or so after 2.1.4 came out, and almost 2 months before 2.1.5/2.1.6
> >came out.
> >
> >But this is not Hibernate related. The hang happens with JDBC too. As I
> >mentioned in my other email, I think the problem is simply trying to mix
> >HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running, there is
> >no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
> >
> >Colin
> >
> >Alef Arendsen wrote:
> >
> >
> >
> >>Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
> >>2.0.2 I think) in its server/default/lib directory. They recently
> >>introduced Hibernate archives (HARs), maybe that's why the jars are in
> >>there. I would expect some weird classnotfoundexception because of this=
,
> >>not a server hang, but it might be related.
> >>
> >>Maybe you could try to cleanup the server/default/lib directory or
> >>create yourself a separate server config.
> >>
> >>Alef
> >>
> >>
> >>
> >>
> >>
> >>
> >>>-----Original Message-----
> >>>From: spr...@li...
> >>>[mailto:spr...@li...]
> >>>On Behalf Of Colin Sampaleanu
> >>>Sent: Saturday, November 13, 2004 1:15 AM
> >>>To: spr...@li...
> >>>Subject: [Springframework-developer] Spring + MySQL + JDBC or
> >>>Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
> >>>
> >>>I am seeing extremely strange, completely repeatable
> >>>behaviour, where Petclinc in both the JDBC and the hibernate
> >>>deployment, using HSQL, starts up ok in JBoss 3.2.5, but
> >>>hangs after a certain point in JBoss 3.2.6. The ejbtest
> >>>sample does exactly the same thing. Weird thing in
> >>>3.2.6 is that if I shut down the external HSQL db (started
> >>>with the server.bat file), then the app starts fine (getting
> >>>some obvious errors since it can't actually talk to the db,
> >>>but doesn't hang). This means the issues are somehow related
> >>>to HSQL in the 3.2.6 environment.
> >>>
> >>>Here's the sequence from the JDBC version:
> >>>
> >>>18:51:31,218 INFO [DefaultListableBeanFactory] Creating
> >>>shared instance of sing leton bean 'dataSource'
> >>>18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
> >>>driver: org.hsqldb.jdbc Driver
> >>>18:51:31,234 INFO [DefaultListableBeanFactory] Creating
> >>>shared instance of sing leton bean 'transactionManager'
> >>>18:51:31,250 INFO [DefaultListableBeanFactory] Creating
> >>>shared instance of sing leton bean 'clinic'
> >>>18:51:31,296 INFO [DefaultListableBeanFactory] Creating
> >>>shared instance of sing leton bean 'hsqlClinic'
> >>>18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
> >>>definitions from c lass path resource
> >>>[org/springframework/jdbc/support/sql-error-codes.xml]
> >>>18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
> >>>of singleton bean '
> >>>DB2'
> >>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
> >>>of singleton bean '
> >>>HSQL'
> >>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
> >>>of singleton bean '
> >>>MS-SQL'
> >>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
> >>>of singleton bean '
> >>>MySQL'
> >>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
> >>>of singleton bean '
> >>>Oracle'
> >>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
> >>>of singleton bean '
> >>>Informix'
> >>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
> >>>of singleton bean '
> >>>PostgreSQL'
> >>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
> >>>of singleton bean '
> >>>Sybase'
> >>>18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
> >>>loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
> >>>Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
> >>>MySQL, DB2*]
> >>>
> >>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
> >>>continues with items below:
> >>>
> >>>18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
> >>>RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
> >>>vets ORDER BY last_name,first_name] compiled 18:51:31,500
> >>>INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
> >>>with SQL [SELECT id,name FROM specialties] compiled
> >>>18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
> >>>RdbmsOperation with SQL [SELECT specialty_id FROM
> >>>vet_specialties WHERE vet_id=3D?] compiled
> >>>
> >>>... and so on
> >>>
> >>>The Hibernate version has this sequence:
> >>>
> >>>18:55:57,421 INFO [DefaultListableBeanFactory] Creating
> >>>shared instance of sing leton bean 'dataSource'
> >>>18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
> >>>driver: org.hsqldb.jdbc Driver
> >>>18:55:57,437 INFO [DefaultListableBeanFactory] Creating
> >>>shared instance of sing leton bean 'sessionFactory'
> >>>18:55:57,468 INFO [Environment] Hibernate 2.1.6
> >>>18:55:57,468 INFO [Environment] hibernate.properties not found
> >>>18:55:57,484 INFO [Environment] using CGLIB reflection
> >>>optimizer 18:55:57,640 INFO [Binder] Mapping class:
> >>>org.springframework.samples.petclinic
> >>>.Vet -> vets
> >>>18:55:57,812 INFO [Binder] Mapping collection:
> >>>org.springframework.samples.petc
> >>>linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
> >>>INFO [Binder] Mapping class: org.springframework.samples.petclinic
> >>>.Specialty -> specialties
> >>>18:55:57,890 INFO [Binder] Mapping class:
> >>>org.springframework.samples.petclinic
> >>>.Owner -> owners
> >>>18:55:57,906 INFO [Binder] Mapping class:
> >>>org.springframework.samples.petclinic
> >>>.Pet -> pets
> >>>18:55:57,906 INFO [Binder] Mapping class:
> >>>org.springframework.samples.petclinic
> >>>.PetType -> types
> >>>18:55:57,906 INFO [Binder] Mapping class:
> >>>org.springframework.samples.petclinic
> >>>.Visit -> visits
> >>>18:55:57,906 INFO [LocalSessionFactoryBean] Building new
> >>>Hibernate SessionFacto ry
> >>>18:55:57,906 INFO [Configuration] processing one-to-many
> >>>association mappings
> >>>18:55:57,906 INFO [Binder] Mapping collection:
> >>>org.springframework.samples.petc linic.Owner.petsInternal -> pets
> >>>18:55:57,906 INFO [Binder] Mapping collection:
> >>>org.springframework.samples.petc linic.Pet.visitsInternal -> visits
> >>>18:55:57,906 INFO [Configuration] processing one-to-one
> >>>association property re ferences
> >>>18:55:57,906 INFO [Configuration] processing foreign key constraints
> >>>18:55:57,953 INFO [Dialect] Using dialect:
> >>>net.sf.hibernate.dialect.HSQLDialect
> >>>
> >>>18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
> >>>18:55:57,968 INFO [ConnectionProviderFactory] Initializing
> >>>connection provider:
> >>>org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
> >>>18:55:57,968 INFO [TransactionManagerLookupFactory] No
> >>>TransactionManagerLookup configured (in JTA environment, use
> >>>of process level read-write cache is not re
> >>>commended)
> >>>
> >>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
> >>>continues with items below:
> >>>
> >>>18:55:57,984 INFO [SettingsFactory] Use scrollable result sets: true
> >>>18:55:57,984 INFO [SettingsFactory] Use JDBC3
> >>>getGeneratedKeys(): false
> >>>18:55:57,984 INFO [SettingsFactory] Optimize cache for
> >>>minimal puts: false
> >>>18:55:57,984 INFO [SettingsFactory] Query language substitutions: {}
> >>>18:55:57,984 INFO [SettingsFactory] cache provider:
> >>>net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
> >>>[Configuration] instantiating and configuring caches
> >>>18:55:58,234 INFO [SessionFactoryImpl] building session factory
> >>>18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
> >>>factory to JNDI, no JNDI name configured
> >>>18:55:58,671 INFO [DefaultListableBeanFactory] Creating
> >>>shared instance of sing leton bean 'transactionManager'
> >>>
> >>>18:55:58,734 INFO [HibernateTransactionManager] Using
> >>>DataSource [org.springfra
> >>>mework.jdbc.datasource.DriverManagerDataSource@139491b] of
> >>>Hibernate SessionFact ory for HibernateTransactionManager
> >>>18:55:58,734 INFO [DefaultListableBeanFactory] Creating
> >>>shared instance of sing leton bean 'clinic'
> >>>18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
> >>>definitions from c lass path resource
> >>>[org/springframework/jdbc/support/sql-error-codes.xml]
> >>>18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
> >>>of singleton bean '
> >>>DB2'
> >>>
> >>>... and so on
> >>>
> >>>
> >>>Can anybody else duplicate this?
> >>>
> >>>Colin
> >>>
> >>>
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
|
|
From: Thomas R. <tho...@tr...> - 2004-11-13 16:42:51
|
I just changed the db scripts for HSQLDB - changed INT(4) to INTEGER and
rebuilt the database. Using the 1.7.2 jar files both for running the
HSQLDB server and deploying to JBoss 3.2.6 worked fine - I was able to
look up Basil and other pets.
I'll do some more testing today to see if the new scripts and db are
interchangeable between 1.7.1 and 1.7.2 - that way we could update the
scripts and rebuild the db to be shipped with our next release. This
would make it easier for JBoss 3.2.6 deployment since all you would have
to do is replace our hsqldb.jar with the one from the JBoss distribution.
Thomas
Colin Sampaleanu wrote:
> I don't have any problems either way. If switching to 1.7.2 is just a
> few tweaks to some of the saved db scripts in CVS I don't see a big
> issue with it, but whatever makes sense.
>
> As for JBoss, they've shipped HSQLDB all along, since their queue used
> it by default, for example. Hibernate they just added recently,
> inlcuding a deployer service which deploys it automatically. For sure
> somebody wanting to use Hibernate with JBoss needs to either take out
> the JBoss incldued one (along with the older cglib) and the deployer,
> or alternately upgrade the jars in JBoss...
>
> jürgen höller [werk3AT] wrote:
>
>> I guess it's better to stick with HSQLDB 1.7.1 for the Spring 1.1.x
>> branch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we need
>> to point out that this incompatibility issue exists.
>>
>> Why does JBoss ship tons of optional third-party jars in the server
>> lib directory in the first place?? Could cause issues with newer
>> Hibernate versions used in applications too, unless the
>> JBoss-provided jars get removed from the server lib directory...
>>
>> Juergen
>>
>>
>> ________________________________
>>
>> Von: spr...@li... im Auftrag
>> von Colin Sampaleanu
>> Gesendet: Sa 13.11.2004 15:47
>> An: spr...@li...
>> Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>
>>
>>
>> Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
>> 2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is only a
>> week or so after 2.1.4 came out, and almost 2 months before 2.1.5/2.1.6
>> came out.
>>
>> But this is not Hibernate related. The hang happens with JDBC too. As I
>> mentioned in my other email, I think the problem is simply trying to mix
>> HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running, there is
>> no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
>>
>> Colin
>>
>> Alef Arendsen wrote:
>>
>>
>>
>>> Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
>>> 2.0.2 I think) in its server/default/lib directory. They recently
>>> introduced Hibernate archives (HARs), maybe that's why the jars are in
>>> there. I would expect some weird classnotfoundexception because of
>>> this,
>>> not a server hang, but it might be related.
>>>
>>> Maybe you could try to cleanup the server/default/lib directory or
>>> create yourself a separate server config.
>>>
>>> Alef
>>>
>>>
>>>
>>>
>>>
>>>
>>>> -----Original Message-----
>>>> From: spr...@li...
>>>> [mailto:spr...@li...]
>>>> On Behalf Of Colin Sampaleanu
>>>> Sent: Saturday, November 13, 2004 1:15 AM
>>>> To: spr...@li...
>>>> Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>
>>>> I am seeing extremely strange, completely repeatable
>>>> behaviour, where Petclinc in both the JDBC and the hibernate
>>>> deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>>> hangs after a certain point in JBoss 3.2.6. The ejbtest
>>>> sample does exactly the same thing. Weird thing in
>>>> 3.2.6 is that if I shut down the external HSQL db (started
>>>> with the server.bat file), then the app starts fine (getting
>>>> some obvious errors since it can't actually talk to the db,
>>>> but doesn't hang). This means the issues are somehow related
>>>> to HSQL in the 3.2.6 environment.
>>>>
>>>> Here's the sequence from the JDBC version:
>>>>
>>>> 18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>>> shared instance of sing leton bean 'dataSource'
>>>> 18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>>> driver: org.hsqldb.jdbc Driver
>>>> 18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>>> shared instance of sing leton bean 'transactionManager'
>>>> 18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>>> shared instance of sing leton bean 'clinic'
>>>> 18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>>> shared instance of sing leton bean 'hsqlClinic'
>>>> 18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>> definitions from c lass path resource
>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>> 18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>>> of singleton bean '
>>>> DB2'
>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>> of singleton bean '
>>>> HSQL'
>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>> of singleton bean '
>>>> MS-SQL'
>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>> of singleton bean '
>>>> MySQL'
>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>> of singleton bean '
>>>> Oracle'
>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>> of singleton bean '
>>>> Informix'
>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>> of singleton bean '
>>>> PostgreSQL'
>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>> of singleton bean '
>>>> Sybase'
>>>> 18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>>> loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>>> Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>>> MySQL, DB2*]
>>>>
>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>> continues with items below:
>>>>
>>>> 18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>>> RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>>> vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>>> INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>>> with SQL [SELECT id,name FROM specialties] compiled
>>>> 18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>>> RdbmsOperation with SQL [SELECT specialty_id FROM
>>>> vet_specialties WHERE vet_id=?] compiled
>>>>
>>>> ... and so on
>>>>
>>>> The Hibernate version has this sequence:
>>>>
>>>> 18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>>> shared instance of sing leton bean 'dataSource'
>>>> 18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>>> driver: org.hsqldb.jdbc Driver
>>>> 18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>>> shared instance of sing leton bean 'sessionFactory'
>>>> 18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>>> 18:55:57,468 INFO [Environment] hibernate.properties not found
>>>> 18:55:57,484 INFO [Environment] using CGLIB reflection
>>>> optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>>> org.springframework.samples.petclinic
>>>> .Vet -> vets
>>>> 18:55:57,812 INFO [Binder] Mapping collection:
>>>> org.springframework.samples.petc
>>>> linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>>> INFO [Binder] Mapping class: org.springframework.samples.petclinic
>>>> .Specialty -> specialties
>>>> 18:55:57,890 INFO [Binder] Mapping class:
>>>> org.springframework.samples.petclinic
>>>> .Owner -> owners
>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>> org.springframework.samples.petclinic
>>>> .Pet -> pets
>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>> org.springframework.samples.petclinic
>>>> .PetType -> types
>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>> org.springframework.samples.petclinic
>>>> .Visit -> visits
>>>> 18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>>> Hibernate SessionFacto ry
>>>> 18:55:57,906 INFO [Configuration] processing one-to-many
>>>> association mappings
>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>> org.springframework.samples.petc linic.Owner.petsInternal -> pets
>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>> org.springframework.samples.petc linic.Pet.visitsInternal -> visits
>>>> 18:55:57,906 INFO [Configuration] processing one-to-one
>>>> association property re ferences
>>>> 18:55:57,906 INFO [Configuration] processing foreign key constraints
>>>> 18:55:57,953 INFO [Dialect] Using dialect:
>>>> net.sf.hibernate.dialect.HSQLDialect
>>>>
>>>> 18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
>>>> 18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>>> connection provider:
>>>> org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>>> 18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>>> TransactionManagerLookup configured (in JTA environment, use
>>>> of process level read-write cache is not re
>>>> commended)
>>>>
>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>> continues with items below:
>>>>
>>>> 18:55:57,984 INFO [SettingsFactory] Use scrollable result sets: true
>>>> 18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>>> getGeneratedKeys(): false
>>>> 18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>>> minimal puts: false
>>>> 18:55:57,984 INFO [SettingsFactory] Query language substitutions: {}
>>>> 18:55:57,984 INFO [SettingsFactory] cache provider:
>>>> net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
>>>> [Configuration] instantiating and configuring caches
>>>> 18:55:58,234 INFO [SessionFactoryImpl] building session factory
>>>> 18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>>> factory to JNDI, no JNDI name configured
>>>> 18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>>> shared instance of sing leton bean 'transactionManager'
>>>>
>>>> 18:55:58,734 INFO [HibernateTransactionManager] Using
>>>> DataSource [org.springfra
>>>> mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>>> Hibernate SessionFact ory for HibernateTransactionManager
>>>> 18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>>> shared instance of sing leton bean 'clinic'
>>>> 18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>> definitions from c lass path resource
>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>> 18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>>> of singleton bean '
>>>> DB2'
>>>>
>>>> ... and so on
>>>>
>>>>
>>>> Can anybody else duplicate this?
>>>>
>>>> Colin
>>>>
>>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
|
|
From: Colin S. <col...@ex...> - 2004-11-13 18:01:47
|
That's great. If it's really that minor, I would vote to just switch
ourselves to 1.7.2, instead of keeping 1.7.1 and only upgrading the
scripts to work with both versions.
Thomas Risberg wrote:
> I just changed the db scripts for HSQLDB - changed INT(4) to INTEGER
> and rebuilt the database. Using the 1.7.2 jar files both for running
> the HSQLDB server and deploying to JBoss 3.2.6 worked fine - I was
> able to look up Basil and other pets.
>
> I'll do some more testing today to see if the new scripts and db are
> interchangeable between 1.7.1 and 1.7.2 - that way we could update the
> scripts and rebuild the db to be shipped with our next release. This
> would make it easier for JBoss 3.2.6 deployment since all you would
> have to do is replace our hsqldb.jar with the one from the JBoss
> distribution.
>
> Thomas
>
>
> Colin Sampaleanu wrote:
>
>> I don't have any problems either way. If switching to 1.7.2 is just a
>> few tweaks to some of the saved db scripts in CVS I don't see a big
>> issue with it, but whatever makes sense.
>>
>> As for JBoss, they've shipped HSQLDB all along, since their queue
>> used it by default, for example. Hibernate they just added recently,
>> inlcuding a deployer service which deploys it automatically. For sure
>> somebody wanting to use Hibernate with JBoss needs to either take out
>> the JBoss incldued one (along with the older cglib) and the deployer,
>> or alternately upgrade the jars in JBoss...
>>
>> jürgen höller [werk3AT] wrote:
>>
>>> I guess it's better to stick with HSQLDB 1.7.1 for the Spring 1.1.x
>>> branch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we
>>> need to point out that this incompatibility issue exists.
>>>
>>> Why does JBoss ship tons of optional third-party jars in the server
>>> lib directory in the first place?? Could cause issues with newer
>>> Hibernate versions used in applications too, unless the
>>> JBoss-provided jars get removed from the server lib directory...
>>>
>>> Juergen
>>>
>>>
>>> ________________________________
>>>
>>> Von: spr...@li... im
>>> Auftrag von Colin Sampaleanu
>>> Gesendet: Sa 13.11.2004 15:47
>>> An: spr...@li...
>>> Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>
>>>
>>>
>>> Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
>>> 2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is only a
>>> week or so after 2.1.4 came out, and almost 2 months before 2.1.5/2.1.6
>>> came out.
>>>
>>> But this is not Hibernate related. The hang happens with JDBC too. As I
>>> mentioned in my other email, I think the problem is simply trying to
>>> mix
>>> HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running, there is
>>> no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
>>>
>>> Colin
>>>
>>> Alef Arendsen wrote:
>>>
>>>
>>>
>>>> Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
>>>> 2.0.2 I think) in its server/default/lib directory. They recently
>>>> introduced Hibernate archives (HARs), maybe that's why the jars are in
>>>> there. I would expect some weird classnotfoundexception because of
>>>> this,
>>>> not a server hang, but it might be related.
>>>>
>>>> Maybe you could try to cleanup the server/default/lib directory or
>>>> create yourself a separate server config.
>>>>
>>>> Alef
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> -----Original Message-----
>>>>> From: spr...@li...
>>>>> [mailto:spr...@li...]
>>>>> On Behalf Of Colin Sampaleanu
>>>>> Sent: Saturday, November 13, 2004 1:15 AM
>>>>> To: spr...@li...
>>>>> Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>
>>>>> I am seeing extremely strange, completely repeatable
>>>>> behaviour, where Petclinc in both the JDBC and the hibernate
>>>>> deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>>>> hangs after a certain point in JBoss 3.2.6. The ejbtest
>>>>> sample does exactly the same thing. Weird thing in
>>>>> 3.2.6 is that if I shut down the external HSQL db (started
>>>>> with the server.bat file), then the app starts fine (getting
>>>>> some obvious errors since it can't actually talk to the db,
>>>>> but doesn't hang). This means the issues are somehow related
>>>>> to HSQL in the 3.2.6 environment.
>>>>>
>>>>> Here's the sequence from the JDBC version:
>>>>>
>>>>> 18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'dataSource'
>>>>> 18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>>>> driver: org.hsqldb.jdbc Driver
>>>>> 18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'transactionManager'
>>>>> 18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'clinic'
>>>>> 18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'hsqlClinic'
>>>>> 18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>> definitions from c lass path resource
>>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>>> 18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> DB2'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> HSQL'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> MS-SQL'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> MySQL'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> Oracle'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> Informix'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> PostgreSQL'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> Sybase'
>>>>> 18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>>>> loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>>>> Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>>>> MySQL, DB2*]
>>>>>
>>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>> continues with items below:
>>>>>
>>>>> 18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>>>> RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>>>> vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>>>> INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>>>> with SQL [SELECT id,name FROM specialties] compiled
>>>>> 18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>>>> RdbmsOperation with SQL [SELECT specialty_id FROM
>>>>> vet_specialties WHERE vet_id=?] compiled
>>>>>
>>>>> ... and so on
>>>>>
>>>>> The Hibernate version has this sequence:
>>>>>
>>>>> 18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'dataSource'
>>>>> 18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>>>> driver: org.hsqldb.jdbc Driver
>>>>> 18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'sessionFactory'
>>>>> 18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>>>> 18:55:57,468 INFO [Environment] hibernate.properties not found
>>>>> 18:55:57,484 INFO [Environment] using CGLIB reflection
>>>>> optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>>>> org.springframework.samples.petclinic
>>>>> .Vet -> vets
>>>>> 18:55:57,812 INFO [Binder] Mapping collection:
>>>>> org.springframework.samples.petc
>>>>> linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>>>> INFO [Binder] Mapping class: org.springframework.samples.petclinic
>>>>> .Specialty -> specialties
>>>>> 18:55:57,890 INFO [Binder] Mapping class:
>>>>> org.springframework.samples.petclinic
>>>>> .Owner -> owners
>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>> org.springframework.samples.petclinic
>>>>> .Pet -> pets
>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>> org.springframework.samples.petclinic
>>>>> .PetType -> types
>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>> org.springframework.samples.petclinic
>>>>> .Visit -> visits
>>>>> 18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>>>> Hibernate SessionFacto ry
>>>>> 18:55:57,906 INFO [Configuration] processing one-to-many
>>>>> association mappings
>>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>>> org.springframework.samples.petc linic.Owner.petsInternal -> pets
>>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>>> org.springframework.samples.petc linic.Pet.visitsInternal -> visits
>>>>> 18:55:57,906 INFO [Configuration] processing one-to-one
>>>>> association property re ferences
>>>>> 18:55:57,906 INFO [Configuration] processing foreign key constraints
>>>>> 18:55:57,953 INFO [Dialect] Using dialect:
>>>>> net.sf.hibernate.dialect.HSQLDialect
>>>>>
>>>>> 18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
>>>>> 18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>>>> connection provider:
>>>>> org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>>>> 18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>>>> TransactionManagerLookup configured (in JTA environment, use
>>>>> of process level read-write cache is not re
>>>>> commended)
>>>>>
>>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>> continues with items below:
>>>>>
>>>>> 18:55:57,984 INFO [SettingsFactory] Use scrollable result sets: true
>>>>> 18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>>>> getGeneratedKeys(): false
>>>>> 18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>>>> minimal puts: false
>>>>> 18:55:57,984 INFO [SettingsFactory] Query language substitutions: {}
>>>>> 18:55:57,984 INFO [SettingsFactory] cache provider:
>>>>> net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
>>>>> [Configuration] instantiating and configuring caches
>>>>> 18:55:58,234 INFO [SessionFactoryImpl] building session factory
>>>>> 18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>>>> factory to JNDI, no JNDI name configured
>>>>> 18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'transactionManager'
>>>>>
>>>>> 18:55:58,734 INFO [HibernateTransactionManager] Using
>>>>> DataSource [org.springfra
>>>>> mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>>>> Hibernate SessionFact ory for HibernateTransactionManager
>>>>> 18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'clinic'
>>>>> 18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>> definitions from c lass path resource
>>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>>> 18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> DB2'
>>>>>
>>>>> ... and so on
>>>>>
>>>>>
>>>>> Can anybody else duplicate this?
>>>>>
>>>>> Colin
>>>>>
>>>>
>>>>
|
|
From: <jue...@we...> - 2004-11-13 18:06:13
|
I wouldn't mind updating to HSQLDB 1.7.2 either, as long as the sample =
applications continue to work properly. However, we need to hurry a bit =
here: Let's clarify this till tomorrow late afternoon, so that I will =
still have enough time for the actual Spring 1.1.2 release tomorrow =
night.
=20
Juergen
=20
________________________________
Von: spr...@li... im Auftrag =
von Colin Sampaleanu
Gesendet: Sa 13.11.2004 19:01
An: spr...@li...
Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or =
Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
That's great. If it's really that minor, I would vote to just switch
ourselves to 1.7.2, instead of keeping 1.7.1 and only upgrading the
scripts to work with both versions.
Thomas Risberg wrote:
> I just changed the db scripts for HSQLDB - changed INT(4) to INTEGER
> and rebuilt the database. Using the 1.7.2 jar files both for running
> the HSQLDB server and deploying to JBoss 3.2.6 worked fine - I was
> able to look up Basil and other pets.
>
> I'll do some more testing today to see if the new scripts and db are
> interchangeable between 1.7.1 and 1.7.2 - that way we could update the
> scripts and rebuild the db to be shipped with our next release. This
> would make it easier for JBoss 3.2.6 deployment since all you would
> have to do is replace our hsqldb.jar with the one from the JBoss
> distribution.
>
> Thomas
>
>
> Colin Sampaleanu wrote:
>
>> I don't have any problems either way. If switching to 1.7.2 is just a
>> few tweaks to some of the saved db scripts in CVS I don't see a big
>> issue with it, but whatever makes sense.
>>
>> As for JBoss, they've shipped HSQLDB all along, since their queue
>> used it by default, for example. Hibernate they just added recently,
>> inlcuding a deployer service which deploys it automatically. For sure
>> somebody wanting to use Hibernate with JBoss needs to either take out
>> the JBoss incldued one (along with the older cglib) and the deployer,
>> or alternately upgrade the jars in JBoss...
>>
>> j=FCrgen h=F6ller [werk3AT] wrote:
>>
>>> I guess it's better to stick with HSQLDB 1.7.1 for the Spring 1.1.x
>>> branch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we
>>> need to point out that this incompatibility issue exists.
>>>
>>> Why does JBoss ship tons of optional third-party jars in the server
>>> lib directory in the first place?? Could cause issues with newer
>>> Hibernate versions used in applications too, unless the
>>> JBoss-provided jars get removed from the server lib directory...
>>>
>>> Juergen
>>>
>>>
>>> ________________________________
>>>
>>> Von: spr...@li... im
>>> Auftrag von Colin Sampaleanu
>>> Gesendet: Sa 13.11.2004 15:47
>>> An: spr...@li...
>>> Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>
>>>
>>>
>>> Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
>>> 2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is only =
a
>>> week or so after 2.1.4 came out, and almost 2 months before =
2.1.5/2.1.6
>>> came out.
>>>
>>> But this is not Hibernate related. The hang happens with JDBC too. =
As I
>>> mentioned in my other email, I think the problem is simply trying to
>>> mix
>>> HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running, there =
is
>>> no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
>>>
>>> Colin
>>>
>>> Alef Arendsen wrote:
>>>
>>>=20
>>>
>>>> Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
>>>> 2.0.2 I think) in its server/default/lib directory. They recently
>>>> introduced Hibernate archives (HARs), maybe that's why the jars are =
in
>>>> there. I would expect some weird classnotfoundexception because of
>>>> this,
>>>> not a server hang, but it might be related.
>>>>
>>>> Maybe you could try to cleanup the server/default/lib directory or
>>>> create yourself a separate server config.
>>>>
>>>> Alef
>>>>
>>>>
>>>>
>>>>
>>>>=20
>>>>
>>>>> -----Original Message-----
>>>>> From: spr...@li...
>>>>> [mailto:spr...@li...]
>>>>> On Behalf Of Colin Sampaleanu
>>>>> Sent: Saturday, November 13, 2004 1:15 AM
>>>>> To: spr...@li...
>>>>> Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>
>>>>> I am seeing extremely strange, completely repeatable
>>>>> behaviour, where Petclinc in both the JDBC and the hibernate
>>>>> deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>>>> hangs after a certain point in JBoss 3.2.6. The ejbtest
>>>>> sample does exactly the same thing. Weird thing in
>>>>> 3.2.6 is that if I shut down the external HSQL db (started
>>>>> with the server.bat file), then the app starts fine (getting
>>>>> some obvious errors since it can't actually talk to the db,
>>>>> but doesn't hang). This means the issues are somehow related
>>>>> to HSQL in the 3.2.6 environment.
>>>>>
>>>>> Here's the sequence from the JDBC version:
>>>>>
>>>>> 18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'dataSource'
>>>>> 18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>>>> driver: org.hsqldb.jdbc Driver
>>>>> 18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'transactionManager'
>>>>> 18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'clinic'
>>>>> 18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'hsqlClinic'
>>>>> 18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>> definitions from c lass path resource
>>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>>> 18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> DB2'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> HSQL'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> MS-SQL'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> MySQL'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> Oracle'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> Informix'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> PostgreSQL'
>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> Sybase'
>>>>> 18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>>>> loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>>>> Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>>>> MySQL, DB2*]
>>>>>
>>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>> continues with items below:
>>>>>
>>>>> 18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>>>> RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>>>> vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>>>> INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>>>> with SQL [SELECT id,name FROM specialties] compiled
>>>>> 18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>>>> RdbmsOperation with SQL [SELECT specialty_id FROM
>>>>> vet_specialties WHERE vet_id=3D?] compiled
>>>>>
>>>>> ... and so on
>>>>>
>>>>> The Hibernate version has this sequence:
>>>>>
>>>>> 18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'dataSource'
>>>>> 18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>>>> driver: org.hsqldb.jdbc Driver
>>>>> 18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'sessionFactory'
>>>>> 18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>>>> 18:55:57,468 INFO [Environment] hibernate.properties not found
>>>>> 18:55:57,484 INFO [Environment] using CGLIB reflection
>>>>> optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>>>> org.springframework.samples.petclinic
>>>>> .Vet -> vets
>>>>> 18:55:57,812 INFO [Binder] Mapping collection:
>>>>> org.springframework.samples.petc
>>>>> linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>>>> INFO [Binder] Mapping class: =
org.springframework.samples.petclinic
>>>>> .Specialty -> specialties
>>>>> 18:55:57,890 INFO [Binder] Mapping class:
>>>>> org.springframework.samples.petclinic
>>>>> .Owner -> owners
>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>> org.springframework.samples.petclinic
>>>>> .Pet -> pets
>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>> org.springframework.samples.petclinic
>>>>> .PetType -> types
>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>> org.springframework.samples.petclinic
>>>>> .Visit -> visits
>>>>> 18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>>>> Hibernate SessionFacto ry
>>>>> 18:55:57,906 INFO [Configuration] processing one-to-many
>>>>> association mappings
>>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>>> org.springframework.samples.petc linic.Owner.petsInternal -> pets
>>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>>> org.springframework.samples.petc linic.Pet.visitsInternal -> =
visits
>>>>> 18:55:57,906 INFO [Configuration] processing one-to-one
>>>>> association property re ferences
>>>>> 18:55:57,906 INFO [Configuration] processing foreign key =
constraints
>>>>> 18:55:57,953 INFO [Dialect] Using dialect:
>>>>> net.sf.hibernate.dialect.HSQLDialect
>>>>>
>>>>> 18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
>>>>> 18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>>>> connection provider:
>>>>> =
org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>>>> 18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>>>> TransactionManagerLookup configured (in JTA environment, use
>>>>> of process level read-write cache is not re
>>>>> commended)
>>>>>
>>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>> continues with items below:
>>>>>
>>>>> 18:55:57,984 INFO [SettingsFactory] Use scrollable result sets: =
true
>>>>> 18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>>>> getGeneratedKeys(): false
>>>>> 18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>>>> minimal puts: false
>>>>> 18:55:57,984 INFO [SettingsFactory] Query language substitutions: =
{}
>>>>> 18:55:57,984 INFO [SettingsFactory] cache provider:
>>>>> net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
>>>>> [Configuration] instantiating and configuring caches
>>>>> 18:55:58,234 INFO [SessionFactoryImpl] building session factory
>>>>> 18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>>>> factory to JNDI, no JNDI name configured
>>>>> 18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'transactionManager'
>>>>>
>>>>> 18:55:58,734 INFO [HibernateTransactionManager] Using
>>>>> DataSource [org.springfra
>>>>> mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>>>> Hibernate SessionFact ory for HibernateTransactionManager
>>>>> 18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>>>> shared instance of sing leton bean 'clinic'
>>>>> 18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>> definitions from c lass path resource
>>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>>> 18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>>>> of singleton bean '
>>>>> DB2'
>>>>>
>>>>> ... and so on
>>>>>
>>>>>
>>>>> Can anybody else duplicate this?
>>>>>
>>>>> Colin
>>>>> =20
>>>>
>>>>
-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
_______________________________________________
Springframework-developer mailing list
Spr...@li...
https://lists.sourceforge.net/lists/listinfo/springframework-developer
|
|
From: Thomas R. <tho...@tr...> - 2004-11-13 18:51:36
|
There are three steps we have to take:
1. Modify scripts to create tables to use INTEGER instead of INT(4)
2. Build a new petclinic database (petclinic.script +
petclinic.properties) and issue a SHUTDOWN COMPACT to provide
compatibility with 1.7.2
3. Upgrade Spring to use HSQLDB 1.7.2 instead of 1.7.1
I think 1 and 2 should be done before 1.1.2 release. We should wait with
3 to give more time for testing and to announce it to our user
community. If we upgrade now we could break existing apps using HSQLDB
since databases from 1.7.1 aren't compatible with 1.7.2. Even if Spring
works properly with 1.7.2 we could affect already running Spring
applications.
I can make changes 1 and 2 today and I have already tested part of the
Petclinic functionality. Everything works as long as the HSQLDB version
in the war file is the same as the one running the server.
Thomas
jürgen höller [werk3AT] wrote:
>I wouldn't mind updating to HSQLDB 1.7.2 either, as long as the sample applications continue to work properly. However, we need to hurry a bit here: Let's clarify this till tomorrow late afternoon, so that I will still have enough time for the actual Spring 1.1.2 release tomorrow night.
>
>Juergen
>
>
>________________________________
>
>Von: spr...@li... im Auftrag von Colin Sampaleanu
>Gesendet: Sa 13.11.2004 19:01
>An: spr...@li...
>Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>
>
>
>That's great. If it's really that minor, I would vote to just switch
>ourselves to 1.7.2, instead of keeping 1.7.1 and only upgrading the
>scripts to work with both versions.
>
>Thomas Risberg wrote:
>
>
>
>>I just changed the db scripts for HSQLDB - changed INT(4) to INTEGER
>>and rebuilt the database. Using the 1.7.2 jar files both for running
>>the HSQLDB server and deploying to JBoss 3.2.6 worked fine - I was
>>able to look up Basil and other pets.
>>
>>I'll do some more testing today to see if the new scripts and db are
>>interchangeable between 1.7.1 and 1.7.2 - that way we could update the
>>scripts and rebuild the db to be shipped with our next release. This
>>would make it easier for JBoss 3.2.6 deployment since all you would
>>have to do is replace our hsqldb.jar with the one from the JBoss
>>distribution.
>>
>>Thomas
>>
>>
>>Colin Sampaleanu wrote:
>>
>>
>>
>>>I don't have any problems either way. If switching to 1.7.2 is just a
>>>few tweaks to some of the saved db scripts in CVS I don't see a big
>>>issue with it, but whatever makes sense.
>>>
>>>As for JBoss, they've shipped HSQLDB all along, since their queue
>>>used it by default, for example. Hibernate they just added recently,
>>>inlcuding a deployer service which deploys it automatically. For sure
>>>somebody wanting to use Hibernate with JBoss needs to either take out
>>>the JBoss incldued one (along with the older cglib) and the deployer,
>>>or alternately upgrade the jars in JBoss...
>>>
>>>jürgen höller [werk3AT] wrote:
>>>
>>>
>>>
>>>>I guess it's better to stick with HSQLDB 1.7.1 for the Spring 1.1.x
>>>>branch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we
>>>>need to point out that this incompatibility issue exists.
>>>>
>>>>Why does JBoss ship tons of optional third-party jars in the server
>>>>lib directory in the first place?? Could cause issues with newer
>>>>Hibernate versions used in applications too, unless the
>>>>JBoss-provided jars get removed from the server lib directory...
>>>>
>>>>Juergen
>>>>
>>>>
>>>>________________________________
>>>>
>>>>Von: spr...@li... im
>>>>Auftrag von Colin Sampaleanu
>>>>Gesendet: Sa 13.11.2004 15:47
>>>>An: spr...@li...
>>>>Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>>>>Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>
>>>>
>>>>
>>>>Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
>>>>2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is only a
>>>>week or so after 2.1.4 came out, and almost 2 months before 2.1.5/2.1.6
>>>>came out.
>>>>
>>>>But this is not Hibernate related. The hang happens with JDBC too. As I
>>>>mentioned in my other email, I think the problem is simply trying to
>>>>mix
>>>>HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running, there is
>>>>no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
>>>>
>>>>Colin
>>>>
>>>>Alef Arendsen wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
>>>>>2.0.2 I think) in its server/default/lib directory. They recently
>>>>>introduced Hibernate archives (HARs), maybe that's why the jars are in
>>>>>there. I would expect some weird classnotfoundexception because of
>>>>>this,
>>>>>not a server hang, but it might be related.
>>>>>
>>>>>Maybe you could try to cleanup the server/default/lib directory or
>>>>>create yourself a separate server config.
>>>>>
>>>>>Alef
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>-----Original Message-----
>>>>>>From: spr...@li...
>>>>>>[mailto:spr...@li...]
>>>>>>On Behalf Of Colin Sampaleanu
>>>>>>Sent: Saturday, November 13, 2004 1:15 AM
>>>>>>To: spr...@li...
>>>>>>Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>>>>>Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>>
>>>>>>I am seeing extremely strange, completely repeatable
>>>>>>behaviour, where Petclinc in both the JDBC and the hibernate
>>>>>>deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>>>>>hangs after a certain point in JBoss 3.2.6. The ejbtest
>>>>>>sample does exactly the same thing. Weird thing in
>>>>>>3.2.6 is that if I shut down the external HSQL db (started
>>>>>>with the server.bat file), then the app starts fine (getting
>>>>>>some obvious errors since it can't actually talk to the db,
>>>>>>but doesn't hang). This means the issues are somehow related
>>>>>>to HSQL in the 3.2.6 environment.
>>>>>>
>>>>>>Here's the sequence from the JDBC version:
>>>>>>
>>>>>>18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>>>>>shared instance of sing leton bean 'dataSource'
>>>>>>18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>>>>>driver: org.hsqldb.jdbc Driver
>>>>>>18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>>>>>shared instance of sing leton bean 'transactionManager'
>>>>>>18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>>>>>shared instance of sing leton bean 'clinic'
>>>>>>18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>>>>>shared instance of sing leton bean 'hsqlClinic'
>>>>>>18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>>>definitions from c lass path resource
>>>>>>[org/springframework/jdbc/support/sql-error-codes.xml]
>>>>>>18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>>>>>of singleton bean '
>>>>>>DB2'
>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>of singleton bean '
>>>>>>HSQL'
>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>of singleton bean '
>>>>>>MS-SQL'
>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>of singleton bean '
>>>>>>MySQL'
>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>of singleton bean '
>>>>>>Oracle'
>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>of singleton bean '
>>>>>>Informix'
>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>of singleton bean '
>>>>>>PostgreSQL'
>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>of singleton bean '
>>>>>>Sybase'
>>>>>>18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>>>>>loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>>>>>Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>>>>>MySQL, DB2*]
>>>>>>
>>>>>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>>>continues with items below:
>>>>>>
>>>>>>18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>>>>>RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>>>>>vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>>>>>INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>>>>>with SQL [SELECT id,name FROM specialties] compiled
>>>>>>18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>>>>>RdbmsOperation with SQL [SELECT specialty_id FROM
>>>>>>vet_specialties WHERE vet_id=?] compiled
>>>>>>
>>>>>>... and so on
>>>>>>
>>>>>>The Hibernate version has this sequence:
>>>>>>
>>>>>>18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>>>>>shared instance of sing leton bean 'dataSource'
>>>>>>18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>>>>>driver: org.hsqldb.jdbc Driver
>>>>>>18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>>>>>shared instance of sing leton bean 'sessionFactory'
>>>>>>18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>>>>>18:55:57,468 INFO [Environment] hibernate.properties not found
>>>>>>18:55:57,484 INFO [Environment] using CGLIB reflection
>>>>>>optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>>>>>org.springframework.samples.petclinic
>>>>>>.Vet -> vets
>>>>>>18:55:57,812 INFO [Binder] Mapping collection:
>>>>>>org.springframework.samples.petc
>>>>>>linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>>>>>INFO [Binder] Mapping class: org.springframework.samples.petclinic
>>>>>>.Specialty -> specialties
>>>>>>18:55:57,890 INFO [Binder] Mapping class:
>>>>>>org.springframework.samples.petclinic
>>>>>>.Owner -> owners
>>>>>>18:55:57,906 INFO [Binder] Mapping class:
>>>>>>org.springframework.samples.petclinic
>>>>>>.Pet -> pets
>>>>>>18:55:57,906 INFO [Binder] Mapping class:
>>>>>>org.springframework.samples.petclinic
>>>>>>.PetType -> types
>>>>>>18:55:57,906 INFO [Binder] Mapping class:
>>>>>>org.springframework.samples.petclinic
>>>>>>.Visit -> visits
>>>>>>18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>>>>>Hibernate SessionFacto ry
>>>>>>18:55:57,906 INFO [Configuration] processing one-to-many
>>>>>>association mappings
>>>>>>18:55:57,906 INFO [Binder] Mapping collection:
>>>>>>org.springframework.samples.petc linic.Owner.petsInternal -> pets
>>>>>>18:55:57,906 INFO [Binder] Mapping collection:
>>>>>>org.springframework.samples.petc linic.Pet.visitsInternal -> visits
>>>>>>18:55:57,906 INFO [Configuration] processing one-to-one
>>>>>>association property re ferences
>>>>>>18:55:57,906 INFO [Configuration] processing foreign key constraints
>>>>>>18:55:57,953 INFO [Dialect] Using dialect:
>>>>>>net.sf.hibernate.dialect.HSQLDialect
>>>>>>
>>>>>>18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
>>>>>>18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>>>>>connection provider:
>>>>>>org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>>>>>18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>>>>>TransactionManagerLookup configured (in JTA environment, use
>>>>>>of process level read-write cache is not re
>>>>>>commended)
>>>>>>
>>>>>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>>>continues with items below:
>>>>>>
>>>>>>18:55:57,984 INFO [SettingsFactory] Use scrollable result sets: true
>>>>>>18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>>>>>getGeneratedKeys(): false
>>>>>>18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>>>>>minimal puts: false
>>>>>>18:55:57,984 INFO [SettingsFactory] Query language substitutions: {}
>>>>>>18:55:57,984 INFO [SettingsFactory] cache provider:
>>>>>>net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
>>>>>>[Configuration] instantiating and configuring caches
>>>>>>18:55:58,234 INFO [SessionFactoryImpl] building session factory
>>>>>>18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>>>>>factory to JNDI, no JNDI name configured
>>>>>>18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>>>>>shared instance of sing leton bean 'transactionManager'
>>>>>>
>>>>>>18:55:58,734 INFO [HibernateTransactionManager] Using
>>>>>>DataSource [org.springfra
>>>>>>mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>>>>>Hibernate SessionFact ory for HibernateTransactionManager
>>>>>>18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>>>>>shared instance of sing leton bean 'clinic'
>>>>>>18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>>>definitions from c lass path resource
>>>>>>[org/springframework/jdbc/support/sql-error-codes.xml]
>>>>>>18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>>>>>of singleton bean '
>>>>>>DB2'
>>>>>>
>>>>>>... and so on
>>>>>>
>>>>>>
>>>>>>Can anybody else duplicate this?
>>>>>>
>>>>>>Colin
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: InterSystems CACHE
>FREE OODBMS DOWNLOAD - A multidimensional database that combines
>robust object and relational technologies, making it a perfect match
>for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>_______________________________________________
>Springframework-developer mailing list
>Spr...@li...
>https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: InterSystems CACHE
>FREE OODBMS DOWNLOAD - A multidimensional database that combines
>robust object and relational technologies, making it a perfect match
>for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>_______________________________________________
>Springframework-developer mailing list
>Spr...@li...
>https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
>
>
|
|
From: Thomas R. <tho...@tr...> - 2004-11-13 21:01:41
|
I have checked in the first two changes - petclinic db scripts now use
INTEGER instead of INT(4) and I built new petclinic and jpetstore
databases using SHUTDOWN COMPACT to provide better compatibility with
1.7.2.
Deployed to JBoss 3.2.5 using 1.7.1 for the server and everything worked
fine.
Deployed to JBoss 3.2.6 and the startup hangs trying to connect (this is
apparently because 1.7.2 jdbc driver hangs while connecting to 1.7.1
server). Switched server to use 1.7.2.7 and everything worked again.
Thomas
Thomas Risberg wrote:
> There are three steps we have to take:
>
> 1. Modify scripts to create tables to use INTEGER instead of INT(4)
> 2. Build a new petclinic database (petclinic.script +
> petclinic.properties) and issue a SHUTDOWN COMPACT to provide
> compatibility with 1.7.2
> 3. Upgrade Spring to use HSQLDB 1.7.2 instead of 1.7.1
>
> I think 1 and 2 should be done before 1.1.2 release. We should wait
> with 3 to give more time for testing and to announce it to our user
> community. If we upgrade now we could break existing apps using
> HSQLDB since databases from 1.7.1 aren't compatible with 1.7.2. Even
> if Spring works properly with 1.7.2 we could affect already running
> Spring applications.
>
> I can make changes 1 and 2 today and I have already tested part of the
> Petclinic functionality. Everything works as long as the HSQLDB
> version in the war file is the same as the one running the server.
>
> Thomas
>
> jürgen höller [werk3AT] wrote:
>
>> I wouldn't mind updating to HSQLDB 1.7.2 either, as long as the
>> sample applications continue to work properly. However, we need to
>> hurry a bit here: Let's clarify this till tomorrow late afternoon, so
>> that I will still have enough time for the actual Spring 1.1.2
>> release tomorrow night.
>>
>> Juergen
>>
>>
>> ________________________________
>>
>> Von: spr...@li... im Auftrag
>> von Colin Sampaleanu
>> Gesendet: Sa 13.11.2004 19:01
>> An: spr...@li...
>> Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>
>>
>>
>> That's great. If it's really that minor, I would vote to just switch
>> ourselves to 1.7.2, instead of keeping 1.7.1 and only upgrading the
>> scripts to work with both versions.
>>
>> Thomas Risberg wrote:
>>
>>
>>
>>> I just changed the db scripts for HSQLDB - changed INT(4) to INTEGER
>>> and rebuilt the database. Using the 1.7.2 jar files both for running
>>> the HSQLDB server and deploying to JBoss 3.2.6 worked fine - I was
>>> able to look up Basil and other pets.
>>>
>>> I'll do some more testing today to see if the new scripts and db are
>>> interchangeable between 1.7.1 and 1.7.2 - that way we could update the
>>> scripts and rebuild the db to be shipped with our next release. This
>>> would make it easier for JBoss 3.2.6 deployment since all you would
>>> have to do is replace our hsqldb.jar with the one from the JBoss
>>> distribution.
>>>
>>> Thomas
>>>
>>>
>>> Colin Sampaleanu wrote:
>>>
>>>
>>>
>>>> I don't have any problems either way. If switching to 1.7.2 is just a
>>>> few tweaks to some of the saved db scripts in CVS I don't see a big
>>>> issue with it, but whatever makes sense.
>>>>
>>>> As for JBoss, they've shipped HSQLDB all along, since their queue
>>>> used it by default, for example. Hibernate they just added recently,
>>>> inlcuding a deployer service which deploys it automatically. For sure
>>>> somebody wanting to use Hibernate with JBoss needs to either take out
>>>> the JBoss incldued one (along with the older cglib) and the deployer,
>>>> or alternately upgrade the jars in JBoss...
>>>>
>>>> jürgen höller [werk3AT] wrote:
>>>>
>>>>
>>>>
>>>>> I guess it's better to stick with HSQLDB 1.7.1 for the Spring 1.1.x
>>>>> branch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we
>>>>> need to point out that this incompatibility issue exists.
>>>>>
>>>>> Why does JBoss ship tons of optional third-party jars in the server
>>>>> lib directory in the first place?? Could cause issues with newer
>>>>> Hibernate versions used in applications too, unless the
>>>>> JBoss-provided jars get removed from the server lib directory...
>>>>>
>>>>> Juergen
>>>>>
>>>>>
>>>>> ________________________________
>>>>>
>>>>> Von: spr...@li... im
>>>>> Auftrag von Colin Sampaleanu
>>>>> Gesendet: Sa 13.11.2004 15:47
>>>>> An: spr...@li...
>>>>> Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>>>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>
>>>>>
>>>>>
>>>>> Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
>>>>> 2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is only a
>>>>> week or so after 2.1.4 came out, and almost 2 months before
>>>>> 2.1.5/2.1.6
>>>>> came out.
>>>>>
>>>>> But this is not Hibernate related. The hang happens with JDBC too.
>>>>> As I
>>>>> mentioned in my other email, I think the problem is simply trying to
>>>>> mix
>>>>> HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running,
>>>>> there is
>>>>> no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
>>>>>
>>>>> Colin
>>>>>
>>>>> Alef Arendsen wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>> Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
>>>>>> 2.0.2 I think) in its server/default/lib directory. They recently
>>>>>> introduced Hibernate archives (HARs), maybe that's why the jars
>>>>>> are in
>>>>>> there. I would expect some weird classnotfoundexception because of
>>>>>> this,
>>>>>> not a server hang, but it might be related.
>>>>>>
>>>>>> Maybe you could try to cleanup the server/default/lib directory or
>>>>>> create yourself a separate server config.
>>>>>>
>>>>>> Alef
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> -----Original Message-----
>>>>>>> From: spr...@li...
>>>>>>> [mailto:spr...@li...]
>>>>>>> On Behalf Of Colin Sampaleanu
>>>>>>> Sent: Saturday, November 13, 2004 1:15 AM
>>>>>>> To: spr...@li...
>>>>>>> Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>>>>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>>>
>>>>>>> I am seeing extremely strange, completely repeatable
>>>>>>> behaviour, where Petclinc in both the JDBC and the hibernate
>>>>>>> deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>>>>>> hangs after a certain point in JBoss 3.2.6. The ejbtest
>>>>>>> sample does exactly the same thing. Weird thing in
>>>>>>> 3.2.6 is that if I shut down the external HSQL db (started
>>>>>>> with the server.bat file), then the app starts fine (getting
>>>>>>> some obvious errors since it can't actually talk to the db,
>>>>>>> but doesn't hang). This means the issues are somehow related
>>>>>>> to HSQL in the 3.2.6 environment.
>>>>>>>
>>>>>>> Here's the sequence from the JDBC version:
>>>>>>>
>>>>>>> 18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>>>>>> shared instance of sing leton bean 'dataSource'
>>>>>>> 18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>>>>>> driver: org.hsqldb.jdbc Driver
>>>>>>> 18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>>>>>> shared instance of sing leton bean 'transactionManager'
>>>>>>> 18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>>>>>> shared instance of sing leton bean 'clinic'
>>>>>>> 18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>>>>>> shared instance of sing leton bean 'hsqlClinic'
>>>>>>> 18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>>>> definitions from c lass path resource
>>>>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>>>>> 18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>>>>>> of singleton bean '
>>>>>>> DB2'
>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>> of singleton bean '
>>>>>>> HSQL'
>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>> of singleton bean '
>>>>>>> MS-SQL'
>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>> of singleton bean '
>>>>>>> MySQL'
>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>> of singleton bean '
>>>>>>> Oracle'
>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>> of singleton bean '
>>>>>>> Informix'
>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>> of singleton bean '
>>>>>>> PostgreSQL'
>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>> of singleton bean '
>>>>>>> Sybase'
>>>>>>> 18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>>>>>> loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>>>>>> Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>>>>>> MySQL, DB2*]
>>>>>>>
>>>>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>>>> continues with items below:
>>>>>>>
>>>>>>> 18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>>>>>> RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>>>>>> vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>>>>>> INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>>>>>> with SQL [SELECT id,name FROM specialties] compiled
>>>>>>> 18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>>>>>> RdbmsOperation with SQL [SELECT specialty_id FROM
>>>>>>> vet_specialties WHERE vet_id=?] compiled
>>>>>>>
>>>>>>> ... and so on
>>>>>>>
>>>>>>> The Hibernate version has this sequence:
>>>>>>>
>>>>>>> 18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>>>>>> shared instance of sing leton bean 'dataSource'
>>>>>>> 18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>>>>>> driver: org.hsqldb.jdbc Driver
>>>>>>> 18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>>>>>> shared instance of sing leton bean 'sessionFactory'
>>>>>>> 18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>>>>>> 18:55:57,468 INFO [Environment] hibernate.properties not found
>>>>>>> 18:55:57,484 INFO [Environment] using CGLIB reflection
>>>>>>> optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>>>>>> org.springframework.samples.petclinic
>>>>>>> .Vet -> vets
>>>>>>> 18:55:57,812 INFO [Binder] Mapping collection:
>>>>>>> org.springframework.samples.petc
>>>>>>> linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>>>>>> INFO [Binder] Mapping class: org.springframework.samples.petclinic
>>>>>>> .Specialty -> specialties
>>>>>>> 18:55:57,890 INFO [Binder] Mapping class:
>>>>>>> org.springframework.samples.petclinic
>>>>>>> .Owner -> owners
>>>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>>>> org.springframework.samples.petclinic
>>>>>>> .Pet -> pets
>>>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>>>> org.springframework.samples.petclinic
>>>>>>> .PetType -> types
>>>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>>>> org.springframework.samples.petclinic
>>>>>>> .Visit -> visits
>>>>>>> 18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>>>>>> Hibernate SessionFacto ry
>>>>>>> 18:55:57,906 INFO [Configuration] processing one-to-many
>>>>>>> association mappings
>>>>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>>>>> org.springframework.samples.petc linic.Owner.petsInternal -> pets
>>>>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>>>>> org.springframework.samples.petc linic.Pet.visitsInternal -> visits
>>>>>>> 18:55:57,906 INFO [Configuration] processing one-to-one
>>>>>>> association property re ferences
>>>>>>> 18:55:57,906 INFO [Configuration] processing foreign key
>>>>>>> constraints
>>>>>>> 18:55:57,953 INFO [Dialect] Using dialect:
>>>>>>> net.sf.hibernate.dialect.HSQLDialect
>>>>>>>
>>>>>>> 18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
>>>>>>> 18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>>>>>> connection provider:
>>>>>>> org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>>>>>> 18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>>>>>> TransactionManagerLookup configured (in JTA environment, use
>>>>>>> of process level read-write cache is not re
>>>>>>> commended)
>>>>>>>
>>>>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>>>> continues with items below:
>>>>>>>
>>>>>>> 18:55:57,984 INFO [SettingsFactory] Use scrollable result sets:
>>>>>>> true
>>>>>>> 18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>>>>>> getGeneratedKeys(): false
>>>>>>> 18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>>>>>> minimal puts: false
>>>>>>> 18:55:57,984 INFO [SettingsFactory] Query language
>>>>>>> substitutions: {}
>>>>>>> 18:55:57,984 INFO [SettingsFactory] cache provider:
>>>>>>> net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
>>>>>>> [Configuration] instantiating and configuring caches
>>>>>>> 18:55:58,234 INFO [SessionFactoryImpl] building session factory
>>>>>>> 18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>>>>>> factory to JNDI, no JNDI name configured
>>>>>>> 18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>>>>>> shared instance of sing leton bean 'transactionManager'
>>>>>>>
>>>>>>> 18:55:58,734 INFO [HibernateTransactionManager] Using
>>>>>>> DataSource [org.springfra
>>>>>>> mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>>>>>> Hibernate SessionFact ory for HibernateTransactionManager
>>>>>>> 18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>>>>>> shared instance of sing leton bean 'clinic'
>>>>>>> 18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>>>> definitions from c lass path resource
>>>>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>>>>> 18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>>>>>> of singleton bean '
>>>>>>> DB2'
>>>>>>>
>>>>>>> ... and so on
>>>>>>>
>>>>>>>
>>>>>>> Can anybody else duplicate this?
>>>>>>>
>>>>>>> Colin
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: InterSystems CACHE
>> FREE OODBMS DOWNLOAD - A multidimensional database that combines
>> robust object and relational technologies, making it a perfect match
>> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>> _______________________________________________
>> Springframework-developer mailing list
>> Spr...@li...
>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: InterSystems CACHE
>> FREE OODBMS DOWNLOAD - A multidimensional database that combines
>> robust object and relational technologies, making it a perfect match
>> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>> _______________________________________________
>> Springframework-developer mailing list
>> Spr...@li...
>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>
>>
>>
>>
>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
|
|
From: Thomas R. <tho...@tr...> - 2004-11-13 22:07:58
|
Just checked JBoss 4.0 and it behaves the same way as 3.2.6 - using
HSQLDB 1.7.2 for the server works both for jpetstore and the new
petclinic database.
Thomas
Thomas Risberg wrote:
> I have checked in the first two changes - petclinic db scripts now use
> INTEGER instead of INT(4) and I built new petclinic and jpetstore
> databases using SHUTDOWN COMPACT to provide better compatibility with
> 1.7.2.
>
> Deployed to JBoss 3.2.5 using 1.7.1 for the server and everything
> worked fine.
> Deployed to JBoss 3.2.6 and the startup hangs trying to connect (this
> is apparently because 1.7.2 jdbc driver hangs while connecting to
> 1.7.1 server). Switched server to use 1.7.2.7 and everything worked
> again.
>
> Thomas
>
>
> Thomas Risberg wrote:
>
>> There are three steps we have to take:
>>
>> 1. Modify scripts to create tables to use INTEGER instead of INT(4)
>> 2. Build a new petclinic database (petclinic.script +
>> petclinic.properties) and issue a SHUTDOWN COMPACT to provide
>> compatibility with 1.7.2
>> 3. Upgrade Spring to use HSQLDB 1.7.2 instead of 1.7.1
>>
>> I think 1 and 2 should be done before 1.1.2 release. We should wait
>> with 3 to give more time for testing and to announce it to our user
>> community. If we upgrade now we could break existing apps using
>> HSQLDB since databases from 1.7.1 aren't compatible with 1.7.2. Even
>> if Spring works properly with 1.7.2 we could affect already running
>> Spring applications.
>>
>> I can make changes 1 and 2 today and I have already tested part of
>> the Petclinic functionality. Everything works as long as the HSQLDB
>> version in the war file is the same as the one running the server.
>>
>> Thomas
>>
>> jürgen höller [werk3AT] wrote:
>>
>>> I wouldn't mind updating to HSQLDB 1.7.2 either, as long as the
>>> sample applications continue to work properly. However, we need to
>>> hurry a bit here: Let's clarify this till tomorrow late afternoon,
>>> so that I will still have enough time for the actual Spring 1.1.2
>>> release tomorrow night.
>>>
>>> Juergen
>>>
>>>
>>> ________________________________
>>>
>>> Von: spr...@li... im
>>> Auftrag von Colin Sampaleanu
>>> Gesendet: Sa 13.11.2004 19:01
>>> An: spr...@li...
>>> Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>
>>>
>>>
>>> That's great. If it's really that minor, I would vote to just switch
>>> ourselves to 1.7.2, instead of keeping 1.7.1 and only upgrading the
>>> scripts to work with both versions.
>>>
>>> Thomas Risberg wrote:
>>>
>>>
>>>
>>>> I just changed the db scripts for HSQLDB - changed INT(4) to INTEGER
>>>> and rebuilt the database. Using the 1.7.2 jar files both for running
>>>> the HSQLDB server and deploying to JBoss 3.2.6 worked fine - I was
>>>> able to look up Basil and other pets.
>>>>
>>>> I'll do some more testing today to see if the new scripts and db are
>>>> interchangeable between 1.7.1 and 1.7.2 - that way we could update the
>>>> scripts and rebuild the db to be shipped with our next release. This
>>>> would make it easier for JBoss 3.2.6 deployment since all you would
>>>> have to do is replace our hsqldb.jar with the one from the JBoss
>>>> distribution.
>>>>
>>>> Thomas
>>>>
>>>>
>>>> Colin Sampaleanu wrote:
>>>>
>>>>
>>>>
>>>>> I don't have any problems either way. If switching to 1.7.2 is just a
>>>>> few tweaks to some of the saved db scripts in CVS I don't see a big
>>>>> issue with it, but whatever makes sense.
>>>>>
>>>>> As for JBoss, they've shipped HSQLDB all along, since their queue
>>>>> used it by default, for example. Hibernate they just added recently,
>>>>> inlcuding a deployer service which deploys it automatically. For sure
>>>>> somebody wanting to use Hibernate with JBoss needs to either take out
>>>>> the JBoss incldued one (along with the older cglib) and the deployer,
>>>>> or alternately upgrade the jars in JBoss...
>>>>>
>>>>> jürgen höller [werk3AT] wrote:
>>>>>
>>>>>
>>>>>
>>>>>> I guess it's better to stick with HSQLDB 1.7.1 for the Spring 1.1.x
>>>>>> branch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we
>>>>>> need to point out that this incompatibility issue exists.
>>>>>>
>>>>>> Why does JBoss ship tons of optional third-party jars in the server
>>>>>> lib directory in the first place?? Could cause issues with newer
>>>>>> Hibernate versions used in applications too, unless the
>>>>>> JBoss-provided jars get removed from the server lib directory...
>>>>>>
>>>>>> Juergen
>>>>>>
>>>>>>
>>>>>> ________________________________
>>>>>>
>>>>>> Von: spr...@li... im
>>>>>> Auftrag von Colin Sampaleanu
>>>>>> Gesendet: Sa 13.11.2004 15:47
>>>>>> An: spr...@li...
>>>>>> Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>>>>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>>
>>>>>>
>>>>>>
>>>>>> Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
>>>>>> 2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is
>>>>>> only a
>>>>>> week or so after 2.1.4 came out, and almost 2 months before
>>>>>> 2.1.5/2.1.6
>>>>>> came out.
>>>>>>
>>>>>> But this is not Hibernate related. The hang happens with JDBC
>>>>>> too. As I
>>>>>> mentioned in my other email, I think the problem is simply trying to
>>>>>> mix
>>>>>> HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running,
>>>>>> there is
>>>>>> no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
>>>>>>
>>>>>> Colin
>>>>>>
>>>>>> Alef Arendsen wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
>>>>>>> 2.0.2 I think) in its server/default/lib directory. They recently
>>>>>>> introduced Hibernate archives (HARs), maybe that's why the jars
>>>>>>> are in
>>>>>>> there. I would expect some weird classnotfoundexception because of
>>>>>>> this,
>>>>>>> not a server hang, but it might be related.
>>>>>>>
>>>>>>> Maybe you could try to cleanup the server/default/lib directory or
>>>>>>> create yourself a separate server config.
>>>>>>>
>>>>>>> Alef
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>> -----Original Message-----
>>>>>>>> From: spr...@li...
>>>>>>>> [mailto:spr...@li...]
>>>>>>>> On Behalf Of Colin Sampaleanu
>>>>>>>> Sent: Saturday, November 13, 2004 1:15 AM
>>>>>>>> To: spr...@li...
>>>>>>>> Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>>>>>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>>>>
>>>>>>>> I am seeing extremely strange, completely repeatable
>>>>>>>> behaviour, where Petclinc in both the JDBC and the hibernate
>>>>>>>> deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>>>>>>> hangs after a certain point in JBoss 3.2.6. The ejbtest
>>>>>>>> sample does exactly the same thing. Weird thing in
>>>>>>>> 3.2.6 is that if I shut down the external HSQL db (started
>>>>>>>> with the server.bat file), then the app starts fine (getting
>>>>>>>> some obvious errors since it can't actually talk to the db,
>>>>>>>> but doesn't hang). This means the issues are somehow related
>>>>>>>> to HSQL in the 3.2.6 environment.
>>>>>>>>
>>>>>>>> Here's the sequence from the JDBC version:
>>>>>>>>
>>>>>>>> 18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'dataSource'
>>>>>>>> 18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>>>>>>> driver: org.hsqldb.jdbc Driver
>>>>>>>> 18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'transactionManager'
>>>>>>>> 18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'clinic'
>>>>>>>> 18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'hsqlClinic'
>>>>>>>> 18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>>>>> definitions from c lass path resource
>>>>>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>>>>>> 18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> DB2'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> HSQL'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> MS-SQL'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> MySQL'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> Oracle'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> Informix'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> PostgreSQL'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> Sybase'
>>>>>>>> 18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>>>>>>> loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>>>>>>> Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>>>>>>> MySQL, DB2*]
>>>>>>>>
>>>>>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>>>>> continues with items below:
>>>>>>>>
>>>>>>>> 18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>>>>>>> RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>>>>>>> vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>>>>>>> INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>>>>>>> with SQL [SELECT id,name FROM specialties] compiled
>>>>>>>> 18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>>>>>>> RdbmsOperation with SQL [SELECT specialty_id FROM
>>>>>>>> vet_specialties WHERE vet_id=?] compiled
>>>>>>>>
>>>>>>>> ... and so on
>>>>>>>>
>>>>>>>> The Hibernate version has this sequence:
>>>>>>>>
>>>>>>>> 18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'dataSource'
>>>>>>>> 18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>>>>>>> driver: org.hsqldb.jdbc Driver
>>>>>>>> 18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'sessionFactory'
>>>>>>>> 18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>>>>>>> 18:55:57,468 INFO [Environment] hibernate.properties not found
>>>>>>>> 18:55:57,484 INFO [Environment] using CGLIB reflection
>>>>>>>> optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .Vet -> vets
>>>>>>>> 18:55:57,812 INFO [Binder] Mapping collection:
>>>>>>>> org.springframework.samples.petc
>>>>>>>> linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>>>>>>> INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .Specialty -> specialties
>>>>>>>> 18:55:57,890 INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .Owner -> owners
>>>>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .Pet -> pets
>>>>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .PetType -> types
>>>>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .Visit -> visits
>>>>>>>> 18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>>>>>>> Hibernate SessionFacto ry
>>>>>>>> 18:55:57,906 INFO [Configuration] processing one-to-many
>>>>>>>> association mappings
>>>>>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>>>>>> org.springframework.samples.petc linic.Owner.petsInternal -> pets
>>>>>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>>>>>> org.springframework.samples.petc linic.Pet.visitsInternal ->
>>>>>>>> visits
>>>>>>>> 18:55:57,906 INFO [Configuration] processing one-to-one
>>>>>>>> association property re ferences
>>>>>>>> 18:55:57,906 INFO [Configuration] processing foreign key
>>>>>>>> constraints
>>>>>>>> 18:55:57,953 INFO [Dialect] Using dialect:
>>>>>>>> net.sf.hibernate.dialect.HSQLDialect
>>>>>>>>
>>>>>>>> 18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
>>>>>>>> 18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>>>>>>> connection provider:
>>>>>>>> org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>>>>>>>
>>>>>>>> 18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>>>>>>> TransactionManagerLookup configured (in JTA environment, use
>>>>>>>> of process level read-write cache is not re
>>>>>>>> commended)
>>>>>>>>
>>>>>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>>>>> continues with items below:
>>>>>>>>
>>>>>>>> 18:55:57,984 INFO [SettingsFactory] Use scrollable result
>>>>>>>> sets: true
>>>>>>>> 18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>>>>>>> getGeneratedKeys(): false
>>>>>>>> 18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>>>>>>> minimal puts: false
>>>>>>>> 18:55:57,984 INFO [SettingsFactory] Query language
>>>>>>>> substitutions: {}
>>>>>>>> 18:55:57,984 INFO [SettingsFactory] cache provider:
>>>>>>>> net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
>>>>>>>> [Configuration] instantiating and configuring caches
>>>>>>>> 18:55:58,234 INFO [SessionFactoryImpl] building session factory
>>>>>>>> 18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>>>>>>> factory to JNDI, no JNDI name configured
>>>>>>>> 18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'transactionManager'
>>>>>>>>
>>>>>>>> 18:55:58,734 INFO [HibernateTransactionManager] Using
>>>>>>>> DataSource [org.springfra
>>>>>>>> mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>>>>>>> Hibernate SessionFact ory for HibernateTransactionManager
>>>>>>>> 18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'clinic'
>>>>>>>> 18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>>>>> definitions from c lass path resource
>>>>>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>>>>>> 18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> DB2'
>>>>>>>>
>>>>>>>> ... and so on
>>>>>>>>
>>>>>>>>
>>>>>>>> Can anybody else duplicate this?
>>>>>>>>
>>>>>>>> Colin
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by: InterSystems CACHE
>>> FREE OODBMS DOWNLOAD - A multidimensional database that combines
>>> robust object and relational technologies, making it a perfect match
>>> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>>> _______________________________________________
>>> Springframework-developer mailing list
>>> Spr...@li...
>>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>>
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by: InterSystems CACHE
>>> FREE OODBMS DOWNLOAD - A multidimensional database that combines
>>> robust object and relational technologies, making it a perfect match
>>> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>>> _______________________________________________
>>> Springframework-developer mailing list
>>> Spr...@li...
>>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: InterSystems CACHE
>> FREE OODBMS DOWNLOAD - A multidimensional database that combines
>> robust object and relational technologies, making it a perfect match
>> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>> _______________________________________________
>> Springframework-developer mailing list
>> Spr...@li...
>> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>
>>
>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
|
|
From: <jue...@we...> - 2004-11-14 09:42:47
|
That's great - thanks, Thomas!
=20
The final question is whether to update the HSQLDB version that we ship =
to 1.7.2 now. As we need to do this at some point anyway, we could =
already go forward and do this now...
=20
Using HSQLDB 1.7.2 should only cause problems on JBoss <=3D 3.2.5 =
anyway. No other server includes an HSQLDB jar as part of its shared =
class loader, as far as I'm aware of...
=20
Juergen
=20
________________________________
Von: spr...@li... im Auftrag =
von Thomas Risberg
Gesendet: Sa 13.11.2004 23:07
An: spr...@li...
Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or =
Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
Just checked JBoss 4.0 and it behaves the same way as 3.2.6 - using
HSQLDB 1.7.2 for the server works both for jpetstore and the new
petclinic database.
Thomas
Thomas Risberg wrote:
> I have checked in the first two changes - petclinic db scripts now use
> INTEGER instead of INT(4) and I built new petclinic and jpetstore
> databases using SHUTDOWN COMPACT to provide better compatibility with
> 1.7.2.
>
> Deployed to JBoss 3.2.5 using 1.7.1 for the server and everything
> worked fine.
> Deployed to JBoss 3.2.6 and the startup hangs trying to connect (this
> is apparently because 1.7.2 jdbc driver hangs while connecting to
> 1.7.1 server). Switched server to use 1.7.2.7 and everything worked
> again.
>
> Thomas
>
>
> Thomas Risberg wrote:
>
>> There are three steps we have to take:
>>
>> 1. Modify scripts to create tables to use INTEGER instead of INT(4)
>> 2. Build a new petclinic database (petclinic.script +
>> petclinic.properties) and issue a SHUTDOWN COMPACT to provide
>> compatibility with 1.7.2
>> 3. Upgrade Spring to use HSQLDB 1.7.2 instead of 1.7.1
>>
>> I think 1 and 2 should be done before 1.1.2 release. We should wait
>> with 3 to give more time for testing and to announce it to our user
>> community. If we upgrade now we could break existing apps using
>> HSQLDB since databases from 1.7.1 aren't compatible with 1.7.2. Even
>> if Spring works properly with 1.7.2 we could affect already running
>> Spring applications.
>>
>> I can make changes 1 and 2 today and I have already tested part of
>> the Petclinic functionality. Everything works as long as the HSQLDB
>> version in the war file is the same as the one running the server.
>>
>> Thomas
>>
>> j=FCrgen h=F6ller [werk3AT] wrote:
>>
>>> I wouldn't mind updating to HSQLDB 1.7.2 either, as long as the
>>> sample applications continue to work properly. However, we need to
>>> hurry a bit here: Let's clarify this till tomorrow late afternoon,
>>> so that I will still have enough time for the actual Spring 1.1.2
>>> release tomorrow night.
>>>
>>> Juergen
>>>
>>>
>>> ________________________________
>>>
>>> Von: spr...@li... im
>>> Auftrag von Colin Sampaleanu
>>> Gesendet: Sa 13.11.2004 19:01
>>> An: spr...@li...
>>> Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>
>>>
>>>
>>> That's great. If it's really that minor, I would vote to just switch
>>> ourselves to 1.7.2, instead of keeping 1.7.1 and only upgrading the
>>> scripts to work with both versions.
>>>
>>> Thomas Risberg wrote:
>>>
>>>=20
>>>
>>>> I just changed the db scripts for HSQLDB - changed INT(4) to =
INTEGER
>>>> and rebuilt the database. Using the 1.7.2 jar files both for =
running
>>>> the HSQLDB server and deploying to JBoss 3.2.6 worked fine - I was
>>>> able to look up Basil and other pets.
>>>>
>>>> I'll do some more testing today to see if the new scripts and db =
are
>>>> interchangeable between 1.7.1 and 1.7.2 - that way we could update =
the
>>>> scripts and rebuild the db to be shipped with our next release. =
This
>>>> would make it easier for JBoss 3.2.6 deployment since all you would
>>>> have to do is replace our hsqldb.jar with the one from the JBoss
>>>> distribution.
>>>>
>>>> Thomas
>>>>
>>>>
>>>> Colin Sampaleanu wrote:
>>>>
>>>>=20
>>>>
>>>>> I don't have any problems either way. If switching to 1.7.2 is =
just a
>>>>> few tweaks to some of the saved db scripts in CVS I don't see a =
big
>>>>> issue with it, but whatever makes sense.
>>>>>
>>>>> As for JBoss, they've shipped HSQLDB all along, since their queue
>>>>> used it by default, for example. Hibernate they just added =
recently,
>>>>> inlcuding a deployer service which deploys it automatically. For =
sure
>>>>> somebody wanting to use Hibernate with JBoss needs to either take =
out
>>>>> the JBoss incldued one (along with the older cglib) and the =
deployer,
>>>>> or alternately upgrade the jars in JBoss...
>>>>>
>>>>> j=FCrgen h=F6ller [werk3AT] wrote:
>>>>>
>>>>> =20
>>>>>
>>>>>> I guess it's better to stick with HSQLDB 1.7.1 for the Spring =
1.1.x
>>>>>> branch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we
>>>>>> need to point out that this incompatibility issue exists.
>>>>>>
>>>>>> Why does JBoss ship tons of optional third-party jars in the =
server
>>>>>> lib directory in the first place?? Could cause issues with newer
>>>>>> Hibernate versions used in applications too, unless the
>>>>>> JBoss-provided jars get removed from the server lib directory...
>>>>>>
>>>>>> Juergen
>>>>>>
>>>>>>
>>>>>> ________________________________
>>>>>>
>>>>>> Von: spr...@li... im
>>>>>> Auftrag von Colin Sampaleanu
>>>>>> Gesendet: Sa 13.11.2004 15:47
>>>>>> An: spr...@li...
>>>>>> Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>>>>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>>
>>>>>>
>>>>>>
>>>>>> Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
>>>>>> 2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is
>>>>>> only a
>>>>>> week or so after 2.1.4 came out, and almost 2 months before
>>>>>> 2.1.5/2.1.6
>>>>>> came out.
>>>>>>
>>>>>> But this is not Hibernate related. The hang happens with JDBC
>>>>>> too. As I
>>>>>> mentioned in my other email, I think the problem is simply trying =
to
>>>>>> mix
>>>>>> HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running,
>>>>>> there is
>>>>>> no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
>>>>>>
>>>>>> Colin
>>>>>>
>>>>>> Alef Arendsen wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>> =20
>>>>>>
>>>>>>> Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're =
using
>>>>>>> 2.0.2 I think) in its server/default/lib directory. They =
recently
>>>>>>> introduced Hibernate archives (HARs), maybe that's why the jars
>>>>>>> are in
>>>>>>> there. I would expect some weird classnotfoundexception because =
of
>>>>>>> this,
>>>>>>> not a server hang, but it might be related.
>>>>>>>
>>>>>>> Maybe you could try to cleanup the server/default/lib directory =
or
>>>>>>> create yourself a separate server config.
>>>>>>>
>>>>>>> Alef
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> =20
>>>>>>>
>>>>>>>> -----Original Message-----
>>>>>>>> From: spr...@li...
>>>>>>>> [mailto:spr...@li...]
>>>>>>>> On Behalf Of Colin Sampaleanu
>>>>>>>> Sent: Saturday, November 13, 2004 1:15 AM
>>>>>>>> To: spr...@li...
>>>>>>>> Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>>>>>>> Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>>>>
>>>>>>>> I am seeing extremely strange, completely repeatable
>>>>>>>> behaviour, where Petclinc in both the JDBC and the hibernate
>>>>>>>> deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>>>>>>> hangs after a certain point in JBoss 3.2.6. The ejbtest
>>>>>>>> sample does exactly the same thing. Weird thing in
>>>>>>>> 3.2.6 is that if I shut down the external HSQL db (started
>>>>>>>> with the server.bat file), then the app starts fine (getting
>>>>>>>> some obvious errors since it can't actually talk to the db,
>>>>>>>> but doesn't hang). This means the issues are somehow related
>>>>>>>> to HSQL in the 3.2.6 environment.
>>>>>>>>
>>>>>>>> Here's the sequence from the JDBC version:
>>>>>>>>
>>>>>>>> 18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'dataSource'
>>>>>>>> 18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>>>>>>> driver: org.hsqldb.jdbc Driver
>>>>>>>> 18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'transactionManager'
>>>>>>>> 18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'clinic'
>>>>>>>> 18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'hsqlClinic'
>>>>>>>> 18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>>>>> definitions from c lass path resource
>>>>>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>>>>>> 18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> DB2'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> HSQL'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> MS-SQL'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> MySQL'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> Oracle'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> Informix'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> PostgreSQL'
>>>>>>>> 18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> Sybase'
>>>>>>>> 18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>>>>>>> loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>>>>>>> Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>>>>>>> MySQL, DB2*]
>>>>>>>>
>>>>>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>>>>> continues with items below:
>>>>>>>>
>>>>>>>> 18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>>>>>>> RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>>>>>>> vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>>>>>>> INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>>>>>>> with SQL [SELECT id,name FROM specialties] compiled
>>>>>>>> 18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>>>>>>> RdbmsOperation with SQL [SELECT specialty_id FROM
>>>>>>>> vet_specialties WHERE vet_id=3D?] compiled
>>>>>>>>
>>>>>>>> ... and so on
>>>>>>>>
>>>>>>>> The Hibernate version has this sequence:
>>>>>>>>
>>>>>>>> 18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'dataSource'
>>>>>>>> 18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>>>>>>> driver: org.hsqldb.jdbc Driver
>>>>>>>> 18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'sessionFactory'
>>>>>>>> 18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>>>>>>> 18:55:57,468 INFO [Environment] hibernate.properties not found
>>>>>>>> 18:55:57,484 INFO [Environment] using CGLIB reflection
>>>>>>>> optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .Vet -> vets
>>>>>>>> 18:55:57,812 INFO [Binder] Mapping collection:
>>>>>>>> org.springframework.samples.petc
>>>>>>>> linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>>>>>>> INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .Specialty -> specialties
>>>>>>>> 18:55:57,890 INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .Owner -> owners
>>>>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .Pet -> pets
>>>>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .PetType -> types
>>>>>>>> 18:55:57,906 INFO [Binder] Mapping class:
>>>>>>>> org.springframework.samples.petclinic
>>>>>>>> .Visit -> visits
>>>>>>>> 18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>>>>>>> Hibernate SessionFacto ry
>>>>>>>> 18:55:57,906 INFO [Configuration] processing one-to-many
>>>>>>>> association mappings
>>>>>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>>>>>> org.springframework.samples.petc linic.Owner.petsInternal -> =
pets
>>>>>>>> 18:55:57,906 INFO [Binder] Mapping collection:
>>>>>>>> org.springframework.samples.petc linic.Pet.visitsInternal ->
>>>>>>>> visits
>>>>>>>> 18:55:57,906 INFO [Configuration] processing one-to-one
>>>>>>>> association property re ferences
>>>>>>>> 18:55:57,906 INFO [Configuration] processing foreign key
>>>>>>>> constraints
>>>>>>>> 18:55:57,953 INFO [Dialect] Using dialect:
>>>>>>>> net.sf.hibernate.dialect.HSQLDialect
>>>>>>>>
>>>>>>>> 18:55:57,953 INFO [SettingsFactory] Use outer join fetching: =
true
>>>>>>>> 18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>>>>>>> connection provider:
>>>>>>>> =
org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>>>>>>>
>>>>>>>> 18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>>>>>>> TransactionManagerLookup configured (in JTA environment, use
>>>>>>>> of process level read-write cache is not re
>>>>>>>> commended)
>>>>>>>>
>>>>>>>> at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>>>>> continues with items below:
>>>>>>>>
>>>>>>>> 18:55:57,984 INFO [SettingsFactory] Use scrollable result
>>>>>>>> sets: true
>>>>>>>> 18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>>>>>>> getGeneratedKeys(): false
>>>>>>>> 18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>>>>>>> minimal puts: false
>>>>>>>> 18:55:57,984 INFO [SettingsFactory] Query language
>>>>>>>> substitutions: {}
>>>>>>>> 18:55:57,984 INFO [SettingsFactory] cache provider:
>>>>>>>> net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
>>>>>>>> [Configuration] instantiating and configuring caches
>>>>>>>> 18:55:58,234 INFO [SessionFactoryImpl] building session =
factory
>>>>>>>> 18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>>>>>>> factory to JNDI, no JNDI name configured
>>>>>>>> 18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'transactionManager'
>>>>>>>>
>>>>>>>> 18:55:58,734 INFO [HibernateTransactionManager] Using
>>>>>>>> DataSource [org.springfra
>>>>>>>> mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>>>>>>> Hibernate SessionFact ory for HibernateTransactionManager
>>>>>>>> 18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>>>>>>> shared instance of sing leton bean 'clinic'
>>>>>>>> 18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>>>>> definitions from c lass path resource
>>>>>>>> [org/springframework/jdbc/support/sql-error-codes.xml]
>>>>>>>> 18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>> of singleton bean '
>>>>>>>> DB2'
>>>>>>>>
>>>>>>>> ... and so on
>>>>>>>>
>>>>>>>>
>>>>>>>> Can anybody else duplicate this?
>>>>>>>>
>>>>>>>> Colin
>>>>>>>> =20
>>>>>>>
>>>>>>>
>>>>>>> =20
>>>>>>
>>>>>>
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by: InterSystems CACHE
>>> FREE OODBMS DOWNLOAD - A multidimensional database that combines
>>> robust object and relational technologies, making it a perfect match
>>> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>>> _______________________________________________
>>> Springframework-developer mailing list
>>> Spr...@li...
>>> =
https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>>
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by: InterSystems CACHE
>>> FREE OODBMS DOWNLOAD - A multidimensional database that combines
>>> robust object and relational technologies, making it a perfect match
>>> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>>> _______________________________________________
>>> Springframework-developer mailing list
>>> Spr...@li...
>>> =
https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>>
>>>
>>>
>>>=20
>>>
>>
>>
>>
>> -------------------------------------------------------
>> This SF.Net email is sponsored by: InterSystems CACHE
>> FREE OODBMS DOWNLOAD - A multidimensional database that combines
>> robust object and relational technologies, making it a perfect match
>> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>> _______________________________________________
>> Springframework-developer mailing list
>> Spr...@li...
>> =
https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>
>>
>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: InterSystems CACHE
> FREE OODBMS DOWNLOAD - A multidimensional database that combines
> robust object and relational technologies, making it a perfect match
> for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
>
-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
_______________________________________________
Springframework-developer mailing list
Spr...@li...
https://lists.sourceforge.net/lists/listinfo/springframework-developer
|
|
From: Colin S. <col...@ex...> - 2004-11-14 13:14:03
|
It's not quite just about JBoss <= 3.2.5. The question is if somebody
has a production system using Spring 1.1.1 or earlier, and they were
using HSQLDB 1.7.1 (which came with that version), and now on upgrading
to 1.1.2 they blindly go an upgrade Spring and all the jars that come
with it, into their system. Their existing db would probably not work
with 1.7.2.
However, since all they have to do is not upgrade there HSQLDB jar, and
we have to do this some time anyways, I am ok with just having a
prominent note to the effect that anybody using the _optional_ HSQLDB
1.7.1 included with Spring <= 1.1.1 should continue using it until they
upgrade their db, instead of switching to the 1.7.2 included with Spring
1.1.2. I would add a separate mention of the need to use 1.7.1 with
JBoss <= 3.2.5.
Colin
jürgen höller [werk3AT] wrote:
>That's great - thanks, Thomas!
>
>The final question is whether to update the HSQLDB version that we ship to 1.7.2 now. As we need to do this at some point anyway, we could already go forward and do this now...
>
>Using HSQLDB 1.7.2 should only cause problems on JBoss <= 3.2.5 anyway. No other server includes an HSQLDB jar as part of its shared class loader, as far as I'm aware of...
>
>Juergen
>
>
>________________________________
>
>Von: spr...@li... im Auftrag von Thomas Risberg
>Gesendet: Sa 13.11.2004 23:07
>An: spr...@li...
>Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>
>
>
>Just checked JBoss 4.0 and it behaves the same way as 3.2.6 - using
>HSQLDB 1.7.2 for the server works both for jpetstore and the new
>petclinic database.
>
>Thomas
>
>
>Thomas Risberg wrote:
>
>
>
>>I have checked in the first two changes - petclinic db scripts now use
>>INTEGER instead of INT(4) and I built new petclinic and jpetstore
>>databases using SHUTDOWN COMPACT to provide better compatibility with
>>1.7.2.
>>
>>Deployed to JBoss 3.2.5 using 1.7.1 for the server and everything
>>worked fine.
>>Deployed to JBoss 3.2.6 and the startup hangs trying to connect (this
>>is apparently because 1.7.2 jdbc driver hangs while connecting to
>>1.7.1 server). Switched server to use 1.7.2.7 and everything worked
>>again.
>>
>>Thomas
>>
>>
>>Thomas Risberg wrote:
>>
>>
>>
>>>There are three steps we have to take:
>>>
>>>1. Modify scripts to create tables to use INTEGER instead of INT(4)
>>>2. Build a new petclinic database (petclinic.script +
>>>petclinic.properties) and issue a SHUTDOWN COMPACT to provide
>>>compatibility with 1.7.2
>>>3. Upgrade Spring to use HSQLDB 1.7.2 instead of 1.7.1
>>>
>>>I think 1 and 2 should be done before 1.1.2 release. We should wait
>>>with 3 to give more time for testing and to announce it to our user
>>>community. If we upgrade now we could break existing apps using
>>>HSQLDB since databases from 1.7.1 aren't compatible with 1.7.2. Even
>>>if Spring works properly with 1.7.2 we could affect already running
>>>Spring applications.
>>>
>>>I can make changes 1 and 2 today and I have already tested part of
>>>the Petclinic functionality. Everything works as long as the HSQLDB
>>>version in the war file is the same as the one running the server.
>>>
>>>Thomas
>>>
>>>jürgen höller [werk3AT] wrote:
>>>
>>>
>>>
>>>>I wouldn't mind updating to HSQLDB 1.7.2 either, as long as the
>>>>sample applications continue to work properly. However, we need to
>>>>hurry a bit here: Let's clarify this till tomorrow late afternoon,
>>>>so that I will still have enough time for the actual Spring 1.1.2
>>>>release tomorrow night.
>>>>
>>>>Juergen
>>>>
>>>>
>>>>________________________________
>>>>
>>>>Von: spr...@li... im
>>>>Auftrag von Colin Sampaleanu
>>>>Gesendet: Sa 13.11.2004 19:01
>>>>An: spr...@li...
>>>>Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>>>>Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>
>>>>
>>>>
>>>>That's great. If it's really that minor, I would vote to just switch
>>>>ourselves to 1.7.2, instead of keeping 1.7.1 and only upgrading the
>>>>scripts to work with both versions.
>>>>
>>>>Thomas Risberg wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>I just changed the db scripts for HSQLDB - changed INT(4) to INTEGER
>>>>>and rebuilt the database. Using the 1.7.2 jar files both for running
>>>>>the HSQLDB server and deploying to JBoss 3.2.6 worked fine - I was
>>>>>able to look up Basil and other pets.
>>>>>
>>>>>I'll do some more testing today to see if the new scripts and db are
>>>>>interchangeable between 1.7.1 and 1.7.2 - that way we could update the
>>>>>scripts and rebuild the db to be shipped with our next release. This
>>>>>would make it easier for JBoss 3.2.6 deployment since all you would
>>>>>have to do is replace our hsqldb.jar with the one from the JBoss
>>>>>distribution.
>>>>>
>>>>>Thomas
>>>>>
>>>>>
>>>>>Colin Sampaleanu wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>I don't have any problems either way. If switching to 1.7.2 is just a
>>>>>>few tweaks to some of the saved db scripts in CVS I don't see a big
>>>>>>issue with it, but whatever makes sense.
>>>>>>
>>>>>>As for JBoss, they've shipped HSQLDB all along, since their queue
>>>>>>used it by default, for example. Hibernate they just added recently,
>>>>>>inlcuding a deployer service which deploys it automatically. For sure
>>>>>>somebody wanting to use Hibernate with JBoss needs to either take out
>>>>>>the JBoss incldued one (along with the older cglib) and the deployer,
>>>>>>or alternately upgrade the jars in JBoss...
>>>>>>
>>>>>>jürgen höller [werk3AT] wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>I guess it's better to stick with HSQLDB 1.7.1 for the Spring 1.1.x
>>>>>>>branch. Let's update to HSQLDB 1.7.2 for Spring 1.2. However, we
>>>>>>>need to point out that this incompatibility issue exists.
>>>>>>>
>>>>>>>Why does JBoss ship tons of optional third-party jars in the server
>>>>>>>lib directory in the first place?? Could cause issues with newer
>>>>>>>Hibernate versions used in applications too, unless the
>>>>>>>JBoss-provided jars get removed from the server lib directory...
>>>>>>>
>>>>>>>Juergen
>>>>>>>
>>>>>>>
>>>>>>>________________________________
>>>>>>>
>>>>>>>Von: spr...@li... im
>>>>>>>Auftrag von Colin Sampaleanu
>>>>>>>Gesendet: Sa 13.11.2004 15:47
>>>>>>>An: spr...@li...
>>>>>>>Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or
>>>>>>>Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
>>>>>>>2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is
>>>>>>>only a
>>>>>>>week or so after 2.1.4 came out, and almost 2 months before
>>>>>>>2.1.5/2.1.6
>>>>>>>came out.
>>>>>>>
>>>>>>>But this is not Hibernate related. The hang happens with JDBC
>>>>>>>too. As I
>>>>>>>mentioned in my other email, I think the problem is simply trying to
>>>>>>>mix
>>>>>>>HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running,
>>>>>>>there is
>>>>>>>no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
>>>>>>>
>>>>>>>Colin
>>>>>>>
>>>>>>>Alef Arendsen wrote:
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>>Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
>>>>>>>>2.0.2 I think) in its server/default/lib directory. They recently
>>>>>>>>introduced Hibernate archives (HARs), maybe that's why the jars
>>>>>>>>are in
>>>>>>>>there. I would expect some weird classnotfoundexception because of
>>>>>>>>this,
>>>>>>>>not a server hang, but it might be related.
>>>>>>>>
>>>>>>>>Maybe you could try to cleanup the server/default/lib directory or
>>>>>>>>create yourself a separate server config.
>>>>>>>>
>>>>>>>>Alef
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>>-----Original Message-----
>>>>>>>>>From: spr...@li...
>>>>>>>>>[mailto:spr...@li...]
>>>>>>>>>On Behalf Of Colin Sampaleanu
>>>>>>>>>Sent: Saturday, November 13, 2004 1:15 AM
>>>>>>>>>To: spr...@li...
>>>>>>>>>Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>>>>>>>>Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>>>>>>>>
>>>>>>>>>I am seeing extremely strange, completely repeatable
>>>>>>>>>behaviour, where Petclinc in both the JDBC and the hibernate
>>>>>>>>>deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>>>>>>>>hangs after a certain point in JBoss 3.2.6. The ejbtest
>>>>>>>>>sample does exactly the same thing. Weird thing in
>>>>>>>>>3.2.6 is that if I shut down the external HSQL db (started
>>>>>>>>>with the server.bat file), then the app starts fine (getting
>>>>>>>>>some obvious errors since it can't actually talk to the db,
>>>>>>>>>but doesn't hang). This means the issues are somehow related
>>>>>>>>>to HSQL in the 3.2.6 environment.
>>>>>>>>>
>>>>>>>>>Here's the sequence from the JDBC version:
>>>>>>>>>
>>>>>>>>>18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>>>>>>>>shared instance of sing leton bean 'dataSource'
>>>>>>>>>18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>>>>>>>>driver: org.hsqldb.jdbc Driver
>>>>>>>>>18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>>>>>>>>shared instance of sing leton bean 'transactionManager'
>>>>>>>>>18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>>>>>>>>shared instance of sing leton bean 'clinic'
>>>>>>>>>18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>>>>>>>>shared instance of sing leton bean 'hsqlClinic'
>>>>>>>>>18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>>>>>>definitions from c lass path resource
>>>>>>>>>[org/springframework/jdbc/support/sql-error-codes.xml]
>>>>>>>>>18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>>>of singleton bean '
>>>>>>>>>DB2'
>>>>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>>>of singleton bean '
>>>>>>>>>HSQL'
>>>>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>>>of singleton bean '
>>>>>>>>>MS-SQL'
>>>>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>>>of singleton bean '
>>>>>>>>>MySQL'
>>>>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>>>of singleton bean '
>>>>>>>>>Oracle'
>>>>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>>>of singleton bean '
>>>>>>>>>Informix'
>>>>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>>>of singleton bean '
>>>>>>>>>PostgreSQL'
>>>>>>>>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>>>of singleton bean '
>>>>>>>>>Sybase'
>>>>>>>>>18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>>>>>>>>loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>>>>>>>>Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>>>>>>>>MySQL, DB2*]
>>>>>>>>>
>>>>>>>>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>>>>>>continues with items below:
>>>>>>>>>
>>>>>>>>>18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>>>>>>>>RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>>>>>>>>vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>>>>>>>>INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>>>>>>>>with SQL [SELECT id,name FROM specialties] compiled
>>>>>>>>>18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>>>>>>>>RdbmsOperation with SQL [SELECT specialty_id FROM
>>>>>>>>>vet_specialties WHERE vet_id=?] compiled
>>>>>>>>>
>>>>>>>>>... and so on
>>>>>>>>>
>>>>>>>>>The Hibernate version has this sequence:
>>>>>>>>>
>>>>>>>>>18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>>>>>>>>shared instance of sing leton bean 'dataSource'
>>>>>>>>>18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>>>>>>>>driver: org.hsqldb.jdbc Driver
>>>>>>>>>18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>>>>>>>>shared instance of sing leton bean 'sessionFactory'
>>>>>>>>>18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>>>>>>>>18:55:57,468 INFO [Environment] hibernate.properties not found
>>>>>>>>>18:55:57,484 INFO [Environment] using CGLIB reflection
>>>>>>>>>optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>>>>>>>>org.springframework.samples.petclinic
>>>>>>>>>.Vet -> vets
>>>>>>>>>18:55:57,812 INFO [Binder] Mapping collection:
>>>>>>>>>org.springframework.samples.petc
>>>>>>>>>linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>>>>>>>>INFO [Binder] Mapping class:
>>>>>>>>>org.springframework.samples.petclinic
>>>>>>>>>.Specialty -> specialties
>>>>>>>>>18:55:57,890 INFO [Binder] Mapping class:
>>>>>>>>>org.springframework.samples.petclinic
>>>>>>>>>.Owner -> owners
>>>>>>>>>18:55:57,906 INFO [Binder] Mapping class:
>>>>>>>>>org.springframework.samples.petclinic
>>>>>>>>>.Pet -> pets
>>>>>>>>>18:55:57,906 INFO [Binder] Mapping class:
>>>>>>>>>org.springframework.samples.petclinic
>>>>>>>>>.PetType -> types
>>>>>>>>>18:55:57,906 INFO [Binder] Mapping class:
>>>>>>>>>org.springframework.samples.petclinic
>>>>>>>>>.Visit -> visits
>>>>>>>>>18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>>>>>>>>Hibernate SessionFacto ry
>>>>>>>>>18:55:57,906 INFO [Configuration] processing one-to-many
>>>>>>>>>association mappings
>>>>>>>>>18:55:57,906 INFO [Binder] Mapping collection:
>>>>>>>>>org.springframework.samples.petc linic.Owner.petsInternal -> pets
>>>>>>>>>18:55:57,906 INFO [Binder] Mapping collection:
>>>>>>>>>org.springframework.samples.petc linic.Pet.visitsInternal ->
>>>>>>>>>visits
>>>>>>>>>18:55:57,906 INFO [Configuration] processing one-to-one
>>>>>>>>>association property re ferences
>>>>>>>>>18:55:57,906 INFO [Configuration] processing foreign key
>>>>>>>>>constraints
>>>>>>>>>18:55:57,953 INFO [Dialect] Using dialect:
>>>>>>>>>net.sf.hibernate.dialect.HSQLDialect
>>>>>>>>>
>>>>>>>>>18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
>>>>>>>>>18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>>>>>>>>connection provider:
>>>>>>>>>org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>>>>>>>>
>>>>>>>>>18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>>>>>>>>TransactionManagerLookup configured (in JTA environment, use
>>>>>>>>>of process level read-write cache is not re
>>>>>>>>>commended)
>>>>>>>>>
>>>>>>>>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>>>>>>>>continues with items below:
>>>>>>>>>
>>>>>>>>>18:55:57,984 INFO [SettingsFactory] Use scrollable result
>>>>>>>>>sets: true
>>>>>>>>>18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>>>>>>>>getGeneratedKeys(): false
>>>>>>>>>18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>>>>>>>>minimal puts: false
>>>>>>>>>18:55:57,984 INFO [SettingsFactory] Query language
>>>>>>>>>substitutions: {}
>>>>>>>>>18:55:57,984 INFO [SettingsFactory] cache provider:
>>>>>>>>>net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
>>>>>>>>>[Configuration] instantiating and configuring caches
>>>>>>>>>18:55:58,234 INFO [SessionFactoryImpl] building session factory
>>>>>>>>>18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>>>>>>>>factory to JNDI, no JNDI name configured
>>>>>>>>>18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>>>>>>>>shared instance of sing leton bean 'transactionManager'
>>>>>>>>>
>>>>>>>>>18:55:58,734 INFO [HibernateTransactionManager] Using
>>>>>>>>>DataSource [org.springfra
>>>>>>>>>mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>>>>>>>>Hibernate SessionFact ory for HibernateTransactionManager
>>>>>>>>>18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>>>>>>>>shared instance of sing leton bean 'clinic'
>>>>>>>>>18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>>>>>>>>definitions from c lass path resource
>>>>>>>>>[org/springframework/jdbc/support/sql-error-codes.xml]
>>>>>>>>>18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>>>>>>>>of singleton bean '
>>>>>>>>>DB2'
>>>>>>>>>
>>>>>>>>>... and so on
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>Can anybody else duplicate this?
>>>>>>>>>
>>>>>>>>>Colin
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
|
|
From: Colin S. <col...@ex...> - 2004-11-13 14:48:30
|
Actually JBoss 3.2.6 seems to ship with some sort of of Hibernate
2.1.4+. It calls itself 2.1.5, but is dated June 9th, which is only a
week or so after 2.1.4 came out, and almost 2 months before 2.1.5/2.1.6
came out.
But this is not Hibernate related. The hang happens with JDBC too. As I
mentioned in my other email, I think the problem is simply trying to mix
HSQLDB 1.7.1 and 1.7.2... If the 1.7.1 server is not running, there is
no more hang... And no hang with JBoss 3.2.5 which uses 1.7.1.
Colin
Alef Arendsen wrote:
>Jboss 3.2.6 ships with Hibernate 2.1.6 and CGLIB 2.0.1 (we're using
>2.0.2 I think) in its server/default/lib directory. They recently
>introduced Hibernate archives (HARs), maybe that's why the jars are in
>there. I would expect some weird classnotfoundexception because of this,
>not a server hang, but it might be related.
>
>Maybe you could try to cleanup the server/default/lib directory or
>create yourself a separate server config.
>
>Alef
>
>
>
>
>>-----Original Message-----
>>From: spr...@li...
>>[mailto:spr...@li...]
>> On Behalf Of Colin Sampaleanu
>>Sent: Saturday, November 13, 2004 1:15 AM
>>To: spr...@li...
>>Subject: [Springframework-developer] Spring + MySQL + JDBC or
>>Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
>>
>>I am seeing extremely strange, completely repeatable
>>behaviour, where Petclinc in both the JDBC and the hibernate
>>deployment, using HSQL, starts up ok in JBoss 3.2.5, but
>>hangs after a certain point in JBoss 3.2.6. The ejbtest
>>sample does exactly the same thing. Weird thing in
>>3.2.6 is that if I shut down the external HSQL db (started
>>with the server.bat file), then the app starts fine (getting
>>some obvious errors since it can't actually talk to the db,
>>but doesn't hang). This means the issues are somehow related
>>to HSQL in the 3.2.6 environment.
>>
>>Here's the sequence from the JDBC version:
>>
>>18:51:31,218 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'dataSource'
>>18:51:31,234 INFO [DriverManagerDataSource] Loaded JDBC
>>driver: org.hsqldb.jdbc Driver
>>18:51:31,234 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'transactionManager'
>>18:51:31,250 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'clinic'
>>18:51:31,296 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'hsqlClinic'
>>18:51:31,406 INFO [XmlBeanDefinitionReader] Loading XML bean
>>definitions from c lass path resource
>>[org/springframework/jdbc/support/sql-error-codes.xml]
>>18:51:31,421 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>DB2'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>HSQL'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>MS-SQL'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>MySQL'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>Oracle'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>Informix'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>PostgreSQL'
>>18:51:31,437 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>Sybase'
>>18:51:31,437 INFO [SQLErrorCodesFactory] SQLErrorCodes
>>loaded: [HSQL Database E ngine, Oracle, Sybase SQL Server,
>>Informix Dynamic Server, Microsoft SQL Server, PostgreSQL,
>>MySQL, DB2*]
>>
>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>continues with items below:
>>
>>18:51:31,500 INFO [AbstractJdbcClinic$VetsQuery]
>>RdbmsOperation with SQL [SELEC T id,first_name,last_name FROM
>>vets ORDER BY last_name,first_name] compiled 18:51:31,500
>>INFO [AbstractJdbcClinic$SpecialtiesQuery] RdbmsOperation
>>with SQL [SELECT id,name FROM specialties] compiled
>>18:51:31,515 INFO [AbstractJdbcClinic$VetSpecialtiesQuery]
>>RdbmsOperation with SQL [SELECT specialty_id FROM
>>vet_specialties WHERE vet_id=?] compiled
>>
>>... and so on
>>
>>The Hibernate version has this sequence:
>>
>>18:55:57,421 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'dataSource'
>>18:55:57,421 INFO [DriverManagerDataSource] Loaded JDBC
>>driver: org.hsqldb.jdbc Driver
>>18:55:57,437 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'sessionFactory'
>>18:55:57,468 INFO [Environment] Hibernate 2.1.6
>>18:55:57,468 INFO [Environment] hibernate.properties not found
>>18:55:57,484 INFO [Environment] using CGLIB reflection
>>optimizer 18:55:57,640 INFO [Binder] Mapping class:
>>org.springframework.samples.petclinic
>>.Vet -> vets
>>18:55:57,812 INFO [Binder] Mapping collection:
>>org.springframework.samples.petc
>>linic.Vet.specialtiesInternal -> vet_specialties 18:55:57,890
>>INFO [Binder] Mapping class: org.springframework.samples.petclinic
>>.Specialty -> specialties
>>18:55:57,890 INFO [Binder] Mapping class:
>>org.springframework.samples.petclinic
>>.Owner -> owners
>>18:55:57,906 INFO [Binder] Mapping class:
>>org.springframework.samples.petclinic
>>.Pet -> pets
>>18:55:57,906 INFO [Binder] Mapping class:
>>org.springframework.samples.petclinic
>>.PetType -> types
>>18:55:57,906 INFO [Binder] Mapping class:
>>org.springframework.samples.petclinic
>>.Visit -> visits
>>18:55:57,906 INFO [LocalSessionFactoryBean] Building new
>>Hibernate SessionFacto ry
>>18:55:57,906 INFO [Configuration] processing one-to-many
>>association mappings
>>18:55:57,906 INFO [Binder] Mapping collection:
>>org.springframework.samples.petc linic.Owner.petsInternal -> pets
>>18:55:57,906 INFO [Binder] Mapping collection:
>>org.springframework.samples.petc linic.Pet.visitsInternal -> visits
>>18:55:57,906 INFO [Configuration] processing one-to-one
>>association property re ferences
>>18:55:57,906 INFO [Configuration] processing foreign key constraints
>>18:55:57,953 INFO [Dialect] Using dialect:
>>net.sf.hibernate.dialect.HSQLDialect
>>
>>18:55:57,953 INFO [SettingsFactory] Use outer join fetching: true
>>18:55:57,968 INFO [ConnectionProviderFactory] Initializing
>>connection provider:
>> org.springframework.orm.hibernate.LocalDataSourceConnectionProvider
>>18:55:57,968 INFO [TransactionManagerLookupFactory] No
>>TransactionManagerLookup configured (in JTA environment, use
>>of process level read-write cache is not re
>>commended)
>>
>>at this point, in JBoss 3.2.6, there is a hang, while 3.2.5
>>continues with items below:
>>
>>18:55:57,984 INFO [SettingsFactory] Use scrollable result sets: true
>>18:55:57,984 INFO [SettingsFactory] Use JDBC3
>>getGeneratedKeys(): false
>>18:55:57,984 INFO [SettingsFactory] Optimize cache for
>>minimal puts: false
>>18:55:57,984 INFO [SettingsFactory] Query language substitutions: {}
>>18:55:57,984 INFO [SettingsFactory] cache provider:
>>net.sf.hibernate.cache.EhCa cheProvider 18:55:58,000 INFO
>>[Configuration] instantiating and configuring caches
>>18:55:58,234 INFO [SessionFactoryImpl] building session factory
>>18:55:58,671 INFO [SessionFactoryObjectFactory] Not binding
>>factory to JNDI, no JNDI name configured
>>18:55:58,671 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'transactionManager'
>>
>>18:55:58,734 INFO [HibernateTransactionManager] Using
>>DataSource [org.springfra
>>mework.jdbc.datasource.DriverManagerDataSource@139491b] of
>>Hibernate SessionFact ory for HibernateTransactionManager
>>18:55:58,734 INFO [DefaultListableBeanFactory] Creating
>>shared instance of sing leton bean 'clinic'
>>18:55:58,843 INFO [XmlBeanDefinitionReader] Loading XML bean
>>definitions from c lass path resource
>>[org/springframework/jdbc/support/sql-error-codes.xml]
>>18:55:58,875 INFO [XmlBeanFactory] Creating shared instance
>>of singleton bean '
>>DB2'
>>
>>... and so on
>>
>>
>>Can anybody else duplicate this?
>>
>>Colin
>>
>>
>>
>>-------------------------------------------------------
>>This SF.Net email is sponsored by: InterSystems CACHE FREE
>>OODBMS DOWNLOAD - A multidimensional database that combines
>>robust object and relational technologies, making it a
>>perfect match for Java, C++,COM, XML, ODBC and JDBC.
>>www.intersystems.com/match8
>>_______________________________________________
>>Springframework-developer mailing list
>>Spr...@li...
>>https://lists.sourceforge.net/lists/listinfo/springframework-developer
>>
>>
>>
>>
>>
>>
>
>
>-------------------------------------------------------
>This SF.Net email is sponsored by: InterSystems CACHE
>FREE OODBMS DOWNLOAD - A multidimensional database that combines
>robust object and relational technologies, making it a perfect match
>for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
>_______________________________________________
>Springframework-developer mailing list
>Spr...@li...
>https://lists.sourceforge.net/lists/listinfo/springframework-developer
>
>
|
