Eclipse Community Forums: EclipseLink » Where to define schema?

Help

Home

Home » Eclipse Projects » EclipseLink » Where to define schema?

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

Where to define schema? [message #770324]

Fri, 23 December 2011 23:18

Missing name Mising name

Messages: 105
Registered: December 2010

Senior Member

I'm new with JPA, and I need to manually define my Schema rather than have it generated.
Is there a standard place to do this?

Where I work, we just have schema.sql and drop.sql scripts in a specific directory that we can run as needed. Is there some standard way of doing this more integrated with the Eclipse environment?

Report message to a moderator

Re: Where to define schema? [message #777480 is a reply to message #770324]

Tue, 10 January 2012 15:28

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

Not sure on Eclipse, but with EclipseLink you can create you schema however you wish.

I think Eclipse can run .sql files with its database integration, but perhaps another forum would be better for how to do that.

When/how you run them depends on your usage. If it is a production database, then you obviously need to be very careful about controlling who and when these can be run.
In a development environment I generally use ant scripts to create the database.

James : Wiki : Book : Blog : Twitter

Report message to a moderator