Now I am getting confused again. I do not see any jboss.jcml files in
~/tomcat/conf/default nor do I see anywheres in the docs that state this.
I had put my ~/jboss/conf/default/jboss.jcml into ~/tomcat/conf/default, and
got those previous results, and did not delete my old
~/jboss/conf/default/jboss.jcml file, but not sure what's correct.
So what set of ~/tomcat/conf files are we talking about?
Thnxs.
----- Original Message -----
From: "Burkhard Vogel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 10:17 AM
Subject: Re: [JBoss-user] dbase is acting way too slow
> Hi,
> still you are completly misconfigured, I really wonder how it works
> anyhow...
> Frist:
> The jboss.jcml is not real xml, so comments won't allways work as
expected,
> to be sure, make a backup-copy of the vanilla config-file and DELETE
> anything you don't want.
> Second:
> Make sure you are editing the right set of config-files. From you output:
> > [EmbeddedTomcatServiceSX] Initialized
> i guess you do a run_with_tomcat to start the server which means you need
to
> change the conf/tomcat files!
> Third:
> What you need to do in order to use the postgres DB through the Jboss
> DB-pooling system.
> a) Copy your driver jar into the lib/ext dir of jboss.
> b) include yourdriver in the JdbcProvider section:
> > <mbean code="org.jboss.jdbc.JdbcProvider"
> name="DefaultDomain:service=JdbcProvider">
> > <attribute name="Drivers">org.postgresql.Driver</attribute>
> > </mbean>
> looks ok, but MUST give you an output during startup:
> > [JdbcProvider] Loaded JDBC-driver:org.postgresql.Driver
> and nothing else! No
> > [JdbcProvider] Loaded JDBC-driver:org.hsql.jdbcDriver
> > [JdbcProvider] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
> If you get these delete jboss-auto.jcml.
> c) Set up your pool:
> There should always be some DefaultDS:
>
> <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.XADataSourceImp
> l</attribute>
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc:postgresql://YOUR_SERVER_HERE/YOUR_DATABASE</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">YOUR_USER</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password">YOUR_PASSWORD</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>
>
> <mbean code="org.jboss.jdbc.XADataSourceLoader"
> name="DefaultDomain:service=XADataSource,name=PostgresqlDB">
> <attribute name="PoolName">PostgresqlDB</attribute>
> <attribute
>
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
> l</attribute>
> <attribute
> name="URL">jdbc:postgresql://YOUR_SERVER_HERE/YOUR_DATABASE</attribute>
> <attribute name="JDBCUser">YOUR_USER</attribute>
> <attribute name="Password">YOUR_PASSWORD</attribute>
> <attribute name="MinSize">0</attribute>
> <attribute name="MaxSize">50</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCEnabled">false</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="GCInterval">120000</attribute>
> <attribute name="IdleTimeoutEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
> <attribute name="IdleTimeout">1800000</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> </mbean>
> Should give you the following output during startup:
> [DefaultDS] Starting
> [DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
> [DefaultDS] Started
> [PostgresqlDB] Starting
> [PostgresqlDB] XA Connection pool PostgresqlDBbound to java:/PostgresqlDB
> [PostgresqlDB] Started
> Now you have a XA Connection pool which can be looked up which new
> InitialContext.lookup(java:/PostgresqlDB). This is however not portable
and
> you should use jboss.xml as a server-specific deployment descritor to map
> this resource to jdbc/YourNameHere, as described in chapter 6 of the
> documentation. All the above is chapter 3 of the documentation.
> Burkhard
>
>
> ----- Original Message -----
> From: "G.L. Grobe" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, July 16, 2001 8:07 AM
> Subject: Re: [JBoss-user] dbase is acting way too slow
>
>
> > Ok, I've found a few mis-configurations problems in my jboss.jcml, but
> after
> > fixing them and now that I understand it a bit more, they still don't
seem
> > to be taking. My postgresql database still works, but is very, very,
very
> > slow.
> >
> > --- jboss.jcml -----------------------------------
> > <!--
> > ==================================================================== -->
> > <!--
> > -->
> > <!--
> > ==================================================================== -->
> >
> > <mbean code="org.jboss.jdbc.JdbcProvider"
> > name="DefaultDomain:service=JdbcProvider">
> > <attribute name="Drivers">org.postgresql.Driver</attribute>
> > </mbean>
> >
> > <!-- mbean code="org.jboss.jdbc.JdbcProvider"
> > name="DefaultDomain:service=JdbcProvider">
> > <attribute
> >
>
name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver</att
> > ribute>
> > </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.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
> > ibute>
> > <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.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
> > ibute>
> > <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>
> >
> > --- jboss output ----------------------------
> > cassia(build):/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/bin$
> > ./run_with_tomcat.sh
> >
JBOSS_CLASSPATH=:/u/public/jdk1.3/lib/tools.jar:run.jar:../lib/crimson.jar
> > jboss.home = /u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss
> > Using JAAS LoginConfig:
> > file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/conf/tomcat/auth.conf
> > Using configuration "tomcat"
> > [root] Started Log4jService,
> >
>
config=file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/conf/tomcat/log4j.prope
> > rties
> > [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.4.4,i386
> > [Shutdown] Shutdown hook added
> > [Service Control] Initializing 28 MBeans
> > [WebService] Initializing
> > [WebService] Initialized
> > [NamingService] Initializing
> > [NamingService] Initialized
> > [JNDIView] Initializing
> > [JNDIView] Initialized
> > [TransactionManagerService] Initializing
> > [TransactionManagerService] Initialized
> > [ClientUserTransactionService] Initializing
> > [ClientUserTransactionService] Initialized
> > [JaasSecurityManagerService] Initializing
> > [JaasSecurityManagerService] Initialized
> > [JdbcProvider] Initializing
> > [JdbcProvider] Loaded JDBC-driver:org.hsql.jdbcDriver
> > [JdbcProvider] Loaded JDBC-driver:org.enhydra.instantdb.jdbc.idbDriver
> > [JdbcProvider] Initialized
> > [HypersonicDatabase] Initializing
> > [HypersonicDatabase] Initialized
> > [XADataSourceLoader] Initializing
> > [XADataSourceLoader] Initialized
> > [XADataSourceLoader] Initializing
> > [XADataSourceLoader] Initialized
> > [ServerDataCollector] Initializing
> > [ServerDataCollector] Initialized
> > [ContainerFactory] Initializing
> > [ContainerFactory] Initialized
> > [EmbeddedTomcatServiceSX] Initializing
> > [EmbeddedTomcatServiceSX] Initialized
> > [JBossMQService] Initializing
> >
> >
> >
> > _______________________________________________
> > 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
