Unable to compile java file with all Classpaths set
От | Kareem Habib |
---|---|
Тема | Unable to compile java file with all Classpaths set |
Дата | |
Msg-id | fd30a5560706221240ne8e53c4oba2024dd3f79c5dc@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Unable to compile java file with all Classpaths set
(Heikki Linnakangas <heikki@enterprisedb.com>)
Re: Unable to compile java file with all Classpaths set (Jeff Hubbach <jeff.hubbach@cha.com>) |
Список | pgsql-jdbc |
I'm in a bit of a dilemma. I need to connect to a PostgreSQL database through JAVA and so naturally I checked out the JDBC drivers. I downloaded the JDBC 3 driver (both 8.2 and the 8.3dev) as I am using JDK 1.5. I set the CLASSPATH in the environment variables to C:\postgresql.jar (I renamed the one i was using to this). I then wrote a test file that will make sure that I've set up everything correctly. I found this sample on the net so I decided to use it... I only wanted it to compile, nothing more.
import java.sql.*;
public class maxi{
public static void main(String[] args){
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://server8.cs.uofs.edu/";
String dbname = "uofsis";
String usernm = "bi";
String passwd = "";
Connection db = DriverManager.getConnection(url+dbname, usernm, passwd);
Statement st = db.createStatement();
String sql = "SELECT name, title " + "FROM faculty f, course c " + "WHERE f.id = c.instructor";
ResultSet rs = st.executeQuery(sql);
st.close();
db.close();
}
}
Every time I compile it I get the following output:
C:\>javac maxi.java
maxi.java:5: unreported exception java.lang.ClassNotFoundException; must be caug
ht or declared to be thrown
Class.forName("org.postgresql.Driver");
^
maxi.java:11: unreported exception java.sql.SQLException; must be caught or decl
ared to be thrown
Connection db = DriverManager.getConnection (url+dbname, usernm, pass
wd);
^
maxi.java:13: unreported exception java.sql.SQLException; must be caught or decl
ared to be thrown
Statement st = db.createStatement();
^
maxi.java:16: unreported exception java.sql.SQLException; must be caught or decl
ared to be thrown
ResultSet rs = st.executeQuery(sql);
^
maxi.java:18: unreported exception java.sql.SQLException; must be caught or decl
ared to be thrown
st.close();
^
maxi.java:19: unreported exception java.sql.SQLException; must be caught or decl
ared to be thrown
db.close();
^
6 errors
I've tried versions 1.5 and 1.6 of the JDK on Windows XP, Windows Vista, and Ubuntu Linux using JDBC 3 and JDBC 4 drivers for 8.0, 8.2, and 8.3dev and they all output the same errors. I also tried writing it using NetBeans and importing the jar file into its libraries for the test project I created. The same errors appeared. What am I missing here?? Perhaps somebody can help.
Thanks
Kareem
import java.sql.*;
public class maxi{
public static void main(String[] args){
Class.forName("org.postgresql.Driver");
String url = "jdbc:postgresql://server8.cs.uofs.edu/";
String dbname = "uofsis";
String usernm = "bi";
String passwd = "";
Connection db = DriverManager.getConnection(url+dbname, usernm, passwd);
Statement st = db.createStatement();
String sql = "SELECT name, title " + "FROM faculty f, course c " + "WHERE f.id = c.instructor";
ResultSet rs = st.executeQuery(sql);
st.close();
db.close();
}
}
Every time I compile it I get the following output:
C:\>javac maxi.java
maxi.java:5: unreported exception java.lang.ClassNotFoundException; must be caug
ht or declared to be thrown
Class.forName("org.postgresql.Driver");
^
maxi.java:11: unreported exception java.sql.SQLException; must be caught or decl
ared to be thrown
Connection db = DriverManager.getConnection (url+dbname, usernm, pass
wd);
^
maxi.java:13: unreported exception java.sql.SQLException; must be caught or decl
ared to be thrown
Statement st = db.createStatement();
^
maxi.java:16: unreported exception java.sql.SQLException; must be caught or decl
ared to be thrown
ResultSet rs = st.executeQuery(sql);
^
maxi.java:18: unreported exception java.sql.SQLException; must be caught or decl
ared to be thrown
st.close();
^
maxi.java:19: unreported exception java.sql.SQLException; must be caught or decl
ared to be thrown
db.close();
^
6 errors
I've tried versions 1.5 and 1.6 of the JDK on Windows XP, Windows Vista, and Ubuntu Linux using JDBC 3 and JDBC 4 drivers for 8.0, 8.2, and 8.3dev and they all output the same errors. I also tried writing it using NetBeans and importing the jar file into its libraries for the test project I created. The same errors appeared. What am I missing here?? Perhaps somebody can help.
Thanks
Kareem
В списке pgsql-jdbc по дате отправления:
Следующее
От: Heikki LinnakangasДата:
Сообщение: Re: Unable to compile java file with all Classpaths set