Re: JDBC 3 Support

[Clinton Begin]

Only 13% of our users are still dependent upon JDBC 2.0.  I wonder
if there is an option whereby we simply increment our supported JDKs?

Originally the iBATIS commitment was to support the current JDK version
N, and version N-1.  But my question would bewhat is the
current Java version?  Sun says it's 1.5/5.0, but the majority of
users use 1.4.  An ibatis usage breakdown by JDK version:

1.3 = 13%
1.4 = 72%
1.5 = 15%

and by iBATIS version:

1.x =  5%
2.x = 95%
So we can probably conclude that less than 10% of iBATIS 2.0 users are
dependent upon iBATIS 2.0.  If they aren't updating their JDK, I
wonder what the chances are that they'll need to upgrade iBATIS?  

Is it possible that iBATIS 2.1.x could be the last version to support JDK 1.3?

If you're dependent upon JDK 1.3 and you're reading thistell us!

Cheers,
Clinton
On 6/11/05, Brandon Goodin <[EMAIL PROTECTED]> wrote:
okay... sounds good.So, we can still have the  attribute that states compatibilitwith using 2 or 3 as values (eventually 4 as well). But, if you arenot explicit we will set it by using class.forName
 and finding outwhether a jdbc 3 specific class exists and setting the compliance onour own. Does that sound good?BrandonOn 6/11/05, Larry Meadors <[EMAIL PROTECTED]
> wrote:> I agree with Sven, we can check for the existence of> classes/interfaces/methods that are new in each release to auto-detect> the JDBC version if the settings did not provide a value.
>> Larry>> On 6/11/05, Sven Boden <[EMAIL PROTECTED]> wrote:> >> > Very personal preference auto-detection, but tag can override if
> > required.> >> > Regards,> > Sven> >> >> > On Sat, 11 Jun 2005 00:05:41 -0600, you wrote:> >> > >Hey guys,> > >
> > >I'm reposting this because i'm not sure it got out with all the email> > >hiccups over the last day. I'd really like to get some feedback on> > >this. It will help us to move forward with adding jdbc 3 support...
> > >> > >We need to start supporting some jdbc 3 functionality. I was thinking> > >we can use the  tag and add a compatibility attribute to it.> > >The default would be 2 but could be configured to support 3. Then when
> > >we add support for savepoints, generated keys, etc... we can throw a> > >sensible exception when someone tries to use jdbc 3 functionality in a> > >jdbc 2 compatibility mode.
> > >> > >My question is, do we want the support to be explicit with the setting> > >tag? or do we want to use an autodetection means?> > >> > >
> > >> > >thoughts?> > >> > >Brandon> >> >>

Re: JDBC 3 Support

[Clinton Begin]

Whoops...this didn't make much sense:

>> less than 10% of iBATIS 2.0 users are
dependent upon iBATIS 2.0
I meant to say:  less than 10% of iBATIS 2.0 users are
dependent upon JDBC 2.0

Cheers,
Clinton
On 6/11/05, Clinton Begin <[EMAIL PROTECTED]> wrote:

Only 13% of our users are still dependent upon JDBC 2.0.  I wonder
if there is an option whereby we simply increment our supported JDKs?

Originally the iBATIS commitment was to support the current JDK version
N, and version N-1.  But my question would bewhat is the
current Java version?  Sun says it's 1.5/5.0, but the majority of
users use 1.4.  An ibatis usage breakdown by JDK version:

1.3 = 13%
1.4 = 72%
1.5 = 15%

and by iBATIS version:

1.x =  5%
2.x = 95%
So we can probably conclude that less than 10% of iBATIS 2.0 users are
dependent upon iBATIS 2.0.  If they aren't updating their JDK, I
wonder what the chances are that they'll need to upgrade iBATIS?  

Is it possible that iBATIS 2.1.x could be the last version to support JDK 1.3?

If you're dependent upon JDK 1.3 and you're reading thistell us!

Cheers,
Clinton
On 6/11/05, Brandon Goodin <[EMAIL PROTECTED]
> wrote:
okay... sounds good.So, we can still have the  attribute that states compatibilitwith using 2 or 3 as values (eventually 4 as well). But, if you arenot explicit we will set it by using class.forName

 and finding outwhether a jdbc 3 specific class exists and setting the compliance onour own. Does that sound good?BrandonOn 6/11/05, Larry Meadors <
[EMAIL PROTECTED]
> wrote:> I agree with Sven, we can check for the existence of> classes/interfaces/methods that are new in each release to auto-detect> the JDBC version if the settings did not provide a value.
>> Larry>> On 6/11/05, Sven Boden <[EMAIL PROTECTED]> wrote:> >
> > Very personal preference auto-detection, but tag can override if
> > required.> >> > Regards,> > Sven> >> >> > On Sat, 11 Jun 2005 00:05:41 -0600, you wrote:> >> > >Hey guys,> > >

> > >I'm reposting this because i'm not sure it got out with all the email> > >hiccups over the last day. I'd really like to get some feedback on> > >this. It will help us to move forward with adding jdbc 3 support...
> > >> > >We need to start supporting some jdbc 3 functionality. I was thinking> > >we can use the  tag and add a compatibility attribute to it.> > >The default would be 2 but could be configured to support 3. Then when
> > >we add support for savepoints, generated keys, etc... we can throw a> > >sensible exception when someone tries to use jdbc 3 functionality in a> > >jdbc 2 compatibility mode.

> > >> > >My question is, do we want the support to be explicit with the setting> > >tag? or do we want to use an autodetection means?> > >> > >
> > >> > >thoughts?> > >> > >Brandon> >> >>

Oracle REF CURSOR Wiki Whiteboard

[Clinton Begin]

Hi all,

There's lots of discussion around the various approaches to dealing with Oracle REF CURSORs.

I've set up a wiki whiteboard to aggregate all of the existing solutions, extensions and new ideas.  

If you have a solution, an improvement or a completely new idea, feel free to add to the wiki here:

http://opensource.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions

After we've collected a number of contributions, we can discuss best
practices and any necessary changes to iBATIS to support those
practices.

Cheers,
Clinton

Re: Serialization issue due to lazy-loading

[Clinton Begin]

Yes, finer grained control would be a great thing.   I don't believe there's a JIRA request for it yet.

Could you please create one Stephane?

ClintonOn 6/21/05, Stephane Bailliez <[EMAIL PROTECTED]> wrote:
I came across a slightly annoying issue a couple of minutes ago withiBatis/cglib.For instance I'm serializing data over the network that have cglibinstrumented classes (relations)When lazyloading is enabled (default), it could seem obvious that it
does not make sense to serialize your data. You could well havebazillions of objects, yet this is what lazy loading is all aboutpreventing.Yet it is not always true.You may know, that your relationships are not in the form 1:bazillion
but more like 1:4 (replace 4 by your favorite 'less than 10' number)with very lightweights objects .To workaround this, you can AFAIK:1) disable applicationw-wide lazy loading via  (big side-effect)
2) implements your own serialization mechanism (annoying)At the moment I did (2), where I'm basically doing:class Parent {transient ArrayList children = new ArrayList();... serializable fields...
 ... private void writeObject(ObjectOutputStream out) throws IOException { out.defaultWriteObject(); ArrayList list = new ArrayList(children); out.writeObject(list);
 } private void readObject(ObjectInputStream in) throwsClassNotFoundException, IOException { in.defaultReadObject(); children = (ArrayList)in.readObject(); }}
Yet, I was wondering if it would make sense to fine-grained control overthe lazy-loading. For instance, having a per-statement lazy-loading flagwhere dependent requests (like in the case of n+1 selects) would inherit
this flag.Just some thoughts straight without thinking too much.Any comments ?Stéphane

Re: testcase for logging switched on and off

[Clinton Begin]

You'd probably be better off just writing better unit tests (or any) for the connection log proxy stuff.  

Thanks for the contribution by the way.  If you want to make it
part of the official release, we'll need you to submit a CLA with
Apache.

Cheers,
ClintonOn 6/22/05, Sven Boden <[EMAIL PROTECTED]> wrote:
Is there a preferred way of making testcases for iBatis for thingsthat go wrong between using iBatis with and without logging. Or is theprocedure to just run iBatis unit testcases with and without logging?
I'm giving it a try to make a unit test case for jira IBATIS-152/149.Regards,Sven Boden

Re: [jira] Commented: (IBATIS-153) NullPointer exception during call of oracle stored procedure with REF CURSOR as output parameter

[Clinton Begin]

You currently can't map ref cursors with result maps.  You have to
use a custom type handler.  So queryForList won't work.

Sorry for the trouble, but Oracle ref cursors are somewhat of a backward paradigm, and are therefore hard to map.

Cheers,
Clinton
On 6/28/05, ppz4j (JIRA) <ibatis-dev@incubator.apache.org> wrote:
[ http://issues.apache.org/jira/browse/IBATIS-153?page=comments#action_12314604 ]ppz4j commented on IBATIS-153:--
I'm
using executeQueryForList because i want ibatis to get the resultset
and convert each row in a java bean as defined in the follow xml file :

   { call OPT_USER.TEST.TEST_CURSOR(?,?,?) }With
update, as you suggest, i can get only the returned resultset from the
input parameter map and after i have to convert it on my ownand this is not the behaviour i expectRegards,> NullPointer exception during call of  oracle stored procedure with REF CURSOR as output parameter
> ->>  Key: IBATIS-153>  URL: 
http://issues.apache.org/jira/browse/IBATIS-153>  Project: iBatis for Java> Type: Bug>   Components: SQL Maps> Versions: 2.1.0>  Environment: Oracle 9.> Reporter: ppz4j
> Assignee: Clinton Begin> Priority: Minor>> the invocation of an oracle stored procedura with REF CURSOR as output parameter raises a NullPointerException.> The procedure's signature is :
>   PROCEDURE test (>  
out_cur  OUT  my_cur,>   out_err_code OUT  NUMBER,>   out_err_text OUT  VARCHAR2>)> where  TYPE my_cur IS REF CURSOR;> and ibatis configuration is :
>> >>>> > > > > 
> > >{ call OPT_USER.TEST.TEST_CURSOR(?,?,?) }> 
> the exception stack trace is:> Caused by:> java.lang.NullPointerException>   at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:352)>   at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure
(SqlExecutor.java:291)>   at com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:34)>   at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
(GeneralStatement.java:173)>   at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)>   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList
(SqlMapExecutorDelegate.java:610)>   at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)>   at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList
(SqlMapSessionImpl.java:105)>   at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:78)>   at it.imiweb.app.data.DataModelTest.testOptions(DataModelTest.java:295)
>   at it.imiweb.app.data.DataModelTest.main(DataModelTest.java:445)> Looking  inside the code it seems that the problem is due to the invocation of the follow instruction:> rs = cs.getResultSet()
>
in method executeQueryProcedure of SQLExcecutor class that returns a
null value instead of the resultset as the stored procedure output. To
successfully invoke the procedure i have modified the code as follow:>   public void executeQueryProcedure(RequestScope request, Connection conn, String sql, Object[] parameters,>
int skipResults, int maxResults, RowHandlerCallback callback)>   ...>   ...>   cs.execute();>>   //this method returns always null>   //rs = cs.getResultSet();
>>  
//with this code is possible to get the resultset even if the procedure
returns more than one output parameter>   retrieveOutputParameters(cs, mappings, parameters);>   for ( int ii = 0;  ii < parameters.length; ii++ ) {>if ( parameters[ii] instanceof ResultSet ) {
>   rs = ( ResultSet ) parameters[ii];>
break;>}>   }>   //end added code>>   errorContext.setMoreInfo("Check the results (failed to retrieve results).");>   handleResults(request, rs, skipResults, maxResults, callback);
>  
errorContext.setMoreInfo("Check the output parameters (retrieval of
output parameters failed).");>  //commented because it's already invoked and another call will throw an exception>  //retrieveOutputParameters(cs, mappings, parameters);>  ...>  ...
> }> The driver jdbc is :> Manifest-Version: 1.0> Specification-Title: "Oracle JDBC driver classes for use with JDK1.4"> Specif

Re: ibatis 2.1.5 release plan

[Clinton Begin]

As soon as brandon gives the go-ahead on IBATIS-148, then we'll be good to go!

Cheers,
clintonOn 7/5/05, Guido García Bernardo <[EMAIL PROTECTED]> wrote:
Hi,I am facing with this bug:http://issues.apache.org/jira/browse/IBATIS-152, solved in 2.1.5Is there any release plan for 2.1.5 so that I can decide whether or not
I'll need to use 2.0.9b or compile the source?Thank you very much.--Guido García Bernardo - [EMAIL PROTECTED]Tfn. +34 983 54 89 08ITDEUSTO - Valladolid

Re: R: [HELP] Whether or not iBatis support SQL Injection?

[Clinton Begin]

Hi Nathan,

Given:

SELECT * FROM ACCOUNT WHERE USERNAME = ? and PASSWORD = ?

Consider that without prepared statements it would likely be implemented like this:

String username = "cbegin";
String password = "barnacle"
String sql = "SELECT * FROM ACCOUNT WHERE USERNAME = '" + username + "' AND PASSWORD = '" + password + "'";

Now consider what would happen if the password was this:

String password = "x' OR USERNAME = 'cbegin";

You'd end up with the SQL statement:

SELECT * FROM ACCOUNT WHERE USERNAME = 'cbegin' AND PASSWORD = 'x' OR USERNAME = 'cbegin'

In Microsoft SQL Server, this would load the ACCOUNT record without the password.

iBATIS protects against this by always using PreparedStatement, but if
you use $substitutions$ in you statements, be very careful! 

Cheers,
Clinton
On 7/9/05, Nathan Maves <[EMAIL PROTECTED]> wrote:
I was asked the question "What is SQL injection and how can I avoid it?"I understand it to a point but an example would be great.NathanOn Jul 5, 2005, at 7:01 AM, Larry Meadors wrote:
> Yes, it does pass the SQL directly to the driver, but unless you use> the $$ syntax for parameters, you should be safe with iBATIS.>> The $$ syntax is the only part of iBATIS that allows string
> concatenation, which is the biggest source of SQL injection attacks.>> If you are using a really crappy jdbc driver, you could have issues> with it somehow botching things in it's implementation of prepared
> statements, but I have not heard of a single case of that happening.>> Larry>>> On 7/5/05, Fabrizio Gianneschi> <
[EMAIL PROTECTED]> wrote:> Since iBatis uses PreparedStatements a lot, it's safer than old>> school JDBC>> code, even if it's still vulnerable because it passes the SQL
>> directly to>> the driver without checking, afaik. You can always use some good>> tricks to>> increase the robustness of your SQL, but... ...this type of checking is not responsibility of a SQL mapper
>> layer like>> iBATIS.>> I think you should check your user input in higher server side>> layers, such>> as the presentation one; Struts Actions and/or ActionForms, for
>> example. Fab  >>  Da: Pham Anh Tuan [mailto:[EMAIL PROTECTED]]>> Inviato: martedì 5 luglio 2005 
12.16>> A: iBatis>> Oggetto: [HELP] Whether or not iBatis support SQL Injection? Hi all, I don't know whether or not iBatis support checking SQL Injection
>> or not ? plz help me :) Pham>

iBATIS for Java 2.1.5 Intent to Release (in 3 days)

[Clinton Begin]

Send any concerns, wishes or corrections to the following as response to this email.

The current change log is:

--
 2.1.5 - July ?, 2005
--

 o Fixed IBATIS-136 groupBy not carried forward to extended result maps
 o Fixed IBATIS-139 discriminator being applied to too many result maps (thanks Sven)
 o Fixed IBATIS-152, 149, 116 null result sets now handled properly by JDBC logging classes (thanks Sven)
 o Fixed IBATIS-146 consumes additional result sets before retrieving output params (JTDS fix)
 o Fixed IBATIS-130 parameter maps don't allow for complete TypeHandler implementations
 o Fixed IBATIS-148 parameter maps don't allow for complete TypeHandler implementations
 o Removed dependency on Commons Logging, will autodetect and use Commons Logging, Log4J, JDK 1.4 or no logging
 o Improved entity resolvers to be smarter, checks both system and public IDs, and both ibatis.com and apache.org  

Cheers,
Clinton

iBATIS Java - Sorry for the silence

[Clinton Begin]

Hi all,

Summer has become a very busy time for the iBATIS team.  We're
spending more time on iBATIS than ever, and yet, it probably appears
from the outside that we're on pause.  As you can imagine, there's
more to software than the software.  So, I just wanted to send a
note to say: "Yes, we're alive!"

First I want to apologize for not releasing 2.1.5 yet.  This is 100% my fault (no excuse).  

Second I want to lay out some exciting plans for the near future.

  * iBATIS will be at 2 upcoming conferences:
    - No Fluff Just Stuff - Calgary - Sept
    - Java in Action - Orlando - Oct

  * We're also considering ApacheCon US 2005, in San Diego in December.

  * We're increasing the size of the Java Team.  We have a
number of people in mind, and will be contacting them shortly, but if
you're interested in joining the iBATIS committers, then drop me a
line.  We need more hands on deck to support the increasing demand.

  * iBATIS 3.0 roundtable discussions will start by September at
the latest.  There's a lot of exciting directions the project can
take.  We want you to be there.

And yes....I will release 2.1.5 this week.

Best regards,

Clinton Begin

Anonymous comments now disallowed on Wiki

[Clinton Begin]

Hi all,

Due to some "wiki spamming" of the questionable kind, we've disallowed anonymous comments on confluence.  

Such targeting of our resources only goes to show how popular we're getting!  Whoohoo!  ;-)

Cheers,
Clinton

iBATIS 2.1.5 is out (despite the website)

[Clinton Begin]

Hi all,

The Apache infrastructure team is working to resolve an issue around
website refreshing, so you can't see the new content I posted yesterday.

...which includes the release of iBATIS for Java 2.1.5

So until then, you can go straight to the download page on good ol' sourceforge...

http://prdownloads.sourceforge.net/ibatisdb/iBATIS_DBL-2.1.5.582.zip?download

Cheers,
Clinton

Re: ApacheCon 2005 San Diego

[Clinton Begin]

I've already submitted one:   "Dealing with Enterprise Database Challenges in an Object Oriented Application".

Or, a shorter title:  "Introducing iBATIS"  ;-)

Cheers,
ClintonOn 7/21/05, Ted Husted <[EMAIL PROTECTED]> wrote:
On 7/19/05, Ron Grabowski <[EMAIL PROTECTED]> wrote:> Is that the kind of stuff you're looking for?This is all good stuff, but I was wondering whether anyone is planning
to submit an iBATIS presentation proposal to the ApacheCon committee,and, if so, what they had in mind in terms of an abstract.Most of the presentations at ApacheCon are given by Apache committers.
-Ted.

Re: Multiple connections in multiple threads doesn't seem to work.

[Clinton Begin]

If you haven't done so already, you should probably post this to the
.NET list.  You'll likely get a response there.  The Dev list
is mostly for design and feature discussion.

Cheers,
ClintonOn 8/9/05, Louis Letourneau <[EMAIL PROTECTED]> wrote:
Hello,I hope I'm not reposting, my original message doesn't seem to have gotten through...In
Ibatis.NET with dataAccess 1.6.1, I'm trying to open many
(different)connections each in a seperate thread (as would occur in a
web application). I get connection already closed or connection already
opened exceptions when running the application. It's as if a new
session doesn't get created individually for each thread...I
took the liberty of checking the source code of the datamapper, and
shouldn't the variable _localSqlMapSession in WindowSessionContainer.cs
be static. If it's not the ThreadStatic attirbute will have no effect
and every thread will have the same session (as in my case).I tested this theory in the attached code and, indeed the variable needs to be static for the attribute to have effect.I checked in jira and couldn't find a similar bug. If there is one already opened...sorry :-)
I have the code to reproduce both problems if you want it. (the ThreadStatic, and the openconnection)Exception:Got: IBatisNet.DataAccess.Exceptions.DataAccessException: DaoManager could not invoke OpenConnection(). A connection is already started. Call CloseConnection fi
rst.I've been using the java dao for awhile now...great product! Very good job guys.ThanksLouis

New iBATIS Contributors voted in.

[Clinton Begin]

Hi everyone,

Congratulations to the following new iBATIS committers, who have been successfully voted in by the iBATIS PMC

Sven Boden
Jeff Butler
Nathan Maves
Brice Ruth

We're working to get them Apache accounts and access to all iBATIS resources.

They've already been doing a great job with the lists, bugs and general
suggestions for improvements to the framework.  We're excited to
have them on board.

Congratulations guys!


Best regards,

Clinton Begin

Re: Proxy target type for Lazy loading

[Clinton Begin]

Technically it seems sound.  It's certainly not as pure as a real
proxy based on the interface, as there's no way we can assert that the
resultmap matches the interface.  So you'd have to be sure that
you unit test appropriately.

The only technical caveat is that you would be REQUIRED to use
CGLIB.  There would be no option, becasue you'd always be creating
dynamic proxies for concrete classes.

The other thing is a question of simple design practices.  If an
interface contract only guarantees a return value of type A, then
you're really making an assumption when you cast it to A1.  A
better design would really be to either change the interface to include
all functionality that you need, or change the return type. That's
being more honest with yourself.  Ask:  "what is this
interface really hiding if I'm just going to cast out of it anyway?"

IMHO using the result map is less "honest", because you're really "guessing" at types by casting them.  

Cheers,
ClintonOn 8/11/05, Oleg Shpak <[EMAIL PROTECTED]> wrote:
Hello,I'm having a problem with iBatis which I'm keen to solve by patchingiBatis (other solutions exist, but they are a bit cumbersome).In short, I propose to modify loadResult() method incom.ibatis.sqlmap.engine.mapping.result.loader.EnhancedLazyResultLoader
,so that is creates more "honest" proxies, proxies which base on lazyloading statement's resultMap result class, rather than just on methodreturn type.-
public Object loadResult() throws SQLException {  if (DomTypeMarker.class.isAssignableFrom(targetType)) {return ResultLoader.getResult(client, statementName,parameterObject, targetType);
  } else if (Collection.class.isAssignableFrom(targetType)) {return Enhancer.create(Object.class, INTERFACES, this);  } else if (targetType.isArray() ||ClassInfo.isKnownType(targetType)) {return 
ResultLoader.getResult(client, statementName,parameterObject, targetType);  } else {// NEW CODE STARTSClass type;try {ResultMap resultMap =
client.getDelegate()  .getMappedStatement(statementName).getResultMap();type = resultMap.getResultClass();} catch (SqlMapException e) {type = targetType;
}return Enhancer.create(type, this);// NEW CODE ENDS// old code was   //   return Enhancer.create(targetType, this);  }}-
The problemWhen a proxy is created for an object, target type is determined usingthe property method return type. It is possible that the actual returnvalue of a method is a subclass of the return type (especially if the
return type is an interface).// public interfacesinterface A {...}interface B {A getA();...}// implementation classesclass A1 implements A { ...}class B1 implements B {
private A1 a;public A getA(){   return a; //an instance of A1}   ...}// result maps...
   ...
...Here I configured lazy loading for B1.getA. The proxy which is beinggenerated is based on type A, not on type A1. My DAO class for type Aactually returns instances of type A1. Generally it is OK for it (DAO
class) to consume objects of type A, but in some cases, when it needs tomodify some implementation details it has to cast them down to A1. Thisis where proxies cause a ClassCastException. "Honest" proxies don't.
What do you think?Probably I put my code not into the right place, or it, probably, shouldbe optionally turned on/off.Regards,Oleg

Re: update listener

[Clinton Begin]

Yep. 

If you want to do it at the DAO layer, you could write a dynamic proxy
the intercepts all of your DAO method calls to perform the check. 
You could use naming conventions to determine whether the check is
needed (i.e. all updateXxx() methods).

If you want to do it at the SQL Map layer, you can proxy SqlMapClient
(which is an interface).  You only need to trap the update()
method to do the check.

Hope that helps.

Cheers,
Clinton
On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]
> wrote:
As part of requirements in our project, we need to verify data before update using timestamp algorithm
by comparing retrieved timestamp value and current value in timestamp column.

This has to be done before every update statement.

At this point, I'm using a generic DAO which will be extended by all DAOs and it has got method to do that.

But for every update statement it needs to be called explicitely. And it will be DAO developers responsibility.

Is it possible to add listener with update statement or any other generic approach ??
Alliance Bernstein: Winner of Money Management "FUND MANAGER OF THE YEAR 2005" 
Member of the Global AXA Group

*
Important Note
This email (including any attachments) contains information which is 
confidential and may be subject to legal privilege.  If you are not 
the intended recipient you must not use, distribute or copy this 
email.  If you have received this email in error please notify the 
sender immediately and delete this email. Any views expressed in this 
email are not necessarily the views of AXA.   Thank you.
**

Mailing list test - PMC Members please read

[Clinton Begin]

Hi all, 

This is a test of the mailing lists.

Will one PMC member please respond from each list?

Thanks,
Clinton

Re: ApacheCon 2005 San Diego

[Clinton Begin]

Yep.  I was accepted.  See you there!

I'm also doing Java In Action in Orlando (October) and I'm considering doing No Fluff Just Stuff in Denver (November).

Cheers,
Clinton
On 8/24/05, Ted Husted <[EMAIL PROTECTED]> wrote:
On 7/21/05, Clinton Begin <[EMAIL PROTECTED]> wrote:>>  I've already submitted one:   "Dealing with Enterprise Database Challenges> in an Object Oriented Application".
>>  Or, a shorter title:  "Introducing iBATIS"  ;-)Did you hear back from the planners yet, Clinton?They accepted one of my Struts presentations, but passed on my .NETtalks. Though, I might try to get a .NET BOF together.
-Ted.

Re: ann: mail list mirror

[Clinton Begin]

I have no issue putting up a link.  I checked out Roomity, and it is indeed very cool.

If there are no objections within 72 hours, I'll add the link.

ClintonOn 8/24/05, netsql <[EMAIL PROTECTED]> wrote:
http://ibatis.roomity.com now mirrors this mail list.

and it uses ibatis. I would not be upset if
http://ibatis.apache.org/mailinglists.html 
had a link to it.

.V

--Broadband interface (RIA) + mail box saftey = 
Roomity.com*Your* clubs, no sign up to read, ad supported; try broadband internet. ~~1124920352589~~--

Supported JDK Version

[Clinton Begin]

Hi everyone,

It's always been the iBATIS policy to support the current JDK version,
and one previous version.  However, we've been supporting JDK 1.3
and JDBC 2.0 for some time simply because it wasn't a problem.  

We're now at a point whereby there is enough legacy JDK 1.3 and JDBC
2.0 code that we can consider it a problem.  More importantly
though, we haven't been able to fully realize the benefits of JDBC 3.0
as much as we'd like to.  

Furthermore, the breakdown of iBATIS users using the various JDK versions is as follows:

1.4  -  69.93%
1.5  -  18.66%
1.3  -  11.40%

So there is nearly 90% of the user population that could be taking
greater advantage of JDBC 3.0 features, while also eliminating
"overhead" code that's there to deal with JDBC 2.0.  

So, in a way this email is an advanced warning that JDK 1.3 and JDBC
2.0 will no longer be supported (we'll announce the version that will
mark the end of such support).

On the other hand, this email is a call out to anyone who has a major
problem with this.if you have a reason why we shouldn't ditch JDK
1.3 and/or JDBC 2.0, then please speak up.  Although, reasons like
"IBM hasn't updated their driver since JDK 1.0.1" likely won't help
your cause much.  ;-)

Cheers,
Clinton

Broken Wiki FAQ Links Update

[Clinton Begin]

Hi everyone,

Most of the links on our FAQ are currently broken due to a
configuration issue with the server currently hosting Confluence. 
It's likely a security policy causing issues related to our use of the
"?" symbol in the FAQ wiki titles (which are then used directly in the
URL).

Atlassian is aware of the issue and has very graciously agreed to fix it for us.  

So thanks to Atlassian for that, and thank you all for your patience while we get this issue resolved.

Clinton Begin

ibatis.com and DTD hosting

[Clinton Begin]

Hi everyone.

The following mostly affects users of the Java version of iBATIS, but it's always nice to keep our C# friends in the loop.

I have good news and bad news.  The good news is that iBATIS is
very popular and in August we served up over 1,000,000 of the
sql-map-2.dtd.  Most versions of iBATIS actually resolve the DTD
from the JAR file, so
most of these hits are likely from IDEs and other tools/parsers that
are making use of the DTD.  

The bad news is that this is unfortunately starting to cost me money in bandwith overcharges.  :-)

Therefore this is a perfect opportunity to change.  This will be a three step process:

1) If you haven't done so already, you should switch to use the DTD
URLs found here http://ibatis.apache.org/dtd/  (i.e. NOT the ones
at ibatis.com).

2) If you haven't done so already, you should upgrade your iBATIS
version to the latest, to ensure that your DTDs resolve from the JAR
files.

3) The by November 30, 2005, the DTDs will cease to be available at ibatis.com, and will only be available from 
http://ibatis.apache.org/dtd/

So let's celebrate our success by making the switch to using the DTDs hosted by Apache.

Of course if you see serious issue with this, please let me know.

Best regards,

Clinton Begin

Re: What package is the "groupBy" code in?

[Clinton Begin]

Groupby code is found in BasicResultMap.  If you pay attention to
the groupByProps and nestedResultMaps fields, you'll get the hang of
what it's doing.

The code isn't modularized very wellbut it's very fast. it only
iterates over the result set once (no matter how deep or wide the
mappings are), which I believe is key to N+1 solution performance.

ClintonOn 9/12/05, Ron Grabowski <[EMAIL PROTECTED]> wrote:
I'm not very familiar with the Java codebase. What package / class isthe code for the "groupBy" attribute in?Thanks,Ron

Re: Security Extension?

[Clinton Begin]

I'm kind of behind Brandon with regard to building something specific
either for security or validation.  iBATIS is not a security
framework, nor a validation framework.  However

I would be fully behind features that would make such things easier for
developers to implement.  For example, providing a standard
approach to decorating DAOs or even the SQL Map Client would be a cool
feature.  AOP at some level.  You can already do this with
iBATIS with a relatively small amount of code (think dynamic proxy, and
the fact that DAOs and the SqlMapClient are interfaces).

For iBATIS 3.0 I'm imagining more simplicity, maintaining our zero
dependencies and eliminating XML as a requirement (i.e. a better Java
API).

Simplicity and focus have kept iBATIS on top (or near the top) for a
long time. I'm all for making it do what it does better, not
necessarily doing something else entirely.

That said, I've been convinced beforeif security/validation can be
done in a way that is very simple, powerful, unassuming and
optional...then I wouldn't see any major issues.

Cheers,
Clinton On 9/20/05, Brice Ruth <[EMAIL PROTECTED]> wrote:
A plug-in would certainly be my preferred implementation. I agree that
validation can take place in the service layer, but this suggestion
came up in a discussion of "security in depth", i.e. the more checks
that are being done, the less likely a vulnerability will compromise
much of the system.

The discussions have revolved largely around various regulations that
are being imposed and what can  be done at all layers, and at all
stages of development, to secure applications, or isolate
vulnerabilities. Of particular interest are the types of things that
don't touch existing code (like a front-end filter, or something that
sits between the application and the database, like an iBATIS plugin).
AOP is an option in this realm, too, of course.

I'll keep this in mind as the 3.x development proceeds!

Thanks for the feedback, Brandon.

BriceOn 9/20/05, Brandon Goodin <

[EMAIL PROTECTED]> wrote:
I am not a fan of Validator whatsoever. But, apart from that and Ithink a rules engine would already fit that bill. A rules engine wouldrest in your service layer. By the time your objects reach your DAOlayer the assumption should be made that they are valid. If your
validation issues can't be handled in your service layer then youshould think about taking up stored procedures. Personally, I wouldnot be on board with this kind of functionality in iBatis.But, we have tossed around the idea of making iBatis 
3.x configs morepluggable. Maybe you can take up the initiative then as a plugin.BrandonOn 9/20/05, Brice Ruth <

[EMAIL PROTECTED]> wrote:> Hi guys,
>>  I've been involved in various "secure application" efforts in the past> couple months and one idea that surfaced is securing database interaction> from the application that's accessing the database. So, basically preventing
> parameters from being passed into the database that are invalid or crafted> in such a way as to expose vulnerabilities in the underlying database.>>  Obviously SQL-injection is one such vulnerability, but this is easily
> managed by using parameters. What I'm proposing is a validation framework> for iBATIS that works similarly to Struts Validator (and uses> Commons-Validator, as Struts does). So, in addition to having a SqlMap file,
> you might have a validation file that could be configured by id or class> name (much like Struts allows an action path or an ActionForm to be> specified) - and the iBATIS infrastructure would run the incoming data
> through the necessary validations, via commons-validator, before attempting> any database access.>>  Obviously this is still a pretty rough idea, but it seemed like it had some> potential. What say ye?
>> --> Brice Ruth> Software Engineer, Madison WI

Re: JIRA 172

[Clinton Begin]

I'll be working on the bug list this weekend.  So I should have a chance to implement this fix.

ClintonOn 9/26/05, Tom B. <[EMAIL PROTECTED]> wrote:
Has anyone had a chance to look/comment on this?  I have time tocontinue this, if needed.http://issues.apache.org/jira/browse/IBATIS-172Thx.
-Tom

Re: iBATIS Junit tests setup

[Clinton Begin]

Wow...  What JVM/SDK are you using?On 10/1/05, Sven Boden <[EMAIL PROTECTED]> wrote:
Been playing with the following for an hour but can't seem to get itsolved. When I extract iBATIS from SVN and run the build script allJUnit tests fail in the following way:java.lang.ClassNotFoundException
:com.ibatis.common.resources.ResourcesTest atjava.net.URLClassLoader$1.run(URLClassLoader.java:199) atjava.security.AccessController.doPrivileged(Native Method) atjava.net.URLClassLoader.findClass(URLClassLoader.java
:187) atjava.lang.ClassLoader.loadClass(ClassLoader.java:289) atjava.lang.ClassLoader.loadClass(ClassLoader.java:235) atjava.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) atjava.lang.Class.forName0
(Native Method) atjava.lang.Class.forName(Class.java:141)I guess this has something to do with the java.policy file, but Ican't seem to figure out which entries to add. Can someone give me apointer?
Regards,Sven

Re: iBATIS Junit tests setup

[Clinton Begin]

It won't build under JDK 1.5, due to some issues with Ant and some of
the Tasks we're using.   It should build fine with 1.4.x

ClintonOn 10/3/05, Sven.Boden <[EMAIL PROTECTED]> wrote:
I'm
currently using JDK 1.4.2_06 on windows. I found some results on
internet suggesting to upgrade to JDK 1.5. To me for the moment it
looks like somehow the testcases are just not in the classpath when
executing the build script (I did an extract of SVN, and didn't change
any file afterwards).I will try some more (and possibly upgrade
or downgrade the JDK) ;-)... I thought someone else might already have
had the problem.Regards,Sven>>Wow... What JVM/SDK are you using?>>On 10/1/05, Sven Boden <[EMAIL PROTECTED]> wrote:>>
 Been playing with the following for an hour but can't seem to get it>> solved. When I extract iBATIS from SVN and run the build script all>> JUnit tests fail in the following way:
 java.lang.ClassNotFoundException:>> com.ibatis.common.resources.ResourcesTest at>> java.net.URLClassLoader$1.run(URLClassLoader.java:199) at>> java.security.AccessController.doPrivileged
(Native Method) at>> java.net.URLClassLoader.findClass(URLClassLoader.java:187) at>> java.lang.ClassLoader.loadClass(ClassLoader.java:289) at>> java.lang.ClassLoader.loadClass(ClassLoader.java
:235) at>> java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at>> java.lang.Class.forName0(Native Method) at>> java.lang.Class.forName(Class.java:141) I guess this has something to do with the 
java.policy file, but I>> can't seem to figure out which entries to add. Can someone give me a>> pointer? Regards,>> Sven>>>

Re: JIRA way slow

[Clinton Begin]

What do you expect from an app built with Hibernate?   

j/k  ;-)On 10/3/05, Nathan Maves <[EMAIL PROTECTED]> wrote:
Same here... I thought it might be the proxies here at Sun, but I getthe same slowness from Comcast at home.This is not just a problem today but all days!NathanOn Oct 3, 2005, at 12:37 PM, Tom B. wrote:
> +1... from two separate locations.  :(>> On 10/3/05, Nathan Maves <[EMAIL PROTECTED]> wrote:>>> Every time I use this site it boggles my mind how slow it is?
 Does anyone else experience it? Nathan>>>

Re: iBATIS Junit tests setup

[Clinton Begin]

Certainly it should build under 1.5so yes, I'd hope so.  

But I don't think that will be our official build platform.  We'll still target 1.4.x.  

(I want to make sure to build under 1.4 to ensure that we're not using 1.5 features until ... well, 1.6 is out. ;-)

Cheers,
ClintonOn 10/3/05, Nathan Maves <[EMAIL PROTECTED]> wrote:
Are we planing on upgrading these and tasks to 1.5 anytime soon?By that I mean is anyone working on it yet?Nathan
On Oct 3, 2005, at 11:28 AM, Clinton Begin wrote:It
won't build under JDK 1.5, due to some issues with Ant and some of the
Tasks we're using.   It should build fine with 1.4.x  ClintonOn 10/3/05, Sven.Boden <
[EMAIL PROTECTED]> wrote: I'm
currently using JDK 1.4.2_06 on windows. I found some results on
internet suggesting to upgrade to JDK 1.5. To me for the moment it
looks like somehow the testcases are just not in the classpath when
executing the build script (I did an extract of SVN, and didn't change
any file afterwards).I will try some more (and possibly upgrade
or downgrade the JDK) ;-)... I thought someone else might already have
had the problem.Regards,Sven>>Wow... What JVM/SDK are you using?>>On 10/1/05, Sven Boden <
[EMAIL PROTECTED]> wrote:>> >>>> Been playing with the following for an hour but can't seem to get it>> solved. When I extract iBATIS from SVN and run the build script all
>> JUnit tests fail in the following way: >>>> java.lang.ClassNotFoundException:>> com.ibatis.common.resources.ResourcesTest at>> java.net.URLClassLoader$1.run(URLClassLoader.java
:199) at>> java.security.AccessController.doPrivileged (Native Method) at>> java.net.URLClassLoader.findClass(URLClassLoader.java:187) at>> java.lang.ClassLoader.loadClass(ClassLoader.java:289) at
>> java.lang.ClassLoader.loadClass(ClassLoader.java :235) at>> java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at>> java.lang.Class.forName0(Native Method) at>> java.lang.Class.forName
(Class.java:141)>>>> I guess this has something to do with the java.policy file, but I>> can't seem to figure out which entries to add. Can someone give me a>> pointer?>>
>> Regards,>> Sven>>> 

Re: iBATIS Junit tests setup

[Clinton Begin]

We could write external tools or extensions for JDK 1.5, but we can't
depend on any features of 1.5.nor would I support forking the
codebase for 1.5 support.  

Cheers,
ClintonOn 10/3/05, Nathan Maves <[EMAIL PROTECTED]> wrote:
On that point is there any plan to take advantage of any of the 1.5
features?  Mean would we rewrite any old code or just move forward
with the ability to use 1.5 features.NathanOn Oct 3, 2005, at 2:07 PM, Clinton Begin wrote:
 Certainly it should build under 1.5so yes, I'd hope so.    But I don't think that will be our official build platform.  We'll still target 1.4.x.    (I want to make sure to build under 
1.4 to ensure that we're not using 1.5 features until ... well, 1.6 is out. ;-)  Cheers, ClintonOn 10/3/05, Nathan Maves <
[EMAIL PROTECTED]> wrote: Are we planing on upgrading these and tasks to 1.5
 anytime soon?By that I mean is anyone working on it yet?Nathan On Oct 3, 2005, at 11:28 AM, Clinton Begin wrote:
It
won't build under JDK 1.5, due to some issues with Ant and some of the
Tasks we're using.   It should build fine with 1.4.x  ClintonOn 10/3/05, Sven.Boden <
 [EMAIL PROTECTED]> wrote: I'm
currently using JDK 1.4.2_06 on windows. I found some results on
internet suggesting to upgrade to JDK 1.5. To me for the moment it
looks like somehow the testcases are just not in the classpath when
executing the build script (I did an extract of SVN, and didn't change
any file afterwards).I will try some more (and possibly upgrade
or downgrade the JDK) ;-)... I thought someone else might already have
had the problem.Regards,Sven>>Wow... What JVM/SDK are you using?>>On 10/1/05, Sven Boden <
 [EMAIL PROTECTED]> wrote:>> >>>> Been playing with the following for an hour but can't seem to get it>> solved. When I extract iBATIS from SVN and run the build script all
 >> JUnit tests fail in the following way: >>>> java.lang.ClassNotFoundException:>> com.ibatis.common.resources.ResourcesTest at>> java.net.URLClassLoader$1.run(URLClassLoader.java
 :199) at>> java.security.AccessController.doPrivileged (Native Method) at>> java.net.URLClassLoader.findClass(URLClassLoader.java:187) at>> java.lang.ClassLoader.loadClass(ClassLoader.java:289) at 
>> java.lang.ClassLoader.loadClass(ClassLoader.java :235) at>> java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at>> java.lang.Class.forName0(Native Method) at>> java.lang.Class.forName
 (Class.java:141)>>>> I guess this has something to do with the java.policy file, but I>> can't seem to figure out which entries to add. Can someone give me a>> pointer?>>
 >> Regards,>> Sven>>>  

Re: Running the tests

[Clinton Begin]

I don't know, but I do know that we're using a very old Ant version, and probably old versions of all of our build tools.  

Anyone interested in upgrading them?

ClintonOn 10/20/05, Nathan Maves <[EMAIL PROTECTED]> wrote:
Anyone know why I might be having trouble running the build scriptson OS X?On Oct 18, 2005, at 3:09 PM, Nathan Maves wrote:> when I issue>> ant test.run>> I get
>> test.run:>> BUILD FAILED> /Users/nmaves/Development/iBatis/trunk/java/mapper/mapper2/build/> build.xml:181: Could not create task or type of type: junit.>> Ant could not find the task or a class this task relies upon.
>> Why would this happen?>> Nathan>

Re: [jira] Reopened: (IBATISNET-118) CacheKey.Equals(object) override can return true when the parameters have the same HashCode but are not equal.

[Clinton Begin]

You're point is correct, but the good news is it is also irrelevant.  :-)

iBATIS only supports the types supported by ADO.NET as
parameters.  Therefore, the only types ever being compared will be
strings, ints, etc

iBATIS doesn't compare the parmeter class using its equas method, it
compares each parameter of the statement as mapped from the class by
the parameter map.

Cheers,
ClintonOn 10/24/05, Jeremy Gray <[EMAIL PROTECTED]> wrote:
This is a dangerous, slippery slope.In .NET there are two and only two equality semantics: reference andvalue type.Assuming that ibatis is now also checking .Equals as opposed to itsprevious reliance on only GetHashcode, the responsibility falls on the
creator of the class being checked for equality, not on ibatis, toperform the appropriate comparison.Reference types that wish to use a value-type equality semantic mustimplement the appropriate method overrides themselves (as 
System.Stringdoes, for example).Ibatis must in turn use only .GetHashcode() and .Equals(...).Any other expected behaviour indicates that the class being compared hasimplemented the wrong equality semantic.
Jeremy Gray-Original Message-----From: Clinton Begin (JIRA) [mailto:ibatis-dev@incubator.apache.org]Sent: Monday, October 24, 2005 4:07 PM
To: ibatis-dev@incubator.apache.orgSubject: [jira] Reopened: (IBATISNET-118) CacheKey.Equals(object)override can return true when the parameters have the same HashCode but
are not equal. [ http://issues.apache.org/jira/browse/IBATISNET-118?page=all ]Clinton Begin reopened IBATISNET-118:-
This is still an issue.  The equals method is using hashcode exclusivelyto compare the values.  It cannot, no matter what the hashcode algorithmis, 32 bits will never be enough to compare uniqueness.
SoThe Equals method of the cachekey object should1) use hashcode for each parameter to determine initial match (forperformance)2) double-check the using a true equals method that directly compares
each parameter for exact equality.There is NO other way to do this.We had the same problem in Java, and it's a pretty seriousbug...anything that ends up returning incorrect results from the DB is
our highest priority.Let me know if you'd like an explanation of the sequence of events,problem and solution from the Java version.Cheers,Clinton> CacheKey.Equals(object) override can return true when the parameters
have the same HashCode but are not equal.>-->>  Key: IBATISNET-118>  URL: 
http://issues.apache.org/jira/browse/IBATISNET-118>  Project: iBatis for .NET> Type: Bug>   Components: DataMapper> Versions: DataMapper 
1.2.1>  Environment: Windows> Reporter: Thomas Tannahill> Assignee: Gilles Bayon>  Fix For: DataMapper 1.3>> CacheKey.Equals(object) override can return true when the parameters
have the same HashCode but are not equal.  This can cause false cachehits.> Only an issue for complex parameters.> Failing NUnit test:>  UNIT TEST BEGIN > using IBatisNet.DataMapper
;> using IBatisNet.DataMapper.TypeHandlers;> using NUnit.Framework;> namespace IBatisNet.DataAccess> {>   [TestFixture]>   public class CacheKeyTests>   {>   private const long A_LONG = 1L;
>  
private const long ANOTHER_LONG_WITH_SAME_HASHCODE =-9223372034707292159;>>   public CacheKeyTests()>   {>   }>   [Test]>   public void
ShouldNotBeConsideredEqualWhenParametersHaveTheSameHashCodeButAreNotEqual()>   {>  
TypeHandlerFactory factory = newTypeHandlerFactory();>  
// Two cache keys are equal except for theparameter.>  
CacheKey key = new CacheKey(factory,"STATEMENT", "SQL", new TestClass(A_LONG), new string[] {"AProperty"},0, 0, CacheKeyType.Object);>  
CacheKey aDifferentKey = new CacheKey(factory,"STATEMENT", "SQL", new TestClass(ANOTHER_LONG_WITH_SAME_HASHCODE), newstring[] {"AProperty"}, 0, 0, CacheKeyType.Object);>  
Assert.IsFalse(aDifferentKey.Equals(key)); //should not be equal.>   }>   }>   public class TestClass>   {>   private long aProperty;>   public TestClass(long aProperty)
>   {>  
this.aProperty = aProperty;>   }>   public long AProperty>   {>  
get { return aProperty; }>  
set { aProperty = value; }>   }>   }> }>  UNIT TEST END > The test passes if yo

[VOTE] Discontinue Support for: iBATIS Java 1.x, JDK 1.3 and DTDs at ibatis.com

[Clinton Begin]

Hi everyone:

== What? ==

I'm going to raise a vote and recommend to discontinue support for:

  * iBATIS 1.x (including 2.0 compat package)
  * All JDKs 1.3 and earlier (and therefore old JDBC versions)
  * DTDs hosted by iBATIS.com

== Why? ==

I'm basing my recommendations on the following facts:

Only 3% of iBATIS users use iBATIS 1.x.
Only 13% of iBATIS users use JDK 1.3.1 or earlier 
We serve up 1.4 million copies of our DTD every month from ibatis.comwhich is costing me money. :-)

Discontinuing support for these will allow us to move forward with more new features and lighten the code up a bit.

== When? ==

iBATIS 1.x support ends as of version 2.2.0 (next feature release)
JDK 1.3 and earlier versions support ends as of version 2.2.0 (next feature release)
DTDs hosted at iBATIS.com removed by November 30th 2005 as per the warning[1] that went out in September (90 days notice).

To be proactive, pragmatic and practical, we will tag the SVN
repository at version 2.1.6 (next bug fix release).  This version
can then be branched if necessary to fix any critical issues for those
living in Bedrock.  

== Who? ==

Would all PMC members please vote on the three items individually

(  )  iBATIS 1.x is unsupported as of version 2.2.0
(  )   JDK 1.3 and earlier are unsupported as of version 2.2.0
(  )  DTDs hosted at iBATIS.com are removed as of November 30th, 2005.

Everyone else is free to comment.  If you think your business will be significantly impacted by this, please let us know.

Cheers, 

Clinton 


[1] http://www.mail-archive.com/user-java@ibatis.apache.org/msg01333.html

[VOTE] Promote iBATIS 2.1.6 to General Availability

[Clinton Begin]

Hi all,

I've released iBATIS 2.1.6 as an Apache Alpha level distribution. 

Here's the change log.

--
 2.1.6 - Nov 5, 2005
--

 o Fixed IBATIS-198 Call "getDataSource()" of SqlMapClientImpl will cause application to hang
 o Fixed IBATIS-179 Binaries on webpage use old Hibernate
 o Fixed IBATIS-174 CacheModel does not support caching null results
 o Fixed IBATIS-197 Call "getDataSource()" of SqlMapClientImpl will cause application to hang
 o Fixed IBATIS-131 Fix use of list[]-notation in propertyattributes of dynamic tags
 o Fixed IBATIS-173 Incorrect resultset retrieve when calling stored procedure
 o Fixed IBATIS-194 No resultSet found when executing SQL Server stored procedure.
 o Fixed IBATIS-196 can't use dynamic replace data-source-type over IBATIS ver 2.0.9 library
 o Fixed IBATIS-191 operation(insert and update) Oracle's(OCI)
CLOB and BLOB fail, CLOB will close tomcat, BLOB will miss any DATA
 o Fixed IBATIS-193 Hidden jar dependicity for iBatis DBL 2.1.5
 o Fixed IBATIS-175 ResultSetLogProxy doesn't log the result properly
 o Fixed IBATIS-195 Sqlmap DTD: include tag not permitted in selectKey element
 o Fixed IBATIS-172 implicit mapping fails on nested column aliases
 o Fixed IBATIS-185 SqlMapClasspathEntityResolver - Offline public ID resolution value ignored 

Everyone: Check it out.  
PMC members: please vote for GA.

Cheers,
Clinton

Re: [VOTE] Discontinue Support for: iBATIS Java 1.x, JDK 1.3 and DTDs at ibatis.com

[Clinton Begin]

They're already on apache.org!

http://ibatis.apache.org/dtd/

Cheers,
ClintonOn 11/6/05, Larry Meadors <[EMAIL PROTECTED]> wrote:
I am not sure i understand: Will the iBATIS 1.x DTDs remain where theyare, go away (potentially a very, very bad thing), or get moved toapache.org?LarryOn 11/5/05, Clinton Begin <
[EMAIL PROTECTED]> wrote:> Hi everyone:>>  == What? ==>>  I'm going to raise a vote and recommend to discontinue support for:>
>* iBATIS 1.x (including 2.0 compat package)>* All JDKs 1.3 and earlier (and therefore old JDBC versions)>* DTDs hosted by iBATIS.com>>  == Why? ==>>  I'm basing my recommendations on the following facts:
>>  Only 3% of iBATIS users use iBATIS 1.x.>  Only 13% of iBATIS users use JDK 1.3.1 or earlier>  We serve up 1.4 million copies of our DTD every month from> ibatis.comwhich is costing me money. :-)
>>  Discontinuing support for these will allow us to move forward with more new> features and lighten the code up a bit.>>  == When? ==>>  iBATIS 1.x support ends as of version 
2.2.0 (next feature release)>  JDK 1.3 and earlier versions support ends as of version 2.2.0 (next feature> release)>  DTDs hosted at iBATIS.com removed by November 30th 2005 as per the> warning[1] that went out in September (90 days notice).
>>  To be proactive, pragmatic and practical, we will tag the SVN repository at> version 2.1.6 (next bug fix release).  This version can then be branched if> necessary to fix any critical issues for those living in Bedrock.
>>  == Who? ==>>  Would all PMC members please vote on the three items individually>>  (  )  iBATIS 1.x is unsupported as of version 2.2.0>  (  )  JDK 1.3 and earlier are unsupported as of version 
2.2.0>  (  )  DTDs hosted at iBATIS.com are removed as of November 30th, 2005.>>  Everyone else is free to comment.  If you think your business will be> significantly impacted by this, please let us know.
>>  Cheers,>>  Clinton>>>  [1]> http://www.mail-archive.com/user-java@ibatis.apache.org/msg01333.html
>>

Re: [VOTE] Discontinue Support for: iBATIS Java 1.x, JDK 1.3 and DTDs at ibatis.com

[Clinton Begin]

Sorry, support in this regard is "technical dependency", not "we don't talk 'bout that no more".


Technically, it means removing the "compatibility" library from the 2.0 distribution. 

ClintonOn 11/6/05, Ted Husted <[EMAIL PROTECTED]> wrote:
>  iBATIS 1.x support ends as of version 2.2.0 (next feature release)What does "support ends" mean, exactly?>  JDK 1.3 and earlier versions support ends as of version 2.2.0 (next feature
> release)+0>  DTDs hosted at iBATIS.com removed by November 30th 2005 as per the> warning[1] that went out in September (90 days notice).+0-Ted.

Re: [VOTE] Discontinue Support for: iBATIS Java 1.x, JDK 1.3 and DTDs at ibatis.com

[Clinton Begin]

No.   But deprecation is a language feature that has become untrusted anyway.  I wouldn't let that stop me.

I figure we'll depend on good old fashioned human communication, rather than compiler warning messages.  ;-)

Cheers,
ClintonOn 11/6/05, Ted Husted <[EMAIL PROTECTED]> wrote:
On 11/6/05, Clinton Begin <[EMAIL PROTECTED]> wrote:>>  Sorry, support in this regard is "technical dependency", not "we don't talk
> 'bout that no more".>>  Technically, it means removing the "compatibility" library from the 2.0> distribution.Is the library deprecated as of the 2.1.5 release?-T.

Re: [jira] Commented: (IBATISNET-118) CacheKey.Equals(object) override can return true when the parameters have the same HashCode but are not equal.

[Clinton Begin]

The iBATIS for Java version compares the parameters using the same
values that are sent to the database, which means all values compared
are primitive (with equals and hashcode consistently implemented by the
core class library). 

Something similar could be done in the .NET version.  Like I said,
this is kind of a "been there, done that" for me, as we had the same
issue in the Java version.

Thomas Tannahill has already written a test that fails and an implementation that fixes it.  I'll ask him for it.

Cheers,
Clinton
 On 11/30/05, Jeremy Gray (JIRA)  wrote:
[ http://issues.apache.org/jira/browse/IBATISNET-118?page=comments#action_12358975 ]Jeremy Gray commented on IBATISNET-118:
---Gilles:
Having reviewed the CacheKey code _again_ this fall (after first
looking at it back in the spring) I can tell you that it does not do
what you describe. Types that need to be treated as special cases (e.g.
Hashtable) given the needs of the application are currently using only
hashcode and perhaps Equals comparisons. Other types are treated as a
special case (walking their properties) when the .NET equality
semantics demand that they strictly be compared based on GetHashCode
and Equals. Even given the current logic, GetHashCode and Equals are
not internally consistent - one of them applies different special cases
than the other.Clinton: Our company would love it to be fixed
for us :), but will be happy to implement the fix at the point in our
schedule where it becomes critical. That said, at the time we can
implement it I doubt we'll be able to verify against the full set of
ibatis.net test cases, so we might need a hand in verification from
someone who is already set up to do so.> CacheKey.Equals(object) override can return true when the parameters have the same HashCode but are not equal.> --
>>  Key: IBATISNET-118>  URL: http://issues.apache.org/jira/browse/IBATISNET-118>  Project: iBatis for .NET
> Type: Bug>   Components: DataMapper> Versions: DataMapper 1.2.1>  Environment: Windows> Reporter: Thomas Tannahill> Assignee: Gilles Bayon>  Fix For: DataMapper 
1.3>>
CacheKey.Equals(object) override can return true when the parameters
have the same HashCode but are not equal.  This can cause
false cache hits.> Only an issue for complex parameters.> Failing NUnit test:>  UNIT TEST BEGIN > using IBatisNet.DataMapper;> using IBatisNet.DataMapper.TypeHandlers;> using 
NUnit.Framework;> namespace IBatisNet.DataAccess> {>   [TestFixture]>   public class CacheKeyTests>   {>   private const long A_LONG = 1L;>  
private const long ANOTHER_LONG_WITH_SAME_HASHCODE = -9223372034707292159;>>   public CacheKeyTests()>   {>   }>   [Test]>  
public void ShouldNotBeConsideredEqualWhenParametersHaveTheSameHashCodeButAreNotEqual()>   {>  
TypeHandlerFactory factory = new TypeHandlerFactory();>  
// Two cache keys are equal except for the parameter.>  
CacheKey key = new CacheKey(factory, "STATEMENT", "SQL", new
TestClass(A_LONG), new string[] {"AProperty"}, 0, 0,
CacheKeyType.Object);>  
CacheKey aDifferentKey = new CacheKey(factory, "STATEMENT", "SQL", new
TestClass(ANOTHER_LONG_WITH_SAME_HASHCODE), new string[] {"AProperty"}, 0, 0, CacheKeyType.Object);>  
Assert.IsFalse(aDifferentKey.Equals(key)); // should not be equal.>   }>   }>   public class TestClass>   {>   private long aProperty;>   public TestClass(long aProperty)
>   {>  
this.aProperty = aProperty;>   }>   public long AProperty>   {>  
get { return aProperty; }>  
set { aProperty = value; }>   }>   }> }>  UNIT TEST END > The test passes if you replace this line in CacheKey.Equals():>if
(_hashCode != cacheKey._hashCode) return false;> with something like this:>if
(this._parameter == null && cacheKey._parameter != null) return
false;>if
(this._parameter != null && cacheKey._parameter == null) return
false;>if (!this._parameter.Equals(cacheKey._parameter)) return false;--This message is automatically generated by JIRA.-If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa-For more information on JIRA, see:   
http://www.atlassian.com/software/jira

Re: ApacheCon

[Clinton Begin]

I'm arriving Monday at 12pm, speaking Tuesday at 2pm and leaving Wednesday at 3:25pm.

Cheers,
ClintonOn 12/4/05, Ron Grabowski <[EMAIL PROTECTED]> wrote:
Who all is going to ApacheCon?I'll be arriving Saturday at 3pm and leaving Thursday at 3pm.- Ron

Re: About a generator for SqlMaps

[Clinton Begin]

Jeff,

LET X = "IntelliJ IDEA"

I there anyway to port this as a X plugin as well?  How tightly coupled is it to Eclipse?
Clinton  ;-)
On 12/11/05, Nathan Maves <[EMAIL PROTECTED]> wrote:
Jeff,I there anyway to port this as a Netbeans plugin as well?  How tightly coupled is it to Eclipse?Nathan
On Dec 7, 2005, at 4:16 PM, Jeff Butler wrote:It
uses database metadata - but many things can be overridden. 
There is an XML file that describes the configuration - but the
metadata is the primary source.  I've tested pretty extensively
with DB2 and MySql and have had no issues with the metadata
- YMMV.    I went ahead and finished the first round of documentation today, so it's ready to go.  I'll get it up on the 
ibatis.apache.org site in the next day or two.   Jeff Butler  On 12/7/05, Philippe Laflamme <
[EMAIL PROTECTED]> wrote: That's pretty interesting!Just curious: what's the reference for the code generation? Do you use
 the Database Metadata provided by JDBC? Custom flat files? Javareflection? Something else?Thanks,PhilJeff Butler wrote:> I've been working on a code generator for iBATIS for a few months now. 
> It's taken me quite a bit longer than I expected to add all the features> I wanted in the first release, but I'm happy with the feature set as it> now stands.>> I've been using it on a medium sized project I've been working on.  It 
> has been a tremendous time saver.  Using it everyday on a real life> project caused me to change some things about the function from my> original design - hence the delay in releasing it.  But I can now say 
> that it works very well, and is quite useful.>> I'm planning on releasing it pretty soon - I was hoping to have more> documentation ready for it, but I think I could write documentation for
 > the next two months and still not be fully satisfied.>> As a preview, here are some of its features:>> 1. Generates SqlMaps> 2. Generates corresponding Java objects> 3. Generates DAOs of different types (including Spring, iBATIS DAO, and 
> two generic types)> 4. VERY configurable> 5. Does not disturb hand-coded additions to the generated XML or Java> files - you can run it over and over again as the database design> evolves without fear of losing any custom changes you've made to SQL 
> maps or Java objects (this feature has taken most of my free time in the> past few weeks to get right)> 6. It can run standalone but it runs the best, and is most full> featured, as an Eclipse plugin.  The plugin provides a simple user 
> interface, and all the resultant files will be saved to Eclipse> projects.  The plugin is also where the function resides to merge old> and new versions of the generated objects (becasue I use the Eclipse AST 
> to do the heavy lifting).>> I hope that talking about it publically will give me enough pressure to> get the initial set of documentation finshed and get it out the door.> More soon... 
>> Jeff Butler>>> On 12/6/05, *Alexander Panzhin* <[EMAIL PROTECTED]
> [EMAIL PROTECTED] >> wrote:>> I noticed you do not have one.
>> I made a little something for myself, but I think that it would be a> nice util for SqlMaps.> Now how do I get to you? >> -->>With best regards,
>   Alexander Panzhin>   IT systems architect

Re: [jira] Commented: (IBATIS-203) Sql comments inside sqlMap's select tag, throws exception

[Clinton Begin]

Acutally it's not just for loggingcertain JDBC drivers complain about newline characters in the SQL stream.

Otherwise, I'd be all for leaving them in.

Cheers,
ClintonOn 12/20/05, Sven Boden (JIRA)  wrote:
[ http://issues.apache.org/jira/browse/IBATIS-203?page=comments#action_12360956 ]Sven Boden commented on IBATIS-203:
---The problem is in class com.ibatis.sqlmap.engine.mapping.sql.SQLText in the method:  public void setText(String text) {this.text = text.replace('\r', ' ').replace('\n', ' ');
this.isWhiteSpace = text.trim().length() == 0;  }Removing the first line of the method would solve the problem.However
this is the same old "problem" again of using the SQL query how it is
specified in the XML file or "pretty printing" it. Removing the first
line would make the logging output a little less nice.Another
solution would be to use the query as is (including newlines), and only
pretty printing the SQL statement when it's actually required for
logging purposes (this would also be a little faster without logging
on).Regards,Sven> Sql comments inside sqlMap's select tag, throws exception> ->>  Key: IBATIS-203>  URL: 
http://issues.apache.org/jira/browse/IBATIS-203>  Project: iBatis for Java> Type: Improvement>   Components: SQL Maps> Versions: 
2.1.5>  Environment: WinXP> Reporter: Henrik Westman>> Using sql comments i.e. lines prepended with "--", causes an exception.> Seems like ibatis, parses the CDATA content of the select tag,
> into one long line without any newlines.> ex.> >   > > gets parsed into>
select * from myTable -- here is my comment where myCol = 5> which is now invalid sql.> Not being able to comment is annoying> when you have very long SQL statements.--This message is automatically generated by JIRA.
-If you think it was sent incorrectly contact one of the administrators:   http://issues.apache.org/jira/secure/Administrators.jspa-
For more information on JIRA, see:   http://www.atlassian.com/software/jira

[VOTE] Promote iBATIS 2.1.7 to General Availability

[Clinton Begin]

Hi all,

I've released iBATIS 2.1.7 as an Apache Beta level distribution, and updated the release process on the wiki to reflect why I didn't release this as alpha.
Here's the front page announcement from the website:iBATIS Java 2.1.7 - Maintenance Release - Last 1.3 Compatible Release!(Jan 21, 2006) Well, as we said back in November, iBATIS will require JDK 
1.4 as of the 2.2.0 release. We expect that this 2.1.7 release will be the last JDK 1.3 compatible release that we make, unless a serious stability or security flaw is found, in which case we'll deploy a fix from a branch of the source. This release contains a number of minor bug fixes, an enhanced entity resolver. 
2.2.0 will be an interesting release with some new features that we've been looking forward to.
Here's the change log:
-- 2.1.7 - Jan 21, 2006-- o Fixed IBATIS-218 'i' character in property names, with Turkish locale o Fixed IBATIS-219 NoClassDefFoundError: oracle/toplink/sessions/UnitOfWork
 o Fixed IBATIS-228 Exception is thrown by TransactionManager when multiple commits are issued against a started transaction. o Fixed IBATIS-229 Method getWriteablePropertyNames in com.ibatis.common.beans.ComplexBeanProbe
 gets the readable property names o Fixed IBATIS-220 Null Pointer in SqlExecutor.handleResults where ResultSet is null. o Fixed IBATIS-213 SELECT statement returns unexpected result when 'groupBy' and 'nullValue' are specified in resultMaps.
 o Fixed IBATIS-221 Can't store a List in a Map  o Fixed IBATIS-223 Thread deadlock due to CacheModel.flush() 

Everyone: Check it out.  
PMC members: please vote for GA.

Cheers,
Clinton

Re: IBM's use of iBatis for Java

[Clinton Begin]

Hi Robert, 

Yes, every "Committer" on this list signed a CLA.

http://ibatis.apache.org/team.html

Cheers,
Clinton
On 2/7/06, rob yates <[EMAIL PROTECTED]> wrote:
All,so we at IBM and more specifically Lotus would like to use
iBatis for Java's data mapper capabilities in a future release of an
IBM / Lotus collaboration product.  We, the developers, are
excited about this and during our preliminary usage it has worked
extremely well for us.  However in order to do this our lawyers
need to be satisfied that iBatis follows the Apache contribution
procedures.  I can't currently figure this out from the
website.  The key question I need answered is whether each
contributor signs a Contributor License Agreement? Is there anywhere
that this is documented on the website or can anyone help me answer
this question.
Many many thanks,Robert Yates

Re: IBM's use of iBatis for Java

[Clinton Begin]

And to add further comfort, we are very careful when accepting code
contributions and patches from non-committers.  We either don't
use it, or the "contributor" must file a CLA.

Cheers,
Clinton
On 2/7/06, Ted Husted <[EMAIL PROTECTED]> wrote:
As Clinton says, all the committers have CLAs on file.Speaking as an ASF Member, I can assure you that following thecontributions procedures is *not* optional for an ASF project. If wedon't file a CLA, we don't get an account. Period. No exceptions.
-Ted.On 2/7/06, Clinton Begin <[EMAIL PROTECTED]> wrote:> Hi Robert,>>  Yes, every "Committer" on this list signed a CLA.
>>  http://ibatis.apache.org/team.html>>  Cheers,>  Clinton>>> On 2/7/06, rob yates <
[EMAIL PROTECTED]> wrote:> > All,> >> > so we at IBM and more specifically Lotus would like to use iBatis for> Java's data mapper capabilities in a future release of an IBM / Lotus
> collaboration product.  We, the developers, are excited about this and> during our preliminary usage it has worked extremely well for us.  However> in order to do this our lawyers need to be satisfied that iBatis follows the
> Apache contribution procedures.  I can't currently figure this out from the> website.  The key question I need answered is whether each contributor signs> a Contributor License Agreement? Is there anywhere that this is documented
> on the website or can anyone help me answer this question.> >> > Many many thanks,> >> > Robert Yates> >>>--HTH, Ted.** 
http://www.husted.com/ted/blog/

Re: Urgent and not so urgent info

[Clinton Begin]

1) Documentation:  Yes it's old.  I'm not sure if the OO doc
in SVN is any newer...I don't think I've updated it.  Maybe
Richard will update it for us.

2) Hosting:  Yes, we should move all of our downloadables to
Apache.  It's both easier to deploy, and easier to download.

3) JIRA:  I'll look into changing the address to use dev@ 

Cheers,
Clinton
On 2/7/06, Nathan Maves <[EMAIL PROTECTED]> wrote:
On this same note...When are we going to start hosting the binaries and documentation onapache and get off the dreadful SF site?NathanOn Feb 7, 2006, at 7:40 AM, Brandon Goodin wrote:> 2 points of observation below:
>> - The documentation that we link to on the ibatis.apache.org website> is not current. Actually, it is quite old. I would fix this myself,> but, I'm not aware of the process of getting it where it needs to be
> and whether we are still using sourceforge to distribute the> documentation.>> - Bugs are still using the ibatis-dev@incubator.apache.org. Shouldn't
> they be using the dev@ibatis.apache.org?>> L8r dudes...> Brandon

Re: Urgent and not so urgent info

[Clinton Begin]

Okay, 

3) I've updated the email address in JIRA.

2) I've moved all of the Java downloads to Apache.

1) No, I have not written any more docs.  ;-)

Cheers,
ClintonOn 2/7/06, Clinton Begin <[EMAIL PROTECTED]> wrote:


1) Documentation:  Yes it's old.  I'm not sure if the OO doc
in SVN is any newer...I don't think I've updated it.  Maybe
Richard will update it for us.

2) Hosting:  Yes, we should move all of our downloadables to
Apache.  It's both easier to deploy, and easier to download.

3) JIRA:  I'll look into changing the address to use dev@ 

Cheers,
Clinton
On 2/7/06, Nathan Maves <[EMAIL PROTECTED]
> wrote:
On this same note...When are we going to start hosting the binaries and documentation onapache and get off the dreadful SF site?NathanOn Feb 7, 2006, at 7:40 AM, Brandon Goodin wrote:> 2 points of observation below:
>> - The documentation that we link to on the ibatis.apache.org website> is not current. Actually, it is quite old. I would fix this myself,
> but, I'm not aware of the process of getting it where it needs to be
> and whether we are still using sourceforge to distribute the> documentation.>> - Bugs are still using the 
ibatis-dev@incubator.apache.org. Shouldn't
> they be using the dev@ibatis.apache.org?>> L8r dudes...> Brandon

Re: Urgent and not so urgent info

[Clinton Begin]

k, I've added a link directly to SVN.  So people have the option to download those.

Cheers,
ClintonOn 2/7/06, Brandon Goodin <[EMAIL PROTECTED]> wrote:
I made changes to the SVN documentation a while back. I added docs fornew features that have been added. I thought we released the docs witheach release of the API. Anyway, just so ya know that there have been
updates made to the SVN docs.BrandonOn 2/7/06, Clinton Begin <[EMAIL PROTECTED]> wrote:> Okay,>>  3) I've updated the email address in JIRA.
>>  2) I've moved all of the Java downloads to Apache.>>  1) No, I have not written any more docs.  ;-)>>  Cheers,>  Clinton>>> On 2/7/06, Clinton Begin <
[EMAIL PROTECTED]> wrote:> >> >> > 1) Documentation:  Yes it's old.  I'm not sure if the OO doc in SVN is any> newer...I don't think I've updated it.  Maybe Richard will update it for us.
> >> > 2) Hosting:  Yes, we should move all of our downloadables to Apache.  It's> both easier to deploy, and easier to download.> >> > 3) JIRA:  I'll look into changing the address to use dev@
> >> > Cheers,> > Clinton> >> >> >> >> > On 2/7/06, Nathan Maves <[EMAIL PROTECTED] > wrote:
> > > On this same note...> > >> > > When are we going to start hosting the binaries and documentation on> > > apache and get off the dreadful SF site?> > >
> > > Nathan> > >> > > On Feb 7, 2006, at 7:40 AM, Brandon Goodin wrote:> > >> > > > 2 points of observation below:> > > >> > > > - The documentation that we link to on the 
ibatis.apache.org website> > > > is not current. Actually, it is quite old. I would fix this myself,> > > > but, I'm not aware of the process of getting it where it needs to be
> > > > and whether we are still using sourceforge to distribute the> > > > documentation.> > > >> > > > - Bugs are still using the 
ibatis-dev@incubator.apache.org. Shouldn't> > > > they be using the dev@ibatis.apache.org?> > > >> > > > L8r dudes...> > > > Brandon
> > >> > >> >> >>>

Re: IBM's use of iBatis for Java

[Clinton Begin]

Hi Rob,That class wraps a Reader with an InputStream, and it's used in 3 places within iBATIS to deal with legacy Java APIs.  
The authors are not committers and therefore don't have CLAs filed.  They are the authors of an input stream API that uses the included Apache Compatible (1.x style) license.  As per their license agreement, we've left their copyright notice in, which is also distributed with every copy of iBATIS.  We are compliant with their license, and their license is compatible with Apache.

There's nothing wrong with an Apache project including code that uses a
compatible license.  Similarly, there's no problem with an Apache
project referencing or including a 3rd party framework or tool that
uses a compatible license.If it creates a problem for Lotus, I suggest they rewrite the class, file a CLA and then contribute it back to iBATIS.Cheers,Clinton
On 2/8/06, rob yates <[EMAIL PROTECTED]> wrote:
Thanks to all for your help with my previous questions.  I have lookedat the iBatis source code and have, hopefully, one final question.There is a reference to nitric.com and a copyright notice for Merlin
Hughes, Michael Shoffner and Derek Hammer.  I don't see those peoplelisted on the committer list.  Does anyone know who they are and howtheir code came to be in iBatis?Again Many Thanks,Rob

Re: Oracle ref cursors

[Clinton Begin]

So the assumptions made here are:  * There can be only one out parameter of type ResultSet  * The default result set (possibly returned from a SELECT) is lost, as it's overidden by the ResultSet parameter.
Seems a bit hackey, but I'm interested in everyone else's opinion.  ClintonOn 2/9/06, Sven Boden <[EMAIL PROTECTED]
> wrote:I've been playing a bit with Michael Fagan's patch for supporting
ResultMaps using Oracle ref cursors. Sometimes I'm also a bit fond ofpushing as much functionality as possible in Oracle procedures and onlyexposing a ref cursor to the (C) applications.The patch works but having ORACLECURSOR in the iBATIS code puts me a bit
off. So I made some small cosmetic changes... what about the following:- Michael Fagan's patch (now already to be redone because of otherchanges in 2.1.7)- With following changes:# Adding javaType="
java.sql.ResultSet" to the parameterMapjavaType="java.lang.Integer
" mode="IN"/>javaType="java.sql.ResultSet" mode="OUT"/>
# doing the ResultSet extraction as follows (hardcoding ResultSetinstead of ORACLECURSOR).if (mapping.isOutputAllowed()) {   if ("java.sql.ResultSet".equalsIgnoreCase(
mapping.getJavaTypeName()) )  {  ResultSet rs = (ResultSet) cs.getObject( i + 1 );# In the TypeHandlerFactory a shortcut "cursor" could be made forjava.sql.ResultSet
The above change would not put something "Oracle only" in iBATIS sourcecode, it would make the SQLMap still dependent on Oracle because ofORACLECURSOR but I don't see this as a big problem (as soon as you use
SQL dialect in the SqlMaps you're also dependent upon a database).As long as an other database supports a type for "cursor" it can use theimplementation above. Or is there something I'm missing, which could
come back to haunt us?People using the current patch should then only add"javaType="java.sql.ResultSet"" to their maps.Regards,Sven Boden

Re: Oracle ref cursors

[Clinton Begin]

Yep.  I agree on the need.  Just being cautious about the implementation.Cheers,ClintonOn 2/9/06, Sven Boden <
[EMAIL PROTECTED]> wrote:In case anyone is interested in having a look, I uploaded the "patch to
the patch" to the wiki,http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions
We may need to think some other things over, but a lot of people seem toneed/want something in iBATIS to convert ResultSets from storedprocedures to maps.Sven>> There can be more than 1 out result sets, Michael's testcases on the
> wiki show that.>> Will check the second bullet tomorrow, we can probably find a way> around it it should also be just a resultset (but I vaguely> remember some problems with it from past experiments).
>> Sven>> Clinton Begin wrote:>>> So the assumptions made here are:>>>>  * There can be only one out parameter of type ResultSet>>  * The default result set (possibly returned from a SELECT) is lost, as
>> it's overidden by the ResultSet parameter.>>>> Seems a bit hackey, but I'm interested in everyone else's opinion.>>>> Clinton>>>> On 2/9/06, Sven Boden <
[EMAIL PROTECTED]> wrote:>>>>>>> I've been playing a bit with Michael Fagan's patch for supporting>>> ResultMaps using Oracle ref cursors. Sometimes I'm also a bit fond of
>>> pushing as much functionality as possible in Oracle procedures and only>>> exposing a ref cursor to the (C) applications.>>>>>> The patch works but having ORACLECURSOR in the iBATIS code puts me a
>>> bit>>> off. So I made some small cosmetic changes... what about the following:>>>>>> - Michael Fagan's patch (now already to be redone because of other>>> changes in 
2.1.7)>>> - With following changes:>>># Adding javaType="java.sql.ResultSet" to the parameterMap>>>
>>>>>> javaType="java.lang.Integer" mode="IN"/>>>>>>> javaType="java.sql.ResultSet" mode="OUT"/>>>>>>>>>># doing the ResultSet extraction as follows (hardcoding ResultSet
>>> instead of ORACLECURSOR).>>>>>>if (mapping.isOutputAllowed()) {>>>   if (>>> "java.sql.ResultSet".equalsIgnoreCase(mapping.getJavaTypeName
()) )  {>>>  ResultSet rs = (ResultSet) cs.getObject( i + 1 );>>>>>>>>># In the TypeHandlerFactory a shortcut "cursor" could be made for
>>> java.sql.ResultSet>>>>>> The above change would not put something "Oracle only" in iBATIS source>>> code, it would make the SQLMap still dependent on Oracle because of
>>> ORACLECURSOR but I don't see this as a big problem (as soon as you use>>> SQL dialect in the SqlMaps you're also dependent upon a database).>>> As long as an other database supports a type for "cursor" it can use
>>> the>>> implementation above. Or is there something I'm missing, which could>>> come back to haunt us?>>>>>> People using the current patch should then only add
>>> "javaType="java.sql.ResultSet"" to their maps.>>>>>> Regards,>>> Sven Boden>>>>>>>>>>>>>
>>>>>>>

Re: Oracle ref cursors

[Clinton Begin]

Hmmm...ok.  Here's what I'd like to see in a solution:  * No dependency upon Oracle (like you've said).  * ResultSet types should be supported in both OUT parameters, as well as result set columns (ick).
  * The regular result set returned by a select statement or procedure should not be compromised.So conceivably I should be able to do something like this:---  
    ...
List list = sqlMap.queryForList("blah", myParam);---In this case, I may have dealt with 3 result maps.  One to deal with the OUT param, one to deal with result sets nested in columns, and of course the normal one returned from a call to .executeQuery().
Note that the XML attribute "resultMap" is already used for  tags, so I called the attribute  "useResultMap"but perhaps there's a better name that's not too long (e.g. cursorResultMap)?
Thoughts?ClintonOn 2/9/06, Clinton Begin <
[EMAIL PROTECTED]> wrote:
Yep.  I agree on the need.  Just being cautious about the implementation.Cheers,ClintonOn 2/9/06, 
Sven Boden <
[EMAIL PROTECTED]> wrote:In case anyone is interested in having a look, I uploaded the "patch to
the patch" to the wiki,http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Oracle+REF+CURSOR+Solutions
We may need to think some other things over, but a lot of people seem toneed/want something in iBATIS to convert ResultSets from storedprocedures to maps.Sven>> There can be more than 1 out result sets, Michael's testcases on the
> wiki show that.>> Will check the second bullet tomorrow, we can probably find a way> around it it should also be just a resultset (but I vaguely> remember some problems with it from past experiments).
>> Sven>> Clinton Begin wrote:>>> So the assumptions made here are:>>>>  * There can be only one out parameter of type ResultSet>>  * The default result set (possibly returned from a SELECT) is lost, as
>> it's overidden by the ResultSet parameter.>>>> Seems a bit hackey, but I'm interested in everyone else's opinion.>>>> Clinton>>>> On 2/9/06, Sven Boden <
[EMAIL PROTECTED]> wrote:>>>>>>> I've been playing a bit with Michael Fagan's patch for supporting
>>> ResultMaps using Oracle ref cursors. Sometimes I'm also a bit fond of
>>> pushing as much functionality as possible in Oracle procedures and only>>> exposing a ref cursor to the (C) applications.>>>>>> The patch works but having ORACLECURSOR in the iBATIS code puts me a
>>> bit>>> off. So I made some small cosmetic changes... what about the following:>>>>>> - Michael Fagan's patch (now already to be redone because of other>>> changes in 
2.1.7)>>> - With following changes:>>># Adding javaType="java.sql.ResultSet" to the parameterMap>>>
>>>>>> javaType="java.lang.Integer" mode="IN"/>>>>>>> javaType="java.sql.ResultSet" mode="OUT"/>>>>>>>>>># doing the ResultSet extraction as follows (hardcoding ResultSet
>>> instead of ORACLECURSOR).>>>>>>if (mapping.isOutputAllowed()) {>>>   if (>>> "java.sql.ResultSet".equalsIgnoreCase(mapping.getJavaTypeName


()) )  {>>>  ResultSet rs = (ResultSet) cs.getObject( i + 1 );>>>>>>>>># In the TypeHandlerFactory a shortcut "cursor" could be made for
>>> java.sql.ResultSet>>>>>> The above change would not put something "Oracle only" in iBATIS source>>> code, it would make the SQLMap still dependent on Oracle because of
>>> ORACLECURSOR but I don't see this as a big problem (as soon as you use>>> SQL dialect in the SqlMaps you're also dependent upon a database).>>> As long as an other database supports a type for "cursor" it can use
>>> the>>> implementation above. Or is there something I'm missing, which could>>> come back to haunt us?>>>>>> People using the current patch should then only add
>>> "javaType="java.sql.ResultSet"" to their maps.>>>>>> Regards,>>> Sven Boden>>>>>>>>>>>>>
>>>>>>>

Re: What about a LDAP dao engine ?

[Clinton Begin]

This has been done a couple of times.  It was discussed on this list a 
while back.


Cheers,
Clinton

Cimballi wrote:


Great ! It's more motivating to work when you know other people may
enjoy it ! ;-)

I hope language will not block me, my english is very poor ! Well, at
least I understand "computer" english, and I've got a big dictionnary
!

So Larry, like you said in LDAP each attribute can have multiple
values. This is one of the differences between LDAP and SQL. If I
understand you well, you also propose a kind of automatic mapping
between the object (JAVA) and the entry (LDAP) based on the
type-objectclass of that object-entry. I don't understand well your
reference to SQL injection, but maybe this is because I don't still
have a look inside the sqlmap architecture.

Now what I thought to do. The simplest way to start should to copy the
way sqlmap works and adapt it to LDAP. Of course there is some
difference but we will discuss them later, I don't think they should
need a new architecture.
About the about to use, I've mostly work with the ldapsdk from
netscape-sun-mozilla, but maybe it's should be better to use JNDI
here. About JNDI, do you think it should be interesting to have a
generic JNDI dao engine, or maybe we can start with JNDI-LDAP dao
engine, and look for more genericity later ?
About mapping between JAVA and LDAP : in LDAP most of the attributes
can be multi valued, but in real life, company's schemas usually
settled if an attribute will be mono or multi valued based on their
model, so maybe we can provide a parameter in the mapping which will
say if the engine should consider the attribute as mono or multi
valued.
About transactions, although there is no transaction in LDAP for the
moment, we should provide the same functionnely like in sqlmap so it
could be easily implemented later.
This is what I've got in mind for now.

I'd like to know about exchange of docs and code inside iBatis
community. If I'd like to submit you docs or code, what's the best way
? Should I post them on this list ?

If I use some words that don't match the ones you are used to use,
just tell me !

First step is made, hope it was the most difficult one ;-)

Cimballi


On 2/12/06, Larry Meadors <[EMAIL PROTECTED]> wrote:
 


I think that would be very interesting. :-)

I did some work with LDAP recently, and think that having something
like SQL Maps for LDAP queries would be really useful. One thing I had
problems with was that the attributes are all name-value pairs - like
doing everything with Maps. ;-)

Semantically, I think it would fit - there is no concept of a mapped
statement, but SQL injection is not really an issue, so escaping may
be adequate. Query results come back in a similar way (name-value
pairs), so that fits. It may actually be simpler because the names of
the attributes are defined by the classes of the returned objects.

Sounds cool!

Larry
   

Re: Maybe OT... what not to have in iBATIS

[Clinton Begin]

+1 on all accounts.  The only comment I'd have is about EHCache and JCSiBATIS has a pluggable cache model, that should be compatible with either.  Although Cameron Purdy once suggested we open up the CacheModel class for extension, to make integrating JCS (Coherence in his case).  I think Cameron's idea is good, and I believe it's already logged in JIRA.  We could add support for JCS or EHCache, but I'd suggest the people who want them should implement them and then contribute them to the project.  I don't want to be an ivory tower of generating plugins for everything under the sun.  By waiting for someone else to implement it, we're ensuring there's an audience for the feature.
In any case.I say close 'em!BTW:  Great job triaging the issue tracker entries Sven!Cheers,ClintonOn 3/18/06, Sven Boden
 <[EMAIL PROTECTED]> wrote:Do we ever vote on stuff we don't want to have in iBATIS?... Below is a
list of JIRA requests/bugs I would not implement.Regards,Sven- IBATIS-22: Specify Query TimeoutThe only projects I can think of that would need it would be kind ofreporting systems. Most systems I know of either want to have the or
data or not. Timeout is also not supported by JDBC and implementing ahack for it (2 threads and then cancelling after the timeout) causesproblems in DB2 for sure (hanging connections). And a workaround exists
by using it via a Timeout aware datasource.- IBATIS-73: EHCache for iBATISI would rather have JCS (http://jakarta.apache.org/jcs/index.html) ascache then EHCache. JCS was written as a EHCache replacement. But maybe
we already have enough dependencies,- IBATIS-119: use label from sql for mapping (XML stuff)Doesn't seem very useful.- IBATIS-120: Use of java.util.List for input parameterToo error prone.
- IBATIS-206: Support for JDBC 3.0 Disconnected Resultsets such asWebRowSet/CachedRowSetiBATIS is into returning domain objects, not returning ResultSets- IBATIS-211: Cache should follow structure of hierarchical resultmaps
As stated doesn't make sense as iBATIS doesn't use object identity...something as flushOnFlush could possibly be implemented.- IBATIS-222: Evict from cacheCould even be closed now... it doesn't make sense as iBATIS doesn't use
object identity- IBATIS-226: Support Commons DBUtils ResultHandlerNot as in the original request. Could be implemented as some kind ofextension point- IBATIS-240: Add support to generate either non-prepared statements or
sequence of simple SQL statementsincluding bad practices is not on my wishlist- IBATIS-259: SqlMapTransactionManager.setUserConnection(null) does notcomplete restore previous transaction stateNot the intended usage

Re: Maybe OT... what not to have in iBATIS

[Clinton Begin]

Thanks for your feedback Chris.I should have applied my comment to all featuresif you have a need, and fill it, feel free to contribute it back.  After all, you're the best people to solve the problems!  ;-)
Cheers,ClintonOn 3/18/06, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:






I would disagree 
with not implementing IBATIS-22: Specify Query Timeout.  This definitely 
something that is supported by the JDBC API (just not neceassarily every jdbc 
driver) and it is necessary for mission critical applications.  We can't 
let a potential "run-away" query lock-up an entire application... this actually 
happened to us in a production environment and we made a change to the IBatis 
core to support this concept.  Haven't gotten around to submitting it back 
yet...
 
- 
Chris 

  -Original Message-From: Clinton Begin 
  [mailto:[EMAIL PROTECTED]]Sent: Saturday, March 18, 2006 
  12:05 PMTo: dev@ibatis.apache.org; 
  [EMAIL PROTECTED]Subject: Re: Maybe OT... what not to have in 
  iBATIS+1 on all accounts.  The only 
  comment I'd have is about EHCache and JCSiBATIS has a pluggable cache 
  model, that should be compatible with either.  Although Cameron Purdy 
  once suggested we open up the CacheModel class for extension, to make 
  integrating JCS (Coherence in his case).  I think Cameron's idea is good, 
  and I believe it's already logged in JIRA.  We could add support for JCS 
  or EHCache, but I'd suggest the people who want them should implement them and 
  then contribute them to the project.  I don't want to be an ivory tower 
  of generating plugins for everything under the sun.  By waiting for 
  someone else to implement it, we're ensuring there's an audience for the 
  feature. In any case.I say close 'em!BTW:  Great job 
  triaging the issue tracker entries Sven!Cheers,Clinton
  On 3/18/06, Sven Boden 
  <[EMAIL PROTECTED]> 
  wrote:
  Do 
we ever vote on stuff we don't want to have in iBATIS?... Below is a 
list of JIRA requests/bugs I would not 
implement.Regards,Sven- IBATIS-22: Specify Query 
TimeoutThe only projects I can think of that would need it would be kind 
ofreporting systems. Most systems I know of either want to have the or 
data or not. Timeout is also not supported by JDBC and implementing 
ahack for it (2 threads and then cancelling after the timeout) 
causesproblems in DB2 for sure (hanging connections). And a workaround 
existsby using it via a Timeout aware datasource.- IBATIS-73: 
EHCache for iBATISI would rather have JCS (http://jakarta.apache.org/jcs/index.html) 
ascache then EHCache. JCS was written as a EHCache replacement. But 
maybe we already have enough dependencies,- IBATIS-119: use 
label from sql for mapping (XML stuff)Doesn't seem very useful.- 
IBATIS-120: Use of java.util.List for input parameterToo error 
prone.- IBATIS-206: Support for JDBC 3.0 Disconnected Resultsets 
such asWebRowSet/CachedRowSetiBATIS is into returning domain 
objects, not returning ResultSets- IBATIS-211: Cache should follow 
structure of hierarchical resultmaps As stated doesn't make sense as 
iBATIS doesn't use object identity...something as flushOnFlush could 
possibly be implemented.- IBATIS-222: Evict from cacheCould even 
be closed now... it doesn't make sense as iBATIS doesn't use object 
identity- IBATIS-226: Support Commons DBUtils ResultHandlerNot 
as in the original request. Could be implemented as some kind 
ofextension point- IBATIS-240: Add support to generate either 
non-prepared statements or sequence of simple SQL 
statementsincluding bad practices is not on my wishlist- 
IBATIS-259: SqlMapTransactionManager.setUserConnection(null) does 
notcomplete restore previous transaction stateNot the intended usage 


**
This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you

**

Re: Help with ticket IBATIS-225

[Clinton Begin]

I can have a look at it.  I'm not sure what's involved, as that wasn't the original idea behind @resultMap.  On the surface, it looks simple.Cheers,ClintonOn 3/30/06, 
Paul Benedict <[EMAIL PROTECTED]> wrote:
I have a business need for issue 225:http://issues.apache.org/jira/browse/IBATIS-225It's too cumbersome to repeat a large result set mapping in another
query when eager fetching is required (joining to get a related object).I should be able to use @resultMap without needing a collection.I am willing to work on it but I need someone else's helpbecause I do not know the ibatis source code as well as
I should :-) I believe the change needs to be made tocom.ibatis.sqlmap.engine.mapping.result.BasicResultMapin method setNestedResultMappingValue.Is anyone willing to discuss this issue to develop a solution?
Paul__Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection aroundhttp://mail.yahoo.com

Re: Help with ticket IBATIS-225

[Clinton Begin]

Hi Paul, I'm swamped right now.  But if you try to put something together, I should be able to look at it.  If you can get it to work, I don't have any problem reviewing it with the rest of the team and committing it.  
If you like, feel free to email the dev list and ask for help from others.Cheers,ClintonOn 4/6/06, Paul Benedict <
[EMAIL PROTECTED]> wrote:Clinton, I have some time to devote to this. Do you? Here's my thinking:
BasicResultMap.getResults() iterates a fix list of result mappings. I don'tthink we can do any sort of "expansion" with a @resultMap because of this,but I am trying to find a method that will simply decode a sub resultmap
without incrementing the ResultSet?I am beginning to look at non-collection @resultMap to be like an implicitinheritence, would you? It's just a listing of additional properties todecode. What do you think?
Paul--- Clinton Begin <[EMAIL PROTECTED]> wrote:> I can have a look at it.  I'm not sure what's involved, as that wasn't the> original idea behind @resultMap.  On the surface, it looks simple.
>>> Cheers,> Clinton>>> On 3/30/06, Paul Benedict <[EMAIL PROTECTED]> wrote:> >> > I have a business need for issue 225:
> > http://issues.apache.org/jira/browse/IBATIS-225> >> > It's too cumbersome to repeat a large result set mapping in another
> > query when eager fetching is required (joining to get a related object).> > I should be able to use @resultMap without needing a collection.> >> > I am willing to work on it but I need someone else's help
> > because I do not know the ibatis source code as well as> > I should :-) I believe the change needs to be made to> > com.ibatis.sqlmap.engine.mapping.result.BasicResultMap> > in method setNestedResultMappingValue.
> >> > Is anyone willing to discuss this issue to develop a solution?> >> > Paul> >> > __> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam protection around> > http://mail.yahoo.com> >>__
Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection aroundhttp://mail.yahoo.com

Re: JIRA Triage

[Clinton Begin]

If they're "bugs" with workarounds (214 and 125) that everyone accepts.turn them into "improvements" rather than closing the bug.  It's nice too keep those in the open state, so we can have a peek through for future versions...  otherwise, 
Cheers,ClintonOn 5/31/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
Hi All,
 
I've been doing some looking in JIRA for low hanging fruit, and have come across some things that should probably be closed as "won't fix".  Here are the items, and my reasons:
 
IBATIS-214 - simple workaround - don't use parameter mapsIBATIS-140 - odd request, no comments, over 1 year oldIBATIS-129 - not a bug or enhancement request, just an announcementIBATIS-125 - simple workaround exists, no comments for nearly a year
 
If you have any comments, please respond.  Otherwise I'll close as "won't fix" on June 7.
 
Thanks!
Jeff Butler
 

Re: Reporting Efforts

[Clinton Begin]

RE: #1 Also make sure to do this for intermediate commits, not just at the end of the work.  Committing intermediate work is allowed (commit often), as long as the tests pass.  For example, just like Brandon did here:
IBATIS-28 Initial test and derby to support testAnd then when the work is complete, we should mark it complete in the comment, using the full original JIRA ticket description for example:COMPLETED IBATIS-28 Support multiple results from Stored Procedures
  - or -FIXED IBATIS-28 Support multiple results from Stored Procedures
RE: #2 I fully agree with Jeff.  If it's good enough to be commented, it's good enought to be deleted.  SVN will take care of history.  Commenting code is often due to a lack of confidence in what you're working on.  If you're not confident in deleting the code, ask someone else for their opinion.  I'm happy to explain any part of the code. 
Finally (from me anyway):  Please try to keep the release.txt file in the /doc directory up to date.  I've updated it for all of the changes to date for the next version.  I know it seems like duplicate work, but it's important, as this is the file that will be deployed with the application, and it's the one that we've used since version 
1.x.  Nice to see all of the discussion due to the activity lately.  Good stuff. I guess we should put these guidelines on the wiki somewhere.Cheers,ClintonOn 6/6/06, 
Jeff Butler <[EMAIL PROTECTED]> wrote:
+1
 
Two more suggestions...
 
1. ALL modifications should be tied to a JIRA ticket.  So even if you're working on something that is totally on your own initiative, please make a JIRA issue and assign it to yourself.
 
2. If for some reason you feel the need to comment out a section of code, please also write a comment about why you're doing that and the curcumstances under which the code could be uncommented or deleted.  It's really unnerving to come across large sections of commented code - could they be uncommented at some point in time?  BTW - my own personal bent is that you should never comment out code except in testing scenarios.  If it's not needed, then delete it.  If you need to get it back then use your SCM to retrieve the history.
 
Jeff Butler 
On 6/6/06, Brandon Goodin <[EMAIL PROTECTED]
> wrote:
Hey All,Just a friendly reminder. Let's be sure that we are using JIRA tocommunicate with each other. When you are working on a bug be sure to
assign it to yourself, adjust the status, and maintain thisinformation through the various stages of resolution. Also, it is goodto use JIRA to record questions and answers regarding the bug. Thiswill help us in the future as we are working through other issues. It
is best to keep the bug information as full as possible. This willavoid us having to search development archives for information thatcan more easily be found in bug comments.Thanks!Brandon Goodin

Re: GUID primary key.

[Clinton Begin]

Questions:What Java type are you mapping it to? (I would expect String, or possibly BigInteger).Are you getting the exception on the parameter, or the result map?Why do you distinguish PaginatedList...does it work if you just do a queryForList()?
ClintonOn 6/6/06, Dorin Manoli <[EMAIL PROTECTED]> wrote:













Haow can I invoke PaginatedList for a GUD primary
key. It always raise an exception "Specified cast is not valid."

Re: [VOTE] Promote iBATIS.NET DataMapper V1.3 and DataAccess V1.7 to General Availability

[Clinton Begin]

+1On 6/6/06, Gilles Bayon <[EMAIL PROTECTED]> wrote:
Hi all,There will be no additional beta release for DataMapper 1.3, there's is no major issue with it and it must be marked as release for a while.
 
PMC members: please vote for GA. 
Cheers,
-Gilles

Javalobby and dzone and devx.com do iBATIS...

[Clinton Begin]

This just arrived in my inbox...my regular JavaLobby newsletter.  I couldn't find an online version, so I'm posting it here and will add it to the wiki.After at least three months of on and off work, we are pleased to say that 
dzone.com
is finally ready for you to enjoy. (Be sure to read Matt's column
following this one for some detailed tips and insights about how to get
the most from dzone.com[snip]That being said, we feel good about what we built to power 
dzone.com. To begin with, we used Spring 2.0 and the Spring Web MVC, [snip]
 But the more interesting technical choice was probably the selection of Apache iBatis
for data persistence. One of the great advantages of Spring is that it
makes it easy to support replaceable implementations for your data
persistence. Hibernate,
of course, is a very popular choice and works well with Spring. We were
concerned, however, that with Hibernate we would be relying too heavily
of the ORM layer to perform database magic. Having learned from hard
experience that database optimization can have at least as much, if not
more, impact on overall performance of Java web applications, we
thought it might be prudent to stay a little closer to our SQL than
Hibernate makes it easy to do. Now don't get me wrong, we have used
Hibernate with great success in other applications, and Matt and I both
respect and admire what this excellent open source ORM layer gives you.
We have also spen!
t more than a few hours watching database logs to find problems in
Hibernate applications, and the SQL Hibernate generates can be really
scary. It's almost invariably correct, but it has that machine-like
bias for not caring whether the queries it outputs are human-readable.
 iBatis,
on the other hand, allowed us to enjoy many of the advantages of an ORM
layer without handing over control to a black box, even one as
competent as Hibernate obviously is. We got to construct hand-written
SQL for our operations and correlate the results of those SQL
statements with JavaBeans that provide object-oriented mappings to and
from the database backend. Spring was equally well prepared to work
with iBatis as it was with Hibernate, so we had confidence that we
could drop back to Hibernate if our iBatis experiment didn't work out.
It did work out, however. iBatis lets us stay very close to the
database, almost as if we were using direct JDBC calls, yet we get to
concentrate all of those calls behind a JavaBeans abstraction that let
us build DAOs, managers and work in a thoroughly object-oriented data
model without concern for the relational database behind it. iBatis was
a good choice for dzone.com,
and I'm! glad we took the chance to try it out. It's just one more case
that proves there is more than one way to get the job done well.
Hibernate is extremely popular, but there are other excellent options
out there, too.---dzone.com looks great, and JavaLobby also has a new look and feel (since the last time I was there anyway).  Check them out.Also a link on dzone found me this:  
http://www.devx.com/Java/Article/31481?trk=DXRSS_LATESTCheers,Clinton

Re: Cannot find sqlmap in jar - new bug

[Clinton Begin]

>> which means that IBATIS is making a wrong assumption hereYou're assuming iBATIS is making an assumption.  Which it is not. If you're using the the iBATIS Resources util, you can confirm the behavior here:
http://svn.apache.org/repos/asf/ibatis/trunk/java/mapper/mapper2/src/com/ibatis/common/resources/Resources.java
Cheers,ClintonOn 6/10/06, Paul Benedict <[EMAIL PROTECTED]> wrote:
I am using version 2.1.5.582My web application has a sqlMapConfig.xml file which is the bootstrap config for ibatis. But theactual configuration files which it refers ( elements) are in a jar. Has anyone had this
problem?I have verified that exploding the jar into my WEB-INF/classes directory makes the problem goaway, which means that IBATIS is making a wrong assumption here. Is it using a File object insteadof 
Class.getResourceAsStream() ?-- Paul__Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: Cannot find sqlmap in jar - new bug

[Clinton Begin]

Did you try removing the "/" from the beginning of your resource path when loading the xml files from the JAR file?  "/c
om/company/people/impl/PeopleImpl-sqlmap.xml" />ClintonOn 6/11/06, Brandon Goodin <
[EMAIL PROTECTED]> wrote:I'd recommend that you place your sqlMapConfig.xml
 in the classesdirectory and use the follwing spring config.class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">I would assume this issue is tied to the fact that the sqlMapConfig isnot being loaded from the classpath.
BrandonOn 6/11/06, Paul Benedict <[EMAIL PROTECTED]> wrote:> Brandon,>> >>All i can tell you is that i have recently created an application that
> uses Spring, iBATIS and is jarred up.>> Forgive me, but based on the feedback I am getting, I am not convinced at all that my problem is> being understood. Can you give me some confidence it is? As I said, this is not a problem with the
> application being jarred up --- my application is not jarred up.>> My problem arises when:> (1) the sqlmapconfig.xml exists in the webapp but> (2) the actual sqlmap files belong in a LIB jar.
>> Do you see the difference?>> Paul>> __> Do You Yahoo!?> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com>

Re: Cannot find sqlmap in jar - new bug [RESOLVED]

[Clinton Begin]

Of course, that's all app server dependent.  It should work as you describe.  Here's the silly thing about some classloaders:  if your resource is loaded with the local classloader (thread or via known class), you can start with a slash ("/"), but if it's loaded by the system classloader, you can't start with a slash.  When you put your SQL Maps in a JAR, it's likely they'll be loaded by the system classloader.  So putting the slash in front of the 
SqlMapConfig.xml when in the web-inf, but not for each of the resources in the JAR may work.Classloaders are messed up.ClintonOn 6/12/06, 
Paul Benedict <[EMAIL PROTECTED]> wrote:
Thanks everyone for your help. The problem is resolved.1) You cannot put sqlmapconfig in WEB-INF but your sqlmap files in jars. This splits the classloader and so one will be found but not the other. Either put them all in your classpath or in WEB-INF
2) Do not start with a /Paul __Do You Yahoo!?Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

More JavaLobby/dzone Treats (i.e. iBATIS survives DIGG effect)

[Clinton Begin]

In the continuing saga of the JavaLobby spin-off dzone.com, I proudly share this on behalf of the iBATIS team...
Well, at about 6AM that morning it did get hit by a traffic tsunami. It
was huge, but when I woke up a half-hour or so later our baby was
happily handling everything DIGG could throw at it, and it wasn't even
breaking a sweat! It was a huge relief, and I believe it is a
meaningful validation of the excellent work of the developers of the
open source Spring framework, 
Apache iBatis and the many other tools we leveraged to assemble dzone.com.
If anyone out there is still buying into that "Java is slow. Java
doesn't scale." malarkey, then I'll be delighted to sit down with them
to set the record straight. The access log was flying by much too fast
to read, yet the server was sitting pretty with a load average hovering
between 0.3 and 0.5. Matt woke up shortly after I did, and we both
heaved a major sigh of relief that the powers that be were smiling on
us and on dzo!
ne.com.
Mike, who is much more of a night owl, was sound asleep until about
9:30 or 10:00 that morning and missed out on some of the fun. (Digg's
traffic wave is huge, but bursts very quickly and then tapers off just as quickly.)
---Clinton

Re: Unsubscribe my mail ID from Ibatis forums...

[Clinton Begin]

Harinder, it's important that you understand this:We do not maintain the mailing lists.  YOU DO.
Send an email to 
[EMAIL PROTECTED] to unsubscribe from each of the lists that you subscribed to.  For example:[EMAIL PROTECTED], 
[EMAIL PROTECTED], [EMAIL PROTECTED]
[EMAIL PROTECTED]...It's pretty much the same process you used to sign up for them in the first place.Cheers,ClintonOn 6/22/06, 
harinder nandyala <[EMAIL PROTECTED]> wrote:
Please unsubscribe my mail ID from iBatis mailing/forum list.Thank you,Harinder Nandyalahttp://www.ashakiran.org"The more you strive for humanity, the more civilized you become" -ASHA

Re: Release Status???

[Clinton Begin]

Sorry Jeff, I have a few small things:  * Buildable source download:  The build script should zip up (iBATIS_SRC-2.1.7.612.zip) the entire buildable dir tree (excluding subversion directories of course) and stick it beside the binary distributable in the deploy directory.
  * Batching stored procs:  Just need to comment out the overload in comment out ProcedureStatement.  * execute vs. executeQuery for procs:  Procs should use whatever is not used now...can't remember.
And one big thing:  * Multiple result sets: already logged in JIRA.I don't think the first three items have jira entries.Gotta run right now, more later!Clinton
On 6/30/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
I believe I'm finished with everything I wanted to do for 2.2.0.  I'm wondering what everyone else's status is.
 
I would be happy to act as release manager for a 2.2.0 release if there's a consensus that it's time to do that.  Or, if there are other things that folks are working on, we could wait a little while longer.
 
Let me know what you think about starting the process for 2.2.0 - I'm +1 for doing it, with the caveat that I'm not sure what everyone else is working on.
 
Jeff Butler
 

Re: Release Status???

[Clinton Begin]

iBATIS does come with the source, always has, always will.  It's in the /src directory of the zip file.The new task I mentioned above is a SEPARATE source download that includes all of the build scripts and dev dependencies so that you can easily build the app yourself.  Basically it's to help people who don't know how to use Subversion export.
Cheers,ClintonOn 7/1/06, Paul Benedict <[EMAIL PROTECTED]> wrote:
Please provide a maven 2 pom and include the source for 2.2.0. One problem I have now is that ibatis has no source jar in M2, and so i can't step through ibatis when I'd like :-)
Jeff Butler <[EMAIL PROTECTED]> wrote:
 Are you referencing this issue:   http://issues.apache.org/jira/browse/IBATIS-122
   Or something else?   Jeff Butler  On 7/1/06, Jerome Gagner <
[EMAIL PROTECTED]> wrote: I vote for a maven package.On
 6/30/06, Larry Meadors <[EMAIL PROTECTED] > wrote:> I have nothing for it...>> On 6/30/06, Jeff Butler <
[EMAIL PROTECTED]> wrote:> >> > I believe I'm finished with everything I wanted to do for  
2.2.0.  I'm> > wondering what everyone else's status is.> >> > I would be happy to act as release manager for a 2.2.0 release if there's a> > consensus that it's time to do that.  Or, if there are other things that 
> > folks are working on, we could wait a little while longer.> >> > Let me know what you think about starting the process for 2.2.0 - I'm +1 for> > doing it, with the caveat that I'm not sure what everyone else is working 
> > on.> >> >> > Jeff Butler>
 >>  
		Want to be your own boss? Learn how on  Yahoo! Small Business.
 

Re: Release Status???

[Clinton Begin]

Oh.  I'll leave that to whomever set up the other ibiblio stuff.  Unfortunately the source build task I'm talking about would include a number of other things, and an inappropriate directory structure for Maven.

Can you not upload the source to ibiblio?Cheers,ClintonOn 7/1/06, Paul Benedict <
[EMAIL PROTECTED]> wrote:
Clinton, I use M2 with ibatis, and M2 cannot find the source. You need to upload it as a separate jar with the extension -sources.jarClinton Begin <

[EMAIL PROTECTED]> wrote: iBATIS does come with the source, always has, always will.  It's in the /src directory of the zip file.
The new task I mentioned above is a SEPARATE source download that includes all of the build scripts and dev dependencies so that you can easily build the app yourself.  Basically it's to help people who don't know how to use Subversion export. 
Cheers,ClintonOn 7/1/06, Paul Benedict <

[EMAIL PROTECTED]> wrote: Please provide a maven 2 pom and include the source for 
2.2.0. One problem I have now is that ibatis has no source jar in M2, and so i can't step through ibatis when I'd like :-) Jeff Butler <

[EMAIL PROTECTED]> wrote:  Are you referencing this issue:   

http://issues.apache.org/jira/browse/IBATIS-122    Or something else?   Jeff Butler  On 7/1/06, Jerome Gagner
 < [EMAIL PROTECTED]> wrote: 

I vote for a maven package.On  6/30/06, Larry Meadors <[EMAIL PROTECTED] > wrote:> I have nothing for it...
>> On 6/30/06, Jeff Butler < [EMAIL PROTECTED]> wrote:> >> > I believe I'm finished with everything I wanted to do for   
2.2.0.  I'm> > wondering what everyone else's status is.> >> > I would be happy to act as release
 manager for a 2.2.0 release if there's a> > consensus that it's time to do that.  Or, if there are other things that  > > folks are working on, we could wait a little while longer.> >> > Let me know what you think about starting the process for 
2.2.0 - I'm +1 for> > doing it, with the caveat that I'm not sure what everyone else is working  > > on.> >> >> > Jeff Butler>  >>

 Want to be your own boss? Learn how on 

 Yahoo! Small Business.  
		Do you Yahoo!? 
Get on board. You're invited to try the new Yahoo! Mail Beta.

Re: iBATIS Web Site Structure

[Clinton Begin]

Sounds good.  +1On 7/17/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
Hi All,
 
I know Clinton has some ideas for restructuring the site now that the Ruby content is getting close.  My main interest is in getting some additional documentation for Abator published.  So, I'm wondering what you all think of a docs structure like this:

 

/docs/dotnet/docs/java
/docs/ruby
/docs/tools/abator
 
These would each be "top level" directories, the different projects could structure as needed under their directory.  Any other stuff that I've forgotten?
 
This would mean that the site would be structured like this:
 
/ - the existing site
/dtd - existing dtd directory, must not be disturbed when the site is regenerated
/docs - new top level docs directory with subdirectories as above, must not be disturbed when the site is regenerated
/tools/abator - existing directory that is serving the Eclipse update site for Abator, must not be disturbed when the site is regenerated
 
The only thing I'm proposing to add to what's already there are the different docs directories.  And I guess the only thing I really have to add right now is /docs/tools/abator.
 
Anyone have objections or other ideas?
 
Jeff Butler
 
 

Re: feture request

[Clinton Begin]

Can you add these to JIRA if they're not already there?The cache hits/misses On 7/17/06, netsql <[EMAIL PROTECTED]
> wrote:these come up from time to time:1. Sql logging, like slow querries
2. cache memory monitoring, like catch hits/misses and size used,requests per statement by day/houri'd consider implementing if that helps..V

Re: rbatis website

[Clinton Begin]

Yeah, Basically the site development paradigm (our favourite word) should be familiar to you.  We use plain old HTML/XHTML with StaticMesh for theming.  You can edit any of the pages which might be .html of .vm (velocity macro) files.  There's no magic to it.  
Once you've edited it, use the build.bat (Ant script) to generate the site to the the /deploy directory.  But definitely read Jeff's docs.   They'll ensure you don't blow anything away. :-)Clinton
On 7/19/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
Hi Jon,
 
That took me a while to figure out too!
 
I've just updated the WIKI page about this with more current information:
 

http://opensource.atlassian.com/confluence/oss/display/IBATIS/Updating+the+Website
 
My opinion is that you should add a high level page linked under the "Downloads and Documentation" section that describes the new version (BTW - woo hoo!).  Then you can add detailed documentation under the /docs/ruby directory.  You can structure and generate those pages any way you desire.

 
Jeff Butler 
On 7/19/06, Jon Tirsen <
[EMAIL PROTECTED]> wrote:
I'm finally getting the RBatis website together. Forgive me for askinga newbie question, but: Where is the current iBatis website? How do I
go about changing it? How do I redeploy it? Any thoughts were I shouldput the RBatis material?Cheers,Jon

Re: Re: rbatis website

[Clinton Begin]

Yes, Jeff sent an email describing the docs structure.  As below:VVHi All,
 
I know Clinton has some ideas for restructuring the site
now that the Ruby content is getting close.  My main interest is in
getting some additional documentation for Abator published.  So, I'm
wondering what you all think of a docs structure like this:

 

/docs/dotnet/docs/java
/docs/ruby
/docs/tools/abator
 
These would each be "top level" directories, the different
projects could structure as needed under their directory.  Any other
stuff that I've forgotten?
 
This would mean that the site would be structured like this:
 
/ - the existing site
/dtd - existing dtd directory, must not be disturbed when the site is regenerated
/docs - new top level docs directory with subdirectories as above, must not be disturbed when the site is regenerated
/tools/abator - existing directory that is serving the Eclipse update site for Abator, must not be disturbed when the site is regenerated

 
The only thing I'm proposing to add to what's already there are
the different docs directories.  And I guess the only thing I really
have to add right now is /docs/tools/abator.
 
Anyone have objections or other ideas?^^^On 7/19/06, Jon Tirsen <
[EMAIL PROTECTED]> wrote:I've got a bunch of rdoc (equivalent to JavaDoc) API documentation I
would like to deploy as well. Can I have completely unstyled contentas well?Cheers,JonOn 7/20/06, Clinton Begin <[EMAIL PROTECTED]> wrote:
> Yeah,>> Basically the site development paradigm (our favourite word) should be> familiar to you.  We use plain old HTML/XHTML with StaticMesh for theming.> You can edit any of the pages which might be .html of .vm (velocity macro)
> files.  There's no magic to it.>> Once you've edited it, use the build.bat (Ant script) to generate the site> to the the /deploy directory.>> But definitely read Jeff's docs.   They'll ensure you don't blow anything
> away. :-)>> Clinton>>> On 7/19/06, Jeff Butler <[EMAIL PROTECTED]> wrote:> >> >> > Hi Jon,
> >> > That took me a while to figure out too!> >> > I've just updated the WIKI page about this with more current information:> >> >> 
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Updating+the+Website> >> > My opinion is that you should add a high level page linked under the> "Downloads and Documentation" section that describes the new version (BTW -
> woo hoo!).  Then you can add detailed documentation under the /docs/ruby> directory.  You can structure and generate those pages any way you desire.> >> >> > Jeff Butler> >
> >> >> > On 7/19/06, Jon Tirsen < [EMAIL PROTECTED]> wrote:> > > I'm finally getting the RBatis website together. Forgive me for asking
> > > a newbie question, but: Where is the current iBatis website? How do I> > > go about changing it? How do I redeploy it? Any thoughts were I should> > > put the RBatis material?> > >
> > > Cheers,> > > Jon> > >> >> >>>

Re: Re: Re: rbatis website

[Clinton Begin]

>> Is everyone okay with me adding the following to the site on the left hand menu: >> for Ruby/Rails (prerelease)
Yep, looks good!>> The link currently just goes to http://ibatis.apache.org/docs/ruby
>> which is the automatically generated RDoc API documentation. It doesNo problem.>> The>> easiest way to get full access to deploying a gem on Rubyforge is by>> registering a project at Rubyforge for RBatis. Would there be any
>> problems around doing that?No, there shouldn't be any problems with that.  For the most part, source control and mailing lists are the important parts of Apache infrastructure for legal reasons.  For other pieces, we can leverage other resources even if it's hosted elsewhere (
e.g. our Confluence is hosted by Atlassian).So full +1 from me!  Very exciting indeed.Cheers,ClintonOn 7/21/06, Jon Tirsen <
[EMAIL PROTECTED]> wrote:Is everyone okay with me adding the following to the site on the left hand menu:
  for Ruby/Rails (prerelease)The link currently just goes to 
http://ibatis.apache.org/docs/rubywhich is the automatically generated RDoc API documentation. It doescontain instructions on how to download, install and getting startedthough. (This is common practice in the Ruby world.)
Oh, another thing: We currently have a Rails plugin which is great forRails users, for users outside Rails we need something called a "Gem".It kinda works a bit like Maven or Ports as in they are automatically
downloaded and installed. They are distributed from Rubyforge. Theeasiest way to get full access to deploying a gem on Rubyforge is byregistering a project at Rubyforge for RBatis. Would there be anyproblems around doing that?
Cheers,JonOn 7/20/06, Clinton Begin <[EMAIL PROTECTED]> wrote:> Yes, Jeff sent an email describing the docs structure.  As below:
>> VV>>> Hi All,>> I know Clinton has some ideas for restructuring the site now that the Ruby> content is getting close.  My main interest is in getting some additional
> documentation for Abator published.  So, I'm wondering what you all think of> a docs structure like this:>>> /docs/dotnet/docs/java> /docs/ruby> /docs/tools/abator>
> These would each be "top level" directories, the different projects could> structure as needed under their directory.  Any other stuff that I've> forgotten?>> This would mean that the site would be structured like this:
>> / - the existing site> /dtd - existing dtd directory, must not be disturbed when the site is> regenerated> /docs - new top level docs directory with subdirectories as above, must not
> be disturbed when the site is regenerated> /tools/abator - existing directory that is serving the Eclipse update site> for Abator, must not be disturbed when the site is regenerated>> The only thing I'm proposing to add to what's already there are the
> different docs directories.  And I guess the only thing I really have to add> right now is /docs/tools/abator.>> Anyone have objections or other ideas?> ^^^
>>> On 7/19/06, Jon Tirsen < [EMAIL PROTECTED]> wrote:> > I've got a bunch of rdoc (equivalent to JavaDoc) API documentation I> > would like to deploy as well. Can I have completely unstyled content
> > as well?> >> > Cheers,> > Jon> >> > On 7/20/06, Clinton Begin <[EMAIL PROTECTED]> wrote:> > > Yeah,
> > >> > > Basically the site development paradigm (our favourite word) should be> > > familiar to you.  We use plain old HTML/XHTML with StaticMesh for> theming.> > > You can edit any of the pages which might be .html of .vm (velocity
> macro)> > > files.  There's no magic to it.> > >> > > Once you've edited it, use the build.bat (Ant script) to generate the> site> > > to the the /deploy directory.
> > >> > > But definitely read Jeff's docs.   They'll ensure you don't blow> anything> > > away. :-)> > >> > > Clinton> > >> > >
> > > On 7/19/06, Jeff Butler <[EMAIL PROTECTED]> wrote:> > > >> > > >> > > > Hi Jon,> > > >
> > > > That took me a while to figure out too!> > > >> > > > I've just updated the WIKI page about this with more current> information:> > > >> > > >
> > >> http://opensource.atlassian.com/confluence/oss/display/IBATIS/Updating+the+Website> > > >
> > > > My opinion is that you should add a high level page linked under the> > > "Downloads and Documentation" section that describes the new version> (BTW -> > > woo hoo!).  Then you can add detailed documentation under the /docs/ruby
> > > directory.  You can structure and generate those pages any way you> desire.> > > >> > > >> > > > Jeff Butler> > > >> > > >
> > > >> > > > On 7/19/06, Jon Tirsen < [EMAIL PROTECTED]> wrote:> > > > > I'm finally getting the RBatis website together. Forgive me for
> asking> > > > > a newbie question, but: Where is the current iBatis website? How do> I> > > > > go about changing it? How do I redeploy it? Any thoughts were I> should
> > > > > put the RBatis material?> > > > >> > > > > Cheers,> > > > > Jon> > > > >> > > >> > > >
> > >> > >> >>>

Re: Confluence wiki location

[Clinton Begin]

I've been enjoying Atlassian's hosting, because we get all the latest upgrades!  :-)Thoughts?ClintonOn 7/22/06, Ted Husted <
[EMAIL PROTECTED]> wrote:We've finally got a Confluence instance running at the foundation.
*At some likely juncture, we could consider moving our space over fromthe OpenSource site.I'd like to be sure that the autoexport plugin is running first, sincethat takes a huge load off the application. Here's the plugin in
action with the Stuts 2 "interim" site.* http://www.twdata.org/backups/WW/home.htmlAt every change, the plugin exports the changed page, so that the HTML
rendition stays fresh and tasty.Right now, I'm working on a way make the exorpted HTML part of theregular project build, so that we can bundle a doc snapshot with thecode distribution.-Ted.

Re: Any thoughts on creating a different email alias for Tools?

[Clinton Begin]

That's good news for tools.  I'm glad to see the level of interest.  I like the idea of a separate mailing list.  [EMAIL PROTECTED]  ...or...
[EMAIL PROTECTED]Cheers,ClintonOn 7/18/06, Nathan Maves <
[EMAIL PROTECTED]> wrote:Just seems that the ibatis list is being pounded by tools questions.
Since they are two separate identities that we should have them ondifferent lists.Comments?Nathan

[VOTE] New mailing list addresses (was: Any thoughts on creating a different email alias for Tools?)

[Clinton Begin]

Good call on a single request for both.  I'm all for:[EMAIL PROTECTED][EMAIL PROTECTED]This vote is open for 24 hours (no need to drag it out, it's not a world changing decision).
Cheers,ClintonOn 7/24/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
Wondering about the future...are there any more tools on the horizon?  Do we think there will be lots of tools?  If not, then I think 
[EMAIL PROTECTED] is OK.
 
Has the request for a Ruby list been made already?  If not, maybe we could make a joint request for two new lists.
 
Jeff Butler 
On 7/23/06, Clinton Begin <
[EMAIL PROTECTED]> wrote:

That's good news for tools.  I'm glad to see the level of interest.  I like the idea of a separate mailing list.  

[EMAIL PROTECTED]  ...or...
[EMAIL PROTECTED]
Cheers, 
Clinton


On 7/18/06, Nathan Maves <

 [EMAIL PROTECTED]> wrote:

Just seems that the ibatis list is being pounded by tools questions. Since they are two separate identities that we should have them on
different lists.Comments?Nathan
 

Continuous Integration

[Clinton Begin]

Hi all, I really want to set up CI for iBATIS.  I'm planning on implementing it for:The website.  Committed site changes will be automatically deployed.  This will improve consistency, simplify and reduce risk of deployment (
e.g. accidentally deleting docs folders, or forgetting to change permissions).Nightly build.  Although we should be releasing official versions more often than we are, a quick-fix is to offer a nightly build.  The code in our SVN is stable by practice  (we don't commit untested code that breaks), so there's little risk to our users if they want to run a nightly build.
So a couple of questions this raises are:What tools are available/preferred by Apache infrastructure? (Cruise Control, Anthill, cron?)What can we do for our .NET friends?  
CC.NET hosted somewhere else?  FWIW:  I'm cool with hosting a CI server offsite.  CC.NET can build Java and Ruby projects just as easily as .NET projects.  But I don't think Apache has any windows boxes.
Thoughts?Cheers,Clinton

Re: Continuous Integration

[Clinton Begin]

I have a "professionally" hosted VPS service.  Unfortunately it blows goat.FWIW:  westhost.com is THE WORST web hosting service in the WORLD.  I was with Pair for 5 years.  I don't believe there was even a single unplanned outage, and even the planned outages were so few that I don't even recall them.
My westhost VPS has been down 3 or 4 times per month, without fail, both unplanned and planned -- noticably.So...if I can stabalize my hosting service, I can run Cruise or Anthill on it for CI.  Cheers,
ClintonOn 7/25/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
Sounds good.
 
I really can offer a nightly build machine - but it sounds like Clinton has some (probably better) ideas too.  I'll defer to his judgement about that.
 
Jeff Butler 
On 7/25/06, Ted Husted <
[EMAIL PROTECTED]> wrote:
We finally hired a system administator, and things are getting better.
But there is a lot to straighten out yet. Doing something like this
ourselves would be a good step in the interim.-Ted.On 7/25/06, Jeff Butler <
[EMAIL PROTECTED]> wrote:>> Hmmm...sounds like Apache isn't really set up to offer these kinds of
> services.  Maybe offsite is a better choice after all.  I could volunteer a> nightly build machine in my basement :)>>> Jeff Butler

iBATIS DTD served every 2 seconds

[Clinton Begin]

Hi everyone,Guess what!  On average, an iBATIS DTD is served up every 1.8 seconds from ibatis.com, and nearly 1.5 million per month.I know this because it's taking down my new web hosting service.  Which sucks and, as far as I'm concerned, it's all due to WestHost sucking as a service provider (
Pair.com had no issues for the last 5 years).  I know 1 per 2 seconds doesn't sound like much...realize that that's just the average.  The reality is that some hours during the day, DTDs are being requested at an incredible rate, an average of 32 per second, which still doesn't sound like a lot -- but what can I say, WestHost sucks.
Unfortunately I signed up for 2.5 years.  :-)  Think they'll give me a refund...no.  Anyway...So:Nearly a year ago I warned that the iBATIS DTDs will be moved to Apache, and the warning has been on the homepage for just as long.
The DTDs should be resolved from the JAR file if you're using a modern version. It's time to finally pull the plug.In 72 hours, I will remove the DTDs from 
iBATIS.com forever. You don't need to upgrade iBATIS to fix the problem, you just need to change your XML files.
  PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN""http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
  PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN""http://ibatis.apache.org/dtd/sql-map-2.dtd">
  PUBLIC "-//ibatis.apache.org//DTD DAO Configuration 2.0//EN""http://ibatis.apache.org/dtd/dao-2.dtd">
Oh look, it's 11pm on the west coast. That means at 11pm on Friday, the DTDs will be gone.Sorry for any inconvenience.  But you have had a year.  :-)Best regards.
Clinton 

Re: Re: Continuous Integration

[Clinton Begin]

I've got a server.ClintonOn 7/26/06, Jerome Gagner <[EMAIL PROTECTED]> wrote:
I've had very good luck with continuum, personally, but they've allbeen maven2 projects. I can ask around about a spare server if youwant.On 7/25/06, Clinton Begin <
[EMAIL PROTECTED]> wrote:> I have a "professionally" hosted VPS service.  Unfortunately it blows goat.>> FWIW:  westhost.com is THE WORST web hosting service in the WORLD.  I was
> with Pair for 5 years.  I don't believe there was even a single unplanned> outage, and even the planned outages were so few that I don't even recall> them.>> My westhost VPS has been down 3 or 4 times per month, without fail, both
> unplanned and planned -- noticably.>> So...if I can stabalize my hosting service, I can run Cruise or Anthill on> it for CI.>> Cheers,> Clinton>>> On 7/25/06, Jeff Butler <
[EMAIL PROTECTED]> wrote:> >> >> > Sounds good.> >> > I really can offer a nightly build machine - but it sounds like Clinton
> has some (probably better) ideas too.  I'll defer to his judgement about> that.> >> >> > Jeff Butler> >> >> >> >> > On 7/25/06, Ted Husted < 
[EMAIL PROTECTED]> wrote:> >> > > We finally hired a system administator, and things are getting better.> > > But there is a lot to straighten out yet. Doing something like this
> > > ourselves would be a good step in the interim.> > >> > > -Ted.> > >> > > On 7/25/06, Jeff Butler < [EMAIL PROTECTED]
> wrote:> > > >> > > > Hmmm...sounds like Apache isn't really set up to offer these kinds of> > > > services.  Maybe offsite is a better choice after all.  I could
> volunteer a> > > > nightly build machine in my basement :)> > > >> > > >> > > > Jeff Butler> > >> >> >> >
>>

Re: iBATIS DTD served every 2 seconds

[Clinton Begin]

The DTD is already in the WEB-INF/lib, as they're included in the JAR files.  :-)Cheers,ClintonOn 7/26/06, netsql <
[EMAIL PROTECTED]> wrote:Better yet, put your dtd in WEB-INF/lib..V
Clinton Begin wrote:> Hi everyone,>> Guess what!  On average, an iBATIS DTD is served up every 1.8 seconds> from ibatis.com <http://ibatis.com
>, and nearly 1.5 million per month.>> I know this because it's taking down my new web hosting service.  Which> sucks and, as far as I'm concerned, it's all due to WestHost sucking as> a service provider ( 
Pair.com <http://Pair.com> had no issues for the> last 5 years).>> I know 1 per 2 seconds doesn't sound like much...realize that that's
> just the average.  The reality is that some hours during the day, DTDs> are being requested at an incredible rate, an average of 32 per second,> which still doesn't sound like a lot -- but what can I say, WestHost sucks.
>> Unfortunately I signed up for 2.5 years.  :-)  Think they'll give me a> refund...no.  Anyway...>> So:>> * Nearly a year ago I warned that the iBATIS DTDs will be moved to
>   Apache, and the warning has been on the homepage for just as long.> * The DTDs should be resolved from the JAR file if you're using a>   modern version.> * It's time to finally pull the plug.
>> In 72 hours, I will remove the DTDs from iBATIS.com forever.>> You don't need to upgrade iBATIS to fix the problem, you just need to> change your XML files.>> >>   PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN">   "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
>> >   PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN">   "http://ibatis.apache.org/dtd/sql-map-2.dtd
">>> >   PUBLIC "-//ibatis.apache.org//DTD DAO Configuration 2.0//EN">   "http://ibatis.apache.org/dtd/dao-2.dtd
">>> Oh look, it's 11pm on the west coast. That means at 11pm on Friday, the> DTDs will be gone.>> Sorry for any inconvenience.  But you have had a year.  :-)>> Best regards.
>> Clinton>>>

Website updated

[Clinton Begin]

Hi all, I've made some significant look and feel changes to the site -- hopefully eliminating some of the clutter.  Let me know what you think.Also, if anyone can tell me the magical CSS code I need to use to make the site look the same in both Firefox and IE, that would be great. 
Right now it looks the way I want in FF, but the colorful Java/.NET/Ruby bar looks wrong in IE.  I'm very simply using the a:hover, td:hover and color: attributes.Cheers,Clinton

Re: Website updated

[Clinton Begin]

Haha...lol.  I had blue, green, red (colors I'd like to stick with because they semi-relate to the respective technologies)and white text, which had decent contrast.Someone (Gilles?) has changed it to the exact opposite problem.  Now it looks fine in IE, but in FF it washes out.  
HELP!-- PS:  Can we stick to blue, green, red?ClintonOn 7/31/06, Ron Grabowski <[EMAIL PROTECTED]
> wrote:The yellow background for the iBatis for .NET hides the white text too
much (Gilles may have fixed it). Why don't the two top iBATIS logoslink back to the homepage?Are any other committers going to ApacheCon? I'll be there.--- Clinton Begin <
[EMAIL PROTECTED]> wrote:> Hi all, I've made some significant look and feel changes to the site> --> hopefully eliminating some of the clutter.  Let me know what you> think.
>> Also, if anyone can tell me the magical CSS code I need to use to> make the> site look the same in both Firefox and IE, that would be great.>> Right now it looks the way I want in FF, but the colorful
> Java/.NET/Ruby bar> looks wrong in IE.  I'm very simply using the a:hover, td:hover and> color:> attributes.>> Cheers,> Clinton>

Re: Website updated

[Clinton Begin]

The status page is supposed to be updated afer each board meeting, usually with the points made about the project during the meeting.  Kind of like "minutes" if I'm not mistaken.If they're not being updated regularly, we should just get rid of them.  I've noticed that the Struts website doesn't have a status page anymore.
Cheers,ClintonOn 7/31/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
Do we still need the status page?  I'm not sure what's supposed to be on that page and it's pretty out of date.
 
I'll be at ApacheCon.
 
Jeff Butler
 
 
On 7/31/06, Ron Grabowski <[EMAIL PROTECTED]
> wrote:
The yellow background for the iBatis for .NET hides the white text toomuch (Gilles may have fixed it). Why don't the two top iBATIS logos
link back to the homepage?Are any other committers going to ApacheCon? I'll be there.--- Clinton Begin <
[EMAIL PROTECTED]> wrote:> Hi all, I've made some significant look and feel changes to the site
> --> hopefully eliminating some of the clutter.  Let me know what you> think.>> Also, if anyone can tell me the magical CSS code I need to use to> make the> site look the same in both Firefox and IE, that would be great.
>> Right now it looks the way I want in FF, but the colorful> Java/.NET/Ruby bar> looks wrong in IE.  I'm very simply using the a:hover, td:hover and> color:> attributes.>

> Cheers,> Clinton>

Re: Website updated

[Clinton Begin]

How many database guys does it take to update a website?  ;-)I've reverted the colors in SVN.  I'll try to figure out how to make the text white in IEapparently { color:#FF } isn't good enough.Cheers,
ClintonOn 7/31/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
I liked the blue, green and red better too.
 
Jeff Butler
 
On 7/31/06, Clinton Begin <[EMAIL PROTECTED]
> wrote:

Haha...lol.  I had blue, green, red (colors I'd like to stick with because they semi-relate to the respective technologies)and white text, which had decent contrast.Someone (Gilles?) has changed it to the exact opposite problem.  Now it looks fine in IE, but in FF it washes out.  
HELP!-- PS:  Can we stick to blue, green, red? 
Clinton


On 7/31/06, Ron Grabowski <
[EMAIL PROTECTED] > wrote:

The yellow background for the iBatis for .NET hides the white text too much (Gilles may have fixed it). Why don't the two top iBATIS logos
link back to the homepage?Are any other committers going to ApacheCon? I'll be there.--- Clinton Begin <

 [EMAIL PROTECTED]> wrote:> Hi all, I've made some significant look and feel changes to the site> --> hopefully eliminating some of the clutter.  Let me know what you> think.

>> Also, if anyone can tell me the magical CSS code I need to use to> make the> site look the same in both Firefox and IE, that would be great.>> Right now it looks the way I want in FF, but the colorful 
> Java/.NET/Ruby bar> looks wrong in IE.  I'm very simply using the a:hover, td:hover and> color:> attributes.>> Cheers,> Clinton>

 

Re: Website updated

[Clinton Begin]

But unfortunately Rubies aren't blue ;-)  I've revertedIs there no way to change the font color of an  element in IE?  ...I'm sure there must be. Clinton
On 7/31/06, Gilles Bayon <[EMAIL PROTECTED]> wrote:
I have change the color to follow the already colors use in the picture so the whole page is more harmonized.
Changing the font color to black, resolve the problem to Mozilla as you can seen in my screenshot 

Does JDBC 4.0 make iBATIS redundant?

[Clinton Begin]

Hi all,I just picked this up from InfoQ.  What do you think?=Blogger Patrick Lightbody noted "I could see
JDBC 4.0 replacing my need for iBatis" after reading another blog post on JDBC 4.0
functionality. JDBC 4.0 includes basic O/R mapper functionality that
eases the repetitive task of copying ResultSet data into objects. It
does not handle inheritance or table relations however.=http://www.infoq.com/news/Easier-Database-Development-JDBC
Patrick's a good guy and a respected developer.  I appreciate his
opinion.  Obviously, this is only useful for people running JDK 5 or
possibly only JDK 6.  And of course, Annotation support would be an
almost brainless effort to implement for iBATIS.  
   	
	Your thoughts?Clinton

Re: Does JDBC 4.0 make iBATIS redundant?

[Clinton Begin]

Thanks Paul, those are good thoughts.  I think we can easily match and beat anything they come up with, and support it on JDK 4 and 5 for years to come.JDK 5 is still only around 15 - 20% adoption since I last checked...and there's an equal number still on JDK 
1.3.  I don't see it being a significant threat any time soon at least...Cheers,ClintonOn 8/4/06, Paul Benedict <
[EMAIL PROTECTED]> wrote:I saw some JDBC 4.0 and it does not make ibatis obsolete. For instance, annotations are not inheritable but you can extend sqlmaps. Also there will always be a need for XML configuration because not everyone wants their mappings statically-linked into their code; it is impossible to change without recompiling. Furthermore, the churn for turnaround in Sun is slow because the JCP is a snail -- you guys can provide more enhancements and releases than the JDK ever could. No worries here.
PaulClinton Begin <[EMAIL PROTECTED]
> wrote: Hi all,I just picked this up from InfoQ.  What do you think?=
Blogger Patrick Lightbody noted "I could see JDBC 4.0 replacing my need for iBatis" after reading 
another blog
 post on JDBC 4.0 functionality. JDBC 4.0 includes basic O/R mapper functionality that eases the repetitive task of copying ResultSet data into objects. It does not handle inheritance or table relations however.=
http://www.infoq.com/news/Easier-Database-Development-JDBC 
Patrick's a good guy and a respected developer.  I appreciate his opinion.  Obviously, this is only useful for people running JDK 5 or possibly only JDK 6.  And of course, Annotation support would be an almost brainless effort to implement for iBATIS.  
   Your thoughts?Clinton  
	
		See the all-new, redesigned Yahoo.com. 
 Check it out.

Re: Does JDBC 4.0 make iBATIS redundant?

[Clinton Begin]

I've already started some preliminary design work for iBATIS 3, and it does include both annotation and XML support.I have to get it on the wiki...But anyway, I agree about the one-liner thing...but that could be easily fixed with very simple multiline support in the compiler.   In both the C# version and the Ruby version you can do multiline string, for example, in C#:
@"SELECT     FIRST_NAME    LAST_NAME    BIRTH_DATE FROM PERSON WHERE LAST_NAME LIKE @lastName AND DECEASED = false"Super nice.  So annotations can be great, I actually prefer them  to XML, as I rarely need to change my SQL without recompiling and running my tests anyway.  But I can understand others have different situations --supporting both is fairly straight forward.  Luckily, Sun made annotations such just as bad as XML, so it's an easier translation in Java.
The C# Attribute support will be harder to keep consistent with the XML, because there are so many improvements one can make using ordinal parameters and simple things like supporting multiple attributes of the same name clean up the code significantly.
Cheers,Clinton On 8/5/06, Larry Meadors <[EMAIL PROTECTED]> wrote:
Heh, my bet is that Sun delivers enough to make iBATIS easier towrite, but still manages to overcomplexificate it enough to makepeople still want to use something else.It is cool to see things like DataSet coming from the API,
but unless DataSet extends List, I do not want that anywhere but in myDAO layer, just like I do not want a ResultSet anywhere but in my DAOlayer. If it does, great! That is a huge advancement.While stuff like @Select("SELECT * FROM Employee WHERE status = 'A'")
looks very attractive, and simple crud accounts for probably 35-50% ofthe statements I use, only about 2% of the SQL I write beyond CRUDfits into the 1-liner category.The rest of the SQL statements are those 80-100 line select statements
with dynamic elements...and as much as I like the StringBuilderclass...I still prefer  elements to java code. ;-)So...top question on my list...can/should we use this for iBATIS3? ;-)
LarryOn 8/4/06, Clinton Begin <[EMAIL PROTECTED]> wrote:> Hi all,>> I just picked this up from InfoQ.  What do you think?>>
> => Blogger Patrick Lightbody noted "I could see JDBC 4.0 replacing my need for> iBatis" after reading another blog post on JDBC 4.0 functionality. JDBC 4.0> includes basic O/R mapper functionality that eases the repetitive task of
> copying ResultSet data into objects. It does not handle inheritance or table> relations however.> =>>> 
http://www.infoq.com/news/Easier-Database-Development-JDBC>> Patrick's a good guy and a respected developer.  I appreciate his opinion.> Obviously, this is only useful for people running JDK 5 or possibly only JDK
> 6.  And of course, Annotation support would be an almost brainless effort to> implement for iBATIS.  Your thoughts?>> Clinton>

[OT] ADO.NET vNext CTP Next Week

[Clinton Begin]

Hi All,I had an opportunity to visit Microsoft to have a look at ADO.NET vNext, and more specifically, the Entity Framework.  They have a lot of really great people working on it and the technology is quite advanced.  However, as anyone who knows me would expect, I personally had quite a bit to say about it... ;-)  I'll be happy to share those thoughts once the CTP is out so that you have a chance to formulate your own opinion.
If your interested in the future of ADO.NET development, keep an eye on 
http://msdn.microsoft.com/data next week.  And more importantly, let Microsoft know what you think about it. Their team is really good at listening to their customers, so I encourage you to share your thoughts with them.
ALSO!  Please let _us_  know what you think about it and how it could impact 
iBATIS.NET in the future - both good and bad. Let us know!
Cheers,Clinton








From:   
[mailto:@microsoft.com] 
Sent: August 11, 2006 4:09 PM
To: Clinton Begin
Subject:   ADO.NET vNext CTP is coming soon

 

I wanted to
send a note specifically to the people that we've been working with closely
over the last year on designs for the next version of ADO.NET to let you know
that we're on track to release the first public CTP of ADO.NET vNext early next
week.  I'm including an overview document that will be available with the
CTP build so that you can get an early scoop on what will be in it.  I'd
like to encourage you to share the news with your colleagues and help us get
the word out on your blog once the CTP goes live on http://msdn.microsoft.com/data.

 

Thanks for
your participation and enjoy the CTP next week!

 

-

 

Multiple Result Set Support complete, 2.2.0 will fly within a week

[Clinton Begin]

Hi all,The good news is that I'm on vacation.  The bad news is that I spent the last 6 hours watching the first two extended edition Lord of the Rings movies while implementing the Multiple ResultSet support.
That was the last "required" feature for 2.2.0 to go out, so I'm thinking it should be no more than a week before we see it deployed.  There may be a few more things to go, but certainly not of that size.
Speaking of major features, I think that must be darn near the entire JDBC API we've wrapped with iBATIS, and iBATIS 2.0 is showing its age.  It's been in production for almost 2.5 years, which is great life to get out of any software.   
That said, with 2.2.0 out, I fully expect the next major version to be 3.0.  I recommend 2.0 enter an extended maintenance mode, whereby we only fix bugs and make minor improvements to existing features.  
I don't suggest we attempt to leverage Java 5/6 or JDBC 3/4 features in iBATIS 2.x.Instead, I'm thinking iBATIS 3.0 should cover all of those, with 2.x still supported until JDK 1.4 drops to well below 15% usage (it's currently at around 80%).  
Thoughts welcome.Cheers,Clinton

Last call for 2.2.0

[Clinton Begin]

Let me know if there's anything I should be waiting for for 2.2.0.  Otherwise, I think it's ready to roll.  If I don't hear anything, I'll put a build up on Monday night.Cheers,Clinton

Re: Re: Multiple Result Set Support complete, 2.2.0 will fly within a week

[Clinton Begin]

Not really.  But here's a quick personal take:  * Turn invalid the JDBC 4.0 "Ease of Development API" by kicking the living snot out of it.  * Make laughable the Microsoft DLINQ API.  * Bring to the enterprise the ways of Ruby without ActiveRecord.
  * Remain a good neighbour to Spring, Hibernate and our other friends in the open source community.  Cheers,  ;-)ClintonPS: Note the smiley.On 8/14/06, 
Jerome Gagner <[EMAIL PROTECTED]> wrote:
Is there a road map for 3.0 yet? It'd be cool to see :)On 8/14/06, Gwyn Evans <[EMAIL PROTECTED]> wrote:> On 13/08/06, Clinton Begin <
[EMAIL PROTECTED]> wrote:> >> > The good news is that I'm on vacation.  The bad news is that I spent the> > last 6 hours watching the first two extended edition Lord of the Rings
> > movies while implementing the Multiple ResultSet support.>> As a result, to enable it, just set the attribute "RingBearer" to true> in your sqlmap...>> > That said, with 
2.2.0 out, I fully expect the next major version to be 3.0.>> but, taking a lead from Peter Jackson, versions 3.1 & 3.2 will be> developed in parallel with it...>> :-)>> /Gwyn
> --> Download Wicket 1.2.1 now! - http://wicketframework.org>

Re: Multiple Result Set Support complete, 2.2.0 will fly within a week

[Clinton Begin]

>> don't make any grand pronouncements about 2.2.0 Good call Jeff.  Sorry for sounding extreme.  We'll definitely be supporting 2.2.0 for a long time, including new features that make too much sense to ignore.  
At the end of the day, we'll always do what makes sense.  Our investors don't mind.  ;-)>> we don't have any idea how long it will take to develop [iBATIS 3.0]I do!  According to the latest hype:
  * iBATIS 3.0 will take 4 weeks to write.    * iBATIS.NET 3.0 will take 2 weeks to write.  * RBatis 3.0 will take 3.5 hours.
Cheers,  ;-)ClintonOn 8/14/06, Jeff Butler <[EMAIL PROTECTED]> wrote:
I agree that no new JDK/JDBC features should be put into iBATIS 2.x.  But I'd suggest that we don't make any grand pronouncements about 2.2.0 being the last release except for maintenance.  It's hard to predict what the future holds and we have no idea when iBATIS 
3.0 might be released.  There have been no substantive discussions about iBATIS 3.0 anywhere and we don't have any idea how long it will take to develop such a thing.
 
So I'd just say that we plan to keep iBATIS 2.x using JDK 1.4.  I can't see any value to declaring some kind of extended maintenance mode for iBATIS 2.x - let's wait to do that until iBATIS 3.0 is somewhat close to a real product.

 
Jeff Butler
On 8/13/06, Clinton Begin <[EMAIL PROTECTED]
> wrote:

Hi all,The good news is that I'm on vacation.  The bad news is that I spent the last 6 hours watching the first two extended edition Lord of the Rings movies while implementing the Multiple ResultSet support.
That was the last "required" feature for 2.2.0 to go out, so I'm thinking it should be no more than a week before we see it deployed.  There may be a few more things to go, but certainly not of that size.
Speaking of major features, I think that must be darn near the entire JDBC API we've wrapped with iBATIS, and iBATIS 2.0 is showing its age.  It's been in production for almost 2.5 years, which is great life to get out of any software.   
That said, with 2.2.0 out, I fully expect the next major version to be 3.0.  I recommend 2.0 enter an extended maintenance mode, whereby we only fix bugs and make minor improvements to existing features.  

I don't suggest we attempt to leverage Java 5/6 or JDBC 3/4 features in iBATIS 2.x.Instead, I'm thinking iBATIS 3.0 should cover all of those, with 2.x still supported until JDK 1.4 drops to well below 15% usage (it's currently at around 80%).  
Thoughts welcome.Cheers, 
Clinton

Re: Last call for 2.2.0

[Clinton Begin]

I'm not planning on it.  Is anyone interested in doing this?Cheers,ClintonOn 8/14/06, Paul Benedict <
[EMAIL PROTECTED]> wrote:Will 2.2.0 be available in maven 2 format? And uploaded to ibiblio?
Jeff Butler <[EMAIL PROTECTED]>
 wrote: Good work on multiple result sets!   I'll have a checkin with code changes and tests for IBATIS-331 later this morning, then I'll be finished.  You'll know I'm finished whan I close the JIRA ticket.
   After that, I'm OK for a release with these caveats:   1. Our release process says that we should try to give a 72 hour notice 2. I think you should update the documentation with information about multiple result sets, and Oracle refcursors before the release.
   Jeff Butler  On 8/14/06, Clinton Begin <
[EMAIL PROTECTED]> wrote:  Let me know if there's anything I should be waiting for for 
2.2.0.  Otherwise, I think it's ready to roll.  If I don't hear anything, I'll put a build up on Monday night.Cheers,  Clinton 
 
	
		Do you Yahoo!? Everyone is raving about the 
 all-new Yahoo! Mail Beta.

Re: Last call for 2.2.0

[Clinton Begin]

Sure.  Anyone willing to do it is welcome. I'd suggest having someone who actually uses Maven do it.  They could submit a patch for the build file to create a separate deployable, and they could be responsible for deploying it to ibiblio.  
Paul, are you interested in owning this?  So far you're the only one asking for it.Cheers,ClintonOn 8/14/06, Jeff Butler <
[EMAIL PROTECTED]> wrote:I could very well be wrong, but my understanding is that the versions of iBATIS on ibiblio are not put there by any of the committers.  I don't know how they got there (no one claimed responsibility when this came up recently).  They're not in the place I would expect (
i.e. - I would expect them to be in an ibatis tree, not a com/ibatis tree).
 
So maybe the new version will appear by magic in the com/ibatis tree?  But probably as the others are (without the full POM and without the source defined).
 
Apache does have some infrastructure in place to publish things to Maven so it would probably be a good idea for us to do this.  I'll try to do a little research about it.
 
Jeff Butler 
On 8/14/06, Paul Benedict <
[EMAIL PROTECTED]> wrote:

Will 2.2.0 be available in maven 2 format? And uploaded to ibiblio?
Jeff Butler <[EMAIL PROTECTED]>
 wrote: 

Good work on multiple result sets!
 
I'll have a checkin with code changes and tests for IBATIS-331 later this morning, then I'll be finished.  You'll know I'm finished whan I close the JIRA ticket.
 
After that, I'm OK for a release with these caveats:
 
1. Our release process says that we should try to give a 72 hour notice
2. I think you should update the documentation with information about multiple result sets, and Oracle refcursors before the release.
 
Jeff Butler 
On 8/14/06, Clinton Begin <[EMAIL PROTECTED]
> wrote: 

Let me know if there's anything I should be waiting for for 2.2.0.  Otherwise, I think it's ready to roll.  If I don't hear anything, I'll put a build up on Monday night.Cheers, 
Clinton



Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail Beta.
 

Re: Multiple Result Set Support complete, 2.2.0 will fly within a week

[Clinton Begin]

That's a great idea.  Let's do an infomercial with Chuck Norris too.Cheers,  :-)ClintonOn 8/14/06, Larry Meadors <
[EMAIL PROTECTED]> wrote:..or take a cue from commercial software vendors, and release them all today (available for pre-order, that is).
LarryOn 8/14/06, Jeff Butler
 <[EMAIL PROTECTED]> wrote:

LOL - we should do MDD - then we could just draw a pretty picture and there would be NO development time. :)
 
Jeff 
On 8/14/06, Clinton Begin <[EMAIL PROTECTED]
> wrote:

>> don't make any grand pronouncements about 2.2.0 
Good call Jeff.  Sorry for sounding extreme.  We'll definitely be supporting 2.2.0 for a long time, including new features that make too much sense to ignore.  At the end of the day, we'll always do what makes sense.  Our investors don't mind.  ;-)
>> we don't have any idea how long it will take to develop [iBATIS 3.0]I do!  According to the latest hype:   * iBATIS 3.0 will take 4 weeks to write.    * 


iBATIS.NET 3.0 will take 2 weeks to write.  * RBatis 3.0 will take 3.5 hours.Cheers,  ;-) 
Clinton

On 8/14/06, Jeff Butler <[EMAIL PROTECTED]
> wrote: 


I agree that no new JDK/JDBC features should be put into iBATIS 2.x.  But I'd suggest that we don't make any grand pronouncements about 2.2.0 being the last release except for maintenance.  It's hard to predict what the future holds and we have no idea when iBATIS 
3.0 might be released.  There have been no substantive discussions about iBATIS 3.0 anywhere and we don't have any idea how long it will take to develop such a thing.
 
So I'd just say that we plan to keep iBATIS 2.x using JDK 1.4.  I can't see any value to declaring some kind of extended maintenance mode for iBATIS 2.x - let's wait to do that until iBATIS 3.0 is somewhat close to a real product. 


 
Jeff Butler

On 8/13/06, Clinton Begin <[EMAIL PROTECTED] 
> wrote: 

Hi all,The good news is that I'm on vacation.  The bad news is that I spent the last 6 hours watching the first two extended edition Lord of the Rings movies while implementing the Multiple ResultSet support. 
That was the last "required" feature for 2.2.0 to go out, so I'm thinking it should be no more than a week before we see it deployed.  There may be a few more things to go, but certainly not of that size. 
Speaking of major features, I think that must be darn near the entire JDBC API we've wrapped with iBATIS, and iBATIS 2.0 is showing its age.  It's been in production for almost 2.5 years, which is great life to get out of any software.   
That said, with 2.2.0 out, I fully expect the next major version to be 3.0.  I recommend 2.0 enter an extended maintenance mode, whereby we only fix bugs and make minor improvements to existing features.  


I don't suggest we attempt to leverage Java 5/6 or JDBC 3/4 features in iBATIS 2.x.Instead, I'm thinking iBATIS 3.0 should cover all of those, with 2.x still supported until JDK 1.4 drops to well below 15% usage (it's currently at around 80%).  
Thoughts welcome.Cheers, 
Clinton

[VOTE] iBATIS for Java 2.2.0 promote to General Availability

[Clinton Begin]

PMC Members, You've no doubt seen the 2.2.0 beta release email.  Unless you find any significant problems with the build, please now vote for iBATIS for Java 2.2.0 to be promoted to General Availabilty status.
This vote will close Friday, August 18th.Best regards,Clinton