Daniel,
I'm sorry to disturb you again but i'm still in troubles with JBoss, MySql,
Hypersonic and table creation.
So I think you can suggest me something useful about it.
I remember you, I wrote you last week explaining some trouble I had with
table creation with JBoss and MySql.
I tried to download newer JBoss binary version. Now I've installed 2.0 PROD3
but my troubles still exist.
In particular I tried to change Db using Hypersonic but I can't see the
tables!!
In particular JBoss deploys my jar file and creates the db file .script that
looks like this:
CREATE TABLE MACHINEGROUPS(GROUPID INTEGER, ...., RECID INTEGER)
CREATE TABLE LOTS(ID VARCHAR, ....., OUTPLANT INTEGER)
.....
/*C1*/CONNECT USER sa PASSWORD ""
SET AUTOCOMMIT FALSE
ROLLBACK
ROLLBACK
.......
ROLLBACK
ROLLBACK
And I don't see any table!! There are no .rec files in jboss/bin directory.
The same happens if I use MySql, while if I use InstantDb the tables are
correctly created.
What's going on?
----- Original Message -----
From: "Daniel Schulze" <[EMAIL PROTECTED]>
To: "jBoss Developer" <[EMAIL PROTECTED]>
Sent: Tuesday, October 17, 2000 3:54 PM
Subject: Re: [jBoss-Dev] JBoss and MySql
> On Tuesday 17 October 2000 14:41, Marco Pappalardo wrote:
> > In my jboss\uninstallerData\Install.log
> > i found this line
> > com.zerog.ia.installer.Installer en jBoss2.0_pr4_BETA
>
> this would be a quite old version?!
> You should try a newer one!
>
> > I also found in my directory
> > jboss\bin
> > a group of files having <Mytablename>.rec name! I found a file
> > "mydatabasename.property" containing the following text:
> > #Hypersonic SQL database
> >
> > #Tue Oct 17 14:45:56 MDT 2000
> >
> > version=1.4
> >
> > modified=yes
> >
> > It's clear that hypersonic SQL is woking instead of mySQL. Why? Why I
can
> > find one of my tables into the correct database while others were in
> > jboss\bin directory?
>
> Hypersonic is using the jboss/bin dir for its data, so what you see there
is
> the Hypersonic database (checkout the file <mydatabasename>.script).
>
> On deploy jBoss uses the <datasource></datasource> that is specified in
the
> jaws.xml file of your ejb.jar. If there is no jaws.xml file he uses the
> default datasource (should be the first registered one = Hypersonic).
>
> Checkout a newer jBoss!
>
> \Daniel
>
