[ http://jira.jboss.com/jira/browse/EJBTHREE-90?page=history ]
Bill Burke closed EJBTHREE-90:
------------------------------
Resolution: Rejected
You have to change the hibernate.properties file to use the mySql dialect
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-development
