Not sure whether this helps, here is our conf, the relevant section is
<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=DefaultDS">
<attribute name="PoolName">PostgresDB</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:postgresql://127.0.0.1/WMS</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">notTelling</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">notTelling</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">true</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
Your url "jdbc:postgresql:acais://localhost:5432" is different ... if this
does not
cut it, run jboss without tomcat and see how this works. I am not really an
expert
with this, as it "just worked" for us ;-)
R.
PS> Here our full conf - (jboss2.2.2, postgres 7.1.2, Linux 2.4.2-2
(standard RH7.1), Sun JDK1.3.1)
JBOSS.CONF
<MLET CODE = "org.jboss.logging.Logger" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
</MLET>
<MLET CODE = "org.jboss.util.ClassPathExtension" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="../../log/">
</MLET>
<MLET CODE = "org.jboss.util.ClassPathExtension" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="./">
</MLET>
<MLET CODE = "org.jboss.logging.ConsoleLogging" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="Information,Debug,Warning,Error">
<ARG TYPE="java.lang.String" VALUE="[{2}] {4}">
</MLET>
<MLET CODE = "org.jboss.util.Info" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
</MLET>
<MLET CODE = "org.jboss.util.ClassPathExtension" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="../../tmp/">
</MLET>
<MLET CODE = "org.jboss.util.ClassPathExtension" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
<ARG TYPE="java.lang.String" VALUE="../../db/">
</MLET>
<MLET CODE = "org.jboss.configuration.ConfigurationService"
ARCHIVE="jboss.jar,../xml.jar" CODEBASE="../../lib/ext/">
</MLET>
<MLET CODE = "org.jboss.util.Shutdown" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
</MLET>
<MLET CODE = "org.jboss.util.ServiceControl" ARCHIVE="jboss.jar"
CODEBASE="../../lib/ext/">
</MLET>
JBOSS.JCML
<?xml version="1.0" encoding="UTF-8"?>
<server>
<mbean code="org.jboss.web.WebService"
name="DefaultDomain:service=Webserver">
<attribute name="Port">8083</attribute>
</mbean>
<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" />
<mbean code="org.jboss.tm.TransactionManagerService"
name="DefaultDomain:service=TransactionManager">
<attribute name="TransactionTimeout">300</attribute>
</mbean>
<mbean code="org.jboss.security.plugins.JaasSecurityManagerService"
name="Security:name=JaasSecurityManager">
<attribute
name="SecurityManagerClassName">org.jboss.security.plugins.JaasSecurityManag
er</attribute>
</mbean>
.. jdbc stuff here, see above ...
<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>
<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>
<mbean code="org.jboss.resource.RARDeployer"
name="JCA:service=RARDeployer">
</mbean>
<mbean code="org.jboss.resource.ConnectionManagerFactoryLoader"
name="JCA:service=ConnectionManagerFactoryLoader,name=MinervaXACMFactory">
<attribute name="FactoryName">MinervaXACMFactory</attribute>
<attribute name="FactoryClass">
org.opentools.minerva.connector.jboss.MinervaXACMFactory
</attribute>
<attribute name="Properties"></attribute>
</mbean>
<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>
<mbean code="fw.util.gc.mbean.GC" name="DefaultDomain:service=GCMonitor">
<attribute name="PauseBetweenGC">30</attribute>
</mbean>
</server>
-----Original Message-----
From: G.L. Grobe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 3:45 PM
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-user] dbase is acting way too slow
Oh yeah, psql works just fine. And the same queries from psql are
sub-second. It's on the same box. I also use the 2.4.4 kernel. I'm sure it's
definately a config issue that I've got wrong somewheres, but I see nothing
wrong, of course, how would I know, heh ... it's my first time w/ JBoss and
I've still got queues to figure out after this. I had this same
configuration on Orion server so I know the code is fine.
----- Original Message -----
From: "Robert Schulz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 16, 2001 11:37 PM
Subject: RE: [JBoss-user] dbase is acting way too slow
> Have you tried connecting using psql?
> What happens when you run the same queries?
>
> How do you connect to the database? Maybe
> your networking is stuffed ... is it on
> the same box? Try pinging ...
>
> We use postgres against jboss (standalone, no tomcat)
> and Linux 2.4 and it works like a dream (we did some
> very superficial speed comparison against oracle and
> the performance for our type of app was about the same)
> and we have tables up to 500,000 rows ... the queries
> we have are not particularly complex though.
>
> The select you describe should be around 10-20ms
> or so ...
>
> R.
>
> -----Original Message-----
> From: G.L. Grobe [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 17, 2001 11:31 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] dbase is acting way too slow
>
>
> Well, seems I've finally got the database configured correctly, at least
it
> starts w/o any errors. But I'm still getting my same original behavior.
The
> problem I started to try and fix.
>
> My dbase queries are extremely slow, but they work. I'm doing a query
> through *7* records in a table w/ only 5 fields and it literally takes
10-20
> seconds for each query (that's 10-20 seconds for a 'select * from
mytable').
> I get the result sets back ok, but as I print out each query, just takes
> waay too long.
>
> As usual, thnxs for all the help.
>
> --- 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 27 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.postgresql.Driver
> [JdbcProvider] Initialized
> [XADataSourceLoader] Initializing
> [XADataSourceLoader] Initialized
> [XADataSourceLoader] Initializing
> [XADataSourceLoader] Initialized
> [ServerDataCollector] Initializing
> [ServerDataCollector] Initialized
> [ContainerFactory] Initializing
> [ContainerFactory] Initialized
> [EmbeddedTomcatServiceSX] Initializing
> [EmbeddedTomcatServiceSX] Initialized
> [JBossMQService] Initializing
> [JBossMQService] Initialized
> [JMSProviderLoader] Initializing
> [Default] queue factory name: XAQueueConnectionFactory
> [Default] topic factory name: XATopicConnectionFactory
> [JMSProviderLoader] Initialized
> [ServerSessionPoolLoader] Initializing
> [ServerSessionPoolLoader] Initialized
> [J2eeDeployer] Initializing
> [J2eeDeployer] Initialized
> [RARDeployer] Initializing
> [RARDeployer] Initialized
> [ConnectionManagerFactoryLoader] Initializing
> [ConnectionManagerFactoryLoader] Initialized
> [ConnectionManagerFactoryLoader] Initializing
> [ConnectionManagerFactoryLoader] Initialized
> [ConnectionManagerFactoryLoader] Initializing
> [ConnectionManagerFactoryLoader] Initialized
> [ConnectionFactoryLoader] Initializing
> [ConnectionFactoryLoader] Initialized
> [ConnectionFactoryLoader] Initializing
> [ConnectionFactoryLoader] Initialized
> [AutoDeployer] Initializing
> [AutoDeployer] Initialized
> [JMXAdaptorService] Initializing
> [JMXAdaptorService] Initialized
> [RMIConnectorService] Initializing
> [RMIConnectorService] Initialized
> [MailService] Initializing
> [MailService] Initialized
> [Service Control] Initialized 27 services
> [Service Control] Starting 27 MBeans
> [WebService] Starting
> [Default] Started on port 8083
> [Webserver] Codebase set to http://cassia:8083/
> [Webserver] Started webserver on port 8083
> [WebService] Started
> [NamingService] Starting
> [NamingService] Starting jnp server
> [NamingService] Started jnpPort=1099, rmiPort=0, Client
SocketFactory=null,
> Server SocketFactory=null
> [NamingService] InitialContext Environment:
> [NamingService] key=java.naming.factory.initial,
> value=org.jnp.interfaces.NamingContextFactory
> [NamingService] key=java.naming.factory.url.pkgs,
>
value=org.jboss.naming:org.jnp.interfaces:org.jboss.naming:org.jnp.interface
> s
> [NamingService] Naming started on port 1099
> [NamingService] Started
> [JNDIView] Starting
> [JNDIView] Started
> [TransactionManagerService] Starting
> [TransactionManagerService] Started
> [ClientUserTransactionService] Starting
> [ClientUserTransactionService] Started
> [JaasSecurityManagerService] Starting
> [Default] JAAS.startService, cachePolicy=null
> [Default] JAAS.startService,
> SecurityProxyFactory=org.jboss.security.SubjectSecurityProxyFactory@687719
> [JaasSecurityManagerService] Started
> [JdbcProvider] Starting
> [JdbcProvider] Started
> [XADataSourceLoader] Starting
> [DefaultDS] XA Connection pool DefaultDS bound to java:/DefaultDS
> [XADataSourceLoader] Started
> [XADataSourceLoader] Starting
> [PostgresqlDB] XA Connection pool PostgresqlDB bound to java:/PostgresqlDB
> [XADataSourceLoader] Started
> [ServerDataCollector] Starting
> [ServerDataCollector] JBoss Management Service 'servercollector' bound to
> servercollector
> [ServerDataCollector] Started
> [ContainerFactory] Starting
> [ContainerFactory] Started
> [EmbeddedTomcatServiceSX] Starting
> [EmbeddedTomcatSX] Starting EmbeddedTomcatSX....
> [Default] Starting tomcat. Check logs/tomcat.log for error messages
> [EmbeddedTomcatSX] OK
> [EmbeddedTomcatServiceSX] Started
> [JBossMQService] Starting
> [Default] Server Version 0.8 Started
> [JBossMQService] Started
> [JMSProviderLoader] Starting
> [JMSProviderLoader] JMS provider Adapter DefaultJMSProvider bound to
> java:/DefaultJMSProvider
> [JMSProviderLoader] Started
> [ServerSessionPoolLoader] Starting
> [ServerSessionPoolLoader] JMS provider Adapter StdJMSPool bound to
> java:/StdJMSPool
> [ServerSessionPoolLoader] Started
> [J2eeDeployer] Starting
> [J2EE Deployer Default] Cleaning up deployment directory
> [J2eeDeployer] Started
> [RARDeployer] Starting
> [RARDeployer] Started
> [ConnectionManagerFactoryLoader] Starting
> [MinervaNoTransCMFactory] Connection manager factory
> 'MinervaNoTransCMFactory bound to 'java:/MinervaNoTransCMFactory'
> [ConnectionManagerFactoryLoader] Started
> [ConnectionManagerFactoryLoader] Starting
> [MinervaSharedLocalCMFactory] Connection manager factory
> 'MinervaSharedLocalCMFactory bound to 'java:/MinervaSharedLocalCMFactory'
> [ConnectionManagerFactoryLoader] Started
> [ConnectionManagerFactoryLoader] Starting
> [MinervaXACMFactory] Connection manager factory 'MinervaXACMFactory bound
to
> 'java:/MinervaXACMFactory'
> [ConnectionManagerFactoryLoader] Started
> [ConnectionFactoryLoader] Starting
> [ConnectionFactoryLoader] Started
> [ConnectionFactoryLoader] Starting
> [ConnectionFactoryLoader] Started
> [AutoDeployer] Starting
> [AutoDeployer] Watching /u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy
> [AutoDeployer] Watching
/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/lib
> [AutoDeployer] Auto deploy of
> file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/tomcat-test.ear
> [J2EE Deployer Default] Deploy J2EE application:
> file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/tomcat-test.ear
> [J2EE Deployer Default] Create application tomcat-test.ear
> [J2EE Deployer Default] inflate and install module tomcat-test.war
> [J2EE Deployer Default] install module tomcat-test.jar
> [J2EE Deployer Default] add all ejb jar files to the common classpath
> [Container factory]
>
Deploying:file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/t
> omcat-test.ear
> [Verifier] Verifying
>
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/tomcat-test
> .ear/ejb1002.jar
> [Container factory] Deploying Optimized
> [Container factory] Deploying NonOptimized
> [ContainerManagement] Initializing
> [ContainerManagement] Initialized
> [ContainerManagement] Starting
> [ContainerManagement] Started
> [ContainerManagement] Initializing
> [ContainerManagement] Initialized
> [ContainerManagement] Starting
> [ContainerManagement] Started
> [Default] Added ClassLoader: org.jboss.web.WebClassLoader@c3679 URL:
> http://cassia:8083/WebClassLoader@800377/
> [Container factory] Deployed application:
>
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/tomcat-test
> .ear
> [J2EE Deployer Default] Starting module tomcat-test.war
> [EmbeddedTomcatSX] deploy, ctxPath=/jboss,
>
warUrl=file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/tomc
> at-test.ear/web1001/
> [J2EE Deployer Default] J2EE application:
> file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/tomcat-test.ear is
> deployed.
> [AutoDeployer] Auto deploy of
> file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/acais-1.0.ear
> [J2EE Deployer Default] Deploy J2EE application:
> file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/acais-1.0.ear
> [J2EE Deployer Default] Create application acais-1.0.ear
> [J2EE Deployer Default] inflate and install module acais-web.war
> [J2EE Deployer Default] install module acais-ejb.jar
> [J2EE Deployer Default] add all ejb jar files to the common classpath
> [Container factory]
>
Deploying:file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/a
> cais-1.0.ear
> [Verifier] Verifying
>
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/acais-1.0.e
> ar/ejb1004.jar
> [Container factory] Deploying Account
> [Container factory] Deploying DBaseListMaps
> [Default] null
> [Container factory] No resource manager found for jms/managerQueue
> [Container factory] No resource manager found for
jms/QueueConnectionFactory
> [Default] null
> [Bean Cache] Cache policy scheduler started
> [ContainerManagement] Initializing
> [ContainerManagement] Initialized
> [ContainerManagement] Starting
> [ContainerManagement] Started
> [ContainerManagement] Initializing
> [ContainerManagement] Initialized
> [ContainerManagement] Starting
> [ContainerManagement] Started
> [ContainerManagement] Initializing
> [ContainerManagement] Initialized
> [ContainerManagement] Starting
> [ContainerManagement] Started
> [ContainerManagement] Initializing
> [ContainerManagement] Initialized
> [ContainerManagement] Starting
> [ContainerManagement] Started
> [ContainerManagement] Initializing
> [ContainerManagement] Initialized
> [ContainerManagement] Starting
> [ContainerManagement] Started
> [ContainerManagement] Initializing
> [ContainerManagement] Initialized
> [ContainerManagement] Starting
> [ContainerManagement] Started
> [Default] Added ClassLoader: org.jboss.web.WebClassLoader@52c6b4 URL:
> http://cassia:8083/WebClassLoader@5424820/
> [Container factory] Deployed application:
>
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/acais-1.0.e
> ar
> [J2EE Deployer Default] Starting module acais-web.war
> [EmbeddedTomcatSX] deploy, ctxPath=/acais,
>
warUrl=file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/tmp/deploy/Default/acai
> s-1.0.ear/web1003/
> [J2EE Deployer Default] J2EE application:
> file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/acais-1.0.ear is
> deployed.
> [AutoDeployer] Auto deploy of
> file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/lib/jms-ra.rar
> [RARDeployer] Attempting to deploy RAR at
> 'file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/lib/jms-ra.rar'
> [JmsXA] Using default value 'java:DefaultJMSProvider' for config property
> 'JmsProviderAdapterJNDI'
> [JmsXA] FINE: Setting LogWriter: org.jboss.logging.LogWriter@406258
> [JmsXA] Bound connection factory for resource adapter 'JMS Adapter' to
JNDI
> name 'java:/JmsXA'
> [AutoDeployer] Auto deploy of
>
file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/lib/jbosspool-jdbc.rar
> [RARDeployer] Attempting to deploy RAR at
>
'file:/u/public/JBoss-2.4.0_Tomcat-3.2.2/jboss/deploy/lib/jbosspool-jdbc.rar
> '
> [RARDeployer] Loading Minerva Resource Adapter for JDBC 1/2 drivers
> [RARDeployer] Required license terms present. See deployment descriptor.
> [MinervaDS] Not setting config property 'Driver'
> [MinervaDS] Not setting config property 'Password'
> [MinervaDS] Not setting config property 'UserName'
> [MinervaDS] Bound connection factory for resource adapter 'Minerva JDBC
> LocalTransaction ResourceAdapter' to JNDI name 'java:/MinervaDS'
> [AutoDeployer] Started
> [JMXAdaptorService] Starting
> [JMXAdaptorService] Started
> [RMIConnectorService] Starting
> [RMIConnectorService] Started
> [MailService] Starting
> [MailService] Mail Service 'Mail' bound to java:/Mail
> [MailService] Started
> [Service Control] Started 27 services
> [Default] JBoss 2.4 BETA(Rel_2_4_0_6) Started in 0m:35s
>
> --- ~/jboss/conf/tomcat/jboss.jcml (JDBC section) ----------------
> <!--
> ==================================================================== -->
> <!--
> -->
> <!--
> ==================================================================== -->
>
> <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=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:postgresql:acais://localhost:5432</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">MyUser</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password">MyPasswd</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.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr
> ibute>
> <attribute name="Properties"></attribute>
> <attribute
name="URL">jdbc:postgresql:acais://localhost:5432</attribute>
> <attribute name="GCMinIdleTime">1200000</attribute>
> <attribute name="JDBCUser">MyUser</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password">MyPasswd</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
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
