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
