Error in getting a connection to Oracle 11g RAC in openJMS
Erick Jesús Delgado Ramírez <[email protected]> Mon, 24 May 2010 02:20:16 -0300
| Newsgroups | gmane.comp.java.openjms.user |
|---|---|
| Message-ID | <[email protected]> |
--===============5767103659630629563==
Content-Type: multipart/alternative; boundary=0016e6d99c1d3f1bb00487503289
--0016e6d99c1d3f1bb00487503289
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
Hi there,
I am having an issue with the OpenJMS v 0.7.5 RC1 used in a third
technology. This issue is related to getting a JMS connection to Oracle 11g
RAC through JDBC.
When I set the openJMS to connect to Oracle 11g without cluster
configuration I don=92t have any problems, but when I set the cluster
configuration using the LOAD_BALANCE and/or FAILOVER features I couldn=92t =
get
any connection. The database cluster configuration is set in the openjms.xm=
l
configuration file:
<DatabaseConfiguration>
<RdbmsDatabaseConfiguration
driver=3D"oracle.jdbc.driver.OracleDriver" url=3D"*jdbc:oracle:thin=
:@
(DESCRIPTION=3D(FAILOVER=3Don)(LOAD_BALANCE=3Dyes)(ADDRESS=3D(PROTOCOL=3DTC=
P)(HOST=3D
host01-vip.com)(PORT=3D1521))(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D**host02-vi=
p.com*<http://jborap02-vip.corp.tvglobo.com.br/>
*)(PORT=3D1521))(CONNECT_DATA=3D(service_name=3DJBORAP02)))*"
user=3D"virageuser"
password=3D"*password*" />
</DatabaseConfiguration>
And the error description in the open jms log, is:
INFO | jvm 1 | 2010/05/04 16:27:41 |
org.exolab.jms.server.ServerException:
org.exolab.jms.persistence.PersistenceException:
java.sql.SQLException:*Exce=E7=E3o de E/S: Connection refused
*
(DESCRIPTION=3D(ERR=3D1153)(VSNNUM=3D185599488)(ERROR_STACK=3D(ERROR=3D(COD=
E=3D1153)(EMFI=3D4)(ARGS=3D'(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dhost02)(PORT=
=3D1521))'))(ERROR=3D(CODE=3D305)(EMFI=3D1))))
I googled this error without success, any suggestions is really appreciated=
.
Thanks
Erick J. Delgado Ramirez
--0016e6d99c1d3f1bb00487503289
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
<br clear=3D"all"><meta http-equiv=3D"Content-Type" content=3D"text/html; c=
harset=3Dutf-8"><meta name=3D"ProgId" content=3D"Word.Document"><meta name=
=3D"Generator" content=3D"Microsoft Word 12"><meta name=3D"Originator" cont=
ent=3D"Microsoft Word 12"><link rel=3D"File-List" href=3D"file:///C:%5CDOCU=
ME%7E1%5CERICKJ%7E1%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist=
.xml"><link rel=3D"themeData" href=3D"file:///C:%5CDOCUME%7E1%5CERICKJ%7E1%=
5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel=3D=
"colorSchemeMapping" href=3D"file:///C:%5CDOCUME%7E1%5CERICKJ%7E1%5CLOCALS%=
7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1107304683 0 0 159 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1073750139 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:Calibri;
mso-fareast-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
.MsoPapDefault
{mso-style-type:export-only;
margin-bottom:10.0pt;
line-height:115%;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<p class=3D"MsoNormal"><a name=3D"OLE_LINK13"></a><a name=3D"OLE_LINK12"><s=
pan style=3D"">Hi there,</span></a></p>
<p class=3D"MsoNormal" style=3D"text-align: justify;"><span style=3D""><spa=
n style=3D"">I am having an issue with the OpenJMS v 0.7.5 RC1
used in a third technology. This issue is related to getting a
JMS connection to Oracle 11g RAC through JDBC. </span></span></p>
<p class=3D"MsoNormal" style=3D"text-align: justify;"><span style=3D""><spa=
n style=3D"">When I set the openJMS to connect to Oracle 11g
without cluster configuration I don=92t have any problems, but when I set t=
he
cluster configuration using the LOAD_BALANCE and/or FAILOVER features I cou=
ldn=92t
get any connection. The database cluster configuration is set in the openjm=
s.xml
configuration file:</span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom: 0.0001pt; line-height: norma=
l;"><span style=3D""><span style=3D""><span style=3D"font-size: 10pt; font-=
family: "Times New Roman","serif";"><DatabaseConfigu=
ration><br>
=A0=A0 =A0=A0=A0 =A0<RdbmsDatabaseConfiguration<br>
=A0=A0=A0=A0=A0 driver=3D"oracle.jdbc.driver.OracleDriver"
=A0 url=3D"<b>jdbc:oracle:thin:@(DESCRIPTION=3D(FAILOVER=3Don)(LOAD_BA=
LANCE=3Dyes)(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D<u><span style=3D"color: blu=
e;"><a href=3D"http://host01-vip.com">host01-vip.com</a></span></u>)(PORT=
=3D1521))(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3D</b></span></span></span><span =
style=3D""><span style=3D""></span></span><a href=3D"http://jborap02-vip.co=
rp.tvglobo.com.br/" target=3D"_blank"><span style=3D""><span style=3D""><b>=
<span style=3D"font-size: 10pt; font-family: "Times New Roman",&q=
uot;serif"; color: blue;">host02-vip.com</span></b></span></span><span=
style=3D""><span style=3D""></span></span></a><span style=3D""><span style=
=3D""><b><span style=3D"font-size: 10pt; font-family: "Times New Roman=
","serif";">)(PORT=3D1521))(CONNECT_DATA=3D(service_name=3DJ=
BORAP02)))</span></b></span></span><span style=3D""><span style=3D""><span =
style=3D"font-size: 10pt; font-family: "Times New Roman","se=
rif";">"<br>
=A0 =A0=A0=A0 =A0 user=3D"virageuser"</span></span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom: 0.0001pt; line-height: norma=
l;"><span style=3D""><span style=3D""><span style=3D"font-size: 10pt; font-=
family: "Times New Roman","serif";">password=3D"<i=
><span style=3D"color: navy;">password</span></i>"
/></span></span></span></p>
<p class=3D"MsoNormal" style=3D"margin-bottom: 0.0001pt; line-height: norma=
l;"><span style=3D""><span style=3D""><span style=3D"font-size: 10pt; font-=
family: "Times New Roman","serif";"></DatabaseConfig=
uration><br>
</span></span></span><span style=3D""><span style=3D""><span style=3D"font-=
size: 12pt; font-family: "Times New Roman","serif";"><b=
r>
</span>And the error description in the open jms log, is: <br>
</span></span><span style=3D""><span style=3D""><span style=3D"font-size: 1=
2pt; font-family: "Times New Roman","serif";"><br>
</span></span></span><span style=3D""><span style=3D""><span style=3D"font-=
size: 10pt; font-family: "Times New Roman","serif";">IN=
FO=A0=A0 | jvm
1=A0=A0=A0 | 2010/05/04 16:27:41 |
org.exolab.jms.server.ServerException: org.exolab.jms.persistence.Persisten=
ceException:
java.sql.SQLException:<b> Exce=E7=E3o de E/S: Connection refused</b>(DESCRI=
PTION=3D(ERR=3D1153)(VSNNUM=3D185599488)(ERROR_STACK=3D(ERROR=3D(CODE=3D115=
3)(EMFI=3D4)(ARGS=3D'(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dhost02)(PORT=3D=
1521))'))(ERROR=3D(CODE=3D305)(EMFI=3D1))))</span></span></span></p>
<p class=3D"MsoNormal"><span style=3D""><span style=3D"">=A0</span></span><=
/p>
<p class=3D"MsoNormal"><span style=3D""><span style=3D"">I googled this err=
or without success, any
suggestions is really appreciated.</span></span></p>
<p class=3D"MsoNormal"><span style=3D""><span style=3D"">Thanks </span></sp=
an></p>
Erick J. Delgado Ramirez<br>
--0016e6d99c1d3f1bb00487503289--
--===============5767103659630629563==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
------------------------------------------------------------------------------
--===============5767103659630629563==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
openjms-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openjms-user
--===============5767103659630629563==--