Eclipse Community Forums: EclipseLink » DDL generation without database access

Help

Home

Home » Eclipse Projects » EclipseLink » DDL generation without database access

Show: Today's Messages :: Show Polls :: Message Navigator

DDL generation without database access [message #378607]

Wed, 06 August 2008 12:59

Frank Schwarz

Messages: 26
Registered: July 2009
Location: Dresden

Junior Member

Is it possible to let EclipseLink write the SQL schema definition files
without accessing the database?

My approach so far still connects to the database:

String directory = args[0];
Map<String, String> properties = new HashMap<String, String>();
properties.put(PersistenceUnitProperties.DDL_GENERATION,
PersistenceUnitProperties.CREATE_ONLY);
properties.put(PersistenceUnitProperties.CREATE_JDBC_DDL_FIL E,
"create-tables.sql");
properties.put(PersistenceUnitProperties.DROP_JDBC_DDL_FILE,
"drop-tables.sql");
properties.put(PersistenceUnitProperties.DDL_GENERATION_MODE ,
PersistenceUnitProperties.DDL_SQL_SCRIPT_GENERATION);
properties.put(PersistenceUnitProperties.APP_LOCATION, directory);
properties.put(PersistenceUnitProperties.JDBC_READ_CONNECTIO NS_MIN, "0");
properties.put(PersistenceUnitProperties.JDBC_WRITE_CONNECTI ONS_MIN, "0");

System.setProperty(PersistenceUnitProperties.JAVASE_DB_INTER ACTION,
"false");

EntityManagerFactory entityManagerFactory =
Persistence.createEntityManagerFactory("default", properties);
entityManagerFactory.createEntityManager().close();
entityManagerFactory.close();

Is there a best practice for this usecase?

Kind regards
Frank

Report message to a moderator

Re: DDL generation without database access [message #378612 is a reply to message #378607]

Wed, 06 August 2008 13:28

James

Messages: 272
Registered: July 2009

Senior Member

EclipseLink will always connect to validate the login information and
connection. I don't know of any easy way to avoid any connection at all.
If you don't have any access to a database, you could just connect to a
dummy in-memory database, or use a SessionCustomizer to configure your own
dummy Connector in the EclipseLink DatabaseLogin.

-- James

Report message to a moderator