Yeap, Daniel. It's there. As I mentioned, I performed the very same test I'm doing right now, but without DataSource and it works.
Now that you mention it, I read in some place that it was necessary to remove the java.sql.* package from the jdbc jar file. I don't know if that is true and, if so, why would that be necessary? Could that have something to do with this problem? (it would be something very odd since it would be affecting exclusively the behaviour of the DataSource, according to what I stated on the previous paragraph. Regards, Freddy. -----Mensaje original----- De: Daniel Huang [mailto:[EMAIL PROTECTED] Enviado el: lunes, 12 de abril de 2004 20:57 Para: Tomcat Users List Asunto: RE: JNDI and DataSource Where did you put your db driver jar file? You want to put it under $CATILINA/common/lib. Regards, Daniel -----Original Message----- From: Freddy Villalba Arias [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 10:19 AM To: Tomcat Users List Subject: RE: JNDI and DataSource Tested it. Same result... same problem. A side comment: the positive part of the other config file (the one I had originally) was that you could trace how Tomcat loaded the Resources. Then, you could see how the tags actually got processed (read) correctly. But then, something happens when the factory builds the DataSource object. Regards, 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] --------------------------------------------------------------------- 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]
