Has anyone actually tried to make the persistance layer work with MySql db?
I do not think this code from JdbcManagerCommonTable.java public final boolean tablesCheckAndSetup(boolean createTables) Line 377,7 will work with MySql.
String req = "SELECT count(*) from " + tablesTxt + " where upper(" + tableNameTxt + ")='" + this.nodesTableName.toUpperCase() + "'";
I find no reference to a table that holds a list of tables (tableTxt) like postgres (pg_tables) and Oracle (ALL_TABLES) obviously do....
Mysql uses an sql statement that only shows tables in the current db. Show Tables;
If you want to list all tables you need to show databases, enumerate through the databases with setCatalog and list tables with show tables;.
Thoughts??????
Regards
