Thank you all for your help! It turned out that I needed the postgresql.jar in my classpath and once I put that in my classpath for my "alias" setting, the class.name and the url jdbc:postgresql:basicportal worked!
Once again, thanks to everyone who helped me over this hump!
Geeta
P.S. This jar is not included in the jasic/postgres
folder. - I think Vic wanted to make this more interesting for us!! ;)
If anybody else needs the postgresql.jar, please write to me and I will
be happy to send it to you.
[EMAIL PROTECTED] wrote:
this is form of the postgres main class and jdbc url i use:class.name=org.postgresql.Driver
url=""replace myDB with your database name.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Geeta Ramani
Sent: Thursday, March 06, 2003 2:15 PM
To: Scott Plante
Cc: [EMAIL PROTECTED]
Subject: Re: [MVC-Programmers] Squirrel trouble..Scott/Peter/anyone:
In the Squirrel window for entering the "Driver" info for PostgresSQL, I
have
the foll info:jxDBCon-.jar-cvs03119 (in my "Extra class path")
and the class name as "org.sourceforge.jxdbcon.JXDBConDriver".Is this correct? (I got a check mark against the "PostgreSQL" in my driver
list with these entries, so i assumed they were ok..?)Thanks!
GeetaScott Plante wrote:
> There's a Postgres setting to turn on network connections, which you
> need turned on for JDBC connections. I suspect that's your problem.
>
> Geeta Ramani wrote:
>
> >Hi everyone:
> >
> >I am trying to get Squirrel up and running and am following the steps
> >outlined in the quick-start.html in the jasic.squirrel folder. i am
> >having trouble with creating the Alias. here's what i have for the
> >values:
> >
> >Name: basicportal1
> >Driver: PostgreSQL
> >URL: jdbc:postgresql://localhost:5432/basicportal
> >user name: bpuser
> >password: password
> >
> >When i hit "Test" on the "Alias" window I get the foll. exception:
> >
> >java.sql.SQLException: Unable to create connection. Check your URL.
> >..etc.
> >
> >So I am guessing the url above is wrong..;) Can anybody tell me what the
> >url should look like?
> >
> >Thanks!
> >Geeta
> >P.S. Btw, I have the postgres server up and running and have already run
> >the scripts in the bin folder so i know the users etc have been created.
> >(the createuser.sql is where I got the username and password ..) Also
> >from the command prompt, I can execute "psql basicportal" which gives me
> >the required welcome message and a "basicportal=#" prompt. What am i
> >doing wrong? Please help!!!
> >
> >
> >_______________________________________________
> >MVC-Programmers mailing list
> >[EMAIL PROTECTED]
> >http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
> >
> >
>
> _______________________________________________
> MVC-Programmers mailing list
> [EMAIL PROTECTED]
> http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers_______________________________________________
MVC-Programmers mailing list
[EMAIL PROTECTED]
http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers_______________________________________________
MVC-Programmers mailing list
[EMAIL PROTECTED]
http://www.basebeans.net:8080/mailman/listinfo/mvc-programmers
