RE: [Xdoclet-user] xPetStore v2.1 released

[Herve Tchepannou]

Title: RE: [Xdoclet-user] xPetStore v2.1 released

I haven't perform any performance test but, - hsqldb is very good for devellopement. but, probably not reliable in production environnement. - I found sapdb really cool, fast and reliable.. but, a little bit tricky to setup - PostgreSQL is ok.. but I've experience some problems with their JDBC driver (which I heard sucks) - For MSSQLServer, I've been using MS drivers.. I haven't experienced any problem with it.   I think the for performance, you have to consider 2 thinks: - The perf of the database - The quality of the driver -----Original Message----- From: Brian McSweeney [mailto:[EMAIL PROTECTED]] Sent: 09 January 2003 12:44 To: Herve Tchepannou; xdoclet Subject: Re: [Xdoclet-user] xPetStore v2.1 released Do you have any stats on which database performs best? Or maybe an opinion on which is the easiest / most reliable with J2EE? thanks, Brian ----- Original Message ----- From: Herve Tchepannou To: xdoclet Sent: Thursday, January 09, 2003 5:20 PM Subject: RE: [Xdoclet-user] xPetStore v2.1 released Nope.. I've try hsqldb,postgresql, sapdb, sql server. But you can easyly plug it to MySQL. It's just a a question of configuration -----Original Message----- From: Brian McSweeney [mailto:[EMAIL PROTECTED]] Sent: 09 January 2003 12:11 To: Herve Tchepannou Subject: Re: [Xdoclet-user] xPetStore v2.1 released Hi Herve, just wondering if you ever tried to use MySql as one of your databases for xpetstore? thanks, Brian   ----- Original Message ----- From: Herve Tchepannou To: xdoclet Sent: Wednesday, January 08, 2003 11:26 PM Subject: RE: [Xdoclet-user] xPetStore v2.1 released I'll look at that at home tonight. what you can do actually is: 1. Undeploy the application 2. Run manually the file XPETSTORE/src/petstore/sql/data.sql from your database console 3. Deploy the application 4. Run the test   -----Original Message----- From: Lukas Severin [mailto:[EMAIL PROTECTED]] Sent: 08 January 2003 15:26 To: Herve Tchepannou Subject: Re: [Xdoclet-user] xPetStore v2.1 released Yes I did run the tests. All tests manipulating products and shopping carts failed. I could create a user account (I checked that directly in the db) though. I got no errors building or deploying the app. The db containd no products when I checked, explaining the testfailures.   So its quite mysterious. Ill continue debugging :)   ----- Original Message ----- From: Herve Tchepannou To: xdoclet Sent: Wednesday, January 08, 2003 7:49 PM Subject: RE: [Xdoclet-user] xPetStore v2.1 released I've you check hsql after deploying the application? I suggest you to deploy the application and run de test case by browsing to http://localhost:8080/xpetstore-test/TestServlet(I mispelled it in the site) If this you have any failure, let me know. If you have no failure, then the db is full, so you can browse to http://localhost:8080/xpetstore to run the webapp   -----Original Message----- From: Lukas Severin [mailto:[EMAIL PROTECTED]] Sent: 08 January 2003 13:00 To: Herve Tchepannou Subject: Re: [Xdoclet-user] xPetStore v2.1 released Thanks,  I understand this, but the products in data.sql arent in the database when I check directly using the hsql qui tool. Any hints ?   ----- Original Message ----- From: Herve Tchepannou To: xdoclet Sent: Wednesday, January 08, 2003 2:36 PM Subject: [Xdoclet-user] xPetStore v2.1 released sql/sapdb/create_db script is a special case for SAPDB because the process for creating a database is a little bit trickier that hsqldb (where the database is already created), that's why you don't need sql/hsqldb/create_db. If you are not using sapdb, don't bother with that script.   But, when you are going to deploy the app to JBoss or WebLogic, the app server will create all the table for you abd the build script will fill the database with data -----Original Message----- From: Lukas Severin [mailto:[EMAIL PROTECTED]] Sent: 07 January 2003 19:55 To: Herve Tchepannou Subject: Re: [Xdoclet-user] xPetStore v2.1 released Sorry for disturbing you again with another stupid question :) I cannot find out how the initial data in sql/data.sql  get into the db.  Where is this defined  ? In java source or in some deployment descriptor ? There is an sql/sapdb/create_db script also,  but no corresponding sql/hsqldb/create_db script.   My basic problem is that the initial data isnt loaded when I startup jboss using hsqldb as db.   Suggestions ?   Tanks !