Are there placeholders for the user/password in the dao.xml?

Larry


On 7/24/06, Christina Xu <[EMAIL PROTECTED]> wrote:
Hello All,

I have a requirement to Dynamic set username/password
when create JDBC connection. So what I have is :

<sqlmapConfig>
   <properties resource="dataSourse.properties" />
   <transactionManager type="JDBC" >
      <dataSource type="SIMPLE" >
      <property name="JDBC.Driver" value="${driver}"
/>
      <property name="JDBC.ConnectionURL"
value="${url}" />
      <property name="JDBC.DefaultAutoCommit"
value="false" />
      ...
      ...
    </dataSource>
   </transactionManager>
...
...
</sqlMapConfig>

In java,

public void loadDaoManager(String username, String
password) {

String dbSource="dao.xml"
Properties daoProp = new Properties();
daoProp.put("JDBC.username", username);
daoProp.put("JDBC.password", password);

Reader reader =
Resources.getResourceAsReader(dbSource);
daoManager =
DaoManagerBuilder.buildDaoManager(reader.daoProp);
...
...

}

When I run this, I got Error
"com.ibatis.common.exception.NestedRuntimeException:
SimpleDataSource: Some properties were not set."

My question is is it possible to Dynamic give
username/password in the properties instead hardcode
in .xml file? If yes, can someone give me direction on
how? Thanks a lot.



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Reply via email to