I'm trying some Ultralite's funcionalities that is supposed
to throw warnings.
Here a little code snippet about what I'm doing in my application:
ps = conn.prepareStatement("ALTER DATABASE SCHEMA FROM FILE '" + "'f.getAbsolutePath() + "'"); ps.execute();
I have to know if any warning was logged in the command's execution above.
At this time there is no way to get warnings from the UltraLiteJ API. We recognize this as a deficiency, and plan to address it by adding an API to get the last SQL warning code in the Connection class.
Regarding the SQLE ROW DROPPED DURING SCHEMA UPGRADE warning that could be generated as a result of the ALTER DATABASE SCHEMA FROM FILE statement, the best workaround that I can offer at this time is to do pre-checks for multiple rows with the same value if you are adding a uniqueness constraint, before you do the schema upgrade.
Thank you for your feedback.
answered 17 Jan '12, 10:00