Re: A doubt with a jdbc connection to cygwin postgres

"Sergio Ramos" <sergrch(at)hotmail(dot)com> wrote:
>
> Hello, Im trying to make a jdbc connection to a cygwin postgres database.
> The fact is that my java aplication is on windows 98 and I  made the
> database on cygwin postgres,
> I already recieve a hint from you but I have truobles with the driver(In the
> trace appears java.lang.ClassNotFoundException), I use :
> org.postgresql.Driver and
> postgresql.Driver

The driver name is just in the first form -- org.postgresql.Driver. The exception might rise because you didn't placed the driver in the proper place (and here I must point again to http://jdbc.postgresql.org where this hint was picked up) - for the 1.3.1 version of the jdk, this place seems to be <jdk_home>/jre/lib/ext/ -- maybe the "-classic" switch for the java command could solve the placement of the .jar somewhere else in the CLASSPATH variable.

>
> I dont know if the problem is on the cygwin postgres, because I only start
> postgres as the documentation says(I dont define a specific host or user or
> things like that)

You don't define, but they are "preconfigured". So, if you take a look at the last lines in your $PGDATA/pg_hba.conf you will discover the default access rights. Also the user name you must use is the one you were logged in to your windows when executed the initdb command. There is by default no password required. (Hint: a you could verify what users are registered with your backend, do a psql after starting the postmaster, and a "select * from pg_user;" after that. Anyway, the java exception shows you didn't reached at the user/password point.

>
> Can you help me?
>
> Many Thanks in Advance.
>
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>

SLao
__________________________________________________________________
Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/