I'd like to verify the URL line, maybe this is my problem. I noticed that
the name url in this post was a little different.
This is the jdbc url I use to connect to my datasource ...
"jdbc:postgresql:acais://localhost:5432". The same url used in the dbURL of
this portion of code.
public Connection getConnection() throws SQLException {
return DriverManager.getConnection(dbURL, "myUser", "myPasswd");
}
So my lines in the <mbean>'s of jboss.jcml look like this.
<attribute name="URL">jdbc:postgresql:acais://localhost:5432</attribute>
5432 is the port in my /etc/services file of postgres. acais is the name of
the dbase in postgres. It all works, it's just very slow.
-----
When the code below executes, it goes very quickly as it runs through the
method, the the next time this method get's called ... there's a pause
before it executes. I'm sure the code is fine, I beleive it's still a config
problem. It has worked fine on other servers. Otherwise the result sets get
returned very quickly. It's just there's a long pause as if it's trying to
find the dbase for some reason and not accepting the config.
...
try {
dbConn = getConnection();
stmt = dbConn.createStatement();
String query = "SELECT shell FROM Shells WHERE platform_id = "
+ platform;
System.out.println("query = " + query);
ResultSet rs = stmt.executeQuery(query);
int cnt = 0;
while (rs.next()) {
shells.put(new Integer(++cnt), rs.getString("shell"));
}
}
----- Original Message -----
From: "Robert Schulz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 1:38 AM
Subject: RE: [JBoss-user] dbase is acting way too slow
>
> 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
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
