ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Fwd: creating tables and dynamic configiration
Date Thu, 09 Jun 2005 22:11:29 GMT
---------- 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