Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/system/azrul.system/azrul.system.php on line 52

Strict Standards: Declaration of CUser::set() should be compatible with JObject::set($property, $value = NULL) in /home/bbiaxisc/public_html/components/com_community/libraries/user.php on line 13

Strict Standards: Declaration of CTableStorageS3::store() should be compatible with JTable::store($updateNulls = false) in /home/bbiaxisc/public_html/components/com_community/libraries/storage/s3.php on line 115

Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with JRegistry::loadSetupFile() in /home/bbiaxisc/public_html/libraries/joomla/html/parameter.php on line 0

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/system/jomsocialredirect/jomsocialredirect.php on line 29

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/system/jomsocialredirect/jomsocialredirect.php on line 132

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/system/azrul.system/azrul.system.php on line 148

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/system/marcosinterceptor/marcosinterceptor.php on line 19

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/system/azrul.system/azrul.system.php on line 87

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/system/jsjobsregister/jsjobsregister.php on line 70

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/system/jsjobsregister/jsjobsregister.php on line 98

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/system/jsjobsregister/jsjobsregister.php on line 75
B2BiAxis Forum :: Topic: Oracle Date Insert - LWJDBC (1/1)
Welcome [ B2BiAxis Sign In / Register ]  

Strict Standards: Non-static method modRokajaxsearchHelper::inizialize() should not be called statically in /home/bbiaxisc/public_html/modules/mod_rokajaxsearch/mod_rokajaxsearch.php on line 19

Strict Standards: Non-static method modRokajaxsearchHelper::getCSSPath() should not be called statically in /home/bbiaxisc/public_html/modules/mod_rokajaxsearch/helper.php on line 29

Strict Standards: Non-static method modRokajaxsearchHelper::getBrowser() should not be called statically in /home/bbiaxisc/public_html/modules/mod_rokajaxsearch/helper.php on line 30
Follow Us

Strict Standards: Non-static method CFactory::getFastCache() should not be called statically in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1008

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1051

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1147

Strict Standards: Non-static method CFactory::getConfig() should not be called statically in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1148

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 788

Strict Standards: Non-static method CAppPlugins::getInstance() should not be called statically in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 794

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 204

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/user.php on line 49

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/user.php on line 117

Strict Standards: Declaration of CTableMultiProfile::store() should be compatible with JTable::store($updateNulls = false) in /home/bbiaxisc/public_html/components/com_community/tables/multiprofile.php on line 0

Strict Standards: Declaration of CTableMultiProfile::delete() should be compatible with JTable::delete($pk = NULL) in /home/bbiaxisc/public_html/components/com_community/tables/multiprofile.php on line 0

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/user.php on line 634

Strict Standards: Non-static method CFactory::getConfig() should not be called statically in /home/bbiaxisc/public_html/components/com_community/helpers/url.php on line 105

Strict Standards: Non-static method CFactory::load() should not be called statically in /home/bbiaxisc/public_html/components/com_community/helpers/url.php on line 110

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/helpers/template.php on line 46

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/helpers/template.php on line 46

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 204

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/community/latestphoto/latestphoto.php on line 24

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/community/log/log.php on line 24

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/community/myarticles/myarticles.php on line 24

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 204

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/community/mytaggedvideos/mytaggedvideos.php on line 24

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 204

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/plugins/community/myvideos/myvideos.php on line 24

Strict Standards: Declaration of CTableOauth::load() should be compatible with JTable::load($keys = NULL, $reset = true) in /home/bbiaxisc/public_html/components/com_community/tables/oauth.php on line 0

Strict Standards: Declaration of CTableOauth::store() should be compatible with JTable::store($updateNulls = false) in /home/bbiaxisc/public_html/components/com_community/tables/oauth.php on line 0

Strict Standards: Declaration of CTableOauth::delete() should be compatible with JTable::delete($pk = NULL) in /home/bbiaxisc/public_html/components/com_community/tables/oauth.php on line 0

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/apps.php on line 268

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1291

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/apps.php on line 269

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/apps.php on line 292

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/apps.php on line 268

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/apps.php on line 269

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/apps.php on line 292

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1185

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 127

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/user.php on line 117

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/user.php on line 634

Strict Standards: Non-static method CFactory::getConfig() should not be called statically in /home/bbiaxisc/public_html/components/com_community/helpers/url.php on line 105

Strict Standards: Non-static method CFactory::load() should not be called statically in /home/bbiaxisc/public_html/components/com_community/helpers/url.php on line 110

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/helpers/template.php on line 46

Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/helpers/template.php on line 46
  • Page:
  • 1

TOPIC: Oracle Date Insert - LWJDBC

Oracle Date Insert - LWJDBC 7 months 5 days ago #7630


  • Strict Standards: Non-static method CFactory::getFastCache() should not be called statically in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1008

    Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1051

    Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1147

    Strict Standards: Non-static method CFactory::getConfig() should not be called statically in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1148
    UncleCharlie

  • Strict Standards: Only variables should be assigned by reference in /home/bbiaxisc/public_html/components/com_community/libraries/user.php on line 593

    Strict Standards: Non-static method CFactory::getConfig() should not be called statically in /home/bbiaxisc/public_html/components/com_community/helpers/url.php on line 105

  • Strict Standards: Non-static method CFactory::getFastCache() should not be called statically in /home/bbiaxisc/public_html/components/com_community/libraries/core.php on line 1008
    UncleCharlie's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
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