When I call a JSP/Servlet deployed in JBOSS/Tomcat , I encounter the following error. The JSP/Servlet connects to Oracle 10g Express Edition installed locally. The error is not consistant.
at oracle.jdbc.driver.Databas
eError.thr
owSqlExcep
tion(Datab
aseError.j
ava:112)
at oracle.jdbc.driver.Databas
eError.thr
owSqlExcep
tion(Datab
aseError.j
ava:261)
at oracle.jdbc.driver.T4CConn
ection.log
on(T4CConn
ection.jav
a:387)
at oracle.jdbc.driver.Physica
lConnectio
n.<init>(P
hysicalCon
nection.ja
va:420)
at oracle.jdbc.driver.T4CConn
ection.<in
it>(T4CCon
nection.ja
va:165)
at oracle.jdbc.driver.T4CDriv
erExtensio
n.getConne
ction(T4CD
riverExten
sion.java:
35)
at oracle.jdbc.driver.OracleD
river.conn
ect(Oracle
Driver.jav
a:801)
at java.sql.DriverManager.get
Connection
(DriverMan
ager.java:
525)
at java.sql.DriverManager.get
Connection
(DriverMan
ager.java:
171)
at org.apache.jsp.jsp.templat
eView_jsp.
_jspServic
e(template
View_jsp.j
ava:65)
at org.apache.jasper.runtime.
HttpJspBas
e.service(
HttpJspBas
e.java:97)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
810)
at org.apache.jasper.servlet.
JspServlet
Wrapper.se
rvice(JspS
ervletWrap
per.java:3
32)
at org.apache.jasper.servlet.
JspServlet
.serviceJs
pFile(JspS
ervlet.jav
a:314)
at org.apache.jasper.servlet.
JspServlet
.service(J
spServlet.
java:264)
at javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
810)
at org.apache.catalina.core.A
pplication
FilterChai
n.internal
DoFilter(A
pplication
FilterChai
n.java:252
)
at org.apache.catalina.core.A
pplication
FilterChai
n.doFilter
(Applicati
onFilterCh
ain.java:1
73)
at org.jboss.web.tomcat.filte
rs.ReplyHe
aderFilter
.doFilter(
ReplyHeade
rFilter.ja
va:96)
at org.apache.catalina.core.A
pplication
FilterChai
n.internal
DoFilter(A
pplication
FilterChai
n.java:202
)
at org.apache.catalina.core.A
pplication
FilterChai
n.doFilter
(Applicati
onFilterCh
ain.java:1
73)
at org.apache.catalina.core.S
tandardWra
pperValve.
invoke(Sta
ndardWrapp
erValve.ja
va:213)
at org.apache.catalina.core.S
tandardCon
textValve.
invoke(Sta
ndardConte
xtValve.ja
va:178)
at org.jboss.web.tomcat.secur
ity.Securi
tyAssociat
ionValve.i
nvoke(Secu
rityAssoci
ationValve
.java:175)
at org.jboss.web.tomcat.secur
ity.JaccCo
ntextValve
.invoke(Ja
ccContextV
alve.java:
74)
at org.apache.catalina.core.S
tandardHos
tValve.inv
oke(Standa
rdHostValv
e.java:126
)
at org.apache.catalina.valves
.ErrorRepo
rtValve.in
voke(Error
ReportValv
e.java:105
)
at org.apache.catalina.core.S
tandardEng
ineValve.i
nvoke(Stan
dardEngine
Valve.java
:107)
at org.apache.catalina.connec
tor.Coyote
Adapter.se
rvice(Coyo
teAdapter.
java:148)
at org.apache.coyote.http11.H
ttp11Proce
ssor.proce
ss(Http11P
rocessor.j
ava:869)
at org.apache.coyote.http11.H
ttp11BaseP
rotocol$Ht
tp11Connec
tionHandle
r.processC
onnection(
Http11Base
Protocol.j
ava:664)
at org.apache.tomcat.util.net
.PoolTcpEn
dpoint.pro
cessSocket
(PoolTcpEn
dpoint.jav
a:527)
at org.apache.tomcat.util.net
.MasterSla
veWorkerTh
read.run(M
asterSlave
WorkerThre
ad.java:11
2)
at java.lang.Thread.run(Threa
d.java:595
)
Browser error
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperEx
ception: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
10.0.0.67:1521:XE
org.apache.jasper.servlet.
JspServlet
Wrapper.ha
ndleJspExc
eption(Jsp
ServletWra
pper.java:
510)
org.apache.jasper.servlet.
JspServlet
Wrapper.se
rvice(JspS
ervletWrap
per.java:3
75)
org.apache.jasper.servlet.
JspServlet
.serviceJs
pFile(JspS
ervlet.jav
a:314)
org.apache.jasper.servlet.
JspServlet
.service(J
spServlet.
java:264)
javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
810)
org.jboss.web.tomcat.filte
rs.ReplyHe
aderFilter
.doFilter(
ReplyHeade
rFilter.ja
va:96)
root cause
javax.servlet.ServletExcep
tion: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
10.0.0.67:1521:XE
org.apache.jasper.runtime.
PageContex
tImpl.doHa
ndlePageEx
ception(Pa
geContextI
mpl.java:8
58)
org.apache.jasper.runtime.
PageContex
tImpl.hand
lePageExce
ption(Page
ContextImp
l.java:791
)
org.apache.jsp.jsp.templat
eView_jsp.
_jspServic
e(template
View_jsp.j
ava:305)
org.apache.jasper.runtime.
HttpJspBas
e.service(
HttpJspBas
e.java:97)
javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
810)
org.apache.jasper.servlet.
JspServlet
Wrapper.se
rvice(JspS
ervletWrap
per.java:3
32)
org.apache.jasper.servlet.
JspServlet
.serviceJs
pFile(JspS
ervlet.jav
a:314)
org.apache.jasper.servlet.
JspServlet
.service(J
spServlet.
java:264)
javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
810)
org.jboss.web.tomcat.filte
rs.ReplyHe
aderFilter
.doFilter(
ReplyHeade
rFilter.ja
va:96)
root cause
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
10.0.0.67:1521:XE
oracle.jdbc.driver.Databas
eError.thr
owSqlExcep
tion(Datab
aseError.j
ava:112)
oracle.jdbc.driver.Databas
eError.thr
owSqlExcep
tion(Datab
aseError.j
ava:261)
oracle.jdbc.driver.T4CConn
ection.log
on(T4CConn
ection.jav
a:387)
oracle.jdbc.driver.Physica
lConnectio
n.<init>(P
hysicalCon
nection.ja
va:420)
oracle.jdbc.driver.T4CConn
ection.<in
it>(T4CCon
nection.ja
va:165)
oracle.jdbc.driver.T4CDriv
erExtensio
n.getConne
ction(T4CD
riverExten
sion.java:
35)
oracle.jdbc.driver.OracleD
river.conn
ect(Oracle
Driver.jav
a:801)
java.sql.DriverManager.get
Connection
(DriverMan
ager.java:
525)
java.sql.DriverManager.get
Connection
(DriverMan
ager.java:
171)
org.apache.jsp.jsp.templat
eView_jsp.
_jspServic
e(template
View_jsp.j
ava:65)
org.apache.jasper.runtime.
HttpJspBas
e.service(
HttpJspBas
e.java:97)
javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
810)
org.apache.jasper.servlet.
JspServlet
Wrapper.se
rvice(JspS
ervletWrap
per.java:3
32)
org.apache.jasper.servlet.
JspServlet
.serviceJs
pFile(JspS
ervlet.jav
a:314)
org.apache.jasper.servlet.
JspServlet
.service(J
spServlet.
java:264)
javax.servlet.http.HttpSer
vlet.servi
ce(HttpSer
vlet.java:
810)
org.jboss.web.tomcat.filte
rs.ReplyHe
aderFilter
.doFilter(
ReplyHeade
rFilter.ja
va:96)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.
Any help is appreciated.
Regards,
Start Free Trial