1. Datasource file jboss-5.0\docs\examples\jca\mysql-ds.xml
2. persistance.xml file
Yes i deployed as jar file
3. jar -tf test1.jar
C:\test1>jar -tf test1.jar
META-INF/
META-INF/MANIFEST.MF
META-INF/persistence.xml
test/
test/entities/
test/entities/Book.java
test/session/
test/session/stateless/
test/session/stateless/BookSessionRemote.java
test/session/stateless/BookSessionRemoteBean.java
4. I placed my data source file in jboss-5.0\docs\examples\jca and its name is mysql-ds.xml
5. Jboss logs
C:\Uninstall\jboss-5.0\bin>run
===============================================================================
JBoss Bootstrap Environment
JBOSS_HOME: C:\Uninstall\jboss-5.0
JAVA: C:\Program Files\Java\jdk1.5.0_13\bin\java
JAVA_OPTS: -Dprogram.name=run.bat -server -Xms128m -Xmx512m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=
3600000
CLASSPATH: C:\Uninstall\jboss-5.0\bin\run.jar
===============================================================================
14:19:01,656 INFO [ServerImpl] Starting JBoss (Microcontainer)...
14:19:01,656 INFO [ServerImpl] Release ID: JBoss [
Morpheus] 5.0.0.CR1 (build: SVNTag=JBoss_5_0_0_CR1 date=200806301254)
14:19:01,656 INFO [ServerImpl] Home Dir: C:\Uninstall\jboss-5.0
14:19:01,656 INFO [ServerImpl] Home URL: file:/C:/Uninstall/jboss-5.0/
14:19:01,656 INFO [ServerImpl] Library URL: file:/C:/Uninstall/jboss-5.0/lib/
14:19:01,656 INFO [ServerImpl] Patch URL: null
14:19:01,656 INFO [ServerImpl] Server Name: default
14:19:01,656 INFO [ServerImpl] Server Home Dir: C:\Uninstall\jboss-5.0\server\default
14:19:01,671 INFO [ServerImpl] Server Home URL: file:/C:/Uninstall/jboss-5.0/server/default/
14:19:01,671 INFO [ServerImpl] Server Data Dir: C:\Uninstall\jboss-5.0\server\default\data
14:19:01,671 INFO [ServerImpl] Server Temp Dir: C:\Uninstall\jboss-5.0\server\default\tmp
14:19:01,671 INFO [ServerImpl] Server Config URL: file:/C:/Uninstall/jboss-5.0/server/default/conf/
14:19:01,671 INFO [ServerImpl] Server Library URL: file:/C:/Uninstall/jboss-5.0/server/default/lib/
14:19:01,671 INFO [ServerImpl] Root Deployment Filename: jboss-service.xml
14:19:03,312 INFO [ServerImpl] Starting Microcontainer, bootstrapURL=file:/C:/Uninstall/jboss-5.0/server/default/conf/bootstrap.xml
14:19:05,859 INFO [CopyMechanism] VFS temp dir: C:\Uninstall\jboss-5.0\server\default\tmp
14:19:05,859 INFO [ZipEntryContext] VFS force nested jars copy-mode is enabled.
14:19:09,093 INFO [ServerInfo] Java version: 1.5.0_13,Sun Microsystems Inc.
14:19:09,093 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.5.0_13-b05,Sun Microsystems Inc.
14:19:09,093 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
14:19:09,171 INFO [JMXKernel] Legacy JMX core initialized
14:19:11,031 INFO [MetaDataAwareProfile] Using profile root:C:\Uninstall\jboss-5.0\server\default
14:19:18,453 INFO [WebService] Using RMI server codebase:
http://127.0.0.1:8083/ 14:19:34,625 WARN [HackClassloaderMetaDataDeployer] FIXME Using loader repository config: jboss.console:sar=console-mgr.sar for vfsfile:/C:/Uninstall/jbo
ss-5.0/server/default/deploy/management/console-mgr.sar/ use classloading metadata not loader repository config
14:19:35,437 INFO [AspectDeployer] Deploying xml into org.jboss.aop.AspectManager@cb36fa for BaseClassLoader@3a71ed{vfsfile:/C:/Uninstall/jboss-5.0/server
/default/deploy/ejb3-interceptors-aop.xml}
14:20:13,984 INFO [JMXConnectorServerService] JMX Connector server: service:jmx:rmi://127.0.0.1/jndi/rmi://127.0.0.1:1090/jmxconnector
14:20:14,187 INFO [MailService] Mail Service bound to java:/Mail
14:20:14,218 WARN [JBossASSecurityMetadataStore] WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messa
ges 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.
14:20:15,000 INFO [TransactionManagerService] JBossTS Transaction Service (JTA version) - JBoss Inc.
14:20:15,000 INFO [TransactionManagerService] Setting up property manager MBean and JMX layer
14:20:15,515 INFO [TransactionManagerService] Starting recovery manager
14:20:15,843 INFO [TransactionManagerService] Recovery manager started
14:20:15,843 INFO [TransactionManagerService] Binding TransactionManager JNDI Reference
14:20:16,281 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.5.0_13\bin;.;C:\WINDOWS\system32;C:\WINDOWS;C:\Perl\site\bin;C:\Perl\bin;C:\Program Files\PC Connectivity So
lution\;C:\Program Files\Common Files\NetSarang;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\ActivCard\ActivCard Gold\resources
;C:\Program Files\Common Files\Teleca Shared;C:\Program Files\Common Files\Ulead Systems\MPEG;C:\Program Files\Java\jdk1.5.0_13\bin;C:\HP Clients;C:\HP Cli
ents\TeMIP Client V5.3 for Windows;C:\Program Files\IBM\Installation Manager\eclipse\lib;C:\Program Files\TeMIP Client V5.3 for Windows;;
14:20:16,343 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-127.0.0.1-8080
14:20:16,343 INFO [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-127.0.0.1-8009
14:20:16,343 INFO [Catalina] Initialization processed in 254 ms
14:20:16,343 INFO [StandardService] Starting service jboss.web
14:20:16,343 INFO [StandardEngine] Starting Servlet Engine: JBoss Web/2.1.1.CR3
14:20:16,406 INFO [Catalina] Server startup in 66 ms
14:20:16,750 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/Uninstall/jboss-5.0/server/default/deploy/jboss-local-jdbc.rar/META-INF/ra
.xml
14:20:16,765 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/Uninstall/jboss-5.0/server/default/deploy/jboss-xa-jdbc.rar/META-INF/ra.xm
l
14:20:16,812 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/Uninstall/jboss-5.0/server/default/deploy/jms-ra.rar/META-INF/ra.xml
14:20:16,828 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/Uninstall/jboss-5.0/server/default/deploy/mail-ra.rar/META-INF/ra.xml
14:20:16,890 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/Uninstall/jboss-5.0/server/default/deploy/quartz-ra.rar/META-INF/ra.xml
14:20:17,046 INFO [SimpleThreadPool] Job execution threads will use class loader of
thread: main
14:20:17,093 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
14:20:17,093 INFO [RAMJobStore] RAMJobStore initialized.
14:20:17,093 INFO [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.proper
ties'
14:20:17,093 INFO [StdSchedulerFactory] Quartz scheduler version: 1.5.2
14:20:17,109 INFO [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
14:20:17,968 INFO [NativeServerConfig] JBoss Web Services - Stack Native Core
14:20:17,984 INFO [NativeServerConfig] 3.0.2.GA
14:20:19,234 INFO [TomcatDeployment] deploy, ctxPath=/, vfsUrl=ROOT.war
14:20:19,781 INFO [TomcatDeployment] deploy, ctxPath=/jmx-console, vfsUrl=jmx-console.war
14:20:19,843 INFO [TomcatDeployment] deploy, ctxPath=/invoker, vfsUrl=http-invoker.sar/invoker.war
14:20:20,015 INFO [TomcatDeployment] deploy, ctxPath=/web-console, vfsUrl=management/console-mgr.sar/web-console.war
14:20:20,531 INFO [TomcatDeployment] deploy, ctxPath=/jbossws, vfsUrl=jbossws.sar/jbossws-management.war
14:20:20,671 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java

efaul
tDS'
14:20:21,078 WARN [QuartzTimerServiceFactory] sql failed: CREATE TABLE QRTZ_JOB_DETAILS(JOB_NAME VARCHAR(80) NOT NULL, JOB_GROUP VARCHAR(80) NOT NULL, DES
CRIPTION VARCHAR(120) NULL, JOB_CLASS_NAME VARCHAR(128) NOT NULL, IS_DURABLE VARCHAR(1) NOT NULL, IS_VOLATILE VARCHAR(1) NOT NULL, IS_STATEFUL VARCHAR(1) N
OT NULL, REQUESTS_RECOVERY VARCHAR(1) NOT NULL, JOB_DATA BINARY NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP))
14:20:21,156 INFO [SimpleThreadPool] Job execution threads will use class loader of thread: main
14:20:21,156 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
14:20:21,156 INFO [JobStoreCMT] Using db table-based data access locking (synchronization).
14:20:21,187 INFO [JobStoreCMT] Removed 0 Volatile Trigger(s).
14:20:21,187 INFO [JobStoreCMT] Removed 0 Volatile Job(s).
14:20:21,187 INFO [JobStoreCMT] JobStoreCMT initialized.
14:20:21,187 INFO [StdSchedulerFactory] Quartz scheduler 'JBossEJB3QuartzScheduler' initialized from an externally provided properties instance.
14:20:21,187 INFO [StdSchedulerFactory] Quartz scheduler version: 1.5.2
14:20:21,187 INFO [JobStoreCMT] Freed 0 triggers from 'acquired' / 'blocked' state.
14:20:21,203 INFO [JobStoreCMT] Recovering 0 jobs that were in-progress at the time of the last shut-down.
14:20:21,203 INFO [JobStoreCMT] Recovery complete.
14:20:21,203 INFO [JobStoreCMT] Removed 0 'complete' triggers.
14:20:21,203 INFO [JobStoreCMT] Removed 0 stale fired job entries.
14:20:21,203 INFO [QuartzScheduler] Scheduler JBossEJB3QuartzScheduler_$_NON_CLUSTERED started.
14:20:21,625 INFO [ServerPeer] JBoss Messaging 1.4.1.CR1 server [0] started
14:20:21,812 INFO [ConnectionFactory] Connector
bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
14:20:21,812 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@1e10abe started
14:20:21,828 INFO [ConnectionFactory] Connector
bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
14:20:21,828 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@e2dc4 started
14:20:21,843 WARN [ConnectionFactoryJNDIMapper] supportsFailover attribute is true on connection factory: jboss.messaging.connectionfactory:service=Cluste
redConnectionFactory but post office is non clustered. So connection factory will *not* support failover
14:20:21,843 WARN [ConnectionFactoryJNDIMapper] supportsLoadBalancing attribute is true on connection factory: jboss.messaging.connectionfactory:service=C
lusteredConnectionFactory but post office is non clustered. So connection factory will *not* support load balancing
14:20:21,843 INFO [ConnectionFactory] Connector
bisocket://127.0.0.1:4457 has leasing enabled, lease period 10000 milliseconds
14:20:21,843 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@e3144 started
14:20:21,859 INFO [QueueService] Queue[/queue/DLQ] started, fullSize=200000, pageSize=2000, downCacheSize=2000
14:20:21,875 INFO [QueueService] Queue[/queue/ExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
14:20:21,875 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:Jms
XA'
14:20:22,031 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
14:20:22,046 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
14:20:22,062 INFO [ServerImpl] JBoss (Microcontainer) [5.0.0.CR1 (build: SVNTag=JBoss_5_0_0_CR1 date=200806301254)] Started in 1m:20s:391ms
14:20:37,515 INFO [JBossASKernel] Created KernelDeployment for: test1.jar
14:20:37,531 INFO [JBossASKernel] installing bean: persistence.units:ear=test1.jar.ear,unitName=test1
14:20:37,531 INFO [JBossASKernel] with dependencies:
14:20:37,531 INFO [JBossASKernel] and demands:
14:20:37,531 INFO [JBossASKernel] jboss.jca:name=MySqlDS,service=DataSourceBinding
14:20:37,531 INFO [JBossASKernel] and supplies:
14:20:37,531 INFO [JBossASKernel] persistence.units:unitName=test1
14:20:37,531 INFO [JBossASKernel] Added bean(persistence.units:ear=test1.jar.ear,unitName=test1) to KernelDeployment of: test1.jar
14:20:37,546 WARN [HDScanner] Failed to process changes
org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):
*** CONTEXTS MISSING DEPENDENCIES: Name -> Dependency{Required State:Actual State}
persistence.units:ear=test1.jar.ear,unitName=test1
-> <UNKNOWN persistence.units:ear=test1.jar.ear,unitName=test1>{Described:** UNRESOLVED Demands 'jboss.jca:name=MySqlDS,service=DataSourceBinding' **}
*** CONTEXTS IN ERROR: Name -> Error
<UNKNOWN persistence.units:ear=test1.jar.ear,unitName=test1> -> ** UNRESOLVED Demands 'jboss.jca:name=MySqlDS,service=DataSourceBinding' **
at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(DeployersImpl.java:676)
at org.jboss.deployers.plugins.main.MainDeployerImpl.checkComplete(MainDeployerImpl.java:661)
at org.jboss.system.server.profileservice.hotdeploy.HDScanner.scan(HDScanner.java:291)
at org.jboss.system.server.profileservice.hotdeploy.HDScanner.run(HDScanner.java:221)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:280)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:135)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:65)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:142)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:166)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)
I put mysql connector jar file in jboss-5.0\server\default\lib and also in
jboss-5.0\lib. Jar file name is mysql-connector-java-5.1.3-rc-bin.jar, and i think it is compatible with jdk 1.5.
Looking forward for the reply,