tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kris Rasmussen <kris_rasmus...@yahoo.com>
Subject Re: configure data source
Date Sun, 18 Apr 2004 08:14:10 GMT
Yeah its confusing. In your global naming resources
you need to declare a resource and then a seperate
group of resource params with the same name. For your
app context look below at my example (....) is the
name of your app.

<Host name="localhost" debug="0" appBase="webapps"
       unpackWARs="true" autoDeploy="true"
       xmlValidation="false"
xmlNamespaceAware="false">

       <Context path="/...." docBase="...."
        debug="5" reloadable="true"
crossContext="true">

  
        <Logger
className="org.apache.catalina.logger.FileLogger"
                 directory="logs" 
prefix="localhost_log." suffix=".txt"
            timestamp="true"/>
            
            <ResourceLink name="jdbc/...."
            global="jdbc/...."
            type="javax.sql.DataSource"/>

      </Context>

--- twcTC <twc7183590290@earthlink.net> wrote:
> I have the same problem. please help.
> ===============================detail
> info==============
> hello all,
> 
> I need help.
> I am using jwsdp-1.3. I am trying to connect to
> oracle 8.1.5 database using DataSource.
> I get sqlexception 
> "java.sql.SQLException: Cannot load JDBC driver
> class".
> 
> I have put oracle jdbc classes12.zip into
> /common/lib/classes12.jar.
> (I rename classes12.zip to classes12.jar)
> 
> Thank you very much.
> It took me a lot of time.
> 
> --Tony
> 
> The following is config and code files.
> 
> conf/server.xml
> ========
> <?xml version='1.0' encoding='utf-8'?>
> <Server
> className="org.apache.catalina.core.StandardServer"
> debug="0"
> port="8005" shutdown="SHUTDOWN">
>   <Listener
>
className="org.apache.catalina.mbeans.ServerLifecycleListener"
> debug="0"/>
>   <Listener
>
className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
> debug="0"/>
>   <GlobalNamingResources>
>     <Environment description="Absolute Pathname of
> the JWSDP Installation"
> name="jwsdp.home" override="true"
> type="java.lang.String"
> value="D:\jwsdp13"/>
>     <Environment name="simpleValue" override="true"
> type="java.lang.Integer" value="30"/>
>     <Resource auth="Container" description="User
> database
> that can be updated and saved" name="UserDatabase"
> scope="Shareable"
> type="org.apache.catalina.UserDatabase"/>
>     <Resource name="jdbc/myoracle" scope="Shareable"
> type="javax.sql.DataSource"/>
>     <ResourceParams name="UserDatabase">
>       <parameter>
>         <name>factory</name>
>        
>
<value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>
>       </parameter>
>       <parameter>
>         <name>pathname</name>
>         <value>conf/tomcat-users.xml</value>
>       </parameter>
>     </ResourceParams>
>     <ResourceParams name="jdbc/myoracle">
>       <parameter>
>         <name>maxWait</name>
>         <value>5000</value>
>       </parameter>
>       <parameter>
>         <name>maxActive</name>
>         <value>4</value>
>       </parameter>
>       <parameter>
>         <name>password</name>
>         <value>tiger</value>
>       </parameter>
>       <parameter>
>         <name>url</name>
>        
>
<value>jdbc:oracle:thin:@127.0.0.1:1521:dellorcl</value>
>       </parameter>
>       <parameter>
>         <name>driverClassName</name>
>        
> <value>oracle.jdbc.driver.OracleDriver</value>
>       </parameter>
>       <parameter>
>         <name>maxIdle</name>
>         <value>2</value>
>       </parameter>
>       <parameter>
>         <name>username</name>
>         <value>scott</value>
>       </parameter>
>     </ResourceParams>
>   </GlobalNamingResources>
>   <Service
> className="org.apache.catalina.core.StandardService"
> debug="0" name="Java Web Services Developer Pack">
>     <Connector
>
className="org.apache.coyote.tomcat5.CoyoteConnector"
> acceptCount="100" bufferSize="2048"
> clientAuth="false"
> compression="off" connectionLinger="-1"
> connectionTimeout="20000"
> connectionUploadTimeout="300000" debug="0"
> disableUploadTimeout="true"
> enableLookups="true" keepAlive="true"
> maxKeepAliveRequests="100"
> maxProcessors="100" minProcessors="5" port="8080"
> protocol="HTTP/1.1"
>
protocolHandlerClassName="org.apache.coyote.http11.Http11Protocol"
> proxyPort="0" redirectPort="8443" scheme="http"
> secure="false" serverSocketTimeout="0"
> tcpNoDelay="true"
> tomcatAuthentication="true" xpoweredBy="true">
>     </Connector>
>     <Engine
> className="org.apache.catalina.core.StandardEngine"
> backgroundProcessorDelay="10" baseDir="D:\jwsdp13"
> debug="0"
> defaultHost="localhost" domain="Catalina"
> name="Catalina">
>       <Host
> className="org.apache.catalina.core.StandardHost"
> appBase="webapps"
> autoDeploy="true" backgroundProcessorDelay="-1"
>
configClass="org.apache.catalina.startup.ContextConfig"
>
contextClass="org.apache.catalina.core.StandardContext"
> debug="0"
> deployOnStartup="true" deployXML="true"
> domain="Catalina"
>
errorReportValveClass="org.apache.catalina.valves.ErrorReportValve"
> liveDeploy="true" name="localhost"
> unpackWARs="false"
> xmlNamespaceAware="false" xmlValidation="false">
>         <Valve
>
className="org.apache.catalina.authenticator.SingleSignOn"
> debug="0"/>
>       </Host>
>       <Logger
> className="org.apache.catalina.logger.FileLogger"
> debug="0" directory="logs" prefix="jwsdp_log."
> suffix=".txt" timestamp="true" verbosity="1"/>
>       <Realm
>
className="org.apache.catalina.realm.UserDatabaseRealm"
> debug="0" resourceName="UserDatabase"
> validate="true"/>
>       <Valve
>
className="org.apache.catalina.valves.AccessLogValve"
> debug="0" directory="logs"
> fileDateFormat="yyyy-MM-dd"
> pattern="%h %l %u %t &quot;%r&quot; %s %b"
> prefix="access_log."
> resolveHosts="false" rotatable="true"
> suffix=".txt"/>
>     </Engine>
>   </Service>
> </Server>
> ========
> 
> /hello1/build/Wen-inf/web.xml
> =========================
> <?xml version="1.0" encoding="UTF-8"?>
> <web-app 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>hello1</display-name>
>   <servlet>
>     <display-name>GreetingServlet</display-name>
>     <servlet-name>GreetingServlet</servlet-name>
>    
>
<servlet-class>servlets.GreetingServlet</servlet-class>
>   </servlet>
>   <servlet>
>     <display-name>ResponseServlet</display-name>
>     <servlet-name>ResponseServlet</servlet-name>
>    
>
<servlet-class>servlets.ResponseServlet</servlet-class>
>   </servlet>
>   <servlet-mapping>
>     <servlet-name>GreetingServlet</servlet-name>
>     <url-pattern>/greeting</url-pattern>
>   </servlet-mapping>
>   <servlet-mapping>
>     <servlet-name>ResponseServlet</servlet-name>
>     <url-pattern>/response</url-pattern>
>   </servlet-mapping>
> <resource-ref>
>  <description>Oracle Datasource
> example</description>
>  <res-ref-name>jdbc/myoracle</res-ref-name>
>  <res-type>javax.sql.DataSource</res-type>
>  <res-auth>Container</res-auth>
> </resource-ref>
> </web-app>
> =========================
> 
> /Catalina/localhost/hello1.xml
> =======================
> 
=== message truncated ===



	
		
__________________________________
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25
http://photos.yahoo.com/ph/print_splash

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message