[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.
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;.