on ‎2010 Jul 02 4:10 PM
2010-07-02 12:58:35 Error Could not execute statement for table/stored proc. "sp_PalletBackflushAcknowledge" (structure "Acknowledge") due to java.lang.NumberFormatException: For input string: "393006000111122222"
2010-07-02 12:58:35 Error JDBC Message processing failed, due to Error processing request in sax parser: Error when executing statement for table/stored proc. 'sp_PalletBackflushAcknowledge' (structure 'Acknowledge'): java.lang.NumberFormatException: For input string: "393006000111122222"
2010-07-02 12:58:35 Error Adapter Framework caught exception: null
2010-07-02 12:58:35 Error Delivering the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'sp_PalletBackflushAcknowledge' (structure 'Acknowledge'): java.lang.NumberFormatException: For input string: "393006000111122222".
2010-07-02 12:58:35 Error The message status was set to NDLV.
JDBC RECEIVER
I the JDBC the field data type is BIGINT.
IN MESSAGE MAPPING SOURCE DATA TYPE IS INTEGER WHERE WE WILL BE GETTING A 18 DIGIT NUMBER.
IN TARGET DATA TYPE THE DAtatype is long where we pass the integer to this long.
and mapping is successful but trying to sent the respoinse back it gives the error as above
can you please
Request clarification before answering.
Hi PBS,
It seems bigint datatype is not there in Oracle. Can you please check that. I have seen the data types in oracle and I didn't find it.
http://ss64.com/ora/syntax-datatypes.html
If you can convert that into number or long that would be good. It can handle your requirement.
Regards,
---Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.