Problem with JSP Database code

[javoine]

Here is the code i'm trying to execute:

<%@ page import=&quot;java.lang.*&quot; %>
<%@ page import=&quot;java.io.*&quot; %>
<%@ page import=&quot;java.sql.*&quot; %>

<%
DriverManager.getDriver(&quot;jdbcostgresql://localhost/Databasename&quot;
Class.forName(&quot;jdbcostgresql&quot;
Connection con = DriverManager.getConnection(&quot;jdbcostgresql://localhost/Databasename&quot;, &quot;Administrator&quot;
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(&quot;SELECT * FROM dates&quot;
while( rs.next() )
{
out.println( rs.getString( &quot;field&quot; ) );
}
%>

HERE IS THE ERROR IT GIVES:

cannot resolve symbol
symbol : method getConnection(java.lang.String,java.lang.String)
location: class java.sql.DriverManager
Connection con = DriverManager.getConnection(&quot;jdbcostgresql://localhost/Databasename&quot;, &quot;usrname&quot;

Any suggestions would be wonderful. the indicator for this error message points to the period before getConnection, like the period is what it cant resolve???

I'm very new to JSP so any help will be appreciated.
Thanx in advance!

 

[sedj]

Look at the docs (there is no method which takes two String arguments) ::

http://java.sun.com/j2se/1.4.1/docs/api/java/sql/DriverManager.html

I suspect you want the method which takes a URL, a USER and a PASSWORD :: getConnection(String url, String user, String password)

You may also have probems with :
>> Class.forName(&quot;jdbcostgresql&quot;

The Class.forName() method attempts to load a class name, ie ::
Class.forName(&quot;org.gjt.mm.mysql.Driver&quot.newInstance();

Ben