Re: Problem with DB2 and BLOB!!

2008-01-03 Thread Curro
v8.1 2008/1/4, Stephen Boyd <[EMAIL PROTECTED]>: > > what version of db2? I have not seen a sqlstate of F before with db2 > v8+ > > On Jan 2, 2008 2:49 AM, Curro <[EMAIL PROTECTED]> wrote: > > > Hi and happy new year for everyone... > > > > This is one of the querys that is failing > > > >

Bulk Insert with IBATIS and MySQL Insert Delayed

2008-01-03 Thread vrl_swamy
Hi Folks, We have an implementation of data logger, that uses 'insert delayed' of MySQL over JDBC to load bulk data in to a MyISAM table. Our typical size of insert is 5-10 KB and we have our own optimized implementation of buffers and maintaining them as values part of bulk insert statement.

Re: BigDecimal conversion exception wth DB2

2008-01-03 Thread j-lists
This is really just a database/jdbc problem, nothing to do with ibatis itself. You probably have a precision problem relating to your fraction (that is too small to show up in the 1.0E+18), setting the scale on the BigDecimal before sending it to the database might sort that out for you. -J On Ja

BigDecimal conversion exception wth DB2

2008-01-03 Thread chunnu
SEVERE: #{MarginRuleEntry.btnSave_action}: javax.faces.el.EvaluationException: com.ibatis.dao.client.DaoException: Failed to update - id [updateMarginRuleDetail] - parameterObject [idx : 3marginruleid : null auid : 13 cpartyid : 0 initmargin : 1.0E+18 margin : 99 granularity :

Re: question about parameterMap and java class

2008-01-03 Thread anika agarwal
Hi why dont you use result map to getName of the color class.. like... select name, id from mytable C064ID=#id[]# So in you class u can get the name of the color class by doing colorClass.getname(); Hope this will help you - Original Message From: Ashish Kulkarni <[E

Re: Problem with DB2 and BLOB!!

2008-01-03 Thread Stephen Boyd
what version of db2? I have not seen a sqlstate of F before with db2 v8+ On Jan 2, 2008 2:49 AM, Curro <[EMAIL PROTECTED]> wrote: > Hi and happy new year for everyone... > > This is one of the querys that is failing > > > > > > > > > > > > > SELECT > imagen.ID_IMAGEN, >

Re: question about parameterMap and java class

2008-01-03 Thread Stephen Boyd
Have you tried C064ID=#id[].*name*# On Jan 3, 2008 1:46 PM, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: > Hi > I have a class like below with get and set method > public ColorClass > { > private String name, desc; > > public void setName(String _name) > { > this.name = _name; > } > public Str

question about parameterMap and java class

2008-01-03 Thread Ashish Kulkarni
Hi I have a class like below with get and set method public ColorClass { private String name, desc; public void setName(String _name) { this.name = _name; } public String getName() { return name; } } How can i define this ColorClass in parameterMap and use it in SQL statement for varaible substi