Re: JBOSS 6 Final
Ramesh Rajamani <[email protected]> Wed, 5 Apr 2017 01:21:26 +0000
| Newsgroups | gmane.org.user-groups.ajug.members |
|---|---|
| Message-ID | <KL1PR04MB109698C01EA0FE68CEBA8AACDC0A0@KL1PR04MB1096.apcprd04.prod.outlook.com> |
--===============5963466496543992170==
Content-Language: en-US
Content-Type: multipart/alternative;
boundary="_000_KL1PR04MB109698C01EA0FE68CEBA8AACDC0A0KL1PR04MB1096apcp_"
--_000_KL1PR04MB109698C01EA0FE68CEBA8AACDC0A0KL1PR04MB1096apcp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello
Added to Koshi, we can also use the jboss-cli (Available from EAP=
6.0 , jboss 7)to add the datasource, if your server is running in the prod=
uction
Add datasource
[standalone@localhost:9999 /] data-source add \
> --name=3DApplicationDS \
> --driver-name=3Dpostgresql \
> --connection-url=3Djdbc:postgresql://localhost:5432/DemoDB \
> --jndi-name=3Djava:jboss/jdbc/ApplicationDS \
> --user-name=3Ddemouser \
> --password=3Dpassword \
> --use-ccm=3Dfalse \
> --max-pool-size=3D25 \
> --blocking-timeout-wait-millis=3D5000 \
> --new-connection-sql=3D"set datestyle =3D ISO, European;"
[standalone@localhost:9999/] data-source enable --name=3DApplicationDS
Add XA Datasource
[standalone@localhost:9999 /] xa-data-source add \
> --name=3DApplicationXADS \
> --driver-name=3Dpostgresql \
> --jndi-name=3Djava:jboss/jdbc/ApplicationXADS \
> --user-name=3Ddemouser \
> --password=3Dpassword \
> --recovery-username=3D demouser \
> --recovery-password =3D password \
> --use-ccm=3Dfalse \
> --max-pool-size=3D25 \
> --blocking-timeout-wait-millis=3D5000 \
> --new-connection-sql=3D"set datestyle =3D ISO, European;"
[standalone@localhost:9999 /] /subsystem=3Ddatasources/xa-data-source=3DApp=
licationXADS/xa-datasource-properties=3DServerName:add(value=3Dlocalhost)
{"outcome" =3D> "success"}
[standalone@localhost:9999 /] /subsystem=3Ddatasources/xa-data-source=3DApp=
licationXADS/xa-datasource-properties=3DPortNumber:add(value=3D5432)
{"outcome" =3D> "success"}
[standalone@localhost:9999 /] /subsystem=3Ddatasources/xa-data-source=3DApp=
licationXADS/xa-datasource-properties=3DDatabaseName:add(value=3DDemoDB)
{"outcome" =3D> "success"}
[standalone@localhost:9999 /] xa-data-source enable --name =3D ApplicationX=
ADS
[standalone@localhost:9999 /]
Regards,
Ramesh Rajamani
________________________________
From: ajug-members <[email protected]> on behalf of koshi=
jose <[email protected]>
Sent: Tuesday, April 4, 2017 7:33:14 PM
To: [email protected]
Subject: Re: [ajug-members] JBOSS 6 Final
it really depends on whether your application is connecting to specific dat=
abase, in which case you will still have your ds.xml configured , if not it=
will still has to follow the below path structure for the . Source Quoted =
from here(https://docs.jboss.org/jbossas/6/JCA_Guide/en-US/html_single/#d0e=
742)
<JBoss_Home>/server/default/deploy, example if you you use JMS, it will be =
below
<JBoss_Home>/server/all/deploy/jms-singleton/hsqldb-jdbc2-service.xml with =
a file in <JBoss_Home>/docs/examples/jms/ depending on your external databa=
se. Notice that if you are using the default server profile, the file path =
is <JBoss_Home>/server/default/deploy/jms/hsqldb-jdbc2-service.xml.
[The simplified JCA DataSource configuration descriptor top-level schema el=
ements]
On Mon, Apr 3, 2017 at 10:29 PM, Mike Barnes <[email protected]<mailto:mdb3=
[email protected]>> wrote:
I am trying to confirm that jboss 6 Final has a default dataasource configu=
reation.
Specifically, I was informed that we did not need to have connection poolin=
g in each of our *-ds.xml files.
If this is true, could someone tell me where to find this default configura=
tion.
Thanks
Mike Barnes
_______________________________________________
ajug-members mailing list
[email protected]<mailto:[email protected]>
Manage your subscription and unsubscribe http://lists.ajug.org/mailman/list=
info/ajug-members
--_000_KL1PR04MB109698C01EA0FE68CEBA8AACDC0A0KL1PR04MB1096apcp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
</head>
<body>
<style type=3D"text/css" style=3D"display:none;"><!-- P {margin-top:0;margi=
n-bottom:0;} --></style>
<div id=3D"divtagdefaultwrapper" style=3D"font-size:12pt;color:#000000;font=
-family:Calibri,Arial,Helvetica,sans-serif;" dir=3D"ltr">
<p>Hello <br>
</p>
<p><br>
</p>
<p> Added to Koshi, w=
e can also use the jboss-cli (Available from EAP 6.0 , jboss 7)to add the d=
atasource, if your server is running in the production <br>
</p>
<p><br>
</p>
<p>Add datasource<br>
</p>
<p> </p>
<div class=3D"line number1 index0 alt2"><code class=3D"java plain">[standal=
one</code><code class=3D"java color1">@localhost</code><code class=3D"java =
plain">:</code><code class=3D"java value">9999</code>
<code class=3D"java plain">/] data-source add \</code></div>
<div class=3D"line number2 index1 alt1"><code class=3D"java plain">> &nb=
sp; --name=3DApplicationDS \</code></div>
<div class=3D"line number3 index2 alt2"><code class=3D"java plain">> &nb=
sp; --driver-name=3Dpostgresql \</code></div>
<div class=3D"line number4 index3 alt1"><code class=3D"java plain">> &nb=
sp; --connection-url=3Djdbc:postgresql:</code><code class=3D"java co=
mments">//localhost:5432/DemoDB \</code></div>
<div class=3D"line number5 index4 alt2"><code class=3D"java plain">> &nb=
sp; --jndi-name=3Djava:jboss/jdbc/ApplicationDS \</code></div>
<div class=3D"line number6 index5 alt1"><code class=3D"java plain">> &nb=
sp; --user-name=3Ddemouser \</code></div>
<div class=3D"line number7 index6 alt2"><code class=3D"java plain">> &nb=
sp; --password=3Dpassword \</code></div>
<div class=3D"line number8 index7 alt1"><code class=3D"java plain">> &nb=
sp; --use-ccm=3D</code><code class=3D"java keyword">false</code>
<code class=3D"java plain">\</code></div>
<div class=3D"line number9 index8 alt2"><code class=3D"java plain">> &nb=
sp; --max-pool-size=3D</code><code class=3D"java value">25</code>
<code class=3D"java plain">\</code></div>
<div class=3D"line number10 index9 alt1"><code class=3D"java plain">> &n=
bsp; --blocking-timeout-wait-millis=3D</code><code class=3D"java val=
ue">5000</code>
<code class=3D"java plain">\</code></div>
<div class=3D"line number11 index10 alt2"><code class=3D"java plain">> &=
nbsp; --</code><code class=3D"java keyword">new</code><code class=3D=
"java plain">-connection-sql=3D</code><code class=3D"java string">"set=
datestyle =3D ISO, European;"</code></div>
<code class=3D"java plain">[standalone</code><code class=3D"java color1">@l=
ocalhost</code><code class=3D"java plain">:</code><code class=3D"java value=
">9999</code><code class=3D"java plain">/] data-source enable --name=3DAppl=
icationDS</code><br>
<p></p>
<p><br>
</p>
<p>Add XA Datasource<br>
</p>
<p><br>
</p>
<p></p>
<div class=3D"container" title=3D"Hint: double-click to select code">
<div class=3D"line number1 index0 alt2"><code class=3D"java plain">[standal=
one</code><code class=3D"java color1">@localhost</code><code class=3D"java =
plain">:</code><code class=3D"java value">9999</code>
<code class=3D"java plain">/] xa-data-source add \</code></div>
<div class=3D"line number2 index1 alt1"><code class=3D"java plain">>&nbs=
p; --name=3DApplicationXADS \</code></div>
<div class=3D"line number3 index2 alt2"><code class=3D"java plain">>&nbs=
p; --driver-name=3Dpostgresql \</code></div>
<div class=3D"line number4 index3 alt1"><code class=3D"java plain">>&nbs=
p; --jndi-name=3Djava:jboss/jdbc/ApplicationXADS \</code>=
</div>
<div class=3D"line number5 index4 alt2"><code class=3D"java plain">>&nbs=
p; --user-name=3Ddemouser \</code></div>
<div class=3D"line number6 index5 alt1"><code class=3D"java plain">>&nbs=
p; --password=3Dpassword \</code></div>
<div class=3D"line number7 index6 alt2"><code class=3D"java plain">>&nbs=
p; --recovery-username=3D demouser \</code></div>
<div class=3D"line number8 index7 alt1"><code class=3D"java plain">>&nbs=
p; --recovery-password =3D password \</code></div>
<div class=3D"line number9 index8 alt2"><code class=3D"java plain">>&nbs=
p; --use-ccm=3D</code><code class=3D"java keyword">false<=
/code>
<code class=3D"java plain">\</code></div>
<div class=3D"line number10 index9 alt1"><code class=3D"java plain">>&nb=
sp; --max-pool-size=3D</code><code class=3D"java value">2=
5</code>
<code class=3D"java plain">\</code></div>
<div class=3D"line number11 index10 alt2"><code class=3D"java plain">>&n=
bsp; --blocking-timeout-wait-millis=3D</code><code class=
=3D"java value">5000</code>
<code class=3D"java plain">\</code></div>
<div class=3D"line number12 index11 alt1"><code class=3D"java plain">>&n=
bsp; --</code><code class=3D"java keyword">new</code><cod=
e class=3D"java plain">-connection-sql=3D</code><code class=3D"java string"=
>"set datestyle =3D ISO, European;"</code></div>
<div class=3D"line number13 index12 alt2"><code class=3D"java plain">[stand=
alone</code><code class=3D"java color1">@localhost</code><code class=3D"jav=
a plain">:</code><code class=3D"java value">9999</code>
<code class=3D"java plain">/] /subsystem=3Ddatasources/xa-data-source=3DApp=
licationXADS/xa-datasource-properties=3DServerName:add(value=3Dlocalhost)</=
code></div>
<div class=3D"line number14 index13 alt1"><code class=3D"java plain">{</cod=
e><code class=3D"java string">"outcome"</code>
<code class=3D"java plain">=3D> </code><code class=3D"java string">"=
;success"</code><code class=3D"java plain">}</code></div>
<div class=3D"line number15 index14 alt2"><code class=3D"java plain">[stand=
alone</code><code class=3D"java color1">@localhost</code><code class=3D"jav=
a plain">:</code><code class=3D"java value">9999</code>
<code class=3D"java plain">/] /subsystem=3Ddatasources/xa-data-source=3DApp=
licationXADS/xa-datasource-properties=3DPortNumber:add(value=3D</code><code=
class=3D"java value">5432</code><code class=3D"java plain">)</code></div>
<div class=3D"line number16 index15 alt1"><code class=3D"java plain">{</cod=
e><code class=3D"java string">"outcome"</code>
<code class=3D"java plain">=3D> </code><code class=3D"java string">"=
;success"</code><code class=3D"java plain">}</code></div>
<div class=3D"line number17 index16 alt2"><code class=3D"java plain">[stand=
alone</code><code class=3D"java color1">@localhost</code><code class=3D"jav=
a plain">:</code><code class=3D"java value">9999</code>
<code class=3D"java plain">/] /subsystem=3Ddatasources/xa-data-source=3DApp=
licationXADS/xa-datasource-properties=3DDatabaseName:add(value=3DDemoDB)</c=
ode></div>
<div class=3D"line number18 index17 alt1"><code class=3D"java plain">{</cod=
e><code class=3D"java string">"outcome"</code>
<code class=3D"java plain">=3D> </code><code class=3D"java string">"=
;success"</code><code class=3D"java plain">}</code></div>
<div class=3D"line number19 index18 alt2"><code class=3D"java plain">[stand=
alone</code><code class=3D"java color1">@localhost</code><code class=3D"jav=
a plain">:</code><code class=3D"java value">9999</code>
<code class=3D"java plain">/] xa-data-source enable --name =3D ApplicationX=
ADS</code></div>
<div class=3D"line number20 index19 alt1"><code class=3D"java plain">[stand=
alone</code><code class=3D"java color1">@localhost</code><code class=3D"jav=
a plain">:</code><code class=3D"java value">9999</code>
<code class=3D"java plain">/]</code></div>
</div>
<br>
<p></p>
<p><br>
</p>
<p><br>
</p>
<p>Regards,</p>
<p>Ramesh Rajamani<br>
</p>
</div>
<hr style=3D"display:inline-block;width:98%" tabindex=3D"-1">
<div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st=
yle=3D"font-size:11pt" color=3D"#000000"><b>From:</b> ajug-members <ajug=
[email protected]> on behalf of koshi jose <koshi.cox@g=
mail.com><br>
<b>Sent:</b> Tuesday, April 4, 2017 7:33:14 PM<br>
<b>To:</b> [email protected]<br>
<b>Subject:</b> Re: [ajug-members] JBOSS 6 Final</font>
<div> </div>
</div>
<div>
<div dir=3D"ltr">it really depends on whether your application is connectin=
g to specific database, in which case you will still have your ds.xml confi=
gured , if not it will still has to follow the below path structure for the=
. Source Quoted from here(<a href=3D"https://docs.jboss.org/jbossas/6/JCA_=
Guide/en-US/html_single/#d0e742">https://docs.jboss.org/jbossas/6/JCA_Guide=
/en-US/html_single/#d0e742</a>)
<div><br>
</div>
<div><a id=3D"gmail-d0e1004" style=3D"color:rgb(51,51,51);font-family:"=
;lucida grande",geneva,verdana,arial,sans-serif;font-size:12px"><code =
class=3D"gmail-literal" style=3D"font-size:0.9em;font-family:"liberati=
on mono","bitstream vera mono",monospace;white-space:nowrap"=
><b><JBoss_Home>/server/default/deploy</b>,
example if you you use JMS, it will be below</code></a><br>
</div>
<div><a style=3D"color:rgb(51,51,51);font-family:"lucida grande",=
geneva,verdana,arial,sans-serif;font-size:12px"><code class=3D"gmail-litera=
l" style=3D"font-size:0.9em;font-family:"liberation mono","b=
itstream vera mono",monospace;white-space:nowrap"><br>
</code></a></div>
<div><a style=3D"color:rgb(51,51,51);font-family:"lucida grande",=
geneva,verdana,arial,sans-serif;font-size:12px"><code class=3D"gmail-litera=
l" style=3D"font-size:0.9em;font-family:"liberation mono","b=
itstream vera mono",monospace;white-space:nowrap"></code></a><code cla=
ss=3D"gmail-literal" style=3D"font-size:0.9em;font-family:"liberation =
mono","bitstream vera mono",monospace;white-space:nowrap"><a=
id=3D"gmail-d0e1004" style=3D"color:rgb(51,51,51);font-family:"lucida=
grande",geneva,verdana,arial,sans-serif;font-size:12px;white-space:no=
rmal"><code class=3D"gmail-literal" style=3D"font-size:0.9em;font-family:&q=
uot;liberation mono","bitstream vera mono",monospace;white-s=
pace:nowrap"><JBoss_Home>/server/all/deploy/jms-singleton/hsqldb-jdbc=
2-service.xml</code> with
a file in <code class=3D"gmail-literal" style=3D"font-size:0.9em;font=
-family:"liberation mono","bitstream vera mono",monospa=
ce;white-space:nowrap"><JBoss_Home>/docs/examples/jms/</code> de=
pending on your external database. Notice that if you are using the <c=
ode class=3D"gmail-literal" style=3D"font-size:0.9em;font-family:"libe=
ration mono","bitstream vera mono",monospace;white-space:now=
rap">default</code> server
profile, the file path is <code class=3D"gmail-literal" style=3D"font=
-size:0.9em;font-family:"liberation mono","bitstream vera mo=
no",monospace;white-space:nowrap"><JBoss_Home>/server/default/de=
ploy/jms/hsqldb-jdbc2-service.xml</code>.</a><br>
</code></div>
<div><a style=3D"color:rgb(51,51,51);font-family:"lucida grande",=
geneva,verdana,arial,sans-serif;font-size:12px"><code class=3D"gmail-litera=
l" style=3D"font-size:0.9em;font-family:"liberation mono","b=
itstream vera mono",monospace;white-space:nowrap"><br>
</code></a></div>
<div><a style=3D"color:rgb(51,51,51);font-family:"lucida grande",=
geneva,verdana,arial,sans-serif;font-size:12px"><code class=3D"gmail-litera=
l" style=3D"font-size:0.9em;font-family:"liberation mono","b=
itstream vera mono",monospace;white-space:nowrap"><br>
</code></a></div>
<div><a style=3D"color:rgb(51,51,51);font-family:"lucida grande",=
geneva,verdana,arial,sans-serif;font-size:12px"><code class=3D"gmail-litera=
l" style=3D"font-size:0.9em;font-family:"liberation mono","b=
itstream vera mono",monospace;white-space:nowrap"><img align=3D"middle=
" alt=3D"The simplified JCA DataSource configuration descriptor top-level s=
chema elements" style=3D"display: block; margin: 2em 0px; font-family: &quo=
t;lucida grande", geneva, verdana, arial, sans-serif; font-size: 12px;=
text-align: -webkit-center; white-space: normal;" src=3D"https://docs.jbos=
s.org/jbossas/6/JCA_Guide/en-US/html_single/images/jboss_ds.jpg"></code></a=
></div>
<div class=3D"gmail_extra"><br>
<div class=3D"gmail_quote">On Mon, Apr 3, 2017 at 10:29 PM, Mike Barnes <sp=
an dir=3D"ltr">
<<a href=3D"mailto:[email protected]" target=3D"_blank">[email protected]=
m</a>></span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir=3D"ltr">I am trying to confirm that jboss 6 Final has a default da=
taasource configureation.
<div><br>
</div>
<div>Specifically, I was informed that we did not need to have connection p=
ooling in each of our *-ds.xml files.</div>
<div><br>
</div>
<div>If this is true, could someone tell me where to find this default conf=
iguration.</div>
<div><br>
</div>
<div>Thanks</div>
<span class=3D"gmail-HOEnZb"><font color=3D"#888888">
<div>Mike Barnes</div>
</font></span></div>
<br>
______________________________<wbr>_________________<br>
ajug-members mailing list<br>
<a href=3D"mailto:[email protected]">[email protected]<=
/a><br>
Manage your subscription and unsubscribe <a href=3D"http://lists.ajug.org/m=
ailman/listinfo/ajug-members" rel=3D"noreferrer" target=3D"_blank">
http://lists.ajug.org/mailman/<wbr>listinfo/ajug-members</a><br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</body>
</html>
--_000_KL1PR04MB109698C01EA0FE68CEBA8AACDC0A0KL1PR04MB1096apcp_--
--===============5963466496543992170==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: base64
Content-Disposition: inline
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KYWp1Zy1tZW1i
ZXJzIG1haWxpbmcgbGlzdAphanVnLW1lbWJlcnNAbGlzdHMuYWp1Zy5vcmcKTWFuYWdlIHlvdXIg
c3Vic2NyaXB0aW9uIGFuZCB1bnN1YnNjcmliZSBodHRwOi8vbGlzdHMuYWp1Zy5vcmcvbWFpbG1h
bi9saXN0aW5mby9hanVnLW1lbWJlcnM=
--===============5963466496543992170==--