Re: MS Access selectKey question

I have no way of changing anyhing about the application, sadly. I will try your second soulution., and tell you how it went.. thanks in advance ;) > If you can change the "Number" id to "AutoNumber" you won't have to do the > combined > select/insert thing... if you can't, well, I'm not an iBatis

Re: MS Access selectKey question

If you can change the "Number" id to "AutoNumber" you won't have to do the combined select/insert thing... if you can't, well, I'm not an iBatis expert but it sounds like you'll have to do the selecting of the next id separate from the insert. Of course then you might have to worry about multipl

Re: MS Access selectKey question

Thanks for the replies guys. Sorry for the late response.. The id property doesnt exist in the object im inserting, its only an internal identifier in the access database. In the database this is defined as Number. And i am stuck with access, as this system is already deployed and widely used.. An

callable statement to multiple objects multipurpose giant stp

can ibatis map the results from one stored procedure in oracle to multiple result sets? see complex e.g. stp Weird- if input param 1 then does select * from X select * from table Y else select * from f select * from table g - in ibatis can this stp be ma

RE: N+ 1 selects

Hello John, As far as I can see in your xml excerpt, you are not using the "groupBy" feature of SqlMaps to avoid the N+1 select problem. What you are doing in that example is using the SQL "GROUP BY" clause which is completely different from the SqlMaps N+1 solution (maybe it should be renamed to

Re: N+ 1 selects

Give us a stack trace, too, please. Larry On 9/28/05, John Chien <[EMAIL PROTECTED]> wrote: > Dear Sir: > > I follow the FAQ to fix the N+1 selects, However, I continue get the > compilation error. > My xml looks like: > > > > PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" > "http://www.i

N+ 1 selects

Dear Sir: I follow the FAQ to fix the N+1 selects, However, I continue get the compilation error. My xml looks like: http://www.ibatis.com/dtd/sql-map-2.dtd";> type="us.nc.state.enr.bets.util.EhsInspectorBean"/> type="us.nc.state.enr.bets.finder.CommonFinder" /> groupBy="key">

Passing logged in Username and password to iBATIS

Hi,       I have included this piece of code before getting the DAO instance from DAOManager.           SqlMapDaoTransaction trans = (SqlMapDaoTransaction) daoManager.getTransaction(daoManager.getDao(daoClass));        SqlMapClient sqlMapClient = trans.getSqlMap();        Connection conTem

Re: Passing logged in Username and password to iBATIS

Hi,       I have even tried supyling sqlMapClient.endTransaction() and sqlMapClient.commit() after the sqlMapClient.setUserConnection(conTemp) statement. But even I got a error which goes like "commit() cannot be given when you use container-managed transactions". Vijai - Original Me

Re: Passing logged in Username and password to iBATIS

Hi Larry,       I have included this piece of code before getting the DAO infstance from DAOManager.           SqlMapDaoTransaction trans = (SqlMapDaoTransaction) daoManager.getTransaction(daoManager.getDao(daoClass));        SqlMapClient sqlMapClient = trans.getSqlMap();        Connection

Re: Quetion about documents

I personally like the PDF documentation. I think the wiki is good for one off examples or learning about a specific part of iBATIS. The PDF seems to flow together more like a good book. After I'm done reading a section I usually continue reading the next section. After 15min or so I find that I've

Re: Reusing sqlmap definitions

I take an approach that avoids the problem of ordering the imports in your main config file. Alternately, you can put all queries that returnA objects in the A mapping file. So A's mapping contains the result map for an A, and queries that return A's, such as getAForB. B's mapping contains the resu

Re: MS Access selectKey question

Uhm, I do not think you can execute two statements with the same connection using the jdbc-odbc bridge. Is using Access a hard requirement for you? If it is, you need to find a real JDBC driver, which may mean you need to buy a commercial driver for it. Larry On 9/28/05, Michael Campbell <[EMAI

Re: MS Access selectKey question

On 9/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hey, > Im having some difficulties inserting rows into ms access. The error i get > is: > > ... > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in org/hisp/dhis/hmis/RoutineData.ibatis.xml. --- > T

Re: Reusing sqlmap definitions

Thanks James i think it's not necessary to enable namespaces in sqlMapConfig, the most import thing is the sqlmap import order in sqlMapConfig, it's relevant (jira: ibatis-135) My error was there, reordered the sqlmap files in sqlMapConfig all works fine. Fabio James, Steven wrote: Never

RE: Reusing sqlmap definitions

Never done this but i think it is all to do with namespaces. So have a look at the wiki or documentation on namespace. From: fabio bongiovanni [mailto:[EMAIL PROTECTED] Sent: Wed 28/09/2005 09:51 To: user-java@ibatis.apache.org Subject: Reusing sqlmap definitions

Reusing sqlmap definitions

Hello and thanks in advice I've defined 2 sqlmap A and B i need to make a query in sqlmap A that return one or more "item" defined with a resultmap in sqlmap B Could someone point me to any doc, example about that? Fabio

MS Access selectKey question

Hey, Im having some difficulties inserting rows into ms access. The error i get is: ... Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in org/hisp/dhis/hmis/RoutineData.ibatis.xml. --- The error occurred while applying a parameter map. --- Check the addRouti