EJB in action - Chapter 2 EAR file error

[Abhay Agarwal]

Hi

I am trying to run EJB3 in action Chapter 2 code.

I am using Jboss version 5.
Instead of using default DB(hypersonic), i configured MySQL DB with my JBOSS.

I ran ant script to build an EAR file for Chapter 2 code and then i placed the EAR file on Jboss'deploy folder. On placing EAR file, i get below mentioned error on command prompt

"Deployment "vfszip:/C:/jboss-5.0.1.GA/server/default/deploy/chapter2.ear/" is in error due to the following reason(s): org.jboss.xb.binding.JBossXBRuntimeException: Failed to resolve schema nsURI= location=persistence"

I found that my persistence.xml is having Hypersonic DB settings.

<persistence>
	<persistence-unit name="actionBazaar">
		<jta-data-source>java:/DefaultDS</jta-data-source>
		<properties>
			<property name="hibernate.dialect"
				value="org.hibernate.dialect.HSQLDialect" />
			<property name="hibernate.hbm2ddl.auto" value="update" />
		</properties>
	</persistence-unit>
</persistence>

Please let me how can i configure my persistence.xml according to MySQL so that Chapter 2 EAR file is deployed successfully

Thanks

[Davide Crudo]

Hi,

My persistence.xml (for O'reilly, but working on jboss 5.x) looks like the following:

   
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">

 <persistence-unit name="titanDB">
 <jta-data-source>java:/titanDS</jta-data-source>
 <properties>
 <property name="hibernate.hbm2ddl.auto" value="create" />
 </properties>
 </persistence-unit>
</persistence>

Then, under the JBOSS server directory"../Server/Default/Deploy" directory, i put my "titan-ds.xml" file that looks
like the following:

 
<datasources>
    <local-tx-datasource>
        <jndi-name>titanDS</jndi-name>
        <connection-url>jdbc:mysql://192.168.1.199:3306/titan</connection-url>
        <driver-class>com.mysql.jdbc.Driver</driver-class>
        <user-name>your_username</user-name>
        <password>your_password</password>

        <min-pool-size>5</min-pool-size>
        <max-pool-size>20</max-pool-size>
        <idle-timeout-minutes>5</idle-timeout-minutes>

 <exception-sorter-class-name>
  com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter
        </exception-sorter-class-name>
        <valid-connection-checker-class-name>
  com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker
        </valid-connection-checker-class-name>

    </local-tx-datasource>
</datasources> 

Note that when I've switched to Jboss 5.x...I had to rewrite the XML files... you cannot apparently using the
old XML for version 4.x with the new version...

Dave