SV: Calling procedures from 2 different databases

Hi there! One database per SqlmapConfig - that's the rule. But if your databases and the data is tightly coupled and if you don't need a different sqlMapConfig setting setup (don't need ping query, lazyLoadingEnabled setting etc) Wouldn't it be more clean to have one sqlMapConfig file ?

SV: Connecting to 2 different Databases

Hi there! Your real problem working with 2 different databases, is that they are of different versions and as long the driver class is the same in 8i and 9i, your are stuck to one driver :-) As far as I know how. What you could try, is to use a 8i driver to see if the query runs agains

SV: Updated IDEA plug-in for iBATIS

Hi there! This plugin looks great, but are you also thinking about a feature like this: Generate CRUD SQL . with default class or alias as input param ? ??? This feature should also have the possibilities to change the default query names for each CRUD operation from e.g:

SV: Updated IDEA plug-in for iBATIS

Hi again! To quick respons last time: We now have intentions for automatically creating result maps and all CRUD operations (insert, select, update, and delete). Yes you are planning automatically creating all CRUD operations :-) That's realy good! ... but remember the option to override the

SV: Pagination

Hi there! In your dao class you can call the sqlMap for example like this: result = sqlMap.queryForList(searchCompanies, searchBean, ((pageNumber-1) * pageSize), pageSize); Use of variables named like this, makes it more easy to read if you ask me :-) Take care, Erlend -Opprinnelig

SV: Pagination

To make it more clear... then your first page starts on page 1 (pageNumber = 1) .. so you don't have to transform the value you send in for page 1, to 0 :-) Clear as ink :-) -Opprinnelig melding- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sendt: 2. juli 2007 18:13 Til:

SV: Lack of BeanInfo support

Hi ! Don't fall for Sun Standards. I did, and iBATIS is worse for it. Interesting, can you tell us a little more about that ? whats worse ? J Thanks, Erlend

SV: Automatic rollback with Spring for junit tests ? SOLUTION :-)

Hi! Just use AbstractTransactionalDatabaseTestCase or whatever it's called. It's not called that, will try to look find it, but do you know the name ? Sounds more easy to use if it do what I think it does :-) Thanks! Erlend

Automatic rollback with Spring for junit tests ?

Hi there! Im trying to set up some junit tests and want to take automatically a rollback for each test, in a Spring context. Any clues how to set this property transactionManager (see below for the error) correctly in Spring ? I have tried to use the

SV: Automatic rollback with Spring for junit tests ? SOLUTION :-)

Hi there! I was struggling with this problem, then I finally realized the problem, ME J I have been using Hibernate with Spring (someone else has setup the transactionManager stuff), and when I realized what I was actually missing then wola J This line here in the spring-dao.xml

SV: Flushing of oscache in a cluster ?

Hi Brian! Are you sure you need to cache? Pretty sure :-) Have worked pretty well so fare. What metrics do you have to warrant the additional complexity? Until now we haven't seen it with extra complexity. When I started to use it, I liked it a lot :-) The shit hit the fan :-) when we

SV: Abator wishlist

Hi there! Gareth wrote: Most of the hand written domain objects I have are completely flat POJOs - there is no separate class for primary key - most of the time, there are no primary keys on the database - so I'd like all of the Abator generated objects to be the same. Can we turn off

SV: Abator wishlist

Hi there Jeff! The primary key class is seperated so that the method signatures for selectByPrimaryKey and deleteByPrimaryKey can only require the primary key, and not the class that represents the entire row. I see, was thinking about that, but I havent got that problem, I always

SV: Abator wishlist

Hi therae Christopher! PrimaryKey class in the first place the impact would have been greatly reduced and almost negligible. I learned my lesson and now always create a PrimaryKey class for every Domain object. And as you stated below, it provides a much cleaner interface to the

SV: pager in ibatis

Hi there! Yusuf wrote I think it's better off making the paging logic yourself in the application, and then querying only the records you want to show, for example in oracle you can use the rownum to fetch the data like select * from (select rownum row, a.* from tabel1 as a) where row between

Connection hangs with SQL query string 1983 of length, can this be a SQLMap bug ?

Hi there! When digging for the error in my previous message: Possible to set timeout on the connection ? I came over a very strange bug somewhere from SQLMap, the Oracle driver classes12.jar and to the database Oracle 9.2. I do a plain SQL without binding variables (I do $complexWhere$ -

SV: Connection hangs with SQL query string 1983 of length, can this be a SQLMap bug ?

Hi there! Wow, that is a wacky one..it seems most likely that it is a driver issue (i can promise that there is no if(sql.length() == 1983) blowChunks(); code in SQL Maps. :-) Can you try it with the latest Oracle drivers? From all reports, the 10g drivers resolved a ton of bugs that were

How to force Integer instead BigDecimal with queryForMap for the value part ?

Title: Melding Hi there! I have a queryForMap like this: HashMap codes = (HashMap) sqlMap.queryForMap("retrieveAdminUserAccessCodes","testUser", "CODE", "VALUE")); And the query like this: select id="retrieveAdminUserAccessCodes" resultClass="java.util.HashMap"

SV: [REPOST] sqlMap + multiple deletes: getting the total number of rows deleted

Hi there! Have you tried with FK and cascade delete ? Which means one delete statement, but behind the scene, deletes in several tables, the number of deleted rows should then be correct ? Erlend --- [Looks like my first post got lost when the list went down :-/] Hi, I'm a newbie to

SV: Capitlizing first letter in words

Title: Melding Hi there! One easy trick is to use the database function, in Oracle: initcap select initcap(name), initcap(contactperson) ... from company -- But still you have the problem with words that you don't want to initcap .. words like: and, or ... -- Let me know if you

SV: SAXParseException, parsing the sqlMap-config.xml file!

Hi there! Apparently you have an element type that is not in proper order with the DTD. You are right, after downloaded the JEdit (thanks for the tip) with the xml parser plugin, tested with the sqlMap-config file from the sqlMap pdf file ... I found out it was the order. I had it like this:

SAXParseException, parsing the sqlMap-config.xml file!

Title: Melding Hi there! In my IntelliJ, in our Resin web applications it all works just fine with SQLMap, but when I tries to run a scheduler job (Quartz) from command prompt using SQLMap from a .bat file (I run the job from IntelliJ it works fine)it seems thatsuddenly the parsingof