MYSQL Support

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Download and install aribaweb 5.0 rc1
2. Create application using master-detail example (java) 
3. Copy mysql connector in jpa lib folder
4. Change persistence parameters in build.xml to use MySQL 

<property value="com.mysql.jdbc.Driver"
name="hibernate.connection.driver_class"/>
<property value="jdbc:mysql://localhost/aribaweb"
name="hibernate.connection.url"/>
<property value="aribaweb" name="hibernate.connection.username"/>
<property value="aribawebpw" name="hibernate.connection.password"/>
<property value="org.hibernate.dialect.MySQLInnoDBDialect"
name="hibernate.dialect"/>
<property value="update" name="hibernate.hbm2ddl.auto" />

What is the expected output? What do you see instead?

Does not work for the followin reasons: 
1. password is not used in presistence.xml (connection error)
2. cannot create Global tables ("key" is a reserved keyword in mysql) 

What version of the product are you using? On what operating system?
aribaweb 5.0.RC1
MySQL 5.1

Proposed fix (for each issue)
1. Add the following line in aribaweb-5.0RC1/tools/templates
<property name="hibernate.connection.password"
                    value="$hibernate.connection.password"/>

2. Rename the "key" column mapping in Global.java
@Column(name="thekey")
    String key;

Hope that helps.
Then it works like a charm. Thanks.

Original issue reported on code.google.com by ope...@gmail.com on 22 Feb 2009 at 10:25

[GoogleCodeExporter]

Thanks, will try your fix, and include in the next release.

-Kingsley

Original comment by Ariba...@gmail.com on 22 Feb 2009 at 10:52

• Changed state: Investigating

[GoogleCodeExporter]

Original comment by Ariba...@gmail.com on 22 Feb 2009 at 10:52

[GoogleCodeExporter]

Fixed: http://code.google.com/p/aribaweb/source/detail?spec=svn22&r=16

Original comment by kingsley...@gmail.com on 4 May 2009 at 9:47

• Changed state: Fixed