|
Thanks Herve,
I'm going to set it up with mySql.
I have another little question if you don't mind.
In deploying to jboss, you have set the jboss deploy
directory to
${jboss.home.dir}/server/xpetstore/deploy
I was wondering why. I was under the impression
that most applications got deployed to
${jboss.home.dir}/server/default/deploy
Could you explain the reasons for
this?
thanks again,
Brian
----- Original Message -----
Sent: Thursday, January 09, 2003 7:03
PM
Subject: 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
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 -----
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
Hi Herve,
just wondering if you ever tried to use
MySql as one of your databases for xpetstore?
thanks,
Brian
----- Original Message -----
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
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 -----
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?
If this you have any failure, let me
know.
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 -----
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
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
!
|
