Missing commit after select won't update cache

Hello, just wanted to check if this behavior is on purpose. For select Statements I use the following construct in my DAO. public ListJob selectJobs() { ListJob resultList = null; SqlSession session = getSqlSessionFactory().openSession(); try { JobMapper

ibatis 3 basis

I'm evaluating the technology and have a tricky startup problem I'm not able to see the solution for. I get the: Exception in thread main org.apache.ibatis.exceptions.IbatisException: ### Error building SqlSession. ### The error may exist in test/ibatis/Account.xml ### Cause:

Re: ibatis 3 basis

Jon, Verify if Account.xml is in correct format. It should contain !DOCTYPE mapper PUBLIC -//ibatis.apache.org//DTD Mapper 3.0//EN http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd; instead of !DOCTYPE sqlMap PUBLIC -//ibatis.apache.org//DTD SQL Map 2.0//EN

Migrations: GMT question

Hi! I have default configuration time_zone=GMT+0:00 and I'm now in the EET time zone (GMT+2:00) I executed migrate new blah and got a script called 20100317163912_blah.sql and my clock shows 2010-03-17 16:39 I expected to got script called 20100317143912_blah.sql Could you please help me

RE: ibatis 3 basis

Thanks, Hmm...missing some letters there I see... Got a step furtherthe 3 version differs a bit from the 2 version I realize. Since the version 3 lacks some documentation i learn quite a bit from the error messages :-) -Jon -Original Message- From: Eduardo M. Cavalcanti

SV: setNull and default jdbcType

Looks good. Thanks orb Fra: Clinton Begin [clinton.be...@gmail.com] Sendt: 17. mars 2010 05:28 Til: user-java@ibatis.apache.org Emne: Re: setNull and default jdbcType Fixed. Give it a try. Clinton On Tue, Mar 16, 2010 at 12:28 PM, Bekkum Odd-Rune

Re: ibatis 3 basis

If there's documentation lacking, please contribute it as per the note within the first couple of pages of the user guide. On 2010-03-17, Jon Finanger j...@finanger.no wrote: Thanks, Hmm...missing some letters there I see... Got a step furtherthe 3 version differs a bit from the 2

Re: ibatis 3 basis

Actually, I just checked, the XML Headers appear on pages 5 and 7 of the user guide, for the config and mapper DTDs respectively. If you have a recommendation to make it clearer, add it to the documentation contribution site.

Re: integrating lucene with ibatis - advice wanted

Andrius Like Simo I like option 1, it is probably the simplest option. 3 could really ugly and pushes functionality down into the RBDMS which is not great for scaling, also adds overhead to any insert/update/delete operations. One think you might consider (which I do for a project I am working

[IB3] method overloading in a mapper

I think I just ran into a small issue. I have the follow in my mapper interface. The second method has the sql defined in a XML file. @Select(select Clients.* from Clients, Accounts where Accounts.id = Clients.accountId and Accounts.id = #{accountId} order by name) public ListClient

Re: ibatis 3 basis

Hi, If I end up using iBaits i'll definitely try to contribute. I like the concept -Jon Actually, I just checked, the XML Headers appear on pages 5 and 7 of the user guide, for the config and mapper DTDs respectively. If you have a recommendation to make it clearer, add it to the

Using iBatis to create a Postgres function - fails because of semi-colon

Hi all, I am trying to accomplish an obscure use-case. I am trying to implement the generation of a Postgres function (aka stored procedure) via iBatis. I am using an insert tag and simply have the standard PostgreSQL syntax for creating the funciton within it. I created all this functionality

Re: Using iBatis to create a Postgres function - fails because of semi-colon

Oh - I forgot to mention a few other details. * I am using the iBatis spring integration (ibatis-sqlmap-2.3.0.jar, spring-ibatis-2.0.8.jar) * The weirdest part here is that the code fully works when I run it through a unit test, but when I run it as a deployed webapp, it fails. On Wed, Mar 17,

Re: Using iBatis to create a Postgres function - fails because of semi-colon

I'm not following your situation. You say it works fine through a unit test but fails in Tomcat. By fine, do you mean that you can create your stored proc via iBATIS in your unit test? If so and it fails on your webapp, then I'm guessing your webapp is using $ signs for other purposes. You

Re: iBatis 2.x vs. iBatis 3.x performance

I'm not sure what to say... this is not really an iBATIS issue. * First, you're purposefully going directly against a key part of the SqlSession contract. There's an entire section in the user guide about SqlSession lifecycle (Page 9) and you're completely ignoring it. This makes it very