Re: mysql error when upgrade from 1.8 to 1.10

2015-11-19 Thread Chuangyu
Thank you, Jeroen. If do not create schema manually, it can run so far, just ignore "create schema" errors. MySQL official document comment: CREATE SCHEMA is a synonym for CREATE DATABASE as of MySQL 5.0.2 I don't want to create separate database for isis addons. James 2015-11-16 23:51

Re: mysql error when upgrade from 1.8 to 1.10

2015-11-16 Thread Jeroen van der Wal
We actively use Apache Isis with HSQLDB, PostgreSQL and MS SQL Server and they all support separate schemas within the same database. I would like to see Apache Isis run without issues in the scenario you have but I don't want to lose the security that database schemas provide in preventing

Re: mysql error when upgrade from 1.8 to 1.10

2015-11-16 Thread Chuangyu
Hi Jeroen and Stephen, Thanks for your response. Jeroen ,your solution may not fit my scenario. I run 3 instance of this system but all 3 databases on one server .(eg. db1,db2,db3) Each instance has username/password separately.(eg, user1, user2, user3) If create schema on this server , all

mysql error when upgrade from 1.8 to 1.10

2015-11-16 Thread Chuangyu
Hi, I create a new 1.10 simple app and copy all code from 1.8 to 1.10. And made some change to fit new 1.10 specs. When start system , Eclipse show errors on console box. It seems each addon module occur one error. Below is one of errors: Unable to create schema