Problem with date format.

2007-11-29 Thread Yuvraj Shinde
Hi all, I am using dd/MM/yy date format in search querry for searching a data. For Eg Select * from cust where cust_date = 30/11/07 it is giving me following exception [Oracle JDBC Driver][Oracle]ORA-01843: not a valid month. How to set or change the date format in Ibatis.

Re: Abator - change to allow it to produce stored procedures instead of SQL?

2007-11-29 Thread Raymond McDermott
Thanks - I think you have a point for completely generic generation, which of course would be the best use case for a framework. I think that a little XSLT will do what we want, so thanks for the input. I will post the results. On 29/11/2007, Jeff Butler <[EMAIL PROTECTED]> wrote: > > I did a pr

Re: Abator - change to allow it to produce stored procedures instead of SQL?

2007-11-29 Thread Jeff Butler
I did a pretty serious investigation into this a few months ago. The bottom line is that it is not really feasible to do code generation for stored procedures. The main issues are these: 1. The database metadata does not have enough information to fully understand what will be required for input

Abator - change to allow it to produce stored procedures instead of SQL?

2007-11-29 Thread Raymond McDermott
Our mainframe standards require us to produce SQL in the form of SQL stored procedures. We use Db2 v7.2/zOS now (v8.1 next year). The template for the stored procedure is well understood and I would just need to plug in the parameters and the sql. We like Abator for producing the original SQL bu

Re: Can abator use Oracle rownum to limit results

2007-11-29 Thread Jeff Butler
Abator doesn't generate code for Oracle rownum support. But you could easily extend the generated Example class to add this kind of function. I'll write some information about extending the example classes for the next release. There have been a lot of enhancements to Abator since the 1.0 release

RE: com.ibatis.common.xml.NodeletException

2007-11-29 Thread sudheesh.puthiyedath.ext
Yes,It worked Thanks Sudheesh -Original Message- From: ext Leucht, Axel [mailto:[EMAIL PROTECTED] Sent: 29 November, 2007 10:23 To: user-java@ibatis.apache.org Subject: AW: com.ibatis.common.xml.NodeletException Most likely you've an error in one of you're xml files, most likely SqlMap

AW: com.ibatis.common.xml.NodeletException

2007-11-29 Thread Leucht, Axel
Most likely you've an error in one of you're xml files, most likely SqlMapConfig.xml. Could you please post them here so we can have a look at it? Regards /Axel