You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tomcat.apache.org by Jitendra Kharche <Ji...@geometricsoftware.com> on 2006/06/26 07:30:04 UTC
Using Datasource in Tomcat 5.5
Hi there, can anybody help me on this. I have posted this problem in
user mailing list 3-4 times in last two weeks but I havn't got any reply
that can solve my problem. Please help me.
Problem:
I am using Tomcat 5.5.17 and tried running a sample datasource
application having a jsp page (see contents below) using the Cloudscape
database. I have added the driver jar into CATALINA_HOME/common/lib
directory. When I run the jsp I get following exception
WARNING: Unexpected exception resolving reference
java.lang.NoSuchMethodException:
com.ibm.db2j.jdbc.DB2jDataSource.setScope(boolean)
at java.lang.Class.getMethod(Class.java:1581)
at
com.ibm.db2j.jdbc.DB2jAbstractDataSource.getObjectInstance(Unknown
Source)
........
************************************************************************
********
Contents of file CATALINA_HOME/webapps/myApp/dbdemo.jsp
************************************************************************
********
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.naming.*" %>
<%
Connection con = null;
Statement stmt = null;
try {
Context initContext = new InitialContext();
Context envContext =
(Context)initContext.lookup("java:comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/MyDB");
System.out.println("Got DataSource\n");
con = ds.getConnection();
System.out.println("Got Connection\n"); }
catch(java.lang.Exception e) {
e.printStackTrace();
System.err.print(e.getClass().getName());
System.err.println(e.getMessage());
}
try {
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM employee");
System.out.println("Table assignment after insertion:");
%>
Your table contains the following entries:<BR>
<table>
<tr><B><th>emp_id</th><th>emp_name</th><th>emp_dept</th></B></tr>
<%
while (rs.next()) {
String emp_id = rs.getString("emp_id");
String emp_name = rs.getString("emp_name");
String emp_dept = rs.getString("emp_dept");
%>
<tr>
<td><%=emp_id%></td><td><%=emp_name%></td><td><%=emp_dept%></td>
</tr>
</table>
<%
}
rs.close(); stmt.close(); con.close();
}
catch(java.lang.Exception e) {
e.printStackTrace();
}%>
************************************************************************
********
Contents of file CATALINA_HOME/conf/server.xml
************************************************************************
********
<?xml version="1.0" encoding="UTF-8"?>
<Server>
<Listener className="org.apache.catalina.core.AprLifecycleListener"/>
<Listener
className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/
>
<Listener
className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"
/>
<Listener
className="org.apache.catalina.mbeans.ServerLifecycleListener"/>
<GlobalNamingResources>
<Environment name="simpleValue" type="java.lang.Integer"
value="30"/>
<Resource auth="Container"
description="User database that can be updated and saved"
name="UserDatabase" type="org.apache.catalina.UserDatabase"
pathname="conf/tomcat-users.xml"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"/>
<Resource name="jdbc/MyDB" type="javax.sql.DataSource"
password="password" driverClassName="com.ibm.db2j.jdbc.DB2jDriver"
maxIdle="2" maxWait="5000" username="user"
url="jdbc:db2j:E:/apache-tomcat-5.5.17/webapps/datasourcedemo/SampleDB"
maxActive="4"/>
</GlobalNamingResources>
<Service name="Catalina">
<Connector port="8080" redirectPort="8443" minSpareThreads="25"
connectionTimeout="20000" maxSpareThreads="75" maxThreads="150">
</Connector>
<Connector port="8009" redirectPort="8443" protocol="AJP/1.3">
</Connector>
<Engine defaultHost="localhost" name="Catalina">
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
<Host appBase="webapps" name="localhost">
</Host>
</Engine>
</Service>
</Server>
************************************************************************
********
Contents of file CATALINA_HOME/webapps/myApp/WEB-INF/web.xml
************************************************************************
********
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"
xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<display-name>
datasourcedemo</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<resource-ref>
<res-ref-name>jdbc/MyDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
************************************************************************
********
Contents of file CATALINA_HOME/webapps/myApp/META-INF/context.xml
************************************************************************
********
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource auth="Container" name="jdbc/MyDB"
type="com.ibm.db2j.jdbc.DB2jDataSource"
password="password" driverClassName="com.ibm.db2j.jdbc.DB2jDriver"
factory="com.ibm.db2j.jdbc.DB2jConnectionPoolDataSource"
maxIdle="4" testOnBorrow="true" validationQuery="select 1"
username="user"
url="jdbc:db2j:E:/apache-tomcat-5.5.17/webapps/datasourcedemo/SampleDB"
timeBetweenEvictionRunsMillis="30000" maxActive="8"/> </Context>
Regards,
Jitendra
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
Re: Using Datasource in Tomcat 5.5
Posted by sarma <ss...@mahindrabt.com>.
HI,
i am working with oracle database when i places classes12.jar file in
D:\Tomcat 5.0\common\lib
i faced same problem.
just try like this remove the jar file (delete it and then undelete the
jar file)
and start th tomcat server so that thei changes made in that folder is
read by tomcat so that yor classes
is identified
i think it will help you.
with regards
shannu sarma
--
View this message in context: http://www.nabble.com/Using-Datasource-in-Tomcat-5.5-tf1847100.html#a5060082
Sent from the Tomcat - Dev forum at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org
Re: Using Datasource in Tomcat 5.5
Posted by Mark Thomas <ma...@apache.org>.
Jitendra Kharche wrote:
> Hi there, can anybody help me on this. I have posted this problem in
> user mailing list 3-4 times in last two weeks but I havn't got any reply
> that can solve my problem. Please help me.
This message does not belong on the dev list. Please keep this thread
on the users list.
You should probably read http://tomcat.apache.org/lists.html and
http://tomcat.apache.org/faq/tomcatuser.html#why
Mark
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org