Re: Connection leak

2005-06-08 Thread Clinton Begin
>>  What happened to returning connection to the pool? You can't compare the logging output between DataSource implementations.  They will be completely different.  So to answer your question:  The return of the connection to the pool wasn't logged by DBCPwhich doesn't mean it wasn't retu

Re: Connection leak

2005-06-07 Thread Clinton Begin
Can you try SIMPLE instead of DBCP, just to confirm that the behaviour is the same? Cheers, ClintonOn 6/7/05, vi am <[EMAIL PROTECTED]> wrote: Here is the full transaction manager configuration:     cacheModelsEnabled="true"enhanceme

Re: [ANNOUNCEMENT] iBATIS graduates to top-level ASF project

2005-06-07 Thread Clinton Begin
Haha.I don't think we alone are worthy of a convention. But now we can crash ApacheCon!  Maybe it could be hosted in Canada in the near future. :-) Maybe in Kananaskis or Banff. Clinton On 6/7/05, Stuart Piltch <[EMAIL PROTECTED]> wrote: Ted Husted gmail.com> writes:>> Recently, the Apach

Re: SqlMapClasspathEntityResolver Using Wrong ID???

2005-06-07 Thread Clinton Begin
e.org, like ibatis.com will eventually be (probably a year from now to give time for everyone to move). Cheers, ClintonOn 6/7/05, Clinton Begin <[EMAIL PROTECTED]> wrote: I only want to maintain one website for ibatis, both to avoid confusion and simplify deployment of the new site.  One prob

Re: SqlMapClasspathEntityResolver Using Wrong ID???

2005-06-07 Thread Clinton Begin
I only want to maintain one website for ibatis, both to avoid confusion and simplify deployment of the new site.  One problem is that nobody will ever have access to the current ibatis.com hosting facilities except me.  Unfortunately I found out (after I made the change) that apache.org doesn't

Re: Using constants in SQL statements

2005-06-07 Thread Clinton Begin
It's not supported at this time.  But feel free to add a JIRA request.  It probably wouldn't be hard. Clinton On 6/7/05, ONeill, Niall <[EMAIL PROTECTED]> wrote: Hi,Is there a way in iBATIS to use static Java fields within SQL statements? Currently I am having to hard-code static values in the st

Re: [ANNOUNCEMENT] iBATIS graduates to top-level ASF project

2005-06-06 Thread Clinton Begin
    Sorry, used a tankard.  ;-)  On 6/6/05, netsql <[EMAIL PROTECTED]> wrote: .VTed Husted wrote:> Recently, the Apache Software Foundation Board of Directors approved > our application to become an official top-level ASF project. This is> great news, and, even better news is that the disruption t

Re: Unexplained exception in GeneralStatement.executeQueryForObject

2005-06-06 Thread Clinton Begin
  java.lang.NoClassDefFoundError is a secondary exception that occurs usually because a static initializer in a class throws an exception causing the loading of the class to fail.  The ClassLoader will usually not try twice in this case.   The other reason is that the class is not on the classpat

Re: [iBatis] Documentation

2005-06-06 Thread Clinton Begin
Ersin,   Feel free to use the wiki to fill in content for the undocumented features, or the examples.  Only if it's easier for you though.  Otherwise, you can download the Open Office documents from our subversion repository.   Cheers, Clinton  On 6/6/05, Ersin Er <[EMAIL PROTECTED]> wrote: > Fina

Re: MORE ON IBATIS.COM DOMAIN UPDATE...YEP, IT BROKE

2005-06-06 Thread Clinton Begin
PS:  As an added bonus, my ibatis.com email is also quite fried.  Use my gmail or apache account to contact me directly. Clinton On 6/6/05, Clinton Begin <[EMAIL PROTECTED]> wrote: Hi everyone, My worst fears have come true, and I managed to screw up the DNS configuration.  Yay.  :

MORE ON IBATIS.COM DOMAIN UPDATE...YEP, IT BROKE

2005-06-06 Thread Clinton Begin
2.0//EN"     "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">     PUBLIC "-//iBATIS.com//DTD DAO Configuration 2.0//EN"     "http://ibatis.apache.org/dtd/dao-2.dtd"> Sorry for the troublesome start to your week. Best regards, Clinton Begin

Re: IBATIS DOMAIN NAME UPDATE - DTD WARNING

2005-06-06 Thread Clinton Begin
PS:  The .NET folks obviously aren't impacted.  Their XML schemas aren't validated against ibatis.com. On 6/6/05, Clinton Begin <[EMAIL PROTECTED]> wrote: Hi everyone, Sorry for the scary subject, I just wanted to make sure everyone wasn't surprised if DTDs stop validating

IBATIS DOMAIN NAME UPDATE - DTD WARNING

2005-06-06 Thread Clinton Begin
the next 24 hours.  To be safe, consider the next 48 hours as the risk period.  Any problems beyond 48 hours will be due to your ISP or internal network configuration. Thanks for your patience in these exciting times of change.  Best regards, Clinton Begin

Re: Calling DAO within TypeHandlerCallback

2005-06-01 Thread Clinton Begin
, even for reads?Niels________From: Clinton Begin [mailto:[EMAIL PROTECTED]]Sent: dinsdag 31 mei 2005 17:46 To: ibatis-user-java@incubator.apache.orgSubject: Re: Calling DAO within TypeHandlerCallbackDAOs never touch result sets. So I wonder what you mean by that? Similarly, iB

Re: TypeHandlerCallback and lazy loading

2005-05-31 Thread Clinton Begin
Lazy loading won't reduce the number of queries, unless you're never accessing the data you're retrieving, in which case I'd ask why you're loading it at all. Consider joining the data and mapping it with groupBy="" and a nested resultMap.  This faq might help http://opensource.atlassian.com/conf

Re: Calling DAO within TypeHandlerCallback

2005-05-31 Thread Clinton Begin
DAOs never touch result sets.  So I wonder what you mean by that?  Similarly, iBATIS only closes result sets once all columns have been iterated through (and hence all TypeHandlers have been executed).  Unfortunately some drivers (like IBM's DB2 driver) like to close resultsets automatically when

[OT] Attention NDD Corporation....

2005-05-30 Thread Clinton Begin
Hello everyone, Sorry for the spam... If you're from NDD Corporation in Japan, and you're an iBATIS user, please email me directly. Cheers, Clinton

Fwd: Support for generics

2005-05-29 Thread Clinton Begin
Sorry, I accidentally replied to Nathan only.-- Forwarded message --From: Clinton Begin <[EMAIL PROTECTED] >Date: May 29, 2005 9:56 AMSubject: Re: Support for genericsTo: Nathan Maves <[EMAIL PROTECTED]> I understand that that is possible.  I'm personally

Re: Support for generics

2005-05-28 Thread Clinton Begin
Or if you have VirtualPC, I suppose you could use TortoiseSVN: http://tortoisesvn.tigris.org/ Clinton On 5/28/05, Clinton Begin <[EMAIL PROTECTED]> wrote: Ohmac boy.  :-)  No tortoise for you.  Here's a couple of clients for you: http://www.lachoseinteractive.net/en/community

Re: Support for generics

2005-05-28 Thread Clinton Begin
eed to build it from the trunk?>>>> Nathan >>>> On May 27, 2005, at 8:32 PM, Clinton Begin wrote:>>>>>>>>  I believe the new Mapper binding functionality would resolve>>> this>>> >>>  Nathan, are you up for trying it out

Re: Support for generics

2005-05-27 Thread Clinton Begin
I believe the new Mapper binding functionality would resolve this Nathan, are you up for trying it out? Cheers, Clinton On 5/27/05, Nathan Maves <[EMAIL PROTECTED]> wrote: Yeah, I have used generics everywhere but the missing link is when itgets to the DAO layer.You can cast the List but you

Re: [HELP] I can't not type < sign in my sqlmap xml file

2005-05-25 Thread Clinton Begin
A while back, we had discussed the possiblility of pluggable scripting engines.   Of course, XML based dyna SQL would always be "enabled", but we could allow for 3rd party parsing of the resulting SQL.  I don't think it would be hard (the biggest problem might be the conflict of certain key charac

Re: Recommended practice / nested ResultMaps

2005-05-24 Thread Clinton Begin
When you say "neither worked properly", what do you mean?  Did you get an exception?  Or did you just get unexpected results? Did you override both equals() and hashCode() for the complex property type?  As per the standard?  Here's a description of how to override them properly: http://www.geoci

Re: Sample Code using javax.sql.DataSource

2005-05-24 Thread Clinton Begin
That code is very incomplete.  It's hard to see what you're trying to do. Why are you accessing the DataSource directly?  How are you even doing that? In any case, why don't you just use the JdbcDaoTemplate and call getConnection().  Then you never have to worry about opening and closing connect

Re: Query performs differently in SQL Query Analyzer [SOLVED]

2005-05-24 Thread Clinton Begin
paramMap has one entry called "sql" which contains the SQL statement.4. Subsequent calls to the above line of code for the same student come back in 1 second.5. We're running 2.0.0 RC5 Build 274. -Original Message-From: Clinton Begin [mailto:[EMAI

Re: transactions

2005-05-24 Thread Clinton Begin
Those update statements ARE in a transaction. But you should NEVER manage transactions inside the DAO.  The transaction in this case is taken care of outside of the scope of this particular method (I believe in this case it is actually an automatic DAO transaction, so you might not find the calls t

Re: [HELP] I can't not type < sign in my sqlmap xml file

2005-05-24 Thread Clinton Begin
I agree with Brandon.  There are definite improvements we need to make to iBATIS dynamic SQL, but that does NOT include building a full templating language.  The power of iBATIS dynamic SQL is the fact that it is VERY specific to SQL.  Using iBATIS dynamic SQL, you can reduce the amount of code to

Re: transactions

2005-05-24 Thread Clinton Begin
As great as that tutorial was for iBATIS 1.x, it holds little value for the 2.0 framework. For one, the new exception handling paradigm is completely different. Please see the Tutorial available at www.ibatis.com and JPetStore 4. Cheers, ClintonOn 5/24/05, Lieven De Keyzer <[EMAIL PROTECTED]> w

Re: [HELP] Ibatis properties with oscache

2005-05-24 Thread Clinton Begin
H...this might require some investigation.  Here's how you can help:  Investigate how OSCache allows properties to be specified programmatically at runtime.  Once that's been figured out, we might be able to provide some mechanism whereby you can pass OSCache properties into the cache model d

Re: database password

2005-05-23 Thread Clinton Begin
You can use ${property} syntax in the SqlMapConfig.xml, and then send it to the SqlMapClientBuilder through a Properties instance as the second parameter. Clinton On 5/23/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi,Database password is quite sensitive information and providing this in pla

Re: Query performs differently in SQL Query Analyzer

2005-05-23 Thread Clinton Begin
>>Each time it encounters a new query? Let's define new query: SELECT * FROM STUDENT WHERE STUDENT_ID = #id# That's one query, regardless of what parameter you use for ?.  In iBATIS, this is represented as: But if you have any dynamic parts to the SQL or any $substitutions$, then you are pote

Re: R: [New Feature] SQL Map Interface Binding -for your review

2005-05-23 Thread Clinton Begin
(and return type) makes the coding extremely fast, when you want to do so.   What about generating the interfaces from the sql map files? At least, generating part of them, when the I/O types are well known.   F Da: Clinton Begin [mailto:[EMAIL PROTECTED]] Inviato: domenica 22 maggio 2005 18.

Re: [New Feature] SQL Map Interface Binding -for your review

2005-05-22 Thread Clinton Begin
Thanks for asking that question. We have to be VERY clear.  These are NOT DAOs!  Nor are they a replacement for DAOs. DAOs are coarse grained classes.  Mappers are more fine grained. You're right, you would have another set of interfaces, and to some people this may be too many.  I agree. In a

[New Feature] SQL Map Interface Binding -for your review

2005-05-22 Thread Clinton Begin
The dev list has already seen this.  I just want to make sure anyone who doesn't subscribe to the dev list gets a chance to provide some feedback... - Although quite simple, there are some tradeoffs with the typical SqlMapClient methods like:     Document doc = (Do

Re: Re: Future releases

2005-05-20 Thread Clinton Begin
asicResultMap.java > >> >  There are 3 prepareXxxParameter methods.  One for Primitives, one for> > DOM and one for Beans.  The only one that doesn't support the {name=col} is> > the primitive one. > >> >  Cheers,> >  Clinton> >> > On 5/19

Re: iBATIS + Websphere 5.1?

2005-05-20 Thread Clinton Begin
Also try EXTERNAL as a transaction manager type instead of JTA.  The the difference is that iBATIS will allow WebSphere fully control the transaction...which is generally better with any IBM product. Cheers, Clinton On 5/20/05, Santamaria Franco, Inaki <[EMAIL PROTECTED]> wrote: Hello all

Re: ResultMap composite key problem - SOLVED

2005-05-19 Thread Clinton Begin
Hmmm..I suppose we could have implemented a better error check therefeel free to put in an "Improvement" in JIRA. ClintonOn 5/19/05, Stuart Piltch <[EMAIL PROTECTED]> wrote: Of course it was something simple.After ripping apart my project until it was just one set of bare bones jarsand classe

Re: ResultMap composite key problem

2005-05-19 Thread Clinton Begin
doesn't support the {name=col} is the primitive one. Cheers, ClintonOn 5/19/05, Stuart Piltch <[EMAIL PROTECTED]> wrote: Clinton Begin gmail.com> writes:> That is terribly strange.  We have a unit test confirming proper parsingIwonder if the space is giving you trouble? >

Re: ResultMap composite key problem

2005-05-18 Thread Clinton Begin
That is terribly strange.  We have a unit test confirming proper parsingI wonder if the space is giving you trouble? Ours looks like this:       column="{orderId=ORD_ID,lineId=ORD_FAVOURITE_LINE}"   select="getSpecificLineItem"/> Try removing the space. ClintonOn 5/18/05, Stuart P

Re: Very Confused : Part 2 :)

2005-05-18 Thread Clinton Begin
Dave, I seriously recommend you learn JUnit before attempting to go any further.  Simple unit tests to verify each layer of your application's functionality will make your life a lot easier and your learning experience a lot more enjoyable. Cheers, Clinton On 5/18/05, Dave Guzda <[EMAIL PROTECT

Re: Article on running iBATIS JPetStore using a Derby database on WebSphere

2005-05-18 Thread Clinton Begin
Cool.  The more help people have for WebSphere the better!  ;-) ClintonOn 5/16/05, Stanley Bradbury <[EMAIL PROTECTED]> wrote: Hi -Some of the readers of this list might be interested in an article justposted about running JPetStore using a Derby database on a WebSphereserver.  The link to the ar

Re: discriminator and submap

2005-05-18 Thread Clinton Begin
Discriminator and subMap are used for inheritance.   I don't think they help you with this situation.  However, you could use the N+1 selects solution.  Check out the FAQ on that subject "How do I avoid the N Plus One selects problem...?" Clinton On 5/18/05, Gregg D Bolinger <[EMAIL PROTECTED]> wr

Re: dtd is messed up

2005-05-18 Thread Clinton Begin
I can't recreate the issue you're having.  It seems to validate fine in my IDE, as well as for all of the unit tests. What is the exact error you have? Clinton On 5/17/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi,The dtd hosted on the web is incomplete.when I try to reference the loca

Re: iBatis DAO - How to turn off data connection pool

2005-05-16 Thread Clinton Begin
What are you trying to achieve by doing that?  You can't really "turn off" pooling with SimpleDataSource, but you could try one of the other implementations or write your own to achieve that.  Cheers, Clinton On 5/16/05, Folashade Adeyosoye <[EMAIL PROTECTED]> wrote: How can I turn

iBATIS for Java 2.1.0 Released

2005-05-16 Thread Clinton Begin
Hi all The subject says it all.  2.1.0 is now available. Change Log: http://sourceforge.net/project/shownotes.php?release_id=327667 Download: http://www.ibatis.com/downloads.html Cheers, Clinton

Re: Custom Type Handler question

2005-05-15 Thread Clinton Begin
e Java version allow the user to name the value something other than #value#? where SeasonYear = #year#--- Clinton Begin <[EMAIL PROTECTED]> wrote:> I'm not really sure what the problem could be. It should work fine. >> Is there no way to just join the data and return a set of repe

Re: query to get records columns as List

2005-05-15 Thread Clinton Begin
You can't map columns to list elements...and that's probably a good thing. It doesn't really make sense semantically. What you can do (which is significantly more useful) is map your results to a Map.  That is, your employee table and its 5 columns will be represented as a Map (column1="whatever"

Re: Custom Type Handler question

2005-05-15 Thread Clinton Begin
I'm not really sure what the problem could be.  It should work fine.  Is there no way to just join the data and return a set of repeating groups and use the iBATIS N+1 Selects solution? http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+around+the+N+Plus+1+selects+proble

Re: cache question... how smart are they

2005-05-15 Thread Clinton Begin
Hi Nathan, To answer your questions: >> Does flush really mean flush?  Yep.  There's no invalidate or "dirty state".  It's either there, or it's not. >> When you have a flush-on-insert setup >> does the caches truly flush all elements in the cache?  Yep. >> If so what is the reason behind

Re: Availability of 2.1.0

2005-05-13 Thread Clinton Begin
ase what can we expect?>> Nathan>> On May 12, 2005, at 9:53 PM, Clinton Begin wrote:>> > Karen,> >> >  A release could be as early as this weekend, but is not guaranteed. > >> >  I'm sure if it's not, that we can at least commit to giving you

Re: issues upgrading from 1.31 to 2.09B

2005-05-13 Thread Clinton Begin
You can ditch the xmlns:fo="http://www.w3.org/1999/XSL/Format"that's just a leftover.  Other than that, I'm not sure what's wrong.  Your DTD looks correct.  Have you tried validating it with a 3rd party XML editor like the free BEA XML editor? Clinton On 5/12/05, Andy Thompson <[EMAIL PR

Re: [OT] JPetStore - BaseBean / BeanAction

2005-05-13 Thread Clinton Begin
m can only have one action specified Ibelieve?So this method would need to have a case where other methods can be called?>From: Clinton Begin < [EMAIL PROTECTED]>>Reply-To: [EMAIL PROTECTED]>To: ibatis-user-java@incubator.apache.org>Subject: Re: [OT] JPetStore - BaseBean / BeanAction >D

Re: [OT] JPetStore - BaseBean / BeanAction

2005-05-12 Thread Clinton Begin
It should be noted that JPetStore also performs multiple "actions" per form.  The difference is that with BeanAction, you must call a different URL for each "action".  (I quote action, as there is obviously only one actual Action class...). Clinton  On 5/12/05, Lieven De Keyzer <[EMAIL PROTECTED]

Re: Availability of 2.1.0

2005-05-12 Thread Clinton Begin
Karen, A release could be as early as this weekend, but is not guaranteed. I'm sure if it's not, that we can at least commit to giving you (and everyone else) a date. Sorry for the lack of clarity here. Cheers, ClintonOn 5/12/05, Karen Koch <[EMAIL PROTECTED]> wrote: Still waiting on any kind

Re: CLARIFICATION - Vote your favourite iBATIS community member onto the "Contributors" list

2005-05-11 Thread Clinton Begin
for their contributions on an ongoing basis.  Open source is driven by excellent communities.  So congrats to everyone who've made it so far.   Sorry for all of the confusion, I hope this clears it up. Cheers Clinton On 5/10/05, Clinton Begin <[EMAIL PROTECTED]> wrote: Hi all, The n

Vote your favourite iBATIS community member onto the "Contributors" list

2005-05-10 Thread Clinton Begin
Hi all, The new website includes a "Contributors" section that recognizes individuals in our iBATIS community that contribute to the project in particularly helpful ways.  This includes providing documentation (sometimes language translations), FAQ entries and other Wiki contributions, answering t

Re: Possible Connection Leak

2005-05-10 Thread Clinton Begin
chnology, e.g.> hibernate, this will have an impact on the services layer as well as the dao > implementation layer.>> -Original Message-> From: Clinton Begin [mailto:[EMAIL PROTECTED]]> Sent: Tuesday, May 10, 2005 1:57 PM > To: ibatis-user-java@incubator.apache.org&g

Re: Possible Connection Leak

2005-05-10 Thread Clinton Begin
s from outside the Dao, wouldn't that defeat the purpose of using a Dao pattern in the first place? -Original Message-From: Clinton Begin [mailto:[EMAIL PROTECTED]] Sent: Monday, May 09, 2005 4:05 PMTo: ibatis-user-java@incubator.apache.orgSubject: Re: Possible Connection L

Re: DAO Exception

2005-05-09 Thread Clinton Begin
You need to dig the real exception out of the Apache logs.  This is a secondary error. Clinton On 5/9/05, Folashade Adeyosoye <[EMAIL PROTECTED]> wrote:     My code still produces these errors from this line in my daoConfig.java, mind you am just trying to get the DAO aspect to wo

Re: Possible Connection Leak

2005-05-09 Thread Clinton Begin
 getSqlMapClientTemplate().insert("insertAccount", account);>>>>}>>>>}>> >>The transaction is started in the EJB level, which calls the DAO, and>>a EJB may call any number of DAO to do the job, in this case,>>do I need to put in the SQLMap.

Re: Possible Connection Leak

2005-05-09 Thread Clinton Begin
volved we are using XA- drivers.   Will the approach you mentioned still work in this scenario? -Original Message-From: Clinton Begin [mailto:[EMAIL PROTECTED]]Sent: Saturday, May 07, 2005 9:30 PMTo: ibatis-user-java@incubator.apache.orgSubject: Re: Possible Connection LeakDo

Re: SQLException when deleting

2005-05-08 Thread Clinton Begin
Oddthe DAO template doesn't throw an exception... public int delete(String id, Object parameterObject) {Maybe you're using an old version of the framework?Cheers,Clinton On 5/8/05, Lieven De Keyzer <[EMAIL PROTECTED]> wrote: This is a snapshot of my AccountSqlMapDao, following the concepts

Re: PL/pgSQL function not working in (more info)

2005-05-07 Thread Clinton Begin
ted.   I am using the same jdbc driver on both occasions.   I did try select('foo') from dual but I got  ERROR: relation "dual" does not exist. I think DUAL is an oracle only psuedo-table.-WolfOn May 7, 2005, at 7:39 PM, Clinton Begin wrote:>>  Try select silly(text) from dual.>>  Cheers,>  Clinton >

Re: PL/pgSQL function not working in

2005-05-07 Thread Clinton Begin
Try select silly(text) from dual. Cheers, Clinton On 5/5/05, Wolf <[EMAIL PROTECTED]> wrote: Hi folks,Thansk for SqlMap, it is making life easier. I am having a problemwithPL/pgSQL functions called from a . I can get around this by notusing the function, but wanted tocall this issue to atten

Re: selectKey & Oracle Database

2005-05-07 Thread Clinton Begin
That should work.  But I don't believe you've stated what the problem actually is.  What is happening?  Is there an exception?  Is the costObjectId always being set to the same value?  Is the sequence being incremented?  Is the call to sqlMapClient.insert() returning the key propertly? What's the

Re: Possible Connection Leak

2005-05-07 Thread Clinton Begin
Do ALL of your SqlMap calls follow this pattern: try {   sqlMap.startTransaction();   //...do work   sqlMap.commitTransaction(); } finally {   sqlMap.endTransaction(); } Clinton On 5/6/05, Rafiq, Adnan <[EMAIL PROTECTED]> wrote: I am using a transaction manager type = JTA in my sql-map-config.xm

Re: iBatis DAO Transaction Batch Default

2005-05-07 Thread Clinton Begin
Here's the cool thingyou can write your own DAO transaction implementation.  I'm assuming you're using SQL Maps.  If so, just copy the SQL Map transaction implementation from the DAO framework into your own package name.  Then, add startBatch() and endBatch() to the constructor and commit meth

Re: iBatis DAO

2005-05-07 Thread Clinton Begin
You only get that if you call .forceCloseAll(). Cheers, ClintonOn 5/4/05, Folashade Adeyosoye <[EMAIL PROTECTED]> wrote: Is this a normal logger/system out  output for iBatis DAODEBUG[2005-May-04 22:47:24] -jdbc.SimpleDataSource(SimpleDataSource.java:506) - SimpleDataSourceforcefully closed/remove

Re: Transaction Manager

2005-05-07 Thread Clinton Begin
You can try both. EXTERNAL, won't do anything with the transaction.  Which in many cases works just fine.  With JTA set, iBATIS will manage the connection as part of the global transaction. Most people find EXTERNAL is the easier of the two to get working. Cheers, ClintonOn 5/6/05, Rafiq, Adnan

Re: BLOB and CLOB FAQ page now restored.

2005-05-07 Thread Clinton Begin
Awesome Nathan.  Thanks so much for fixing that. Clinton On 5/4/05, Nathan Maves <[EMAIL PROTECTED]> wrote: Team,I have restored the FAQ on one way to use the built in BLOB and CLOBCustom Type Handlers (CTH).  I have also added a section near thebottom on the to common problems.- 86 length on the

Re: returned too many results error

2005-05-07 Thread Clinton Begin
...try just running queryForList to see what you get back.  That will help you determine why you're getting multiple rows back. Clinton On 5/7/05, Brian Beaulieu <[EMAIL PROTECTED]> wrote: I can not seem to get around this error:java.sql.SQLException: Error: executeQueryForObject returned too many

Re: DAO and Batch in Single Transaction

2005-05-04 Thread Clinton Begin
Your approach sounds good.  I wouldn't try to overcomplicate this. Cheers, ClintonOn 5/2/05, Gregg D Bolinger <[EMAIL PROTECTED]> wrote: I am using iBatis SqlMap and iBatis DAO. I am trying to look intodoing batch inserts/updates/delete within a single transaction formultiple DAO's.  So should I

Re: Calling all Store Procedure Gurus

2005-05-02 Thread Clinton Begin
I wrote chapter 1 and 2 in a fairly language neutral fashion.  Most of the book will focus on the Java implementation.  But there is an appendix for .NET.  The cool thing is that Gilles did such a good job of keeping consistent, that there are few differences.  I can probably count less than 10

Re: getResultsAsXml

2005-05-02 Thread Clinton Begin
Just set the type to "xml" or "dom" in the result map.  "xml" will return XML as a String, "dom" will return a DOM object. Cheers, Clinton On 5/2/05, Netsql <[EMAIL PROTECTED]> wrote: Vic Cekvenich (netsql) wrote:> There was talk and I think saw away to getResultsAsXml.>> How/where? Url?>> tia,>

Re: invalid column type

2005-04-27 Thread Clinton Begin
You don't NEED null value replacements, just the type.  So this would be fine: insert into PRODUCT (PRD_ID, PRD_DESCRIPTION) values (#id:NUMERIC#,#description:VARCHAR#);   This is an Oracle requirement supported by the standard JDBC intereface.  The method signature for setti

Re: invalid column type

2005-04-27 Thread Clinton Begin
Make sure you've specified the JDBC type of *ALL* nullable columns. Oracle requires the type for nullable columns to be specified. Otherwise when you try to set a null value you'll get that invalid column type error. Cheers, clinton On 4/26/05, Jason Punzalan <[EMAIL PROTECTED]> wrote: > thi

Re: Output parameters with optional result set

2005-04-27 Thread Clinton Begin
age the use of iBATIS at our company. > > Do you think it is likely there is some sort of way I can override a class > to create a new type of call or something that can get us able to address > this? I have not looked at any source code, and was wondering if it is > worth trying

Re: setUserConnection() does not reset the connection used in SQLMAP

2005-04-26 Thread Clinton Begin
This combination of Tyrex and the Oracle XA driver leave you in a situation where non-standard interfaces are required to make this work. My recommendation to you would be to write your own custom DataSourceFactory implementation. It is a very simple interface. This way you can call the propriet

Re: Output parameters with optional result set

2005-04-26 Thread Clinton Begin
Can you wrap the wacky stored proc with a more predictable one that returns an empty result set every time, so as to avoid the exception? cheers, Clinton On 4/26/05, David Whipple <[EMAIL PROTECTED]> wrote: > We have a situation that might address a situation that is not handled by > iBATIS, but

Re: CacheModel Cache Removal

2005-04-26 Thread Clinton Begin
The big question here is...how do you intend to identify that object? Cheers, Clinton On 4/26/05, Mike Zupper <[EMAIL PROTECTED]> wrote: > I am using Spring Framework 1.1.5, SQLMaps 2.0 with OSCACHE 2.1. > > Currently, the "FlushOnExecute" XML element of the SQLMaps configuration > file determi

Re: Populating 2 lists within a class

2005-04-24 Thread Clinton Begin
> specific with MS Access and the JdbcOdbc driver? > > I've experimented and can populate this by doing the n+1 workaround solution. > But I would still prefer to use the select > method in some circumstances. Thanks! > > Re: Populating 2 lists within a class >

Re: ANSI_PADDING

2005-04-24 Thread Clinton Begin
How do you turn it off without iBATIS? Clinton On 4/24/05, Bitra, Venkateswararao (Corporate, consultant) <[EMAIL PROTECTED]> wrote: > Hi, > I user IBATIS layer for my Pervasive SQL database. Pervasive SQL 9 > came up with an option to deal with ANSI_PADDING problem with datatype CHAR >

Re: sql-map file

2005-04-23 Thread Clinton Begin
They're where they always are... http://www.ibatis.com/dtd/sql-map.dtd http://www.ibatis.com/dtd/sql-map-config.dtd Cheers, Clinton On 4/23/05, Sergey Livanov <[EMAIL PROTECTED]> wrote: > > Clinton, > Could you, please, send me 1.2.8 version sql-map.dtd file ? > > -- > regards, > Sergey

Re: SQLMap and OSCACHE unwanted behavior with hierarchy of objects.

2005-04-22 Thread Clinton Begin
Do I understand correctly The first row is the category, the next 20 rows are sub-categories? In other words, a parent child relationship described as peers in the result set? Correct? Clinton On 4/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi there! > > Today I introdu

Re: RES: Mapping of one object to several tables?

2005-04-22 Thread Clinton Begin
Ummmno. There's no way to insert into multiple tables using a single statement, unless you have DBMS that supports it. The only way I've seen this implemented in RDBMS is with a view that has insert rules applied to it (already very simple designs, that don't benefit much from the additional

Re: about the metadata in sqlmap

2005-04-19 Thread Clinton Begin
You can't. But then again, that's part of the point.  Why would you get RSMD when you could have a real typed java object? ClintonOn 4/19/05, 任增刚 <[EMAIL PROTECTED]> wrote: Hi! every body:   How can i get the metadata for query result.redards!--任增刚[EMAIL PROTECTED][EMAIL PROTECTED]

Re: composite keys and procedures

2005-04-18 Thread Clinton Begin
e procedures but say using tag and .   Jason. -Original Message-----From: Clinton Begin [mailto:[EMAIL PROTECTED]]Sent: Sunday, April 17, 2005 3:01 AMTo: ibatis-user-java@incubator.apache.orgSubject: Re: composite keys and proceduresIt doesn't look like you're even mak

Re: composite keys and procedures

2005-04-17 Thread Clinton Begin
It doesn't look like you're even making use of a composite key (at least not a composite key that gets passed to your proc). The following only sends a single column to the loadCategories proc. select="loadCategories"/> So...I suppose this should work fine.  As for the Oracle ref cursor stuff,

Re: Avoiding N+1 Selects (1:M and M:N)

2005-04-15 Thread Clinton Begin
I've fixed the FAQ on the new Wiki... http://opensource.atlassian.com/confluence/oss/display/IBATIS/Home It includes the information brandon was referring to. Cheers, ClintonOn 4/15/05, Brandon Goodin <[EMAIL PROTECTED]> wrote: we now have a groupBy functionality that will help with N+1. It is n

Re: Please Help in arguing for iBatis SqlMaps

2005-04-07 Thread Clinton Begin
Hi Kaushik, I was going to respond with a technical rebuttal, until I read:  "my business acumen says that IBM will definitely take care of that". (apparently from your supervisor or something) Let me instead tell you how IBM made $96 Billion dollars in 2004.  Or you can read it yourself at:  htt

Re: Passing an XML document as a parameter to SqlMapClient methods

2005-04-07 Thread Clinton Begin
There are unit tests for this feature...both DOM and String based XML PS:   Sorry the tests are kind of messy at this point...but they're there. Cheers, ClintonOn Apr 7, 2005 11:19 AM, Mark Nabours <[EMAIL PROTECTED]> wrote:I understand that passing an XML document (W3C, JDOM, ??) as a parameter

Re: bad perfomance ibatis between native JDBC and PLSQL

2005-04-06 Thread Clinton Begin
Where is the Java code for the iBATIS calls?  It is critical that you show us the complete Java source for what you're doing.  This includes JDBC connection management, iBATIS transaction management and the timing demarcation and mechanism. Basically post 2 files:  JdbcTest.java and Ibatis.java

Re: bad perfomance ibatis between native JDBC and PLSQL

2005-04-06 Thread Clinton Begin
Here we go again... How are you testing this?  Please don't post performance testing results WITHOUT THE SOURCE.  Once you post the source, we can begin to help you. Cheers, Clinton On Apr 6, 2005 12:19 PM, rodrigo castillo <[EMAIL PROTECTED]> wrote:I tested the perfomance between ibatis, jdbc

Re: iBATIS DAO question

2005-03-31 Thread Clinton Begin
Sure, why not. If that's what you need to do, go for it. I don't see any harm other than the loss of transparency (which in this case is a requirement, not a flaw). Cheers, Clinton On Mar 31, 2005 10:29 AM, Karen Koch <[EMAIL PROTECTED]> wrote: > Up until now, I have been keeping my dao.xml fil

Re: Wiki FAQ still broken! (Was Re: Customer Type Handler)

2005-03-31 Thread Clinton Begin
We're in the process of moving the wiki to confluencewe've pretty much had it with MoinMoin. Clinton On Thu, 31 Mar 2005 09:10:43 -0700, Brandon Goodin <[EMAIL PROTECTED]> wrote: > We put in a request and have been following it up. But, no go. I know > the Apache infrastucture guys are strai

Looking for Calgary based iBATIS talent

2005-03-28 Thread Clinton Begin
Hi everyone, Please email me directly if you're in Calgary and are an experienced iBATIS user. Cheers, Clinton

Re: Problem with Excel+iBATIS

2005-03-28 Thread Clinton Begin
Unfortunately the JDBC/ODBC bridge driver fails to support a great many JDBC 2.0 features. It is also buggy and has some weird usage semantics. We would have to make too many sacrifices to support excel, which is pretty rare, so we don't. Clinton On Sun, 27 Mar 2005 10:52:39 -0500, Sancho Chia

Re: Ordering guaranteed in queryForList results?

2005-03-25 Thread Clinton Begin
Yes, the order is preserved. Clinton On Fri, 25 Mar 2005 13:56:02 -0800 (PST), Karen Koch <[EMAIL PROTECTED]> wrote: > I'm curious as to whether I can count on the immediate results of a call to > queryForList always preserving the order specified in the ORDER BY clause of a > SQL statement... ?

Re: Integer to Boolean conversion is opposite from expected behavior

2005-03-25 Thread Clinton Begin
You should use a custom type handler for conversion from text to boolean. We'll be including a standard one in a future release. Clinton On Fri, 25 Mar 2005 10:20:46 -0500, Mike Zatko <[EMAIL PROTECTED]> wrote: > I have a db table that has a field that has a SMALLINT datatype. This > field is b

Re: Struggling with insertion of Clob into the database. PS:

2005-03-25 Thread Clinton Begin
PS: We've applied for a confluence OSS license. Clinton On Fri, 25 Mar 2005 08:10:02 -0700, Clinton Begin <[EMAIL PROTECTED]> wrote: > Yes. Absolutely. > > I've never been a fan of MoinMoin. It's crap. > > Confluence is big, slow and ove

  1   2   3   4   >