Re: Ibatis CLOB Support

2009-03-29 Thread Jeff Butler
If you use a parameterMap, use question marks (?). If you use a parameterClass, then use hash marks (#id#, etc.). In your case, use question marks. Jeff Butler On Sun, Mar 29, 2009 at 8:35 PM, a.rubalcaba wrote: > > So what parameter marks should I be using? > > > > Larry Meadors wrote: >> >>

Re: Ibatis CLOB Support

2009-03-29 Thread a.rubalcaba
So what parameter marks should I be using? Larry Meadors wrote: > > Yikes, be careful with that thing, it's loaded. ;-) > > $variable$ does substitution, so should really only be used as an > absolute last resort because of the SQL injection risk. > > Also, this statement will be sent to the

Re: Ibatis CLOB Support

2009-03-29 Thread Larry Meadors
Yikes, be careful with that thing, it's loaded. ;-) $variable$ does substitution, so should really only be used as an absolute last resort because of the SQL injection risk. Also, this statement will be sent to the database with no parameters, because they are all being substituted in. For examp

Re: Ibatis CLOB Support

2009-03-29 Thread a.rubalcaba
a.rubalcaba wrote: > > I am currently working on a project using Spring + Ibatis. DBA's have > recently switched a varchar field into a CLOB field to support large > Strings of data. > > My SQL map has the following > > > > which maps to a String object in my java class. > > I can ret