Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate ver 3.1:

No Mapping docs-have to do it in coding ony!! :





Oracle/MySQL


Hi , I need to create database programmatically without using any mapping files/config files...
Do reply at [email protected]

Thanks...





Read this: http://hibernate.org/42.html

Here we go,


public void CreateDB(String dbname) throws SQLException{
try{
System.out.println("INSIDE CREATEDB()...");
org.hibernate.connection.DriverManagerConnectionProvider cn=new org.hibernate.connection.DriverManagerConnectionProvider();
Properties p=new Properties();
//p.setProperty("hibernate.connection.url", "jdbc:mysql://localhost:3306/db1");
p.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLInnoDBDialect");
p.setProperty("hibernate.connection.driver_class", "com.mysql.jdbc.Driver");
p.setProperty("hibernate.connection.username","root");
p.setProperty("hibernate.connection.password","root");
p.setProperty("hibernate.connection.url","jdbc:mysql://localhost:3306/temp");
p.setProperty("hibernate.order_updates", "true");
p.setProperty("hibernate.show_sql", "true");
p.setProperty("hibernate.format_sql", "true");
p.setProperty("hibernate.generate_statistics", "true");
p.setProperty("hibernate.use_sql_comments", "true");
p.setProperty("hibernate.connection.autocommit", "true");
cn.configure(p);
cn.getConnection().setCatalog("db1");
String sql="CREATE DATABASE IF NOT EXISTS "+dbname;
System.out.println("Executing..."+sql);
cn.getConnection().createStatement().execute(sql);
System.out.println("Execution Completed!!");
cn=null;
p=null;
}catch(Exception e){
System.err.println("Error in CreateDB()!!");
e.printStackTrace();
}
}


Nisarg Panchal

[email protected]
Gateway Techno Labs Pvt Ltd