RE: Squirrel trouble..

the jars i use for my jsp pages are of the form jdbc7.2dev-1.2.jar or
jdbc7.1-1.2.jar, depending on which version of postgres you are using (this
is linux dist of postgres downloaded from postgres websites). windows
distribution may have other jars. a quick look at jasic directories don't
seem to show a jdbc jar except for jdbc-mysql.jar.

dave
  -----Original Message-----
  From: [email protected]
[mailto:[email protected]]On Behalf Of Geeta Ramani
  Sent: Thursday, March 06, 2003 8:49 PM
  To: mvc
  Subject: Re: [MVC-Programmers] 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