I am not sure if this is the only way to do it. When I struggled with hbm2ddl I found that this was working alternative. However, I also ran into some problems with it. Some of my statements worked just fine. I had no problems creating several DB VIEWs in that way. But when I tried to create some triggers I only could create one. If I tried to create more then one it just failed no matter what I did. I tried to separate my statements into separate files and tried all kind of other things but nothing helped. As for portability - since as you already noticed you have to write SQL yourself portability is totally up to you. If the SQL you write is portable then it will work on other DBs if your SQL is DB specific then no. If you are not good enough with writting SQLs consult your DBA. As far as Hibernate supporting <database-object> tag - I do believe it is DB independed. As far as my problem that I described above I had to resort to not so pretty solution. I created a standalone java program that loads up current Hibernate.cfg file and adds hbm2ddl property hardcoded. (I removed that property from my cfg file). Then I open and close hibernate session. That creates my db structure. Then I run a method in which I use jdbc to create some extra db objects. You can of course use the same to alter the objects. Here is a sample of my code:
package <package_name>;
import ...;
.....
public class SetupDb {
/**
* @param args
* @throws IOException
* @throws FileNotFoundException
*/
public static void main(String[] args) throws FileNotFoundException,
IOException {
Configuration cfg = new Configuration();
Properties props = new Properties();
props.load(new FileReader(<FULL_PROPERTIES_FILE_NAME>);
cfg.setProperties(props);
cfg.setProperty("hibernate.hbm2ddl.auto", "create");
cfg.configure();
SessionFactory sf = cfg.buildSessionFactory();
Session sess = sf.openSession();
sess.close();
createTriggers(props);
}
private static void createTriggers(Properties props) {
String sqlStatement1 = "...";
String sqlStatement2 = "...";
String sqlStatement3 = "...";
try {
OracleDataSource ods = new OracleDataSource();
ods.setURL(props.getProperty("hibernate.connection.url"));
ods.setUser(props.getProperty("hibernate.connection.username"));
ods.setPassword(props.getProperty("hibernate.connection.password"));
Statement stmt = ods.getConnection().createStatement();
stmt.execute(sqlStatement1);
stmt.execute(sqlStatement2);
stmt.execute(sqlStatement3);
} catch (SQLException se) {
se.printStackTrace();
}
}
}
Login
FAQ
Search
