Re: JDBC Connect Error Postgresql
Chase Preuninger wrote:
I think I found the problem because it works if the database URL is
"jdbc:postgresql:Notes" but why?
Your original syntax shows way too many slash characters.
Connection conn = DriverManager.getConnection(
"jdbc:postgresql:////127.0.0.1//Notes", "myun", "mypw");
I suspect this:
System.setProperty("jdbc.drivers", "org.postgresql.Driver");
I've never done such a thing with JDBC code before. Initializing the driver
with Class.forName(), which is NOT a "test", btw, but how you initialize the
driver, has always sufficed.
Setting a System property in code is where you went wrong. The whole point of
System properties is that they are set by the *system*, and then read in code.
The typical approach to setting them is a "-D" parameter on the java command
line. This is, in fact, how you're supposed to use this particular property.
According to the documentation, it is used so that
the JVM will attempt to load the driver as part of its initialization.
<http://jdbc.postgresql.org/documentation/83/load.html>
That means that since you didn't provide the value at the right time, it
wasn't available *during initialization*.
Just use Class.forName() to load the driver.
Try the correct number of slashes. I don't think the extra one after the IP
address hurts, but I really don't know about the one after the protocol. The
documentation sure doesn't indicate the use of four slashes.
You could also try specifying the port if you aren't using the 5432 default.
--
Lew