Erro de The user must supply a JDBC connection (HIbernate 3 + as400 db2)

Assuntos Gerais
#1

Alguem já viu esse erro?

10:33:39,969 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
10:33:40,031 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - HQL: from naval.model.HistoriaClinica where (AAACTR*10000)+(MMACTR*100)+DDACTR >= :dataInicio AND (AAACTR*10000)+(MMACTR*100)+DDACTR <= :dataFim
10:33:40,156 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.hql.ast.QueryTranslatorImpl - SQL: select historiacl0_.NRHCLP as NRHCLP4_, historiacl0_.DSRUNP as DSRUNP4_, historiacl0_.SEXOP as SEXOP4_, historiacl0_.DDACTR as DDACTR4_, historiacl0_.MMNAC as MMNAC4_, historiacl0_.AANAC as AANAC4_, historiacl0_.INST2 as INST13_4_, historiacl0_.DIREC as DIREC4_, historiacl0_.CODCIU as CODCIU4_, historiacl0_.FONO as FONO4_, historiacl0_.MMACTR as MMACTR4_, historiacl0_.AAACTR as AAACTR4_, historiacl0_.CODCOM as CODCOM4_, historiacl0_.DDNAC as DDNAC4_, historiacl0_.ESTCIVP as ESTCIVP4_ from HC01PF historiacl0_ where AAACTR*10000+MMACTR*100+DDACTR>=? and AAACTR*10000+MMACTR*100+DDACTR<=?
10:33:40,484 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.hql.ast.ErrorCounter - throwQueryException() : no errors
10:33:40,531 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.engine.query.HQLQueryPlan - HQL param location recognition took 15 mills (from HistoriaClinica where (AAACTR*10000)+(MMACTR*100)+DDACTR >= :dataInicio AND (AAACTR*10000)+(MMACTR*100)+DDACTR <= :dataFim)
10:33:40,781 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.engine.query.QueryPlanCache - located HQL query plan in cache (from HistoriaClinica where (AAACTR*10000)+(MMACTR*100)+DDACTR >= :dataInicio AND (AAACTR*10000)+(MMACTR*100)+DDACTR <= :dataFim)
10:33:40,844 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.engine.query.HQLQueryPlan - find: from HistoriaClinica where (AAACTR*10000)+(MMACTR*100)+DDACTR >= :dataInicio AND (AAACTR*10000)+(MMACTR*100)+DDACTR <= :dataFim
10:33:41,016 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.engine.QueryParameters - named parameters: {dataInicio=20061116, dataFim=20061116}
10:33:41,016 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.jdbc.AbstractBatcher - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
10:33:41,031 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.jdbc.ConnectionManager - opening JDBC connection
10:33:41,172 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.jdbc.JDBCContext - after autocommit
10:33:41,188 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.jdbc.ConnectionManager - aggressively releasing JDBC connection
10:33:41,203 [DefaultQuartzScheduler_Worker-0] DEBUG org.hibernate.impl.SessionImpl - after transaction completion
10:33:41,344 [DefaultQuartzScheduler_Worker-0] ERROR org.quartz.core.JobRunShell - Job DEFAULT.SendMsg threw an unhandled Exception: 
java.lang.UnsupportedOperationException: The user must supply a JDBC connection
	at org.hibernate.connection.UserSuppliedConnectionProvider.getConnection(UserSuppliedConnectionProvider.java:30)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1560)
	at org.hibernate.loader.Loader.doQuery(Loader.java:661)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
	at org.hibernate.loader.Loader.doList(Loader.java:2144)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
	at org.hibernate.loader.Loader.list(Loader.java:2023)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at naval.model.dao.HistoriaClinicaDAO.queryEventos(HistoriaClinicaDAO.java:39)
	at naval.app.HistoriaClinicaRN.queryHistoriasClinica(HistoriaClinicaRN.java:51)
	at naval.app.SendMsg.execute(SendMsg.java:37)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:191)

tenho um arquivo config.cfg.xml está assim

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
		"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
		"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">com.ibm.as400.access.AS400JDBCDriver</property>
        <property name="hibernate.dialect">org.hibernate.dialect.DB2400Dialect</property>
		<property name="hibernate.connection.username">medicos</property>
		<property name="hibernate.connection.password">medicos</property>
		<!-- MAPEAMENTOS -->
		<mapping class="naval.model.Bairro" />
		<mapping class="naval.model.Cidade" />
		<mapping class="naval.model.Instituicao" />
		<mapping class="naval.model.Paciente" />
		<mapping class="naval.model.HistoriaClinica" />    
    </session-factory>
</hibernate-configuration>

e não estou usando um hibernate.properties.

Valeu!!

#2

alguem já viu isso?

The user must supply a JDBC connection

Hibernate 3.0, será que é um problema de acesso?

#3

E ai velhinho… Também estou com esse erro no meu projeto…

Segue abaixo meu hibernate.cfg.xml

org.hibernate.dialect.Oracle9Dialect jdbc:oracle:thin:@notemarcio:1521:ORCL2 oracle.jdbc.driver.OracleDriver system ma8283rc true true 
	<!-- Declarando os mapeamentos dos Javabens(Entity) -->
	<mapping class="br.com.oticasolarium.vo.UsuarioVO" />	
	
</session-factory>

Consigo conectar via JDBC normalmente… Só que estou implementando o Hibernate no meu projeto, e deu esse problema…

Vamos ver se alguem consegue nos ajudar.

Falow.

#4

Estou com o mesmo problema, alguem sabe como resolver?

#5