cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

java.lang.NumberFormatException

Former Member
0 Likes
1,421

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Likes

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

Ask a Question