[ http://jira.jboss.com/jira/browse/EJBTHREE-90?page=comments#action_12315968 ] Jens Elkner commented on EJBTHREE-90: -------------------------------------
OK. I've also found in the forum, that one can use a hibernate.properties file per application. But I'm wondering, what than the <type-mapping> in the datasource is used for. Can you enlighten me a little bit ? > 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