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

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

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

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

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