Re: [eclipselink-users] Create DB DDL scripts instead of building databa

[Tom Ware <tom.ware@xxxxxxxxxx>]

Hi Roger,

  I just ran a quick test and I seem to get the expected behavior.

  How is your persistence unit configured?  Where are the classes?  Where is 
the persistence.xml?  Is it possible to post the full persistence.xml?  Is your 
application OSGi?

-Tom

RogerV wrote:
> tware wrote:
> > Do you see the SQL scripts being generated?  (i.e. Do you see
> > create_ddl.sql and 
> > drop_ddl.sql being generated?)
>
> No. There no mention of create_ddl.sql or drop_ddl.sql in the console
> output. Scanning the harddrive - no sign of them either.
>
>
>
> > Also, what version of EclipseLink are you running on?
>
> Project properties shows EclipseLink 1.1.x. Looking at the persistence jars
> in the eclipse/plugin directory, looks like 1.1.2.v20060612-r4475. If this
> isn't the information you need, you'll need to tell me where to look I'm
> afraid.
>
> Regards
>
> RogerV wrote:
> > tware wrote:
> > > Are you running in JavaSE or in some kind of application server (and if
> > > so, 
> > > which one?
> > Running in JavaSE - I'm actually running within Eclipse Galileo.
> >
> >
> >
> > > Do you see the sql-script generated as well?
> > I see some SQL - but it doesn't look any different than it did previously
> > before I changed the persistence.xml - for example
> >
> > [EL Fine]: Connection(25515362)--ALTER TABLE Hardware DROP FOREIGN KEY
> > FK_Hardware_assemblyId
> > [EL Fine]: Connection(25515362)--ALTER TABLE PEcu DROP FOREIGN KEY
> > FK_PEcu_platformId
> > [EL Fine]: Connection(25515362)--DROP TABLE Software
> > [EL Fine]: Connection(25515362)--CREATE TABLE Software (predecessor
> > VARCHAR(64), successor VARCHAR(64), fileName VARCHAR(32), fileType
> > VARCHAR(8), sequence INTEGER UNIQUE NOT NULL, softwareId VARCHAR(64)
> > UNIQUE
> > NOT NULL, hardwareId VARCHAR(64) UNIQUE NOT NULL, assemblyId VARCHAR(64)
> > UNIQUE NOT NULL, platformId INTEGER UNIQUE NOT NULL, txAddress VARCHAR(3)
> > UNIQUE NOT NULL, busId INTEGER UNIQUE NOT NULL, PRIMARY KEY (sequence,
> > softwareId, hardwareId, assemblyId, platformId, txAddress, busId))
> >
> > Regards
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users