Hi Guy, That's interesting. I hadn't thought about that possibility. I'll try it.
However, let me state that I don't think that's the problem (hope I'm wrong, of course!) since the inspection (JBuilder inspector) on the java variable holding the reference to the DataSource object reveals that the properties are indeed not being populated (in fact, there is an attribute "dataSource" which I suppose is intended for holding the actual DataSource and it's null as well). Anyway, can't discard anything and your help is appreciated. Will let you know the outcome of this test. Cheers, Freddy. -----Mensaje original----- De: Guy Pardon [mailto:[EMAIL PROTECTED] Enviado el: lunes, 12 de abril de 2004 19:02 Para: Tomcat Users List Asunto: Re: JNDI and DataSource 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. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
