cancel
Showing results for 
Search instead for 
Did you mean: 

Data is not being sent to DB from ESP

Former Member
0 Kudos

Hi,

I am using ESP 5_1 version SP08 in linux environment.

I am sending some data from esp windows to external oracle database using db_out adapter.

I can see that there are n number of records there in window but they were not sent to database.

in.ccl file-

ATTACH OUTPUT ADAPTER AD_mywindows1 TYPE db_out TO H_mywindow1 PROPERTIES service = 'myservice1' ,table = 'mywindow1';

log-

Connection(AD_mywindows1/H_mywindow1):: DBOutput_Adapter::purgePending() Entered

all the windows has this same log throughout the log file [log level is - 7]

Clueless about what went wrong !!

One more question -

2015-06-01 11:50:23.855 | 6944 | container | [SP-3-150004] (104.176) sp(6250) Connection(AD_XXXX/H_XXXX):: DBOutput_Adapter::executeUpdateSQL() executeUpdate not successful for [insert into XXXX values(   ? , ? , ? , ? )] update count of: 0

What is the meaning of the symbol  ? in above error log from esp.

Is this denotes the null values in the update query ..!!

Thanks

Regards

Adesh

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

>>What is the meaning of the symbol  ? in above error log from esp.

>>Is this denotes the null values in the update query ..!!

This means "data". It is saying it executed the statement in the database:

insert into XXXX values(   ? , ? , ? , ? )

For security reason table name is put as XXXX and data are shown as ?.

It seems you have created a data service called myservice1. Using ESP Studio can you discover this data service. This means, Studio will try to connect database and display some of the tables.

Second question is does your windows schema match with the table schema in the database?

Thanks.

Answers (0)