If you can change the "Number" id to "AutoNumber" you won't have to do the combined
select/insert thing... if you can't, well, I'm not an iBatis expert but it sounds like
you'll have to do the selecting of the next id separate from the insert. Of course then
you might have to worry about multiple threads getting the same "next" id...
b
[EMAIL PROTECTED] wrote:
Thanks for the replies guys. Sorry for the late response..
The id property doesnt exist in the object im inserting, its only an
internal identifier in the access database. In the database this is
defined as Number.
And i am stuck with access, as this system is already deployed and widely
used..
Any help on how to solve this would ensure you a place in heaven ;)
On 9/28/05, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
Hey,
Im having some difficulties inserting rows into ms access. The error i
get
is:
...
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in org/hisp/dhis/hmis/RoutineData.ibatis.xml. ---
The error occurred while applying a parameter map.
--- Check the addRoutineDataValue-InlineParameterMap.
--- Check the parameter mapping for the 'id' property.
--- Cause: java.sql.SQLException: [Microsoft][ODBC Microsoft Access
Driver]Invalid SQL-datatype
You have id both in your select key and the inserted value, and the
error said "while applying the *parameter* map"... What datatype is
your "id" property of the object you're inserting?
--
I tend to view "truly flexible" by another term: "Make everything
equally hard". -- DHH
