Welcome [ B2BiAxis Sign In / Register ]  
Follow Us
  • Page:
  • 1

TOPIC: Oracle Date Insert - LWJDBC

Oracle Date Insert - LWJDBC 1 month 5 days ago #7630

We're switching over to IBM SI Linux with Oracle as our DB. We previously used windows / MS SQL.

I'm trying to setup an onfault BP to write a log entry into a table in Oracle and I keep getting caught up on the datetime.

It gives me the error: 1843: ORA-01843: not a valid month.

Any ideas on what I can do here? Here are the two main sections used (get timestamp service and lwjdbc).
<operation name="Get Timestamp">
        <participant name="TimestampUtilService"/>
          <output message="TimestampUtilServiceTypeInputMessage">
            <assign to="action">format</assign>
            <assign to="baseTime" from="'now'"></assign>
            <assign to="format">yyyy-MM-dd HH:mm:ss.SSS</assign>
            <assign to="." from="*"></assign>
          </output>
          <input message="inmsg">
            <assign to="gen_dblog/DateTime" from="string(formattedTime)"></assign>
          </input>
        </operation>

<operation name="InsertLog">
            <participant name="LightweightJDBCAdapterQuery"/>
              <output message="LightweightJDBCAdapterTypeInputMessage">
                <assign to="param1" from="string(gen_dblog/BPID)"></assign>
                <assign to="param2" from="string(gen_dblog/BPNAME)"></assign>
                <assign to="param3" from="string(gen_dblog/DateTime)"></assign>
                <assign to="param4" from="string(gen_dblog/TYPE)"></assign>
                <assign to="param5" from="string(gen_dblog/MESSAGE)"></assign>
                <assign to="param6" from="string(gen_dblog/STATUS)"></assign>
                <assign to="param7" from="string(gen_dblog/DetailMsg)"></assign>
                <assign to="param8" from="string(gen_dblog/TRANS_REPORT)"></assign>
                <assign to="param9" from="if(not(PrimaryDocument),'No PrimaryDocument Received.','')"></assign>
                <assign to="param10" from="string(gen_dblog/RETURNCODE)"></assign>
                <assign to="param11" from="string(gen_dblog/ETETrkNum)"></assign>
                <assign to="param12" from="number(gen_dblog/BPRowID)"></assign>
                <assign to="param13" from="string(gen_dblog/FileID)"></assign>
                <assign to="param14" from="string(gen_dblog/SplitDocID)"></assign>
                <assign to="param15" from="string(gen_dblog/ArchiveDocID)"></assign>
                <assign to="param16" from="string(gen_dblog/NodeName)"></assign>
                <assign to="paramtype1">String</assign>
                <assign to="paramtype2">String</assign>
                <assign to="paramtype3">Date</assign>
                <assign to="paramtype4">String</assign>
                <assign to="paramtype5">String</assign>
                <assign to="paramtype6">String</assign>
                <assign to="paramtype7">String</assign>
                <assign to="paramtype8">String</assign>
                <assign to="paramtype9" from="if(not(PrimaryDocument),'String','CharacterStreamFromDocument')"></assign>
                <assign to="paramtype10">String</assign>
                <assign to="paramtype11">String</assign>
                <assign to="paramtype12">Integer</assign>
                <assign to="paramtype13">String</assign>
                <assign to="paramtype14">String</assign>
                <assign to="paramtype15">String</assign>
                <assign to="paramtype16">String</assign>
                <assign to="pool" from="string(gen_dblog/POOLNAME)"></assign>
                <assign to="query_type">INSERT</assign>
                <assign to="result_name">result</assign>
                <assign to="row_name">row</assign>
                <assign to="sql" from="concat('INSERT INTO ',string(gen_dblog/TABLENAME), '(BPID, BPNAME, DateTime, Type, Message, Status, Details, Trans_Report, PrimaryDocument, HTTPReturnCode, BPTrackingNumber, BPRowID, FileID, SplitDocID, ArchiveDocID, NodeName) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)')"></assign>
                <assign to="." from="*"></assign>
              </output>
              <input message="inmsg">
                <assign to="." from="*"></assign>
              </input>
            </operation>
          </sequence>
The administrator has disabled public write access.
  • Page:
  • 1