The pings report back fine to localhost and cassia (the node w/ jboss and my
enterprise app), acais is just my context name to the webapp. Everything on
my network is normal in this respect.
I think the problem still lies somewheres in my configuration of the
DataSource's.
----- Original Message -----
From: "Sacha Labourey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 27, 2001 1:22 AM
Subject: RE: [JBoss-user] dbase is acting way to slow
> Hello,
>
> This is most probably out of topic but, what happens if you try to ping
> these hosts: localhost, acais, cassia (with these exact spelling and by
not
> using their IP addresses.)
>
> Just to check that you do not have a resolver issue (as you say that your
> lookups are also slow).
>
> Cheers,
>
>
> Sacha
>
>
> -----Message d'origine-----
> De : [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]De la part de G.L. Grobe
> Envoyé : vendredi, 27 juillet 2001 08:04
> À : [EMAIL PROTECTED]
> Objet : [JBoss-user] dbase is acting way to slow
>
>
> Some new information.
>
> My problem has been that my dbase queries are extremely slow, but they
work.
> A query through 10 records in a table w/ only 5 fields (extremely simple
sql
> stuff) takes 10-20 seconds. The lookup()'s to the datasource are also
slow.
> Upon run_with_tomcat.sh, I see the following output from jboss ... (I went
> ahead and included all the output at the end of this post).
> ----------
> [JdbcProvider] Initializing
> [JdbcProvider] Loaded JDBC-driver:org.postgresql.Driver
> [JdbcProvider] Initialized
> ...
> [PostgresqlDB] XA Connection pool PostgresqlDB bound to java:/PostgresqlDB
>
>
> There are no errors or exceptions in my startup.
>
> 1. I pulled the PostgresqlDB <mbean... resource (below) out of my
> ~/conf/tomcat/jboss.jcml file. I'm using the postgresql dbase. When I did
> this, I got exactly the same behavior, but my queries were still working.
>
> 2. Then I pulled the DefaultDS out of the jboss.jcml, and it took just as
> long, same behavior, except exceptions were being thrown and no data was
> returned. Note that at this point there were no dbase resources in my
> jboss.jcml.
>
> 3. Then the below resource (PostgresqlDB) was added back into the
jboss.jcml
> so that it was the only DB resource in jboss.jcml and I got the same
> behavior as if (in step 2 above) there were no resources in the
jboss.jcml.
>
> Conclusion:
> So my guess is that my current configuration is still not correct as I
don't
> think my PostgresqlDB <mbean ... was/is ever being used (although, like
the
> above output, it seems to be accepted by jboss w/o problems) and long time
> delays are because of it having to use the DefaultDS instead of the one
I've
> config'd it to use.
>
> Any help much appreciated.
>
> -----------
> <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">build</attribute>
> <attribute name="MaxSize">10</attribute>
> <attribute name="Password">build</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>
>
> Here is my 'run_with_tomcat.sh' jboss output. This output is from running
> with the PostgresqlDB only resource in the jboss.jcml.
> ------------
> 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 26 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
> [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 26 services
> [Service Control] Starting 26 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@64c34e
> [JaasSecurityManagerService] Started
> [JdbcProvider] Starting
> [JdbcProvider] 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@358f03 URL:
> http://cassia:8083/WebClassLoader@3510019/
> [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
> [Container factory] Deploying Users
> [Container factory] No resource manager found for jdbc/PostgresqlDB
> [Default] null
> [Container factory] No resource manager found for jms/managerQueue
> [Container factory] No resource manager found for
jms/QueueConnectionFactory
> [Container factory] No resource manager found for jdbc/PostgresqlDB
> [Default] null
> [Container factory] No resource manager found for jdbc/PostgresqlDB
> [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@552b76 URL:
> http://cassia:8083/WebClassLoader@5581686/
> [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@20dbf3
> [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 26 services
> [Default] JBoss 2.4 BETA(Rel_2_4_0_6) Started in 1m:2s
>
>
>
> _______________________________________________
> 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
