connecting to database with jsp

admin

Administrator
Staff member
I am trying to query a postgresql database using jsp in windows. I have this from a tutorial i did <br />
Code:
<br />Load the driver<br />  try {<br />    Class.forName("connect.microsoft.MicrosoftDriver");<br />    Class.forName("oracle.jdbc.driver.OracleDriver");<br />  } catch { ClassNotFoundException cnfe) {<br />    System.out.println("Error loading driver: " cnfe);<br />  }<br />Define the Connection URL<br />  String host = "dbhost.yourcompany.com";<br />  String dbName = "someName";<br />  int port = 1234;<br />  String oracleURL = "jdbc:oracle:thin:@" + host + <br />                     ":" + port + ":" + dbName;<br />  String sybaseURL = "jdbc:sybase:Tds:" + host  + <br />                     ":" + port + ":" + <br />                     "?SERVICENAME=" + dbName;<br />[code]<br /><br />my problem is "oracle.jdbc.driver.OracleDriver".  I am using a pgsql database, not oracle.<br />Does anyone know the name of the driver for postgreSQL or where I can find it.<br /><br />RPJD <img src="http://static.dreamincode.net/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> <br />
</div>
 
Back
Top