ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: iBatis configuration problem
Date Wed, 28 May 2008 16:09:40 GMT
You have sqlMapConfig->sqlMapConfig->sqlMap.  This is not correct.

Delete sqlMapCollection.xml.  Reference tts_user.xml directly in
sqlMapConfig.xml.

Jeff Butler

On Wed, May 28, 2008 at 10:57 AM, cuong PN <pncuong83@yahoo.com> wrote:

>
> Hi guys
>
> I've been looking at this, searching the Internet, trying this and that but
> nothing works yet. I'd greatly appreciate any help to resolve this. Thanks
> so so much!
>
> When I run, I got this error:
>
> com.ibatis.sqlmap.client.SqlMapException: There is no statement named
> TTS_USER.countUsers in this SqlMap.
>
> Even though after searching thru the net, I think my configuration looks
> right, at least the namespace part. Or am I wrong? Funny thing is even if I
> messed up the xml format of sqlmap file (like doing "</sqlMap----- #>"
> instead of a correct closing tag "</sqlMap>), nothing is complained about.
> Looks like SQLMaps isn't even reading that sqlmap file. Please kindly see
> details below:
>
> ---- sqlMapConfig.xml ------
> <?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">
>
> <sqlMapConfig>
>
> <properties resource="appSqlMapConfig.properties" />
>
> <settings
>    useStatementNamespaces="true"
> />
>
> <transactionManager type="JDBC" >
>    <dataSource type="JNDI">
>        <property name="DataSource" value="${appJNDI}"/>
>    </dataSource>
> </transactionManager>
>
> <sqlMap resource="sqlMapCollection.xml" />
> </sqlMapConfig>
>
> ----  End of sqlMapConfig.xml ------
>
>
> ---- sqlMapCollection.xml ------
> <?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">
>
> <sqlMapConfig>
>    <sqlMap resource="sqlmap/sql/tts_user.xml" />
> </sqlMapConfig>
>
> ---- End of sqlMapCollection.xml ------
>
>
> ---- tts_user.xml ----
> <?xml version="1.0" encoding="UTF-8" ?>
> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
> "http://ibatis.apache.org/dtd/sql-map-2.dtd">
>
> <sqlMap namespace="TTS_USER">
>    <select id="countUsers" resultClass="Integer">
>        select count(*) from users
>    </select>
> </sqlMap>
> ---- End of tts_user.xml ----
>
> And here's how I configure SQLMaps from java file:
>
>            private static Reader reader;
>            private static String sqlMapConfigResource =
> "location/to/config/file";
>
>            ...
>            reader = Resources.getResourceAsReader(sqlMapConfigResource);
>            sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);
>            List resultList = sqlMapper.queryForList("TTS_USER.countUsers");
>            logger.debug(resultList);
>            reader.close();
>
> Hope to hear from your reply soon! Thanks again!
> --
> View this message in context:
> http://www.nabble.com/iBatis-configuration-problem-tp17516022p17516022.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>

Mime
View raw message