Mysql
lavoir Sep 29, 2005 2:47 PMI tried changing persistence to Mysql and the shema is not being created.
Am I missing something?
Copied mysql-connector-java-3.1.10-bin.jar to C:\jboss-jdk5-seam-403RC2\server\default\lib
<datasources> <local-tx-datasource> <jndi-name>bookingDatasource</jndi-name> <connection-url>jdbc:mysql://localhost:3306/booking</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>root</user-name> <password></password> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>
<entity-manager> <name>bookingDatabase</name> <provider>org.hibernate.ejb.HibernatePersistence</provider> <jta-data-source>java:/bookingDatasource</jta-data-source> <properties> <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" /> <property name="hibernate.case.use_query_cache">true</property> <property name="hibernate.show_sql">false</property> <property name="hibernate.hbm2ddl.auto">create</property> <property name="hibernate.connection.datasource" value="java:/bookingDatasource"/> </properties> </entity-manager>
<?xml version="1.0" encoding="UTF-8"?> <deployment xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:jboss:bean-deployer bean-deployer_1_0.xsd" xmlns="urn:jboss:bean-deployer"> <bean name="bookingDatasourceBootstrap" class="org.jboss.resource.adapter.jdbc.local.LocalTxDataSource"> <property name="driverClass">com.mysql.jdbc.Driverr</property> <property name="connectionURL">jdbc:mysql://localhost:3306/booking</property> <property name="userName">root</property> <property name="password"></property> <property name="jndiName">java:/bookingDatasource</property> <property name="minSize">0</property> <property name="maxSize">10</property> <property name="blockingTimeout">1000</property> <property name="idleTimeout">100000</property> <property name="transactionManager"><inject bean="TransactionManager"/></property> <property name="cachedConnectionManager"><inject bean="CachedConnectionManager"/></property> <property name="initialContextProperties"><inject bean="InitialContextProperties"/></property> </bean> <bean name="bookingDatasource" class="java.lang.Object"> <constructor factoryMethod="getDatasource"> <factory bean="bookingDatasourceBootstrap"/> </constructor> </bean> </deployment>