1 Reply Latest reply on Jul 23, 2010 11:43 AM by Peter Johnson

    I have got this error configuring jboss4.2.3 with mysql

    amit ambre Newbie

      Step I done to configured mysql to jboss

       

      1)  Copy the .jar file  mysql-connector-java-5.1.5-bin.jar to the /server/default/lib directory.

       

         2) To use the MySQL data source, copy /docs/examples/jca/mysql-ds.xml to the /server/default/deploy directory. Modify the mysql-ds.xml configuration file by setting <driver-class/> to com.mysql.jdbc.Driver and <connection-url/> to jdbc:mysql://<mysqlhost>/<database></connection-url>

       

       

      1)  11:38:40,593 INFO  [Server] Starting JBoss (MX MicroKernel)...

      11:38:40,609 INFO  [Server] Release ID: JBoss [Trinity] 4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181439)

      11:38:40,625 INFO  [Server] Home Dir: H:\all drive\Amit New Adv\jboss-4.2.3.GA-jdk6.zip\jboss-4.2.3.GA

      11:38:40,625 INFO  [Server] Home URL: file:/H:/all drive/Amit New Adv/jboss-4.2.3.GA-jdk6.zip/jboss-4.2.3.GA/

      11:38:40,625 INFO  [Server] Patch URL: null

      11:38:40,625 INFO  [Server] Server Name: default

      11:38:40,625 INFO  [Server] Server Home Dir: H:\all drive\Amit New Adv\jboss-4.2.3.GA-jdk6.zip\jboss-4.2.3.GA\server\default

      11:38:40,703 INFO  [Server] Server Home URL: file:/H:/all drive/Amit New Adv/jboss-4.2.3.GA-jdk6.zip/jboss-4.2.3.GA/server/default/

      11:38:40,703 INFO  [Server] Server Log Dir: H:\all drive\Amit New Adv\jboss-4.2.3.GA-jdk6.zip\jboss-4.2.3.GA\server\default\log

      11:38:40,703 INFO  [Server] Server Temp Dir: H:\all drive\Amit New Adv\jboss-4.2.3.GA-jdk6.zip\jboss-4.2.3.GA\server\default\tmp

      11:38:40,703 INFO  [Server] Root Deployment Filename: jboss-service.xml

      11:38:42,046 INFO  [ServerInfo] Java version: 1.6.0_07,Sun Microsystems Inc.

      11:38:42,046 INFO  [ServerInfo] Java VM: Java HotSpot(TM) Client VM 10.0-b23,Sun Microsystems Inc.

      11:38:42,046 INFO  [ServerInfo] OS-System: Windows XP 5.1,x86

      11:38:43,281 INFO  [Server] Core system initialized

      11:38:48,703 INFO  [WebService] Using RMI server codebase: http://127.0.0.1:8083/

      11:38:48,718 INFO  [Log4jService$URLWatchTimerTask] Configuring from URL: resource:jboss-log4j.xml

      11:38:50,156 INFO  [TransactionManagerService] JBossTS Transaction Service (JTA version) - JBoss Inc.

      11:38:50,156 INFO  [TransactionManagerService] Setting up property manager MBean and JMX layer

      11:38:50,968 INFO  [TransactionManagerService] Starting recovery manager

      11:38:51,328 INFO  [TransactionManagerService] Recovery manager started

      11:38:51,328 INFO  [TransactionManagerService] Binding TransactionManager JNDI Reference

      11:38:59,093 INFO  [EJB3Deployer] Starting java:comp multiplexer

      11:39:06,625 INFO  [NativeServerConfig] JBoss Web Services - Native

      11:39:06,625 INFO  [NativeServerConfig] jbossws-3.0.1-native-2.0.4.GA (build=200803312044)

      11:39:10,406 INFO  [Embedded] Catalina naming disabled

      11:39:11,859 INFO  [AprLifecycleListener] The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.6.0_07\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Program Files/Java/jdk1.6.0_07/bin/../jre/bin/client;C:/Program Files/Java/jdk1.6.0_07/bin/../jre/bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Java\jdk1.6.0_07\bin;C:\Program Files\Common Files\Ahead\Lib\

      11:39:12,156 INFO  [Http11Protocol] Initializing Coyote HTTP/1.1 on http-127.0.0.1-8080

      11:39:12,156 INFO  [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-127.0.0.1-8009

      11:39:12,156 INFO  [Catalina] Initialization processed in 1743 ms

      11:39:12,171 INFO  [StandardService] Starting service jboss.web

      11:39:12,187 INFO  [StandardEngine] Starting Servlet Engine: JBossWeb/2.0.1.GA

      11:39:12,406 INFO  [Catalina] Server startup in 245 ms

      11:39:13,203 INFO  [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jboss-web.deployer/ROOT.war/

      11:39:16,546 INFO  [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/http-invoker.sar/invoker.war/

      11:39:17,125 INFO  [TomcatDeployer] deploy, ctxPath=/jbossws, warUrl=.../deploy/jbossws.sar/jbossws-context.war/

      11:39:17,546 INFO  [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/

      11:39:21,187 INFO  [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/

      11:39:23,328 INFO  [MailService] Mail Service bound to java:/Mail

      11:39:23,828 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar

      11:39:23,953 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar

      11:39:24,062 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar

      11:39:24,531 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar

      11:39:24,765 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar

      11:39:24,859 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/mail-ra.rar

      11:39:25,000 INFO  [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/quartz-ra.rar

      11:39:25,031 INFO  [QuartzResourceAdapter] start quartz!!!

      11:39:25,250 INFO  [SimpleThreadPool] Job execution threads will use class loader of thread: main

      11:39:25,343 INFO  [QuartzScheduler] Quartz Scheduler v.1.5.2 created.

      11:39:25,359 INFO  [RAMJobStore] RAMJobStore initialized.

      11:39:25,390 INFO  [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'

      11:39:25,390 INFO  [StdSchedulerFactory] Quartz scheduler version: 1.5.2

      11:39:25,390 INFO  [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.

      11:39:25,968 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MySqlDS' to JNDI name 'java:MySqlDS'

      11:39:26,406 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'

      11:39:26,484 INFO  [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/

      11:39:26,906 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

       

      --- MBeans waiting for other MBeans ---

      ObjectName: jboss.ejb:service=EJBTimerService,persistencePolicy=database

        State: CONFIGURED

        I Depend On:

          jboss.jca:service=DataSourceBinding,name=DefaultDS

       

      ObjectName: jboss.mq:service=InvocationLayer,type=HTTP

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=Invoker

          jboss.web:service=WebServer

       

      ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo

        State: CONFIGURED

        I Depend On:

          jboss:service=TransactionManager

          jboss.jca:service=DataSourceBinding,name=DefaultDS

       

      ObjectName: jboss.mq:service=StateManager

        State: CONFIGURED

        I Depend On:

          jboss.jca:service=DataSourceBinding,name=DefaultDS

        Depends On Me:

          jboss.mq:service=DestinationManager

       

      ObjectName: jboss.mq:service=DestinationManager

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=MessageCache

          jboss.mq:service=PersistenceManager

          jboss.mq:service=StateManager

          jboss.mq:service=ThreadPool

          jboss:service=Naming

        Depends On Me:

          jboss.mq.destination:service=Topic,name=testTopic

          jboss.mq.destination:service=Topic,name=securedTopic

          jboss.mq.destination:service=Topic,name=testDurableTopic

          jboss.mq.destination:service=Queue,name=testQueue

          jboss.mq.destination:service=Queue,name=A

          jboss.mq.destination:service=Queue,name=B

          jboss.mq.destination:service=Queue,name=C

          jboss.mq.destination:service=Queue,name=D

          jboss.mq.destination:service=Queue,name=ex

          jboss.mq:service=SecurityManager

          jboss.mq.destination:service=Queue,name=DLQ

       

      ObjectName: jboss.mq:service=PersistenceManager

        State: CONFIGURED

        I Depend On:

          jboss.jca:service=DataSourceBinding,name=DefaultDS

        Depends On Me:

          jboss.mq:service=DestinationManager

       

      ObjectName: jboss.mq.destination:service=Topic,name=testTopic

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=DestinationManager

          jboss.mq:service=SecurityManager

       

      ObjectName: jboss.mq.destination:service=Topic,name=securedTopic

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=DestinationManager

          jboss.mq:service=SecurityManager

       

      ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=DestinationManager

          jboss.mq:service=SecurityManager

       

      ObjectName: jboss.mq.destination:service=Queue,name=testQueue

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=DestinationManager

          jboss.mq:service=SecurityManager

       

      ObjectName: jboss.mq.destination:service=Queue,name=A

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=DestinationManager

       

      ObjectName: jboss.mq.destination:service=Queue,name=B

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=DestinationManager

       

      ObjectName: jboss.mq.destination:service=Queue,name=C

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=DestinationManager

       

      ObjectName: jboss.mq.destination:service=Queue,name=D

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=DestinationManager

       

      ObjectName: jboss.mq.destination:service=Queue,name=ex

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=DestinationManager

       

      ObjectName: jboss.mq:service=Invoker

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=TracingInterceptor

          jboss:service=Naming

        Depends On Me:

          jboss.mq:service=InvocationLayer,type=HTTP

          jboss.mq:service=InvocationLayer,type=JVM

          jboss.mq:service=InvocationLayer,type=UIL2

       

      ObjectName: jboss.mq:service=TracingInterceptor

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=SecurityManager

        Depends On Me:

          jboss.mq:service=Invoker

       

      ObjectName: jboss.mq:service=SecurityManager

        State: CONFIGURED

        I Depend On:

          jboss.security:service=JaasSecurityManager

          jboss.mq:service=DestinationManager

        Depends On Me:

          jboss.mq.destination:service=Topic,name=testTopic

          jboss.mq.destination:service=Topic,name=securedTopic

          jboss.mq.destination:service=Topic,name=testDurableTopic

          jboss.mq.destination:service=Queue,name=testQueue

          jboss.mq:service=TracingInterceptor

          jboss.mq.destination:service=Queue,name=DLQ

       

      ObjectName: jboss.mq.destination:service=Queue,name=DLQ

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=DestinationManager

          jboss.mq:service=SecurityManager

       

      ObjectName: jboss.mq:service=InvocationLayer,type=JVM

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=Invoker

       

      ObjectName: jboss.mq:service=InvocationLayer,type=UIL2

        State: CONFIGURED

        I Depend On:

          jboss.mq:service=Invoker

       

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---

      ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS

        State: NOTYETINSTALLED

        Depends On Me:

          jboss.ejb:service=EJBTimerService,persistencePolicy=database

          jboss:service=KeyGeneratorFactory,type=HiLo

          jboss.mq:service=StateManager

          jboss.mq:service=PersistenceManager

       

       

      11:39:27,234 INFO  [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080

      11:39:27,437 INFO  [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009

      11:39:27,578 INFO  [Server] JBoss (MX MicroKernel) [4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181439)] Started in 46s:875ms