Schema export does not honor DS mapping ---------------------------------------
Key: EJBTHREE-90 URL: http://jira.jboss.com/jira/browse/EJBTHREE-90 Project: EJB 3.0 Type: Bug Versions: Preview 4 Environment: Linux, JDK 1.5.0_01, JBoss 4.0.1sp1 Reporter: Jens Elkner I've setup the DefaultDS to use mysqldb and hus to use the mySQL mappings. Trying the callback example listed in the ebj3 docs, I get the following error: 18:58:40,341 INFO [DatasourceConnectionProvider] Using datasource: java:/DefaultDS 18:58:40,345 ERROR [SchemaExport] Unsuccessful: create table CUSTOMER (id integer generated by default as identity (start with 1), STATE varchar(255), FIRST varchar(255), LAST varchar(255), STREET varchar(255), CITY varchar(255), ZIP varchar(255), primary key (id)) 18:58:40,345 ERROR [SchemaExport] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'generated by default as identity (start with 1), STATE varchar(255), FIRST varch' at line 1 18:58:40,345 INFO [SchemaExport] schema export complete 18:58:40,348 INFO [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect 18:58:40,348 INFO [Configuration] processing extends queue ... So the schema stuff uses HSQLDB mappings, insteadof the given mapping in the DS descriptor and finally produces invalid MySQL statements: <datasources> <local-tx-datasource> <jndi-name>DefaultDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/web</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>foo</user-name> <password>bar</password> <connection-property name="autoReconnect">true</connection-property> <connection-property name="autoReconnectForPools" >true</connection-property> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources> -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development