acciente / oacc-db Goto Github PK

View Code? Open in Web Editor NEW

7.0 3.0 3.0 117 KB

Contains the SQL DDL scripts to create the OACC database tables for each supported database.

Home Page: http://oaccframework.org

License: Apache License 2.0

oacc-db's People

Contributors

Stargazers

Watchers

Forkers

inverselina dhaase balasubramanian-rengasamy

oacc-db's Issues

Change database name in create_database script for mysql to upper case

Make changes to database or schema for all the DB's to have consistent case, i.e. while executing the scripts on Ubuntu for Mysql create_tables.sql fail as the database name in the script is specified as upper case and where as in create_database script we have created the DB with lower case.

Can we check for all other scripts and DB to have database and schema to be consistence naming.

MySQL 5.7 tables are case-sensitive

The schema refers to OAC_ResourceExternalID (note the uppercase ID) while the Java code refers to OAC_ResourceExternalId. The oacc-core integration tests fail under MySQL 5.7.16:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: DELETE command denied to user 'oaccuser'@'10.0.2.2' for table 'OAC_ResourceExternalId'
java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'oaccuser'@'10.0.2.2' for table 'OAC_ResourceExternalId'

Will submit a pull request that passes integration tests.

Recommend Projects