Re: iBATIS 3 for Java Released (BETA 1)

2009-08-10 Thread Ian Zabel
Congrats, everyone! This is great to see! Cheers, Ian. On Sat, Aug 8, 2009 at 3:36 PM, Nathan Maves wrote: > A month ago iBATIS turned 7 years old, and while we're celebrating a > little late, today we're happy to announce iBATIS 3 for Java. iBATIS 3 > is a complete rewrite from the ground up an

Re: Using iBatis outside servlet container

2009-01-30 Thread Ian Zabel
, Jan 30, 2009 at 12:19 PM, Larry Meadors wrote: > Wouldn't that require including tomcat (or part of it) with your > application? > > Larry > > On Fri, Jan 30, 2009 at 10:10 AM, Ian Zabel wrote: > > System.setProperty( Context.INITIAL_CONTEXT_FACTORY, > "org.apache.naming.java.javaURLContextFactory" ); >

Re: Using iBatis outside servlet container

2009-01-30 Thread Ian Zabel
This is how I create a mock JNDI datasource for our unit tests to match the one we normally get from Tomcat: // Create initial context System.setProperty( Context.INITIAL_CONTEXT_FACTORY, "org.apache.naming.java.javaURLContextFactory" ); System.setProperty( Context.URL_PKG_P

Re: [VOTE] Should iBATIS support SQLJ?

2009-01-23 Thread Ian Zabel
0

Re: Hooking into cache flushes?

2008-10-16 Thread Ian Zabel
Kai, You can implement a CacheEntryEventListener (from com.opensymphony.oscache.base.events in OSCache), and register it as a listener in your oscache.properties. Here's the javadoc: http://www.opensymphony.com/oscache/api/com/opensymphony/oscache/base/events/CacheEntryEventListener.html Ian. O

Re: Shutting down Connection Pool at runtime (for maintenance)

2008-09-27 Thread Ian Zabel
We're looking into the suggestions offered, however. Thanks for the thoughts! Ian. On Wed, Sep 24, 2008 at 11:58 AM, Ian Zabel <[EMAIL PROTECTED]> wrote: > Very soon we're releasing our first build of our legacy app using > iBATIS! We've converted about 10% of our lega

Re: AW: Shutting down Connection Pool at runtime (for maintenance)

2008-09-25 Thread Ian Zabel
Thanks, Axel. I'll do some research into this. We don't have a DBA on staff, and this is how we've been doing it for years. Hopefully Oracle 8i supports this! (soo old!) Thanks, Ian. On Sep 25, 2008, at 1:38 AM, Leucht, Axel wrote: I have to admit that I know Oracle only very basically, tho

Shutting down Connection Pool at runtime (for maintenance)

2008-09-24 Thread Ian Zabel
Very soon we're releasing our first build of our legacy app using iBATIS! We've converted about 10% of our legacy SQL to iBATIS so far, and it's really working great. Things are 15-30% faster compared to our old framework (homegrown SOAP server for all data access). We're using iBATIS with Tomcat

Re: Ibatis : multiple insert

2008-08-24 Thread Ian Zabel
I think you need to iterate over the bookList in your Java code and call your insert multiple times. Take the out of the insert. Maybe this will help you: http://www.mail-archive.com/user-java@ibatis.apache.org/msg04760.html Also, what's with the WHERE clause in your INSERT statement? I'm n

Re: Really Weird Oracle REF Cursor Behavior

2008-08-22 Thread Ian Zabel
: Always make sure you're defining the correct types for your parameters. I feel better now! Thanks, Ian. On Tue, Aug 12, 2008 at 5:41 PM, Ian Zabel <[EMAIL PROTECTED]> wrote: > Hello, > > Using the latest build of iBATIS and Oracle REF Cursors, we're running > into

Re: Really Weird Oracle REF Cursor Behavior

2008-08-12 Thread Ian Zabel
t in house here we've found that stored functions (where the Cursor is returned from the function and not fetched into an out parameter) works best. Hope This Helps, Jeff Stahl Ian Zabel wrote: Hello, Using the latest build of iBATIS and Oracle REF Cursors, we're running

Really Weird Oracle REF Cursor Behavior

2008-08-12 Thread Ian Zabel
Hello, Using the latest build of iBATIS and Oracle REF Cursors, we're running into a problem with certain rows not coming back in the ResultSet. It seems to be certain data in the rows that makes them not return. For example, we have a column called INTERNAL_INVOICE_NBR. With the following values

Re: sealectKey database abstraction

2008-08-12 Thread Ian Zabel
I'd suggest that you do your development against an Oracle 10g database. This really is the best solution. But, if that's not really an option, I guess you could maintain a separate set of sql maps for each DB. Or, maybe use Ant replacement variables for your build to swap out the correct s

Re: inline map format: empty String in nullValue

2008-08-09 Thread Ian Zabel
Clinton, Good to read your point of view here. It's very much appreciated. I wasn't aware of the compatibility kit for iBATIS 3. Also wasn't aware that the only incompatible changes are the nullValue mapping and XML. This is good to know. I honestly can't say I really understand the reason

Re: inline map format: empty String in nullValue

2008-08-09 Thread Ian Zabel
Ondra, I agree. We are making use of this feature quite a bit in our legacy system (old objects, old DB) in which we are currently switching to use iBATIS. We are striving to maintain high compatibility by making few changes to the code, sql, and schema. nullValue comes in handy a LOT.

Re: Logging Query Execution Time

2008-08-08 Thread Ian Zabel
wrote: > Hey, I wrote that... > > It should be easy to use Spring AOP to do the same thing. > > If you don't want to, I may do it this weekend - I have a pet project > I'm doing iB2+Spring on. > > If I do, I'll put up a new lesson on it. > > Larry > &

Logging Query Execution Time

2008-08-08 Thread Ian Zabel
Afternoon, all. I'd like to easily enable logging of the time it takes to run iBATIS queries. I found this article which is the basic idea http://www.learntechnology.net/content/misc/aop_oldskool.jsp But, it's written to use the deprecated iBATIS DAO. Is there any built-in way to enable this now

2.3.3 and Spring? Good to go?

2008-08-08 Thread Ian Zabel
I've seen some recent traffic on this list saying that Spring is incompatible with iBatis 2.3.x. Is this still the case, or have these issues been resolved? Thanks! Ian.

Re: Thread starvation - pool / Throttle issue?

2008-08-06 Thread Ian Zabel
Clinton, A bit confused here (new to ibatis)... The docs state: "By default, calling any execute method on SqlMapClient instance (e.g. queryForObject() or insert()) will auto- commit or auto-rollback. This means that each call to any execution method will be a single unit of work. " Also

Re: iBatis Tomcat log4j IntelliJ IDEA

2008-07-18 Thread Ian Zabel
I see that in my logs. I have log4j.jar in my classpath, and in my WEB-INF/classes/log4j.properties, I have the following (copied from the iBatis manual): # SqlMap logging configuration... log4j.logger.com.ibatis=DEBUG log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG log4j.logger.com.iba

Re: [ANNOUNCE] iBATIS 2.3.3 ... Beta is the new Production

2008-07-17 Thread Ian Zabel
As a new user to iBatis (we just began using it two weeks ago at my company!), I just want to give you guys a big thanks for your work on the framework. It's made it a lot more comfortable to know that iBatis is under active development, and has a lively community around it. Keep up the good work!

Re: Leave complex properties null when columns are null?

2008-07-11 Thread Ian Zabel
tter way of handling this? Thanks, Ian. On Jul 9, 2008, at 11:29 PM, Ian Zabel wrote: Hello all, I have a class with a complex property (another class). For example: class Person { Address address; String name; } class Address { String city; String state; } The DB table `PERSON` has t

Leave complex properties null when columns are null?

2008-07-09 Thread Ian Zabel
Hello all, I have a class with a complex property (another class). For example: class Person { Address address; String name; } class Address { String city; String state; } The DB table `PERSON` has the following columns: `NAME`, `CITY`, and `STATE`. If the `CITY` and `STATE` column