You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by T00081 madhu <ma...@wizit.com> on 2003/07/24 10:10:18 UTC
DB2 connection problem with Tomcat-4.0.3
Hi
I have found your email id in tomcat forums
Well .. When I trying to open connection to my DB2 database in tomcat
-4.0.3, I am getting below expections..
here is the stacktrace from Tomcat
logs(/usr/local/jakartha-tomcat-4.0.3/logs/catilina.out)
javax.naming.NameNotFoundException: Name SmsDBDS is not bound in this
Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:811)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:181)
at org.apache.naming.NamingContext.lookup(NamingContext.java:822)
at org.apache.naming.NamingContext.lookup(NamingContext.java:194)
at
org.apache.naming.SelectorContext.lookup(SelectorContext.java:183)
at javax.naming.InitialContext.lookup(InitialContext.java:354)
at com.ebizon.util.jdbc.DBUtil.getEbizDBConnection(DBUtil.java:32)
at
com.ebizon.board.service.BoardServiceForDB2.getCategoriesByGroup(BoardServiceForDB2.java:1010)
at
com.ebizon.board.servlet.command.ListBoardCommand.doAction(ListBoardCommand.java:125)
at
com.ebizon.util.command.ActionCommand.execute(ActionCommand.java:54)
at
com.ebizon.util.servlet.BaseServlet.service(BaseServlet.java:227)
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
com.wizit.acs.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:105)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
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.valves.CertificatesValve.invoke(CertificatesValve.java:246)
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.StandardContext.invoke(StandardContext.java:2343)
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.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.warp.WarpRequestHandler.handle(WarpRequestHandler.java:217)
at
org.apache.catalina.connector.warp.WarpConnection.run(WarpConnection.java:194)
at java.lang.Thread.run(Thread.java:536)
------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------
And my resource definition in server.xml
(/usr/local/jakartha-tomcat-4.0.3/conf/server.xml)
<Context path="/DBTest" docBase="DBTest"
debug="5" reloadable="true" crossContext="true">
<Logger className="org.apache.catalina.logger.FileLogger"
prefix="localhost_DBTest_log." suffix=".txt"
timestamp="true"/>
<Resource name="jdbc/SmsDBDS"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/SmsDBDS">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<!-- DB2 dB username and password for dB connections -->
<parameter>
<name>username</name>
<value>DBUsername</value>
</parameter>
<parameter>
<name>password</name>
<value>DBPassword</value>
</parameter>
<!-- Class name for mm.mysql JDBC driver -->
<parameter>
<name>driverClassName</name>
<value>COM.ibm.db2.jdbc.app.DB2Driver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:db2:smsdb</value>
</parameter>
</ResourceParams>
</Context>
this is my connection class DBUtil.java
package com.ebizon.util.jdbc;
import java.sql.*;
import java.util.*;
import javax.naming.*;
import javax.sql.*;
public class DBUtil {
/* Ebizon DB Connection for Tomcat */
public static Connection getEbizDBConnection() throws NamingException,
SQLException {
Connection conn = null;
try {
InitialContext initCtx = new InitialContext();
Context envContext = (Context)initContext.lookup
("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup
("jdbc/SmsDBDS");
conn = ds.getConnection();
} catch (NamingException ne) {
throw ne;
} catch (SQLException se) {
throw se;
}
return conn;
}
}
All my Jsp are in /usr/local/jakartha-tomcat-4.0.3/webapps/acs
Do I need to configure web.xml file which is under WEB-INF ?
I guess you also experienced similar problems some time back
have you solved it?
Pls help me to solve this problem
Thanks in advance
Waiting for your mail
With regards
Madhu Chundu
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-dev-help@jakarta.apache.org