Re: Ibatis DAO XML problem

[Jeff Butler]

I'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: user-java@ibatis.apache.org
Assunto: RE: Ibatis DAO XML problem

If 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: 'user-java@ibatis.apache.org'
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: user-java@ibatis.apache.org
Assunto: RE: Ibatis DAO XML problem

I 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: user-java@ibatis.apache.org
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