John,
Got a reply saying "mail to long" - here the mail (see below) without
standardjaws.xml attached, only the relevant changed bits:
<datasource>PostgresDB</datasource>
<type-mapping>PostgreSQL</type-mapping>
<!--
<datasource>java:/DefaultDS</datasource>
<type-mapping>Hypersonic SQL</type-mapping>
-->
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
>
> <jboss>
>
> <resource-managers>
> <resource-manager
> res-class="org.jboss.ejb.deployment.JDBCResource">
> <res-name>FOOBAR</res-name>
> <res-jndi-name>java:/PostgresDB</res-jndi-name>
> </resource-manager>
> </resource-managers>
>
> and then in the same file something like
>
> <enterprise-beans>
>
> <entity>
> <ejb-name>SomeBeanName</ejb-name>
> <resource-ref>
> <res-ref-name>ResourceRefName</res-ref-name>
> <resource-name>FOOBAR</resource-name>
> </resource-ref>
> </entity>
>
> 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
> > [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.
> >
> >
> > <?xml version="1.0" encoding="UTF-8"?>
> > <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>
> >
> > <!-- JDBC -->
> > <mbean code="org.jboss.jdbc.JdbcProvider"
> > name="DefaultDomain:service=JdbcProvider">
> > <attribute name="Drivers">org.postgresql.Driver</attribute>
> > </mbean>
> >
> > <mbean code="org.jboss.jdbc.XADataSourceLoader"
> > name="DefaultDomain:service=XADataSource,name=PostgresDB">
> > <attribute name="Properties"></attribute>
> > <attribute name="PoolName">PostgresDB</attribute>
> > <attribute
> > name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.X
> > ADataSourceImp
> > l</attribute>
> > <attribute
> > name="URL">jdbc:postgresql://192.168.0.2/ejb</attribute>
> > <attribute name="GCMinIdleTime">1200000</attribute>
> > <attribute name="JDBCUser">postgres</attribute>
> > <attribute name="MaxSize">20</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">true</attribute>
> > <attribute name="LoggingEnabled">true</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>
> >
> >
> > <!-- 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>
> > </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 -->
> >
> > <!-- 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>
> >
> > <!-- 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>
> >
> > <!-- Add your custom MBeans here -->
> >
> > </server>
> >
> >
> >
> >
> > _______________________________________________
> > 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