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 creating tables and dynamic configiration
Date Thu, 09 Jun 2005 22:26:43 GMT
---------- Forwarded message ----------
From: Brandon Goodin <brandon.goodin@gmail.com>
Date: Jun 9, 2005 4:26 PM
Subject: Re: creating tables and dynamic configiration
To: lmeadors@apache.org


larry's idea is better. Mine sucks.

Brandon

On 6/9/05, Larry Meadors <larry.meadors@gmail.com> wrote:
> 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