Sorry - wrong wget lines - I meant to provide this statement: wget http://jdbc.postgresql.org/download/pg74.215.jdbc2.jar
I then untarred it in the common lib directory. I tried both the type 2 and type 3 driver. Thanks, - Ole --- Ole Ersoy <[EMAIL PROTECTED]> wrote: > David, > > I downloaded it and un-zipped it here: > > > cd /usr/local/jakarta-tomcat-5.5.7/common/lib > >- wget > >http://cvs.apache.org/builds/jakarta-taglibs/nightly/jakarta-taglibs-20050303.tar.gz > >- tar xzf jakarta-taglibs-20050303.tar.gz > > I've tried both type two and type 3 drivers, since > the > example was a bit vague on which driver is currently > supported by DBCP. > > Thanks though, > - Ole > --- David Smith <[EMAIL PROTECTED]> wrote: > > > One of the only things I don't see here -- and > it's > > a big one -- no > > postgresql jdbc driver in common/lib. Tomcat > > doesn't come with it by > > default. You have to download the latest and > > install it before this > > will work. > > > > --David > > > > Ole Ersoy wrote: > > > > >Hi everybody, > > > > > >I'm attempting to get the JNDI Datasource How To > > >example for Postgresql to work. > > > > > >Here is the URL for the example: > > > >http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html > > > > > >After completing the listed steps the test.jsp > > error > > >page reports: > > >"java.sql.SQLException: No suitable driver" > > > > > >Here are all my configuration steps, including > the > > >files: > > >- On Fedora Core 3 - adduser postgres > > >- passwd postgres (set to postgres) > > >- chown postgres /var/lib/pqsql/data > > >- /usr/bin/initdb -D /var/lib/pgsql/data > > >- /usr/bin/postmaster -D /var/lib/pgsql/data > > >logfile > > >2>&1 & > > >- createdb test postgres > > >- psql test > > >create table testdata (id int not null primary > key, > > >foo varchar(25), bar int); > > >insert into testdata values(1, 'hello', 12345); > > >- Update server.xml with this under the </Host> > > tag: > > ><Resource name="jdbc/postgres" auth="Container" > > > type="javax.sql.DataSource" > > >driverClassName="org.postgresql.Driver" > > > > > url="jdbc:postgresql://127.0.0.1:5432/mydb" > > > username="postgres" password="postgres" > > >maxActive="20" maxIdle="10" maxWait="-1"/> > > ></Context> > > > cd /usr/local/jakarta-tomcat-5.5.7/common/lib > > >- wget > > > >http://cvs.apache.org/builds/jakarta-taglibs/nightly/jakarta-taglibs-20050303.tar.gz > > >- tar xzf jakarta-taglibs-20050303.tar.gz > > >- mkdir /var/www/webapps/dbtest > > >- vi /var/www/webapps/dbtest/test.jsp (I put the > > >example code here) > > >Here it is just in case: > > > > > > > > ><%@ taglib uri="http://java.sun.com/jsp/jstl/sql" > > >prefix="sql" %> > > ><%@ taglib > uri="http://java.sun.com/jsp/jstl/core" > > >prefix="c" %> > > > > > ><sql:query var="rs" dataSource="jdbc/TestDB"> > > >select id, foo, bar from testdata > > ></sql:query> > > > > > ><html> > > > <head> > > > <title>DB Test</title> > > > </head> > > > <body> > > > > > > <h2>Results</h2> > > > > > ><c:forEach var="row" items="${rs.rows}"> > > > Foo ${row.foo}<br/> > > > Bar ${row.bar}<br/> > > ></c:forEach> > > > > > > </body> > > ></html> > > > > > >- mkdir /var/www/webapps/dbtest/WEB-INF/ > > >- vi /var/www/webapps/dbtest/WEB-INF/web.xml > > > > > >I have the following in web.xml > > ><web-app xmlns="http://java.sun.com/xml/ns/j2ee" > > > > > > >xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > > > > > > >xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee > > >http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" > > > version="2.4"> > > > <description>Postgre Test App</description> > > > <resource-ref> > > > <description>DB Connection</description> > > > <res-ref-name>jdbc/test</res-ref-name> > > > <res-type>javax.sql.DataSource</res-type> > > > <res-auth>Container</res-auth> > > > </resource-ref> > > ></web-app> > > > > > >I now copy the necessary tag libraries over to > the > > >application directory: > > >- mkdir /var/www/webapps/dbtest/WEB-INF/lib > > >- cp > > > >/usr/local/jakarta-tomcat-5.5.7/common/lib/jakarta-taglibs/standard/lib/jstl.jar > > >standard.jar /var/www/webapps/dbtest/WEB-INF/lib > > >- cp > > > >/usr/local/jakarta-tomcat-5.5.7/common/lib/jakarta-taglibs/standard/tld/* > > >/var/www/webapps/dbtest/WEB-INF > > > > > >- catalina.sh run > > >- http://localhost:8080/dbtest/test.jsp > > >- And the console gives the following: > > > > > >[EMAIL PROTECTED] local]# catalina.sh run > > >Using CATALINA_BASE: > > /usr/local/jakarta-tomcat-5.5.7 > > >Using CATALINA_HOME: > > /usr/local/jakarta-tomcat-5.5.7 > > >Using CATALINA_TMPDIR: > > >/usr/local/jakarta-tomcat-5.5.7/temp > > >Using JRE_HOME: /usr/java/jdk1.5.0 > > >Mar 3, 2005 10:22:45 PM > > >org.apache.coyote.http11.Http11Protocol init > > >INFO: Initializing Coyote HTTP/1.1 on http-8080 > > >Mar 3, 2005 10:22:45 PM > > >org.apache.catalina.startup.Catalina load > > >INFO: Initialization processed in 1106 ms > > >Mar 3, 2005 10:22:45 PM > > >org.apache.catalina.core.StandardService start > > >INFO: Starting service Catalina > > >Mar 3, 2005 10:22:45 PM > > >org.apache.catalina.core.StandardEngine start > > >INFO: Starting Servlet Engine: Apache > Tomcat/5.5.7 > > >Mar 3, 2005 10:22:45 PM > > >org.apache.catalina.core.StandardHost start > > >INFO: XML validation disabled > > >Mar 3, 2005 10:22:46 PM > > >org.apache.coyote.http11.Http11Protocol start > > >INFO: Starting Coyote HTTP/1.1 on http-8080 > > >Mar 3, 2005 10:22:46 PM > > >org.apache.jk.common.ChannelSocket init > > >INFO: JK2: ajp13 listening on /0.0.0.0:8009 > > >Mar 3, 2005 10:22:46 PM > org.apache.jk.server.JkMain > > >start > > >INFO: Jk running ID=0 time=0/142 config=null > > >Mar 3, 2005 10:22:47 PM > > >org.apache.catalina.storeconfig.StoreLoader load > > >INFO: Find registry server-registry.xml at > > classpath > > >resource > > >Mar 3, 2005 10:22:47 PM > > >org.apache.catalina.startup.Catalina start > > >INFO: Server startup in 1701 ms > > >Mar 3, 2005 10:23:29 PM > > >org.apache.catalina.core.StandardWrapperValve > > invoke > > >SEVERE: Servlet.service() for servlet jsp threw > > >exception > > >javax.servlet.jsp.JspException: Unable to get > > >connection, DataSource invalid: > > >"java.sql.SQLException: No suitable driver" > > > at > > > >org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(Unknown > > >Source) > === message truncated === __________________________________ Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web http://birthday.yahoo.com/netrospective/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]