---------- Forwarded message ---------- From: Brandon Goodin <[EMAIL PROTECTED]> Date: Jun 9, 2005 4:26 PM Subject: Re: creating tables and dynamic configiration To: [EMAIL PROTECTED]
larry's idea is better. Mine sucks. Brandon On 6/9/05, Larry Meadors <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > ---------- Forwarded message ---------- > > From: Dmitry Skavish <[EMAIL PROTECTED]> > > Date: Jun 9, 2005 3:35 PM > > Subject: Re: creating tables and dynamic configiration > > To: Brandon Goodin <[EMAIL PROTECTED]> > > > > > > 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 > > >
