Hi,
I am trying to create database connection pool. I m using following software versions.
1) J2SDK 1.4.0_01
2) Jakarta-Tomcat 4.0.4
3) Oracle 8.1.5
My code in server.xml, web.xml and in main.jsp is as follows
***** server.xml ************
<Resource name="jdbc/MyConnectionPool" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/MyConnectionPool">
<parameter>
<name>username</name>
<value>ko02</value>
</parameter>
<parameter>
<name>password</name>
<value>ko02</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>driverName</name>
<value>jdbc:oracle:thin:@10.65.56.12:21203:DC03</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>5</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10</value>
</parameter>
</ResourceParams>
***** web.xml **************
<resource-ref>
<res-ref-name>jdbc/MyConnectionPool</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
**** main.jsp ***************
try{
Context ctx = new InitialContext();
if(ctx == null )
throw new Exception("Boom - No Context");
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/MyConnectionPool");
if (ds != null) {
Connection conn = ds.getConnection();
if(conn != null) {
System.out.println("Got Connection "+conn.toString());
conn.close();
}
}
}catch(Exception e) {
e.printStackTrace();
}
But after exectuting main.jsp I get SQLException as Connection refused as follows
java.sql.SQLException: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135291648)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:407)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:152)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:214)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:193)
at tyrex.jdbc.xa.EnabledDataSource.getConnection(EnabledDataSource.java:262)
at tyrex.jdbc.xa.EnabledDataSource.getConnection(EnabledDataSource.java:204)
at org.apache.jsp.main$jsp._jspService(main$jsp.java, Compiled Code)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java, Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java, Compiled Code)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java, Compiled Code)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java, Compiled Code)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java, Compiled Code)
at java.lang.Thread.run(Thread.java:479)
I checked host and port its right but still the exception is...
any help/suggestion ll be great
Regards
Susheel