Re: Select from View (as opposed to table) using iBatis

2010-06-09 Thread Jeff Butler
Please join us at the new project site: www.mybatis.org Select from view is support. The error message is "Undefined Name". DB2 cannot find the view called MY_SCHEMA.V_MY_VIEW. Jeff Butler On Wed, Jun 9, 2010 at 4:11 PM, mule_user wrote: > > I am using iBatis (2.5) with DB2

Re: Need support for Dynamic procedure invocation

2010-05-25 Thread Jeff Butler
eally need to be this dynamic (do they REALLY need to be this dynamic?) And writing a spring object factory for mybatis isn't that hard to do. Jeff Butler On Tue, May 25, 2010 at 10:04 AM, Joe Gooch wrote: > Sure, but it'll be uglier. > > To me, your whole approach/rationale

Re: Need support for Dynamic procedure invocation

2010-05-25 Thread Jeff Butler
This would be a great time to switch to mybatis and usa a @SelectProvider to write the query exactly as you need it. I think that the dynamic SQL tags won't work in this case. Jeff Butler On 5/25/10, Nicky Jha wrote: > Hi > > Is there a way I can modify {call $procedureName$

Re: iBATIS 3 @InsertProvider (and other @*Provider) annotation question

2010-05-21 Thread Jeff Butler
Yes - that works. iBATIS is using OGNL to interpret the parameters, so any valid OGNL expression works. Jeff Butler On Fri, May 21, 2010 at 10:04 AM, Alex Sherwin wrote: > On 5/21/2010 10:23 AM, Alex Sherwin wrote: >> >> I just want to make sure, but there is there simply

Re: iBATIS 3 @InsertProvider (and other @*Provider) annotation question

2010-05-21 Thread Jeff Butler
join us at the new project - www.mybatis.org New mailing list: http://groups.google.com/group/mybatis-user Jeff Butler On Fri, May 21, 2010 at 9:23 AM, Alex Sherwin wrote: > I just want to make sure, but there is there simply no way to pass arguments > to the sql provider method defined in

Re: ibator download

2010-05-20 Thread Jeff Butler
ret it. Search/replace - tedious but effective. Jeff Butler On Wed, May 19, 2010 at 4:30 PM, Roy Bailey wrote: > Thanks Jeff, > > I've been able to follow the instructions and generate Ibatis 3 mappers from > Ibator 1.2.2 build.  Great job. > > I've also been looki

Re: contextGenerateAdditionalXmlFiles to create single file

2010-05-18 Thread Jeff Butler
Take a look at the source for SqlMapConfigPlugin - it does something very similar to what you are trying to accomplish. Jeff Butler On Mon, May 17, 2010 at 4:08 AM, Amar X Hussain wrote: > Hi guys, > > > > I have an Ibator plugin that creates a spring config file per table, it &

Re: Need support for Dynamic procedure invocation

2010-05-14 Thread Jeff Butler
Yes - this the best approach. Jeff Butler On 5/14/10, Joe Gooch wrote: > I suggest going with a dynamic SQL approach in the mapped statement. > > public class DynamicProcedureParams { > private String procedureName; > private List params = new ArrayList(); > > // get

Re: Need support for Dynamic procedure invocation

2010-05-14 Thread Jeff Butler
This won't work (as you've discovered). iBATIS 2.x does not reparse the string for variables after string substitution. You'll need to do this with the dynamic tags, or you'll need to compose the entire string (including parameter values - like {call myproc('fred')

Re: Way to use sql in mapper interface, without having to create a corresponding xml mapping file?

2010-05-13 Thread Jeff Butler
It took me a while to figure it out also! Create your SqlSessionFactory as normal, then add the interfaces manually: sqlSessionFactory.getConfiguration().addMapper(SomeMapperInterface.class); Jeff Butler On Wed, May 12, 2010 at 4:16 PM, Rick R wrote: > Larry showed me his cool no

Re: New to Ibatis / Ibator / Eclipse

2010-05-12 Thread Jeff Butler
Dude - please stop sending the same email over and over again! Read the iBATIS documentation, do a google search for "ibatis tutorial", etc. Jeff Butler On Wed, May 12, 2010 at 10:36 AM, SMe Software - Rocky Castaneda wrote: > > Hi Clinton, > I have a table named

Re: ibator download

2010-05-10 Thread Jeff Butler
han I seem to have. It's very easy to build yourself with Maven. I wrote some directions here: http://svn.apache.org/repos/asf/ibatis/java/ibator/trunk/core/ibator-core/doc/html/reference/building.html Jeff Butler On Mon, May 10, 2010 at 4:31 PM, Roy Bailey wrote: > Any idea when a versi

Re: Converting ibator generated clause in iBATIS 2 to iBATIS 3.0

2010-05-07 Thread Jeff Butler
me thinking about an ibatis2->ibatis3 XML conversion tool - but it's a very difficult thing to do because the dynamic SQL elements are very different. There's no easy answer for that. Jeff Butler On Thu, May 6, 2010 at 11:56 PM, Don's Email wrote: > I used ibator 1.2 to crea

Re: Strange problem with resultMaps

2010-05-06 Thread Jeff Butler
assumes it is complete. Jeff Butler On Thu, May 6, 2010 at 5:27 AM, Metsovuori Juho wrote: > Hey all, > > I have a this strange problem with resultMaps. When I use the query below to > retrieve a users information, everything works great. > >    public class User > >  

Re: Help with iBatis nested syntax

2010-05-05 Thread Jeff Butler
OK. Nested iterates work in iBATIS 2.2.0 or later. "ReportParameters" is not really a proper Java property name - you might try "reportParameters". Maybe thats the problem? Jeff Butler On Wed, May 5, 2010 at 10:58 AM, devver wrote: > > Hi > > It&

Re: Does anyone have any example of "foreach" with annotation

2010-05-05 Thread Jeff Butler
IIRC, iBATIS doesn't support dynamic SQL in annotations. You'll need to use an @UpdateProvider and generate the dynamic SQL yourself. Jeff On Wed, May 5, 2010 at 2:18 AM, shamim wrote: > > Hi All, >  i have stuck with dynamic Sql on Ibatis 3 annotations. Trying to pass List > in dynamic sql as

Re: date in where clause does not work.

2010-05-05 Thread Jeff Butler
these types of situations, it's best to turn on logging to see the actual SQL being sent - that usually leads to an Aha moment. Jeff Butler On Wed, May 5, 2010 at 3:50 AM, Jeremy Jardin wrote: > > Today, I'm having other kind of pb... > My select request return too much

Re: Help with iBatis nested syntax

2010-05-05 Thread Jeff Butler
a property of your parameter object - and I'm guessing that "ReportParameters" IS your parameter object. So, remove "ReportParameters" and things will likely improve. Jeff Butler On Wed, May 5, 2010 at 8:42 AM, devver wrote: > > Thanks for your reply Jeff > >

Re: Help with iBatis nested syntax

2010-05-04 Thread Jeff Butler
Assuming MyParameters is some object passed as a parameter object, and that myOuterList is a property of MyParameters: #myOuterList[].myInnerList[].myProperty# Jeff Butler On Tue, May 4, 2010 at 2:09 PM, devver wrote: > > Hi > > #Subsequent to the problems outline

SelectBuilder

2010-04-28 Thread Jeff Butler
I've been playing with SelectBuilder. I like it, and I just added support for the DISTINCT keyword. Just wondering... Clinton - did you consider doing DeleteBuilder, InsertBuilder, UpdateBuilder? I'd be happy to work on them if you are open to it. J

Re: iBATIS 3 Live

2010-04-22 Thread Jeff Butler
Not me. Jeff Butler On 4/22/10, Clinton Begin wrote: > Do either of you use ManagedTransaction? > > Clinton > > On Thu, Apr 22, 2010 at 12:38 PM, Guy Rouillier > wrote: > >> We've had our production customer portal running with iBATIS beta 7 for 3 >> month

iBATIS 3 Live

2010-04-22 Thread Jeff Butler
es - which saved us a huge amount of startup time. So in my humble opinion, iBATIS 3 is good to go! Jeff Butler - To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org

Re: IBator mapper calls all getters, not just the ones it needs

2010-04-20 Thread Jeff Butler
Its a bug in ibatis - not ibator. It was fixed a couple of days ago. Recompile ibatis and you'll be good to go. Jeff Butler On 4/20/10, Morearty, Brian wrote: > Hi, > > > > I'm using iBATIS 3 with a IBator 1.2.2. > > > > I used IBator to generate my mode

Re: iBator HierarchicalJava5Test fails on test testPKFieldsBlobsUpdateByPrimaryKeyWithBLOBs

2010-04-20 Thread Jeff Butler
I ran the tests just this morning and didn't have any failures. Perhaps a bit more detail? Jeff Butler On Tue, Apr 20, 2010 at 3:26 PM, Elmer Smith wrote: > I am trying to build the latest version of iBator.  I re-sync with SVN and > run “mvn clean install” but I get 1 fail

Re: Transaction management in iBATIS 3 inside an EJB (3.1) container

2010-04-18 Thread Jeff Butler
orial/doc/bncjj.html It seems to imply that we still have to call close to return the connection to the pool. Jeff Butler On Sun, Apr 18, 2010 at 4:45 PM, Clinton Begin wrote: > You did the right thing... iBATIS transaction managers are meant to be easy > to implement yourself. > >

Re: Handling stale data on End User

2010-04-14 Thread Jeff Butler
yourself - and design your tables properly. Or - you can just let user B overwrite user A's changes. In reality, this is probably the most common pattern :) Jeff Butler On Wed, Apr 14, 2010 at 10:24 AM, Vinaya Tirikkovalluru wrote: > Hi, > > I have a situation below.. > >

Re: Locks

2010-04-14 Thread Jeff Butler
iBATIS always starts a transaction. If you want to avoid transactions completely, you will need to implement your own version of a transaction manager - you can base it on the EXTERNAL transaction manager. Jeff Butler On Wed, Apr 14, 2010 at 11:43 AM, Ejaz X Mohammed wrote: > I changed

Re: Locks

2010-04-14 Thread Jeff Butler
(like JNDI), then you'll need to look to that datasource for information about changing the isolation level. Jeff Butler On Wed, Apr 14, 2010 at 9:51 AM, Ejaz X Mohammed wrote: > These are my settings ... > >     >                cacheModelsEnabled="true" >

Re: DefaultSqlSession.selectOne()

2010-04-14 Thread Jeff Butler
http://opensource.atlassian.com/confluence/oss/display/IBATIS/Contribute+Documentation Jeff Butler On Wed, Apr 14, 2010 at 10:15 AM, cowwoc wrote: > >    I don't mind using the workaround you outlined so long as it's mentioned > in the iBatis 3 documentation. Right now

Re: Locks

2010-04-14 Thread Jeff Butler
It's dependent on the transaction isolation level set on your connection. There are many variables involved - what is your environment (POOLED, UNPOOLED, JNDI, etc.)? Jeff Butler On Wed, Apr 14, 2010 at 9:38 AM, Ejaz X Mohammed wrote: > Hello, > > > > I have an applicati

Re: Ibatis 3 - special method in model class which Ibatis can't use

2010-04-13 Thread Jeff Butler
Fixed. https://issues.apache.org/jira/browse/IBATIS-777 Jeff Butler On Tue, Apr 13, 2010 at 4:04 PM, Jeff Butler wrote: > I've got a fix for this - I'll commit shortly. > > Jeff Butler > > > On Tue, Apr 13, 2010 at 3:34 PM, Jeff Butler wrote: >> I just

Re: Ibatis 3 - special method in model class which Ibatis can't use

2010-04-13 Thread Jeff Butler
I've got a fix for this - I'll commit shortly. Jeff Butler On Tue, Apr 13, 2010 at 3:34 PM, Jeff Butler wrote: > I just confirmed this to be true.  It has nothing to do with Ibator. > > Clinton - the constructor for DynamicContext calls every "getter" in > th

Re: Ibatis 3 - special method in model class which Ibatis can't use

2010-04-13 Thread Jeff Butler
I just confirmed this to be true. It has nothing to do with Ibator. Clinton - the constructor for DynamicContext calls every "getter" in the parameter object regardless of whether it is used in the query or not.I suppose we should take a look at changing this somehow. Jeff Butle

Re: ibator with rootclass overrides getters and setters

2010-04-09 Thread Jeff Butler
management in that case is far less than optimal. This might finally prompt me to make a change in this area. Jeff Butler On Fri, Apr 9, 2010 at 4:09 AM, Jeremy Jardin wrote: > > Ok, it works now. > > When I run the ant script (task ibator.generate) I've got no warnings, bu

Re: ibator with rootclass overrides getters and setters

2010-04-08 Thread Jeff Butler
It shouldn't make any difference - just using Java introspection to look for getter/setter methods. Jeff Butler On 4/8/10, Jeremy Jardin wrote: > > Ho, I thought about something.. is the order of the attributs in the > rootClass important ? > And what about comments ? > >

Re: ibator with rootclass overrides getters and setters

2010-04-08 Thread Jeff Butler
It is a mystery :). There are unit tests in the Ibator build that test this functionality and they are passing. If you're up for an experiment, try it with a build of Ibator from source - maybe something is wrong in the version you are using. Jeff Butler On 4/8/10, Jeremy Jardin wrote: &

Re: ibator with rootclass overrides getters and setters

2010-04-08 Thread Jeff Butler
OK. Then I need to see some detail. What are the methods in the base class, and what is Ibator generating? Jeff Butler On Thu, Apr 8, 2010 at 9:20 AM, Jeremy Jardin wrote: > > Yes, I had that message the first time I ran the ant script. > > Then, I tried something with the classP

Re: ibator with rootclass overrides getters and setters

2010-04-08 Thread Jeff Butler
e compiled DecObject class is in Ibator's classpath, or add a configuration element specifying where the compiled class is. Jeff Butler On Thu, Apr 8, 2010 at 7:21 AM, Jeremy Jardin wrote: > > Hi, > > I'd like Ibator to generate ibatis bean extending a specific rootClass. >

Re: Cannot resolve classpath entry

2010-04-05 Thread Jeff Butler
http://ibatis.apache.org/docs/tools/ibator/configreference/classPathEntry.html Jeff Butler On Mon, Apr 5, 2010 at 7:55 AM, magistermagica wrote: > > Hi. > > I am testing Ibator in Eclipse and have come across the following problem: > > When I Right Click on the xml and instru

Re: Configuring Ibator's classpath for different machines (Eclipse)

2010-03-31 Thread Jeff Butler
I think you misunderstood me. There is an Ant task built into Eclipse for Ibator. It includes the "don't clobber on regenerate" capabilities. This is different than the regular ant task in the base Ibator distribution. Check it out! It does exactly what you need. Jeff Butler

Re: Configuring Ibator's classpath for different machines (Eclipse)

2010-03-31 Thread Jeff Butler
shows how to use the built in "ibator.generate" task. Jeff Butler On Wed, Mar 31, 2010 at 3:27 PM, Morearty, Brian wrote: > My team is using Ibator 1.2.2 in Eclipse. We happen to have our Oracle > installations in different directories. It looks like the > element in Ibator co

Re: newbie Q: get back generated key with Oracle

2010-03-26 Thread Jeff Butler
> Brian > > > -Original Message- > From: Jeff Butler [mailto:jeffgbut...@gmail.com] > Sent: Friday, March 26, 2010 1:01 PM > To: user-java@ibatis.apache.org > Subject: Re: newbie Q: get back generated key with Oracle > > This is an Ibator issue and it's an inte

Re: newbie Q: get back generated key with Oracle

2010-03-26 Thread Jeff Butler
This is an Ibator issue and it's an interesting case that I had not considered previously. I'll fix it. Jeff Butler On Wed, Mar 24, 2010 at 5:33 PM, Morearty, Brian wrote: > Related to this discussion earlier today, I have a feature request.  I'm not > sure if this s

Re: Eclipse error when running Ibator

2010-03-26 Thread Jeff Butler
t the Java code formatting options on the failing machine - what's different there? Jeff Butler On Thu, Mar 25, 2010 at 7:41 PM, Morearty, Brian wrote: > Hi, > > > > My team has 3 developers. One of us is having the following problem. The > other two of us are not. Does anyo

Re: mapping insert of object graph

2010-03-18 Thread Jeff Butler
Basically it's manual because SQL doesn't have a concept like join on insert. So you usually write a dao or service method like this: insertMasterRecord(); for each detail record { insertDetailRecord(); } commit(); Jeff Butler On Thu, Mar 18, 2010 at 8:05 AM, Jon Finanger wrote:

Re: Ibator 1.2.2 Eclipse jars not published

2010-03-12 Thread Jeff Butler
ple who are using iBATIS 3. > > One thing that's not quite clear to me: it generates some Mapper interfaces > but no implementations.  Is that a bug or by design or am I doing something > wrong? > > Brian > > > > -Original Message- > From: Jeff Butler [m

Re: Ibator 1.2.2 Eclipse jars not published

2010-03-12 Thread Jeff Butler
I'm glad you got it working. I'm working on making the documentation for this better! Jeff Butler On Fri, Mar 12, 2010 at 8:57 PM, Morearty, Brian wrote: > I got it working. > > In case anyone else has this problem: I didn't know I had to update the > build.

Re: Ibator 1.2.2 Eclipse jars not published

2010-03-12 Thread Jeff Butler
Run the build.xml file in the build project. Jeff Butler On 3/12/10, Morearty, Brian wrote: > Hmm, I must have done something wrong. As instructed on the build page I > loaded the projects into Eclipse and waited for the build to complete. But > I don't have a \Temp\ibator.bui

Re: Ibator 1.2.2 Eclipse jars not published

2010-03-12 Thread Jeff Butler
fternoon. Jeff Butler On Fri, Mar 12, 2010 at 1:03 PM, Jeff Butler wrote: > The SVN repo has moved - glad you found the new one!  The "how to > build" pages in SVN should be current - it sounds like you found the > page for building the Eclipse feature. > > Ibator for Eclips

Re: Ibator 1.2.2 Eclipse jars not published

2010-03-12 Thread Jeff Butler
rk anymore. When you run the PDE build, the resulting file is placed on your hard drive in the \Temp\ibator.build\I.TestBuild directory. You can unzip that file directly into an eclipse install and it should work fine. Jeff Butler On Fri, Mar 12, 2010 at 12:24 PM, Morearty, Brian wrote: >

Re: Ibator for ibatis 3

2010-02-21 Thread Jeff Butler
> Eclipse, manually delete the JAR files, restart Eclipse and reinstall the > feature. > > > On 2/19/2010 6:47 PM, Guy Rouillier wrote: >> >> I'll try a fresh checkout.  The link below is failing for me: >> >> The requested URL >> >> /repos/asf/

Re: Ibator for ibatis 3

2010-02-19 Thread Jeff Butler
/buildingFromSVN.html Jeff Butler On Fri, Feb 19, 2010 at 12:31 PM, Guy Rouillier wrote: > Unfortunately, that's not it.  I had found that manifest and updated it to > reflect 3.0.0.  I'll try working more on this tonight.  I'll search my > Eclipse installation and just re

Re: Ibator for ibatis 3

2010-02-19 Thread Jeff Butler
d) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.eclipse.equinox.launcher.Main.invokeF

Re: If all my sql is in xml, do I gain that much (assuming unit tests) using Mapper objects as well?

2010-02-17 Thread Jeff Butler
w HashMap(); parms.put("id1", id1); parms.put("id2", id2); return sqlSession.selectList("foo.Bar.getById", parms); } YMMV. Jeff Butler On Wed, Feb 17, 2010 at 2:36 PM, Rick R wrote: > On Wed, Feb 17, 2010 at 2:51 PM, Jeff Butler wrote: >> >> Usi

Re: If all my sql is in xml, do I gain that much (assuming unit tests) using Mapper objects as well?

2010-02-17 Thread Jeff Butler
mapper interface might break the code. The mapper is doing the same thing under the covers as what you describe - so there's no other magic. In my current project I'm using the mapper interface because I like to write less code, and Ibator generated most of the mapper methods anyway. J

Re: Ibator for ibatis 3

2010-02-17 Thread Jeff Butler
a few new features to Ibator to make my own coding life easier. I can say that I'm using Ibator and iBATIS3 nearly every day for real work and have run into very few troubles. When will there be a new release? I always say "soon, hopefully". Jeff Butler On Wed, Feb 17, 2010 at 12:45

Re: table name as parameter

2010-02-08 Thread Jeff Butler
Well, I wasn't quite right in what I said. RowBounds is the exception to the rule - so if you pass more than one parameter in addition to RowBounds, then you must use the @Param annotation. In your case, you don't need to annotate and "value" is the right default. Jeff Bu

Re: table name as parameter

2010-02-08 Thread Jeff Butler
rs about NULL values. Jeff Butler On Mon, Feb 8, 2010 at 4:57 PM, Tom Carchrae wrote: > > > > nmaves wrote: >> >> I would double check that you are not sending in null as the table name. >> > > I am passing in a non-null string.  But it is definitely a probl

Re: iBatis 3.x common sql fragments?

2010-02-08 Thread Jeff Butler
Yes - everything's in xml for me. Jeff Butler On 2/8/10, Alex Sherwin wrote: > Are you registering your mappers all in the configuration XML? I tried > to programatically register my common SqlMap file first, and I'm still > having the same problem. I'm wonderi

Re: iBatis 3.x common sql fragments?

2010-02-08 Thread Jeff Butler
I'm doing this (across different xml files). I believe ibatis is still load order dependant - so your fragments file needs to be loaded in the configuration before the file that uses the fragments. Jeff Butler On 2/8/10, Alex Sherwin wrote: > Martin Ellis wrote: >> On 8 Febru

Re: ibator build from source 1.2.1 running error

2010-01-27 Thread Jeff Butler
have everything you need. Jeff Butler On Wed, Jan 27, 2010 at 2:23 AM, kevin zhao wrote: > Hi there, > > I'm trying to build ibator from source that I downloaded form this address > http://people.apache.org/builds/ibatis/ibator/ibator-1.2.1-681.zip. > > The tool I'm buil

Re: Strange data/number clobbered problem

2010-01-26 Thread Jeff Butler
BATIS did not handle this properly. Jeff Butler On Tue, Jan 26, 2010 at 6:32 PM, Wu, Daniel wrote: > Hi, > > > > We recently encountered some issues which potentially related to iBitis. > > We searched the web and the mailing list archive but did not find > anything us

Re: insert going wrong after going from Sybase to MySQL

2010-01-23 Thread Jeff Butler
Use the is a holdover from iBATIS 1.x I believe. Jeff Butler On Sat, Jan 23, 2010 at 4:20 PM, StevenF wrote: > > Hi Guys, > > Still no luck here. > > I have this, but doesn't work: > >     parameterClass="nl.chessone40.dom

Re: Re-2: Logging in iBatis 3

2010-01-12 Thread Jeff Butler
else. Jeff Butler On 1/12/10, [e2n] software | Björn Raupach wrote: > try { > // insert, update or delete > session.commit(); > } catch (IbatisException e) { > log.warn(e.getMessage()); > } finally { > session.close(); > } > > Now I catch a unchecked exc

Re: ibator couldnt find jdbc driver

2010-01-12 Thread Jeff Butler
Sorry - you need the entry in your ibatorconfig file - not the .classpath file. Eclipse plugins have a different classpath than the eclipse project classpath. Jeff Butler On 1/12/10, olamalam wrote: > > I have it: > > > >path="org.eclipse.jdt.

Re: ibator couldnt find jdbc driver

2010-01-12 Thread Jeff Butler
You need to add a element to add the JAR to the classpath. Jeff Butler On Tue, Jan 12, 2010 at 9:13 AM, olamalam wrote: > > Hi to all, > > I have a problem with the eclipse plugin of ibatis. > I've generated a ibatorConfiguration xml file and filled its fields: >

Re: Ibator generate incomplete bean

2009-12-30 Thread Jeff Butler
Try this: Jeff Butler On Wed, Dec 30, 2009 at 7:20 AM, ines DNSCE wrote: > > The reason is that the reading of the given méta data has the right DBA. > Thus I reads méta data of another plan (schéma) than I waited. > If I specify the plan for every table, I have no more the

Re: Ibator generate incomplete bean

2009-12-29 Thread Jeff Butler
Usually Ibator will ignore a column only if it encounters an unsupported data type. Ibator should show a warning if that happens. Unsupported data typed are fairly common with Oracle. Check the data types of the missing columns - that might give us a better idea of what's wrong. Jeff B

Re: Beta 6 Oracle Invalid column type: getCLOB not implemented

2009-12-13 Thread Jeff Butler
I believe I have found and fixed the error in iBATIS. Please try building from SVN and let me know if the issue is resolved. Jeff Butler On Fri, Dec 11, 2009 at 11:10 PM, Guy Rouillier wrote: > I've posted an update to Jira issue IBATIS-712.  I can get this to fail > repeatedly wi

Re: Beta 6 Oracle Invalid column type: getCLOB not implemented

2009-12-10 Thread Jeff Butler
ng into the mix on linux. Jeff Butler On 12/10/09, Guy Rouillier wrote: > On 12/10/2009 11:33 AM, Jeff Butler wrote: >> This method (getCLOB) is a JDBC 3 method. You must now use a driver >> that is JDBC 3 compliant. > > I'm using the ojdbc6.jar driver from 11g (although

Re: Beta 6 Oracle Invalid column type: getCLOB not implemented

2009-12-10 Thread Jeff Butler
This method (getCLOB) is a JDBC 3 method. You must now use a driver that is JDBC 3 compliant. Jeff Butler On 12/10/09, Guy Rouillier wrote: > I'm getting a catastrophic failure with Beta 6 that does not happen with > Beta 5. I opened Jira issue IBATIS-712 for this

Re: separate package for ...Example classes

2009-11-17 Thread Jeff Butler
accessed in a plugin (IntrospectedTable.getTableConfigurationProperty(String), or IntrospectedTable.getTableConfiguration().getProperties()). Jeff Butler 2009/11/17 Tomáš Procházka : > > Hi. > > It's possible change package where ...Example classes will be generated? > This will be great o

Re: what contain int return value for insert?

2009-11-15 Thread Jeff Butler
Fixed in SVN. Thanks! Jeff Butler 2009/11/15 Tomáš Procházka : > > I found problem, produce this: > > > > should be use order="AFTER" instead of type="post"? > > ______ >> Od: "Jeff

Re: What I miss in Ibator (was: Re: what contain int return value for insert?)

2009-11-15 Thread Jeff Butler
I used part of your patch for column defaults - I added to attribute in the introspected column and filled it in with the database introspector. You can do the rest of your patch with a plugin. Thanks! Jeff Butler 2009/11/15 Tomáš Procházka : > > Thanks you. This is great, only small p

Re: what contain int return value for insert?

2009-11-14 Thread Jeff Butler
The return value from the insert method is the number of rows inserted (in iBATIS3). Ibator will generated the proper code for generated keys - see the configuration element in the documentation. Jeff Butler 2009/11/14 Tomáš Procházka : > > What contain return int value for this mapper

Re: Ibator for ibatis 3

2009-11-12 Thread Jeff Butler
Hi Guy, I'm glad you are finding some value from Ibator. I have no plans to do a generate from a select statement. I'm not opposed to it philosophically - I just have limited time right now. Feel free to work on a patch if you are interested. Jeff Butler On Thu, Nov 12, 2009 at 1:

Re: ibator and enum colum type

2009-11-12 Thread Jeff Butler
bator configuration: This works as expected. I've checked in a new test to prove it for the future. Jeff Butler 2009/11/12 Tomáš Procházka : > > Another issue that I found in ibator is that he doesn't support Enum type > when database has enum column. It generate pojo o

Re: Collection with composite key in XML mapping

2009-11-12 Thread Jeff Butler
Open a JIRA ticket. If you can attach a path and a test case that would be even better. Jeff Butler On Thu, Nov 12, 2009 at 12:17 PM, Byron Tymvios wrote: > I have downloaded the latest trunk of iBatis 3 from SVN and did some > debugging. It appears as if the composite key no

Re: ibator and default column value

2009-11-09 Thread Jeff Butler
27;ll need to wait until the new version of the Eclipse plugin comes out for that. This has been discussed on this list many times, so you can look back in the archives to understand the reasons for this. I'm glad Ibator worked for you with iBATIS3! Jeff Butler 2009/11/9 Tomáš Procházka

Re: Ibator for ibatis 3

2009-11-08 Thread Jeff Butler
here might be some situations I've not anticipated. Let me know if you encounter any difficulties. The SVN link is here: http://svn.apache.org/repos/asf/ibatis/java/ibator/trunk/core/ Jeff Butler On Thu, Nov 5, 2009 at 11:41 PM, Zach Visagie wrote: > On Thu, 5 Nov 2009 09:44:48 -

Re: iBatis queryforList not working for dynamic Stored Proc

2009-11-02 Thread Jeff Butler
If I understand the question, it seems you are asking if ibatis supports optional parameters for stored procedure calls. The simple answer is "yes". See the tag with ibatis 3 or the tag with ibatis 2. Jeff Butler On 11/2/09, abdesai wrote: > > Hi ppl, > > I am using i

Re: Update Table with selected columns

2009-10-22 Thread Jeff Butler
updateByPrimaryKeySelective and updateByExampleSelective allow you to select the columns - only non-null columns in the parameter objects will be updated. Jeff Butler On Thu, Oct 22, 2009 at 2:31 PM, Vinaya Tirikkovalluru wrote: > They do, they don't take the specified columns though.

Re: Update Table with selected columns

2009-10-22 Thread Jeff Butler
Ibator generates updateByPrimaryKey and updateByExample methods that serve this purpose. Jeff Butler On Thu, Oct 22, 2009 at 2:26 PM, Vinaya Tirikkovalluru wrote: > Hi, > > > > I am using Ibator to generate the Ibatis objects. > > I have a requirement where I should be a

Re: Executing PL/SQL procs from migration tool.

2009-10-19 Thread Jeff Butler
Can you configure the end of line delimiter? If so, the user could choose some unused character for this kind of situation. Jeff Butler On Mon, Oct 19, 2009 at 9:13 PM, Clinton Begin wrote: > PS:  you could use full line demarcation and use 'GO' or something like SQL >

Re: iBatis - Connections to PostgreSQL Not Closing

2009-10-19 Thread Jeff Butler
sqlMap", sqlMap); } catch (Exception e) { e.printStackTrace(); } } Make sure all other actions use this same code - a good use for a super class :). Then you know it's only created once. Jeff Butler On Mon, Oct 19, 2009 at 3:28 PM, Jim Borland wrote: > > Here it

Re: iBatis - Connections to PostgreSQL Not Closing

2009-10-19 Thread Jeff Butler
We should also see the Java code that creates the SqlMapClient. Without Spring you need to make sure that only a SINGLE instance of that object is created (it should be and stored either in a singleton or something like a web context). Jeff Butler On Mon, Oct 19, 2009 at 2:50 PM, Larry Meadors

Re: Building iBator Eclipse plug-in from source

2009-09-16 Thread Jeff Butler
nk/eclipse/org.apache.ibatis.ibator.eclipse.doc/html-src/eclipseui/buildingFromSVN.html Jeff Butler On Wed, Sep 16, 2009 at 1:24 AM, Guy Rouillier wrote: > I'm trying to build the iBator Eclipse plug-in from source to correct the > NullPointerException if the daoGenerator clause is not

Re: Mapping new syntax

2009-09-08 Thread Jeff Butler
contribute it back to the community. Jeff Butler On Tue, Sep 8, 2009 at 7:36 AM, faresz wrote: > > Yes i know but we have a huge application with thousands of queries  :S > So should we loose time by reconstructing all these queries??? > > > > > Jeff Butler-2 wrote: >

Re: Mapping new syntax

2009-09-08 Thread Jeff Butler
The old syntax is gone. The new syntax is like this: ... iBATIS now uses OGNL for expressions - it's much more powerful than the old tags. Jeff Butler On Tue, Sep 8, 2009 at 2:49 AM, faresz wrote: > > Does iBatis3 support the old syntax of iBatis 2 like if not > so the

Re: Using the foreach statement in iBatis 3.0

2009-08-26 Thread Jeff Butler
The "collection" attribute of the tag should the property of the parameter object that holds the list of values. From what's below, iBATIS is expecting a "public List getList()" method in the BAFselectByDateRange object. Jeff Butler On Wed, Aug 26, 2009 at 1:

Re: iBATOR does not generate without optional an element

2009-08-20 Thread Jeff Butler
The code in SVN is very stable so you can check it out and build it yourself to have the bug fix. The only reason I haven't released a new version of Ibator is that I'm writing the code generators for iBATIS3. Should be out very soon. Jeff Butler On Thu, Aug 20, 2009 at 3:14 AM,

Re: iBATOR+iBATIS generation is successful, but test does not work.

2009-08-20 Thread Jeff Butler
You need to enable statement namespaces. See here for an example: http://ibatis.apache.org/docs/tools/ibator/afterRunning.html Jeff Butler On Thu, Aug 20, 2009 at 3:04 AM, bhaa wrote: > > Hi, > > This is file ibatorConfig.xml: > > > Apache iBATIS Ibator Configurat

Re: How Do I Change Schema

2009-08-13 Thread Jeff Butler
I like it! Jeff Butler On Thu, Aug 13, 2009 at 10:02 AM, Clinton Begin wrote: > Sorry for being unclear.  Jeff's explanation is correct. > > The reason I didn't put the property syntax in is that we need a way to > specify whether the property should be parameterized,

Re: How Do I Change Schema

2009-08-13 Thread Jeff Butler
#{...} use bean properties as parameters ${...} use bean properties for string substitution ?{...} use system properties for string substitution I don't remember if we thought this was too complex to implement, or too confusing to use, or if we just forgot to do it. Jeff Butler On Thu, Aug 1

Re: [IB3] Some questions

2009-08-12 Thread Jeff Butler
an do or . Jeff Butler On Wed, Aug 12, 2009 at 7:22 PM, Zoran Avtarovski wrote: > First off, fantastic effort guys. This looks like a unbelievable release. > The improvements over the previous version are just incredible. I’m > especially a fan of the new collection tag. > > I’ve b

Re: Ibator: disable aliases for update and delete statements?

2009-08-09 Thread Jeff Butler
will soon. So I'll have to think about this for a bit to come up with the best way to deal with it. Don't you love how "standard" SQL is? I've never run into this in all my testing, but I don't test with SQL Server regularly. No problems in MySql, HSQLDB, DB2, and

Re: LazyLoading and CGLIB return wrong types

2009-07-29 Thread Jeff Butler
ct on your application performance. It's worth a try. Jeff Butler On Wed, Jul 29, 2009 at 2:09 AM, Dawson Lewis wrote: > > Hi, > I am aware of that , but there are so many fields to exclude. It should not > be that way . > Plus it is really annoying to track all those classes iBati

Re: Questions regd ibatis best practices - need some help here

2009-07-24 Thread Jeff Butler
You don't need a parameter map for procedures in iBATIS2. This is from the developers guide, page 30: {call MyProcedure (#parm1,jdbcType=INTEGER,mode=IN#, #parm2,jdbcType=INTEGER,mode=IN#, #parm3,jdbcType=DECIMAL,mode=OUT,numericScale=2#)} Similar in iBATIS3. Jeff Butler 2009

Re: Questions regd ibatis best practices - need some help here

2009-07-24 Thread Jeff Butler
asf/ibatis/trunk/java/ibatis-3/ BTW - there's no published documentation yet - so look to the test cases to see how to use it. Jeff Butler On Fri, Jul 24, 2009 at 12:38 AM, swaroop belur wrote: > > > Hi Jeff > > This is really good.  This kind of reply will really help us

Re: Questions regd ibatis best practices - need some help here

2009-07-23 Thread Jeff Butler
iBATIS caches statements, not objects or tables Anybody have others? Jeff Butler On Wed, Jul 22, 2009 at 8:13 AM, swaroop belur wrote: > > Hello all, > > Is there any pointer/link or document which suggests using certain features > over others to achieve the same goal > to i

  1   2   3   4   5   6   7   8   9   10   >