Skip site navigation (1) Skip section navigation (2)

Re: JDBC connection issue

From: foredl(at)yahoo(dot)com (datalines)
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC connection issue
Date: 2004-07-19 08:27:23
Message-ID: 1ac22fd7.0407190027.53d75925@posting.google.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
JDBC with anything...can be a real pain in the ass!!!!
why don't you learn to connect to the DB using PHP...there's
no drivers involved!   Also, the latest thing,
is using DBCP with Jakara Struts...why don't you read about that?
good luck
Ynam(at)sharedmarketing(dot)com ("Young Nam") wrote in message news:<581C48EBC132FF459E62A6809D0D72AE22C749(at)mail(dot)sharedmarketing(dot)com>...
> Hi,
> 
> I am having some difficulties connecting to a local postgresql database via
>  jdbc driver.
> 
> my setup is:
> mandrake 10.0
> j2sdk1.4.2
> postgresql 7.4.3
> 
> I've configured postgresql from its source with --with-java option, make, a
> nd make install.
> 
> The default directory for the postgresql.jar is /usr/local/pgsql/share/java
> /postgresql.jar
> I've run >jar -tf /usr/local/pgsql/share/java/postgresql.jar and the class 
> files seem to be in the right order.
> 
> I've added the following line to the pg hba.conf to test local connections 
> via jdbc driver.
> local	all	all	127.0.0.1	trust
> 
> Also, changed the postgresql.conf
> tcpip socket = true
> 
> Added CLASSPATH to bashrc file
> export CLASSPATH=/usr/local/pgsql/share/java/postgresql.jar:${CLASSPATH}
> 
> and I am trying to run the following code
> import java.sql.*;
> import java.util.*;
> 
> public class Xlang {
> 	public static void main(String[] args) {
> 		try {
> 			Class.forName("org.postgresql.Driver");
> 		...
> 	}
> }
> 
> and I am getting the following exception..
> 
> java.lang.ClassNotFoundException: org.postgresql.Driver
> 
> Any ideas would be very much appreciated.
> 
> YJ
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match

In response to

Responses

pgsql-jdbc by date

Next:From: Michael StephensonDate: 2004-07-19 10:25:49
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE
Previous:From: Dario V. FassiDate: 2004-07-18 19:47:20
Subject: Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group