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

<wishfulthinking>
Or JBoss could make their classloader behave like every other app
server without jumping through hoops.
</wishfulthinking>

I can't wait for the J2EE 1.5/5.0 spec to clarify classloader
behavior, as I understand they are going to.

Patrick

On Sat, 13 Nov 2004 10:17:46 -0500, Colin Sampaleanu <col...@ex...> wr=
ote:
> 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.
>=20
> 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...
>=20
>=20
>=20
> 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 bran=
ch. 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 vers=
ions used in applications too, unless the JBoss-provided jars get removed f=
rom the server lib directory...
> >
> >Juergen
> >
> >
> >________________________________
> >
> >Von: spr...@li... im Auftrag vo=
n Colin Sampaleanu
> >Gesendet: Sa 13.11.2004 15:47
> >An: spr...@li...
> >Betreff: Re: [Springframework-developer] Spring + MySQL + JDBC or Hibern=
ate, 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=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
> -------------------------------------------------------
> 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