[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[xmlblaster] MySql persistance.
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.
If you want to list all tables you need to show databases, enumerate
through the databases with setCatalog and list tables with show tables;.