Re: Postgres and JBoss 3 RC1 (was: [JBoss-user] Newbie)
You have the wrong postgres-service.xml file for rc1. Look in http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/jbosscx/src/etc/example-config/ I meant to ask Scott to make sure these made it into the binary distro but forgot, I don't know if they are there I'll try to update the manual as well. david jencks On 2002.04.15 12:33:26 -0400 Simon Stewart wrote: > I know it's not a great idea to answer to your own post, but someone > suggested that I send a few more details. IMO, it was lame of me to > leave them out, so sorry for not doing this earlier! > > I'm using jboss-3.0.0RC1, JDK 1.4, Postgres 7.2.1 and the > postgres-service.xml 1.3 file from CVS. > > The only changes that I've made to the postgres-service.xml file are > to the user name, password and connection url. I've attached it to > this email, with the password being the only difference between this > and and the deployed version. > > Once JBoss has started, connecting to "http://localhost:8082"; lists > the hsqldbDS, but no reference is made to "FooPostgresDS". There are > no startup error messages, and the Postgres logs indicate that no > connection attempt is made. > > I am starting the default JBoss server from a freshly unpacked copy of > the RC1 download. I've copied the pgjdbc2.jar file to both > ${JBOSS_HOME}/lib and ${JBOSS_HOME}/lib/ext, and the startup logs > indicate that it is picked up. The startup logs also contain the > lines: > > 17:18:31,621 INFO [MainDeployer] Starting deployment of package: > file:/home/sms/jboss/jboss-3.0.0RC1/server/default/deploy/postgres-service.xml > 17:18:31,943 INFO [MainDeployer] Successfully completed deployment of > package: >file:/home/sms/jboss/jboss-3.0.0RC1/server/default/deploy/postgres-service.xml > > which suggests that I'm not doing things _entirely_ wrong. I believe > that once the postgres datasource is picked up, it should just be a > case of renaming the DS to "DefaultDS" to have everything go according > to plan. > > Regards, > > Simon > > On Mon, Apr 15, 2002 at 04:16:20PM +0100, Simon Stewart wrote: > > How do I get to use Postgres as the backend database instead of hsqldb > > in Orion? I'd like to bind it to DefaultDS so that I can ditch hsqldb, > > but I'm not sure how to do this. > > > > I believe that all that needs to be done is to copy pgjdbc2.jar to > > "${JBOSS_HOME}/lib/ext and the postgres-service.xml from the cvs tree > > to the server/default/deploy directory (for the sake of simplicity) > > but this doesn't work at all --- attempting to deploy my ".ear" file > > results in multiple exceptions, and from the stack trace this is > > because nothing is bound to DefaultDS > > > > Any help or advice on this would be greatly appreciated --- I'm > > finding it hard to get going with JBoss, even though it appears to > > have a good reputation amongst those that I've spoken to about it. > > -- > [Regarding "Highlander II"] "In an experiment to determine the > precise amount of beer required to enjoy this film, I passed > out." -- Dave O'Brien > > ___ > 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
Re: Postgres and JBoss 3 RC1 (was: [JBoss-user] Newbie)
Simon, db-service.xml files have changed for RC1. You need to downloadd the new postgres-service.xml from: http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/jboss/jbosscx/src/etc/example-config/ You also need to add a PostgresDbRealm entry in server/default/conf/login-config.xml, since the user and password specified in postgres-service.xml are not used (because of the ByContainer entry)... Greetings, Ricardo Arguello - Original Message - From: "Simon Stewart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 15, 2002 11:33 AM Subject: Postgres and JBoss 3 RC1 (was: [JBoss-user] Newbie) > I know it's not a great idea to answer to your own post, but someone > suggested that I send a few more details. IMO, it was lame of me to > leave them out, so sorry for not doing this earlier! > > I'm using jboss-3.0.0RC1, JDK 1.4, Postgres 7.2.1 and the > postgres-service.xml 1.3 file from CVS. > > The only changes that I've made to the postgres-service.xml file are > to the user name, password and connection url. I've attached it to > this email, with the password being the only difference between this > and and the deployed version. > > Once JBoss has started, connecting to "http://localhost:8082"; lists > the hsqldbDS, but no reference is made to "FooPostgresDS". There are > no startup error messages, and the Postgres logs indicate that no > connection attempt is made. > > I am starting the default JBoss server from a freshly unpacked copy of > the RC1 download. I've copied the pgjdbc2.jar file to both > ${JBOSS_HOME}/lib and ${JBOSS_HOME}/lib/ext, and the startup logs > indicate that it is picked up. The startup logs also contain the > lines: > > 17:18:31,621 INFO [MainDeployer] Starting deployment of package: >file:/home/sms/jboss/jboss-3.0.0RC1/server/default/deploy/postgres-service.xml > 17:18:31,943 INFO [MainDeployer] Successfully completed deployment of package: >file:/home/sms/jboss/jboss-3.0.0RC1/server/default/deploy/postgres-service.xml > > which suggests that I'm not doing things _entirely_ wrong. I believe > that once the postgres datasource is picked up, it should just be a > case of renaming the DS to "DefaultDS" to have everything go according > to plan. > > Regards, > > Simon > > On Mon, Apr 15, 2002 at 04:16:20PM +0100, Simon Stewart wrote: > > How do I get to use Postgres as the backend database instead of hsqldb > > in Orion? I'd like to bind it to DefaultDS so that I can ditch hsqldb, > > but I'm not sure how to do this. > > > > I believe that all that needs to be done is to copy pgjdbc2.jar to > > "${JBOSS_HOME}/lib/ext and the postgres-service.xml from the cvs tree > > to the server/default/deploy directory (for the sake of simplicity) > > but this doesn't work at all --- attempting to deploy my ".ear" file > > results in multiple exceptions, and from the stack trace this is > > because nothing is bound to DefaultDS > > > > Any help or advice on this would be greatly appreciated --- I'm > > finding it hard to get going with JBoss, even though it appears to > > have a good reputation amongst those that I've spoken to about it. > > -- > [Regarding "Highlander II"] "In an experiment to determine the > precise amount of beer required to enjoy this film, I passed > out." -- Dave O'Brien > > ___ > 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
Postgres and JBoss 3 RC1 (was: [JBoss-user] Newbie)
And here's the postgres-service.xml file. Cheers, Simon -- "Those are pretty strong words coming from a guy who's been mistaken for a plush toy" --- Get Fuzzy ConnectionURL=jdbc:postgresql://localhost/ejb DriverClass=org.postgresql.Driver UserName=sms Password=password FooPostgresDS java:/TransactionManager jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory # #Wed Aug 15 16:17:29 EDT 2001 BlockingTimeoutMillis=50 IdleTimeoutMinutes=30 MaxSize=10 CleanupIntervalMinutes=10 MinSize=0 MaxIdleTimeoutPercent=1.0 org.jboss.resource.security.ManyToOnePrincipalMapping UserName=
Postgres and JBoss 3 RC1 (was: [JBoss-user] Newbie)
I know it's not a great idea to answer to your own post, but someone suggested that I send a few more details. IMO, it was lame of me to leave them out, so sorry for not doing this earlier! I'm using jboss-3.0.0RC1, JDK 1.4, Postgres 7.2.1 and the postgres-service.xml 1.3 file from CVS. The only changes that I've made to the postgres-service.xml file are to the user name, password and connection url. I've attached it to this email, with the password being the only difference between this and and the deployed version. Once JBoss has started, connecting to "http://localhost:8082"; lists the hsqldbDS, but no reference is made to "FooPostgresDS". There are no startup error messages, and the Postgres logs indicate that no connection attempt is made. I am starting the default JBoss server from a freshly unpacked copy of the RC1 download. I've copied the pgjdbc2.jar file to both ${JBOSS_HOME}/lib and ${JBOSS_HOME}/lib/ext, and the startup logs indicate that it is picked up. The startup logs also contain the lines: 17:18:31,621 INFO [MainDeployer] Starting deployment of package: file:/home/sms/jboss/jboss-3.0.0RC1/server/default/deploy/postgres-service.xml 17:18:31,943 INFO [MainDeployer] Successfully completed deployment of package: file:/home/sms/jboss/jboss-3.0.0RC1/server/default/deploy/postgres-service.xml which suggests that I'm not doing things _entirely_ wrong. I believe that once the postgres datasource is picked up, it should just be a case of renaming the DS to "DefaultDS" to have everything go according to plan. Regards, Simon On Mon, Apr 15, 2002 at 04:16:20PM +0100, Simon Stewart wrote: > How do I get to use Postgres as the backend database instead of hsqldb > in Orion? I'd like to bind it to DefaultDS so that I can ditch hsqldb, > but I'm not sure how to do this. > > I believe that all that needs to be done is to copy pgjdbc2.jar to > "${JBOSS_HOME}/lib/ext and the postgres-service.xml from the cvs tree > to the server/default/deploy directory (for the sake of simplicity) > but this doesn't work at all --- attempting to deploy my ".ear" file > results in multiple exceptions, and from the stack trace this is > because nothing is bound to DefaultDS > > Any help or advice on this would be greatly appreciated --- I'm > finding it hard to get going with JBoss, even though it appears to > have a good reputation amongst those that I've spoken to about it. -- [Regarding "Highlander II"] "In an experiment to determine the precise amount of beer required to enjoy this film, I passed out." -- Dave O'Brien ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user