Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: <48AD776B.9090802@mtl.mit.edu>
Date: Thu, 21 Aug 2008 10:10:51 -0400
From: Jonathan Slate <jslate@mtl.mit.edu>
User-Agent: Thunderbird 2.0.0.16 (X11/20080724)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: passing in java date
References: <48AD664E.6090507@mtl.mit.edu>
 <a10a823c0808210602v7d9db9e3o2e61e61a569f0e44@mail.gmail.com>
In-Reply-To: <a10a823c0808210602v7d9db9e3o2e61e61a569f0e44@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Okay, so you mean and AOP proxy, right? Thanks for the suggestion. It 
doesn't seem like that's documented much, looking at the mailing list 
archives I'm guessing my best bet would be to download the iBATIS source 
and see how you guys are doing the logging stuff, right?

I don't know, I'm guessing this is going to be more work than it is 
worth for me in the long run. But if there are some decent examples 
maybe I'll give it a try, or would it be helpful if I did it and wrote 
it up for others? Not sure if this is something other people would need.

If I *did* do this, would it make more sense to pass in the date as part 
of the parameterObject or as a property? It looks like the properties 
(java.util.Properties) get passed to the SqlMapClientBuilder which 
builds the SqlMapClient, so I'm thinking that once the SqlMapClient is 
built, those properties are essentially unmodifiable.

Or I could do before advice for all the methods that take a 
parameterObject to create a map, setting a "currentTime" value and... 
hm... "parameterObject" value? ...well, I think I'd have some things to 
work out there.

Maybe I'm missing something obvious here. :)

Thanks again,
Jonathan


Larry Meadors wrote:
> Put a proxy on the sql map client interface.
>
> Larry
>
>
> On Thu, Aug 21, 2008 at 6:57 AM, Jonathan Slate <jslate@mtl.mit.edu> wrote:
>   
>> Hi:
>>
>> We were having some problems where the time on the Web server and the DB
>> server are off by a few milliseconds and it was causing some issues, so
>> rather than rely on getting the times synched perfectly, I thought we could
>> just always use the time on the Web server by passing in the current time
>> when querying.
>>
>> I could change all of our "getSqlMapClientTemplate()..." calls to pass in a
>> map that includes the current java date/time, but that would be a lot of
>> work (and I'm lazy). So I was trying to find a way to always make "now"
>> available  to my SQL maps.
>>
>> For example:
>> SELECT * FROM foo WHERE start_time <= ${now}
>>
>> I know I can use static properties from a properties file like this. Is
>> there a way to do this for something more dynamic like "current time?"
>>
>> Thanks,
>> Jonathan
>>
>>