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