Menu
▾
▴
RE: [Springframework-developer] Spring + MySQL + JDBC or Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6
|
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
|
