RE: Squirrel trouble..

looking at the driver mentioned below I looked up it source, i.e. from the
sourceforge description.

"jxDBCon a framework to ease the development JDBC drivers. By using it you
can concentrate on the tasks specific to your DBMS and benefit from the
generic solutions provided by jxDBCon. jxDBCon contains a featureful driver
implementation for PostgreSQL"

you can find more info at http://sourceforge.net/projects/jxdbcon

note the jar is jxDBCon.jar. it is included in both the basicportal and
webcms lib directories.

i have not tried to get it to work yet but should be implementable based on
the description.

dave



 -----Original Message-----
From: [email protected]
[mailto:[email protected]]On Behalf Of
[email protected]
Sent: Thursday, March 06, 2003 9:41 PM
To: [email protected]
Subject: RE: [MVC-Programmers] 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