13 Replies Latest reply on Sep 2, 2009 3:13 PM by nguyenjulian

    Configure DataSource for "all" server.

    nguyenjulian

      Hello,

      I successfully configured DataSource (with a connection pool) for
      MS SQL 2000 for the "default" server but when I tried the same
      configuration technique I could not get it to work on the "all" server.

      Thanks in advance if you could show how a JDBC Datasource could
      be configured for the "all" server (JBoss 5.1)

      -Nam

        • 1. Re: Configure DataSource for
          vickyk

           

          "nguyenjulian" wrote:

          Thanks in advance if you could show how a JDBC Datasource could
          be configured for the "all" server (JBoss 5.1)

          There should not be difference in deployment procedure of the datasource across all/default, so deployments should run across default/all modes without issues.

          What issues are you getting when you are deploying the datasource in all mode, give us the details about it?
          How did you conclude that datasource does not get deployed in all mode?

          • 2. Re: Configure DataSource for
            nguyenjulian

            I knew it doesn't work since:

            1) when I started the "all" server and then looked at the
            Admin console, the DataSource has the "unavailable"
            status, which wouldn't happen if I started the "default"
            server

            2) my same test JSP page acessing the DataSource would work
            only when the .ear deployed in the "default" server.

            I suspected that the difference is the "all" server is meant to be used
            for Jboss clustering, hence a DataSource must be configured differently.
            But that's only a suspicion, not a fact.

            Again, thanks for any info on this.

            -Nam

            • 3. Re: Configure DataSource for
              jaikiran

               

              "nguyenjulian" wrote:


              I suspected that the difference is the "all" server is meant to be used
              for Jboss clustering, hence a DataSource must be configured differently.


              As Vicky said, there's no difference in configuring a datasource for the "default" server or a "all" server. Post the contents of your datasource file and also post the console logs (not server.log) of the "all" server.

              While posting logs or xml content or code, please remember to wrap it in a code block by using the Code button in the message editor window. Please use the Preview button to ensure that your post is correctly formatted.


              • 4. Re: Configure DataSource for
                jaikiran

                And how do you deploy the datasource? You use the admin console to do it? There was a similar post where the user had tried using the admin console for deploying datasource and ended up seeing the datasource as "Down" because he had specified the JDBC URL incorrect. I don't think that's the case here, because your datasource seems to be working fine against the "default" server. The only other suspect would be that you did not place the JDBC driver jar in the server/all/lib folder.

                • 5. Re: Configure DataSource for
                  nguyenjulian

                  Hi all,

                  OK, so there's no difference between the 2 versions
                  of "mssql-ds.xml" (in "default" and "all" servers),
                  as a comparison (using Textpad) would show:

                  ---------------------->

                  Compare: (<)C:\apps\jboss-5.1.0.GA\server\default\deploy\mssql-ds.xml (621 bytes)
                  with: (>)C:\apps\jboss-5.1.0.GA\server\all\deploy\mssql-ds.xml (621 bytes)

                  The files are identical

                  ---------------------->

                  Now the (identical) content of the file "mssql-ds.xml"
                  is:

                  ----------------------->
                  <?xml version="1.0" encoding="UTF-8"?>

                  <local-tx-datasource>
                  <jndi-name>CydoniaDataSource</jndi-name>
                  <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=testDB</connection-url>
                  <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
                  <user-name>someone</user-name>
                  somepassword
                  <min-pool-size>6</min-pool-size>
                  <max-pool-size>15</max-pool-size>
                  <check-valid-connection-sql>SELECT 1 FROM sysobjects</check-valid-connection-sql>

                  <type-mapping>MS SQLSERVER2000</type-mapping>

                  </local-tx-datasource>

                  ----------------------->

                  Also, I placed the JDBC driver .jar file under the "lib"
                  in each server, as shown below:

                  ------------------------------------->

                  C:\apps\jboss-5.1.0.GA>dir /S sqljdbc4.jar
                  Volume in drive C is S3A4031D502
                  Volume Serial Number is B070-043B

                  Directory of C:\apps\jboss-5.1.0.GA\server\all\lib

                  03/25/2009 07:08 PM 466,359 sqljdbc4.jar
                  1 File(s) 466,359 bytes

                  Directory of C:\apps\jboss-5.1.0.GA\server\default\lib

                  03/25/2009 07:08 PM 466,359 sqljdbc4.jar
                  1 File(s) 466,359 bytes

                  Directory of C:\apps\jboss-5.1.0.GA\server\standard\lib

                  03/25/2009 07:08 PM 466,359 sqljdbc4.jar
                  1 File(s) 466,359 bytes

                  Total Files Listed:
                  3 File(s) 1,399,077 bytes
                  0 Dir(s) 28,496,863,232 bytes free

                  C:\apps\jboss-5.1.0.GA>

                  -------------------------------------->

                  What is the "console logs" you were referring to?

                  Thanks.

                  -Nam



                  • 6. Re: Configure DataSource for
                    nguyenjulian

                    Here's the code block for the "mssql-ds.xml". (Sorry, I didn't quite know how to use the code block correctly).

                    <?xml version="1.0" encoding="UTF-8"?>
                    <datasources>
                     <local-tx-datasource>
                     <jndi-name>CydoniaDataSource</jndi-name>
                     <connection-url>jdbc:sqlserver://localhost:1433;DatabaseName=testDB</connection-url>
                     <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
                     <user-name>someone</user-name>
                     <password>somepassword</password>
                     <min-pool-size>6</min-pool-size>
                     <max-pool-size>15</max-pool-size>
                     <check-valid-connection-sql>SELECT 1 FROM sysobjects</check-valid-connection-sql>
                     <metadata>
                     <type-mapping>MS SQLSERVER2000</type-mapping>
                     </metadata>
                     </local-tx-datasource>
                    </datasources>


                    • 7. Re: Configure DataSource for
                      jaikiran

                       

                      "nguyenjulian" wrote:

                      What is the "console logs" you were referring to?



                      The logs that you see on the console when you start JBoss. But that depends on how you start JBoss. So the real question is - how do you start JBoss, what command do you use?

                      And did you see this, in my previous reply:

                      The only other suspect would be that you did not place the JDBC driver jar in the server/all/lib folder.


                      • 8. Re: Configure DataSource for
                        nguyenjulian

                         

                        Compare: (<)C:\apps\jboss-5.1.0.GA\server\default\deploy\mssql-ds.xml (621 bytes)
                         with: (>)C:\apps\jboss-5.1.0.GA\server\all\deploy\mssql-ds.xml (621 bytes)
                        
                        The files are identical

                        C:\apps\jboss-5.1.0.GA>dir /S sqljdbc4.jar
                         Volume in drive C is S3A4031D502
                         Volume Serial Number is B070-043B
                        
                         Directory of C:\apps\jboss-5.1.0.GA\server\all\lib
                        
                        03/25/2009 07:08 PM 466,359 sqljdbc4.jar
                         1 File(s) 466,359 bytes
                        
                         Directory of C:\apps\jboss-5.1.0.GA\server\default\lib
                        
                        03/25/2009 07:08 PM 466,359 sqljdbc4.jar
                         1 File(s) 466,359 bytes
                        
                         Directory of C:\apps\jboss-5.1.0.GA\server\standard\lib
                        
                        03/25/2009 07:08 PM 466,359 sqljdbc4.jar
                         1 File(s) 466,359 bytes
                        
                         Total Files Listed:
                         3 File(s) 1,399,077 bytes
                         0 Dir(s) 28,496,863,232 bytes free
                        
                        C:\apps\jboss-5.1.0.GA>


                        • 9. Re: Configure DataSource for
                          nguyenjulian

                          This is how I started the "all" server (together with the log content):

                          C:\apps\jboss-5.1.0.GA\bin>.\run.bat -c all
                          Calling C:\apps\jboss-5.1.0.GA\bin\run.conf.bat
                          ===============================================================================
                          
                           JBoss Bootstrap Environment
                          
                           JBOSS_HOME: C:\apps\jboss-5.1.0.GA
                          
                           JAVA: C:\apps\j2se\bin\java
                          
                           JAVA_OPTS: -Dprogram.name=run.bat -Xms128M -Xmx512M -XX:MaxPermSize=256M -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Dorg.jboss.resolver.warning=true -server
                          
                           CLASSPATH: C:\apps\jboss-5.1.0.GA\bin\run.jar
                          
                          ===============================================================================
                          
                          23:53:58,832 INFO [ServerImpl] Starting JBoss (Microcontainer)...
                          23:53:58,832 INFO [ServerImpl] Release ID: JBoss [The Oracle] 5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)
                          23:53:58,832 INFO [ServerImpl] Bootstrap URL: null
                          23:53:58,832 INFO [ServerImpl] Home Dir: C:\apps\jboss-5.1.0.GA
                          23:53:58,832 INFO [ServerImpl] Home URL: file:/C:/apps/jboss-5.1.0.GA/
                          23:53:58,832 INFO [ServerImpl] Library URL: file:/C:/apps/jboss-5.1.0.GA/lib/
                          23:53:58,832 INFO [ServerImpl] Patch URL: null
                          23:53:58,832 INFO [ServerImpl] Common Base URL: file:/C:/apps/jboss-5.1.0.GA/common/
                          23:53:58,832 INFO [ServerImpl] Common Library URL: file:/C:/apps/jboss-5.1.0.GA/common/lib/
                          23:53:58,832 INFO [ServerImpl] Server Name: all
                          23:53:58,832 INFO [ServerImpl] Server Base Dir: C:\apps\jboss-5.1.0.GA\server
                          23:53:58,832 INFO [ServerImpl] Server Base URL: file:/C:/apps/jboss-5.1.0.GA/server/
                          23:53:58,832 INFO [ServerImpl] Server Config URL: file:/C:/apps/jboss-5.1.0.GA/server/all/conf/
                          23:53:58,832 INFO [ServerImpl] Server Home Dir: C:\apps\jboss-5.1.0.GA\server\all
                          23:53:58,832 INFO [ServerImpl] Server Home URL: file:/C:/apps/jboss-5.1.0.GA/server/all/
                          23:53:58,832 INFO [ServerImpl] Server Data Dir: C:\apps\jboss-5.1.0.GA\server\all\data
                          23:53:58,832 INFO [ServerImpl] Server Library URL: file:/C:/apps/jboss-5.1.0.GA/server/all/lib/
                          23:53:58,832 INFO [ServerImpl] Server Log Dir: C:\apps\jboss-5.1.0.GA\server\all\log
                          23:53:58,832 INFO [ServerImpl] Server Native Dir: C:\apps\jboss-5.1.0.GA\server\all\tmp\native
                          23:53:58,832 INFO [ServerImpl] Server Temp Dir: C:\apps\jboss-5.1.0.GA\server\all\tmp
                          23:53:58,832 INFO [ServerImpl] Server Temp Deploy Dir: C:\apps\jboss-5.1.0.GA\server\all\tmp\deploy
                          23:53:59,597 INFO [ServerImpl] Starting Microcontainer, bootstrapURL=file:/C:/apps/jboss-5.1.0.GA/server/all/conf/bootstrap.xml
                          23:54:00,300 INFO [VFSCacheFactory] Initializing VFSCache [org.jboss.virtual.plugins.cache.CombinedVFSCache]
                          23:54:00,300 INFO [VFSCacheFactory] Using VFSCache [CombinedVFSCache[real-cache: null]]
                          23:54:00,675 INFO [CopyMechanism] VFS temp dir: C:\apps\jboss-5.1.0.GA\server\all\tmp
                          23:54:00,722 INFO [ZipEntryContext] VFS force nested jars copy-mode is enabled.
                          23:54:02,410 INFO [ServerInfo] Java version: 1.6.0_14,Sun Microsystems Inc.
                          23:54:02,425 INFO [ServerInfo] Java Runtime: Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
                          23:54:02,425 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM 14.0-b16,Sun Microsystems Inc.
                          23:54:02,425 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
                          23:54:02,425 INFO [ServerInfo] VM arguments: -Dprogram.name=run.bat -Xms128M -Xmx512M -XX:MaxPermSize=256M -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000 -Dorg.jboss.resolver.warning=true -Djava.endorsed.di
                          rs=C:\apps\jboss-5.1.0.GA\lib\endorsed
                          23:54:02,472 INFO [JMXKernel] Legacy JMX core initialized
                          23:54:05,582 INFO [ProfileServiceBootstrap] Loading profile: ProfileKey@b7f2d0[domain=default, server=default, name=all]
                          23:54:08,519 INFO [WebService] Using RMI server codebase: http://127.0.0.1:8083/
                          23:54:18,300 INFO [NativeServerConfig] JBoss Web Services - Stack Native Core
                          23:54:18,300 INFO [NativeServerConfig] 3.1.2.GA
                          23:54:19,238 INFO [AttributeCallbackItem] Owner callback not implemented.
                          23:54:20,925 INFO [LogNotificationListener] Adding notification listener for logging mbean "jboss.system:service=Logging,type=Log4jService" to server org.jboss.mx.server.MBeanServerImpl@a45435[ defaultDomain='jboss' ]
                          23:54:41,629 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@6235237{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/profileservice-secured.jar/}
                          23:54:41,629 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@6235237{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/profileservice-secured.jar/}
                          23:54:41,629 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@6235237{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/profileservice-secured.jar/}
                          23:54:41,629 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@6235237{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/profileservice-secured.jar/}
                          23:54:43,800 INFO [CorbaNamingService] CORBA Naming Started
                          23:54:49,285 INFO [JMXConnectorServerService] JMX Connector server: service:jmx:rmi://127.0.0.1/jndi/rmi://127.0.0.1:1090/jmxconnector
                          23:54:49,800 INFO [MailService] Mail Service bound to java:/Mail
                          23:54:50,597 INFO [SnmpAgentService] SNMP agent going active
                          23:54:54,613 INFO [DefaultPartition] Initializing partition DefaultPartition
                          23:54:54,707 INFO [STDOUT]
                          ---------------------------------------------------------
                          GMS: address is 127.0.0.1:3164 (cluster=DefaultPartition)
                          ---------------------------------------------------------
                          23:54:54,894 INFO [PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server.
                          23:54:54,972 INFO [STDOUT]
                          ---------------------------------------------------------
                          GMS: address is 127.0.0.1:3164 (cluster=DefaultPartition-HAPartitionCache)
                          ---------------------------------------------------------
                          23:54:56,785 INFO [DefaultPartition] Number of cluster members: 1
                          23:54:56,785 INFO [DefaultPartition] Other members: 0
                          23:54:56,988 INFO [RPCManagerImpl] Received new cluster view: [127.0.0.1:3164|0] [127.0.0.1:3164]
                          23:54:57,004 INFO [RPCManagerImpl] Cache local address is 127.0.0.1:3164
                          23:54:57,082 INFO [RPCManagerImpl] state was retrieved successfully (in 2.05 seconds)
                          23:54:57,113 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Cascabel' 3.1.0.GA
                          23:54:57,113 INFO [DefaultPartition] Fetching serviceState (will wait for 30000 milliseconds):
                          23:54:57,113 INFO [DefaultPartition] State could not be retrieved (we are the first member in group)
                          23:54:57,300 INFO [HANamingService] Started HAJNDI bootstrap; jnpPort=1100, backlog=50, bindAddress=/127.0.0.1
                          23:54:57,316 INFO [DetachedHANamingService$AutomaticDiscovery] Listening on /127.0.0.1:1102, group=230.0.0.4, HA-JNDI address=127.0.0.1:1100
                          23:54:58,972 INFO [UnifiedInvokerHA] Service name is jboss:service=invoker,type=unifiedha
                          23:54:59,863 WARN [JBossASSecurityMetadataStore] WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its password changed from the installation d
                          efault. Please see the JBoss Messaging user guide for instructions on how to do this.
                          23:54:59,879 WARN [AnnotationCreator] No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
                          23:55:00,019 WARN [AnnotationCreator] No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
                          23:55:00,097 INFO [TransactionManagerService] JBossTS Transaction Service (JTA version - tag:JBOSSTS_4_6_1_GA) - JBoss Inc.
                          23:55:00,097 INFO [TransactionManagerService] Setting up property manager MBean and JMX layer
                          23:55:00,410 INFO [TransactionManagerService] Initializing recovery manager
                          23:55:00,566 INFO [TransactionManagerService] Recovery manager configured
                          23:55:00,582 INFO [TransactionManagerService] Binding TransactionManager JNDI Reference
                          23:55:00,629 INFO [TransactionManagerService] Starting transaction recovery manager
                          23:55:01,269 INFO [AprLifecycleListener] The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\apps\j2se\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:
                          \WINDOWS;C:\Program Files\JavaFX\javafx-sdk1.2\bin;C:\Program Files\JavaFX\javafx-sdk1.2\emulator\bin;C:\apps\tibco\tibrv\8.1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:
                          \apps\j2se\bin;C:\apps\j2se\jre\bin;c:\Program Files\Microsoft SQL Server\90\Tools\binn;C:\apps\apache-ant-1.7.1\bin;c:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\QuickTime\QTSystem\;C:\apps\MySQL5.1\bin;C:\apps\SunA
                          ppGlassFish\bin;C:\apps\OpenSSL\bin;C:\Program Files\Common Files\Ahead\Lib\;C:\Program Files\Common Files\Ahead\Lib\
                          23:55:01,363 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-127.0.0.1-8080
                          23:55:01,363 INFO [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-127.0.0.1-8009
                          23:55:01,394 INFO [StandardService] Starting service jboss.web
                          23:55:01,394 INFO [StandardEngine] Starting Servlet Engine: JBoss Web/2.1.3.GA
                          23:55:01,457 INFO [Catalina] Server startup in 93 ms
                          23:55:01,535 INFO [TomcatDeployment] deploy, ctxPath=/web-console
                          23:55:03,035 INFO [TomcatDeployment] deploy, ctxPath=/invoker
                          23:55:03,113 INFO [TomcatDeployment] deploy, ctxPath=/jbossws
                          23:55:03,144 INFO [TomcatDeployment] deploy, ctxPath=/juddi
                          23:55:03,191 INFO [RegistryServlet] Loading jUDDI configuration.
                          23:55:03,254 INFO [RegistryServlet] Resources loaded from: /WEB-INF/juddi.properties
                          23:55:03,269 INFO [RegistryServlet] Initializing jUDDI components.
                          23:55:03,535 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/apps/jboss-5.1.0.GA/server/all/deploy/jboss-local-jdbc.rar/META-INF/ra.xml
                          23:55:03,550 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/apps/jboss-5.1.0.GA/server/all/deploy/jboss-xa-jdbc.rar/META-INF/ra.xml
                          23:55:03,582 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/apps/jboss-5.1.0.GA/server/all/deploy/jms-ra.rar/META-INF/ra.xml
                          23:55:03,613 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/apps/jboss-5.1.0.GA/server/all/deploy/mail-ra.rar/META-INF/ra.xml
                          23:55:03,644 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/apps/jboss-5.1.0.GA/server/all/deploy/quartz-ra.rar/META-INF/ra.xml
                          23:55:03,800 INFO [SimpleThreadPool] Job execution threads will use class loader of thread: main
                          23:55:03,847 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
                          23:55:03,863 INFO [RAMJobStore] RAMJobStore initialized.
                          23:55:03,863 INFO [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
                          23:55:03,863 INFO [StdSchedulerFactory] Quartz scheduler version: 1.5.2
                          23:55:03,863 INFO [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
                          23:55:04,613 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
                          23:55:05,285 INFO [ServerPeer] JBoss Messaging 1.4.3.GA server [0] started
                          23:55:05,582 INFO [STDOUT]
                          ---------------------------------------------------------
                          GMS: address is 127.0.0.1:3164 (cluster=MessagingPostOffice-CTRL)
                          ---------------------------------------------------------
                          23:55:07,613 INFO [GroupMember] org.jboss.messaging.core.impl.postoffice.GroupMember$ControlMembershipListener@12bd157 got new view [127.0.0.1:3164|0] [127.0.0.1:3164], old view is null
                          23:55:07,613 INFO [GroupMember] I am (127.0.0.1:3164)
                          23:55:07,613 INFO [GroupMember] New Members : 1 ([127.0.0.1:3164])
                          23:55:07,613 INFO [GroupMember] All Members : 1 ([127.0.0.1:3164])
                          23:55:07,644 INFO [STDOUT]
                          ---------------------------------------------------------
                          GMS: address is 127.0.0.1:7900 (cluster=MessagingPostOffice-DATA)
                          ---------------------------------------------------------
                          23:55:12,722 INFO [QueueService] Queue[/queue/ExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
                          23:55:12,863 INFO [ConnectionFactory] Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
                          23:55:12,879 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@2bb567 started
                          23:55:13,300 WARN [JBossASSecurityMetadataStore] WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its password changed from the installation d
                          efault. Please see the JBoss Messaging user guide for instructions on how to do this.
                          23:55:14,004 INFO [ConnectionFactory] Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
                          23:55:14,004 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@1729115 started
                          23:55:14,035 INFO [ConnectionFactory] Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
                          23:55:14,035 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@1563bcf started
                          23:55:14,035 INFO [QueueService] Queue[/queue/DLQ] started, fullSize=200000, pageSize=2000, downCacheSize=2000
                          23:55:14,207 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
                          23:55:14,254 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=CydoniaDataSource' to JNDI name 'java:CydoniaDataSource'
                          23:55:14,691 INFO [JBossASKernel] Created KernelDeployment for: profileservice-secured.jar
                          23:55:14,707 INFO [JBossASKernel] installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3
                          23:55:14,707 INFO [JBossASKernel] with dependencies:
                          23:55:14,707 INFO [JBossASKernel] and demands:
                          23:55:14,707 INFO [JBossASKernel] jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView
                          23:55:14,707 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
                          23:55:14,707 INFO [JBossASKernel] and supplies:
                          23:55:14,707 INFO [JBossASKernel] Class:org.jboss.profileservice.spi.ProfileService
                          23:55:14,707 INFO [JBossASKernel] jndi:SecureProfileService/remote
                          23:55:14,722 INFO [JBossASKernel] jndi:SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService
                          23:55:14,722 INFO [JBossASKernel] Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3) to KernelDeployment of: profileservice-secured.jar
                          23:55:14,722 INFO [JBossASKernel] installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3
                          23:55:14,722 INFO [JBossASKernel] with dependencies:
                          23:55:14,722 INFO [JBossASKernel] and demands:
                          23:55:14,722 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
                          23:55:14,722 INFO [JBossASKernel] and supplies:
                          23:55:14,722 INFO [JBossASKernel] jndi:SecureDeploymentManager/remote-org.jboss.deployers.spi.management.deploy.DeploymentManager
                          23:55:14,738 INFO [JBossASKernel] Class:org.jboss.deployers.spi.management.deploy.DeploymentManager
                          23:55:14,738 INFO [JBossASKernel] jndi:SecureDeploymentManager/remote
                          23:55:14,738 INFO [JBossASKernel] Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3) to KernelDeployment of: profileservice-secured.jar
                          23:55:14,738 INFO [JBossASKernel] installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3
                          23:55:14,738 INFO [JBossASKernel] with dependencies:
                          23:55:14,738 INFO [JBossASKernel] and demands:
                          23:55:14,738 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
                          23:55:14,738 INFO [JBossASKernel] and supplies:
                          23:55:14,738 INFO [JBossASKernel] jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView
                          23:55:14,754 INFO [JBossASKernel] Class:org.jboss.deployers.spi.management.ManagementView
                          23:55:14,754 INFO [JBossASKernel] jndi:SecureManagementView/remote
                          23:55:14,754 INFO [JBossASKernel] Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3) to KernelDeployment of: profileservice-secured.jar
                          23:55:14,754 INFO [EJB3EndpointDeployer] Deploy AbstractBeanMetaData@609de0{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties=
                          [container] constructor=null autowireCandidate=true}
                          23:55:14,769 INFO [EJB3EndpointDeployer] Deploy AbstractBeanMetaData@17e9678{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl propert
                          ies=[container] constructor=null autowireCandidate=true}
                          23:55:14,769 INFO [EJB3EndpointDeployer] Deploy AbstractBeanMetaData@1d28dc9{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties
                          =[container] constructor=null autowireCandidate=true}
                          23:55:14,988 INFO [SessionSpecContainer] Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3
                          23:55:15,019 INFO [EJBContainer] STARTED EJB: org.jboss.profileservice.ejb.SecureDeploymentManager ejbName: SecureDeploymentManager
                          23:55:15,129 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:
                          
                           SecureDeploymentManager/remote - EJB3.x Default Remote Business Interface
                           SecureDeploymentManager/remote-org.jboss.deployers.spi.management.deploy.DeploymentManager - EJB3.x Remote Business Interface
                          
                          23:55:15,238 INFO [SessionSpecContainer] Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3
                          23:55:15,238 INFO [EJBContainer] STARTED EJB: org.jboss.profileservice.ejb.SecureManagementView ejbName: SecureManagementView
                          23:55:15,254 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:
                          
                           SecureManagementView/remote - EJB3.x Default Remote Business Interface
                           SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView - EJB3.x Remote Business Interface
                          
                          23:55:15,363 INFO [SessionSpecContainer] Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3
                          23:55:15,363 INFO [EJBContainer] STARTED EJB: org.jboss.profileservice.ejb.SecureProfileServiceBean ejbName: SecureProfileService
                          23:55:15,379 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:
                          
                           SecureProfileService/remote - EJB3.x Default Remote Business Interface
                           SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService - EJB3.x Remote Business Interface
                          
                          23:55:15,535 INFO [TomcatDeployment] deploy, ctxPath=/admin-console
                          23:55:15,660 INFO [config] Initializing Mojarra (1.2_12-b01-FCS) for context '/admin-console'
                          23:55:19,957 INFO [TomcatDeployment] deploy, ctxPath=/
                          23:55:20,050 INFO [TomcatDeployment] deploy, ctxPath=/jmx-console
                          23:55:20,285 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
                          23:55:20,316 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
                          23:55:20,332 INFO [ServerImpl] JBoss (Microcontainer) [5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)] Started in 1m:21s:485ms
                          


                          • 10. Re: Configure DataSource for
                            jaikiran

                            Let's keep out the admin-console for a moment. Please post the logs which show the exceptions when you use your jsp in "all" config:


                            2) my same test JSP page acessing the DataSource would work
                            only when the .ear deployed in the "default" server.


                            Also, post the relevant portion from the jsp which does the lookup and obtains a connection.



                            • 11. Re: Configure DataSource for
                              nguyenjulian

                              First, l'd like to thank all, especially Jaikiran, for putting some effort
                              answering the issue.

                              Secondly, though the Admin console still shows the data source
                              is down, my JSP test page is now successful even in the "all" server
                              (in both "exploded" and "packaged" deployment modes)!

                              Exactly what happened before I'm no longer certain. My guess would
                              be at the time the (erroneous?) status on the console about the datasource
                              coupled with whatever wrongness in my EAR application contributed
                              to my incorrect assement of the problem. And I apologize to have
                              somewhat misled (though unintentionally) us all.

                              So I'm happy that it works though the "outstanding" issue is the
                              Admin console still shows the _incorrect_ status of the datasource.
                              Should one really care about that? In any rate, this is what one would
                              see from the Admin console (beside the red X symbol):

                               * Summary
                               * Configuration
                               * Metrics
                               * Control
                               * Content
                              
                              Local Transaction Datasources deployed in the instance of JBoss AS
                              Name Status Actions
                              CydoniaDataSource DOWN
                              DefaultDS UP
                              


                              The URL for the above is:
                              http://localhost:8080/admin-console/secure/summary.seam?path=-3%2FResources%2FDatasources%2FLocal+Tx+Datasource&conversationId=2&conversationPropagation=end
                              
                              


                              And for what it's worth, my testing JSP is:
                              <%@ page language="java" import="java.util.*,javax.naming.*,javax.sql.*,java.sql.*" pageEncoding="ISO-8859-1"%>
                              
                              <%!
                              String theJDBCError = "No JDBC error";
                              
                              public int JDBCtest() {
                               DataSource ds = null;
                               Connection con = null;
                               PreparedStatement pr = null;
                               InitialContext initCtx;
                               int ret = 0;
                              
                               theJDBCError = "No JDBC error";
                              
                               try {
                               initCtx = new InitialContext();
                               ds = (DataSource)initCtx.lookup( "java:/CydoniaDataSource" );
                               con = ds.getConnection();
                               pr = con.prepareStatement("SELECT count(*) from book");
                               ResultSet rs = pr.executeQuery();
                               while (rs.next()) {
                               ret = rs.getInt(1);
                               }
                               rs.close();
                               pr.close();
                               }
                               catch(Exception e){
                               theJDBCError = e.toString();
                               ret = -1;
                               }
                               finally{
                               if(con != null) {
                               try {
                               con.close();
                               }catch(SQLException e2) {}
                               }
                               }
                               return ret;
                              }
                              %>
                              
                              <%
                              String path = request.getContextPath();
                              String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
                              
                              int nBooks = JDBCtest();
                              %>
                              
                              <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
                              <html>
                               <head>
                               <base href="<%=basePath%>">
                              
                               <title>My JSP 'DB.jsp' starting page</title>
                              
                               <meta http-equiv="pragma" content="no-cache">
                               <meta http-equiv="cache-control" content="no-cache">
                               <meta http-equiv="expires" content="0">
                               <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
                               <meta http-equiv="description" content="This is my page">
                               <!--
                               <link rel="stylesheet" type="text/css" href="styles.css">
                               -->
                              
                               </head>
                              
                               <body>
                               This is a testing page for DAO layer.<br>
                               theJDBCError = <%=theJDBCError%><br>
                               Number of books = <%=nBooks%><br>
                               </body>
                              </html>
                              


                              with the results from a browser as:
                              This is a testing page for DAO layer.
                              theJDBCError = No JDBC error
                              Number of books = 7
                              


                              And the "all" server log is:

                              11:00:03,500 INFO [ServerImpl] Starting JBoss (Microcontainer)...
                              11:00:03,500 INFO [ServerImpl] Release ID: JBoss [The Oracle] 5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)
                              11:00:03,500 INFO [ServerImpl] Bootstrap URL: null
                              11:00:03,500 INFO [ServerImpl] Home Dir: C:\apps\jboss-5.1.0.GA
                              11:00:03,515 INFO [ServerImpl] Home URL: file:/C:/apps/jboss-5.1.0.GA/
                              11:00:03,515 INFO [ServerImpl] Library URL: file:/C:/apps/jboss-5.1.0.GA/lib/
                              11:00:03,515 INFO [ServerImpl] Patch URL: null
                              11:00:03,515 INFO [ServerImpl] Common Base URL: file:/C:/apps/jboss-5.1.0.GA/common/
                              11:00:03,515 INFO [ServerImpl] Common Library URL: file:/C:/apps/jboss-5.1.0.GA/common/lib/
                              11:00:03,515 INFO [ServerImpl] Server Name: all
                              11:00:03,515 INFO [ServerImpl] Server Base Dir: C:\apps\jboss-5.1.0.GA\server
                              11:00:03,515 INFO [ServerImpl] Server Base URL: file:/C:/apps/jboss-5.1.0.GA/server/
                              11:00:03,515 INFO [ServerImpl] Server Config URL: file:/C:/apps/jboss-5.1.0.GA/server/all/conf/
                              11:00:03,515 INFO [ServerImpl] Server Home Dir: C:\apps\jboss-5.1.0.GA\server\all
                              11:00:03,515 INFO [ServerImpl] Server Home URL: file:/C:/apps/jboss-5.1.0.GA/server/all/
                              11:00:03,515 INFO [ServerImpl] Server Data Dir: C:\apps\jboss-5.1.0.GA\server\all\data
                              11:00:03,515 INFO [ServerImpl] Server Library URL: file:/C:/apps/jboss-5.1.0.GA/server/all/lib/
                              11:00:03,515 INFO [ServerImpl] Server Log Dir: C:\apps\jboss-5.1.0.GA\server\all\log
                              11:00:03,515 INFO [ServerImpl] Server Native Dir: C:\apps\jboss-5.1.0.GA\server\all\tmp\native
                              11:00:03,515 INFO [ServerImpl] Server Temp Dir: C:\apps\jboss-5.1.0.GA\server\all\tmp
                              11:00:03,515 INFO [ServerImpl] Server Temp Deploy Dir: C:\apps\jboss-5.1.0.GA\server\all\tmp\deploy
                              11:00:04,140 INFO [ServerImpl] Starting Microcontainer, bootstrapURL=file:/C:/apps/jboss-5.1.0.GA/server/all/conf/bootstrap.xml
                              11:00:04,703 INFO [VFSCacheFactory] Initializing VFSCache [org.jboss.virtual.plugins.cache.CombinedVFSCache]
                              11:00:04,718 INFO [VFSCacheFactory] Using VFSCache [CombinedVFSCache[real-cache: null]]
                              11:00:04,984 INFO [CopyMechanism] VFS temp dir: C:\apps\jboss-5.1.0.GA\server\all\tmp
                              11:00:04,984 INFO [ZipEntryContext] VFS force nested jars copy-mode is enabled.
                              11:00:05,828 INFO [ServerInfo] Java version: 1.6.0_14,Sun Microsystems Inc.
                              11:00:05,828 INFO [ServerInfo] Java Runtime: Java(TM) SE Runtime Environment (build 1.6.0_14-b08)
                              11:00:05,828 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 14.0-b16,Sun Microsystems Inc.
                              11:00:05,828 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
                              11:00:05,828 INFO [ServerInfo] VM arguments: -Djboss.home=C:\apps\jboss-5.1.0.GA -Djava.library.path=C:\apps\j2se\bin -Djava.endorsed.dirs=C:\apps\jboss-5.1.0.GA\lib\endorsed -Xms128m -Xmx512m -XX:MaxPermSize=256m
                              11:00:05,859 INFO [JMXKernel] Legacy JMX core initialized
                              11:00:07,531 INFO [ProfileServiceBootstrap] Loading profile: ProfileKey@396fce[domain=default, server=default, name=all]
                              11:00:09,250 INFO [WebService] Using RMI server codebase: http://127.0.0.1:8083/
                              11:00:14,406 INFO [NativeServerConfig] JBoss Web Services - Stack Native Core
                              11:00:14,406 INFO [NativeServerConfig] 3.1.2.GA
                              11:00:15,640 INFO [AttributeCallbackItem] Owner callback not implemented.
                              11:00:17,171 INFO [LogNotificationListener] Adding notification listener for logging mbean "jboss.system:service=Logging,type=Log4jService" to server org.jboss.mx.server.MBeanServerImpl@cc5436[ defaultDomain='jboss' ]
                              11:00:30,343 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@22541663{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/profileservice-secured.jar/}
                              11:00:30,343 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@22541663{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/profileservice-secured.jar/}
                              11:00:30,343 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@22541663{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/profileservice-secured.jar/}
                              11:00:30,343 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@22541663{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/profileservice-secured.jar/}
                              11:00:30,343 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@32347476{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/cydonia.ear/cydoniaEJB.jar/}
                              11:00:30,343 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@32347476{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/cydonia.ear/cydoniaEJB.jar/}
                              11:00:30,343 INFO [Ejb3DependenciesDeployer] Encountered deployment AbstractVFSDeploymentContext@32347476{vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/cydonia.ear/cydoniaEJB.jar/}
                              11:00:31,484 INFO [CorbaNamingService] CORBA Naming Started
                              11:00:36,046 INFO [JMXConnectorServerService] JMX Connector server: service:jmx:rmi://127.0.0.1/jndi/rmi://127.0.0.1:1090/jmxconnector
                              11:00:36,265 INFO [MailService] Mail Service bound to java:/Mail
                              11:00:36,843 INFO [SnmpAgentService] SNMP agent going active
                              11:00:39,359 INFO [DefaultPartition] Initializing partition DefaultPartition
                              11:00:39,468 INFO [STDOUT]
                              ---------------------------------------------------------
                              GMS: address is 127.0.0.1:4756 (cluster=DefaultPartition)
                              ---------------------------------------------------------
                              11:00:39,609 INFO [PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server.
                              11:00:39,671 INFO [STDOUT]
                              ---------------------------------------------------------
                              GMS: address is 127.0.0.1:4756 (cluster=DefaultPartition-HAPartitionCache)
                              ---------------------------------------------------------
                              11:00:41,546 INFO [DefaultPartition] Number of cluster members: 1
                              11:00:41,546 INFO [DefaultPartition] Other members: 0
                              11:00:41,671 INFO [RPCManagerImpl] Received new cluster view: [127.0.0.1:4756|0] [127.0.0.1:4756]
                              11:00:41,671 INFO [RPCManagerImpl] Cache local address is 127.0.0.1:4756
                              11:00:41,671 INFO [RPCManagerImpl] state was retrieved successfully (in 2 seconds)
                              11:00:41,703 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Cascabel' 3.1.0.GA
                              11:00:41,703 INFO [DefaultPartition] Fetching serviceState (will wait for 30000 milliseconds):
                              11:00:41,703 INFO [DefaultPartition] State could not be retrieved (we are the first member in group)
                              11:00:41,796 INFO [HANamingService] Started HAJNDI bootstrap; jnpPort=1100, backlog=50, bindAddress=/127.0.0.1
                              11:00:41,812 INFO [DetachedHANamingService$AutomaticDiscovery] Listening on /127.0.0.1:1102, group=230.0.0.4, HA-JNDI address=127.0.0.1:1100
                              11:00:42,734 INFO [UnifiedInvokerHA] Service name is jboss:service=invoker,type=unifiedha
                              11:00:43,312 WARN [JBossASSecurityMetadataStore] WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its password changed from the installation default. Please see the JBoss Messaging user guide for instructions on how to do this.
                              11:00:43,343 WARN [AnnotationCreator] No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
                              11:00:43,500 WARN [AnnotationCreator] No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
                              11:00:43,562 INFO [TransactionManagerService] JBossTS Transaction Service (JTA version - tag:JBOSSTS_4_6_1_GA) - JBoss Inc.
                              11:00:43,562 INFO [TransactionManagerService] Setting up property manager MBean and JMX layer
                              11:00:44,593 INFO [TransactionManagerService] Initializing recovery manager
                              11:00:44,765 INFO [TransactionManagerService] Recovery manager configured
                              11:00:44,765 INFO [TransactionManagerService] Binding TransactionManager JNDI Reference
                              11:00:44,812 INFO [TransactionManagerService] Starting transaction recovery manager
                              11:00:45,328 INFO [AprLifecycleListener] The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\apps\j2se\bin
                              11:00:45,390 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-127.0.0.1-8080
                              11:00:45,406 INFO [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-127.0.0.1-8009
                              11:00:45,421 INFO [StandardService] Starting service jboss.web
                              11:00:45,421 INFO [StandardEngine] Starting Servlet Engine: JBoss Web/2.1.3.GA
                              11:00:45,484 INFO [Catalina] Server startup in 78 ms
                              11:00:45,500 INFO [TomcatDeployment] deploy, ctxPath=/invoker
                              11:00:46,078 INFO [TomcatDeployment] deploy, ctxPath=/juddi
                              11:00:46,140 INFO [RegistryServlet] Loading jUDDI configuration.
                              11:00:46,140 INFO [RegistryServlet] Resources loaded from: /WEB-INF/juddi.properties
                              11:00:46,140 INFO [RegistryServlet] Initializing jUDDI components.
                              11:00:46,296 INFO [TomcatDeployment] deploy, ctxPath=/web-console
                              11:00:47,656 INFO [TomcatDeployment] deploy, ctxPath=/jbossws
                              11:00:47,765 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/apps/jboss-5.1.0.GA/server/all/deploy/jboss-local-jdbc.rar/META-INF/ra.xml
                              11:00:47,781 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/apps/jboss-5.1.0.GA/server/all/deploy/jboss-xa-jdbc.rar/META-INF/ra.xml
                              11:00:47,828 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/apps/jboss-5.1.0.GA/server/all/deploy/jms-ra.rar/META-INF/ra.xml
                              11:00:47,859 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/apps/jboss-5.1.0.GA/server/all/deploy/mail-ra.rar/META-INF/ra.xml
                              11:00:47,890 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/apps/jboss-5.1.0.GA/server/all/deploy/quartz-ra.rar/META-INF/ra.xml
                              11:00:47,984 INFO [SimpleThreadPool] Job execution threads will use class loader of thread: main
                              11:00:48,015 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
                              11:00:48,031 INFO [RAMJobStore] RAMJobStore initialized.
                              11:00:48,031 INFO [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
                              11:00:48,031 INFO [StdSchedulerFactory] Quartz scheduler version: 1.5.2
                              11:00:48,031 INFO [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
                              11:00:48,625 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
                              11:00:49,187 INFO [ServerPeer] JBoss Messaging 1.4.3.GA server [0] started
                              11:00:49,421 INFO [STDOUT]
                              ---------------------------------------------------------
                              GMS: address is 127.0.0.1:4756 (cluster=MessagingPostOffice-CTRL)
                              ---------------------------------------------------------
                              11:00:51,421 INFO [GroupMember] org.jboss.messaging.core.impl.postoffice.GroupMember$ControlMembershipListener@b746cd got new view [127.0.0.1:4756|0] [127.0.0.1:4756], old view is null
                              11:00:51,421 INFO [GroupMember] I am (127.0.0.1:4756)
                              11:00:51,421 INFO [GroupMember] New Members : 1 ([127.0.0.1:4756])
                              11:00:51,421 INFO [GroupMember] All Members : 1 ([127.0.0.1:4756])
                              11:00:51,437 INFO [STDOUT]
                              ---------------------------------------------------------
                              GMS: address is 127.0.0.1:7900 (cluster=MessagingPostOffice-DATA)
                              ---------------------------------------------------------
                              11:00:57,437 INFO [ConnectionFactory] Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
                              11:00:57,437 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@1a1569b started
                              11:00:57,484 INFO [QueueService] Queue[/queue/DLQ] started, fullSize=200000, pageSize=2000, downCacheSize=2000
                              11:00:57,484 INFO [ConnectionFactory] Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
                              11:00:57,484 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@f168d9 started
                              11:00:57,734 WARN [JBossASSecurityMetadataStore] WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its password changed from the installation default. Please see the JBoss Messaging user guide for instructions on how to do this.
                              11:00:58,265 INFO [ConnectionFactory] Connector bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
                              11:00:58,265 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@1837295 started
                              11:00:58,265 INFO [QueueService] Queue[/queue/ExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
                              11:00:58,375 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
                              11:00:58,421 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=CydoniaDataSource' to JNDI name 'java:CydoniaDataSource'
                              11:00:58,859 INFO [JBossASKernel] Created KernelDeployment for: profileservice-secured.jar
                              11:00:58,859 INFO [JBossASKernel] installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3
                              11:00:58,859 INFO [JBossASKernel] with dependencies:
                              11:00:58,859 INFO [JBossASKernel] and demands:
                              11:00:58,859 INFO [JBossASKernel] jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView
                              11:00:58,859 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
                              11:00:58,859 INFO [JBossASKernel] and supplies:
                              11:00:58,859 INFO [JBossASKernel] Class:org.jboss.profileservice.spi.ProfileService
                              11:00:58,859 INFO [JBossASKernel] jndi:SecureProfileService/remote
                              11:00:58,859 INFO [JBossASKernel] jndi:SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService
                              11:00:58,859 INFO [JBossASKernel] Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3) to KernelDeployment of: profileservice-secured.jar
                              11:00:58,859 INFO [JBossASKernel] installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3
                              11:00:58,859 INFO [JBossASKernel] with dependencies:
                              11:00:58,859 INFO [JBossASKernel] and demands:
                              11:00:58,859 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
                              11:00:58,859 INFO [JBossASKernel] and supplies:
                              11:00:58,859 INFO [JBossASKernel] jndi:SecureDeploymentManager/remote-org.jboss.deployers.spi.management.deploy.DeploymentManager
                              11:00:58,859 INFO [JBossASKernel] Class:org.jboss.deployers.spi.management.deploy.DeploymentManager
                              11:00:58,859 INFO [JBossASKernel] jndi:SecureDeploymentManager/remote
                              11:00:58,859 INFO [JBossASKernel] Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3) to KernelDeployment of: profileservice-secured.jar
                              11:00:58,859 INFO [JBossASKernel] installing bean: jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3
                              11:00:58,859 INFO [JBossASKernel] with dependencies:
                              11:00:58,859 INFO [JBossASKernel] and demands:
                              11:00:58,859 INFO [JBossASKernel] jboss.ejb:service=EJBTimerService
                              11:00:58,859 INFO [JBossASKernel] and supplies:
                              11:00:58,859 INFO [JBossASKernel] jndi:SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView
                              11:00:58,859 INFO [JBossASKernel] Class:org.jboss.deployers.spi.management.ManagementView
                              11:00:58,859 INFO [JBossASKernel] jndi:SecureManagementView/remote
                              11:00:58,859 INFO [JBossASKernel] Added bean(jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3) to KernelDeployment of: profileservice-secured.jar
                              11:00:58,875 INFO [EJB3EndpointDeployer] Deploy AbstractBeanMetaData@14f5969{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties=[container] constructor=null autowireCandidate=true}
                              11:00:58,875 INFO [EJB3EndpointDeployer] Deploy AbstractBeanMetaData@299e34{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties=[container] constructor=null autowireCandidate=true}
                              11:00:58,875 INFO [EJB3EndpointDeployer] Deploy AbstractBeanMetaData@d2b97b{name=jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3_endpoint bean=org.jboss.ejb3.endpoint.deployers.impl.EndpointImpl properties=[container] constructor=null autowireCandidate=true}
                              11:00:59,078 INFO [SessionSpecContainer] Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureDeploymentManager,service=EJB3
                              11:00:59,093 INFO [EJBContainer] STARTED EJB: org.jboss.profileservice.ejb.SecureDeploymentManager ejbName: SecureDeploymentManager
                              11:00:59,187 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:
                              
                               SecureDeploymentManager/remote - EJB3.x Default Remote Business Interface
                               SecureDeploymentManager/remote-org.jboss.deployers.spi.management.deploy.DeploymentManager - EJB3.x Remote Business Interface
                              
                              11:00:59,328 INFO [SessionSpecContainer] Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureManagementView,service=EJB3
                              11:00:59,328 INFO [EJBContainer] STARTED EJB: org.jboss.profileservice.ejb.SecureManagementView ejbName: SecureManagementView
                              11:00:59,359 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:
                              
                               SecureManagementView/remote - EJB3.x Default Remote Business Interface
                               SecureManagementView/remote-org.jboss.deployers.spi.management.ManagementView - EJB3.x Remote Business Interface
                              
                              11:00:59,484 INFO [SessionSpecContainer] Starting jboss.j2ee:jar=profileservice-secured.jar,name=SecureProfileService,service=EJB3
                              11:00:59,484 INFO [EJBContainer] STARTED EJB: org.jboss.profileservice.ejb.SecureProfileServiceBean ejbName: SecureProfileService
                              11:00:59,500 INFO [JndiSessionRegistrarBase] Binding the following Entries in Global JNDI:
                              
                               SecureProfileService/remote - EJB3.x Default Remote Business Interface
                               SecureProfileService/remote-org.jboss.profileservice.spi.ProfileService - EJB3.x Remote Business Interface
                              
                              11:00:59,671 INFO [TomcatDeployment] deploy, ctxPath=/admin-console
                              11:00:59,750 INFO [config] Initializing Mojarra (1.2_12-b01-FCS) for context '/admin-console'
                              11:01:02,718 INFO [TomcatDeployment] deploy, ctxPath=/
                              11:01:02,796 INFO [TomcatDeployment] deploy, ctxPath=/jmx-console
                              11:01:02,953 INFO [EjbDeployer] installing bean: ejb/cydoniaEJB.jar#Authentication,uid4361587
                              11:01:02,953 INFO [EjbDeployer] with dependencies:
                              11:01:02,953 INFO [EjbDeployer] and supplies:
                              11:01:02,953 INFO [EjbDeployer] jndi:local/Authentication@18850285
                              11:01:02,953 INFO [EjbDeployer] jndi:cydonia/Authentication
                              11:01:02,953 INFO [EjbDeployer] jndi:Authentication
                              11:01:02,953 INFO [EjbDeployer] installing bean: ejb/cydoniaEJB.jar#BusinessGeneral,uid21064614
                              11:01:02,953 INFO [EjbDeployer] with dependencies:
                              11:01:02,953 INFO [EjbDeployer] and supplies:
                              11:01:02,953 INFO [EjbDeployer] jndi:BusinessGeneral
                              11:01:02,953 INFO [EjbDeployer] jndi:cydonia/BusinessGeneral
                              11:01:02,953 INFO [EjbDeployer] jndi:local/BusinessGeneral@29363912
                              11:01:03,078 INFO [EjbModule] Deploying Authentication
                              11:01:03,125 WARN [EjbModule] EJB configured to bypass security. Please verify if this is intended. Bean=Authentication Deployment=vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/cydonia.ear/cydoniaEJB.jar/
                              11:01:03,171 INFO [EjbModule] Deploying BusinessGeneral
                              11:01:03,187 WARN [EjbModule] EJB configured to bypass security. Please verify if this is intended. Bean=BusinessGeneral Deployment=vfsfile:/C:/apps/jboss-5.1.0.GA/server/all/deploy/cydonia.ear/cydoniaEJB.jar/
                              11:01:03,328 INFO [BaseLocalProxyFactory] Bound EJB LocalHome 'Authentication' to jndi 'local/Authentication@18850285'
                              11:01:03,328 INFO [ProxyFactory] Bound EJB Home 'Authentication' to jndi 'Authentication'
                              11:01:03,343 INFO [BaseLocalProxyFactory] Bound EJB LocalHome 'BusinessGeneral' to jndi 'local/BusinessGeneral@29363912'
                              11:01:03,343 INFO [ProxyFactory] Bound EJB Home 'BusinessGeneral' to jndi 'BusinessGeneral'
                              11:01:03,359 INFO [TomcatDeployment] deploy, ctxPath=/cydoniaWeb
                              11:01:04,718 INFO [TilesPlugin] Tiles definition factory loaded for module ''.
                              11:01:04,890 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
                              11:01:04,906 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
                              11:01:04,921 INFO [ServerImpl] JBoss (Microcontainer) [5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)] Started in 1m:1s:406ms
                              
                              


                              Again thanks everyone.

                              -Nam

                              • 12. Re: Configure DataSource for
                                jaikiran

                                 

                                my JSP test page is now successful even in the "all" server
                                (in both "exploded" and "packaged" deployment modes)!


                                Good to know :)

                                So I'm happy that it works though the "outstanding" issue is the
                                Admin console still shows the _incorrect_ status of the datasource.
                                Should one really care about that?


                                From the point of an end-user who doesn't use the admin console, you probably can ignore that. However, if that's what is being shown in the admin console, then its probably a bug. I remember a user reporting a similar issue with the admin console, a few days back. I haven't yet tried it myself, so not really sure what the issue is. If you find any more details in the server.log and if this is consistently reproduced with a sample application then feel free to create JIRA and attach that app there.


                                • 13. Re: Configure DataSource for
                                  nguyenjulian

                                   


                                  If you find any more details in the server.log and if this is consistently reproduced with a sample application then feel free to create JIRA and attach that app there.


                                  Thanks, Jaikiran. Let me try it out with a different database (say, MySQL).
                                  If the problem still persists, I'd create a JIRA.

                                  -Nam