Hi,
The fact that you get 'No suitable driver' could also mean that the chosen properties are incompatible (as opposed to not set).
Just a guess: did you try to specify the user and password as part of the URL? (jdbc:oracle:thin:user/[EMAIL PROTECTED])
That's the way I usually connect to oracle.
You never know, maybe that's it...
HTH,
Guy
http://www.atomikos.com - Our JTA for your transactions
On maandag, apr 12, 2004, at 18:35 Europe/Brussels, Freddy Villalba Arias wrote:
<image.tiff>
Hi Sandy,
Thanks, it certainly looked better than mine. I appreciate it. However, the problem persists…
Any other suggestion? (I’ll keep looking at it, too… obviously)
-----Mensaje original----- De: Sandy McArthur [mailto:[EMAIL PROTECTED] Enviado el: lunes, 12de abril de 2004 18:29 Para: Tomcat Users List Asunto: Re: JNDI and DataSource
This shouldn't be all that different, but this is the server.xml I'd
use on my setup.
<?xml version="1.0" encoding="UTF-8"?>
<Server debug="5" port="8081" shutdown="SHUTDOWN">
<GlobalNamingResources>
<Resource name="jdbc/cnid" scope="Shareable"
type="javax.sql.DataSource" cached="false"/>
<ResourceParams name="jdbc/cnid">
<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:@BMSRVORACLE:1521:BMSRVMS</value>
</parameter>
<parameter>
<name>username</name>
<value>SGC_CNID</value>
</parameter>
<parameter>
<name>password</name>
<value>****</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</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>
<Service name="Tomcat-Standalone">
<Connector acceptCount="10"
className="org.apache.coyote.tomcat4.CoyoteConnector"
connectionTimeout="60000" debug="0" maxProcessors="75" minProcessors="5"
port="8080"/>
<Engine debug="5" defaultHost="localhost" name="Standalone">
<Host
appBase="C:\Usuarios\fvillalba\project\SGC\SGC_CNID\FUENTES\java\Acceso
a datos\Tomcat\webapps" debug="5" name="localhost" unpackWARs="true">
<DefaultContext>
<ResourceLink name="jdbc/cnid"
global="jdbc/cnid"
type="javax.sql.DataSource"/>
</DefaultContext>
<Context path="wa" docBase="..\..\Testing" debug="5"
reloadable="true">
</Context>
<Context path="" docBase="..\..\Testing" debug="5"
reloadable="true">
</Context>
</Host>
</Engine>
</Service>
</Server>
HTH
Sandy
On Apr 12, 2004, at 11:36 AM, Freddy Villalba Arias wrote:
> Yes and no... :)
>
> I have only one web application to be deployed (wa). Then, I read in
> some places that it's mandatory to have a default context. I tried
> defining a <DefaultContext> but then Tomcat's initialization failed (I
> looked for something odd but couldn't find anything). So, I decided to
> "create" a default (dummy) web app "by hand". That's the only intent of
> that second web app. It doesn't even exist (there is no WEB-INF
> directory, leave alone web.xml). The good part: that solved the
> initialization problem.
>
> So, it's not what I originally wanted (I'd remove it if I knew how to
> "elegantly" solve the dummy web app - or just no default web app, if
> possible - issue), but it does the job for now (if you can provide some
> insight on this other subject, I would also appreciate it).
>
> HTH.
>
> -----Mensaje original-----
> De: Sandy McArthur [mailto:[EMAIL PROTECTED]
> Enviado el: lunes, 12 de abril de 2004 17:32
> Para: Tomcat Users List
> Asunto: Re: JNDI and DataSource
>
> You have a default context right after the wa context that doesn't
> specify a <Resource . Is that what you meant?
>
> Sandy
>
> On Apr 12, 2004, at 9:44 AM, Freddy Villalba Arias wrote:
>
>> [...]
>> </ResourceParams>
>>
>> </Context>
>>
>> <Context path="" docBase="..\..\Testing" debug="5"
>> reloadable="true">
>>
>> </Context>
>>
>> </Host>
>>
>> [...]
>
>
> ---------------------------------------------------------------------
> 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]
Dr. Guy Pardon ( [EMAIL PROTECTED] ) Atomikos: Your Partner for Reliable eBusiness Coordination http://www.atomikos.com/
The information in this email is confidential and only meant for the addressee(s). The content of this email is informal and will not be legally binding for Atomikos.