ERROR: relation resource_id_seq does not exist

14/12/2011

0

Java

Pessoal,

No curso de Struts2 + JPA + Sitemesh + Spring + Maven - Video_Aula-09,

O Felipe diz que ao realizar os testes apareceriam 2 erros,

No erro abaixo diz que eu não tenho a sequence, mas eu a tenho no Postgres..

Na classe de teste eu faço assim:

em.createNativeQuery(alter sequence frasys.resource_id_seq restart with 10;).executeUpdate();

Não sei mais o que fazer,

Obrigado!!

T E S T S
-------------------------------------------------------
Running net.fratech.frasys.domain.repositories.TestUserRepository
Dec 14, 2011 1:09:17 AM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.0.Final}
Dec 14, 2011 1:09:17 AM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.0.0.CR6}
Dec 14, 2011 1:09:17 AM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Dec 14, 2011 1:09:17 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Dec 14, 2011 1:09:17 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Dec 14, 2011 1:09:17 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
Dec 14, 2011 1:09:17 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: true
Dec 14, 2011 1:09:17 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://localhost:5432/postgres]
Dec 14, 2011 1:09:17 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=postgres, password=****, autocommit=true, release_mode=auto}
Dec 14, 2011 1:09:17 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
Dec 14, 2011 1:09:18 AM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
Dec 14, 2011 1:09:18 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
Dec 14, 2011 1:09:18 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
Dec 14, 2011 1:09:18 AM org.springframework.context.support.AbstractApplicationContext prepareRefresh
INFO: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@7bf52460: display name [org.springframework.context.support.ClassPathXmlApplicationContext@7bf52460]; startup date [Wed Dec 14 01:09:18 BRST 2011]; root of context hierarchy
Dec 14, 2011 1:09:18 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [applicationContext.xml]
Dec 14, 2011 1:09:18 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from class path resource [testDomainContext.xml]
Dec 14, 2011 1:09:18 AM org.springframework.context.support.AbstractApplicationContext obtainFreshBeanFactory
INFO: Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext@7bf52460]: org.springframework.beans.factory.support.DefaultListableBeanFactory@3a0b2c64
Dec 14, 2011 1:09:18 AM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@3a0b2c64: defining beans [user,userRepository,userExample,addressExample]; root of factory hierarchy
Dec 14, 2011 1:09:18 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Dec 14, 2011 1:09:18 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
Dec 14, 2011 1:09:18 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: true
Dec 14, 2011 1:09:18 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://localhost:5432/postgres]
Dec 14, 2011 1:09:18 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=postgres, password=****, autocommit=true, release_mode=auto}
Dec 14, 2011 1:09:18 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
Dec 14, 2011 1:09:18 AM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
Dec 14, 2011 1:09:18 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
Dec 14, 2011 1:09:18 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
Dec 14, 2011 1:09:19 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 0, SQLState: 42P01
Dec 14, 2011 1:09:19 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: ERROR: relation resource_id_seq does not exist
Position: 17
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: ERROR: relation resource_id_seq does not exist
Position: 17
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1353)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1281)
at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1287)
at org.hibernate.ejb.AbstractEntityManagerImpl.merge(AbstractEntityManagerImpl.java:870)
at net.fratech.frasys.infrastructure.daos.GenericJpaDao.persist(GenericJpaDao.java:58)
at net.fratech.frasys.infrastructure.UserDecorator.save(UserDecorator.java:18)
at net.fratech.frasys.domain.repositories.TestUserRepository.saveNewUser(TestUserRepository.java:60)
at net.fratech.frasys.domain.repositories.TestUserRepository.sucess(TestUserRepository.java:47)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:71)
at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:35)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:115)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.apache.maven.surefire.booter.ProviderFactory$ClassLoaderProxy.invoke(ProviderFactory.java:103)
at $Proxy0.invoke(Unknown Source)
at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:150)
at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcess(SurefireStarter.java:91)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:69)
Caused by: org.hibernate.exception.SQLGrammarException: ERROR: relation resource_id_seq does not exist
Position: 17
at org.hibernate.exception.internal.SQLStateConverter.convert(SQLStateConverter.java:100)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at $Proxy23.executeQuery(Unknown Source)
at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:112)
at org.hibernate.id.SequenceHiLoGenerator.generate(SequenceHiLoGenerator.java:77)
at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:120)
at org.hibernate.ejb.event.EJB3MergeEventListener.saveWithGeneratedId(EJB3MergeEventListener.java:71)
at org.hibernate.event.internal.DefaultMergeEventListener.saveTransientEntity(DefaultMergeEventListener.java:422)
at org.hibernate.event.internal.DefaultMergeEventListener.mergeTransientEntity(DefaultMergeEventListener.java:342)
at org.hibernate.event.internal.DefaultMergeEventListener.entityIsTransient(DefaultMergeEventListener.java:304)
at org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:259)
at org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:86)
at org.hibernate.internal.SessionImpl.fireMerge(SessionImpl.java:783)
at org.hibernate.internal.SessionImpl.merge(SessionImpl.java:768)
at org.hibernate.internal.SessionImpl.merge(SessionImpl.java:772)
at org.hibernate.ejb.AbstractEntityManagerImpl.merge(AbstractEntityManagerImpl.java:861)
... 30 more
Caused by: org.postgresql.util.PSQLException: ERROR: relation resource_id_seq does not exist
Position: 17
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
Erro: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: ERROR: relation resource_id_seq does not exist
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
Position: 17
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
... 45 more
Dec 14, 2011 1:09:19 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Dec 14, 2011 1:09:19 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
Dec 14, 2011 1:09:19 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: true
Dec 14, 2011 1:09:19 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [org.postgresql.Driver] at URL [jdbc:postgresql://localhost:5432/postgres]
Dec 14, 2011 1:09:19 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=postgres, password=****, autocommit=true, release_mode=auto}
Dec 14, 2011 1:09:19 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect
Dec 14, 2011 1:09:19 AM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
Dec 14, 2011 1:09:19 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
Dec 14, 2011 1:09:19 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 2.59 sec <<< FAILURE!

Results :

Failed tests:
sucess(net.fratech.frasys.domain.repositories.TestUserRepository): expected:<10> but was:<0>


Rafael Jesus

Rafael Jesus

Responder

Posts

14/12/2011

Robson Teixeira

veja nas suas classes de modelo qual faz uso da sequence e poste aqui por favor.
Responder
Gostei + 0

14/12/2011

Rafael Jesus

É a classe User que faz referência:

@Entity
@Table(schema = frasys)
@NamedQueries( { @NamedQuery(name = User.getByLogin, query = SELECT user FROM User user WHERE user.login = :login and user.password = :password) })
public class User implements Serializable {

	@Id
	@SequenceGenerator(name = USER_GENERATOR, sequenceName = resource_id_seq, initialValue = 1, allocationSize = 1)
	@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = USER_GENERATOR)
	private int id;

Responder
Gostei + 0

15/12/2011

Robson Teixeira

olha não vi erro no mapeamento por quer não tenta o seguinte apague todas as tabelas e sequences do seu banco e mande o hibernate criar novamente as tabelas e sequences de sua app para ver se o erro ainda persiste.
ok??
att
robson
Responder
Gostei + 0

15/12/2011

Rafael Jesus

Boa Robson...

Chega em casa eu faço..

Obrigado man..

Rafael
Responder
Gostei + 0

17/12/2011

Rafael Jesus

Fala Robson blz?

Cara, dei um clean install no postgres e oracle 10g,

No oracle ele criou todas tabelas e sequence, menos a tabela User,

Ja no postgres ele criou só a de User..

Já não sei o que fazer brother?

Mandei os erros no seu e-mail de ambos os bancos para não poluir o artigo..

Arbcs

Rafael
Responder
Gostei + 0

18/12/2011

Robson Teixeira

teste o hibernate.hbm2ddl.auto com o valor update e diz se causa o mesmo erro??
Responder
Gostei + 0

18/12/2011

Rafael Jesus

Velho eu li e reli os logs..

No Oracle ele só não cria a User...muito estranho isso...

Não consigo achar solução para isso man....

Será que é mais um curso que eu terei que parar pelo caminho???

É ossoooo...

Obrigado Robson caso consiga algo ai dá um tok...

Abrcs
Responder
Gostei + 0

19/12/2011

Robson Teixeira

Kra no oracle você criou o schema chamado frasys???? e no postgres também???
no oracle pelo fato de não ter criado a tabela User pode ser pela ausencia do schema frasys.
no postgres o erro de não ter criado a sequence pode ser tb pelo fato de não ter acesso ao schema.
também poste aqui no forum todas as suas classes de entidade da sua app completas por favor.
att
robson
Responder
Gostei + 0

19/12/2011

Rafael Jesus

Então, o schema frasys já esta criado em ambos os bancos, só esperando para ser populado..

No Postgres ele só cria a tabela USER, no Oracle ele criar tudo até as SEQUENCES
Responder
Gostei + 0

19/12/2011

Rafael Jesus

.......Como ia dizendo, no Oracle só não cria a tabela USER..

Assim que eu chegar em casa posto o código aqui...

Obrigado
Responder
Gostei + 0

20/12/2011

Dyego Carmo

Ficamos no aguardo para ajudar :)
Responder
Gostei + 0

21/12/2011

Simova Ltda

Pessoal,

Na minha classe de teste eu comentei a linha que deleta um USER, e ao verificar o banco haviam dados gravados,

Que eu gerei na minha classe teste..

Ao dar um clean install, ele criar somente a tabela USER e a sequence resorce_id_sequence..

Lembrando que eu havia apagado todas as tebelas criadas manualmente, pois não encontrava a resource_id_seq e ela estava lá,

Por opinião do Robson eu apaguei e dexei o hibernate fazer isso, porém não faz, cria somente a table USER e a resouce_id_sequence.

E perceba que no final ele diz que não existe???

Eu poderia pular essas partes de testes, mas são de extrema importancia..vcs sabem disso...

Caso precisem no log inteiro eu mando por e-mail..

Obrigado!

Meu persistence.xml:
<persistence-unit name=frasys>

		<class>net.fratech.frasys.domain.Project</class>
		<class>net.fratech.frasys.domain.Iteration</class>
		<class>net.fratech.frasys.domain.Item</class>
		<class>net.fratech.frasys.domain.Task</class>
		<class>net.fratech.frasys.domain.User</class>

		<properties>
			<property name=hibernate.dialect value= org.hibernate.dialect.PostgreSQLDialect />
			<property name=hibernate.connection.url value=jdbc:postgresql://localhost:5432/postgres />
			<property name=hibernate.connection.driver_class value=org.postgresql.Driver />
			<property name=hibernate.connection.username value=postgres />
			<property name=hibernate.connection.password value=rafa1986 />
			<property name=hibernate.show_sql value=true />
			<property name=hibernate.hbm2ddl.auto value=update />
		</properties>

	</persistence-unit>
</persistence>

Minha entidade:
@Entity
@Table(schema=frasys)
@NamedQueries ({
	@NamedQuery(name = User.getByLogin,
				query = SELECT u FROM User u WHERE u.login = :login and u.password = :password)})
public class User implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@SequenceGenerator(name=USER_GENERATOR, sequenceName=frasys.resource_id_seq, initialValue = 1, allocationSize = 1)
	@GeneratedValue(strategy=GenerationType.SEQUENCE, generator=USER_GENERATOR)
	private int id;
	// outro atributos


Minha classe de teste:
@BeforeClass
	public static void prepare () {
		reset();
		ctx = new ClassPathXmlApplicationContext(new String[] {applicationContext.xml, testDomainContext.xml});
		repository = (UserRepository) ctx.getBean(userRepository);
	}
	
	@AfterClass
	public static void reset () {
		EntityManager em = Persistence.createEntityManagerFactory(frasys).createEntityManager();
		em.getTransaction().begin();
		em.createNativeQuery(ALTER SEQUENCE resource_id_seq RESTART with 10;).executeUpdate();
		em.createNativeQuery(DELETE FROM FRASYS.USER).executeUpdate();
		em.close();
	}
	
	private User getUser () {
		return (User) ctx.getBean(userExample);
	}
	
	@Test
	public void sucess () {
		User u = saveNewUser();
		saveManaged(u);
		saveUpdate();
		saveAnotherUser();
		userWithId();
		userWithLogin();
		allUsers();
		remove();
		removeManaged(u);
	}
	// métodos da classe success onde faço todos os teste da entidade USER

Erros gerados pelo teste:
// foram 2.000 linhas de erro gerados pelo slf4
2011-12-21 19:34:12,982 DEBUG [SQLStatementLogger.java:111] : ALTER SEQUENCE resource_id_seq RESTART with 10;
Hibernate: ALTER SEQUENCE resource_id_seq RESTART with 10;
2011-12-21 19:34:12,983 DEBUG [AbstractBatcher.java:418] : about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2011-12-21 19:34:12,983 DEBUG [JDBCExceptionReporter.java:225] : could not execute native bulk manipulation query [ALTER SEQUENCE resource_id_seq RESTART with 10;]
org.postgresql.util.PSQLException: ERROR: relation resource_id_seq does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:210)
at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1310)
at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:396)
at org.hibernate.ejb.QueryImpl.internalExecuteUpdate(QueryImpl.java:188)
at org.hibernate.ejb.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:99)
at net.fratech.frasys.domain.repositories.TestUserRepository.reset(TestUserRepository.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.internal.runners.BeforeAndAfterRunner.invokeMethod(BeforeAndAfterRunner.java:74)
at org.junit.internal.runners.BeforeAndAfterRunner.runAfters(BeforeAndAfterRunner.java:65)
at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:37)
at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:35)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:115)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.maven.surefire.booter.ProviderFactory$ClassLoaderProxy.invoke(ProviderFactory.java:103)
at $Proxy0.invoke(Unknown Source)
at org.apache.maven.surefire.booter.SurefireStarter.invokeProvider(SurefireStarter.java:150)
at org.apache.maven.surefire.booter.SurefireStarter.runSuitesInProcess(SurefireStarter.java:91)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:69)
2011-12-21 19:34:12,984 WARN [JDBCExceptionReporter.java:233] : SQL Error: 0, SQLState: 42P01
2011-12-21 19:34:12,984 ERROR [JDBCExceptionReporter.java:234] : ERROR: relation resource_id_seq does not exist
2011-12-21 19:34:12,984 DEBUG [AbstractEntityManagerImpl.java:948] : mark transaction for rollback
Tests run: 2, Failures: 0, Errors: 2, Skipped: 0, Time elapsed: 2.099 sec <<< FAILURE!

Results :

Tests in error:
net.fratech.frasys.domain.repositories.TestUserRepository: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
net.fratech.frasys.domain.repositories.TestUserRepository: org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
Responder
Gostei + 0

22/12/2011

Davi Costa

testa fazer essa alteração sequenceName=frasys.resource_id_seq para:

sequenceName=resource_id_seq

att Davi
Responder
Gostei + 0

22/12/2011

Robson Teixeira

sim teste de acordo com o que o davi falou pois o postgres sem especificar o schema ele considera o schema public.
Responder
Gostei + 0

22/12/2011

Rafael Jesus

Desconsidere o nome do schema na frente da sequence frasys.resource_id_seq da classe User,
(fiz diversos testes e ao copiar esqueci de tirar)

No erro acima as sequences eu as deixei iguais,

Classe teste = resource_id_seq
Entidade = resource_id_seq

Agora mudei para:

Classe teste = frasys.resource_id_seq
Entidade = frasys.resource_id_seq

Assim criou a sequence no banco, porém não criou a do hibernate que é default eu acho..

Mesmo assim deu erro;

// acima aviam mais logs
2011-12-22 18:45:03,580 DEBUG [ErrorCounter.java:91] : throwQueryException() : no errors
2011-12-22 18:45:03,583 DEBUG [SessionFactoryImpl.java:557] : Checking 0 named SQL queries
2011-12-22 18:45:03,590 DEBUG [SessionImpl.java:265] : opened session at timestamp: 13245867035
2011-12-22 18:45:03,590 DEBUG [JDBCTransaction.java:78] : begin
2011-12-22 18:45:03,591 DEBUG [ConnectionManager.java:444] : opening JDBC connection
2011-12-22 18:45:03,591 DEBUG [JDBCTransaction.java:83] : current autocommit status: true
2011-12-22 18:45:03,591 DEBUG [JDBCTransaction.java:86] : disabling autocommit
2011-12-22 18:45:03,592 DEBUG [AbstractBatcher.java:410] : about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2011-12-22 18:45:03,592 DEBUG [SQLStatementLogger.java:111] : ALTER SEQUENCE frasys.resource_id_seq RESTART with 10;
Hibernate: ALTER SEQUENCE frasys.resource_id_seq RESTART with 10;
2011-12-22 18:45:03,593 DEBUG [AbstractBatcher.java:418] : about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2011-12-22 18:45:03,594 DEBUG [AbstractBatcher.java:410] : about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2011-12-22 18:45:03,594 DEBUG [SQLStatementLogger.java:111] : DELETE FROM FRASYS.USER
Hibernate: DELETE FROM FRASYS.USER
2011-12-22 18:45:03,595 DEBUG [AbstractBatcher.java:418] : about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 3.165 sec <<< FAILURE!

Results :

Failed tests:
sucess(net.fratech.frasys.domain.repositories.TestUserRepository): expected:<10> but was:<0>
Responder
Gostei + 0
Mais tópicos

Assista grátis a nossa aula inaugural

Assitir aula

Saiba por que programar é uma questão de
sobrevivência e como aprender sem riscos

Assistir agora

Utilizamos cookies para fornecer uma melhor experiência para nossos usuários, consulte nossa política de privacidade.

Aceitar