Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Where to define schema?
Where to define schema? [message #770324] Fri, 23 December 2011 18:18 Go to next message
Missing name Mising name is currently offline Missing name Mising name
Messages: 94
Registered: December 2010
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 10:28 Go to previous message
James Sutherland is currently offline James Sutherland
Messages: 1844
Registered: July 2009
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

Report message to a moderator

Re: Where to define schema? [message #777484 is a reply to message #770324] Tue, 10 January 2012 10:28 Go to previous message
James Sutherland is currently offline James Sutherland
Messages: 1844
Registered: July 2009
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 : http://wiki.eclipse.org/EclipseLink : http://en.wikibooks.org/wiki/Java_Persistence : http://java-persistence-performance.blogspot.com/

James : Wiki : Book : Blog

Report message to a moderator

Previous Topic:Cannot find Maven Repository
Next Topic:Order by primary key as a associated entity.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 23 01:01:55 EDT 2013

Powered by FUDForum. Page generated in 0.21715 seconds