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