RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-08 Thread Rupp, Heiko
p;atid=381174 Heiko > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Comtois, > Pierre > Sent: Wednesday, October 08, 2003 3:44 PM > To: '[EMAIL PROTECTED]' > Subject: RE: FW: [JBoss-user] Problem integrating MySql with

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-08 Thread Comtois, Pierre
ouillier [mailto:[EMAIL PROTECTED] Sent: October 7, 2003 9:12 PM To: [EMAIL PROTECTED] Subject: Re: FW: [JBoss-user] Problem integrating MySql with JBOSS Michael Klem wrote: > From MySQL version 4.0, InnoDB is enabled by default. So sql used to > create a db table will default to being an InnoDB t

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-08 Thread Comtois, Pierre
; in your CREATE TABLE statement as the above, then your table will have transaction support. * By default, AUTOCOMMIT is on. To turn it off, do "SET AUTOCOMMIT=0;". >Pierre Comtois >Business Acceleration Services, Solutions Consulting >45 O'Connor Street, Suite 500

Re: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Michael Klem
Forgot to mention, my interpretation of what the docs said is that you no longer need to specify a table type. MySQL will treat the tables as InnoDB tables as a default. Just my .02 At 9:50 PM -0700 10/7/03, Michael Klem wrote: Just quoting from the MySQL docs. I will verify for myself too. I a

Re: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Michael Klem
Just quoting from the MySQL docs. I will verify for myself too. I am using 4.0.14 At 9:12 PM -0400 10/7/03, Guy Rouillier wrote: Michael Klem wrote: From MySQL version 4.0, InnoDB is enabled by default. So sql used to create a db table will default to being an InnoDB table. To explicitly creat

Re: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Guy Rouillier
Michael Klem wrote: From MySQL version 4.0, InnoDB is enabled by default. So sql used to create a db table will default to being an InnoDB table. To explicitly create a table as InnoDB do this: CREATE TABLE CUSTOMER (A INT, B CHAR (20), INDEX (A)) TYPE = InnoDB; That has not been my experience

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Michael Klem
AIL PROTECTED] > > -Original Message- From: Adrian Brock [mailto:[EMAIL PROTECTED] Sent: October 7, 2003 11:01 AM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS Some guy had the same problem last week and resolved it, > but he seems to ha

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Adrian Brock
ess Acceleration Services, Solutions Consulting > >45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4 > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: [EMAIL PROTECTED] > > > > > > > -Original Message- > From: Adrian Brock [m

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Comtois, Pierre
: Adrian Brock [mailto:[EMAIL PROTECTED] Sent: October 7, 2003 11:01 AM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS Some guy had the same problem last week and resolved it, but he seems to have vanished from this list when somebody else has a prob

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Comtois, Pierre
#x27;Connor Street, Suite 500*Ottawa, Ontario K1P 1A4 >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: [EMAIL PROTECTED] > > -Original Message- From: Adrian Brock [mailto:[EMAIL PROTECTED] Sent: October 7, 2003 11:01 AM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Adrian Brock
> >45 O'Connor Street, Suite 500*Ottawa, Ontario K1P 1A4 > >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: [EMAIL PROTECTED] > > > > > > > -Original Message- > From: Adrian Brock [mailto:[EMAIL PROTECTED] > Sent: October 6, 2003 7:40 PM >

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Comtois, Pierre
o K1P 1A4 >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: [EMAIL PROTECTED] > > -Original Message- From: Adrian Brock [mailto:[EMAIL PROTECTED] Sent: October 6, 2003 7:40 PM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS On Mon,

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-07 Thread Comtois, Pierre
FAX: 613-567-6053 * E-Mail: [EMAIL PROTECTED] > > -Original Message- From: Adrian Brock [mailto:[EMAIL PROTECTED] Sent: October 6, 2003 7:40 PM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS On Mon, 2003-10-06 at 22:23, Comtois, Pierre w

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Adrian Brock
613-567-6053 * E-Mail: [EMAIL PROTECTED] > > > > > > > -Original Message- > From: Adrian Brock [mailto:[EMAIL PROTECTED] > Sent: October 6, 2003 4:56 PM > To: [EMAIL PROTECTED] > Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS > > > Wher

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Adrian Brock
053 * E-Mail: [EMAIL PROTECTED] > > > > > > > -Original Message- > From: Adrian Brock [mailto:[EMAIL PROTECTED] > Sent: October 6, 2003 4:56 PM > To: [EMAIL PROTECTED] > Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS > > > Wher

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Comtois, Pierre
> -Original Message- From: Adrian Brock [mailto:[EMAIL PROTECTED] Sent: October 6, 2003 4:56 PM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS Where did you get jbossmq-service.xml from? The persistence manager has been removed from tha

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Comtois, Pierre
Ottawa, Ontario K1P 1A4 >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: [EMAIL PROTECTED] > > -Original Message- From: Adrian Brock [mailto:[EMAIL PROTECTED] Sent: October 6, 2003 4:56 PM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql wit

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Comtois, Pierre
Ottawa, Ontario K1P 1A4 >Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: [EMAIL PROTECTED] > > -Original Message- From: Adrian Brock [mailto:[EMAIL PROTECTED] Sent: October 6, 2003 4:42 PM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql with JB

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Comtois, Pierre
Sent: October 6, 2003 4:13 PM To: '[EMAIL PROTECTED]' Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS I deleted hsqldb-ds.xml and changed jndi name. I'm looking at what I'd need to change ... My install didn't have any reference to persisten

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Adrian Brock
-conf.xml . u should make an entry like this. > > > > > > > >> "org.jboss.resource.security.ConfiguredIdentityLoginModule" > > flag = "required"> > > dummy > >

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Adrian Brock
>Ph: 613-787-4649 * FAX: 613-567-6053 * E-Mail: [EMAIL PROTECTED] > > > > > > > -----Original Message- > From: Comtois, Pierre > Sent: October 6, 2003 4:13 PM > To: '[EMAIL PROTECTED]' > Subject: RE: FW: [JBoss-user] Problem integrating MySql w

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Comtois, Pierre
* E-Mail: [EMAIL PROTECTED] > > -Original Message- From: Adrian Brock [mailto:[EMAIL PROTECTED] Sent: October 6, 2003 2:24 PM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS If you want it to be the default db you should remove hsqldb-ds.xml

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Adrian Brock
67-6053 * E-Mail: [EMAIL PROTECTED] > > > > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: October 6, 2003 10:51 AM > To: [EMAIL PROTECTED] > Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS > &g

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Comtois, Pierre
PROTECTED] [mailto:[EMAIL PROTECTED] Sent: October 6, 2003 10:51 AM To: [EMAIL PROTECTED] Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS Hi, i am able to connect successfully to MySQL usign JBoss. Here are the steps that u shoud follow: 1) copy the .xml file from ex

RE: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Marco.Mistroni
lto:[EMAIL PROTECTED] > Sent: 06 October, 2003 16:34 > To: [EMAIL PROTECTED] > Subject: Re: FW: [JBoss-user] Problem integrating MySql with JBOSS > > > Please keep discussions on jboss-user. > > Re-read what I wrote last time. You can find an example > mysql-ds.x

Re: FW: [JBoss-user] Problem integrating MySql with JBOSS

2003-10-06 Thread Adrian Brock
Please keep discussions on jboss-user. Re-read what I wrote last time. You can find an example mysql-ds.xml in ${jboss.home}/docs/examples/jca Regards, Adrian On Mon, 2003-10-06 at 14:27, Comtois, Pierre wrote: > Thx for fielding my question. > > I did as you suggested and renamed the mysql-se