You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Somu Sundar Reddy.Y" <ys...@yahoo.com> on 2007/06/05 20:26:47 UTC
Need some help in using Oracle Database connection pool in jakarta-tomcat-5.0.28
Hi,
Need some help in using Oracle Database connection pool in jakarta-tomcat-5.0.28
Problem Description:
I created a JNDI(Name is jdbc/TestOracle ) for Oracle using Tomcat Admin console Example --TomcatServer->Service->Host->Context(TestProject)->Resources->DataSources using oracle.jdbc.driver.OracleDriver driver
In my web application I created a connection using above JNDI name.
private static final String JNDI_POOL="jdbc/TestOracle ";
Context oracleObjCtx = new InitialContext();
DataSource ds=null;
try {
ds = (DataSource) oracleObjCtx.lookup(JNDI_POOL);
} catch (Exception ne) {
oracleObjCtx = (Context)oracleObjCtx.lookup("java:comp/env");
ds = (DataSource) oracleObjCtx.lookup(JNDI_POOL);
}
conn = (Connection)ds.getConnection();
Above code is working fine in Window environment and it 's throwing exception in Linux while creating a DataSource
Error Message is
Name jdbc is not bound in this Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:768)
at org.apache.naming.NamingContext.lookup(NamingContext.java:151)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:136)
at javax.naming.InitialContext.lookup(InitialContext.java:351)
at com.usscript.util.ConnectionManager.getOracleConnectionFromPool(ConnectionManager.java:26)
at com.usscript.dataaccess.AuthenticatorDAO.getUserDetailsAfterFirstTimeAccess(AuthenticatorDAO.java:132)
at com.usscript.dataaccess.AuthenticatorDAO.getUserDetails(AuthenticatorDAO.java:29)
at com.usscript.delegate.LoginDelegateHandler.getUserDetails(LoginDelegateHandler.java:125)
at com.usscript.action.LoginAction.execute(LoginAction.java:39)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at com.usscript.util.USScriptActionServlet.doPost(USScriptActionServlet.java:48)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:595)
Thank,
Somu
573-462-0599
---------------------------------
Be a better Globetrotter. Get better travel answers from someone who knows.
Yahoo! Answers - Check it out.
Re: Need some help in using Oracle Database connection pool in jakarta-tomcat-5.0.28
Posted by David Smith <dn...@cornell.edu>.
I would recommend not using the admin console to define datasources.
There have been messages on this list for a while indicating the admin
console webapp doesn't always persist the config to the disk. Instead,
configure it in the context.xml file if at all possible.
--David
Somu Sundar Reddy.Y wrote:
>
>Hi,
>
>
> Need some help in using Oracle Database connection pool in jakarta-tomcat-5.0.28
>
> Problem Description:
>
> I created a JNDI(Name is jdbc/TestOracle ) for Oracle using Tomcat Admin console Example --TomcatServer->Service->Host->Context(TestProject)->Resources->DataSources using oracle.jdbc.driver.OracleDriver driver
> In my web application I created a connection using above JNDI name.
>
> private static final String JNDI_POOL="jdbc/TestOracle ";
> Context oracleObjCtx = new InitialContext();
> DataSource ds=null;
> try {
> ds = (DataSource) oracleObjCtx.lookup(JNDI_POOL);
>
> } catch (Exception ne) {
> oracleObjCtx = (Context)oracleObjCtx.lookup("java:comp/env");
> ds = (DataSource) oracleObjCtx.lookup(JNDI_POOL);
> }
> conn = (Connection)ds.getConnection();
>
> Above code is working fine in Window environment and it 's throwing exception in Linux while creating a DataSource
> Error Message is
> Name jdbc is not bound in this Context
>at org.apache.naming.NamingContext.lookup(NamingContext.java:768)
> at org.apache.naming.NamingContext.lookup(NamingContext.java:151)
> at org.apache.naming.SelectorContext.lookup(SelectorContext.java:136)
> at javax.naming.InitialContext.lookup(InitialContext.java:351)
> at com.usscript.util.ConnectionManager.getOracleConnectionFromPool(ConnectionManager.java:26)
> at com.usscript.dataaccess.AuthenticatorDAO.getUserDetailsAfterFirstTimeAccess(AuthenticatorDAO.java:132)
> at com.usscript.dataaccess.AuthenticatorDAO.getUserDetails(AuthenticatorDAO.java:29)
> at com.usscript.delegate.LoginDelegateHandler.getUserDetails(LoginDelegateHandler.java:125)
> at com.usscript.action.LoginAction.execute(LoginAction.java:39)
> at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
> at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
> at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
> at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
> at com.usscript.util.USScriptActionServlet.doPost(USScriptActionServlet.java:48)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
> at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
> at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
> at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
> at java.lang.Thread.run(Thread.java:595)
>
> Thank,
> Somu
> 573-462-0599
>
>
>
>
>
>
>
>
>
>---------------------------------
>Be a better Globetrotter. Get better travel answers from someone who knows.
>Yahoo! Answers - Check it out.
>
>
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org