tomee-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From AndrewClarke <s...@clarke.ca>
Subject Re: OpenJPA/Hibernate won't create/edit tables
Date Mon, 19 Aug 2013 12:56:36 GMT
Thank you for the response.  I think my errors are Hibernate-related rather than JPA, but as
I'm using both I just wasn't sure what is really causing the errors.

I've had <property name="hibernate.hbm2ddl.auto" value="update"/> in general, but I
changed it to "create" when I deleted all my tables.  I thought maybe there was a problem
with my database, so recreating everything might resolve the issue.  Unfortunately it didn't,
as I still get the errors and nothing is created.

- Andrew.


On 2013-08-17, at 03:43, Romain Manni-Bucau [via OpenEJB] <ml-node+s979440n4664697h42@n4.nabble.com>
wrote:

> Hi 
> 
> Why you said you have openjpa errors? 
> 
> With hibernate using create you should start only once with this setting. 
> Le 16 août 2013 22:57, "AndrewClarke" <[hidden email]> a écrit : 
> 
> > I'm having lots of problems with OpenJPA and/or Hibernate on TomeEE 
> > startup. 
> > It seems like this used to be working and now it's not, so I'm not sure 
> > what 
> > I've done wrong.  Here's an example of what happens with a table when I 
> > start TomEE: 
> > 
> > 2013-08-16 16:44:02,219 ERROR [localhost-startStop-1] 
> > tool.hbm2ddl.SchemaExport.perform(425): HHH000389: Unsuccessful: alter 
> > table 
> > User add index FK_dfc815c8d2a74750ab18b9d1f35 (organizationId), add 
> > constraint FK_dfc815c8d2a74750ab18b9d1f35 foreign key (organizationId) 
> > references Organization (id) 
> > 2013-08-16 16:44:02,219 ERROR [localhost-startStop-1] 
> > tool.hbm2ddl.SchemaExport.perform(425): HHH000389: Unsuccessful: alter 
> > table 
> > User add index FK_dfc815c8d2a74750ab18b9d1f35 (organizationId), add 
> > constraint FK_dfc815c8d2a74750ab18b9d1f35 foreign key (organizationId) 
> > references Organization (id) 
> > 2013-08-16 16:44:02,220 ERROR [localhost-startStop-1] 
> > tool.hbm2ddl.SchemaExport.perform(426): Table 'example_db_prod_innodb.user' 
> > doesn't exist 
> > 2013-08-16 16:44:02,220 ERROR [localhost-startStop-1] 
> > tool.hbm2ddl.SchemaExport.perform(426): Table 'example_db_prod_innodb.user' 
> > doesn't exist 
> > 
> > Yes, I get each Hibernate log entry twice.  No, I don't know why. 
> > 
> > I originally had a populated database and was getting all sorts of errors 
> > trying to create foreign key constraints, indexes, etc.  Each time I 
> > started 
> > TomEE it would try to create more indexes and constraints, without dropping 
> > old ones.  Eventually I thought I'd start with an empty database, which is 
> > where I am now.  No matter how I set up persistence.xml, I can't get it 
> > working.  Here's what I have at the moment: 
> > 
> > 
> > <?xml version="1.0" encoding="UTF-8"?> 
> > <persistence 
> >         xmlns="http://java.sun.com/xml/ns/persistence" 
> >         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
> >         xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> > http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" 
> >         version="2.0" 
> >         > 
> >     <persistence-unit name="ExampleEngine" transaction-type="JTA"> 
> >         <provider>org.hibernate.ejb.HibernatePersistence</provider>

> > 
> >         <properties> 
> >             <property name="hibernate.show_sql" value="true"/> 
> >             <property name="hibernate.format_sql" value="true"/> 
> >             <property name="hibernate.hbm2ddl.auto" value="create"/> 
> >         </properties> 
> >     </persistence-unit> 
> > </persistence> 
> > 
> > 
> > I'd really appreciate any ideas or insight. 
> > 
> > Thank you very much, 
> > - Andrew. 
> > 
> > 
> > 
> > -- 
> > View this message in context: 
> > http://openejb.979440.n4.nabble.com/OpenJPA-Hibernate-won-t-create-edit-tables-tp4664696.html
> > Sent from the OpenEJB User mailing list archive at Nabble.com. 
> > 
> 
> 
> If you reply to this email, your message will be added to the discussion below:
> http://openejb.979440.n4.nabble.com/OpenJPA-Hibernate-won-t-create-edit-tables-tp4664696p4664697.html
> To unsubscribe from OpenJPA/Hibernate won't create/edit tables, click here.
> NAML





--
View this message in context: http://openejb.979440.n4.nabble.com/OpenJPA-Hibernate-won-t-create-edit-tables-tp4664696p4664721.html
Sent from the OpenEJB User mailing list archive at Nabble.com.
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message