-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: error - Unsuccessful: create table X ; Table already exists
PostPosted: Tue Oct 29, 2013 6:53 am 
Newbie

Joined: Tue Oct 29, 2013 6:32 am
Posts: 2
Hi do you know why i get theese types of errors?
Quote:
[java] 1125 [btpool0-0] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create table ADDETTO (ID bigint not null, ADDETTO_NOME varchar(255), ADDETTO_COGNOME varchar(255), ADDETTO_USERNAME varchar(255), ADDETTO_PASSWORD varchar(255), primary key (ID))


in the hibernate.cfg.xml i have this property:
<property name="hbm2ddl.auto">create</property>
this is the full console log:
Code:
Buildfile: /home/ardiz/Downloads/gwt_hibernate_dto/build.xml
libs:
javac:
    [javac] /home/ardiz/Downloads/gwt_hibernate_dto/build.xml:34: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds
hosted:
     [java] 23 [btpool0-0] INFO org.hibernate.cfg.Environment - Hibernate 3.3.1.GA
     [java] 26 [btpool0-0] INFO org.hibernate.cfg.Environment - hibernate.properties not found
     [java] 31 [btpool0-0] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
     [java] 36 [btpool0-0] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
     [java] 97 [btpool0-0] INFO org.hibernate.cfg.Configuration - configuring from resource: /hibernate.cfg.xml
     [java] 97 [btpool0-0] INFO org.hibernate.cfg.Configuration - Configuration resource: /hibernate.cfg.xml
     [java] 164 [btpool0-0] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : com/google/musicstore/domain/Record.hbm.xml
     [java] 257 [btpool0-0] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.google.musicstore.domain.Record -> RECORD
     [java] 284 [btpool0-0] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : com/google/musicstore/domain/Account.hbm.xml
     [java] 365 [btpool0-0] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.google.musicstore.domain.Account -> ACCOUNT
     [java] 370 [btpool0-0] INFO org.hibernate.cfg.HbmBinder - Mapping collection: com.google.musicstore.domain.Account.records -> ACCOUNT_RECORD
     [java] 372 [btpool0-0] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : com/google/musicstore/domain/Addetto.hbm.xml
     [java] 425 [btpool0-0] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.google.musicstore.domain.Addetto -> ADDETTO
     [java] 426 [btpool0-0] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : com/google/musicstore/domain/Cliente.hbm.xml
     [java] 452 [btpool0-0] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.google.musicstore.domain.Cliente -> CLIENTE
     [java] 453 [btpool0-0] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : com/google/musicstore/domain/Auto.hbm.xml
     [java] 476 [btpool0-0] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.google.musicstore.domain.Auto -> AUTO
     [java] 477 [btpool0-0] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : com/google/musicstore/domain/Noleggio.hbm.xml
     [java] 501 [btpool0-0] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.google.musicstore.domain.Noleggio -> NOLEGGIO
     [java] 565 [btpool0-0] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
     [java] 572 [btpool0-0] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
     [java] 572 [btpool0-0] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 1
     [java] 572 [btpool0-0] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
     [java] 575 [btpool0-0] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost
     [java] 575 [btpool0-0] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=sa, password=****}
     [java] 626 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - RDBMS: HSQL Database Engine, version: 1.8.0
     [java] 626 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - JDBC driver: HSQL Database Engine Driver, version: 1.8.0
     [java] 652 [btpool0-0] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.HSQLDialect
     [java] 665 [btpool0-0] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
     [java] 667 [btpool0-0] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
     [java] 667 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
     [java] 667 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
     [java] 667 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
     [java] 667 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
     [java] 668 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
     [java] 668 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled
     [java] 668 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
     [java] 669 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
     [java] 669 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
     [java] 669 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
     [java] 669 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
     [java] 669 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
     [java] 674 [btpool0-0] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
     [java] 674 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
     [java] 674 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
     [java] 674 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
     [java] 674 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
     [java] 677 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge
     [java] 677 [btpool0-0] INFO org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge - Cache provider: org.hibernate.cache.NoCacheProvider
     [java] 677 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
     [java] 677 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
     [java] 682 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout
     [java] 683 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
     [java] 683 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
     [java] 683 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
     [java] 683 [btpool0-0] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
     [java] 752 [btpool0-0] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
     [java] 1036 [btpool0-0] INFO org.hibernate.tuple.PojoInstantiator - no default (no-argument) constructor for class: com.google.musicstore.domain.Noleggio (class must be instantiated by Interceptor)
     [java] 1109 [btpool0-0] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
     [java] 1118 [btpool0-0] INFO org.hibernate.tool.hbm2ddl.SchemaExport - Running hbm2ddl schema export
     [java] 1119 [btpool0-0] INFO org.hibernate.tool.hbm2ddl.SchemaExport - exporting generated schema to database
     [java] 1125 [btpool0-0] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create table ADDETTO (ID bigint not null, ADDETTO_NOME varchar(255), ADDETTO_COGNOME varchar(255), ADDETTO_USERNAME varchar(255), ADDETTO_PASSWORD varchar(255), primary key (ID))
     [java] 1126 [btpool0-0] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Table already exists: ADDETTO in statement [create table ADDETTO]
     [java] 1126 [btpool0-0] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create table AUTO (ID bigint not null, NOME varchar(255), TIPO varchar(255), PREZZO bigint, primary key (ID))
     [java] 1126 [btpool0-0] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Table already exists: AUTO in statement [create table AUTO]
     [java] 1126 [btpool0-0] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create table CLIENTE (ID bigint not null, NOME varchar(255), COGNOME varchar(255), CODFISCALE varchar(255), primary key (ID))
     [java] 1126 [btpool0-0] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Table already exists: CLIENTE in statement [create table CLIENTE]
     [java] 1127 [btpool0-0] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Unsuccessful: create table NOLEGGIO (ID bigint not null, CLIENTE_ID bigint, primary key (ID))
     [java] 1127 [btpool0-0] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Table already exists: NOLEGGIO in statement [create table NOLEGGIO]
     [java] 1129 [btpool0-0] INFO org.hibernate.tool.hbm2ddl.SchemaExport - schema export complete
     [java] Hibernate: select max(ID) from CLIENTE
     [java] Hibernate: select max(ID) from ADDETTO
     [java] Hibernate: select max(ID) from AUTO
     [java] Hibernate: insert into CLIENTE (NOME, COGNOME, CODFISCALE, ID) values (?, ?, ?, ?)
     [java] Hibernate: insert into CLIENTE (NOME, COGNOME, CODFISCALE, ID) values (?, ?, ?, ?)
     [java] Hibernate: insert into AUTO (NOME, TIPO, PREZZO, ID) values (?, ?, ?, ?)
     [java] Hibernate: insert into ADDETTO (ADDETTO_NOME, ADDETTO_COGNOME, ADDETTO_USERNAME, ADDETTO_PASSWORD, ID) values (?, ?, ?, ?, ?)
     [java] Hibernate: select addetto0_.ID as ID3_, addetto0_.ADDETTO_NOME as ADDETTO2_3_, addetto0_.ADDETTO_COGNOME as ADDETTO3_3_, addetto0_.ADDETTO_USERNAME as ADDETTO4_3_, addetto0_.ADDETTO_PASSWORD as ADDETTO5_3_ from ADDETTO addetto0_ where addetto0_.ADDETTO_USERNAME=? and addetto0_.ADDETTO_PASSWORD=?
     [java] Hibernate: select cliente0_.ID as ID4_, cliente0_.NOME as NOME4_, cliente0_.COGNOME as COGNOME4_, cliente0_.CODFISCALE as CODFISCALE4_ from CLIENTE cliente0_
     [java] Hibernate: select addetto0_.ID as ID3_, addetto0_.ADDETTO_NOME as ADDETTO2_3_, addetto0_.ADDETTO_COGNOME as ADDETTO3_3_, addetto0_.ADDETTO_USERNAME as ADDETTO4_3_, addetto0_.ADDETTO_PASSWORD as ADDETTO5_3_ from ADDETTO addetto0_
     [java] Hibernate: select cliente0_.ID as ID4_, cliente0_.NOME as NOME4_, cliente0_.COGNOME as COGNOME4_, cliente0_.CODFISCALE as CODFISCALE4_ from CLIENTE cliente0_
     [java] Hibernate: select auto0_.ID as ID5_, auto0_.NOME as NOME5_, auto0_.TIPO as TIPO5_, auto0_.PREZZO as PREZZO5_ from AUTO auto0_
     [java] Hibernate: select auto0_.ID as ID5_, auto0_.NOME as NOME5_, auto0_.TIPO as TIPO5_, auto0_.PREZZO as PREZZO5_ from AUTO auto0_
     [java] Hibernate: select noleggio0_.ID as ID6_, noleggio0_.CLIENTE_ID as CLIENTE2_6_ from NOLEGGIO noleggio0_


Top
 Profile  
 
 Post subject: Re: error - Unsuccessful: create table X ; Table already exists
PostPosted: Tue Oct 29, 2013 12:53 pm 
Hibernate Team
Hibernate Team

Joined: Tue Sep 18, 2012 5:03 am
Posts: 36
Location: Fort Wayne, Indiana, USA
The line proceeding the error is the issue:

[java] 1126 [btpool0-0] ERROR org.hibernate.tool.hbm2ddl.SchemaExport - Table already exists: ADDETTO in statement [create table ADDETTO]

It appears you're trying to create tables that already exist.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.