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

Reply via email to