ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From nath1 <vishwanath.manch...@yahoo.co.in>
Subject Re: com.ibatis.sqlmap.client.SqlMapException: There was an error while building the SqlMap instance
Date Mon, 21 Dec 2009 13:09:30 GMT

meindert-3, 
Thanks for the reply. Am also using MySql drivers but not mentioned in the
jar files listing..




nath1 wrote:
> 
> Hi
> Am very new to iBATIS. Am facing com.ibatis.sqlmap.client.SqlMapException:
> There was an error while building the SqlMap instance Exception. 
> 
> below is the SQLMapConfig.xml file:
> 
> <?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>
> 
>   <settings useStatementNamespaces="true"/>
>   
>   <transactionManager type="JDBC" commitRequired="false">
>     <dataSource type="SIMPLE">
>       <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
>       <property name="JDBC.ConnectionURL"
>         value="jdbc:mysql://localhost:3306/junk"/>
>       <property name="JDBC.Username" value="root"/>
>       <property name="JDBC.Password" value=""/>
>     </dataSource>
>   </transactionManager>
> 
>   <sqlMap resource="Contact.xml"/>
>  
> </sqlMapConfig>
> 
> 
> Contact.xml file:
> 
> <?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="Contact">
> 
> 	<!--- Inserting data in table -->
> 
> 	<insert id="insert" parameterClass="Contact">
> 		insert into contact (firstName,lastName,email)
> 		values (#firstName#, #lastName#, #email#)
> 		<selectKey resultClass="int" keyProperty="id">
> 				select last_insert_id() as id
> 		</selectKey>
>      </insert>
> 
> 	<!--- Showing all data of table -->
> 
> 	<select id="getAll" resultClass="Contact">
> 		select * from contact
> 	</select>
> 
> </sqlMap>
> 
> 
> I used jar files:
> 
> ibatis-common-2.jar      
> ibatis-dao-2.jar         
> ibatis-sqlmap-2.jar      
> sqljdbc.jar              
> commons-logging-1.0.4.jar
> 
> Please help to rectify the error....
> 
> Exception in Detail:
> 
> 
> 
> :com.ibatis.sqlmap.client.SqlMapException: There was an error while
> building the SqlMap instance.
> --- The error occurred in the SQL Map Configuration file.
> --- Cause: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. 
> Cause: java.net.ConnectExcep
> tion: Connection timed out: connect
> Caused by: java.net.ConnectException: Connection timed out: connect
> Caused by: com.ibatis.sqlmap.client.SqlMapException: XML Parser Error. 
> Cause: java.net.ConnectExcep
> tion: Connection timed out: connect
> Caused by: java.net.ConnectException: Connection timed out: connect
> 
> 

-- 
View this message in context: http://old.nabble.com/com.ibatis.sqlmap.client.SqlMapException%3A-There-was-an-error-while-building-the-SqlMap-instance-tp26872916p26873788.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message