I'm not at home right now, so I can't send you my exact configuration files, but
I can provide some guidelines that can hopefully get you started:
- Look on the postgres web page for where the jdbc drivers are in your postgres
installation. The docs give you the file names (they should be .jar files), so
if worse comes to worst, you can always search for those file names.
- Choose the JDBC driver compiled for JDK 1.2
- Copy this .jar file into your jboss/lib/ext directory
- Go into your jboss.conf file, you will see some entries in there for the JDBC
drivers for InstantDB and HypersonicSQL. Copy and paste one of these, then
change the name of the .jar file, username, password, and database connection
URL to match the Postgres settings. The format for the databse connection URL
is in the Postgres documentation.
- Go into jboss.properties, and add the full class name for the Postgres driver
in the list of JDBC drivers there. There should already be entries for
InstantDB and HypersonicSQL
- In your CMP entity beans, you will need to use ejx to modify the jaws.xml file
to use postgres as the data source. Also enable the type mappings for postgres.
Hopefully this will get you started. This is what I had to do to figure it out
anyway. Most of it involves reading the Postgres dox.
-Charles
Kamen wrote:
> Thanks Charles,
> could you please let me know what exactly would I have to do in order to use
> postgress connections from jboss. (Please take a look at the other e-mail
> that I sent earlier today titled:
> Re: [jBoss-User] Entity BMP Transaction Rollback
>
> )
> Regards,
> Kamen
> ----- Original Message -----
> From: "Charles Crain" <[EMAIL PROTECTED]>
> To: "jBoss" <[EMAIL PROTECTED]>
> Sent: Friday, September 29, 2000 5:51 PM
> Subject: Re: [jBoss-User] Postges jdbc driver
>
> > The latest release of Postgres comes with its own jdbc drivers (check the
> > postgres docs on the web). I have had no problems with them. Use the 1.2
> > version of the drivers.
> >
> > -Charles
> >
> > Kamen wrote:
> >
> > > Hi all,
> > > I'm interested in a good jdbc postgres driver that I could use problem
> free
> > > in jboss.
> > > Regards,
> > > Kamen
> > >
> > > --
> > > --------------------------------------------------------------
> > > To subscribe: [EMAIL PROTECTED]
> > > To unsubscribe: [EMAIL PROTECTED]
> > > Problems?: [EMAIL PROTECTED]
> >
> >
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Problems?: [EMAIL PROTECTED]
> >
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Problems?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
