Re: servlet-PostgreSQL connection does not work.

[Robert B. Easter]

The PostgreSQL JDBC jar needs to be in CLASSPATH when you are starting tomcat. CLASSPATH=$CLASSPATH:<pathtojdbcjar>/postgresql.jar Start PostgreSQL with: pg_ctl -o "-i" <and whatever else> Remember that postmaster needs the -i option or else it will not allow TCP/IP connections. Checking data/pg_hda.conf is a good idea too when you enable this. On Monday 25 December 2000 02:14, NSB) $B3^>> (B wrote: > It seems that servlet to PostgreSQL connection does not work.Tomcat.log > file shows "Context log:path="/jdbc_servlet"File not Found > /usr/local/jakarta-tomcat/webapps/jdbc_servlet/WEB-INF/web.xml,using > only defaults.",where jdbc_servlet is my application directory. > In addtion,I got an error message of > "java.lang.ClassNotFoundException;org.postgresql.Driver" when I access > to "http://127.0.0.1:8080/jdbc_servlet/servlet/postgreservlet." > I wonder if Tomcat cannot find postgresql.jar.If so,what do I need to do > for Tomcat? > Or one possibility is a setting of pg_hba.conf for PostgreSQL.I set like > this. > local all trust > host all 127.0.0.1 255.255.255.255 trust > Does not this setting work? I hava a confusion.Please help me out. > > The development environment is as folows. > Apache1.3.12,Tomcat3.1,PostgreSQL7.0.2,jdk1.2.2 > Thanks in advance. > Hiroshi Kasamatsu > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html -- -------- Robert B. Easter [EMAIL PROTECTED] --------- - CompTechNews Message Board http://www.comptechnews.com/ - - CompTechServ Tech Services http://www.comptechserv.com/ - ---------- http://www.comptechnews.com/~reaster/ ------------ ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html