-
1. Re: [newbie] Howto connect JBoss to PostgreSQL
juhalindfors Jun 21, 2003 5:21 AM (in response to pengster)The datasource config from the JBoss examples pretty much works as is. Just make sure you enable TCP/IP connections to your database (postmaster -i).
-
2. Re: [newbie] Howto connect JBoss to PostgreSQL
xiao_yuh Jul 21, 2003 7:02 AM (in response to pengster)I did some simple test for Jboss 3.2.1 + PostgreSQL 7.3.2
Here is the major JBOSS related steps:
1. Delete or rename the hsqldb-ds.xml
2. copy docs\example\jca\postgres-ds.xml to "deploy" folder, modify it like this:
(assume using database "mydb" locally)
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: postgres-ds.xml,v 1.1 2002/07/22 22:57:24 d_jencks Exp $ -->
<!-- ==================================================================== -->
<!-- Datasource config for Postgres -->
<!-- ==================================================================== -->
<local-tx-datasource>
<jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:postgresql://localhost:5432/mydb</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>postgres</user-name>
</local-tx-datasource>
3. Modify the conf\standardjbosscmp-jdbc.xml liek this:
(change "Hypersonic SQL" to "PostgreSQL")
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc>
<!-- ===================================================================== -->
<!-- -->
<!-- Standard JBossCMP-JDBC Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.14 2003/05/03 11:03:40 slaboure Exp $ -->
<jbosscmp-jdbc>
java:/DefaultDS
<datasource-mapping>PostgreSQL</datasource-mapping>
..... -
3. Re: [newbie] Howto connect JBoss to PostgreSQL
gordonlch Jul 21, 2003 8:40 PM (in response to pengster)Hi,
Had you successful connect to postgrsql other than "DefaultDS"? If yes, could you post the sample config to us? Thanks.
Gordon -
4. Re: [newbie] Howto connect JBoss to PostgreSQL
leninkoduru Jul 23, 2003 10:54 PM (in response to pengster)Yes i am using Postgres with Jboss.Here is the configuration file srequired for it.See the attachments.
postgres-ds.xml file should be in your server/default/deploy directory. -
5. Re: [newbie] Howto connect JBoss to PostgreSQL
gordonlch Jul 24, 2003 8:21 AM (in response to pengster)Thanks for your help first.
Yes, its work when i just use single datasource, i can found jboss open up connection pool according my config as postgres-ds.xml.
But when i put the default one ( hsqldb-ds.xml) back... jboss hadn't open postgresql side connection pool for me.
I attach a few config files for ref.
Little bit different to yours, just i add more attribit to postgres-ds.xml to define the min/max pool size and standardjbosscmp-jdbc.xml point to PostgresSQL 7.2 for mapping.
Please have a look and give me a hand. Thanks a lot. -
6. Re: [newbie] Howto connect JBoss to PostgreSQL
rsrawat Jul 24, 2003 9:06 AM (in response to pengster)Hi
If anyone from you who got successful in connecting JBoss to Postgres could post ejb-jar.xml , jboss.xml and jbosscmp-jdbc.xml file for CMP Entity Bean.
I am trying my best to communicate between these but do not know where I am making mistake. If anyone can post these sample files for me. I will be very thankful.
Thanks in Advance. -
7. Re: [newbie] Howto connect JBoss to PostgreSQL
pauster007 Jul 25, 2003 6:42 AM (in response to pengster)> Hi
> If anyone from you who got successful in connecting
> JBoss to Postgres could post ejb-jar.xml , jboss.xml
> and jbosscmp-jdbc.xml file for CMP Entity Bean.
> I am trying my best to communicate between these but
> do not know where I am making mistake. If anyone can
> post these sample files for me. I will be very
> thankful.
> Thanks in Advance.
>
yes any kind hearted souls out there? pls post or attach the said xml files...some newbies here need some help... -
8. Re: [newbie] Howto connect JBoss to PostgreSQL
praveenkushwaha Oct 22, 2003 8:17 AM (in response to pengster)hi
guys
i am using postgresql7.2 anf jboss3.2.2
but i am getting error i think in jndi name
i am atting the details of error ( a part of it)