cancel
Showing results for 
Search instead for 
Did you mean: 

Error when using receiver JDBC adapter

Former Member
0 Kudos

i am using JDBC adapter as receiver(for oracle 10g) now, however i got ORA-00984 error. So i enable logSQLStatement.

then got the following SQL statement from communication channel monitoring:

INSERT INTO BASEINFO(APPNO, BUSSINAME, APPPERSON) VALUES (3, Steven, Lee)

I realize the statement is incorrect, which should be:

INSERT INTO BASEINFO(APPNO, BUSSINAME, APPPERSON) VALUES ('3', 'Steven', 'Lee')

So how can i correct the SQL statement? is there any setting i miss out in configuration?

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Answered

prateek
Active Contributor
0 Kudos

You may try this. For each field in datatype, add an attribute hasQuot. Map it to "no" in mapping. Then add single quotes to all the values by simply concatinating it on both sides of value.

Regards,

Prateek

VijayKonam
Active Contributor
0 Kudos

If you are using the right fromat of receiver jdbc adapter, i donot think you need to do anything special. Check the message structure.

VJ