My url is jdbc:oracle:thin:@ora.mydomain.com:1521:SID


-----Original Message-----
From: g k [mailto:[EMAIL PROTECTED] 
Sent: February 15, 2005 5:15 PM
To: tomcat-user@jakarta.apache.org
Subject: RE: Cannot create JDBC driver of class '' for connect URL 'null'


yes have defined that

<!-- Global JNDI resources -->
  <GlobalNamingResources>

    <!-- Test entry for demonstration purposes -->
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>

    <!-- Editable user database that can also be used by
         UserDatabaseRealm to authenticate users -->
    <Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
       description="User database that can be updated and saved">
    </Resource>
    <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>

    <Resource name="jdbc/myoracle" auth="Container"
              type="javax.sql.DataSource"/>

        <ResourceParams name="jdbc/myoracle">
        <parameter>
    <name>factory</name>
    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
        </parameter>
        <parameter>
    <name>driverClassName</name>
    <value>oracle.jdbc.driver.OracleDriver</value>
        </parameter>
        <parameter>
    <name>url</name>
    <value>jdbc:oracle:thin:[EMAIL PROTECTED]:1521:mysid</value>
        </parameter>
        <parameter>
    <name>username</name>
    <value>******</value>
        </parameter>
        <parameter>
    <name>password</name>
    <value>******</value>
         </parameter>
        <parameter>
    <name>maxActive</name>
    <value>20</value>
        </parameter>
        <parameter>
    <name>maxIdle</name>
    <value>10</value>
        </parameter>
        <parameter>
    <name>maxWait</name>
    <value>-1</value>
        </parameter>
        </ResourceParams>


  </GlobalNamingResources>

>From: Phillip Qin <[EMAIL PROTECTED]>
>Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>To: 'Tomcat Users List' <tomcat-user@jakarta.apache.org>
>Subject: RE: Cannot create JDBC driver of class '' for connect URL 
>'null'
>Date: Tue, 15 Feb 2005 13:32:59 -0500
>
>Didn't you define url, password etc. in your server.xml 
><GlobalNamingResources>?
>
>-----Original Message-----
>From: g k [mailto:[EMAIL PROTECTED]
>Sent: February 15, 2005 12:49 PM
>To: tomcat-user@jakarta.apache.org
>Subject: RE: Cannot create JDBC driver of class '' for connect URL 
>'null'
>
>
>Server.xml contains :
>
><Resource name="jdbc/myoracle" auth="Container" 
>type="javax.sql.DataSource"/> No context tag is in server.xml
>
>Context.xml file contains
><Context>
><ResourceLink global="jdbc/myoracle" name="jdbc/myoracle" 
>type="javax.sql.DataSource"/> </Context>
>
>
> >From: Phillip Qin <[EMAIL PROTECTED]>
> >Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> >To: 'Tomcat Users List' <tomcat-user@jakarta.apache.org>
> >Subject: RE: Cannot create JDBC driver of class '' for connect URL 
> >'null'
> >Date: Tue, 15 Feb 2005 11:33:35 -0500
> >
> >In your context.xml or server.xml, you would define your jdbc 
> >resource. Find out that url and post it here. Jdbc driver and 
> >location are correct.
> >
> >-----Original Message-----
> >From: g k [mailto:[EMAIL PROTECTED]
> >Sent: February 15, 2005 11:25 AM
> >To: [EMAIL PROTECTED]; tomcat-user@jakarta.apache.org
> >Subject: RE: Cannot create JDBC driver of class '' for connect URL 
> >'null'
> >
> >
> >
> >Hi
> >
> >
> >ojdbc14.jar - is in the tomcat/common/lib directory
> >
> >post jdc url? - not to clear on what this is?
> >
> >do i need to create a context.xml?
> >
> >regards
> >
> >Gurpreet
> >
> > >From: "David Short" <[EMAIL PROTECTED]>
> > >Reply-To: <[EMAIL PROTECTED]>
> > >To: "'Tomcat Users List'" <tomcat-user@jakarta.apache.org>
> > >Subject: RE: Cannot create JDBC driver of class '' for connect URL 
> > >'null'
> > >Date: Tue, 15 Feb 2005 07:18:58 -0800
> > >
> > >Rename the Oracle classes12.zip file to classes12.jar and move to 
> > >the tomcat\common\lib directory.
> > >
> > >-----Original Message-----
> > >From: Phillip Qin [mailto:[EMAIL PROTECTED]
> > >Sent: Tuesday, February 15, 2005 6:39 AM
> > >To: 'Tomcat Users List'
> > >Subject: RE: Cannot create JDBC driver of class '' for connect URL 
> > >'null'
> > >
> > >
> > >Post your jdbc url.
> > >
> > >-----Original Message-----
> > >From: g k [mailto:[EMAIL PROTECTED]
> > >Sent: February 15, 2005 6:44 AM
> > >To: tomcat-user@jakarta.apache.org
> > >Subject: Cannot create JDBC driver of class '' for connect URL 
> > >'null'
> > >
> > >
> > >Hi
> > >
> > >I have added Oracle resource params to the server.xml file and 
> > >reference parameters to oracle in the web.xml
> > >
> > >When i startup tomcat - i get the following error:
> > >
> > >11:20:38,385 [ConnectDB.java] [ConnectDB] 
> > >[getConnectionPoolForOracle:101]
> > >-
> > >
> > >ERR
> > >OR - failed to get the connection:
> > >org.apache.commons.dbcp.SQLNestedException: C
> > >annot create JDBC driver of class '' for connect URL 'null', cause: 
> > >No suitable driver 11:20:38,385 [SendMessageAction.java] 
> > >[SendMessageAction] [Send:227] - DEBUG
> > >
> > >- C
> > >onnection after:
> > >null
> > >java.net.MalformedURLException: no protocol:
> > >         at java.net.URL.<init>(URL.java:537)
> > >         at java.net.URL.<init>(URL.java:434)
> > >         at java.net.URL.<init>(URL.java:383)
> > >         at 
> > >com.csc.nhs.web.legacypas.struts.action.SendMessageAction.Send(Send
> > >Me
> > >ssageAction.java:231)
> > >
> > >any thoughts?
> > >
> > >regards
> > >
> > >Gurpreet
> > >
> > >
> > >
> > >-------------------------------------------------------------------
> > >--
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >
> > >
> > >
> > >
> > >
> > >
> > >-------------------------------------------------------------------
> > >--
> > >To unsubscribe, e-mail: [EMAIL PROTECTED]
> > >For additional commands, e-mail: [EMAIL PROTECTED]
> > >
> >
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> >
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


!DSPAM:421274eb134511175816384!

Reply via email to