Hi Bernard, This problem is 'windows' (yes, spealt...B:A:D)..related. This application needs to run on a HP Unix box but the development is happening on a XP pc using Eclipse (don't ask...;-)) . It actually works if I place the exact resource entry I posted in the "catalina/localhost/<appname>.xml" file - on Unix. I have the 'exact' same tomcat version running on the XP box. I went back to basics and found that not even a standard DB connection creation in the servlet works: Class.forName("com.sybase.jdbc3.jdbc.SybDriver"); Connection conn = DriverManager.getConnection( "jdbc:sybase:Tds:xx.xxx.xxx.xx:5001", "foobar", "badabing");
Same code works on the unix box. Not sure why it be different. The XP box in question can talk to Sybase using the Sybase openclient - so I am guessing it is related to the JDBC/jar file on the PC?.... Having said that, what you suggest below is interesting and I will address once I have "hello world" on XP working.... Thanks for your help. Jack "Durfee, Bernard" <[EMAIL PROTECTED]> wrote: Since the element is outside of the server.xml file, you don't need the 'path' attribute. From http://tomcat.apache.org/tomcat-5.5-doc/config/context.html "The value of this field [path] must not be set except when statically defining a Context in server.xml, as it will be inferred from the filenames used for either the .xml context file or the docBase." Also, the docBase is only needed when your web application is outside of the 'webapps' directory. "You may specify an absolute pathname for this directory or WAR file, or a pathname that is relative to the appBase directory of the owning Host." But those are probably unrelated to the JDBC issue. Make sure that your JDBC driver is in the common/lib directory with the DBCP jar files. Since the Tomcat DBCP library will be instantiating the driver, it needs to be able to find the driver in the same classloader. See http://tomcat.apache.org/tomcat-5.5-doc/class-loader-howto.html Now as far as the message itself, most would scoff at the idea that a non-useful error message is a critical bug, but your frustration demonstrates how poor error messages are just as damaging as "real" bugs! SQLState: null Code: 0 Message: Cannot create JDBC driver of class '' for connect URL 'null' How useful! DBCP is not much better, their error logging is nearly non-existent. Bernie Durfee > -----Original Message----- > From: g m [mailto:[EMAIL PROTECTED] > Sent: Friday, January 20, 2006 6:22 AM > To: Tomcat Users List > Subject: RE: Absolute Guide for config of JDBC Connection Pool ? > > > Ok, I have tried it....it fails ..or maybe I am helping it fail? > > Been fighting with it all morning......I followed your > email and the doc...here are my entries/values..any opinions > on what else to try? > > > 1. Resource entry values > > > > type="javax.sql.DataSource" > auth="Container" > driverClassName="com.sybase.jdbc3.jdbc.SybDriver" > url="jdbc:sybase:Tds:10.xx.xxx.xx:5001" > username="xxxxx" > password="xxxx" > maxIdle="15" > maxActive="50" > maxWait="10000" > factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" > removeAbandoned="true" > removeAbandonedTimeout="60" > logAbandoned="true"/> > > > 2. web.xml entry > > Sybase Connection Resource > > jdbc/deebee > javax.sql.DataSource > Container > > > 3. Java code - error checking left out... > > Context ctx = new InitialContext(); > DataSource ds = (DataSource) > ctx.lookup("java:comp/env/jdbc/deebee"); > Connection dbconn = ds.getConnection() ; > > 5. Put resource entry in file > conf/Catalina/localhost/DBS3.xml with following error: > > "WARNING: A docBase C:\Program Files\Apache Software Foundation\ > Tomcat 5.5\webapps\DBS3 inside the host appBase has been > specified, and will be ignored" > > 6. Put resource entry in server.xml with error. > > SQLState: null > Code: 0 > Message: Cannot create JDBC driver of class '' for > connect URL 'null' > > > 7. Put it in webapps/DBS3/META-INF/context.xml with error. > > SQLState: null > Code: 0 > Message: Cannot create JDBC driver of class '' for > connect URL 'null' > > > any suggestions gladly taken .... > Thanks! > > > > > > > g m wrote: > Agreed! Simple no-nonsense description - I shall give it a > 'whirl' ..... > > Thanks Len - your on my Xmas list ;-) > > "Durfee, Bernard" wrote: > Excellent! That is the exact documentation that should be on > the Tomcat > site. It would also be nice to see a quick description of how Tomcat > processes the sections, what exactly it does with the > attributes, so that other drivers and pools can be configured. > > There are also other parameters that DBCP accepts... > > http://jakarta.apache.org/commons/dbcp/configuration.html > > Bernie Durfee > > > > > -----Original Message----- > > From: Len Popp [mailto:[EMAIL PROTECTED] > > Sent: Thursday, January 19, 2006 12:58 PM > > To: Tomcat Users List > > Subject: Re: Absolute Guide for config of JDBC Connection Pool ? > > > > > > I don't know if there's a complete top-to-bottom guide, but here's > > what I know from setting up connection pooling under 5.5.12: > > > > 1. The JDBC driver JAR must go in the common/lib directory (because > > for connection pooling it needs to be accessible to both Tomcat and > > the web app). > > > > 2. DBCP is built into Tomcat so you don't need to install a > > JAR for that. > > > > 3. The tag goes inside the tag for the web app, > > wherever it is (server.xml, webapps//META-INF/context.xml or > > conf/Catalina/localhost/.xml) > > Note that the syntax for has changed from earlier versions > > - see the Tomcat documentation. Here's a sample: > > > > > type="javax.sql.DataSource" > > auth="Container" > > driverClassName="com.mysql.jdbc.Driver" > > url="jdbc:mysql://localhost:3306/???" > > username="???" > > password="???" > > maxIdle="15" > > maxActive="50" > > maxWait="10000" > > factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" > > removeAbandoned="true" > > removeAbandonedTimeout="60" > > logAbandoned="true"/> > > > > The "???" bits are installation-dependent. Some of the > parameters will > > be different for Sybase (driverClassName and url for sure). > > > > 4. Yes, it is supposed to say "... .dbcp.dbcp ..." in the > > factory= line. > > > > 5. The code to get a DB connection is: > > InitialContext initCtx = new InitialContext(); > > DataSource ds = (DataSource) > > initCtx.lookup("java:comp/env/jdbc/???"); > > Connection conn = ds.getConnection(); > > Make sure that "jdbc/???" is the same here as in the tag. > > > > 6. Always close the connection when you're done with it. Use a > > "finally" block to make sure. > > > > 7. If you're trying to decide where to put the declaration, > > the choices are: > > - server.xml - Don't put it here. We're told it's bad. > > - webapps//META-INF/context.xml - If you put it here, it will be > > bundled up in the app's WAR file. That makes it easier to > install, but > > harder to configure if every installation has different details for > > the database tag. > > - conf/Catalina/localhost/.xml - If you put it here, it's easier > > to edit the tag, but it's an extra file to be installed in > > addition to the WAR. > > > > Hope this helps. At least it's shorter than > > http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-exampl > es-howto.html. > :-) > > On 1/19/06, g m wrote: > > There seems to be 'truckloads' of information on just as many forums > on how best to setup a JDBC connection pool, varying from > which file to > put what entries (server.xml, context.xml, web.xml) etc.... > > > > It looks like the same questions be asked in a slightly different > fashion and for different environments. > > > > Does anyone happen to know where there is a definative guide on how > to do this and what jar files one needs ?... or does this > sort of 'clean > doc' not exist ? > > > > FYI: My environment: Tomcat 5.5.9, Sybase, Windows . > > Many thanks! > > -- > Len > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------- > Yahoo! Autos. Looking for a sweet ride? Get pricing, reviews, > & more on new and used cars. > > > > --------------------------------- > Yahoo! Photos - Showcase holiday pictures in hardcover > Photo Books. You design it and we'll bind it! > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------- What are the most popular cars? Find out at Yahoo! Autos