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

Reply via email to