error inserting null values to database

2005-10-31 Thread neilhenry
Hi I'm having trouble inserting null values into my database. The table allows nulls but when I supply a parameterMap with null values in it I get the folloing exception: java.sql.SQLException: Invalid column type at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:

Re: using result maps within result maps

2005-10-28 Thread neilhenry
That is true, but as I am getting a very wide result set from lots of tables and also getting that same data from each table at other times it requires duplication of property mappings. I have moved the select clauses into sql fragments so that I don't have to have them written out multiple times,

Re: Parameter Maps AND dynamic sql at the same time

2005-10-28 Thread neilhenry
Hi In the iBatis-SqlMaps-2.pdf (page 16) it states: Note! Dynamic mapped statements (described below) only support inline parameters and do not work with parameter maps. Regards Neil Quoting g m <[EMAIL PROTECTED]>: > Well spotted - it appears I pasted the wrong xml > fragment. My mistake. > H

Re: org.xml.sax.SAXParseException: Attribute "id" is required and must be specified for element type "delete".

2005-10-19 Thread neilhenry
The delete needs a close node. Quoting David Moss <[EMAIL PROTECTED]>: > I'm getting this exception when trying to start my web app in Tomcat5. > > my sql-map-config.xml file contains: > > > 2.0//EN" "http://www.ibatis.com/dtd/sql-map-config-2.dtd";> > > > >

using result maps within result maps

2005-10-19 Thread neilhenry
I have a situation where I have several tables with one-to-one relationships. Each of which has 20 + columns. As each of them requires to be queried individually I have created result maps for each one. We also need to get all the data related to the central table and I would like to do this in o