No data in table using <oxf:sql update> with insert...

hi,

i'm trying to prototype a simple pipeline that takes xml feed via the oxf:url-generator into a sql processor that extracts certain elements and inserts them into the correct db table. Here's the pipeline (doing this via cli so only including xpl and xml fragments):

  <p:processor name="oxf:url-generator" xmlns:p="http://www.orbeon.com/oxf/pipeline">  
      <p:input name="config">  
         <config>  
             <url>oxf:notifications.xml</url>  
             <content-type>application/xml</content-type>  
             <validating>true</validating>  
             <handle-xinclude>false</handle-xinclude>  
         </config>  
       </p:input>  
       <p:output name="data" id="notification-xml-feed" debug="true"/>
     </p:processor>

    <p:processor name="oxf:sql">
        <p:input name="data" href="#notification-xml-feed" debug="true"/>
        <p:input name="datasource" href="datasource.xml"/>
        <p:input name="config">
            <sql:config>
                <sql:connection>
                    <sql:execute>
                        <sql:update select="/notificationList/notification">
                           insert into notification (notification_type)
                             values (<sql:param type="xs:string" select="notification_type"/>)
                        </sql:update>
                    </sql:execute>
                </sql:connection>
            </sql:config>
        </p:input>
    </p:processor

here's the xml fragment (notificationList is the root):

<notificationList xmlns="urn:bss:cim" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="..\schema\notification.xsd">

              <notification>
                <notifier>CHILD CARE CENTRE</notifier>
                <notificationType>electronic</notificationType>
                ...

here's debug tracing prologue from the OPS (console):

2006-04-24 19:05:54,359 INFO  org.orbeon.oxf.processor.DatabaseContext null - Co
mmitting JDBC connection for datasource: [oracle.jdbc.OracleDriver|jdbc:oracle:t
hin:testbss/testbss@localhost:1521:xe|null].
2006-04-24 19:05:54,359 INFO  org.orbeon.oxf.main.OPS null - / - Timing: 1094 -
Cache hits: 5, fault: 15, adds: 15, success rate: 25%

Problem: Despite the above msg (to INFO level only i see though!) i'm not seeing any indication of an exception or failure - the commit is happening on the connection (i'm using Oracle 10g XE).

Any help would be appreciated.

-m.






--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

[hidden email] wrote: In one place, you have "notification_type", and in the other,
"notificationType". Is that a typo, or could that be the source of your
problem?

-Erik

--
Orbeon - XForms Everywhere:
http://www.orbeon.com/blog/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws