Dynamic tables.

2005-11-01 Thread David Moss
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

Re: Dynamic tables.

2005-11-01 Thread Larry Meadors
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 to

Feature of resultset.getGeneratedKeys

2005-11-01 Thread Tat Leong Chong
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 selectKey Select LAST_INSERT_ID() as id/selectKey?2. In the current

N+1 with column renaming

2005-11-01 Thread Paul Benedict
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: resultMap

Re: N+1 with column renaming

2005-11-01 Thread Larry Meadors
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

Re: Feature of resultset.getGeneratedKeys

2005-11-01 Thread Larry Meadors
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 the

RE: Problems applying parameter map property

2005-11-01 Thread Niels Beekman
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:

RE: Feature of resultset.getGeneratedKeys

2005-11-01 Thread Niels Beekman
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: Feature of resultset.getGeneratedKeys

2005-11-01 Thread John Hurst
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

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

2005-11-01 Thread Siming Weng
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