sqlUpdate Insert Error

Hi mashers,

I'm trying to use SQL commands to load a database with data, but I'm getting an error message when the emml executes. I know the code works because I've tested it with much simpler example of data and values. Now I'm working toward my intended use, but have run in to this error.

Does anyone have any suggestions on where the problem might be.

Cheers, Innes

640 ERROR [com.jackbe.jbp.jems.moe.runtime.JEMSDesignerImpl] -
<Error execution Mashup Script : org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT into client(clinicgrp,clientno,lastname,firstname,title,address1,address2,address3,postcode)         VALUES(?,?,?,?,?,?,?,?,?)]; Unable to convert between net.sf.saxon.dom.DOMNodeList and JAVA_OBJECT.; nested exception is java.sql.SQLException: Unable to convert between net.sf.saxon.dom.DOMNodeList and JAVA_OBJECT. : EMML Line # 106 : EMML Line # : 6>

Here's the full emml code:

         <variables>
            <variable name="global.AHCDataStore.SQL.jdbcURL" type="string" />
            <variable name="global.AHCIntranet.SQL.jdbcDriver" type="string" />
            <variable name="global.jdbcUserID" type="string" />
            <variable name="global.jdbcPassword" type="string" />
            <variable name="sqlCmdResult" type="document" />
            <variable name="sqlRecord" type="document" />
            <variable name="clinicgrp" type="string" />
            <variable name="clientno" type="number" />
            <variable name="lastname" type="string" />
            <variable name="firstname" type="string" />
            <variable name="title" type="string" />
            <variable name="address1" type="string" />
            <variable name="address2" type="string" />
            <variable name="address2" type="string" />
            <variable name="postcode" type="string" />
    <variable name="ahcRecordSet" type="document">
        <records>
            <record>
                <clientno>23871</clientno>
                <lastname>Leech</lastname>
                <firstname>Daphine</firstname>
                <title />
                <address1>248 State Highway 27</address1>
                <address2>RD 1 </address2>
                <address3>Tirau</address3>
                <postcode>3484</postcode>
                <preferredvet />
                <areacode />
                <clienttype />
                <code />
                <salesrep />
            </record>
            <record>
                <clientno>23872</clientno>
                <lastname>Macfarlane</lastname>
                <firstname>Philip</firstname>
                <title>Mr</title>
                <address1>341 Tauwhare Road</address1>
                <address2>RD3</address2>
                <address3>Hamilton</address3>
                <postcode>3285</postcode>
                <preferredvet />
                <areacode />
                <clienttype />
                <code />
                <salesrep />
            </record>
            <record>
                <clientno>23873</clientno>
                <lastname>Blogs</lastname>
                <firstname>Jo</firstname>
                <title>Mr</title>
                <address1>Vfansdjgnank</address1>
                <address2 />
                <address3 />
                <postcode />
                <preferredvet />
                <areacode />
                <clienttype />
                <code />
                <salesrep />
            </record>
        </records>
    </variable>                   
        </variables>

        <datasource name="ahcDataStore" url="{$global.AHCDataStore.SQL.jdbcURL}"
            driverClassName="{$global.AHCIntranet.SQL.jdbcDriver}" username="{$global.jdbcUserID}"
            password="{$global.jdbcPassword}" />

        <sqlBeginTransaction name="ahcDataStore" />

        <sqlUpdate name="ahcDataStore"
            statement="CREATE TABLE client (clinicGrp varchar(5) NOT NULL,
                                            clientNo int NOT NULL,
                                            lastname varchar(40),
                                            firstname varchar(30),
                                            title varchar(15),
                                            address1 varchar(50),
                                            address2 varchar(30),
                                            address3 varchar(30),
                                            postcode varchar(10),
                                            CONSTRAINT pk_clnGrpClient PRIMARY KEY (clinicgrp,clientno)
                                            )"
            outputvariable="sqlCmdResult" />
        <display message="sqlCmdResult=" variable="sqlCmdResult" />

        <foreach items="$ahcRecordSet/*:records/*:record" variable="sqlRecord">

            <display message="&#10;&#13;record=" variable="sqlRecord" />
            <assign literal="ahc" outputvariable="clinicgrp" />
            <assign fromexpr="$sqlRecord/*:clientno/text()" outputvariable="clientno" />
            <assign fromexpr="$sqlRecord/*:lastname/text()" outputvariable="lastname" />
            <assign fromexpr="$sqlRecord/*:firstname/text()" outputvariable="firstname" />
            <assign fromexpr="$sqlRecord/*:title/text()" outputvariable="title" />
            <assign fromexpr="$sqlRecord/*:address1/text()" outputvariable="address1" />
            <assign fromexpr="$sqlRecord/*:address2/text()" outputvariable="address2" />
            <assign fromexpr="$sqlRecord/*:address3/text()" outputvariable="address3" />
            <assign fromexpr="$sqlRecord/*:postcode/text()" outputvariable="postcode" />
           
            <sqlUpdate name="ahcDataStore"
                statement="INSERT into client(clinicgrp,clientno,lastname,firstname,title,address1,address2,address3,postcode)
                            VALUES(:clinicgrp,:clientno,:lastname,:firstname,:title,:address1,:address2,:address3,:postcode)"
                outputvariable="sqlCmdResult" />
            <display message="sqlCmdResult=" variable="sqlCmdResult" />
        </foreach>

        <sqlCommit name="ahcDataStore" />