Marius, Thanks.One last question, how will my jboss.xml look like. And what name will I use to refer to the datasource.
Allan. --- Marius Kotsbak <[EMAIL PROTECTED]> wrote: > jboss-service.xml: (maybe you could call it > postgres-service.xml also) > > <?xml version="1.0" encoding="UTF-8"?> > > <server> > > <!-- <classpath archives="jboss.jar"/> --> > > <!-- Postgresql data source for Connect --> > > <mbean > code="org.jboss.resource.ConnectionFactoryLoader" > > name="BoostCom:service=ConnectionFactoryLoader,name=ConnectDS"> > <attribute > name="ManagedConnectionFactoryProperties"> > > ConnectionURL=jdbc:postgresql://localhost/connect > UserName=user > Password=pw > DriverClass=org.postgresql.Driver > </attribute> > <attribute > name="JndiName">connect/ConnectDS</attribute> > <attribute > name="TransactionManagerName">java:/TransactionManager</attribute> > > <depends > optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva > JDBC LocalTransaction ResourceAdapter</depends> > <depends > optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory</depends> > <attribute name="ConnectionManagerProperties"> > MinSize=0 > MaxSize=10 > BlockingTimeoutMillis=5000 > IdleTimeoutMinutes=30 > CleanupIntervalMinutes=10 > MaxIdleTimeoutPercent=1.0 > </attribute> > > <attribute name="PrincipalMappingClass"> > > org.jboss.resource.security.ManyToOnePrincipalMapping > </attribute> > <attribute > name="PrincipalMappingProperties">userName=connect</attribute> > </mbean> > </server> > > place this file in the deploy-directory (after > copying the postgres > jdbc-driver (.jar) into the jboss-3.0.0beta2/lib, > and restarted jboss) > > > > On Wed, 2002-04-03 at 14:00, Allan Kamau wrote: > > McAuley, > > Kindly send me the postgresql-service.xml for > > jboss-3.0.0beta together with details of where to > > place this file and the postgres-jdbc.jar file and > > finally an extract of the jboss.xml file. > > > > Thanks, > > Allan Kamau. > > > > --- Marius Kotsbak <[EMAIL PROTECTED]> wrote: > > > I have used the same file since alpha, so i > don't > > > think it has changed > > > much. Have sent it to him, forgot to add the > list, > > > so could you > > > forward/reply to all it to the list, Allan? > > > > > > On tir, 2002-04-02 at 15:56, McAuley, Tim wrote: > > > > Which version of JBoss are you using? > > > > > > > > My advise is firstly to make sure you're using > a > > > copy of the service file > > > > applicable to the version of JBoss you're > using. > > > > > > > > - Make a copy of hsqldb-default-service.xml > and > > > rename it to > > > > postgres-service.xml. > > > > - Modify the relevent sections for use with > > > Postgres i.e. > > > > - jdbc driver, datasource name (if not > default) > > > > - database to access, and username password > > > > (possibly the location of the postgres jar > file > > > needs to be added > > > > in). > > > > > > > > If you let me know what version of JBoss you > have, > > > I might be able to send > > > > you a copy of my postgres service file. I have > > > been using alpha, beta and > > > > beta2 (26/03) > > > > > > > > Tim > > > > > > > > > > > > > > > > > > I havent been successful in get PostgreSQL > to be > > > used > > > > > for CMP in my entity EJB running on JBoss > 3.0.0. > > > > > Can anyone show some light in the areas I am > may > > > have > > > > > overlooked or if possible a step by step > listing > > > of > > > > > what I is required to get PostgreSQL being > used > > > for > > > > > CMP. > > > > > Thank you all in advance. > > > > > > > > > > Allan Kamau. > > > > > > > > > > > > > > _______________________________________________ > > > > JBoss-user mailing list > > > > [EMAIL PROTECTED] > > > > > > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > > > > _______________________________________________ > > > JBoss-user mailing list > > > [EMAIL PROTECTED] > > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Tax Center - online filing with TurboTax > > http://taxes.yahoo.com/ > > > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
