Insert null

2007-10-31 Thread Härtel , Eric
Hello list, I want to insert null for a String/VARCHAR property. Posting http://www.mail-archive.com/[email protected]/msg05079.html tells if my String is null default is null is inserted in the table. But it works not this way here. I got the following error message: --- The error o

Re: Insert null

2007-10-31 Thread Larry Meadors
Heh, OK, that confused me. :) Eric, I think what Lisa is saying is that you need to provide a hint as to the data type - this is required for null values in some JDBC drivers (Oracle, for instance). So, you want to make the variables look like this: INSERT INTO application ( degree, first

Re: infinite loop in the method 'moveToNextResultsIfPresent'

2007-10-31 Thread Larry Meadors
I *always* reply faster with an active support agreement - please feel free to email me off-list to negotiate the rate. ;-) ...and I've never had this issue with Oracle stored procedures, sorry. Larry On 10/31/07, Niels Beekman <[EMAIL PROTECTED]> wrote: > > I think you will be rewarded when yo

Re: FW: infinite loop in the method 'moveToNextResultsIfPresent'

2007-10-31 Thread Jeff Butler
I think you'll need to give us additional information or do some additional debugging. My initial guess is that this is hitting a driver bug since we haven't heard a general outcry about this issue. This method is hit in the tests and seems to perform correctly in most circumstances. Sorry, but

Re: RV: Problem with Stored Procedure SQLServer + iBatis

2007-10-31 Thread Larry Meadors
Not to mention that the JDBC drivers from M$ are notoriously crummy. If you had some time to test the JTDS driver, it might be worth a shot - I've had great success with it and SQL 2K5. Larry On 10/30/07, Jeff Butler <[EMAIL PROTECTED]> wrote: > I doubt this is an iBATIS issue - it must be a bu

Re: Insert null

2007-10-31 Thread Lisa Jenkins
If what you are saying is you want to pass null value to ibatis, try substituting the null value with "" in the insert statement. #email:jdbcType:null value to substitue# On the null value to use part, use "". iBatis will automatically substitute null values with empty string. Should work.

Rv: Rv: iterate syntax problem

2007-10-31 Thread Carlos de Luna Saenz
I am still getting the error no mater if i use the #epoca[]# or the #epocas[]# or the #epoca# public class EpocasTO { public Integer epoca; public List epocas; private int sala; public List salas; private int actualizacion; private int tipoAct; private int procedencia; private int acuerdoEpoca;

RE: Insert null

2007-10-31 Thread Härtel , Eric
Thank you a lot. That´s a proper solution :-) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors > Sent: Wednesday, October 31, 2007 3:48 PM > To: [email protected] > Subject: Re: Insert null > > Heh, OK, that confused me. :)

RE: infinite loop in the method 'moveToNextResultsIfPresent'

2007-10-31 Thread Niels Beekman
?, but yeh, support agreements usually help :) Niels -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: woensdag 31 oktober 2007 15:51 To: [email protected] Subject: Re: infinite loop in the method 'moveToNextResultsIfPresent'

Re: Rv: Rv: iterate syntax problem

2007-10-31 Thread Jeff Butler
iBATIS won't do what you want with the TO as is. Actually, I think your TO is a bit incorrect anyway because it appears from your query that epocas and salas are linked somehow. This will work: public class EpocaSalaTO { private Integer epoca; private Integer sala; // getters, setters } p