Hi
My problem is using JDBC(ODBC) in POSTGRESQL. My machine has Red Hat
Linux 5.2. In the Howto Postgres document it is written that JDBC driver
is supplied with this CD. I created Database and tabels using psql
interactive prompt. Then I wrote one java program to access the tabels
created before.
The statements in the java program are:
String url ="jdbc:postgres95:mydb?user=postgres&passwd=pass";
String query="select * from emp;
(I have created emp tabel and it has also some rows inserted.)
To load the driver the statement is
Class.forName("postgress95.PGDriver");
To connect to the database
Connection con = DriverManager.getConnection(url);
There is no error message when I compile using javac. But when run this
program using java I get a error message as :
Java.lang.ClassNotFoundException: postgres95/PGDriver
at SimpleSelect.main(41)
In one website of FAQJDBC it is written that one must have postgers.jar
file in the current directory to load the driver. But I didn't
get that file anywhere in my system.
Please help me to solve this problem.
Is there any other way I can use JDBC to access the tabels created
in Postgres.
Sorry for inconvenience
With regards
-Sitansu
----------------------------------------------------------------------
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
