[jboss-as7-dev] Help with ClusterJPA & OpenJPA

[Mohammad Alkahtani]

 I'm trying to do J2EE version of this tutorial which J2SE
http://www.clusterdb.com/mysql-cluster/using-clusterjpa-part-of-mysql-cluster-connector-for-java-a-tutorial
I installed OpenJPA as module in JBoss add the MySQL JDBC datasource
to JBoss AS 7 then I run my application with persistence.xml
<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.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_2_0.xsd">
  <persistence-unit name="SQLTPU" transaction-type="JTA">
    <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
       <jta-data-source>java:/mcube/DefaultDS</jta-data-source>

 <class>org.ksu.SQLT.entities.Employee</class>
 <class>org.ksu.SQLT.entities.Department</class>
 <properties>

 <property name="jboss.as.jpa.providerModule" value="org.apache.openjpa" />
<!--   IMPORTANT PROPERTIES   -->
           <property name="openjpa.DynamicEnhancementAgent" value="false"/>
           <property name="openjpa.RuntimeUnenhancedClasses"
value="supported" />
<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema(ForeignKeys=true)" />
     <!-- <property name="openjpa.jdbc.DBDictionary" value="mysql" /> !-->
<property name="openjpa.ConnectionDriverName"
 value="com.mysql.jdbc.Driver" />
 <property name="openjpa.ConnectionURL"
 value="jdbc:mysql://192.168.1.13:3306/clusterdb" />
 <property name="openjpa.ConnectionUserName" value="root" />
 <property name="openjpa.ConnectionPassword" value="Password" />
 <property name="openjpa.BrokerFactory"
value="com.mysql.clusterj.openjpa.NdbOpenJPABrokerFactory" />
 <property name="openjpa.jdbc.DBDictionary" value="TableType=ndbcluster" />
 <property name="openjpa.ndb.connectString" value="192.168.1.13:1186" />
 <property name="openjpa.ndb.database" value="clusterdb" />
 </properties>
 </persistence-unit>
</persistence>

I add the .jar files ClusterJPA, ClusterJ and ClusterAPI to the
project library folder in NetBeans. the application deployed but dose
not create the tables in the database