[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jboss-user
Subject:    [jboss-user] [jBPM] - Re: MySQL database connection error
From:       Zoltan Papp <do-not-reply () jboss ! com>
Date:       2013-03-28 17:57:03
Message-ID: 2-802643-3-125386-1363261277748-2-805364-3-126070-1364493418500.jivesbs.jivemailuser () https://community ! jboss ! org
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Zoltan Papp [https://community.jboss.org/people/pzoli] created the discussion

"Re: MySQL database connection error"

To view the discussion, visit: https://community.jboss.org/message/805364#805364

--------------------------------------------------------------
Okay, let's speak english.

My persistance.xml in a JPA/CDI project:

<datasources xmlns=" http://www.jboss.org/ironjacamar/schema \
http://www.jboss.org/ironjacamar/schema" xmlns:xsi=" \
http://www.w3.org/2001/XMLSchema-instance http://www.w3.org/2001/XMLSchema-instance"  \
xsi:schemaLocation=" http://www.jboss.org/ironjacamar/schema \
http://www.jboss.org/ironjacamar/schema  \
http://docs.jboss.org/ironjacamar/schema/datasources_1_0.xsd \
                http://docs.jboss.org/ironjacamar/schema/datasources_1_0.xsd">
       <!-- The datasource is bound into JNDI at this location. We reference 
             this in META-INF/persistence.xml -->
     <datasource jndi-name="java:jboss/datasources/sample-multi-tierDS"
           pool-name="{artifactId}" enabled="true"
           use-java-context="true">
               <connection-url>jdbc:mysql://localhost:3306/bigfilesystem?useUnicode=true&amp;autoReconnect=true&amp;characterEncoding=UTF-8</connection-url>
  <driver>com.mysql</driver>
               <security>
                       <user-name>username</user-name>
                       <password>password</password>
               </security>
     </datasource>
</datasources>

Did you install mysql driver to JBoss modules/com/mysql subdirectory?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/805364#805364]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]



[Attachment #5 (text/html)]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; \
margin: 0; padding: 20px;">

<div>
	<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: \
1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; \
-webkit-border-radius: 6px;">  <tbody>
			<tr>

				<td>

					<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" \
style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: \
6px; -webkit-border-radius: 6px;">  <tbody>
							<tr>
								<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px \
solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; \
-moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; \
                -webkit-border-top-left-radius: 5px;">
									<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; \
                margin: 0; display: block !important;">
									<!-- To have a header image/logo replace the name below with your img tag \
                -->
									<!-- Email clients will render the images when the message is read so any \
                image -->
									<!-- must be made available on a public server, so that all recipients can \
                load the image. -->
									<a href="https://community.jboss.org/index.jspa" style="text-decoration: \
none; color: #E1E1E1">JBoss Community</a></h1>  </td>

							</tr>
							<tr>
								<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; \
color:#333333; padding: 20px;  -moz-border-radius-bottomleft: 4px; \
-moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; \
-webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: \
17px; font-weight: normal;">  Re: MySQL database connection error
</h3>
<span style="margin-bottom: 10px;">
    created by <a href="https://community.jboss.org/people/pzoli">Zoltan Papp</a> in \
<i>jBPM</i> - <a href="https://community.jboss.org/message/805364#805364">View the \
full discussion</a> </span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">

<div class="jive-rendered-content"><p>Okay, let's speak english.</p><p \
style="min-height: 8pt; height: 8pt; padding: 0px;">&#160;</p><p>My persistance.xml \
in a JPA/CDI project:</p><p style="min-height: 8pt; height: 8pt; padding: \
0px;">&#160;</p><p><span>&lt;datasources xmlns="</span><a \
class="jive-link-external-small" href="http://www.jboss.org/ironjacamar/schema" \
target="_blank">http://www.jboss.org/ironjacamar/schema</a><span>" \
xmlns:xsi="</span><a class="jive-link-external-small" \
href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow" \
target="_blank">http://www.w3.org/2001/XMLSchema-instance</a><span>"</span></p><p><span>&#160;&#160;&#160; \
xsi:schemaLocation="</span><a class="jive-link-external-small" \
href="http://www.jboss.org/ironjacamar/schema" \
target="_blank">http://www.jboss.org/ironjacamar/schema</a><span> </span><a \
class="jive-link-external-small" \
href="http://docs.jboss.org/ironjacamar/schema/datasources_1_0.xsd" \
target="_blank">http://docs.jboss.org/ironjacamar/schema/datasources_1_0.xsd</a><span>"&gt;</span></p><p>&#160;&#160;&#160; \
&lt;!-- The datasource is bound into JNDI at this location. We reference \
</p><p>&#160;&#160;&#160;&#160;&#160;&#160; this in META-INF/persistence.xml \
--&gt;</p><p>&#160;&#160; &lt;datasource \
jndi-name="java:jboss/datasources/sample-multi-tierDS"</p><p>&#160;&#160;&#160;&#160;&#160; \
pool-name="{artifactId}" enabled="true"</p><p>&#160;&#160;&#160;&#160;&#160; \
use-java-context="true"&gt;</p><p>&#160;&#160;&#160;&#160;&#160;&#160;&#160; \
&lt;connection-url&gt;jdbc:mysql://localhost:3306/bigfilesystem?useUnicode=true&amp;am \
p;autoReconnect=true&amp;amp;characterEncoding=UTF-8&lt;/connection-url&gt;</p><p>&#160;&#160;&#160;&#160;&#160;&#160;&#160; \
&lt;driver&gt;com.mysql&lt;/driver&gt;</p><p>&#160;&#160;&#160;&#160;&#160;&#160;&#160; \
&lt;security&gt;</p><p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; \
&lt;user-name&gt;username&lt;/user-name&gt;</p><p>&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; \
&lt;password&gt;password&lt;/password&gt;</p><p>&#160;&#160;&#160;&#160;&#160;&#160;&#160; \
&lt;/security&gt;</p><p>&#160;&#160; \
&lt;/datasource&gt;</p><p>&lt;/datasources&gt;</p><p style="min-height: 8pt; height: \
8pt; padding: 0px;">&#160;</p><p>Did you install mysql driver to JBoss \
modules/com/mysql subdirectory?</p></div>

<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
    <p style="margin: 0;">Reply to this message by <a \
href="https://community.jboss.org/message/805364#805364">going to Community</a></p>  \
<p style="margin: 0;">Start a new discussion in jBPM at <a \
href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
 </div></td>
                        </tr>
                    </tbody>
                </table>


                </td>
            </tr>
        </tbody>
    </table>

</div>

</body>
</html>



_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic