Fw: [Springframework-developer] petclinic, hsqldb, & jboss

[Rajeev K. <Ra...@cu...>]

----- Original Message -----=20
From: Rajeev Kaul=20
To: JP Pawlak=20
Sent: Monday, July 28, 2003 6:45 PM
Subject: Re: [Springframework-developer] petclinic, hsqldb, & jboss


Hi Jean-Pierre,

This certainly helps.  I got the petclinic app to work under Jboss3.2.1. =
 However, I get the following error during jboss startup:

Depends On Me: jboss.mq:service=3DSecurityManager

jboss.mq.destination:service=3DQueue,name=3DDLQ

jboss.mq.destination:service=3DTopic,name=3DtestTopic

jboss.mq.destination:service=3DTopic,name=3DsecuredTopic

jboss.mq.destination:service=3DTopic,name=3DtestDurableTopic

jboss.mq.destination:service=3DQueue,name=3DtestQueue

jboss.mq.destination:service=3DQueue,name=3DA

jboss.mq.destination:service=3DQueue,name=3DB

jboss.mq.destination:service=3DQueue,name=3DC

jboss.mq.destination:service=3DQueue,name=3DD

jboss.mq.destination:service=3DQueue,name=3Dex

, ObjectName: jboss.mq:service=3DMessageCache

state: FAILED

I Depend On:=20

Depends On Me: jboss.mq:service=3DPersistenceManager

org.jboss.deployment.DeploymentException: No property editor for =
attribute: CacheStore; type=3Dclass javax.management.ObjectName, =
ObjectName: jboss.mq:service=3DPersistenceManager



However, it does not seem to affect the petclinic application.  If I =
remove the petclinic app from the deployment dir, I do not get this =
message.  So, somehow, the petclinic app with hsqldb causes this =
problem.



Also, I noticed the following:

1.  The petclinic build does not automatically copy the =
hsql-petclinic-ds.xml to the deploy directory.

2. The web.xml does not contain the following information:

<resource-ref>

<res-ref-name>jdbc/petclinicHSQL</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

</resource-ref>

<resource-ref>

<res-ref-name>jdbc/petclinicMYSQL</res-ref-name>

<res-type>javax.sql.DataSource</res-type>

<res-auth>Container</res-auth>

</resource-ref>

3.  The "DROP TABLE" sql commands cause a problem, when you run the =
script the first time.  I had to comment them out from the build.xml in =
the db dir for the 1st build. In subsequent builds it worked fine.



I just thought I would give you some feedback on these issues.



Rajeev

  ----- Original Message -----=20
  From: JP Pawlak=20
  To: 'Rajeev Kaul' ; spr...@li...=20
  Sent: Saturday, July 26, 2003 6:56 AM
  Subject: RE : [Springframework-developer] petclinic, hsqldb, & jboss


  Hi Rajeev,



  As you can see in my PetClinic post, we will fix the Jboss issues for =
Petclinic. It will be done for the 0.9.1 which should be released early =
next week.

  For now, you can check the new elements in the CVS under =
main/samples/petclinic.



  Regards,

  Jean-Pierre



  -----Message d'origine-----
  De : spr...@li... =
[mailto:spr...@li...] De la =
part de Rajeev Kaul
  Envoy=E9 : samedi 26 juillet 2003 02:43
  =C0 : spr...@li...
  Objet : [Springframework-developer] petclinic, hsqldb, & jboss



  I am having trouble running the petclinic app with hsqldb & jboss =
3.0.7.  On stepping through the code, I found that after getting the =
connection in the DriverManagerDatasource class, it hangs on the =
following statement:





  con.setAutoCommit(true);





  public Connection getConnection(String username, String password) =
throws SQLException {

  logger.info("Creating new JDBC connection: " + this.url);

  Connection con =3D getConnectionFromDriverManager(this.url, username, =
password);

  con.setAutoCommit(true);

  return con;

  }



  I did start hsqldb before I started jboss using server.bat.  I also =
checked with manager.bat to see if the data is loaded.

  Any ideas???



  Rajeev