ibatis says "no results" but query does return results

2005-04-07 Thread Dan Tenenbaum
I am running a query from ibatis and I get this error: java.lang.reflect.UndeclaredThrowableException at $Proxy9.getVisibleSelectedIds(Unknown Source) at (...) ... 18 more Caused by: com.ibatis.dao.client.DaoException: Error executing query for list. Cause: com.ibatis.co

About MySQL Driver Properties in

2005-04-07 Thread Akihiro Kubota
           

Support for oracle cursors as resultsets

2005-04-07 Thread Grassi Fabio
Title: Messaggio The support for oracle ref cursors both as stored-function results and as out stored-procedure parameters is critical for me as well. I have a not-so-small code base (150-200 stored procedures) I currently access to through Oracle JPublisher. I would like to dismiss JPublish

Re: How do I use the dollar sign notation (i.e. $xyz$) to send a string to the database that has a pound sign on either side of it?

2005-04-07 Thread Brice Ruth
Note - the $xyz$ notation does not create a '?' for a prepared statement ... it's value (as indicated by Brandon) is placed into the SQL string before the prepared statement is generated. On Apr 6, 2005 4:25 PM, Ron Grabowski <[EMAIL PROTECTED]> wrote: How do I use the dollar sign notation (i.e. $x

Re: ibatis technology need company references.

2005-04-07 Thread Brice Ruth
Vic, can you use an email client that actually puts "Vic" as your name?! Would you like a Gmail account?!   Love your contributions, but always frustrated that I can't tell who's posting until I see ".V" ... :)  On Apr 6, 2005 9:26 PM, NetSQL <[EMAIL PROTECTED]> wrote: 1up.com is using iBatis 2 and

class cast exception

2005-04-07 Thread Baldur Norddahl
Hi, In some of our projects we are haunted by a strange class cast exception. I suspect it is a class loader issue. Just after restarting the application server everything works fine, and it may continue to work fine for hours or days. Until suddenly it stops working with this kind of errors:

Re: ibatis technology need company references.

2005-04-07 Thread NetSQL
I... sometimes say things I should not. So a company policy is to go by "handles", in my case netsql. I do wonder if that is ok? .V Brice Ruth wrote: Vic, can you use an email client that actually puts "Vic" as your name?! Would you like a Gmail account?! Love your contributions, but always fr

R: class cast exception

2005-04-07 Thread Grassi Fabio
 Where do you put you iBatis jar files? In common/lib, server/lib or WEB-INF/lib?> -Messaggio originale-> Da: Baldur Norddahl [mailto:[EMAIL PROTECTED] > Inviato: giovedì 7 aprile 2005 15:36> A: ibatis-user-java@incubator.apache.org> Oggetto: class cast exception> > > Hi,> > In some of our

Re: ibatis technology need company references.

2005-04-07 Thread Brice Ruth
What's the point if you sign your messages .V?! On Apr 7, 2005 8:39 AM, NetSQL <[EMAIL PROTECTED]> wrote: I... sometimes say things I should not. So a company policy is to go by"handles", in my case netsql.I do wonder if that is ok?.VBrice Ruth wrote:> Vic, can you use an email client that actually

Re: R: class cast exception

2005-04-07 Thread Baldur Norddahl
Grassi Fabio wrote:   Where do you put you iBatis jar files? In common/lib, server/lib or WEB-INF/lib? WEB-INF/lib in the .war file - so iBatis is not shared. Some of our applications run with old iBatis and some with the new version. Thanks, Baldur > -Messaggio originale-

Re: How do I use the dollar sign notation (i.e. $xyz$) to send a string to the database that has a pound sign on either side of it?

2005-04-07 Thread Ron Grabowski
Correct. The main point I was trying to make was that choice B from my choices below is the correct way to parse things. 34 and 56 should remain in the sql being sent to the database. This is related to an issue with IBatisNet: http://issues.apache.org/jira/browse/IBATISNET-29 I wanted to make

Re: ibatis technology need company references.

2005-04-07 Thread Leonardo Bueno
Did you get a job at JBoss Inc .V ? ;-) Leonardo Bueno On Apr 7, 2005 10:43 AM, Brice Ruth <[EMAIL PROTECTED]> wrote: > What's the point if you sign your messages .V?! > > > > On Apr 7, 2005 8:39 AM, NetSQL <[EMAIL PROTECTED]> wrote: > > I... sometimes say things I should not. So a company p

Re: ibatis says "no results" but query does return results

2005-04-07 Thread Brandon Goodin
It would help if you posted the sqlmap, the sqlmap config, associated property files and the full code that calls the sqlmap. Brandon On Apr 6, 2005 12:50 PM, Dan Tenenbaum <[EMAIL PROTECTED]> wrote: > I am running a query from ibatis and I get this error: > > java.lang.reflect.UndeclaredThrowa

Re: About MySQL Driver Properties in

2005-04-07 Thread Brandon Goodin
There is no current feature like that. You have to pass them on the connection string like you are currently doing. What is the difficulty you are facing with passing the values on the connections string? Please explain why this is a problem. Brandon On Apr 7, 2005 3:59 AM, Akihiro Kubota <[EMAIL

Re: ibatis says "no results" but query does return results

2005-04-07 Thread Larry Meadors
this somehow got resent, we solved this yesterday...missing resultmap/resultclass attribute in the select tagOn Apr 7, 2005 8:10 AM, Brandon Goodin <[EMAIL PROTECTED]> wrote:It would help if you posted the sqlmap, the sqlmap config, associatedproperty files and the full code that calls the sqlmap.B

Re: About MySQL Driver Properties in

2005-04-07 Thread Larry Meadors
that used to work in 1.x, but i have not tried it in 2.xOn Apr 7, 2005 3:59 AM, Akihiro Kubota <[EMAIL PROTECTED]> wrote: >>   >>>>   > value="jdbc:mysql://localhost:3306/exam?zeroDateTimeBehavior=convertToNull"> />>>>>>>  

Re: Support for oracle cursors as resultsets

2005-04-07 Thread Brandon Goodin
We appreciate all you help. The best thing you can do it to checkout the ibatis source from SVN. Make the change in accordance with the proposed solution in JIRA. Then attach a patch to thie issue for review. Thanks Brandon On Apr 7, 2005 6:08 AM, Grassi Fabio <[EMAIL PROTECTED]> wrote: > > The

Re: ibatis technology need company references.

2005-04-07 Thread NetSQL
:-P People that would be upset... it's enough to confuse them. I duno hell, I use Collections instead of beans. .V Brice Ruth wrote: What's the point if you sign your messages .V?! On Apr 7, 2005 8:39 AM, *NetSQL* <[EMAIL PROTECTED] > wrote: I... sometimes say t

Re: ibatis technology need company references.

2005-04-07 Thread NetSQL
Leonardo Bueno wrote: Did you get a job at JBoss Inc .V ? ;-) Nope. :-[ .V

R: Support for oracle cursors as resultsets

2005-04-07 Thread Grassi Fabio
 Will you please point me to the SVN repository? I looked for it but only found the source for the stable version. Thanks in advance, Fabio.> -Messaggio originale-> Da: Brandon Goodin [mailto:[EMAIL PROTECTED] > Inviato: giovedì 7 aprile 2005 16:15> A: ibatis-user-java@incubator.apache.org>

R: Support for oracle cursors as resultsets

2005-04-07 Thread Grassi Fabio
 Sorry everybody, I finally found it. Fabio.Will you please point me to the SVN repository? I looked for it but only found the source for the stable version. Thanks in advance, Fabio.> -Messaggio originale-> Da: Brandon Goodin [mailto:[EMAIL PROTECTED] > Inviato: giovedì 7 aprile 2005 16:15

RE: ibatis technology need company references.

2005-04-07 Thread Jim Shea
We've been using iBATIS at Traq-wireless (http://www.traq.com/) for over a year now. In my experience it's a very stable, high-quality product and I have no hesitation in recommending it. Jim -Original Message- From: Victor Stepanov [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 06, 20

RE: ibatis technology need company references.

2005-04-07 Thread Mark Bennett
I know you're looking for product references but to give you more "ammo" you should make a hard copy of the Data Mapper Development Guide and bring that to your meetings as well. It is an impressive document. Mark -Original Message- From: Victor Stepanov [mailto:[EMAIL PROTECTED] Sent: W

Bidirectional parent-child relationship and groupBy

2005-04-07 Thread Oscar Picasso
Hi, I have something like that: class Category { int id; List subcategories; ..getters and setters } class Subcategory { int id; Category parent; ..getters and setters } A groupBy in the Category resultMap loads the related subcategories. However while loading these subcate

Passing an XML document as a parameter to SqlMapClient methods

2005-04-07 Thread Mark Nabours
I understand that passing an XML document (W3C, JDOM, ??) as a parameter to the SqlMapClient's methods (insert, update, queryForList, etc.) is a undocumented feature of iBATIS (http://wiki.apache.org/ibatis/Not_yet_Documented). Does anyone have any examples of using this feature? Thanks in ad

Nested Beans?

2005-04-07 Thread Nic Werner
Greetings, The archives aren't searchable right now (http://incubator.apache.org/ibatis/site/mailinglists.html), so I have this question: I have a Bean (Reservation), with another Bean (Device) inside it. My database just contains the DeviceID in the Reservation table - where/how can I use

Re: Nested Beans?

2005-04-07 Thread Brandon Goodin
You can use '.' (dot) notation. So, if you pass in Reservation as your parameter class you can acess the device id with 'device.id' (assuming 'id' is the name of your id propety in the Device class) Brandon On Apr 7, 2005 12:58 PM, Nic Werner <[EMAIL PROTECTED]> wrote: > Greetings, > The arc

Please Help in arguing for iBatis SqlMaps

2005-04-07 Thread Kaushik Ashodiya
Hi, I have hard time arguing for iBatis SqlMaps (not because something wrong with SqlMaps). Please give me more reasons so that I can convince them. Their argument: 1. For small project SqlMap is adding unnecessary complexity. 2. Why learn one more tool when you have a simple base data access obj

Re: Please Help in arguing for iBatis SqlMaps

2005-04-07 Thread Mark Bennett
Wow, I think this is going to be a fun thread. On Apr 7, 2005 1:55 PM, Kaushik Ashodiya <[EMAIL PROTECTED]> wrote: > Hi, > > I have hard time arguing for iBatis SqlMaps (not because something wrong > with SqlMaps). > > Please give me more reasons so that I can convince them. > > Their argument

Re: Please Help in arguing for iBatis SqlMaps

2005-04-07 Thread NetSQL
Kaushik Ashodiya wrote: Hi, I have hard time arguing for iBatis SqlMaps (not because something wrong with SqlMaps). Please give me more reasons so that I can convince them. Their argument: 1. For small project SqlMap is adding unnecessary complexity. 2. Why learn one more tool when you have a sim

Re: Please Help in arguing for iBatis SqlMaps

2005-04-07 Thread Brandon Goodin
You know... I can appreciate an informed opinion. But, your peer is clearly lacking in his assessment. All i can say is that you peer has some absurd notions and ridiculous antidotes. They clearly don''t understand the nature of the technologies they are talking about. I really don't feel like figh

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: Please Help in arguing for iBatis SqlMaps

2005-04-07 Thread Larry Meadors
Heheheh, this is funny. OK, here is an iBATIS application. It is not the best example, but it shows how nonsensical this statement is: "For small project SqlMap is adding unnecessary complexity." === Main.java === package blah; import com.ibatis.sqlmap.client.SqlMapClientBuilder; import com.ib

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: Please Help in arguing for iBatis SqlMaps

2005-04-07 Thread J.F. Zarama
Further help from IBM to newcomers on the subject include: http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0502cline/ http://www-1.ibm.com/support/docview.wss?uid=swg4f0a6040763358eee85256f9c005cad80 http://www-128.ibm.com/developerworks/opensource/newto/ http://www-128.ibm.com/d