Eclipse Community Forums: EclipseLink » ddl-generation separator

Help

Home

Home » Eclipse Projects » EclipseLink » ddl-generation separator

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

ddl-generation separator [message #384365]

Mon, 29 December 2008 11:24

Neuhauser Bernhard

Messages: 4
Registered: July 2009

Junior Member

Hi again,

Is it possible to specify a separator for the ddl file generation? (for
both output files: drop.sql and create.sql)

EclipseLink generates files like:
DROP TABLE A
DROP SEQUENCE A

Personally i expected that it should be like:
DROP TABLE A;
DROP SEQUENCE A;

I hoped that the ddl generator would add such separators depending on
the chosen targetDatabase. Is there a way to convince eclipseLink to add
; at the end of every sql statement?

regards,
Bernhard

Report message to a moderator

Re: ddl-generation separator [message #384366 is a reply to message #384365]

Mon, 29 December 2008 12:47

Tom Eugelink

Messages: 817
Registered: July 2009

Senior Member

You can extend the database class that is being used, and adapt its behavior to your needs.

Report message to a moderator

Re: ddl-generation separator [message #385167 is a reply to message #384365]

Mon, 29 December 2008 14:22

Gordon Yorke

Messages: 78
Registered: July 2009

Member

There should be a property for this but there is not, please file an
enhancement.

You can cause the ddl to be generated in the same manner as EclipseLink
using the native SchemaManager.

DatabaseSession session = entityManagerFactory.getServerSession();
SchemaManager mgr = new SchemaManager(session)
mgr.outputCreateDDLToFile(createDDLFilePath); // set create ddl file name
mgr.outputDropDDLToFile(dropDDLFilePath);// sets drop ddl file name
mgr.setCreateSQLFiles(true); // writes statement terminator
mgr.replaceDefaultTables(true, true); // generates both drop and create ddl
mgr.closeDDLWriter();

--Gordon

Report message to a moderator

Re: ddl-generation separator [message #385177 is a reply to message #384365]

Sun, 11 January 2009 12:44

Frank Schwarz

Messages: 26
Registered: July 2009
Location: Dresden

Junior Member

There is already an enhancement request for this feature:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=227145

If you use apache-ant, you might consider adding these lines to your build
script
<fixcrlf srcdir="${basedir}/build/sql" />
<replace dir="${basedir}/build/sql" token="${line.separator}"
value=";${line.separator}" summary="true" />

-- Frank

Report message to a moderator

Previous Topic:	EclipseLink vs Hibernate
Next Topic:	Source code for javax.persistence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 13:50:00 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter