driver=com.informix.jdbc.IfxDriver
url="" color=#2a00ff>jdbc:informix-sqli://10.11.101.6:668/polimed4:INFORMIXSERVER=df06
username=user
password=pass
-----Mensagem original-----
De: Jeff Butler [mailto:[EMAIL PROTECTED]
Enviada em: segunda-feira, 19 de junho de 2006 12:20
Para: [email protected]
Assunto: Re: Ibatis DAO XML problemI'm pretty certain this is related to your database connection settings. Send along a copy of your SqlMapConfig.properties file. Probably something is wrong there.Jeff Butler
On 6/19/06, Cristiano Monteiro dos Santos <[EMAIL PROTECTED]> wrote:The fixed doctipe I'm using now is:<?
xml version="1.0" encoding ="UTF-8" ?><!
DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd ">But still getting the error. Ideas?
Thanks!
-----Mensagem original-----
De: Niels Beekman [mailto:[EMAIL PROTECTED]]Enviada em: segunda-feira, 19 de junho de 2006 11:57
Para: [email protected]
Assunto: RE: Ibatis DAO XML problemIf you fixed the DOCTYPE declaration, it should all work, do you still get the same exception?
From: Cristiano Monteiro dos Santos [mailto: [EMAIL PROTECTED]]
Sent: maandag 19 juni 2006 16:35
To: '[email protected]'
Subject: RES: Ibatis DAO XML problem
This information is closer to the one I get from google about this problem. How can I solve this? Also, I've already fixed the other observations from Jeff.
Thanks,
CMS
-----Mensagem original-----
De: Niels Beekman [mailto: [EMAIL PROTECTED]]
Enviada em: segunda-feira, 19 de junho de 2006 11:29
Para: [email protected]
Assunto: RE: Ibatis DAO XML problemI believe the "connection refused" is actually the result of the wrong DOCTYPE declaration, the DTD cannot be resolved.
Niels
From: Jeff Butler [mailto: [EMAIL PROTECTED]]
Sent: maandag 19 juni 2006 16:25
To: [email protected]
Subject: Re: Ibatis DAO XML problem
The cause of error is "connection refused". This implies that there is something wrong with your database connection settings.
Other things I noticed (these are not causing your error, but could cause other errors):
1. You need to specify useStatementNamespaces="true". You'll not get far with Abator if you disable namespaces.
2. The DOCTYPE declaration is wrong - please see the iBATIS home page for the new DOCTYPE declarations.
Jeff Butler
On 6/19/06, Cristiano Monteiro dos Santos < [EMAIL PROTECTED]> wrote:
Hi there!
I'm new to iBATIS and I'm having problem on executing JUnit tests. I'm using
Abator for some code generation for a simple CRUD app I have to build. I've
mapped all the abator's xml in the SqlMapConfig.xml, like this:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<properties resource="SqlMapConfig.properties " />
<settings cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" maxRequests="32" maxSessions="10"
maxTransactions="5" useStatementNamespaces="false" />
<typeAlias alias="order" type="testdomain.Order" />
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="${driver}" />
<property name="JDBC.ConnectionURL " value="${url}"
/>
<property name="JDBC.Username" value="${username}"
/>
<property name="JDBC.Password" value="${password}"
/>
</dataSource>
</transactionManager>
<sqlMap
resource="br/com/polimed/ibatis/polimed4/model/informix_tbcartaocategoria_Sq
lMap.xml" />
<sqlMap
resource="br/com/polimed/ibatis/polimed4/model/informix_tbcartaoespec_SqlMap
.xml" />
<sqlMap
resource="br/com/polimed/ibatis/polimed4/model/informix_tbespecialidade_SqlM
ap.xml" />
</sqlMapConfig>
But as I try to configure my DAO like this:
Reader reader = Resources.getResourceAsReader( "SqlMapConfig.xml" );
Tb301autogeradoDAO dao = new Tb301autogeradoDAOImpl(
DaoManagerBuilder.buildDaoManager( reader ) );
I receive this error:
com.ibatis.dao.client.DaoException: Error while configuring DaoManager.
Cause: com.ibatis.common.exception.NestedRuntimeException: XML Parser Error.
Cause: java.net.ConnectException: Connection refused: connect
Caused by: com.ibatis.common.exception.NestedRuntimeException: XML Parser
Error. Cause: java.net.ConnectException: Connection refused: connect
at
com.ibatis.dao.engine.builder.xml.XmlDaoManagerBuilder.buildDaoManager(XmlDa
oManagerBuilder.java:129)
at
com.ibatis.dao.client.DaoManagerBuilder.buildDaoManager(DaoManagerBuilder.ja
va:59)
at
br.com.polimed.ibatis.sim.dao.Tb301autogeradoDAOImplTest.setUp(Tb301autogera
doDAOImplTest.java:17)
at junit.framework.TestCase.runBare(TestCase.java:125)
at junit.framework.TestResult$1.protect (TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3T
estReference.java:128)
at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:3
8)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRu
nner.java:460)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRu
nner.java:673)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.
java:386)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner
.java:196)
Caused by: com.ibatis.common.exception.NestedRuntimeException: XML Parser
Error. Cause: java.net.ConnectException : Connection refused: connect
at
com.ibatis.dao.engine.builder.xml.XmlDaoManagerBuilder.getDoc(XmlDaoManagerB
uilder.java:320)
at
com.ibatis.dao.engine.builder.xml.XmlDaoManagerBuilder.buildDaoManager (XmlDa
oManagerBuilder.java:88)
... 15 more
Caused by:
com.ibatis.common.exception.NestedRuntimeException: XML Parser Error.
Cause: java.net.ConnectException: Connection refused: connect
at
com.ibatis.dao.engine.builder.xml.XmlDaoManagerBuilder.getDoc(XmlDaoManagerB
uilder.java:320)
at
com.ibatis.dao.engine.builder.xml.XmlDaoManagerBuilder.buildDaoManager(XmlDa
oManagerBuilder.java:88)
at
com.ibatis.dao.client.DaoManagerBuilder.buildDaoManager(DaoManagerBuilder.ja
va:59)
at
br.com.polimed.ibatis.sim.dao.Tb301autogeradoDAOImplTest.setUp(Tb301autogera
doDAOImplTest.java:17)
at junit.framework.TestCase.runBare(TestCase.java:125)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run (TestSuite.java:203)
at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3T
estReference.java:128)
at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java :3
8)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRu
nner.java:460)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRu
nner.java :673)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.
java:386)
at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner
.java:196)
Any idea of what's happening? I've already searched Google and Jira for
those, with no concrete answer.
TIA!
Regards,
Cristiano
