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
>
>
>
> <?xml version="1.0" encoding="UTF-8"?>
> <!-- This is where you can add and configure your MBeans
> ATTENTION: The order of the listing here is the same order as
> the MBeans are loaded. Therefore if a MBean depends on another
> MBean to be loaded and started it has to be listed after all
> the MBeans it depends on.
> -->
>
> <server>
> <!-- Classloading -->
> <mbean code="org.jboss.web.WebService"
> name="DefaultDomain:service=Webserver">
> <attribute name="Port">8083</attribute>
> </mbean>
>
> <!-- JNDI -->
> <mbean code="org.jboss.naming.NamingService"
> name="DefaultDomain:service=Naming">
> <attribute name="Port">1099</attribute>
> </mbean>
> <mbean code="org.jboss.naming.JNDIView"
> name="DefaultDomain:service=JNDIView" />
>
>
> <!-- Transactions -->
> <mbean code="org.jboss.tm.TransactionManagerService"
> name="DefaultDomain:service=TransactionManager">
> <attribute name="TransactionTimeout">300</attribute>
> </mbean>
>
> <!-- Security -->
>
> <!-- Uncomment to enable the sample SRPVerifierStore service
> <mbean code="org.jboss.security.plugins.SRPVerifierStoreService"
> name="Security:name=SRPVerifierStoreService">
> <attribute name="JndiName">SRPDefaultVerifierSource</attribute>
> <attribute name="StoreFile">SRPVerifierStore.ser</attribute>
> </mbean>
> -->
> <!-- Uncomment to enable the SRP login service
> <mbean code="org.jboss.security.plugins.SRPService"
> name="service:name=SRPService">
> <attribute name="JndiName">SRPServerInterface</attribute>
> <attribute
> name="VerifierSourceJndiName">SRPDefaultVerifierSource</attribute>
> <attribute
> name="AuthenticationCacheJndiName">SRPAuthenticationCache</attribute>
> <attribute name="ServerPort">10099</attribute>
> </mbean>
> -->
>
> <!-- JAAS security manager and realm mapping -->
> <mbean code="org.jboss.security.plugins.JaasSecurityManagerService"
> name="Security:name=JaasSecurityManager">
> <attribute
> name="SecurityManagerClassName">org.jboss.security.plugins.Jaa
> sSecurityManag
> er</attribute>
> </mbean>
>
> <!-- Uncomment to enable the XML implementation of the JAAS policy
> <mbean code="org.jboss.security.plugins.SecurityPolicyService"
> name="Security:name=SecurityPolicyService">
> <attribute name="JndiName">DefaultSecurityPolicy</attribute>
> <attribute name="PolicyFile">sample_policy.xml</attribute>
> </mbean>
> -->
>
> <!-- JDBC -->
> <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 code="org.jboss.jdbc.HypersonicDatabase"
> name="DefaultDomain:service=Hypersonic">
> <attribute name="Port">1476</attribute>
> <attribute name="Silent">true</attribute>
> <attribute name="Database">default</attribute>
> <attribute name="Trace">false</attribute>
> </mbean>
>
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource,name=InstantDB">
> <attribute name="PoolName">InstantDB</attribute>
> <attribute
> name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.X
> ADataSourceImp
> l</attribute>
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc:idb:../conf/default/instantdb.properties</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser" />
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password" />
> <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>
>
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource,name=DefaultDS">
> <attribute name="PoolName">DefaultDS</attribute>
> <attribute
> name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.X
> ADataSourceImp
> l</attribute>
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc:HypersonicSQL:hsql://localhost:1476</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">sa</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password" />
> <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>
>
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource,name=PostgresDB">
> <attribute name="PoolName">PostgresDB</attribute>
> <attribute
> name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.X
> ADataSourceImp
> l</attribute>
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc:postgresql://localhost:5432/ejb</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">ejbUser</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password">ejbPassword</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>
>
> <!-- J2EE deployment -->
>
> <mbean code="org.jboss.ejb.ContainerFactory"
> name=":service=ContainerFactory">
> <attribute name="VerifyDeployments">true</attribute>
> <attribute name="MetricsEnabled">false</attribute>
> <attribute name="VerifierVerbose">true</attribute>
> <attribute name="BeanCacheJMSMonitoringEnabled">false</attribute>
> </mbean>
>
> <!-- Uncomment to add embedded tomcat service
> <mbean code="org.jboss.tomcat.EmbeddedTomcatService"
> name="DefaultDomain:service=EmbeddedTomcat" />
> -->
>
> <!-- Uncomment and set file URL to add Jetty service (you
> can set config
> more than once)
> <mbean code="org.jboss.jetty.JettyService"
> name="DefaultDomain:service=Jetty">
> <attribute name="Configuration">file URL to jetty.xml e.g.
> file:/usr/local/jboss/dist/conf/default/jetty.xml</attribute>
> </mbean>
> -->
>
> <!-- For Message Driven Beans -->
> <mbean code="org.jbossmq.server.JBossMQService"
> name="DefaultDomain:service=JBossMQ" />
> <mbean code="org.jboss.jms.jndi.JMSProviderLoader"
> name=":service=JMSProviderLoader,name=JBossMQProvider">
> <attribute name="ProviderName">DefaultJMSProvider</attribute>
> <attribute
> name="ProviderAdapterClass">org.jboss.jms.jndi.JBossMQProvider
> </attribute>
> </mbean>
> <mbean code="org.jboss.jms.asf.ServerSessionPoolLoader"
> name=":service=ServerSessionPoolMBean,name=StdJMSPool">
> <attribute name="PoolName">StdJMSPool</attribute>
> <attribute
> name="PoolFactoryClass">org.jboss.jms.asf.StdServerSessionPool
> Factory</attri
> bute>
> </mbean>
>
>
> <!-- Make sure you change EmbeddedTomcat to Jetty if you are using
> etty -->
> <mbean code="org.jboss.deployment.J2eeDeployer"
> name="J2EE:service=J2eeDeployer">
> <attribute name="DeployerName">Default</attribute>
> <attribute
> name="JarDeployerName">:service=ContainerFactory</attribute>
> <attribute
> name="WarDeployerName">:service=EmbeddedTomcat</attribute>
> </mbean>
>
> <mbean code="org.jboss.ejb.AutoDeployer"
> name="EJB:service=AutoDeployer">
> <attribute name="Deployer">J2EE:service=J2eeDeployer</attribute>
> <attribute name="URLs">../deploy</attribute>
> </mbean>
>
> <!-- J2EE connector architecture -->
> <mbean code="org.jboss.resource.RARDeployer"
> name="JCA:service=RARDeployer">
> </mbean>
>
> <!-- Minerva no transaction connection manager factory.
>
> Use this for resource adapters that don't support
> transactions. -->
> <mbean code="org.jboss.resource.ConnectionManagerFactoryLoader"
>
> name="JCA:service=ConnectionManagerFactoryLoader,name=MinervaN
> oTransCMFactor
> y">
> <attribute name="FactoryName">MinervaNoTransCMFactory</attribute>
> <attribute
> name="FactoryClass">org.opentools.minerva.connector.jboss.Mine
> rvaNoTransCMFa
> ctory</attribute>
> <attribute name="Properties"></attribute>
> </mbean>
>
> <!-- Minerva local transaction connection manager factory.
>
> Use this for resource adapters that support "local"
> transactions. -->
> <mbean code="org.jboss.resource.ConnectionManagerFactoryLoader"
>
> name="JCA:service=ConnectionManagerFactoryLoader,name=MinervaS
> haredLocalCMFa
> ctory">
> <attribute
> name="FactoryName">MinervaSharedLocalCMFactory</attribute>
> <attribute
> name="FactoryClass">org.opentools.minerva.connector.jboss.Mine
> rvaSharedLocal
> CMFactory</attribute>
> <attribute name="Properties"></attribute>
> </mbean>
>
> <!-- Minerva XA transaction connection manager factory
>
> Use this for resource adapters that support "xa"
> transactions. -->
> <mbean code="org.jboss.resource.ConnectionManagerFactoryLoader"
>
> name="JCA:service=ConnectionManagerFactoryLoader,name=MinervaX
> ACMFactory">
> <attribute name="FactoryName">MinervaXACMFactory</attribute>
> <attribute
> name="FactoryClass">org.opentools.minerva.connector.jboss.Mine
> rvaXACMFactory
> </attribute>
> <attribute name="Properties"></attribute>
> </mbean>
>
> <!-- Example connection factory for the example "Black Box" resource
> adapter. This points at the same database as DefaultDS. -->
> <mbean code="org.jboss.resource.ConnectionFactoryLoader"
> name="JCA:service=ConnectionFactoryLoader,name=BlackBoxDS">
> <attribute name="FactoryName">BlackBoxDS</attribute>
> <attribute
> name="RARDeployerName">JCA:service=RARDeployer</attribute>
> <attribute name="ResourceAdapterName">Black Box LocalTx
> Adapter</attribute>
> <attribute name="Properties">
> ConnectionURL=jdbc:HypersonicSQL:hsql://localhost:1476
> </attribute>
>
> <attribute
> name="ConnectionManagerFactoryName">MinervaSharedLocalCMFactor
> y</attribute>
> <!-- See the documentation for the specific connection manager
> implementation you are using for the properties you
> can set -->
> <attribute name="ConnectionManagerProperties">
> # Pool type - uncomment to force, otherwise it is the default
> #PoolConfiguration=per-factory
>
> # Connection pooling properties - see
> # org.opentools.minerva.pool.PoolParameters
> MinSize=0
> MaxSize=10
> Blocking=true
> GCEnabled=false
> IdleTimeoutEnabled=false
> InvalidateOnError=false
> TrackLastUsed=false
> GCIntervalMillis=120000
> GCMinIdleMillis=1200000
> IdleTimeoutMillis=1800000
> MaxIdleTimeoutPercent=1.0
> </attribute>
>
> <!-- Principal mapping configuration -->
> <attribute
> name="PrincipalMappingClass">org.jboss.resource.security.ManyT
> oOnePrincipalM
> apping</attribute>
> <attribute name="PrincipalMappingProperties">
> userName=sa
> password=
> </attribute>
> </mbean>
>
> <!-- This is an example of using a resource adapter that supports XA
> transactions. The Black Box XA resource adapter requires an
> XADataSource to be in JNDI somewhere. JBoss doesn't include a
> database with an XA-compliant JDBC driver, so this will need to
> be configured to use whatever XADataSource implementation you
> have.
>
> <mbean code="org.jboss.jdbc.RawXADataSourceLoader"
>
> name="DefaultDomain:service=RawXADataSourceLoader,name=BlackBoxXADS">
> <attribute name="PoolName">BlackBoxXADS</attribute>
> <attribute name="DataSourceClass">Put your XADataSource
> implementation
> class here</attribute>
> <attribute name="Properties"></attribute>
> </mbean>
>
> <mbean code="org.jboss.resource.ConnectionFactoryLoader"
> name="JCA:service=ConnectionFactoryLoader,name=XABlackBoxDS">
> <attribute name="FactoryName">XABlackBoxDS</attribute>
> <attribute
> name="RARDeployerName">JCA:service=RARDeployer</attribute>
> <attribute name="ResourceAdapterName">Black Box XA
> Adapter</attribute>
> <attribute name="Properties">
> XADataSourceName=java:/BlackBoxXADS
> </attribute>
>
> <attribute
> name="ConnectionManagerFactoryName">MinervaXACMFactory</attribute>
> <attribute name="ConnectionManagerProperties">
> # Pool type - uncomment to force, otherwise it is the default
> #PoolConfiguration=per-factory
>
> # Connection pooling properties - see
> # org.opentools.minerva.pool.PoolParameters
> MinSize=0
> MaxSize=10
> Blocking=true
> GCEnabled=false
> IdleTimeoutEnabled=false
> InvalidateOnError=false
> TrackLastUsed=false
> GCIntervalMillis=120000
> GCMinIdleMillis=1200000
> IdleTimeoutMillis=1800000
> MaxIdleTimeoutPercent=1.0
> </attribute>
>
> <attribute
> name="PrincipalMappingClass">org.jboss.resource.security.ManyT
> oOnePrincipalM
> apping</attribute>
> <attribute name="PrincipalMappingProperties">
> userName=sa
> password=
> </attribute>
> </mbean>
> -->
>
> <!-- JMX adaptors -->
> <mbean code="org.jboss.jmx.server.JMXAdaptorService"
> name="Adaptor:name=RMI" />
>
> <mbean code="org.jboss.jmx.server.RMIConnectorService"
> name="Connector:name=RMI" />
>
> <mbean code="com.sun.jdmk.comm.HtmlAdaptorServer"
> name="Adaptor:name=html">
> <attribute name="MaxActiveClientCount">10</attribute>
> <attribute name="Parser" />
> <attribute name="Port">8082</attribute>
> </mbean>
>
> <!-- Mail Connection Factory -->
> <mbean code="org.jboss.mail.MailService" name=":service=Mail">
> <attribute name="JNDIName">Mail</attribute>
> <attribute name="ConfigurationFile">mail.properties</attribute>
> <attribute name="User">user_id</attribute>
> <attribute name="Password">password</attribute>
> </mbean>
>
> <!-- Uncomment to enable JMX monitoring of the bean cache
> <mbean code="org.jboss.monitor.BeanCacheMonitor"
> name="Monitor:name=BeanCacheMonitor"/>
> -->
>
> <!-- Add your custom MBeans here -->
>
> </server>
>
>
>
> THIS IS THE LOG FILE
>
>
> 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
> [JAAS Security Manager] Initializing
> [JAAS Security Manager] Initialized
> [JDBC provider] Initializing
> [JDBC provider] Loaded JDBC-driver:org.hsql.jdbcDriver
> [JDBC provider] Loaded
> JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
> [JDBC provider] Loaded JDBC-driver:org.postgresql.Driver
> [JDBC provider] Initialized
> [Hypersonic] Initializing
> [Hypersonic] Initialized
> [InstantDB] Initializing
> [InstantDB] Initialized
> [DefaultDS] Initializing
> [DefaultDS] Initialized
> [PostgresDB] Initializing
> [PostgresDB] Initialized
> [Container factory] Initializing
> [Container factory] Initialized
> [JBossMQ] Initializing
> [JBossMQ] Initialized
> [DefaultJMSProvider] Initializing
> [DefaultJMSProvider] Initialized
> [StdJMSPool] Initializing
> [StdJMSPool] Initialized
> [J2EE Deployer Default] Initializing
> [J2EE Deployer Default] Initialized
> [Auto deploy] Initializing
> [Auto deploy] Initialized
> [RARDeployer] Initializing
> [RARDeployer] Initialized
> [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.SubjectSecurityProxyFa
> ctory@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 <java.home>/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.SMTP
> Transport,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 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:
> > > >
> > > > <mbean code="org.jboss.jdbc.XADataSourceLoader"
> > > > name="DefaultDomain:service=XADataSource,name=jdbc/PostgresDB">
> > > > <attribute name="PoolName">jdbc/PostgresDB</attribute>
> > > >
> > > > instead of
> > > >
> > > > <mbean code="org.jboss.jdbc.XADataSourceLoader"
> > > > name="DefaultDomain:service=XADataSource,name=PostgreSQL">
> > > > <attribute name="PoolName">jdbc/PostgresDB</attribute>
> > > >
> > > > 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?
> > > >
> > > > <mbean code="org.jboss.jdbc.XADataSourceLoader"
> > > > name="DefaultDomain:service=XADataSource,name=PostgreSQL">
> > > > <attribute name="PoolName">jdbc/PostgresDB</attribute>
> > > > <attribute
> > > >
> >
> name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.X
> ADataSourc
> > > > eImp
> > > > l</attribute>
> > > > <attribute name="Properties"></attribute>
> > > > <attribute
> > > > name="URL">jdbc:postgresql://localhost:5432/ejb</attribute>
> > > > <attribute name="GCMinIdleTime">1200000</attribute>
> > > > <attribute name="JDBCUser">ejbUser</attribute>
> > > > <attribute name="MaxSize">10</attribute>
> > > > <attribute name="Password">ejbUserPassword</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-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
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
jboss.jcml
jboss.conf