FW: [JBoss-user] PostgreSQL 7.1 Datasource setup
John, Got a reply saying "mail to long" - here the mail (see below) without standardjaws.xml attached, only the relevant changed bits: PostgresDB PostgreSQL This standardjaws is from jBoss2.0 times, we just keep copying the config files over and adapting them when moving to a new version ... Here is the rest of the email: > -Original Message- > From: Robert Schulz > Sent: Sunday, 22 April 2001 17:59 > To: '[EMAIL PROTECTED]' > Subject: RE: [JBoss-user] PostgreSQL 7.1 Datasource setup > > > Haa .. another change we made so long ago for postgres, that > I forgot ... sorry. > In standardjaws.xml it seems to setup the defaultDS which > points to hypersonic, > which must somehow also trigger the black box db thing - > again, don't really > have time to dig around this (especially as I don't want to > use hypersonic). > Attached our standardjaws.xml (stripped of everything we > don't need / understand). > > Hope this will do the trick. > > Cheers, > > R. > > PS> This standardjaws name change will now of course dripple > through all your > deployment descriptors for you beans. Your jboss.xml-s > (in META-INF) should > look like > > > > > res-class="org.jboss.ejb.deployment.JDBCResource"> > FOOBAR > java:/PostgresDB > > > > and then in the same file something like > > > > > SomeBeanName > > ResourceRefName > FOOBAR > > > > and in your code use "java:comp/env/ResourceRefName" to get > to the connection pool. > > > > -Original Message- > > From: John Menke [mailto:[EMAIL PROTECTED]] > > Sent: Friday, 20 April 2001 12:12 > > To: [EMAIL PROTECTED] > > Subject: RE: [JBoss-user] PostgreSQL 7.1 Datasource setup > > > > > > Robert, > > > > I used your versions of jboss.conf and jboss.jcml with the > > adjustments for > > jdbc url. (Thanks:)) It looks like it ran well. Take a look > > at the log > > though. I have this phantom datasource at the bottom again!! > > Where is > > DefaultDB coming from?? For that matter where is BlackBoxDB > > coming from? It > > is not mentioned in jboss.jcml!!? > > > > CLASSPATH=/usr/tomcat/webapps/cocoon/WEB-INF/lib:/usr/local/jC > > VS-5.2.2/jars/ > > jcvsii.jar:run.jar:../lib/crimson.jar > > jboss.home = /usr/local/jboss > > Using configuration "default" > > [Info] Java version: 1.3.0,Sun Microsystems Inc. > > [Info] Java VM: Java HotSpot(TM) Server VM 1.3.0,Sun > Microsystems Inc. > > [Info] System: Linux 2.2.14-5.0,i386 > > [Shutdown] Shutdown hook added > > [Service Control] Registered with server > > [Service Control] Initializing 26 MBeans > > [Webserver] Initializing > > [Webserver] Initialized > > [Naming] Initializing > > [Naming] Initialized > > [JNDIView] Initializing > > [JNDIView] Initialized > > [Transaction manager] Initializing > > [Transaction manager] Initialized > > [JDBC provider] Initializing > > [JDBC provider] Loaded JDBC-driver:org.postgresql.Driver > > [JDBC provider] Initialized > > [PostgresDB] Initializing > > [PostgresDB] Initialized > > [Container factory] Initializing > > [Container factory] Initialized > > [J2EE Deployer Default] Initializing > > [J2EE Deployer Default] Initialized > > [Auto deploy] Initializing > > [Auto deploy] Initialized > > [ConnectionManagerFactoryLoader] Initializing > > [MinervaXACMFactory] Initialized > > [JMX RMI Adaptor] Initializing > > [JMX RMI Adaptor] Initialized > > [JMX RMI Connector] Initializing > > [JMX RMI Connector] Initialized > > [ConnectionFactoryLoader] Initializing > > [BlackBoxDS] Initialized > > [DefaultDS] Initializing > > [DefaultDS] Initialized > > [ConnectionManagerFactoryLoader] Initializing > > [MinervaNoTransCMFactory] Initialized > > [InstantDB] Initializing > > [InstantDB] Initialized > > [RARDeployer] Initializing > > [RARDeployer] Initialized > > [JBossMQ] Initializing > > [JBossMQ] Initialized > > [JAAS Security Manager] Initializing > > [JAAS Security Manager] Initialized > > [jdbc/PostgresDB] Initializing > > [jdbc/PostgresDB] Initialized > > [StdJMSPool] Initializing > > [StdJMSPool] Initialized > > [DefaultJMSProvider] Initializing > > [DefaultJMSProvider] Initialized > > [Mail Service] Initializing > > [Mail Service] Initialized > > [ConnectionMan
RE: [JBoss-user] PostgreSQL 7.1 Datasource setup
That was it! jboss-auto was creating the phantom entries!!! THANKS TO EVERYONE FOR THEIR HELP :) I also added a password to the password attribute in the postgres config. (After deleting the auto-conf I was getting a new error). It seems like jboss-auto was caching the attribute settings also. p.s. Doreen, pg_hba.conf is a postgres file that deals with security. If you are running Informix you don't have to worry about it. Did you try deleting the jboss-auto.jcml file? When I removed it, I stopped getting the phantom entries on startup. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of David Jencks > Sent: Friday, April 20, 2001 1:19 AM > To: [EMAIL PROTECTED] > Subject: RE: [JBoss-user] PostgreSQL 7.1 Datasource setup > > > I haven't been following your thread but if you leave > jboss-auto.jcml lying > around ( and aren't using the -very- latest ( i think 2.3, maybe 2.2.1) > sources you will keep getting all the mbeans from your previous runs even > though you removed them from jboss.jcml. Delete jboss-auto.jcml and these > extras should go away. > > david jencks > On 2001.04.19 22:11:36 -0400 John Menke wrote: > > Robert, > > > > I used your versions of jboss.conf and jboss.jcml with the adjustments > > for > > jdbc url. (Thanks:)) It looks like it ran well. Take a look at the log > > though. I have this phantom datasource at the bottom again!! Where is > > DefaultDB coming from?? For that matter where is BlackBoxDB coming from? > > It > > is not mentioned in jboss.jcml!!? > > > > > CLASSPATH=/usr/tomcat/webapps/cocoon/WEB-INF/lib:/usr/local/jCVS-5 > .2.2/jars/ > > jcvsii.jar:run.jar:../lib/crimson.jar > > jboss.home = /usr/local/jboss > > Using configuration "default" > > [Info] Java version: 1.3.0,Sun Microsystems Inc. > > [Info] Java VM: Java HotSpot(TM) Server VM 1.3.0,Sun Microsystems Inc. > > [Info] System: Linux 2.2.14-5.0,i386 > > [Shutdown] Shutdown hook added > > [Service Control] Registered with server > > [Service Control] Initializing 26 MBeans > > [Webserver] Initializing > > [Webserver] Initialized > > [Naming] Initializing > > [Naming] Initialized > > [JNDIView] Initializing > > [JNDIView] Initialized > > [Transaction manager] Initializing > > [Transaction manager] Initialized > > [JDBC provider] Initializing > > [JDBC provider] Loaded JDBC-driver:org.postgresql.Driver > > [JDBC provider] Initialized > > [PostgresDB] Initializing > > [PostgresDB] Initialized > > [Container factory] Initializing > > [Container factory] Initialized > > [J2EE Deployer Default] Initializing > > [J2EE Deployer Default] Initialized > > [Auto deploy] Initializing > > [Auto deploy] Initialized > > [ConnectionManagerFactoryLoader] Initializing > > [MinervaXACMFactory] Initialized > > [JMX RMI Adaptor] Initializing > > [JMX RMI Adaptor] Initialized > > [JMX RMI Connector] Initializing > > [JMX RMI Connector] Initialized > > [ConnectionFactoryLoader] Initializing > > [BlackBoxDS] Initialized > > [DefaultDS] Initializing > > [DefaultDS] Initialized > > [ConnectionManagerFactoryLoader] Initializing > > [MinervaNoTransCMFactory] Initialized > > [InstantDB] Initializing > > [InstantDB] Initialized > > [RARDeployer] Initializing > > [RARDeployer] Initialized > > [JBossMQ] Initializing > > [JBossMQ] Initialized > > [JAAS Security Manager] Initializing > > [JAAS Security Manager] Initialized > > [jdbc/PostgresDB] Initializing > > [jdbc/PostgresDB] Initialized > > [StdJMSPool] Initializing > > [StdJMSPool] Initialized > > [DefaultJMSProvider] Initializing > > [DefaultJMSProvider] Initialized > > [Mail Service] Initializing > > [Mail Service] Initialized > > [ConnectionManagerFactoryLoader] Initializing > > [MinervaSharedLocalCMFactory] Initialized > > [Hypersonic] Initializing > > [Hypersonic] Initialized > > [Service Control] Initialized 26 services > > [Service Control] Starting 26 MBeans > > [Webserver] Starting > > [Webserver] Codebase set to http://remote:8083/ > > [Webserver] Started webserver on port 8083 > > [Webserver] Started > > [Naming] Starting > > [Naming] Naming started on port 1099 > > [Naming] Started > > [JNDIView] Starting > > [JNDIView] Started > > [Transaction manager] Starting > > [Transaction manager] Started > > [JDBC provider] Starting > > [JDBC provider] Started > > [PostgresDB] Starting > > [PostgresDB] XA Connection pool PostgresDB b
Re: [JBoss-user] PostgreSQL 7.1 Datasource setup
David is quite correct (as is his wont) - when you make a configuration change it is usually a good idea to kill (expurgate, delete, elminiate, etc.) jboss-auto.conf. In more than good fun, danch David Jencks wrote: > I haven't been following your thread but if you leave jboss-auto.jcml lying > around ( and aren't using the -very- latest ( i think 2.3, maybe 2.2.1) > sources you will keep getting all the mbeans from your previous runs even > though you removed them from jboss.jcml. Delete jboss-auto.jcml and these > extras should go away. > > david jencks ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
RE: [JBoss-user] PostgreSQL 7.1 Datasource setup
I haven't been following your thread but if you leave jboss-auto.jcml lying around ( and aren't using the -very- latest ( i think 2.3, maybe 2.2.1) sources you will keep getting all the mbeans from your previous runs even though you removed them from jboss.jcml. Delete jboss-auto.jcml and these extras should go away. david jencks On 2001.04.19 22:11:36 -0400 John Menke wrote: > Robert, > > I used your versions of jboss.conf and jboss.jcml with the adjustments > for > jdbc url. (Thanks:)) It looks like it ran well. Take a look at the log > though. I have this phantom datasource at the bottom again!! Where is > DefaultDB coming from?? For that matter where is BlackBoxDB coming from? > It > is not mentioned in jboss.jcml!!? > > CLASSPATH=/usr/tomcat/webapps/cocoon/WEB-INF/lib:/usr/local/jCVS-5.2.2/jars/ > jcvsii.jar:run.jar:../lib/crimson.jar > jboss.home = /usr/local/jboss > Using configuration "default" > [Info] Java version: 1.3.0,Sun Microsystems Inc. > [Info] Java VM: Java HotSpot(TM) Server VM 1.3.0,Sun Microsystems Inc. > [Info] System: Linux 2.2.14-5.0,i386 > [Shutdown] Shutdown hook added > [Service Control] Registered with server > [Service Control] Initializing 26 MBeans > [Webserver] Initializing > [Webserver] Initialized > [Naming] Initializing > [Naming] Initialized > [JNDIView] Initializing > [JNDIView] Initialized > [Transaction manager] Initializing > [Transaction manager] Initialized > [JDBC provider] Initializing > [JDBC provider] Loaded JDBC-driver:org.postgresql.Driver > [JDBC provider] Initialized > [PostgresDB] Initializing > [PostgresDB] Initialized > [Container factory] Initializing > [Container factory] Initialized > [J2EE Deployer Default] Initializing > [J2EE Deployer Default] Initialized > [Auto deploy] Initializing > [Auto deploy] Initialized > [ConnectionManagerFactoryLoader] Initializing > [MinervaXACMFactory] Initialized > [JMX RMI Adaptor] Initializing > [JMX RMI Adaptor] Initialized > [JMX RMI Connector] Initializing > [JMX RMI Connector] Initialized > [ConnectionFactoryLoader] Initializing > [BlackBoxDS] Initialized > [DefaultDS] Initializing > [DefaultDS] Initialized > [ConnectionManagerFactoryLoader] Initializing > [MinervaNoTransCMFactory] Initialized > [InstantDB] Initializing > [InstantDB] Initialized > [RARDeployer] Initializing > [RARDeployer] Initialized > [JBossMQ] Initializing > [JBossMQ] Initialized > [JAAS Security Manager] Initializing > [JAAS Security Manager] Initialized > [jdbc/PostgresDB] Initializing > [jdbc/PostgresDB] Initialized > [StdJMSPool] Initializing > [StdJMSPool] Initialized > [DefaultJMSProvider] Initializing > [DefaultJMSProvider] Initialized > [Mail Service] Initializing > [Mail Service] Initialized > [ConnectionManagerFactoryLoader] Initializing > [MinervaSharedLocalCMFactory] Initialized > [Hypersonic] Initializing > [Hypersonic] Initialized > [Service Control] Initialized 26 services > [Service Control] Starting 26 MBeans > [Webserver] Starting > [Webserver] Codebase set to http://remote:8083/ > [Webserver] Started webserver on port 8083 > [Webserver] Started > [Naming] Starting > [Naming] Naming started on port 1099 > [Naming] Started > [JNDIView] Starting > [JNDIView] Started > [Transaction manager] Starting > [Transaction manager] Started > [JDBC provider] Starting > [JDBC provider] Started > [PostgresDB] Starting > [PostgresDB] XA Connection pool PostgresDB bound to java:/PostgresDB > [PostgresDB] org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl > created > new Connection (org.postgresql.jdbc2.Connection) with XAResource > org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl and XAConnection > org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl. > [PostgresDB] No transaction right now. > [PostgresDB] Pool PostgresDB [0/0/20] gave out new object: > org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@23e5d1 > [PostgresDB] Pool PostgresDB [0/1/20] returned object > org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@23e5d1 to the > pool. > [PostgresDB] Started > [Container factory] Starting > [Container factory] Started > [J2EE Deployer Default] Starting > [J2EE Deployer Default] No web container found - only EJB deployment > available... > [J2EE Deployer Default] Cleaning up deployment directory > [J2EE Deployer Default] Started > [Auto deploy] Starting > [Auto deploy] Watching /usr/local/jboss/deploy > [Auto deploy] Started > [MinervaXACMFactory] Starting > [MinervaXACMFactory] Connection manager factory 'MinervaXACMFactory bound > to > 'java:/MinervaXACMFactory' > [MinervaXACMFactory] Started > [JMX RMI Adaptor] Starting > [JMX RMI Adaptor] Started > [JMX RMI Connector] Starting > [JMX RMI Connector] Started > [BlackBoxDS] Starting > [BlackBoxDS] Started > [DefaultDS] Starting > [DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS > > Below is the jboss.jcml file. I used your jboss.conf exactly. > > > > > >name="DefaultDomain:service=Webserver"> > 8083 > > > >name="Defau
RE: [JBoss-user] PostgreSQL 7.1 Datasource setup
Robert, I used your versions of jboss.conf and jboss.jcml with the adjustments for jdbc url. (Thanks:)) It looks like it ran well. Take a look at the log though. I have this phantom datasource at the bottom again!! Where is DefaultDB coming from?? For that matter where is BlackBoxDB coming from? It is not mentioned in jboss.jcml!!? CLASSPATH=/usr/tomcat/webapps/cocoon/WEB-INF/lib:/usr/local/jCVS-5.2.2/jars/ jcvsii.jar:run.jar:../lib/crimson.jar jboss.home = /usr/local/jboss Using configuration "default" [Info] Java version: 1.3.0,Sun Microsystems Inc. [Info] Java VM: Java HotSpot(TM) Server VM 1.3.0,Sun Microsystems Inc. [Info] System: Linux 2.2.14-5.0,i386 [Shutdown] Shutdown hook added [Service Control] Registered with server [Service Control] Initializing 26 MBeans [Webserver] Initializing [Webserver] Initialized [Naming] Initializing [Naming] Initialized [JNDIView] Initializing [JNDIView] Initialized [Transaction manager] Initializing [Transaction manager] Initialized [JDBC provider] Initializing [JDBC provider] Loaded JDBC-driver:org.postgresql.Driver [JDBC provider] Initialized [PostgresDB] Initializing [PostgresDB] Initialized [Container factory] Initializing [Container factory] Initialized [J2EE Deployer Default] Initializing [J2EE Deployer Default] Initialized [Auto deploy] Initializing [Auto deploy] Initialized [ConnectionManagerFactoryLoader] Initializing [MinervaXACMFactory] Initialized [JMX RMI Adaptor] Initializing [JMX RMI Adaptor] Initialized [JMX RMI Connector] Initializing [JMX RMI Connector] Initialized [ConnectionFactoryLoader] Initializing [BlackBoxDS] Initialized [DefaultDS] Initializing [DefaultDS] Initialized [ConnectionManagerFactoryLoader] Initializing [MinervaNoTransCMFactory] Initialized [InstantDB] Initializing [InstantDB] Initialized [RARDeployer] Initializing [RARDeployer] Initialized [JBossMQ] Initializing [JBossMQ] Initialized [JAAS Security Manager] Initializing [JAAS Security Manager] Initialized [jdbc/PostgresDB] Initializing [jdbc/PostgresDB] Initialized [StdJMSPool] Initializing [StdJMSPool] Initialized [DefaultJMSProvider] Initializing [DefaultJMSProvider] Initialized [Mail Service] Initializing [Mail Service] Initialized [ConnectionManagerFactoryLoader] Initializing [MinervaSharedLocalCMFactory] Initialized [Hypersonic] Initializing [Hypersonic] Initialized [Service Control] Initialized 26 services [Service Control] Starting 26 MBeans [Webserver] Starting [Webserver] Codebase set to http://remote:8083/ [Webserver] Started webserver on port 8083 [Webserver] Started [Naming] Starting [Naming] Naming started on port 1099 [Naming] Started [JNDIView] Starting [JNDIView] Started [Transaction manager] Starting [Transaction manager] Started [JDBC provider] Starting [JDBC provider] Started [PostgresDB] Starting [PostgresDB] XA Connection pool PostgresDB bound to java:/PostgresDB [PostgresDB] org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl created new Connection (org.postgresql.jdbc2.Connection) with XAResource org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl and XAConnection org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl. [PostgresDB] No transaction right now. [PostgresDB] Pool PostgresDB [0/0/20] gave out new object: org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@23e5d1 [PostgresDB] Pool PostgresDB [0/1/20] returned object org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@23e5d1 to the pool. [PostgresDB] Started [Container factory] Starting [Container factory] Started [J2EE Deployer Default] Starting [J2EE Deployer Default] No web container found - only EJB deployment available... [J2EE Deployer Default] Cleaning up deployment directory [J2EE Deployer Default] Started [Auto deploy] Starting [Auto deploy] Watching /usr/local/jboss/deploy [Auto deploy] Started [MinervaXACMFactory] Starting [MinervaXACMFactory] Connection manager factory 'MinervaXACMFactory bound to 'java:/MinervaXACMFactory' [MinervaXACMFactory] Started [JMX RMI Adaptor] Starting [JMX RMI Adaptor] Started [JMX RMI Connector] Starting [JMX RMI Connector] Started [BlackBoxDS] Starting [BlackBoxDS] Started [DefaultDS] Starting [DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS Below is the jboss.jcml file. I used your jboss.conf exactly. 8083 1099 300 org.postgresql.Driver PostgresDB org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp l jdbc:postgresql://192.168.0.2/ejb 120 postgres 20 false false false true 12 180 true true 1.0 0 true false true false Default :service=ContainerFactory J2EE:service=J2eeDeployer ../deploy MinervaXACMFactory org.opentools.minerva.connector.jboss.MinervaXACMFactory 10 8082 ___
Re: [JBoss-user] PostgreSQL 7.1 Datasource setup
Set loggingEnabled to true in your jcml. God willing, that will allow you to see the damned SQLException that's being thrown and eaten. -danch John Menke wrote: > It was related to that. (pg_hba.conf) I had an entry for localhost in the > pg_hba.conf. For some reason Postgresql was seeing the JBoss connection > coming from my local network IP address instead of localhost. I determined > this by trying to connect to a JSP page that uses the database from Tomcat. > It gave an error pointing to the local address. I added the local address > in the pg_hba.conf and Tomcat worked. So then I tried the Jboss startup > again. It seemed to work as it printed that the PostgreDB pool was created > in the log, BUT... at the very end of the log, I get the same message as > before... Very strange. I have included both the JBOSS.jcml and the log > file below: > > > ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
RE: [JBoss-user] PostgreSQL 7.1 Datasource setup
We run RH7.0 with jBoss2.2 and Postgres7.1b5 - works like a dream. Attached is out jboss.conf and jboss.jcml - have look at it. Will not fit your need exactly, as we don't use tomcat and I also ripped other MBeans which we don't need, but the postgres stuff should be the same (change connection info) - just diff the files to see what's different. For testing, just put host all 0.0.0.0 0.0.0.0 trust in pg_hba.conf. Hope this helps! Cheers, Robert. > -Original Message- > From: John Menke [mailto:[EMAIL PROTECTED]] > Sent: Friday, 20 April 2001 7:20 > To: [EMAIL PROTECTED] > Subject: RE: [JBoss-user] PostgreSQL 7.1 Datasource setup > > > It was related to that. (pg_hba.conf) I had an entry for > localhost in the > pg_hba.conf. For some reason Postgresql was seeing the JBoss > connection > coming from my local network IP address instead of localhost. > I determined > this by trying to connect to a JSP page that uses the > database from Tomcat. > It gave an error pointing to the local address. I added the > local address > in the pg_hba.conf and Tomcat worked. So then I tried the > Jboss startup > again. It seemed to work as it printed that the PostgreDB > pool was created > in the log, BUT... at the very end of the log, I get the > same message as > before... Very strange. I have included both the JBOSS.jcml > and the log > file below: > > > > > THIS IS THE JBOSS.JCML FILE > > > > > > > > >name="DefaultDomain:service=Webserver"> > 8083 > > > >name="DefaultDomain:service=Naming"> > 1099 > >name="DefaultDomain:service=JNDIView" /> > > > >name="DefaultDomain:service=TransactionManager"> > 300 > > > > > > > > >name="Security:name=JaasSecurityManager"> > name="SecurityManagerClassName">org.jboss.security.plugins.Jaa > sSecurityManag > er > > > > > >name="DefaultDomain:service=JdbcProvider"> > name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc. > idbDriver,org. > postgresql.Driver > > >name="DefaultDomain:service=Hypersonic"> > 1476 > true > default > false > > >name="DefaultDomain:service=XADataSource,name=InstantDB"> > InstantDB > name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.X > ADataSourceImp > l > > name="URL">jdbc:idb:../conf/default/instantdb.properties > 120 > > 10 > > false > false > false > true > 12 > 180 > false > false > 1.0 > 0 > > >name="DefaultDomain:service=XADataSource,name=DefaultDS"> > DefaultDS > name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.X > ADataSourceImp > l > > name="URL">jdbc:HypersonicSQL:hsql://localhost:1476 > 120 > sa > 10 > > false > false > false > true > 12 > 180 > false > false > 1.0 > 0 > > > name="DefaultDomain:service=XADataSource,name=PostgresDB"> > PostgresDB > name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.X > ADataSourceImp > l > > name="URL">jdbc:postgresql://localhost:5432/ejb > 120 > ejbUser > 10 > ejbPassword > false > false > false > true > 12 > 180 > false > false > 1.0 > 0 > > > > >name=":service=ContainerFactory"> > true > false > true > false > > > > > > > >name="DefaultDomain:service=JBossMQ" /> >name=":service=JMSProviderLoader,name=JBossMQProvider"> > DefaultJMSProvider > name="ProviderAdapterClass">org.jboss.jms.jndi.JBossMQProvider > > >name=":service=ServerSessionPoolMBean,name=StdJMSPool"> > StdJMSPool > name="PoolFactoryClass">org.jboss.jms.asf.StdServerSessionPool > Factory bute> > > > > >name="J2EE:service=J2eeDeployer"> > Default > name="JarDeployerName">:service=ContainerFactory > name="WarDeployerName">:service=
RE: [JBoss-user] PostgreSQL 7.1 Datasource setup
nitialized [ConnectionManagerFactoryLoader] Initializing [MinervaNoTransCMFactory] Initialized [ConnectionManagerFactoryLoader] Initializing [MinervaSharedLocalCMFactory] Initialized [ConnectionManagerFactoryLoader] Initializing [MinervaXACMFactory] Initialized [ConnectionFactoryLoader] Initializing [BlackBoxDS] Initialized [JMX RMI Adaptor] Initializing [JMX RMI Adaptor] Initialized [JMX RMI Connector] Initializing [JMX RMI Connector] Initialized [Mail Service] Initializing [Mail Service] Initialized [jdbc/PostgresDB] Initializing [jdbc/PostgresDB] Initialized [Service Control] Initialized 26 services [Service Control] Starting 26 MBeans [Webserver] Starting [Webserver] Codebase set to http://remote:8083/ [Webserver] Started webserver on port 8083 [Webserver] Started [Naming] Starting [Naming] Naming started on port 1099 [Naming] Started [JNDIView] Starting [JNDIView] Started [Transaction manager] Starting [Transaction manager] Started [JAAS Security Manager] Starting [JAAS Security Manager] JAAS.startService, cachePolicy=null [JAAS Security Manager] JAAS.startService, SecurityProxyFactory=org.jboss.security.SubjectSecurityProxyFactory@10058 [JAAS Security Manager] Started [JDBC provider] Starting [JDBC provider] Started [Hypersonic] Starting [Hypersonic] Server 1.4 is running [Hypersonic] Database started [Hypersonic] Started [InstantDB] Starting [Hypersonic] Press [Ctrl]+[C] to abort [InstantDB] XA Connection pool InstantDB bound to java:/InstantDB Enhydra InstantDB - Version 3.21 [InstantDB] The Initial Developer of the Original Code is Lutris Technologies Inc. Portions created by Lutris are Copyright (C) 1997-2000 Lutris Technologies, Inc. All Rights Reserved. [InstantDB] Started [DefaultDS] Starting [DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS [DefaultDS] Started [PostgresDB] Starting [PostgresDB] XA Connection pool PostgresDB bound to java:/PostgresDB [PostgresDB] Started [Container factory] Starting [Container factory] Started [JBossMQ] Starting [JBossMQ] Server Version 0.8 Started [JBossMQ] Started [DefaultJMSProvider] Starting [DefaultJMSProvider] JMS provider Adapter DefaultJMSProvider bound to java:/DefaultJMSProvider [DefaultJMSProvider] Started [StdJMSPool] Starting [StdJMSPool] JMS provider Adapter StdJMSPool bound to java:/StdJMSPool [StdJMSPool] Started [J2EE Deployer Default] Starting [J2EE Deployer Default] No web container found - only EJB deployment available... [J2EE Deployer Default] Cleaning up deployment directory [J2EE Deployer Default] Started [Auto deploy] Starting [Auto deploy] Watching /usr/local/jboss/deploy [Auto deploy] Started [RARDeployer] Starting [RARDeployer] Started [MinervaNoTransCMFactory] Starting [MinervaNoTransCMFactory] Connection manager factory 'MinervaNoTransCMFactory bound to 'java:/MinervaNoTransCMFactory' [MinervaNoTransCMFactory] Started [MinervaSharedLocalCMFactory] Starting [MinervaSharedLocalCMFactory] Connection manager factory 'MinervaSharedLocalCMFactory bound to 'java:/MinervaSharedLocalCMFactory' [MinervaSharedLocalCMFactory] Started [MinervaXACMFactory] Starting [MinervaXACMFactory] Connection manager factory 'MinervaXACMFactory bound to 'java:/MinervaXACMFactory' [MinervaXACMFactory] Started [BlackBoxDS] Starting [BlackBoxDS] Started [JMX RMI Adaptor] Starting [JMX RMI Adaptor] Started [JMX RMI Connector] Starting [JMX RMI Connector] Started [Mail Service] Starting [Mail Service] DEBUG: not loading system providers in /lib [Mail Service] DEBUG: not loading optional custom providers file: /META-INF/javamail.providers [Mail Service] DEBUG: successfully loaded default providers [Mail Service] DEBUG: Tables of loaded providers [Mail Service] DEBUG: Providers Listed By Class Name: {com.sun.mail.smtp.SMTPTransport=javax.mail.Provider[TRANSPORT,smtp,com.sun. mail.smtp.SMTPTransport,Sun Microsystems, Inc], com.sun.mail.imap.IMAPStore=javax.mail.Provider[STORE,imap,com.sun.mail.imap .IMAPStore,Sun Microsystems, Inc], com.sun.mail.pop3.POP3Store=javax.mail.Provider[STORE,pop3,com.sun.mail.pop3 .POP3Store,Sun Microsystems, Inc]} [Mail Service] DEBUG: Providers Listed By Protocol: {imap=javax.mail.Provider[STORE,imap,com.sun.mail.imap.IMAPStore,Sun Microsystems, Inc], pop3=javax.mail.Provider[STORE,pop3,com.sun.mail.pop3.POP3Store,Sun Microsystems, Inc], smtp=javax.mail.Provider[TRANSPORT,smtp,com.sun.mail.smtp.SMTPTransport,Sun Microsystems, Inc]} [Mail Service] DEBUG: not loading optional address map file: /META-INF/javamail.address.map [Mail Service] Mail Service 'Mail' bound to java:/Mail [Mail Service] Started [jdbc/PostgresDB] Starting [jdbc/PostgresDB] XA Connection pool jdbc/PostgresDB bound to java:/jdbc/PostgresDB > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of danch > Sent: Thursday, April 19, 2001 4:11 PM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] PostgreSQL 7.1 Datasource setup > > > My only though
Re: [JBoss-user] PostgreSQL 7.1 Datasource setup
My only thought is if you have pg_hba.conf set up to allow TCP from localhost? -danch John Menke wrote: > > I just tried that and it still doesn't work. > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel > > Cardin > > Sent: Thursday, April 19, 2001 2:52 PM > > To: [EMAIL PROTECTED] > > Subject: RE: [JBoss-user] PostgreSQL 7.1 Datasource setup > > > > > > I can't say for sure, because I don't use Postgresql... but AFAIK, you > > should > > use the same values for the PoolName and the Name under the XADataSource > > service. > > > > ie: > > > > > name="DefaultDomain:service=XADataSource,name=jdbc/PostgresDB"> > > jdbc/PostgresDB > > > > instead of > > > > > name="DefaultDomain:service=XADataSource,name=PostgreSQL"> > > jdbc/PostgresDB > > > > When JBoss hangs on the datasource binding, from my experience, it > > indicates a connection to the datasource > > could not be established, either because the name is incorrect or the > > database is not reachable. > > > > HTH, > > > > Daniel > > > > -Message d'origine- > > De : John Menke [mailto:[EMAIL PROTECTED]] > > Envoyé : 19 avril, 2001 14:38 > > À : jboss > > Objet : [JBoss-user] PostgreSQL 7.1 Datasource setup > > > > > > I have the following coded in my jboss.jcml and I have included > > postgresql.jar in my lib/ext folder, but JBoss hangs on startup. > > postmaster > > is running with the -i option when I try this and I have a database > > setup > > named ejb with ejbUser as a user and ejbUserPassword as the account > > password. > > > > My environment is: > > > > JBoss 2.2 > > PostgreSQL 7.1RC4 > > Redhat Linux 6.2 > > > > JBoss startup ends with the following output: > > > > [jdbc/PostgresDB] Starting > > [jdbc/PostgresDB] XA connection pool jdbc/PostgreDB bound to > > java:/jdbc/PostgresDB > > > > then it hangs... > > > > Does anyone have Postgres7.1 working with JBoss? > > > > > name="DefaultDomain:service=XADataSource,name=PostgreSQL"> > > jdbc/PostgresDB > > > name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourc > > eImp > > l > > > > > name="URL">jdbc:postgresql://localhost:5432/ejb > > 120 > > ejbUser > > 10 > > ejbUserPassword > > false > > false > > false > > true > > 12 > > 180 > > false > > false > > 1.0 > > 0 > > > > > > > > > > > > > > > > > > > > ___ > > 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 > > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > http://lists.sourceforge.net/lists/listinfo/jboss-user Confidential e-mail for addressee only. Access to this e-mail by anyone else is unauthorized. If you have received this message in error, please notify the sender immediately by reply e-mail and destroy the original communication. ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
RE: [JBoss-user] PostgreSQL 7.1 Datasource setup
I just tried that and it still doesn't work. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Daniel > Cardin > Sent: Thursday, April 19, 2001 2:52 PM > To: [EMAIL PROTECTED] > Subject: RE: [JBoss-user] PostgreSQL 7.1 Datasource setup > > > I can't say for sure, because I don't use Postgresql... but AFAIK, you > should > use the same values for the PoolName and the Name under the XADataSource > service. > > ie: > > name="DefaultDomain:service=XADataSource,name=jdbc/PostgresDB"> > jdbc/PostgresDB > > instead of > > name="DefaultDomain:service=XADataSource,name=PostgreSQL"> > jdbc/PostgresDB > > When JBoss hangs on the datasource binding, from my experience, it > indicates a connection to the datasource > could not be established, either because the name is incorrect or the > database is not reachable. > > HTH, > > Daniel > > -Message d'origine- > De : John Menke [mailto:[EMAIL PROTECTED]] > Envoyé : 19 avril, 2001 14:38 > À : jboss > Objet : [JBoss-user] PostgreSQL 7.1 Datasource setup > > > I have the following coded in my jboss.jcml and I have included > postgresql.jar in my lib/ext folder, but JBoss hangs on startup. > postmaster > is running with the -i option when I try this and I have a database > setup > named ejb with ejbUser as a user and ejbUserPassword as the account > password. > > My environment is: > > JBoss 2.2 > PostgreSQL 7.1RC4 > Redhat Linux 6.2 > > JBoss startup ends with the following output: > > [jdbc/PostgresDB] Starting > [jdbc/PostgresDB] XA connection pool jdbc/PostgreDB bound to > java:/jdbc/PostgresDB > > then it hangs... > > Does anyone have Postgres7.1 working with JBoss? > > name="DefaultDomain:service=XADataSource,name=PostgreSQL"> > jdbc/PostgresDB > name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourc > eImp > l > > name="URL">jdbc:postgresql://localhost:5432/ejb > 120 > ejbUser > 10 > ejbUserPassword > false > false > false > true > 12 > 180 > false > false > 1.0 > 0 > > > > > > > > > > ___ > 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 ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
RE: [JBoss-user] PostgreSQL 7.1 Datasource setup
I can't say for sure, because I don't use Postgresql... but AFAIK, you should use the same values for the PoolName and the Name under the XADataSource service. ie: jdbc/PostgresDB instead of jdbc/PostgresDB When JBoss hangs on the datasource binding, from my experience, it indicates a connection to the datasource could not be established, either because the name is incorrect or the database is not reachable. HTH, Daniel -Message d'origine- De : John Menke [mailto:[EMAIL PROTECTED]] Envoyé : 19 avril, 2001 14:38 À : jboss Objet : [JBoss-user] PostgreSQL 7.1 Datasource setup I have the following coded in my jboss.jcml and I have included postgresql.jar in my lib/ext folder, but JBoss hangs on startup. postmaster is running with the -i option when I try this and I have a database setup named ejb with ejbUser as a user and ejbUserPassword as the account password. My environment is: JBoss 2.2 PostgreSQL 7.1RC4 Redhat Linux 6.2 JBoss startup ends with the following output: [jdbc/PostgresDB] Starting [jdbc/PostgresDB] XA connection pool jdbc/PostgreDB bound to java:/jdbc/PostgresDB then it hangs... Does anyone have Postgres7.1 working with JBoss? jdbc/PostgresDB org.opentools.minerva.jdbc.xa.wrapper.XADataSourc eImp l jdbc:postgresql://localhost:5432/ejb 120 ejbUser 10 ejbUserPassword false false false true 12 180 false false 1.0 0 ___ 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
[JBoss-user] PostgreSQL 7.1 Datasource setup
I have the following coded in my jboss.jcml and I have included postgresql.jar in my lib/ext folder, but JBoss hangs on startup. postmaster is running with the -i option when I try this and I have a database setup named ejb with ejbUser as a user and ejbUserPassword as the account password. My environment is: JBoss 2.2 PostgreSQL 7.1RC4 Redhat Linux 6.2 JBoss startup ends with the following output: [jdbc/PostgresDB] Starting [jdbc/PostgresDB] XA connection pool jdbc/PostgreDB bound to java:/jdbc/PostgresDB then it hangs... Does anyone have Postgres7.1 working with JBoss? jdbc/PostgresDB org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp l jdbc:postgresql://localhost:5432/ejb 120 ejbUser 10 ejbUserPassword false false false true 12 180 false false 1.0 0 ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user