JPA e Hibernate: Erro no esquema da tabela

1 resposta
mrmgomes

Ola a todos, sou novo no mundo java, estou tentando fazer uma aplicacao com JPA e Hibernate, com um banco JavaDB,
mas estou obtendo os seguintes erros:

run: 02/06/2010 17:38:10 org.hibernate.cfg.annotations.Version <clinit> INFO: Hibernate Annotations 3.3.1.GA 02/06/2010 17:38:10 org.hibernate.cfg.Environment <clinit> INFO: Hibernate 3.2.5 02/06/2010 17:38:10 org.hibernate.cfg.Environment <clinit> INFO: hibernate.properties not found 02/06/2010 17:38:10 org.hibernate.cfg.Environment buildBytecodeProvider INFO: Bytecode provider name : cglib 02/06/2010 17:38:10 org.hibernate.cfg.Environment <clinit> INFO: using JDK 1.4 java.sql.Timestamp handling 02/06/2010 17:38:10 org.hibernate.ejb.Version <clinit> INFO: Hibernate EntityManager 3.3.2.GA 02/06/2010 17:38:10 org.hibernate.cfg.AnnotationBinder bindClass INFO: Binding entity from annotated class: br.com.devmedia.jpa.entity.People 02/06/2010 17:38:10 org.hibernate.cfg.annotations.EntityBinder bindTable INFO: Bind entity br.com.devmedia.jpa.entity.People on table People 02/06/2010 17:38:10 org.hibernate.cfg.AnnotationBinder bindClass INFO: Binding entity from annotated class: br.com.devmedia.jpa.entity.PeopleCP 02/06/2010 17:38:10 org.hibernate.cfg.annotations.EntityBinder bindTable INFO: Bind entity br.com.devmedia.jpa.entity.PeopleCP on table PEOPLECP 02/06/2010 17:38:10 org.hibernate.cfg.AnnotationBinder bindClass INFO: Binding entity from annotated class: br.com.devmedia.jpa.entity.PeopleInfo 02/06/2010 17:38:10 org.hibernate.cfg.annotations.EntityBinder bindTable INFO: Bind entity br.com.devmedia.jpa.entity.PeopleInfo on table PeopleInfo 02/06/2010 17:38:10 org.hibernate.cfg.AnnotationBinder bindClass INFO: Binding entity from annotated class: br.com.devmedia.jpa.entity.Address 02/06/2010 17:38:10 org.hibernate.cfg.annotations.EntityBinder bindTable INFO: Bind entity br.com.devmedia.jpa.entity.Address on table Address 02/06/2010 17:38:10 org.hibernate.cfg.AnnotationBinder bindClass INFO: Binding entity from annotated class: br.com.devmedia.jpa.entity.Group 02/06/2010 17:38:10 org.hibernate.cfg.annotations.EntityBinder bindTable INFO: Bind entity br.com.devmedia.jpa.entity.Group on table GROUPS 02/06/2010 17:38:10 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass INFO: Mapping collection: br.com.devmedia.jpa.entity.People.addresses -> Address 02/06/2010 17:38:10 org.hibernate.cfg.AnnotationConfiguration secondPassCompile INFO: Hibernate Validator not found: ignoring 02/06/2010 17:38:10 org.hibernate.connection.DriverManagerConnectionProvider configure INFO: Using Hibernate built-in connection pool (not for production use!) 02/06/2010 17:38:10 org.hibernate.connection.DriverManagerConnectionProvider configure INFO: Hibernate connection pool size: 20 02/06/2010 17:38:10 org.hibernate.connection.DriverManagerConnectionProvider configure INFO: autocommit mode: true 02/06/2010 17:38:10 org.hibernate.connection.DriverManagerConnectionProvider configure INFO: using driver: org.apache.derby.jdbc.ClientDriver at URL: jdbc:derby://localhost:1527/jpaFullExample 02/06/2010 17:38:10 org.hibernate.connection.DriverManagerConnectionProvider configure INFO: connection properties: {user=jpa, password=****, autocommit=true, release_mode=auto} 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: RDBMS: Apache Derby, version: 10.5.3.0 - (802917) 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: JDBC driver: Apache Derby Network Client JDBC Driver, version: 10.5.3.0 - (802917) 02/06/2010 17:38:11 org.hibernate.dialect.Dialect <init> INFO: Using dialect: org.hibernate.dialect.DerbyDialect 02/06/2010 17:38:11 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory INFO: Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory 02/06/2010 17:38:11 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Automatic flush during beforeCompletion(): disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Automatic session close at end of transaction: disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Scrollable result sets: enabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: JDBC3 getGeneratedKeys(): disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Connection release mode: auto 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Default batch fetch size: 1 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Generate SQL with comments: disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Order SQL updates by primary key: disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Order SQL inserts for batching: disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 02/06/2010 17:38:11 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init> INFO: Using ASTQueryTranslatorFactory 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Query language substitutions: {} 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: JPA-QL strict compliance: enabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Second-level cache: enabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Query cache: disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory createCacheProvider INFO: Cache provider: org.hibernate.cache.NoCacheProvider 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Optimize cache for minimal puts: disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Structured second-level cache entries: disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Statistics: disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Deleted entity synthetic identifier rollback: disabled 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Default entity-mode: pojo 02/06/2010 17:38:11 org.hibernate.cfg.SettingsFactory buildSettings INFO: Named query checking : enabled 02/06/2010 17:38:11 org.hibernate.impl.SessionFactoryImpl <init> INFO: building session factory 02/06/2010 17:38:11 org.hibernate.impl.SessionFactoryObjectFactory addInstance INFO: Not binding factory to JNDI, no JNDI name configured 02/06/2010 17:38:11 org.hibernate.util.JDBCExceptionReporter logExceptions WARNING: SQL Error: -1, SQLState: 42Y07 02/06/2010 17:38:11 org.hibernate.util.JDBCExceptionReporter logExceptions SEVERE: O esquema 'JPA' não existe 02/06/2010 17:38:11 org.hibernate.event.def.DefaultLoadEventListener onLoad INFO: Error performing load command [b]org.hibernate.exception.SQLGrammarException: could not load an entity: [entity.Group#1][/b] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.loadEntity(Loader.java:1874) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:182) at br.com.devmedia.jpa.TheAppClass.main(TheAppClass.java:30) [b]Caused by: java.sql.SQLSyntaxErrorException: O esquema 'JPA' não existe[/b] at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547) at org.hibernate.loader.Loader.doQuery(Loader.java:673) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.loadEntity(Loader.java:1860) ... 13 more [b]Caused by: org.apache.derby.client.am.SqlException: O esquema 'JPA' não existe[/b] at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source) at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source) at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source) ... 21 more [b]Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not load an entity: [entity.Group#1][/b] at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:637) at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:202) at br.com.devmedia.jpa.TheAppClass.main(TheAppClass.java:30) [b]Caused by: org.hibernate.exception.SQLGrammarException: could not load an entity: [br.com.devmedia.jpa.entity.Group#1][/b] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.loadEntity(Loader.java:1874) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815) at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:182) ... 1 more Caused by: java.sql.SQLSyntaxErrorException: O esquema 'JPA' não existe at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505) at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547) at org.hibernate.loader.Loader.doQuery(Loader.java:673) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) at org.hibernate.loader.Loader.loadEntity(Loader.java:1860) ... 13 more Caused by: org.apache.derby.client.am.SqlException: O esquema 'JPA' não existe at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source) at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source) at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source) ... 21 more Java Result: 1 CONSTRUÍDO COM SUCESSO (tempo total: 1 segundo)

Gostaria de salientar que DESDE o comeco to tendo problema com o esquema do banco de dados, e em cada entidade, tive que forcar o esquema no @Table.
Eh normal que no NetBeans 6.8 o esquema do DB seja igual ao nome do usuario? E como eu faco pra mudar isso?

Tô quebrando a cabeca e nao consigo resolver… Help!

Agradeco desde ja!

1 Resposta

mrmgomes

Ninguem nunca passou por isso aqui?

Criado 2 de junho de 2010
Ultima resposta 2 de jun. de 2010
Respostas 1
Participantes 1