Discussoes de Programacao e Tecnologia

Problema com Hibernate e SQL Server

12 respostas
tatianaesc
tatianaesc

Pessoal,

Já tentei procurar em tudo que foi canto, mas o erro continua o mesmo.
Eu tenho uma aplicação que usa Hibernate para acesar uma base de dados SQL Server. Basicamente, a única coisa que ela faz é fazer um select em uma única tabela (Entry) de tempos em tempos, e deve retornar as tuplas que satisfaçam à consulta.

A minha main() apenas dá um desses comandos, e acontece o seguinte erro:

Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.loader.Loader.doList(Loader.java:2148)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
	at org.hibernate.loader.Loader.list(Loader.java:2024)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at br.pucrio.inf.les.aulanet.HibernateDatastore.fetch(HibernateDatastore.java:46)
	at br.pucrio.inf.les.aulanet.TestHibernate.main(TestHibernate.java:15)

Eu tenho certeza que o nome da tabela e do banco estão corretos, que tenho permissão de select na tabela e que estou usando um driver bom (JTDS). Já perguntei pra muita gente e ninguém tem IDÉIA do que possa ser…

Alguém tem alguma sugestão?

Muito obrigada,
Tatiana

Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

12 Respostas

Luca
Luca

Olá

Um conselho: mensagens com título contendo “socorro”, “urgente” e coisas do gênero geralmente pouca gente responde. Mas se realmente precisa de socorro pode tentar o CVV. :wink:

[]s
Luca

tatianaesc
tatianaesc

:slight_smile: obrigada, já editei a mensagem :slight_smile:

Luca
Luca

Olá

Obrigado. E desculpe a brincadeira. É o que faz umas cervejinhas a mais. Espero que lhe respondam logo, se bem que à noite menos gente responde.

[]s
Luca

Mauricio_Linhares
Mauricio_Linhares

Esse é o stack trace completo? Não tem mais nenhuma mensagem aparecendo?

_fs
_fs

Qual a query gerada?

tatianaesc
tatianaesc

Pessoal,

Pra facilitar, vou colocar o método que executa a query:

public List<Entry> fetch( Date date ) {
		String queryStr = "FROM Entry WHERE timestamp > ?" ;
	    Session session = factory.openSession();
	    
	    Query query = session.createQuery( queryStr);
	  
	    query.setParameter( 0, date );

	    List<Entry> entries = query.list();
	    session.flush();
	    session.close();
	    return entries;
	}

E vou colar o stacktrace um pouco antes de começarem os erros (foi mal pelo tamanho, mas completo dá pra ver melhor):

2006-04-12 10:51:52,562 DEBUG hql.ast.ErrorCounter  -> throwQueryException() : no errors
2006-04-12 10:51:52,593 DEBUG hql.ast.QueryTranslatorImpl  -> HQL: FROM br.pucrio.inf.les.aulanet.Entry WHERE timestamp > ?
2006-04-12 10:51:52,593 DEBUG hql.ast.QueryTranslatorImpl  -> SQL: select entry0_.Data_Real as Data1_0_, entry0_.IdParticipante as IdPartic2_0_, entry0_.IdServico as IdServico0_ from Entry entry0_ where entry0_.Data_Real>?
2006-04-12 10:51:52,593 DEBUG hql.ast.ErrorCounter  -> throwQueryException() : no errors
2006-04-12 10:51:52,609 DEBUG engine.query.HQLQueryPlan  -> HQL param location recognition took 16 mills (FROM Entry WHERE timestamp > ?)
2006-04-12 10:51:52,655 DEBUG engine.query.QueryPlanCache  -> located HQL query plan in cache (FROM Entry WHERE timestamp > ?)
2006-04-12 10:51:52,655 DEBUG engine.query.HQLQueryPlan  -> find: FROM Entry WHERE timestamp > ?
2006-04-12 10:51:52,655 DEBUG hibernate.engine.QueryParameters  -> parameters: [2006-04-12 10:51:51]
2006-04-12 10:51:52,655 DEBUG hibernate.engine.QueryParameters  -> named parameters: {}
2006-04-12 10:51:52,655 DEBUG hibernate.jdbc.AbstractBatcher  -> about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2006-04-12 10:51:52,655 DEBUG hibernate.jdbc.ConnectionManager  -> opening JDBC connection
2006-04-12 10:51:52,655 DEBUG v2.resourcepool.BasicResourcePool  -> resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@1bfc93a ---> age: 1531   max: 5000000 [com.mchange.v2.resourcepool.BasicResourcePool@111a775]
2006-04-12 10:51:52,655 DEBUG v2.resourcepool.BasicResourcePool  -> trace com.mchange.v2.resourcepool.BasicResourcePool@111a775 [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@ce5b1c)
2006-04-12 10:51:52,655 DEBUG org.hibernate.SQL  -> /* FROM Entry WHERE timestamp > ? */ select entry0_.Data_Real as Data1_0_, entry0_.IdParticipante as IdPartic2_0_, entry0_.IdServico as IdServico0_ from Entry entry0_ where entry0_.Data_Real>?
Hibernate: /* FROM Entry WHERE timestamp > ? */ select entry0_.Data_Real as Data1_0_, entry0_.IdParticipante as IdPartic2_0_, entry0_.IdServico as IdServico0_ from Entry entry0_ where entry0_.Data_Real>?
2006-04-12 10:51:52,655 DEBUG hibernate.jdbc.AbstractBatcher  -> preparing statement
2006-04-12 10:51:52,687 DEBUG c3p0.stmt.GooGooStatementCache  -> cxnStmtMgr.statementSet( net.sourceforge.jtds.jdbc.ConnectionJDBC3@50988 ).size(): 1
2006-04-12 10:51:52,687 DEBUG c3p0.stmt.GooGooStatementCache  -> checkoutStatement: com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 1; checked out: 1; num connections: 1; num keys: 1
2006-04-12 10:51:52,687 DEBUG hibernate.type.TimestampType  -> binding '2006-04-12 10:51:51' to parameter: 1
2006-04-12 10:51:52,702 DEBUG c3p0.impl.NewPooledConnection  -> com.mchange.v2.c3p0.impl.NewPooledConnection@1bfc93a handling a throwable.
java.sql.SQLException: Invalid object name 'Entry'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
	at org.hibernate.loader.Loader.doList(Loader.java:2145)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
	at org.hibernate.loader.Loader.list(Loader.java:2024)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at br.pucrio.inf.les.aulanet.HibernateDatastore.fetch(HibernateDatastore.java:46)
	at br.pucrio.inf.les.aulanet.TestHibernate.main(TestHibernate.java:15)
2006-04-12 10:51:52,702 DEBUG v2.sql.SqlUtils  -> Attempted to convert SQLException to SQLException. Leaving it alone. [SQLState: 42S02; errorCode: 208]
java.sql.SQLException: Invalid object name 'Entry'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
	at org.hibernate.loader.Loader.doList(Loader.java:2145)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
	at org.hibernate.loader.Loader.list(Loader.java:2024)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at br.pucrio.inf.les.aulanet.HibernateDatastore.fetch(HibernateDatastore.java:46)
	at br.pucrio.inf.les.aulanet.TestHibernate.main(TestHibernate.java:15)
2006-04-12 10:51:52,718 DEBUG c3p0.impl.DefaultConnectionTester  -> Testing a Connection in response to an Exception:
java.sql.SQLException: Invalid object name 'Entry'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
	at org.hibernate.loader.Loader.doList(Loader.java:2145)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
	at org.hibernate.loader.Loader.list(Loader.java:2024)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at br.pucrio.inf.les.aulanet.HibernateDatastore.fetch(HibernateDatastore.java:46)
	at br.pucrio.inf.les.aulanet.TestHibernate.main(TestHibernate.java:15)
2006-04-12 10:51:52,749 DEBUG hibernate.jdbc.AbstractBatcher  -> about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2006-04-12 10:51:52,749 DEBUG hibernate.jdbc.AbstractBatcher  -> closing statement
2006-04-12 10:51:52,749 DEBUG c3p0.stmt.GooGooStatementCache  -> checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 1; checked out: 0; num connections: 1; num keys: 1
2006-04-12 10:51:52,749 DEBUG hibernate.util.JDBCExceptionReporter  -> could not execute query [select entry0_.Data_Real as Data1_0_, entry0_.IdParticipante as IdPartic2_0_, entry0_.IdServico as IdServico0_ from Entry entry0_ where entry0_.Data_Real>?]
java.sql.SQLException: Invalid object name 'Entry'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
	at org.hibernate.loader.Loader.doList(Loader.java:2145)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
	at org.hibernate.loader.Loader.list(Loader.java:2024)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at br.pucrio.inf.les.aulanet.HibernateDatastore.fetch(HibernateDatastore.java:46)
	at br.pucrio.inf.les.aulanet.TestHibernate.main(TestHibernate.java:15)
2006-04-12 10:51:52,749 WARN  hibernate.util.JDBCExceptionReporter  -> SQL Error: 208, SQLState: 42S02
2006-04-12 10:51:52,749 ERROR hibernate.util.JDBCExceptionReporter  -> Invalid object name 'Entry'.
2006-04-12 10:51:52,765 DEBUG hibernate.jdbc.JDBCContext  -> after autocommit
2006-04-12 10:51:52,765 DEBUG hibernate.jdbc.ConnectionManager  -> aggressively releasing JDBC connection
2006-04-12 10:51:52,765 DEBUG hibernate.jdbc.ConnectionManager  -> releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2006-04-12 10:51:52,765 DEBUG hibernate.util.JDBCExceptionReporter  -> SQL Warning
java.sql.SQLWarning: Preparing the statement failed: Invalid object name 'Entry'.
	at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1204)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:646)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:692)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
	at org.hibernate.loader.Loader.doList(Loader.java:2145)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
	at org.hibernate.loader.Loader.list(Loader.java:2024)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at br.pucrio.inf.les.aulanet.HibernateDatastore.fetch(HibernateDatastore.java:46)
	at br.pucrio.inf.les.aulanet.TestHibernate.main(TestHibernate.java:15)
Caused by: java.sql.SQLException: Invalid object name 'Entry'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
	at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1180)
	... 17 more
2006-04-12 10:51:52,765 WARN  hibernate.util.JDBCExceptionReporter  -> SQL Warning: 208, SQLState: 42S02
2006-04-12 10:51:52,765 WARN  hibernate.util.JDBCExceptionReporter  -> Preparing the statement failed: Invalid object name 'Entry'.
2006-04-12 10:51:52,765 DEBUG c3p0.stmt.GooGooStatementCache  -> checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 1; checked out: 0; num connections: 1; num keys: 1
2006-04-12 10:51:52,765 DEBUG c3p0.impl.NewPooledConnection  -> A Throwable occurred while trying to reset the typeMap property of our Connection to Collections.EMPTY_MAP!
java.sql.SQLException: The Connection.setTypeMap(Map) method is not implemented.
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.notImplemented(ConnectionJDBC2.java:1519)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.setTypeMap(ConnectionJDBC2.java:2123)
	at com.mchange.v2.c3p0.impl.NewPooledConnection.reset(NewPooledConnection.java:290)
	at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:247)
	at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1148)
	at org.hibernate.connection.C3P0ConnectionProvider.closeConnection(C3P0ConnectionProvider.java:42)
	at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:445)
	at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:400)
	at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:287)
	at org.hibernate.jdbc.JDBCContext.afterNontransactionalQuery(JDBCContext.java:225)
	at org.hibernate.impl.SessionImpl.afterOperation(SessionImpl.java:412)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1111)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at br.pucrio.inf.les.aulanet.HibernateDatastore.fetch(HibernateDatastore.java:46)
	at br.pucrio.inf.les.aulanet.TestHibernate.main(TestHibernate.java:15)
2006-04-12 10:51:52,780 DEBUG v2.resourcepool.BasicResourcePool  -> trace com.mchange.v2.resourcepool.BasicResourcePool@111a775 [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@ce5b1c)
Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.loader.Loader.doList(Loader.java:2148)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
	at org.hibernate.loader.Loader.list(Loader.java:2024)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at br.pucrio.inf.les.aulanet.HibernateDatastore.fetch(HibernateDatastore.java:46)
	at br.pucrio.inf.les.aulanet.TestHibernate.main(TestHibernate.java:15)
Caused by: java.sql.SQLException: Invalid object name 'Entry'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
	at org.hibernate.loader.Loader.doList(Loader.java:2145)
	... 9 more

Obrigada desde já!

_fs
_fs

Query gerada:

select entry0_.Data_Real as Data1_0_, entry0_.IdParticipante as IdPartic2_0_, entry0_.IdServico as IdServico0_ from Entry entry0_ where entry0_.Data_Real>?

Melhorando:

select * from Entry e where e.Data_Real > ?
Erro:

java.sql.SQLException: Invalid object name 'Entry'.
Problema: não existe uma tabela chamada “Entry” neste banco de dados.
Solução: crie a tabela ou acerte o nome no mapeamento.

tatianaesc
tatianaesc

Oi Filipe,

Aí é que está. A tabela EXISTE :slight_smile:

E agora?

tatianaesc
tatianaesc

Pessoal,

Alterei as configurações do driver e agora o stacktrace diminuiu para:

2006-04-12 12:11:43,728 DEBUG c3p0.stmt.GooGooStatementCache  -> checkinAll(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 1; checked out: 0; num connections: 1; num keys: 1
2006-04-12 12:11:43,728 DEBUG c3p0.impl.NewPooledConnection  -> A Throwable occurred while trying to reset the typeMap property of our Connection to Collections.EMPTY_MAP!
java.sql.SQLException: The Connection.setTypeMap(Map) method is not implemented.
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.notImplemented(ConnectionJDBC2.java:1519)
	at net.sourceforge.jtds.jdbc.ConnectionJDBC2.setTypeMap(ConnectionJDBC2.java:2123)
	at com.mchange.v2.c3p0.impl.NewPooledConnection.reset(NewPooledConnection.java:290)
	at com.mchange.v2.c3p0.impl.NewPooledConnection.markClosedProxyConnection(NewPooledConnection.java:247)
	at com.mchange.v2.c3p0.impl.NewProxyConnection.close(NewProxyConnection.java:1148)
	at org.hibernate.connection.C3P0ConnectionProvider.closeConnection(C3P0ConnectionProvider.java:42)
	at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:445)
	at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:400)
	at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:287)
	at org.hibernate.jdbc.JDBCContext.afterNontransactionalQuery(JDBCContext.java:225)
	at org.hibernate.impl.SessionImpl.afterOperation(SessionImpl.java:412)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1111)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at br.pucrio.inf.les.aulanet.HibernateDatastore.fetch(HibernateDatastore.java:48)
	at br.pucrio.inf.les.aulanet.TestHibernate.main(TestHibernate.java:15)
2006-04-12 12:11:43,744 DEBUG v2.resourcepool.BasicResourcePool  -> trace com.mchange.v2.resourcepool.BasicResourcePool@74c3aa [managed: 2, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@ce5b1c)
2006-04-12 12:11:43,744 DEBUG hibernate.impl.SessionImpl  -> closing session
2006-04-12 12:11:43,744 DEBUG hibernate.jdbc.ConnectionManager  -> connection already null in cleanup : no action

Alguém sabe como resolver este problema?

Obrigada,
Tatiana

_fs
_fs

Que configurações alterou? URL do banco?

Quanto ao erro novo, tente retirar o c3p0 para descobrir se o problema é com ele. Se for, deve descobrir qual configuração faz uso do método não implementado.

tatianaesc
tatianaesc

Olá,

Sim, eu alterei de:

property name="hibernate.connection.url">		   <jdbc:jtds:sqlserver://tiae.les.inf.puc-rio.br:1433;Database=aulanetTesteImplantacao;selectMethod=cursor>
</property>

para

property name="hibernate.connection.url">						jdbc:jtds:sqlserver://tiae.les.inf.puc-rio.br:1433/aulanetTesteImplantacao
</property>

Mas este erro já estava dando antes… A diferença é que agora dá SÓ este erro.

tatianaesc
tatianaesc

Pessoal,

Eu achei um problema parecido num outro fórum, e quem respondeu aconselhou a ignorar o erro caso não estivesse atrabaplhando. Eu fiz isso então, e verifiquei que minha aplicação funcionou como esperado mesmo sem esse erro. É claro que isso não é o ideal, o melhor é sempre estarmos sem erros, mas o importante é que por hora, tá funcionando… Então quem tiver idéia do que pode ser feito, a ajuda ainda é válida! :slight_smile:

Só por curiosidade, quem se interessar em ler o post que me inspirou:
http://jira.atlassian.com/browse/CONF-4317

[]´s e obrigada a todos
Tatiana

Criado 11 de abril de 2006
Ultima resposta 12 de abr. de 2006
Respostas 12
Participantes 4

Topicos relacionados

Como saber se um mes tem 4 ou 5 semanas?[RESOLVIDO] 31 respostas Como converter inteiro para string! 13 respostas Comando SELECT para selecionar intervalo de data SQL SERVER 12 respostas &, &&, |, ||. Qndo usar? 6 respostas O método split 12 respostas
Alura POO: o que é programação orientada a objetos? Aprenda os conceitos básicos da programação orientada a objetos, como classes, objetos, herança, encapsulamento e polimorfismo, com exemplos.
Casa do Codigo Inteligencia Artificial e ChatGPT: Da revolucao dos... Por Fabricio Carraro — Casa do Codigo