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