You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by Dain Sundstrom <da...@iq80.com> on 2007/01/31 00:30:20 UTC
log create table statements?
I have openjpa setup to auto create my tables, and I see openjpa the
tables using in my log, but I don't see the create table statements.
I have this in my persistenc.xml file
<properties>
<property name="openjpa.Log" value="DefaultLevel=TRACE"/>
<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema(ForeignKeys=true)"/>
</properties>
I there some other property I need to set?
-dain
Re: log create table statements?
Posted by Dain Sundstrom <da...@iq80.com>.
I'm dumb. I thought I was using hsqldb in memory only mode, but
instead it was in file mode.
-dain
On Jan 31, 2007, at 6:33 AM, Kevin Sutter wrote:
> Another possibility is that you need to explicitly declare the
> classes that
> you want processed for automatic table creation via the <class>..</
> class>
> elements. Scanning for available Entity classes won't work when
> attempting
> to auto create the tables.
>
> Kevin
>
> On 1/30/07, Marc Prud'hommeaux <mp...@apache.org> wrote:
>>
>> Dain-
>>
>> Odd ... you certainly should see the statements. Are you sure you
>> aren't running against a database where the tables already exist
>> (since OpenJPA won't try to create tables when they exist)?
>>
>> Can you see any SQL statements in the logged messages at all (e.g.,
>> when you run a query)? Can you post the logging output? (I want to
>> make sure the log setting is not being overridden somewhere else).
>>
>>
>>
>> On Jan 30, 2007, at 3:30 PM, Dain Sundstrom wrote:
>>
>> > I have openjpa setup to auto create my tables, and I see openjpa
>> > the tables using in my log, but I don't see the create table
>> > statements. I have this in my persistenc.xml file
>> >
>> > <properties>
>> > <property name="openjpa.Log" value="DefaultLevel=TRACE"/>
>> > <property name="openjpa.jdbc.SynchronizeMappings"
>> > value="buildSchema(ForeignKeys=true)"/>
>> > </properties>
>> >
>> > I there some other property I need to set?
>> >
>> > -dain
>>
>>
Re: log create table statements?
Posted by Kevin Sutter <kw...@gmail.com>.
Another possibility is that you need to explicitly declare the classes that
you want processed for automatic table creation via the <class>..</class>
elements. Scanning for available Entity classes won't work when attempting
to auto create the tables.
Kevin
On 1/30/07, Marc Prud'hommeaux <mp...@apache.org> wrote:
>
> Dain-
>
> Odd ... you certainly should see the statements. Are you sure you
> aren't running against a database where the tables already exist
> (since OpenJPA won't try to create tables when they exist)?
>
> Can you see any SQL statements in the logged messages at all (e.g.,
> when you run a query)? Can you post the logging output? (I want to
> make sure the log setting is not being overridden somewhere else).
>
>
>
> On Jan 30, 2007, at 3:30 PM, Dain Sundstrom wrote:
>
> > I have openjpa setup to auto create my tables, and I see openjpa
> > the tables using in my log, but I don't see the create table
> > statements. I have this in my persistenc.xml file
> >
> > <properties>
> > <property name="openjpa.Log" value="DefaultLevel=TRACE"/>
> > <property name="openjpa.jdbc.SynchronizeMappings"
> > value="buildSchema(ForeignKeys=true)"/>
> > </properties>
> >
> > I there some other property I need to set?
> >
> > -dain
>
>
Re: log create table statements?
Posted by Marc Prud'hommeaux <mp...@apache.org>.
Dain-
Odd ... you certainly should see the statements. Are you sure you
aren't running against a database where the tables already exist
(since OpenJPA won't try to create tables when they exist)?
Can you see any SQL statements in the logged messages at all (e.g.,
when you run a query)? Can you post the logging output? (I want to
make sure the log setting is not being overridden somewhere else).
On Jan 30, 2007, at 3:30 PM, Dain Sundstrom wrote:
> I have openjpa setup to auto create my tables, and I see openjpa
> the tables using in my log, but I don't see the create table
> statements. I have this in my persistenc.xml file
>
> <properties>
> <property name="openjpa.Log" value="DefaultLevel=TRACE"/>
> <property name="openjpa.jdbc.SynchronizeMappings"
> value="buildSchema(ForeignKeys=true)"/>
> </properties>
>
> I there some other property I need to set?
>
> -dain