custom db.properties

Hi all! Is there some way to dynamically pass properties to iBatis for configuring database access instead of providing in mapping configuration file? We have encrypted passwords in db.properties which should be decrypted on the fly. -- Eugene N Dzhurinsky

Re: how to map unsigned bigint in MySql to long value

A defected connector/j 3.1.4 beta is used when the project is initially created. It failed to map unsigned bigint to java.math.BigInteger. Thanks a lot for your assistance. On 10/28/05, Jeff Butler <[EMAIL PROTECTED]> wrote: > I've tried your exact example (as close as I can replicate), and don't

RE: Feature of resultset.getGeneratedKeys

I don't know if the question is just for MySQL, but in my tests of Firebird with the Jaybird driver I found that it screws this up. That is, if you do SELECT GEN_ID(gen_song, 1) FROM rdb$database -- increments And then later in the same thread with the same Connection: SELECT G

RE: Feature of resultset.getGeneratedKeys

This feature has been available as of JDBC 3.0 (so actually JDK1.4), but is not available in iBATIS. There is already an issue in JIRA for it, so you could vote for it to increase the chance it gets implemented (I believe): http://issues.apache.org/jira/browse/IBATIS-142 Niels __

RE: Problems applying parameter map property

Just a guess, can you try to remove the CDATA-tags? There have been a number of people that reported similar issues. Niels -Original Message- From: Daniel Henrique Ferreira e Silva [mailto:[EMAIL PROTECTED] Sent: woensdag 2 november 2005 2:01 To: user-java@ibatis.apache.org Subject: Prob

Re: Feature of resultset.getGeneratedKeys

1) Nope. 2) Depends on the driver, but in every case I have seen, no. Larry On 11/1/05, Tat Leong Chong <[EMAIL PROTECTED]> wrote: > Hi, > > I am new to Ibatis and using MySQL for company > MIS development. We found the new feature in JDK1.5 > for getGeneratedKeys. > > 1. I am curious that is t

Re: N+1 with column renaming

I generally name my key fields uniquely, but leave the others what they are, for example: create table Fruit ( fruitId int, name varchar(30) ) Then if I join to another table with a "name" field, I alias them to include the table name (so, in this case i would use "fruitName"). That said..it

N+1 with column renaming

Maybe someone has encountered this problem and would like to lend a hand. Many of the tables that I have have column names that are not unique across tables. At the moment, I have taken the solution to rename each column in my query and each resultMap knows what to look for: So I

Feature of resultset.getGeneratedKeys

Hi, I am new to Ibatis and using MySQL for company MIS development. We found the new feature in JDK1.5for getGeneratedKeys. 1. I am curious that is the current version 2.1.5Ibatis already support this feature instead of usingthe Select LAST_INSERT_ID() as id?2. In the current version of IBATIS, Se

Problems applying parameter map property

Hey all, I'm getting an annoying error that is giving me such a great headache as i can't figure it out. Database: Oracle 9iR2 Container: Resin 3.0.14 OS: Windows XP SP2 iBATIS version: 2.1.5.582 Here is my problem: I have this statement with its parameter map:

Re: Dynamic tables.

First off, DDL is unsupported. If it works, swell; If not, bummer. You may be able to do the insert using $substitution$ and #parameters# with iterate tags - I have never tried that, but give it a shot - it may work. Larry On 11/1/05, David Moss <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying t

Dynamic tables.

Hi, I'm trying to create a system that dynamically generates a table and inserts content according to the attributes of a dynamic data set (from imported files). The data is actually from ESRI shape files, which require a table each for their attribute information. I believe that I've been