1 19 20 package org.efs.openreports.util.schema; 21 22 import java.io.FileWriter ; 23 import java.io.IOException ; 24 25 import org.hibernate.cfg.Configuration; 26 import org.hibernate.dialect.*; 27 28 public class SchemaGenerator 29 { 30 public static void main(String [] args) 31 { 32 try 33 { 34 Configuration cfg = new Configuration().configure(); 35 36 String [] scripts = cfg.generateSchemaCreationScript(new HSQLDialect()); 37 writeFile("or_ddl_hsqldb.sql", scripts); 38 39 scripts = cfg.generateSchemaCreationScript(new MySQLDialect()); 40 writeFile("or_ddl_mysql.sql", scripts); 41 42 scripts = cfg.generateSchemaCreationScript(new SybaseDialect()); 43 writeFile("or_ddl_sybase.sql", scripts); 44 45 scripts = cfg.generateSchemaCreationScript(new DB2Dialect()); 46 writeFile("or_ddl_db2.sql", scripts); 47 48 cfg = new Configuration().configure(); 50 51 scripts = cfg.generateSchemaCreationScript(new PostgreSQLDialect()); 52 writeFile("or_ddl_postgre.sql", scripts); 53 54 scripts = cfg.generateSchemaCreationScript(new Oracle9Dialect()); 55 writeFile("or_ddl_oracle.sql", scripts); 56 57 cfg = new Configuration().configure(); 59 60 scripts = cfg.generateSchemaCreationScript(new SQLServerDialect()); 61 writeFile("or_ddl_sqlserver.sql", scripts); 62 63 cfg = new Configuration().configure(); 65 66 scripts = cfg.generateSchemaCreationScript(new DerbyDialect()); 67 writeFile("or_ddl_derby.sql", scripts); 68 } 69 catch(Exception e) 70 { 71 e.printStackTrace(); 72 } 73 } 74 75 private static void writeFile(String fileName, String [] scripts) throws IOException 76 { 77 FileWriter writer = new FileWriter (fileName); 78 79 for (int i=0; i < scripts.length; i++) 80 { 81 writer.write(scripts[i] + "\n\n"); 82 } 83 84 writer.flush(); 85 writer.close(); 86 } 87 } 88 89 | Popular Tags |