Eclipse Community Forums: EclipseLink » Getting update DDL with SchemaManager

Help

Home

Home » Eclipse Projects » EclipseLink » Getting update DDL with SchemaManager

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

Getting update DDL with SchemaManager [message #872582]

Wed, 16 May 2012 11:51

Emmanuel Comba

Messages: 3
Registered: May 2012

Junior Member

Hello,

For a project I need to get and display the create DDL and Update DDL for the entities included in an EAR on a J2EE Server (Glassfish).
With the following code I get the create DDL without problem:

...
Map<String, Object> properties = new HashMap<String, Object>();

// Enable DDL Generation
properties.put(PersistenceUnitProperties.DDL_GENERATION, PersistenceUnitProperties.NONE);
properties.put(PersistenceUnitProperties.CREATE_JDBC_DDL_FILE, "EclipseLink_DDL.sql");
properties.put(PersistenceUnitProperties.DDL_GENERATION_MODE, PersistenceUnitProperties.DDL_SQL_SCRIPT_GENERATION);

//eManager is the injected EntityManager with @PersistenceContext
ServerSession session = eManager.unwrap(ServerSession.class);  
SchemaManager schemaManager = new SchemaManager(session);  
    			
schemaManager.setCreateSQLFiles(true);
StringWriter w = new StringWriter();

schemaManager.outputDDLToWriter(w);
schemaManager.createDefaultTables(true);
String s =w.toString();
...

Now I need the same to be able to generate an Update DDL. It seems the SchemaManager Class does not support it yet.
Is there a solution for that ?

Thanks a lot in advance!

Report message to a moderator

Re: Getting update DDL with SchemaManager [message #872669 is a reply to message #872582]

Wed, 16 May 2012 15:10

Chris Delahunt

Messages: 1389
Registered: July 2009

Senior Member

No there doesn't seem to be a way other than to grab the SQL that gets logged. Please file a bug/feature request.

Best Regards,
Chris

Report message to a moderator

Re: Getting update DDL with SchemaManager [message #872879 is a reply to message #872669]

Thu, 17 May 2012 02:05

Emmanuel Comba

Messages: 3
Registered: May 2012

Junior Member

Thanks a lot!
I have created the following Bug/Feature Request #379774

I think it will be implemented in EclipseLink 2.4:
wiki.eclipse.org/EclipseLink/DesignDocs/368365

Thus I am not sure the new implemented feature will allow getting the Update DDL in a Writer...

Regards

Emmanuel Comba

Report message to a moderator

Re: Getting update DDL with SchemaManager [message #873249 is a reply to message #872879]

Thu, 17 May 2012 19:54

Chris Delahunt

Messages: 1389
Registered: July 2009

Senior Member

The feature as it stands for 2.4 will not use a writer - this is listed in the limitations in the design doc. The reason was that the feature requires database access, while the outputDDLToWriter methods are generally used when it is not connected.

Please remember to vote for 379774.

Best Regards,
Chris

Report message to a moderator