Re: postgresql + jboss

This might or might not be overkill, but Out-of-the-Box by EJB Solutions (my
company) installs and configures JBoss 3.2 + Tomcat 4.1.24 with PostgreSQL
7.3.2, and provides sample applications with Ant build scripts that use all
of them.

For a potentially quick solution, look in the JBoss docs/examples/jca
directory for sample PostgreSQL datasource definitions for JBoss.  You can
edit one and copy it to server/default/deploy to get started.  Don't forget
to remove the hsqldb-service files from server/default/deploy to avoid
conflicts.

HTH
Rod



-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Paul Thomas
Sent: Tuesday, June 17, 2003 10:19 AM
To: alexis
Cc: pgsql-general @ postgresql . org
Subject: Re: [GENERAL] postgresql + jboss


On 17/06/2003 16:23 alexis wrote:
>
> hi everybody,
>
> i'm newbie with postgre, and i don't know hot to connect it to jboss
>
> i have postgre 7.3.2 and jboss 3.0.4 + tomcat 4.0.6
>
> i've been looking for documentation on how to connect the database and
> the j2ee server,
> but i was unable to find anything useful.
>
> can anybody  help me ??
>
> thanks in advance ;)


It's been a while since I played with this but I remember getting a test
app to work using JBoss 3.0.0/Tomcat 4.0.3. I've attached the xml config
file I used to define a data source called PostgresAccountsDS connecting
to a db named test_accounts. I placed this, together with the .war file in
server/default/deploy. For the JDBC driver, I simply created a symbolic
link to the its jar file in lib.

HTH

--
Paul Thomas
+------------------------------+--------------------------------------------
-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+--------------------------------------------
-+