Re: What is the best way to get data from 2 different database having same table names

2005-12-28 Thread Nathan Maves
SMC is short hand for SqlMapClient. If you look at the API you will see that there is a method in the SqlMapClientBuilder class that takes a properties object. This properties can have the different connection information that you need to connect to different databases. What we are sugg

Re: What is the best way to get data from 2 different database having same table names

2005-12-28 Thread Ashish Kulkarni
Larry What is SMC and how do i create it? suppose i have a SQL statement like select * from myname.table1 and similarly have some thing like select * from diffname.table1 how do i on the fly execute one of the querries depending on user selection. table1 has same layout Ashish --- Larry Mead

Dimamy ResultMap

2005-12-28 Thread Marco Berri
Hello! Is Possible generate a dynamic resultmap for field ? es. select a, b, $fields_b$ from t1 Where the fields_b is "d, e" The resultMap return fields "d" and "e" ? How i Mapping the field not specify in resultMap ? Thank's Marco Berri