----- Original Message -----
From: "Dave Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 2:04 PM
Subject: Re: [JBoss-user] Configure Postgres with JBoss 2.1
> Cameron Tabor wrote:
>
> > Hello,
> > Can someone please post the configuration for Postgres and jboss 2.1
> > I had it with 2.0, but something is very different now.
> > Thanks,
> > Cameron Tabor
> >
> >
> >
> >
> > Cameron Tabor, Software Engineer
> > Rievent Technologies, LLC
> > email: [EMAIL PROTECTED]
> > Phone: 757-547-8076
> >
> >
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > http://lists.sourceforge.net/lists/listinfo/jboss-user
>
> jboss.conf
>
> <MLET CODE = "org.jboss.jdbc.JdbcProvider"
> ARCHIVE="jboss.jar,jdbc7.0-1.2.jar" CODEBASE="../../lib/ext/">
> </MLET>
>
>
> <MLET CODE="org.jboss.jdbc.XADataSourceLoader" ARCHIVE="jboss.jar"
> CODEBASE="../../lib/ext/">
> <ARG TYPE="java.lang.String" VALUE="PostgresDB">
> <ARG TYPE="java.lang.String"
> VALUE="org.jboss.minerva.xa.XADataSourceImpl">
> </MLET>
Don't need to add anything to jboss.conf
>
> jboss.jcml
Add postgres-driver to classpath or just copy the jar-file to ..\lib\ext
Update the JDBC section with the postgres-driver:
<mbean
code="org.jboss.jdbc.JdbcProvider"name="DefaultDomain:service=JdbcProvider">
<attribute
name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,org.
postgresql.Driver</attribute>
</mbean>
>
> <mbean name="DefaultDomain:service=XADataSource,name=PostgresDB">
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc:postgresql://devel.candata.com/Import</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">jboss</attribute>
> <attribute name="MaxSize">0</attribute>
> <attribute name="Password">jboss1</attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="MinSize">0</attribute>
> </mbean>
>
> jboss.properties
>
> jdbc.drivers=org.postgresql.Driver
Don't need this.....
>
> standardjaws.xml
>
> datasource>java:/PostgresDB</datasource>
> <type-mapping>PostgreSQL</type-mapping>
... if you want to use Postgres as your DefaultDB
>
>
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
