I'm familiar with the java.sql.DatabaseMetaData interface, but I find it quite clunky to use. For example, in order to find out the table names, you have to call getTables and loop through the returned ResultSet, using well-known literals as the column names. Is there an easier way to obtain database metadata? ...
When trying to use DDLUtils it always seems to take over the id values for the columns that are set to autoincrement. How can I prevent this? For example, I have a Dogs table with a column called ownerID. The column ownerID is set to autoincrement. However my list of owners is not continuous, there are gaps (for example, ownerID's 2, 4,...
I'm looking for a lightweight, open source, more or less cross-database Java library that would allow me to read off metainformation on columns, tables and integrity constraints given a DataSource. ...
I am not able to read oracle database with ddlutils and getting following error: java.lang.NullPointerException at org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:573) at org.apache.ddlutils.platform.oracle.Oracle8ModelReader.readTable(Oracle8ModelReader.java:102) at org.apache.ddlutils.platform.JdbcModelR...
I have built several applications using Eclipselink and the EL Workbench to generate entity files and all necessary configuration as a deploy.xml file. For my next project, I would like to be able to modify the deploy.xml at runtime, using some sort of XML API, and be able to generate the revised entity files and ideally manipulate the ...
Is there any possibility to create unique column constraint using DDLUtils ? I have not found it in API. Is there other solution then altering table (add unique) just a second after its creation on my own ? ...