Re: Squirrel trouble..

Hi Peter, Scott, "dschorsc":

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=jdbc:postgresql:myDB
>
> 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!
> Geeta
>
> Scott 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