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
John Lussmyer is currently offline John Lussmyer
Messages: 96
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?
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: 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
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: 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 : http://wiki.eclipse.org/EclipseLink : http://en.wikibooks.org/wiki/Java_Persistence : http://java-persistence-performance.blogspot.com/


James : Wiki : Book : Blog : Twitter
Previous Topic:Cannot find Maven Repository
Next Topic:Order by primary key as a associated entity.
Goto Forum:
  


Current Time: Wed Jul 23 22:29:08 EDT 2014

Powered by FUDForum. Page generated in 0.01653 seconds