Re: [Springframework-developer] Spring + MySQL + JDBC or Hibernate, ok in JBoss 3.2.5, hang in JBos

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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
>  
>

Re: [Springframework-developer] Spring + MySQL + JDBC or Hibernate, ok in JBoss 3.2.5, hang in JBos

Re: [Springframework-developer] Spring + MySQL + JDBC or Hibernate, ok in JBoss 3.2.5, hang in JBoss 3.2.6