You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Christina Xu <ch...@yahoo.com> on 2006/07/24 15:42:10 UTC
Dynamically passing username/password while create JDBC connection in buildDaoManager
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
Re: Dynamically passing username/password while create JDBC connection in buildDaoManager
Posted by Christina Xu <ch...@yahoo.com>.
How could I put username/password in dao.xml file?
in dao.xml file I have:
<!DOCTYPE daoConfig PUBLIC "-//ibatis.apache.org//DTD
DAO Configuration
2.0//EN" "http://ibatis.apache.org/dtd/dao-2.dtd">
<daoConfig>
<context>
<transactionManager type="SQLMAP">
<property name="SqlMapConfigResource"
value="sql-map-config.xml"/>
</transactionManager>
<dao interface="com.abc.dao.ContentOrderDao"
implementation="com.abc.dao.sqlmap.SqlMapDao"/>
</context>
</daoConfig>
in sql-map-config.xml file I have:
<sqlMapConfig>
<properties resource="dataSource.properties" />
</sqlMapConfig>
So When I put username/password to
dataSource.properties file it works fine. BUT, but
when I put EMPTY username/password (just for
placehold) or fake username/password in
dataSource.properties it brakes.
driver=oracle.jdbc.driver.OracleDriver
url=jdbc.oracle.thin:@hostname:1521:SID
username=
password=
The way IBATIS behaive looks like to me it didn't take
the properties passing to the
DaoManagerBuilder.buildDaoManager(reader, properties).
in java I have:
Properties daoProp = new Properties();
daoProp.put("JDBC.username", username);
daoProp.put("JDBC.password", password);
Reader reader =
Resources.getResourceAsReader(dbSource);
daoManager = DaoManagerBuilder.buildDaoManager(reader,
daoProp);
Should IBatis get this JDBC.username and JDBC.password
from daoProp instead of .xml or other property files.
Thanks, Help is really needed .
--- Larry Meadors <lm...@apache.org> wrote:
> Oh, OK - you need to add those to the dao.xml file,
> too.
>
> Larry
>
>
> On 7/24/06, Christina Xu <ch...@yahoo.com> wrote:
> > No. I don't have user/password defined in dao.xml.
> Not
> > in any .xml or property files.
> >
> > In dataSource.properties file, I only have
> >
> > driver=oracle.jdbc.driver.OracleDriver
> > url=jdbc.oracle.thin:@hostname:1521:SID
> >
> > Any help is appreciated. Thanks.
> >
> > --- Larry Meadors <lm...@apache.org> wrote:
> >
> > > Are there placeholders for the user/password in
> the
> > > dao.xml?
> > >
> > > Larry
> > >
> > >
> > > On 7/24/06, Christina Xu <ch...@yahoo.com>
> 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
> > > >
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: Dynamically passing username/password while create JDBC connection in buildDaoManager
Posted by Larry Meadors <lm...@apache.org>.
Oh, OK - you need to add those to the dao.xml file, too.
Larry
On 7/24/06, Christina Xu <ch...@yahoo.com> wrote:
> No. I don't have user/password defined in dao.xml. Not
> in any .xml or property files.
>
> In dataSource.properties file, I only have
>
> driver=oracle.jdbc.driver.OracleDriver
> url=jdbc.oracle.thin:@hostname:1521:SID
>
> Any help is appreciated. Thanks.
>
> --- Larry Meadors <lm...@apache.org> wrote:
>
> > Are there placeholders for the user/password in the
> > dao.xml?
> >
> > Larry
> >
> >
> > On 7/24/06, Christina Xu <ch...@yahoo.com> 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
> > >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
Re: Dynamically passing username/password while create JDBC connection in buildDaoManager
Posted by Christina Xu <ch...@yahoo.com>.
No. I don't have user/password defined in dao.xml. Not
in any .xml or property files.
In dataSource.properties file, I only have
driver=oracle.jdbc.driver.OracleDriver
url=jdbc.oracle.thin:@hostname:1521:SID
Any help is appreciated. Thanks.
--- Larry Meadors <lm...@apache.org> wrote:
> Are there placeholders for the user/password in the
> dao.xml?
>
> Larry
>
>
> On 7/24/06, Christina Xu <ch...@yahoo.com> 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
> >
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: Dynamically passing username/password while create JDBC connection in buildDaoManager
Posted by Larry Meadors <lm...@apache.org>.
Are there placeholders for the user/password in the dao.xml?
Larry
On 7/24/06, Christina Xu <ch...@yahoo.com> 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
>