RE: [JBoss-user] a to cmp

2003-10-29 Thread Comtois, Pierre
Title: Message



I 
started using Lomboz ... http://www.objectlearn.com/index.html 
not sure if it can create cmps from DB but it seems to be a good tool to 
investigate.
 
 
 
Pierre 
Comtois Business 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: Eric J Kaplan 
  [mailto:[EMAIL PROTECTED] Sent: October 29, 2003 9:06 
  AMTo: [EMAIL PROTECTED]Subject: 
  [JBoss-user] a to cmp
  
  All
   
  Anyone know of a good product (or eclipse plugin) that I can point at my database and have it 
  generate cmp entity beans (files with xdoclet tags would be ok).  Yes, I realize I'll have to tweak the 
  files afterward, but there's a lot of this that can be 
  automated.
   
  Regards
   
  Eric J. 
  Kaplan
  Armanta, 
  Inc.
  350 Mt. Kemble 
  Ave.
  Morristown, 
  NJ 
  07960
   


RE: [JBoss-user] Newbee! Jboss how to needed !!

2003-10-29 Thread Comtois, Pierre
You'll find what you need here ... See the JB Quick Start ... Excellent doco

http://sourceforge.net/docman/?group_id=22866


>Pierre Comtois
>Business 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: October 29, 2003 6:10 AM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] Newbee! Jboss how to needed !!



> Could any give any pointers about How to's , Getting started 
> documentations ??

I'm a newbie too and I've been working through
http://www.mastertech.net/spumer/Jboss%203%20step-by-step.pdf

Hopefully others will provide more :-)

Cheers
J




---
This SF.net email is sponsored by: SF.net Giveback Program. Does
SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?   SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] Warnings on Server Startup

2003-10-14 Thread Comtois, Pierre
I had same with 3.2.2 and Scott Stark of JBoss told me they shouldn't be
warnings and can be ignored.


>Pierre Comtois
>Business 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: Rich Reese [mailto:[EMAIL PROTECTED] 
Sent: October 13, 2003 3:16 PM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] Warnings on Server Startup


I get the following Warning messages when I start my JBoss 3.2.1 server.  Do
I need to worry about these warnings or can anyone tell me how to remedy the
issues?

Maximize your mail reader window to make it easier to read the warning
messages.

13:32:38,177 WARN  [MainDeployer] The manifest entry in
file:/D:/jboss-3.2.1/server/all/deploy/jboss-net.sar/commons-logging.jar
references URL
file:/D:/jboss-3.2.1/server/all/deploy/jboss-net.sar/log4j.jar which could
not be opened, entry ignored 13:32:38,187 WARN  [MainDeployer] The manifest
entry in
file:/D:/jboss-3.2.1/server/all/deploy/jboss-net.sar/commons-logging.jar
references URL
file:/D:/jboss-3.2.1/server/all/deploy/jboss-net.sar/log4j-core.jar
which could not be opened, entry ignored
13:32:41,241 WARN  [MainDeployer] The manifest entry in
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/bootstrap.jar
references URL
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/commons-daemon.ja
r
which could not be opened, entry ignored
13:32:41,331 WARN  [MainDeployer] The manifest entry in
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/commons-logging.j
ar
references URL
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/log4j.jar
which could not be opened, entry ignored
13:32:41,331 WARN  [MainDeployer] The manifest entry in
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/commons-logging.j
ar
references URL
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/log4j-core.jar
which could not be opened, entry ignored
13:32:42,403 WARN  [MainDeployer] The manifest entry in
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/tomcat-jk2.jar
references URL
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/workers.jar
which could not be opened, entry ignored
13:32:42,403 WARN  [MainDeployer] The manifest entry in
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/tomcat-jk2.jar
references URL file:/D:/jboss-3.2.1/server/all/deploy/classes/ which could
not be opened, entry ignored 13:32:42,403 WARN  [MainDeployer] The manifest
entry in
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/tomcat-jk2.jar
references URL
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/log4j.jar
which could not be opened, entry ignored
13:32:42,653 WARN  [MainDeployer] The manifest entry in
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/tomcat-util.jar
references URL
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/log4j.jar
which could not be opened, entry ignored
13:32:42,653 WARN  [MainDeployer] The manifest entry in
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/tomcat-util.jar
references URL
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/log4j-core.jar
which could not be opened, entry ignored
13:32:42,653 WARN  [MainDeployer] The manifest entry in
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/tomcat-util.jar
references URL
file:/D:/jboss-3.2.1/server/all/deploy/jbossweb-tomcat.sar/mx4j.jar
which could not be opened, entry ignored



Thanks,
Rich


---
This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net
hosts over 70,000 Open Source Projects. See the people who have HELPED US
provide better services: Click here: http://sourceforge.net/supporters.php
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] setDelegate warning with EmbeddedTomcatService a nd other warnings

2003-10-14 Thread Comtois, Pierre
Thx ...


>Pierre Comtois
>Business 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: Scott M Stark [mailto:[EMAIL PROTECTED] 
Sent: October 11, 2003 1:18 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] setDelegate warning with EmbeddedTomcatService and
other warnings


All can be ignored and should probably not be warnings.

-- 

Scott Stark
Chief Technology Officer
JBoss Group, LLC
xxxxxxxxxxxx

Comtois, Pierre wrote:

> I'm running JB 3.2.2RC4 with embedded TC 4.1.27 on XP Pro. I can start 
> JBOSS without errors and can run the JMX-console fine, but I do get 
> the following warnings and want to know if it is something I need to 
> worry about:



---
This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net
hosts over 70,000 Open Source Projects. See the people who have HELPED US
provide better services: Click here: http://sourceforge.net/supporters.php
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


[JBoss-user] setDelegate warning with EmbeddedTomcatService and other warnings

2003-10-10 Thread Comtois, Pierre
I'm running JB 3.2.2RC4 with embedded TC 4.1.27 on XP Pro. I can start JBOSS
without errors and can run the JMX-console fine, but I do get the following
warnings and want to know if it is something I need to worry about:

09:24:07,550 INFO  [EmbeddedTomcatService] OK
09:24:07,550 INFO  [MainDeployer] Adding deployer:
org.jboss.web.tomcat.tc4.Embe
[EMAIL PROTECTED]
09:24:07,550 INFO  [MainDeployer] Starting deployment of package:
file:/C:/jboss  
-3.2.2RC4/server/default/deploy/http-invoker.sar/invoker.war/
09:24:07,881 INFO  [EmbeddedTomcatService] deploy, ctxPath=/invoker,
warUrl=file
:/C:/jboss-3.2.2RC4/server/default/deploy/http-invoker.sar/invoker.war/
09:24:08,512 INFO  [Engine] ContextConfig[/invoker]: Added certificates ->
reque
st attribute Valve
09:24:08,562 INFO  [Engine] ContextConfig[/invoker]: Configured an
authenticator
 for method BASIC
09:24:08,582 WARN  [EmbeddedTomcatService] Unable to invoke setDelegate on
class
 loader:[EMAIL PROTECTED]
09:24:08,582 INFO  [Engine] StandardManager[/invoker]: Seeding random number
gen
erator class java.security.SecureRandom
09:24:09,423 INFO  [Engine] StandardManager[/invoker]: Seeding of random
number
generator has been completed
09:24:09,513 INFO  [Engine] StandardWrapper[/invoker:default]: Loading
container
 servlet default

I looked at the JBOSS Class Loading document and the archives but found
nothing about it. Could someone telll me what the message means and what
might it imply ?

I also get the following warnings before the above listing in case they're
related... they are complaints about manifest file referencing jar files
that are not there and the default/deploy/classes folder that is not there
either.. I'm not sure if I need to manually copy them in the locations
complained about.

09:24:05,557 INFO  [SARDeployer] nested deployment:
file:/C:/jboss-3.2.2RC4/serv  
er/default/deploy/jbossweb-tomcat41.sar/tomcat-jk2.jar
09:24:05,577 INFO  [SARDeployer] nested deployment:
file:/C:/jboss-3.2.2RC4/serv  
er/default/deploy/jbossweb-tomcat41.sar/tomcat-util.jar
09:24:05,598 INFO  [SARDeployer] nested deployment:
file:/C:/jboss-3.2.2RC4/serv  
er/default/deploy/jbossweb-tomcat41.sar/tomcat41-service.jar
09:24:05,708 WARN  [MainDeployer] The manifest entry in
file:/C:/jboss-3.2.2RC4/  
server/default/deploy/jbossweb-tomcat41.sar/bootstrap.jar references URL
file:/C  
:/jboss-3.2.2RC4/server/default/deploy/jbossweb-tomcat41.sar/commons-daemon.
jar
which could not be opened, entry ignored
09:24:05,878 WARN  [MainDeployer] The manifest entry in
file:/C:/jboss-3.2.2RC4/  
server/default/deploy/jbossweb-tomcat41.sar/tomcat-util.jar references URL
file:
/C:/jboss-3.2.2RC4/server/default/deploy/jbossweb-tomcat41.sar/log4j.jar
which c
ould not be opened, entry ignored
09:24:05,878 WARN  [MainDeployer] The manifest entry in
file:/C:/jboss-3.2.2RC4/  
server/default/deploy/jbossweb-tomcat41.sar/tomcat-util.jar references URL
file:
/C:/jboss-3.2.2RC4/server/default/deploy/jbossweb-tomcat41.sar/log4j-core.ja
r wh
ich could not be opened, entry ignored
09:24:05,878 WARN  [MainDeployer] The manifest entry in
file:/C:/jboss-3.2.2RC4/  
server/default/deploy/jbossweb-tomcat41.sar/tomcat-util.jar references URL
file:
/C:/jboss-3.2.2RC4/server/default/deploy/jbossweb-tomcat41.sar/mx4j.jar
which co
uld not be opened, entry ignored
09:24:05,928 WARN  [MainDeployer] The manifest entry in
file:/C:/jboss-3.2.2RC4/  
server/default/deploy/jbossweb-tomcat41.sar/tomcat-jk2.jar references URL
file:/  
C:/jboss-3.2.2RC4/server/default/deploy/jbossweb-tomcat41.sar/workers.jar
which
could not be opened, entry ignored
09:24:05,928 WARN  [MainDeployer] The manifest entry in
file:/C:/jboss-3.2.2RC4/  
server/default/deploy/jbossweb-tomcat41.sar/tomcat-jk2.jar references URL
file:/  
C:/jboss-3.2.2RC4/server/default/deploy/classes/ which could not be opened,
entr
y ignored
09:24:05,938 WARN  [MainDeployer] The manifest entry in
file:/C:/jboss-3.2.2RC4/  
server/default/deploy/jbossweb-tomcat41.sar/tomcat-jk2.jar references URL
file:/  
C:/jboss-3.2.2RC4/server/default/deploy/jbossweb-tomcat41.sar/log4j.jar
which co
uld not be opened, entry ignored
09:24:06,068 WARN  [MainDeployer] The manifest entry in
file:/C:/jboss-3.2.2RC4/  
server/default/deploy/jbossweb-tomcat41.sar/commons-logging.jar references
URL f
ile:/C:/jboss-3.2.2RC4/server/default/deploy/jbossweb-tomcat41.sar/log4j.jar
whi
ch could not be opened, entry ignored
09:24:06,068 WARN  [MainDeployer] The manifest entry in
file:/C:/jboss-3.2.2RC4/  
server/default/deploy/jbossweb-tomcat41.sar/commons-logging.jar references
URL f
ile:/C:/jboss-3.2.2RC4/server/default/deploy/jbossweb-tomcat41.sar/log4j-cor
e.ja
r which could not be opened, entry ignored
09:24:06,449 WARN  [MainDeployer] The manifest entry in
file:/C:/jboss-3.2.2RC4/  
server/default/deploy/jbossweb-tomcat41.sar/ant.jar references URL
file:/C:/jbos  
s-3.2.2RC4/server/default/deploy/jbossweb-tomcat41.sar/xml-apis.jar which
could
not be opened, entry ignored
09:24:0

RE: [JBoss-user] HSQLDB

2003-10-09 Thread Comtois, Pierre
I'm using 3.2.2RC4 with embedded Tomcat which I guess doesn't have that
folder. I'll look for something similar.


>Pierre Comtois
>Business 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: Rafal Kedziorski [mailto:[EMAIL PROTECTED] 
Sent: October 8, 2003 5:31 PM
To: [EMAIL PROTECTED]; '[EMAIL PROTECTED]'
Subject: RE: [JBoss-user] HSQLDB


At 11:41 08.10.2003 -0400, Comtois, Pierre wrote:
>I don not have any such folder. I am using 3,2,2RC4 ... Are you as well 
>? Where is yours located ?

in the system TMP folder. at the same place Jetty stores own files. but 
this can be configured.


Regards,
Rafal 



---
This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net
hosts over 70,000 Open Source Projects. See the people who have HELPED US
provide better services: Click here: http://sourceforge.net/supporters.php
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


RE: [JBoss-user] HSQLDB

2003-10-08 Thread Comtois, Pierre
I don not have any such folder. I am using 3,2,2RC4 ... Are you as well ?
Where is yours located ?


>Pierre Comtois
>Business 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: Rafal Kedziorski [mailto:[EMAIL PROTECTED] 
Sent: October 8, 2003 11:11 AM
To: [EMAIL PROTECTED]
Subject: [JBoss-user] HSQLDB


hi,

HSQLDB creates an thm folder named hsperfdata_jboss. Where can be set, 
where HSQLDB should store this data.


Regards,
Rafal



---
This SF.net email is sponsored by: SF.net Giveback Program. SourceForge.net
hosts over 70,000 Open Source Projects. See the people who have HELPED US
provide better services: Click here: http://sourceforge.net/supporters.php
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


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

2003-10-08 Thread Comtois, Pierre
Same for me ...


>Pierre Comtois
>Business 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: Guy Rouillier [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 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.  I have MySQL 4 on both Windows 2000 
and Linux, and if I don't specify a type, tables end up as MyISAM.
-- 
Guy Rouillier




---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf ___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user


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

2003-10-08 Thread Comtois, Pierre
For InnoDB, simply add "type=InnoDB" at the end of the create statement ...
CREATE TABLE tableX (.) type=InnoDB

I realized that about the Hypersonic bean after I sent my reply ... Am I
right in thinking that I can setup the Hypersonic GUI to open my MySql DB
when it open ... I see there is a setting called  set to "default"
and I suspect that is what I have to change for that to happen.

On a related topic, if I choose "Connect" from the File-Connect, I do not
see an entry for the MySql configuration I have ... I have to select
MM.MySql and modify the settings (which never get saved). What file would I
need to modify so I don't need to re-enter that information ?

Here are notes you might find useful. I've compiled them from all over the
web about setting up MySql for InnoDB ... I'm documenting all the steps so
it's repeatable.

MySql InnoDB Configuration

- Run winmysqladmin.exe (under bin subfolder):
1. First time (when my.ini does not exist under Windows directory, e.g.
C:\WinNT), you will be prompted for username/password. Enter your choice

 

2. Its window will come up and then minimize into System Tray. Bring it up
by:
Right click on System Tray icon -> Option "Show me".
3. By default, "mysqld" is used which has only ISAM, which does NOT support
transaction. To use "mysqld-max" with InnoDB or BDB enabled (supporting
transactions), configure my.ini as following:
Select tab "my.ini Setup" -> Select "mysqld-max" -> In editor for my.ini:
[mysqld]
...
[WinMySQLadmin]
...
Add the following before line "[WinMySQLadmin]", 
innodb_data_home_dir = C:\mysql\ibdata
innodb_data_file_path = ibdata1:500M;ibdata2:500M
set-variable = innodb_buffer_pool_size=70M
set-variable = innodb_additional_mem_pool_size=10M
innodb_log_group_home_dir = C:\mysql\iblogs
innodb_log_arch_dir = C:\mysql\iblogs
innodb_log_archive=0
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=10M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
* The above specifies that two 500MB database files be created at
C:\mysql3.23\ibdata, and three 10MB log files created at
C:\mysql3.23\iblogs.
Then click "Save Modification" to save the changes into my.ini (under e.g.
C:\WinNT).

4. Manually create the folder  and  (in
the above example, it's C:\mysql\ibdata and C:\mysql\iblogs).

5. Start the server ("mysql" service):
Right click on the window -> Option "Win NT" -> item "Install the service"
Then Right click again -> Option "Win NT" -> item "Start the service".
It will take a moment to create the database files and log files as
configured.


Test the configuration:
1. Make sure service "Mysql" is started.
2. Try to login.
- Open a Command window, try "mysql -u  -p". You'll be prompted
for password (use the one you specified in my.ini, e.g.
/).
- You are in mysql console. Try SQL "SELECT user();" or "SELECT 1+1;". (Be
sure to end your SQL with semicolon.)
3. Add a user - username "", and password "".
In mysql console, enter SQL - GRANT ALL PRIVILEGES ON test.* TO
@localhost IDENTIFIED BY '';
4. Login to database "test" as user "":
- In DOS, enter "mysql -u  -p test" (Note: test here is the
database name, NOT the password. Password will be prompted.)
- After giving password, you should be in test as :
- Try "SELECT user();" and you should get "@localhost".
- Try creating a table and put some data:
CREATE TABLE table1 (id INTEGER NOT NULL, data VARCHAR(100),PRIMARY KEY
(id)) type=InnoDB;
INSERT INTO table1 (id, data) VALUES (1, 'one');
INSERT INTO table1 (id, data) VALUES (2, 'two');
INSERT INTO table1 (id, data) VALUES (3, 'three');
SELECT * FROM table1; 
Note: 
* The default CREATE TABLE creates table as type ISAM, which does not
support transaction. Include clause "type=InnoDB" 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*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 4:25 PM
To: [EMAIL PROTECTED]
Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS


On Tue, 2003-10-07 at 19:37, Comtois, Pierre wrote:
> Finally resolved the exception issue:
> 
> 1. I created the tables manually and for my appl. Made them of type 
> InnoDB
>

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

2003-10-07 Thread Comtois, Pierre
Finally resolved the exception issue:

1. I created the tables manually and for my appl. Made them of type InnoDB

2. I gave SELECT permission to my user to the mysql database so it could
access its permission table. I'm a novice at MySql as well so I might have
messed that up myself :-)

3. I had put my computer name in the mysql-ds connection-url attribute ... I
put it back to localhost

ps: I would have thought that it would be better to specify a computer name
as opposed to localhost ... ?


Next item up for bid ... I want to access the newly configured DB using the
JBoss console ( http://localhost:8080/jmx-console/index.jsp ). Seems that
now I have no link in jmx-console to access the Hypwersonic service ... The
link to it is gone ...
Is this normal ? Am I missing something ? My thought is that I have to
configures the jmx ...

Looking at displayMBeans.jsp, that the mbean is missing in the MBeanData
array ...
<%
  MBeanData[] data = domainData.getData();
  for(int d = 0; d < data.length; d ++)
  {
 String name = data[d].getObjectName().toString();
 String properties = data[d].getNameProperties();
%>
  <%= URLDecoder.decode(properties) %>
<%


Ideas ?

>Pierre Comtois
>Business 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 [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 problem. :-(

On Tue, 2003-10-07 at 15:34, Comtois, Pierre wrote:
> Making progress ... but ever s-o-o-o-o slowly !
> 
> It would seem that the persistence tables specified by the 
> mysql-jdbc2-service.xml file are not getting creating resulting in 
> connection errors on startup. I found nothing in the archives that 
> helped ...
> 
>   CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID 
> INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, 
> TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
>   CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
>   CREATE_TABLES_ON_STARTUP = TRUE
> 
> What could be preventing these from getting created ... I've now 
> changed user temporarily to root to remove authorization issues from 
> the equation. If I have to, I'll create them by hand, but this likely 
> indicates another problem.
> 

Please wait... I'm trying to hack your machine so I can see the error
message. :-)

> P.S. Is there an up-to-date document anywhere that details how to 
> integrate MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff with Google 
> but haven't found anything up-to-date and accurate. I'm setting up a 
> pc with around 12 different development modules/tools and this piece 
> is taking much more time than it should/can afford to get going on the 
> actual development phase. Maybe what I want to do is a rarity, but I 
> don't think it is. A short white paper would cost cycles initially, 
> but would likely pay off over the long haul.
> 

Remove mysql-jdbc2.xml and use the file version.
Come back to it when you are sure mysql works.

I'm currently preparing an enhanced jbossmq section for the admin docs with
the 3.2.2 release.

Regards,
Adrian

> 
> >Pierre Comtois
> >Business 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 [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 wrote:
> > Default install puts it in  ... It's dated June 10/2003 ...
> > 
> 
> Ok, so you are using 3.2.1?
> 
> Copy the SQL Properties from the mysql-jdbc2-service.xml
> into jbossmq-service.xml - replacing the hsqldb sql properties.
> 
> Where is the difficulty?
> There is an MBean called the PersistenceManager that
> takes a parameter called SQLProperties.
> By default it references DefaultDS and uses hsqldb sql.
> You need to change it to match your jndi name and mysql sql statements.
> 
> It is harder with 3.2.1
> 
> With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml
> and replace it with mysql-jdbc2-service.xml
> 
> Regards,
> Adrian
> 
> > 
> > >

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

2003-10-07 Thread Comtois, Pierre
I found a reference where a user ended up creating them manually which I'm
thinking of doing to go forward. If that doesn't work, then I'll use the
file method, but I hate giving up on it ...


>Pierre Comtois
>Business 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 [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 problem. :-(

On Tue, 2003-10-07 at 15:34, Comtois, Pierre wrote:
> Making progress ... but ever s-o-o-o-o slowly !
> 
> It would seem that the persistence tables specified by the 
> mysql-jdbc2-service.xml file are not getting creating resulting in 
> connection errors on startup. I found nothing in the archives that 
> helped ...
> 
>   CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID 
> INTEGER NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, 
> TXOP CHAR(1), MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
>   CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
>   CREATE_TABLES_ON_STARTUP = TRUE
> 
> What could be preventing these from getting created ... I've now 
> changed user temporarily to root to remove authorization issues from 
> the equation. If I have to, I'll create them by hand, but this likely 
> indicates another problem.
> 

Please wait... I'm trying to hack your machine so I can see the error
message. :-)

> P.S. Is there an up-to-date document anywhere that details how to 
> integrate MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff with Google 
> but haven't found anything up-to-date and accurate. I'm setting up a 
> pc with around 12 different development modules/tools and this piece 
> is taking much more time than it should/can afford to get going on the 
> actual development phase. Maybe what I want to do is a rarity, but I 
> don't think it is. A short white paper would cost cycles initially, 
> but would likely pay off over the long haul.
> 

Remove mysql-jdbc2.xml and use the file version.
Come back to it when you are sure mysql works.

I'm currently preparing an enhanced jbossmq section for the admin docs with
the 3.2.2 release.

Regards,
Adrian

> 
> >Pierre Comtois
> >Business 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 [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 wrote:
> > Default install puts it in  ... It's dated June 10/2003 ...
> > 
> 
> Ok, so you are using 3.2.1?
> 
> Copy the SQL Properties from the mysql-jdbc2-service.xml
> into jbossmq-service.xml - replacing the hsqldb sql properties.
> 
> Where is the difficulty?
> There is an MBean called the PersistenceManager that
> takes a parameter called SQLProperties.
> By default it references DefaultDS and uses hsqldb sql.
> You need to change it to match your jndi name and mysql sql statements.
> 
> It is harder with 3.2.1
> 
> With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml
> and replace it with mysql-jdbc2-service.xml
> 
> Regards,
> Adrian
> 
> > 
> > >Pierre Comtois
> > >Business 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 [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 that file.
> > It is now in x-jdbc2-service.xml
> > 
> > Supposedly to make it easier to drop in a different implementation
> > like you are trying :-)
> > 
> > Regards,
> > Adrian
> > 
> > On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote:
> 

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

2003-10-07 Thread Comtois, Pierre
Making progress ... but ever s-o-o-o-o slowly !

It would seem that the persistence tables specified by the
mysql-jdbc2-service.xml file are not getting creating resulting in
connection errors on startup. I found nothing in the archives that helped
...

  CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES (MESSAGEID INTEGER
NOT NULL, DESTINATION VARCHAR(150) NOT NULL, TXID INTEGER, TXOP CHAR(1),
MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION))
  CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS (TXID INTEGER)
  CREATE_TABLES_ON_STARTUP = TRUE

What could be preventing these from getting created ... I've now changed
user temporarily to root to remove authorization issues from the equation.
If I have to, I'll create them by hand, but this likely indicates another
problem.

P.S. Is there an up-to-date document anywhere that details how to integrate
MySQL 4.x with JBOSS 3.2.2RC4? I've found stuff with Google but haven't
found anything up-to-date and accurate. I'm setting up a pc with around 12
different development modules/tools and this piece is taking much more time
than it should/can afford to get going on the actual development phase.
Maybe what I want to do is a rarity, but I don't think it is. A short white
paper would cost cycles initially, but would likely pay off over the long
haul.


>Pierre Comtois
>Business 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 [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 wrote:
> Default install puts it in  ... It's dated June 10/2003 ...
> 

Ok, so you are using 3.2.1?

Copy the SQL Properties from the mysql-jdbc2-service.xml
into jbossmq-service.xml - replacing the hsqldb sql properties.

Where is the difficulty?
There is an MBean called the PersistenceManager that
takes a parameter called SQLProperties. 
By default it references DefaultDS and uses hsqldb sql.
You need to change it to match your jndi name and mysql sql statements.

It is harder with 3.2.1

With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml 
and replace it with mysql-jdbc2-service.xml

Regards,
Adrian

> 
> >Pierre Comtois
> >Business 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 [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 that file.
> It is now in x-jdbc2-service.xml
> 
> Supposedly to make it easier to drop in a different implementation 
> like you are trying :-)
> 
> Regards,
> Adrian
> 
> On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote:
> > I've also copied mysql-jdbc2-service.xml from the examples to the 
> > deploy/jms folder and deleted the hsql version.
> > 
> > I'm still getting an error:
> > 
> > 16:41:14,011 INFO  [MainDeployer] Starting deployment of package: 
> > file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml
> > 16:41:14,322 INFO  [ServiceConfigurator] Problem configuring service 
> > jboss.mq:service=PersistenceManager
> > org.jboss.deployment.DeploymentException: Exception setting attribute
> > javax.management.Attribute: name=MessageCache 
> > value=jboss.mq:service=MessageCache on mbean 
> > jboss.mq:service=PersistenceManager; - nested throwable:
> > (java.lang.UnsupportedOperationException: This is now set on the 
> > destination
> > manager)
> > at
> >
>
org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:4
> > 78)
> > 
> > 
> > Sounds like I should remove name=MessageCache 
> > value=jboss.mq:service=MessageCache attribute .. Would that be right ?
> > 
> > 
> > >Pierre Comtois
> > >Business 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: Comtois, Pierre
> > Sent: October 6, 2003 4:13 PM
> > To: '[EMAIL PROTECTED]'
> &g

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

2003-10-07 Thread Comtois, Pierre
No ... 3.2.2RC4 ... The date was an error on my part ... I extracted the
orginal from the zip file and will try again ...


>Pierre Comtois
>Business 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 [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 wrote:
> Default install puts it in  ... It's dated June 10/2003 ...
> 

Ok, so you are using 3.2.1?

Copy the SQL Properties from the mysql-jdbc2-service.xml
into jbossmq-service.xml - replacing the hsqldb sql properties.

Where is the difficulty?
There is an MBean called the PersistenceManager that
takes a parameter called SQLProperties. 
By default it references DefaultDS and uses hsqldb sql.
You need to change it to match your jndi name and mysql sql statements.

It is harder with 3.2.1

With 3.2.2 it will be to just delete hsqldb-jdbc2-service.xml 
and replace it with mysql-jdbc2-service.xml

Regards,
Adrian

> 
> >Pierre Comtois
> >Business 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 [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 that file.
> It is now in x-jdbc2-service.xml
> 
> Supposedly to make it easier to drop in a different implementation 
> like you are trying :-)
> 
> Regards,
> Adrian
> 
> On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote:
> > I've also copied mysql-jdbc2-service.xml from the examples to the 
> > deploy/jms folder and deleted the hsql version.
> > 
> > I'm still getting an error:
> > 
> > 16:41:14,011 INFO  [MainDeployer] Starting deployment of package: 
> > file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml
> > 16:41:14,322 INFO  [ServiceConfigurator] Problem configuring service 
> > jboss.mq:service=PersistenceManager
> > org.jboss.deployment.DeploymentException: Exception setting attribute
> > javax.management.Attribute: name=MessageCache 
> > value=jboss.mq:service=MessageCache on mbean 
> > jboss.mq:service=PersistenceManager; - nested throwable:
> > (java.lang.UnsupportedOperationException: This is now set on the 
> > destination
> > manager)
> > at
> >
>
org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:4
> > 78)
> > 
> > 
> > Sounds like I should remove name=MessageCache 
> > value=jboss.mq:service=MessageCache attribute .. Would that be right ?
> > 
> > 
> > >Pierre Comtois
> > >Business 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: 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 persistence in 
> > jbossmq-service.xmlso copied the one I found at 
> > http://www.jboss.org/thread.jsp?forum=48&thread=39416&message=3803454&;
> > q=jbos
> > smq-service.xml#3803454 and put it in the default/deploy/jms folder.
> > 
> > I found a section to :
> > 
> >  >  name="jboss.mq:service=PersistenceManager">
> >  > optional-attribute-name="MessageCache">jboss.mq:service=MessageCache > depend
> > s>
> >  > optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxC
> > M,name
> > =DefaultDS
> > 
> > 
> > But it only includes SQL statements that do not seem to be 
> > configurable specifically for my DB. Likely there are other attribs, 
> > but can't find any mention of any in the archives.
> > 
> > Can you point me where ?
> 

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

2003-10-06 Thread Comtois, Pierre
Default install puts it in  ... It's dated June 10/2003 ... 


>Pierre Comtois
>Business 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 [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 that file.
It is now in x-jdbc2-service.xml

Supposedly to make it easier to drop in a different implementation 
like you are trying :-)

Regards,
Adrian

On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote:
> I've also copied mysql-jdbc2-service.xml from the examples to the 
> deploy/jms folder and deleted the hsql version.
> 
> I'm still getting an error:
> 
> 16:41:14,011 INFO  [MainDeployer] Starting deployment of package: 
> file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml
> 16:41:14,322 INFO  [ServiceConfigurator] Problem configuring service 
> jboss.mq:service=PersistenceManager
> org.jboss.deployment.DeploymentException: Exception setting attribute
> javax.management.Attribute: name=MessageCache 
> value=jboss.mq:service=MessageCache on mbean 
> jboss.mq:service=PersistenceManager; - nested throwable:
> (java.lang.UnsupportedOperationException: This is now set on the 
> destination
> manager)
>   at
>
org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:4
> 78)
> 
> 
> Sounds like I should remove name=MessageCache 
> value=jboss.mq:service=MessageCache attribute .. Would that be right ?
> 
> 
> >Pierre Comtois
> >Business 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: 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 persistence in 
> jbossmq-service.xmlso copied the one I found at 
> http://www.jboss.org/thread.jsp?forum=48&thread=39416&message=3803454&;
> q=jbos
> smq-service.xml#3803454 and put it in the default/deploy/jms folder.
> 
> I found a section to :
> 
> name="jboss.mq:service=PersistenceManager">
>  optional-attribute-name="MessageCache">jboss.mq:service=MessageCache depend
> s>
>  optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxC
> M,name
> =DefaultDS
> 
> 
> But it only includes SQL statements that do not seem to be 
> configurable specifically for my DB. Likely there are other attribs, 
> but can't find any mention of any in the archives.
> 
> Can you point me where ?
> 
> Thx ...
> 
> 
> >Pierre Comtois
> >Business 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 [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
> change the jndi name in your mysql-ds.xml to DefaultDS
> 
> You will also need to modify the sql properties in 
> jms/jbossmq-service.xml as discussed last week on this list.
> 
> Regards,
> Adrian
> 
> On Mon, 2003-10-06 at 19:15, Comtois, Pierre wrote:
> > Thx. I can load JBOSS without error using the sample file modified 
> > for my settings, but I still cannot set MySQL as the default DB for 
> > JBOSS nor do I see my 3.0.8 driver in the connection list in the
> > Hypersonic->File-Connect dropdown. Maybe I misunderstand the 
> > Hypersonic->expected
> > result from http://www.dodtechnology.ie/jboss.htm . I am expecting 
> > that when starting the JMX console and clicking the Hypersonic 
> > service, that my MySql DB is the one that gets loaded by default ... 
> > Is this a wrong assumption ?
> > 
> > P.S.: I can attach to my MySql DB by selecting MMM.MySql and 
> > modifying the driver, host/port/db and cr

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

2003-10-06 Thread Comtois, Pierre
Must be tired ... Got it from the JBOSS archives archives at

http://www.jboss.org/thread.jsp?forum=48&thread=39416&message=3803454&q=jbos
smq-service.xml#3803454


>Pierre Comtois
>Business 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 [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 that file.
It is now in x-jdbc2-service.xml

Supposedly to make it easier to drop in a different implementation 
like you are trying :-)

Regards,
Adrian

On Mon, 2003-10-06 at 21:47, Comtois, Pierre wrote:
> I've also copied mysql-jdbc2-service.xml from the examples to the 
> deploy/jms folder and deleted the hsql version.
> 
> I'm still getting an error:
> 
> 16:41:14,011 INFO  [MainDeployer] Starting deployment of package: 
> file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml
> 16:41:14,322 INFO  [ServiceConfigurator] Problem configuring service 
> jboss.mq:service=PersistenceManager
> org.jboss.deployment.DeploymentException: Exception setting attribute
> javax.management.Attribute: name=MessageCache 
> value=jboss.mq:service=MessageCache on mbean 
> jboss.mq:service=PersistenceManager; - nested throwable:
> (java.lang.UnsupportedOperationException: This is now set on the 
> destination
> manager)
>   at
>
org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:4
> 78)
> 
> 
> Sounds like I should remove name=MessageCache 
> value=jboss.mq:service=MessageCache attribute .. Would that be right ?
> 
> 
> >Pierre Comtois
> >Business 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: 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 persistence in 
> jbossmq-service.xmlso copied the one I found at 
> http://www.jboss.org/thread.jsp?forum=48&thread=39416&message=3803454&;
> q=jbos
> smq-service.xml#3803454 and put it in the default/deploy/jms folder.
> 
> I found a section to :
> 
> name="jboss.mq:service=PersistenceManager">
>  optional-attribute-name="MessageCache">jboss.mq:service=MessageCache depend
> s>
>  optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxC
> M,name
> =DefaultDS
> 
> 
> But it only includes SQL statements that do not seem to be 
> configurable specifically for my DB. Likely there are other attribs, 
> but can't find any mention of any in the archives.
> 
> Can you point me where ?
> 
> Thx ...
> 
> 
> >Pierre Comtois
> >Business 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 [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
> change the jndi name in your mysql-ds.xml to DefaultDS
> 
> You will also need to modify the sql properties in 
> jms/jbossmq-service.xml as discussed last week on this list.
> 
> Regards,
> Adrian
> 
> On Mon, 2003-10-06 at 19:15, Comtois, Pierre wrote:
> > Thx. I can load JBOSS without error using the sample file modified 
> > for my settings, but I still cannot set MySQL as the default DB for 
> > JBOSS nor do I see my 3.0.8 driver in the connection list in the
> > Hypersonic->File-Connect dropdown. Maybe I misunderstand the 
> > Hypersonic->expected
> > result from http://www.dodtechnology.ie/jboss.htm . I am expecting 
> > that when starting the JMX console and clicking the Hypersonic 
> > service, that my MySql DB is the one that gets loaded by default ... 
> > Is this a wrong assumption ?
> > 
> > P.S.: I 

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

2003-10-06 Thread Comtois, Pierre
I did use search ... Found the link you refer to and copied the file ... I'm
also looking at mysql-jdbc2-services file ... See posting ... Messages are
crossing ...


>Pierre Comtois
>Business 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 [mailto:[EMAIL PROTECTED] 
Sent: October 6, 2003 4:42 PM
To: [EMAIL PROTECTED]
Subject: RE: FW: [JBoss-user] Problem integrating MySql with JBOSS


I'll point you at last week's thread instead.
Make sure you check the other comments.

You can use search just as easily as I can.

http://www.mail-archive.com/[EMAIL PROTECTED]/msg32527.html

Regards,
Adrian

On Mon, 2003-10-06 at 21:13, Comtois, Pierre wrote:
> 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 persistence in 
> jbossmq-service.xmlso copied the one I found at 
> http://www.jboss.org/thread.jsp?forum=48&thread=39416&message=3803454&;
> q=jbos
> smq-service.xml#3803454 and put it in the default/deploy/jms folder.
> 
> I found a section to :
> 
> name="jboss.mq:service=PersistenceManager">
>  optional-attribute-name="MessageCache">jboss.mq:service=MessageCache depend
> s>
>  optional-attribute-name="ConnectionManager">jboss.jca:service=LocalTxC
> M,name
> =DefaultDS
> 
> 
> But it only includes SQL statements that do not seem to be 
> configurable specifically for my DB. Likely there are other attribs, 
> but can't find any mention of any in the archives.
> 
> Can you point me where ?
> 
> Thx ...
> 
> 
> >Pierre Comtois
> >Business 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 [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
> change the jndi name in your mysql-ds.xml to DefaultDS
> 
> You will also need to modify the sql properties in 
> jms/jbossmq-service.xml as discussed last week on this list.
> 
> Regards,
> Adrian
> 
> On Mon, 2003-10-06 at 19:15, Comtois, Pierre wrote:
> > Thx. I can load JBOSS without error using the sample file modified 
> > for
> > my settings, but I still cannot set MySQL as the default DB for JBOSS 
> > nor do I see my 3.0.8 driver in the connection list in the 
> > Hypersonic->File-Connect dropdown. Maybe I misunderstand the 
> > Hypersonic->expected
> > result from http://www.dodtechnology.ie/jboss.htm . I am expecting
> > that when starting the JMX console and clicking the Hypersonic 
> > service, that my MySql DB is the one that gets loaded by default ... 
> > Is this a wrong assumption ?
> > 
> > P.S.: I can attach to my MySql DB by selecting MMM.MySql and 
> > modifying
> > the driver, host/port/db and credential settings.
> > 
> > 
> > >Pierre Comtois
> > >Business 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: [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
> > 
> > 
> > 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 examples and rename it mysql-ds.xml
> > 
> > Here is my data 4 example
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >  
> >   
> > MySqlDS
> >
jdbc:mysql://localhost:3306/menagerie
> > org.gjt.mm.mysql.Driver
> > dummy
> > PASSWORD
> > 5
> > MySqlDbRealm
> >   
> > 
> > 
> > 
> > 
> > 2) edit the login-conf.xml . u should make an entry like this.
> > 
> > 
> >
> >> &qu

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

2003-10-06 Thread Comtois, Pierre
I've also copied mysql-jdbc2-service.xml from the examples to the deploy/jms
folder and deleted the hsql version.

I'm still getting an error:

16:41:14,011 INFO  [MainDeployer] Starting deployment of package:
file:/C:/jboss-3.2.2RC4/server/default/deploy/jms/jbossmq-service.xml
16:41:14,322 INFO  [ServiceConfigurator] Problem configuring service
jboss.mq:service=PersistenceManager
org.jboss.deployment.DeploymentException: Exception setting attribute
javax.management.Attribute: name=MessageCache
value=jboss.mq:service=MessageCache on mbean
jboss.mq:service=PersistenceManager; - nested throwable:
(java.lang.UnsupportedOperationException: This is now set on the destination
manager)
at
org.jboss.system.ServiceConfigurator.setAttribute(ServiceConfigurator.java:4
78)


Sounds like I should remove name=MessageCache
value=jboss.mq:service=MessageCache attribute .. Would that be right ?


>Pierre Comtois
>Business 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: 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 persistence in jbossmq-service.xmlso
copied the one I found at
http://www.jboss.org/thread.jsp?forum=48&thread=39416&message=3803454&q=jbos
smq-service.xml#3803454 and put it in the default/deploy/jms folder.

I found a section to :


jboss.mq:service=MessageCache
jboss.jca:service=LocalTxCM,name
=DefaultDS


But it only includes SQL statements that do not seem to be configurable
specifically for my DB. Likely there are other attribs, but can't find any
mention of any in the archives.

Can you point me where ?

Thx ...


>Pierre Comtois
>Business 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 [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
change the jndi name in your mysql-ds.xml to DefaultDS

You will also need to modify the sql properties in jms/jbossmq-service.xml
as discussed last week on this list.

Regards,
Adrian

On Mon, 2003-10-06 at 19:15, Comtois, Pierre wrote:
> Thx. I can load JBOSS without error using the sample file modified for
> my settings, but I still cannot set MySQL as the default DB for JBOSS 
> nor do I see my 3.0.8 driver in the connection list in the 
> Hypersonic->File-Connect dropdown. Maybe I misunderstand the expected
> result from http://www.dodtechnology.ie/jboss.htm . I am expecting
> that when starting the JMX console and clicking the Hypersonic 
> service, that my MySql DB is the one that gets loaded by default ... 
> Is this a wrong assumption ?
> 
> P.S.: I can attach to my MySql DB by selecting MMM.MySql and modifying
> the driver, host/port/db and credential settings.
> 
> 
> >Pierre Comtois
> >Business 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: [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
> 
> 
> 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 examples and rename it mysql-ds.xml
> 
> Here is my data 4 example
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  
>   
> MySqlDS
> jdbc:mysql://localhost:3306/menagerie
> org.gjt.mm.mysql.Driver
> dummy
> PASSWORD
> 5
> MySqlDbRealm
>   
> 
> 
> 
> 
> 2) edit the login-conf.xml . u should make an entry like this.
> 
> 
>
>"org.jboss.resource.security.ConfiguredIdentityLoginModule"
>  flag = "required">
>  dummy
>  dummy
>  PASSWORD
>   "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlD
> S ule-option>
>   
>
> 
> 
>  
> 3) of course p

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

2003-10-06 Thread Comtois, Pierre
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 persistence in jbossmq-service.xmlso
copied the one I found at
http://www.jboss.org/thread.jsp?forum=48&thread=39416&message=3803454&q=jbos
smq-service.xml#3803454 and put it in the default/deploy/jms folder.

I found a section to :


jboss.mq:service=MessageCache
jboss.jca:service=LocalTxCM,name
=DefaultDS


But it only includes SQL statements that do not seem to be configurable
specifically for my DB. Likely there are other attribs, but can't find any
mention of any in the archives.

Can you point me where ?

Thx ...


>Pierre Comtois
>Business 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 [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
change the jndi name in your mysql-ds.xml to DefaultDS

You will also need to modify the sql properties in jms/jbossmq-service.xml
as discussed last week on this list.

Regards,
Adrian

On Mon, 2003-10-06 at 19:15, Comtois, Pierre wrote:
> Thx. I can load JBOSS without error using the sample file modified for 
> my settings, but I still cannot set MySQL as the default DB for JBOSS 
> nor do I see my 3.0.8 driver in the connection list in the 
> Hypersonic->File-Connect dropdown. Maybe I misunderstand the expected 
> result from http://www.dodtechnology.ie/jboss.htm . I am expecting 
> that when starting the JMX console and clicking the Hypersonic 
> service, that my MySql DB is the one that gets loaded by default ... 
> Is this a wrong assumption ?
> 
> P.S.: I can attach to my MySql DB by selecting MMM.MySql and modifying 
> the driver, host/port/db and credential settings.
> 
> 
> >Pierre Comtois
> >Business 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: [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
> 
> 
> 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 examples and rename it mysql-ds.xml
> 
> Here is my data 4 example
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  
>   
> MySqlDS
> jdbc:mysql://localhost:3306/menagerie
> org.gjt.mm.mysql.Driver
> dummy
> PASSWORD
> 5
> MySqlDbRealm
>   
> 
> 
> 
> 
> 2) edit the login-conf.xml . u should make an entry like this.
> 
> 
>
>"org.jboss.resource.security.ConfiguredIdentityLoginModule"
>  flag = "required">
>  dummy
>  dummy
>  PASSWORD
>   "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlD
> S ule-option>
>   
>
> 
> 
>  
> 3) of course place mysql jdbc driver in the lib directory and make
>sure that the username&pwd mentioned above will work...
> 
> hope this helps..it worked for me, and i have took data from samples..
> 
> hope will work also for you
> 
> regards
>   marco
> 
> 
> 
> 
> > -Original Message-
> > From: ext Adrian Brock [mailto:[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.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-service.xml file to
> > > mysql-ds.xml but I still get the following error. JBOSS
> > still complains
> > > about JndiName and ManagedConnectionFactoryName attributes
> > not being found.
> > > I'm new to all this so don't know the implication of using
> > the different
> &g

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

2003-10-06 Thread Comtois, Pierre
Thx. I can load JBOSS without error using the sample file modified for my
settings, but I still cannot set MySQL as the default DB for JBOSS nor do I
see my 3.0.8 driver in the connection list in the Hypersonic->File-Connect
dropdown. Maybe I misunderstand the expected result from
http://www.dodtechnology.ie/jboss.htm . I am expecting that when starting
the JMX console and clicking the Hypersonic service, that my MySql DB is the
one that gets loaded by default ... Is this a wrong assumption ?

P.S.: I can attach to my MySql DB by selecting MMM.MySql and modifying the
driver, host/port/db and credential settings.


>Pierre Comtois
>Business 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: [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


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 examples and rename it mysql-ds.xml

Here is my data 4 example











 
  
MySqlDS
jdbc:mysql://localhost:3306/menagerie
org.gjt.mm.mysql.Driver
dummy
PASSWORD
5
MySqlDbRealm
  




2) edit the login-conf.xml . u should make an entry like this.


   
  
 dummy
 dummy
 PASSWORD
 jboss.jca:service=LocalTxCM,name=MySqlDS
  
   


 
3) of course place mysql jdbc driver in the lib directory and make
   sure that the username&pwd mentioned above will work...

hope this helps..it worked for me, and i have took data from samples..

hope will work also for you

regards
marco




> -Original Message-
> From: ext Adrian Brock [mailto:[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.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-service.xml file to 
> > mysql-ds.xml but I still get the following error. JBOSS
> still complains
> > about JndiName and ManagedConnectionFactoryName attributes
> not being found.
> > I'm new to all this so don't know the implication of using
> the different
> > name, only that it's what is used in newer releases. I'm
> using the current
> > configuration because I'm trying to have JBOSS use my
> TestAppDb as the
> > default DB as detailed at:
> http://www.dodtechnology.ie/jboss.htm . Maybe
> > it's out of date for the versions I have.
> > 
> > 
> > 
> > 09:06:36,228 INFO  [MainDeployer] Deployed package: 
> > file:/C:/jboss-3.2.2RC4/serv er/default/deploy/OnlineBank.war
> > 09:06:36,228 ERROR [URLDeploymentScanner] MBeanException: 
> Exception in MBean
> > ope
> > ration 'checkIncompleteDeployments()'
> > Cause: Incomplete Deployment listing:
> > Packages waiting for a deployer:
> >   
> > Incompletely deployed packages:
> >   
> > MBeans waiting for classes:
> >   
> > MBeans waiting for other MBeans:
> > [ObjectName: jboss.jca:service=LocalTxCM,name=TestAppDb
> >  state: FAILED
> >  I Depend On:   jboss.jca:service=LocalTxDS,name=TestAppDb
> > 
> >  Depends On Me: org.jboss.deployment.DeploymentException:
> Exception setting
> > attr
> > ibute javax.management.Attribute: name=ManagedConnectionFactoryName 
> > value=jboss. jca:service=LocalTxDS,name=TestAppDb on mbean
> > jboss.jca:service=LocalTxCM,name=T
> > estAppDb; - nested throwable: 
> (javax.management.AttributeNotFoundException:
> > Writ
> > able attribute 'ManagedConnectionFactoryName' not found),
> ObjectName:
> > jboss.jca:
> > service=LocalTxDS,name=TestAppDb
> >  state: FAILED
> >  I Depend On:
> >  Depends On Me:   jboss.jca:service=LocalTxCM,name=TestAppDb
> > org.jboss.deployment.DeploymentException: No Attribute
> found with name:
> > JndiName
> > ]
> > 09:06:36,228 INFO  [URLDeploymentScanner] Started 09:06:36,288 INFO  
> > [MainDeployer] Deployed package: file:/C:/jboss-3.2.2RC4/serv
> > er/default/conf/jboss-service.xml
> > 09:06:36,288 INFO  [Server] JBoss (MX MicroKernel) [3.2.2RC4 (build:
> > CVSTag=JBos
> > s_3_2_

[JBoss-user] Problem integrating MySql with JBOSS

2003-10-03 Thread Comtois, Pierre
Platform: XP Pro
JBOSS 3.2.2RC4
MySQL4.0.15
Driver:mysql-connector-.jar

I'm getting following error when starting JBOSS:
16:21:21,673 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean
ope
ration 'checkIncompleteDeployments()'
Cause: Incomplete Deployment listing:
Packages waiting for a deployer:
  
Incompletely deployed packages:
  
MBeans waiting for classes:
  
MBeans waiting for other MBeans:
[ObjectName: jboss.jca:service=LocalTxCM,name=TestAppDb
 state: FAILED
 I Depend On:   jboss.jca:service=LocalTxDS,name=TestAppDb

 Depends On Me: org.jboss.deployment.DeploymentException: Exception setting
attr
ibute javax.management.Attribute: name=ManagedConnectionFactoryName
value=jboss.
jca:service=LocalTxDS,name=TestAppDb on mbean
jboss.jca:service=LocalTxCM,name=T
estAppDb; - nested throwable: (javax.management.AttributeNotFoundException:
Writ
able attribute 'ManagedConnectionFactoryName' not found), ObjectName:
jboss.jca:
service=LocalTxDS,name=TestAppDb
 state: FAILED
 I Depend On:
 Depends On Me:   jboss.jca:service=LocalTxCM,name=TestAppDb
org.jboss.deployment.DeploymentException: No Attribute found with name:
JndiName
]
16:21:21,673 INFO  [URLDeploymentScanner] Started

I've scoured the archives and google to death, but can't nail down the
problem ... here are my files. If anyone can see the problem, please let me
know !

I've added following to login-config.xml





TestAppDbAdmin
TestAppDbAdmin
eugenia
jboss.jca:service=LocalTxCM,name=TestAppDb




Here is my mysql-service.xml:

 

 
SecureTestAppDb 
 
 
 
TestAppDb 
 
 
jdbc:mysql://w2czz4ch03:3306/TestAppDb 
com.mysql.jdbc.Driver 
 
 
 
 
jboss.jca:service=RARDeployment,n
ame=JBoss LocalTransaction JDBC Wrapper 
 
 
 
 
 
0 
50 
5000 
15 
ByContainer 
 
 
jboss.jca:service=CachedCo
nnectionManager 
jboss.security:service=
JaasSecurityManager
java:/TransactionManager 
 
jboss.jca:service=RARDeployer 
 


I have replaced the exsiting lines in standardjbosscmp-jdbc.xml and
standardjaws.xml with:
java:/TestAppDb
mySQL

I've confirmed the username/password in MySql. Not sure why it's complaining
about the JndiName.

Seems that I have something mismatched ... any ideas ??

Thx for the help !!


> Pierre Comtois
> Business 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]
> 
> 
> 


---
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user