Re: [INTERFACES] JDBC and DriverManager
От | llestat |
---|---|
Тема | Re: [INTERFACES] JDBC and DriverManager |
Дата | |
Msg-id | 98070315083700.00261@linux-serv обсуждение исходный текст |
Список | pgsql-interfaces |
Go ahead and pass it a user name and password I had a similar problem where all JDBC programs would refuse to connect even though the Database was not password protected just use yur admin name and anything for the password. - Richard On Thu, 02 Jul 1998, Jeffrey Napolitano wrote: >Okay...the below code compiles fine, but when it runs, it throws the >SQLException at the DriverManager line (as you can see, everything below >is commented out). There is indeed a datasource "bugs", and PostgreSQL >is running on the local machine. There is no password needed to access >the database, and I can access "bugs" interactively with psql. Am I not >importing a package...? > >I need help...am lost to why it throws the SQLException. > >------------------------------------------------------------ >import java.util.*; >import java.io.*; >import java.sql.*; > >public class HopeSprings { > public static void main(String[] args) { > String url = "jdbc:postgresql:bugs"; > Connection con; > String createString; > createString = "create table STUFF " + "(NAME >varchar(30), " + "IDNUMBER int)"; > Statement stmt; > > try { > Class.forName("postgresql.Driver"); > } > catch(ClassNotFoundException except) { > System.out.println("ClassNotFound: didn't >work"); > } > > try { > con = DriverManager.getConnection(url); > //stmt = con.createStatement(); > //stmt.executeUpdate(createString); > //stmt.close(); > //con.close(); > } > catch(SQLException sqlexcept) { > System.out.println("The SQL Exception was >thrown"); > } > } //End of main in JDBC_Connection class >} //End of JDBC_Connection class bracket
В списке pgsql-interfaces по дате отправления: