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!