ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: creating tables and dynamic configiration
Date Thu, 09 Jun 2005 22:23:06 GMT
Ooooh, Ok.

Use the SqlMapClient's buildSqlMapClient(Reader reader, Properties
props) method.

You can pass in the properties at runtime that way.

Larry

On 6/9/05, Brandon Goodin <brandon.goodin@gmail.com> wrote:
> ---------- Forwarded message ----------
> From: Dmitry Skavish <skavish@gmail.com>
> Date: Jun 9, 2005 3:35 PM
> Subject: Re: creating tables and dynamic configiration
> To: Brandon Goodin <brandon.goodin@gmail.com>
> 
> 
> Let me explain. I am developing a client side app, that is with gui
> and such, not a web app.
> The app will be querying/updating db as part of what it's doing. When
> the app starts it would prompt a dialog asking user to enter
> username/password. This username/password will be used to access the
> db. I don't use any connection pool because there will be exactly one
> connection. So basically I need to pass these user/pwd to ibatis at
> runtime. Currently they are hardcoded in ibatis xml resource. That's
> why I mentioned generation of this xml. I can parse it, replace some
> properties (that is user/pwd) and feed it to ibatis. I consider it to
> be a hack and if there is a better workaround I would prefer to use
> it. I hope it's clear. Thanks!
> 
> > #2 I'm not sure what xml generation has to do with this issue. Maybe i
> > am misunderstanding you. If you are developing a web application you
> > will have to do something like what was provided if you want
> > individuals to use their own username and password for database
> > access. Considering you work with connection pools there is no easy
> > way to add a username and password to the connection and maintain
> > security without doing what the link mentioned. So, this is not an
> > issue with iBatis as much as it is an issue with pooled connections.
> >
> > Brandon
> >
> > On 6/9/05, Dmitry Skavish <skavish@gmail.com> wrote:
> > > > 1) iBatis does not support DDL script execution.
> > >
> > > Are there any plans to support this?
> > >
> > > > 2) http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+connect+using+a+user%27s+credentials%3F
> > >
> > > It seems to be an overkill for such simple thing. If this is the only
> > > way? I would rather generate xml and give it to iBatis than doing what
> > > is suggested there.
> > >
> > > >
> > > > Brandon
> > > >
> > > > On 6/9/05, Dmitry Skavish <skavish@gmail.com> wrote:
> > > > > Hello everybody,
> > > > >
> > > > > I am pretty new to iBATIS, but already love it! I have couple of
questions:
> > > > >
> > > > > 1. I am developing a client app which will be using iBatis. On the
> > > > > first run I want to create tables in a db if they are not there yet.
> > > > > Can I use iBatis for that? If yes how? Basically I need to send a
> > > > > bunch of "create table ..." in one transaction. Currently I get
> > > > > connection manually from jdbc and then create stmt and create all
> > > > > those tables. I would prefer to do it via iBatis the same way I query
> > > > > or update it. Another related problem is that i was trying to obtain
> > > > > connection from iBatis using this code:
> > > > >
> > > > >       SqlMapClient map ....
> > > > >
> > > > >       map.startTransaction();
> > > > >       Connection connection = map.getCurrentConnection();
> > > > >       createDB(connection);
> > > > >       map.endTransaction();
> > > > >
> > > > > but it fails on the first sql, some noninformant jdbc exception saying
> > > > > that transaction is aborted without any clue why. I use postgress
db.
> > > > >
> > > > > 2. How do I pass connection properties, i.e. user, password, in
> > > > > runtime. I mean I don't want it to be hardcoded in xml config.
> > > > >
> > > > > Thanks!
> > > > > --
> > > > > Dmitry Skavish
> > > > >
> > > >
> > >
> > >
> > > --
> > > Dmitry Skavish
> > >
> >
> 
> 
> --
> Dmitry Skavish
>

Mime
View raw message