Hi Greg,

 You should be able to use TopLink essentials to generate some files that will contain the DDL statements you want and then edit those files.   I realize that is not quite as easy as having the DDL automatically created on the database, but it could help.

 If you want to give it a try, take a look at the schema generation extensions in the following document:

http://www.oracle.com/technology/products/ias/toplink/jpa/resources/toplink-jpa-extensions.html#Java2DBSchemaGen

- set |toplink.ddl-generation to either ||create-tables or|| drop-and-create-tables| - set |toplink.create-ddl-jdbc-file-name to the name and location of the file that should contain the create statements
- set ||toplink.drop-ddl-jdbc-file-name to the name and location of the file that should contain the drop statements (if you are using the ||drop-and-create-tables|  option above|)
- set ||toplink.ddl-generation.output-mode to ||sql-script

This should produce some files that can fairly easily be edited to produce some files you can use to build your DDL.  The are ".jdbc" files, so in order to make the into runnable sql files, you will likely have to add some line terminators.  In addition, you should be able to make any edits you choose.

Note: Currently due to glassfish issue 1171, if you are running in SE, we will also attempt to create the tables on the database, but that should not interfere with the correctness of the files.

-Tom



|Marina Vatkina wrote:

Hi Greg,

I suggest to file a bug and attach a simple test case ;).

If you have a legacy system, can you use its DDL to create your test
environment?

Is your application a JavaEE app? The actual solution will depend on the mode
in which you use TopLink Essentials DDL generation. But in any case the idea
would be to take the generated .jdbc file, modify and load it yourself, then
do not use auto DDL generation.

Does it make sense?

thanks,
-marina

Greg Ederer wrote:
 

Hi Marina,

This does create a table with the correct structure; however, I lose control over the name of the table, and the column names.  I would like these names to match those in a legacy system.  I just tried it with @JoinTable(name="user_role"), and I got the correct structure and table name, but the column names do not match those in my legacy table.

Any other suggestions?

Thanks for the help.

Greg

Marina Vatkina wrote:

  

Hi Greg,

Does it work if you remove @JoinTable annotation? If you use the DDL generation
feature, the provider will generate a join table for you automatically.

thanks,
-marina

Greg Ederer wrote:

    

Hi,

I have a ManyToMany relationship between two classes, annotated like so at the owning end:

 @ManyToMany
 @JoinTable(name = "user_role", joinColumns =
   {@JoinColumn(name = "username", referencedColumnName = "username")},
    inverseJoinColumns = {@JoinColumn(name = "role_name", referencedColumnName = "name")})
 private List<Role> roles = new ArrayList<Role>();

At the other end:

 @ManyToMany(mappedBy="roles")
 private List<AppUser> appUsers = new ArrayList<AppUser>();

This produces the following join table (PostgreSQL):

CREATE TABLE user_role
(
 role_name varchar(255) NOT NULL,
 username varchar(255) NOT NULL,
 CONSTRAINT user_role_pkey PRIMARY KEY (role_name, username),
 CONSTRAINT fk_user_role_role_name FOREIGN KEY (role_name)
     REFERENCES "role" (name) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT fk_user_role_username FOREIGN KEY (username)
     REFERENCES app_user (username) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT user_role_username_key UNIQUE (username)
)

The user_role_username_key is unwanted.  How can I prevent it from being generated?

Thanks!

Greg
-- 

| E R G O N O S I S
| Greg Ederer
| Lead Developer
| greg@ergonosis.com
| 360.379.1157
| | OpenDocument - OK <http://openoffice.org/>
|

      

-- 

| E R G O N O S I S
| Greg Ederer
| Lead Developer
| greg@ergonosis.com
| 360.379.1157
| | OpenDocument - OK <http://openoffice.org/>
|

  

| E R G O N O S I S
| Greg Ederer
| Lead Developer
| greg@ergonosis.com
| 360.379.1157
| 
| OpenDocument - OK
|