Run Time exception

[haqabsaar]

Hi,
I am trying to create a POC for iBatis. I have trying to do some
configuration and getting the following error

14-Jun-2010 20:02:20 com.ibatis.common.logging.jdk14.Jdk14LoggingImpl
error
SEVERE: SimpleDataSource: Error while loading properties. Cause:
java.lang.RuntimeException: SimpleDataSource: Some properties were not
set

Here is the stack trace:

java.lang.RuntimeException: SimpleDataSource: Some properties were not
set.
at
com.ibatis.common.jdbc.SimpleDataSource.initialize(SimpleDataSource.java:
131)
at
com.ibatis.common.jdbc.SimpleDataSource.<init>(SimpleDataSource.java:
116)
at
com.ibatis.sqlmap.engine.datasource.SimpleDataSourceFactory.initialize(SimpleDataSourceFactory.java:
31)
at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser
$9.process(SqlMapConfigParser.java:220)
at
com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:
121)
at
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:105)
at
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
at
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
at
com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)
at
com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:51)
at
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:
46)
at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:
63)
at com.ociweb.music.LoadDB.main(LoadDB.java:19)
Exception in thread "main" java.lang.RuntimeException: Error
occurred. Cause: com.ibatis.common.xml.NodeletException: Error
parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/
sqlMapConfig/transactionManager/dataSource/end()'. Cause:
com.ibatis.sqlmap.client.SqlMapException: Error initializing
DataSource. Could not instantiate DataSourceFactory. Cause:
java.lang.RuntimeException: SimpleDataSource: Error while loading
properties. Cause: java.lang.RuntimeException: SimpleDataSource: Some
properties were not set.
at
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:
49)
at
com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:
63)
at com.ociweb.music.LoadDB.main(LoadDB.java:19)
Caused by: com.ibatis.common.xml.NodeletException: Error parsing XML.
Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/
transactionManager/dataSource/end()'. Cause:
com.ibatis.sqlmap.client.SqlMapException: Error initializing
DataSource. Could not instantiate DataSourceFactory. Cause:
java.lang.RuntimeException: SimpleDataSource: Error while loading
properties. Cause: java.lang.RuntimeException: SimpleDataSource: Some
properties were not set.
at
com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:53)
at
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:
46)
... 2 more
Caused by: java.lang.RuntimeException: Error parsing XPath '/
sqlMapConfig/transactionManager/dataSource/end()'. Cause:
com.ibatis.sqlmap.client.SqlMapException: Error initializing
DataSource. Could not instantiate DataSourceFactory. Cause:
java.lang.RuntimeException: SimpleDataSource: Error while loading
properties. Cause: java.lang.RuntimeException: SimpleDataSource: Some
properties were not set.
at
com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:
123)
at
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:105)
at
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
at
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:102)
at
com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:72)
at
com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:51)
... 3 more
Caused by: com.ibatis.sqlmap.client.SqlMapException: Error
initializing DataSource. Could not instantiate DataSourceFactory.
Cause: java.lang.RuntimeException: SimpleDataSource: Error while
loading properties. Cause: java.lang.RuntimeException:
SimpleDataSource: Some properties were not set.
at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser
$9.process(SqlMapConfigParser.java:227)
at
com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java:
121)
... 8 more
Caused by: java.lang.RuntimeException: SimpleDataSource: Error while
loading properties. Cause: java.lang.RuntimeException:
SimpleDataSource: Some properties were not set.
at
com.ibatis.common.jdbc.SimpleDataSource.initialize(SimpleDataSource.java:
210)
at
com.ibatis.common.jdbc.SimpleDataSource.<init>(SimpleDataSource.java:
116)
at
com.ibatis.sqlmap.engine.datasource.SimpleDataSourceFactory.initialize(SimpleDataSourceFactory.java:
31)
at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser
$9.process(SqlMapConfigParser.java:220)
... 9 more
Caused by: java.lang.RuntimeException: SimpleDataSource: Some
properties were not set.
at
com.ibatis.common.jdbc.SimpleDataSource.initialize(SimpleDataSource.java:
131)

The configuration that I am using is :

<?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>

<settings useStatementNamespaces="true"
cacheModelsEnabled="true"
enhancementEnabled="true"
maxSessions="64"
maxTransactions="8"
maxRequests="128"/>

<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.driver" value="com.mysql.jdbc.Driver"/>
<property name="JDBC.ConnectionURL" value="jdbc:mysql://
192.168.100.101:3306/bookmarks"/>
<property name="JDBC.Username" value="tbl"/>
<property name="JDBC.Password" value="tblpass"/>

<!-- <property name="JDBC.AutoCommit" value="true"/>
<property name="Pool.MaximumActiveConnections" value="10"/>
<property name="Pool.MaximumIdleConnections" value="5"/>
<property name="Pool.MaximumCheckoutTime" value="150000"/>
<property name="Pool.MaximumTimeToWait" value="500"/>
<property name="Pool.PingQuery" value="select 1 from Artists"/>
<property name="Pool.PingEnabled" value="false"/>-->
</dataSource>
</transactionManager>

<sqlMap resource="com/ociweb/music/Artist.xml"/>
<sqlMap resource="com/ociweb/music/Recording.xml"/>


</sqlMapConfig>

Any help/suggestion form the fellow members would be highly helpful.

Thanks

[Chema]

Try with

<property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>

not

<property name="JDBC.driver" value="com.mysql.jdbc.Driver"/>

I'm not sure but you can try it