[Datasource Configuration] - Fedora vs Windows 7 MySql Driver
paul arber <[email protected]> Thu, 22 Aug 2013 13:44:25 -0400
| Newsgroups | gmane.comp.java.jboss.user |
|---|---|
| Message-ID | <[email protected]> |
------=_Part_860478_2056102730.1377193465637
Content-Type: multipart/alternative;
boundary="----=_Part_860477_816337338.1377193465637"
------=_Part_860477_816337338.1377193465637
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
paul arber [https://community.jboss.org/people/paularber] created the discu=
ssion
"Fedora vs Windows 7 MySql Driver"
To view the discussion, visit: https://community.jboss.org/message/833591#8=
33591
--------------------------------------------------------------
I am running jobss eap 6.1, and develop on my desktop and would like to hav=
e a server where I install checkpoint relases.=C2=A0 The desktop runs Windo=
ws 7, Jboss eap 6.1 and has a MySql datasource configured to use MySql on a=
remote server, all is working well.=C2=A0 I installed Jboss eap 6.1 on Fed=
ora 19 and attempted to configure the same MySql datasource but when I star=
t Jboss I get:=20
12:40:00,555 ERROR [org.jboss.as.controller.management-operation] (ServerSe=
rvice Thread Pool -- 31) JBAS014613: Operation ("add") failed - address: ([
=C2=A0=C2=A0=C2=A0 ("subsystem" =3D> "datasources"),
=C2=A0=C2=A0=C2=A0 ("jdbc-driver" =3D> "mysql")
]) - failure description: "JBAS010441: Failed to load module for driver [co=
m.mysql]"
On both systems I installed MySql jdbc driver as a module=C2=A0 in JBOSS/mo=
dule/com/mysql/main.=C2=A0 I have the same module.xml and the same <driver>=
definitions but on Fedora I get the above error.=C2=A0 I have searched the=
net for similar issues, searched my definitions for any differences in the=
deployment and I have not found any solution. Has anyone come across this =
problem?
standalone-full.xml
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 ...
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 <datasource jndi-name=3D"java:jboss/datasources/myDS" pool-=
name=3D"myDS" enabled=3D"true" use-java-context=3D"true">
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <connection-url>jdbc:mysql://192.168.1.20=
1:3306/jboss</connection-url>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <driver>mysql</driver>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <transaction-isolation>TRANSACTION_READ_C=
OMMITTED</transaction-isolation>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <pool>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <min-pool-s=
ize>2</min-pool-size>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <max-pool-s=
ize>10</max-pool-size>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 </pool>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <security>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <user-name>=
jboss</user-name>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <password>j=
boss</password>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 </security>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <statement>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <prepared-s=
tatement-cache-size>100</prepared-statement-cache-size>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <share-prep=
ared-statements/>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 </statement>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 </datasource>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 <drivers>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <driver name=3D"h2" module=3D"com.h=
2database.h2">
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <xa-datasou=
rce-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 </driver>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <driver name=3D"mysql" module=3D"co=
m.mysql">
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <driver-cla=
ss>com.mysql.jdbc.Driver</driver-class>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 </driver>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 </drivers>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0 ...
module.xml
=C2=A0=C2=A0 <?xml version=3D"1.0" encoding=3D"UTF-8"?>=20
=C2=A0=C2=A0=C2=A0=C2=A0 <module xmlns=3D"urn:jboss:module:1.1" name=3D"com=
.mysql">=C2=A0=C2=A0=C2=A0=20
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <resources>=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=20
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 <resource-root path=3D"mysql-connector-java-5.1.25-bin.jar"=
/>=C2=A0=C2=A0=C2=A0=C2=A0=20
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 </resources>=C2=A0=
=C2=A0=C2=A0=C2=A0=20
=C2=A0=C2=A0=C2=A0=C2=A0 <dependencies>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=20
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <module name=
=3D"javax.api"/>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=20
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 <module name=3D"java=
x.transaction.api"/>=C2=A0=C2=A0=C2=A0=20
=C2=A0=C2=A0=C2=A0=C2=A0 </dependencies>
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 </module>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/833591#833591]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=3D1&co=
ntainerType=3D14&container=3D2077]
------=_Part_860477_816337338.1377193465637
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link=3D"#355491" alink=3D"#4262a1" vlink=3D"#355491" style=3D"backgro=
und: #e2e2e2; margin: 0; padding: 20px;">
<div>
=09<table cellpadding=3D"0" bgcolor=3D"#FFFFFF" border=3D"0" cellspacing=3D=
"0" style=3D"border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -=
moz-border-radius: 6px; -webkit-border-radius: 6px;">
=09=09<tbody>
=09=09=09<tr>
=09=09=09=09<td>
=09=09=09=09=09<table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" bgco=
lor=3D"#FFFFFF" style=3D"border: solid 2px #ccc; background: #dadada; width=
: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
=09=09=09=09=09=09<tbody>
=09=09=09=09=09=09=09<tr>
=09=09=09=09=09=09=09=09<td bgcolor=3D"#000000" valign=3D"middle" height=3D=
"58px" style=3D"border-bottom: 1px solid #ccc; padding: 20px; -moz-border-r=
adius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-ri=
ght-radius: 5px; -webkit-border-top-left-radius: 5px;">
=09=09=09=09=09=09=09=09=09<h1 style=3D"color: #333333; font: bold 22px Ari=
al, Helvetica, sans-serif; margin: 0; display: block !important;">
=09=09=09=09=09=09=09=09=09<!-- To have a header image/logo replace the nam=
e below with your img tag -->
=09=09=09=09=09=09=09=09=09<!-- Email clients will render the images when t=
he message is read so any image -->
=09=09=09=09=09=09=09=09=09<!-- must be made available on a public server, =
so that all recipients can load the image. -->
=09=09=09=09=09=09=09=09=09<a href=3D"https://community.jboss.org/index.jsp=
a" style=3D"text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
=09=09=09=09=09=09=09=09</td>
=09=09=09=09=09=09=09</tr>
=09=09=09=09=09=09=09<tr>
=09=09=09=09=09=09=09=09<td bgcolor=3D"#FFFFFF" style=3D"font: normal 12px =
Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-ra=
dius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-b=
ottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style=
=3D"margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Fedora vs Windows 7 MySql Driver
</h3>
<span style=3D"margin-bottom: 10px;">
created by <a href=3D"https://community.jboss.org/people/paularber">pau=
l arber</a> in <i>Datasource Configuration</i> - <a href=3D"https://communi=
ty.jboss.org/message/833591#833591">View the full discussion</a>
</span>
<hr style=3D"margin: 20px 0; border: none; background-color: #dadada; heigh=
t: 1px;">
<div class=3D"jive-rendered-content"><p>I am running jobss eap 6.1, and dev=
elop on my desktop and would like to have a server where I install checkpoi=
nt relases.  The desktop runs Windows 7, Jboss eap 6.1 and has a MySql=
datasource configured to use MySql on a remote server, all is working well=
.  I installed Jboss eap 6.1 on Fedora 19 and attempted to configure t=
he same MySql datasource but when I start Jboss I get: </p><p style=3D"min-=
height: 8pt; height: 8pt; padding: 0px;"> </p><p>12:40:00,555 ERROR [o=
rg.jboss.as.controller.management-operation] (ServerService Thread Pool -- =
31) JBAS014613: Operation ("add") failed - address: ([</p><p>  &#=
160; ("subsystem" =3D> "datasources"),</p><p>    ("jdbc-d=
river" =3D> "mysql")</p><p>]) - failure description: "JBAS010441: Failed=
to load module for driver [com.mysql]"</p><p style=3D"min-height: 8pt; hei=
ght: 8pt; padding: 0px;"> </p><p>On both systems I installed MySql jdb=
c driver as a module  in JBOSS/module/com/mysql/main.  I have the=
same module.xml and the same <driver> definitions but on Fedora I ge=
t the above error.  I have searched the net for similar issues, search=
ed my definitions for any differences in the deployment and I have not foun=
d any solution. Has anyone come across this problem?</p><p style=3D"min-hei=
ght: 8pt; height: 8pt; padding: 0px;"> </p><p>standalone-full.xml</p><=
p>            &=
#160;  ...</p><p>         =
;       <datasource jndi-name=3D"java:jbos=
s/datasources/myDS" pool-name=3D"myDS" enabled=3D"true" use-java-context=3D=
"true"></p><p>         =
0;         <connection-url>jd=
bc:mysql://192.168.1.201:3306/jboss</connection-url></p><p> =
0;            &=
#160;    <driver>mysql</driver></p><p> =
0;            &=
#160;    <transaction-isolation>TRANSACTION_READ_COMMI=
TTED</transaction-isolation></p><p>     =
0;             =
<pool></p><p>         &#=
160;            =
;  <min-pool-size>2</min-pool-size></p><p>  =
0;            &=
#160;        <max-pool-size>10<=
/max-pool-size></p><p>        &#=
160;          </pool></p=
><p>            =
;       <security></p><p>  &#=
160;            =
;         <user-name>jboss<=
;/user-name></p><p>         =
;            &#=
160;  <password>jboss</password></p><p>   &=
#160;           =
0;   </security></p><p>      =
             &l=
t;statement></p><p>         =
;            &#=
160;  <prepared-statement-cache-size>100</prepared-statement-=
cache-size></p><p>         =
            =
60;  <share-prepared-statements/></p><p>    =
            =
60;  </statement></p><p>      =
0;         </datasource></p><=
p>            &=
#160;   <drivers></p><p>      =
;            &#=
160; <driver name=3D"h2" module=3D"com.h2database.h2"></p><p> &#=
160;            =
;          <xa-datasource-c=
lass>org.h2.jdbcx.JdbcDataSource</xa-datasource-class></p><p> =
;            &#=
160;      </driver></p><p>   =
            =
60;    <driver name=3D"mysql" module=3D"com.mysql"></p=
><p>            =
;            <dri=
ver-class>com.mysql.jdbc.Driver</driver-class></p><p>  &=
#160;           =
0;     </driver></p><p>    &#=
160;           </drive=
rs></p><p>          &#=
160;    ...</p><p style=3D"min-height: 8pt; height: 8pt; pad=
ding: 0px;"> </p><p>module.xml</p><p style=3D"min-height: 8pt; height:=
8pt; padding: 0px;"> </p><p>   <?xml version=3D"1.0" enc=
oding=3D"UTF-8"?> </p><p>     <module xmlns=3D"ur=
n:jboss:module:1.1" name=3D"com.mysql">    </p><p> &=
#160;         <resources>=
0;       </p><p>     =
;           <resource-=
root path=3D"mysql-connector-java-5.1.25-bin.jar"/>   =
60; </p><p>          </reso=
urces>     </p><p>     <depen=
dencies>        </p><p>  &#=
160;        <module name=3D"javax.api=
"/>         </p><p>  &=
#160;       <module name=3D"javax.transact=
ion.api"/>    </p><p>     </depend=
encies></p><p>      </module>  =
            =
60;            =
           </p></div>
<div style=3D"background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style=3D"margin: 0;">Reply to this message by <a href=3D"https://com=
munity.jboss.org/message/833591#833591">going to Community</a></p>
=09<p style=3D"margin: 0;">Start a new discussion in Datasource Configurati=
on at <a href=3D"https://community.jboss.org/choose-container!input.jspa?co=
ntentType=3D1&containerType=3D14&container=3D2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
------=_Part_860477_816337338.1377193465637--
------=_Part_860478_2056102730.1377193465637
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
------=_Part_860478_2056102730.1377193465637--