1-Visitor

Solved

I want to save data in oracle

Forum|Forum|6 years ago
September 4, 2019
1 reply
1430 views

I saw this manual.

https://developer.thingworx.com/en/resources/guides/external-databases/external-database-write

but Invalid column index Error confirmed.

I used two methods.

SQL (Command), SQL (Query)

And I used three methods.

([[ipvalue]], [[clocksvalue]], [[tempervalue]], [[loadvalue]], [[powervalue]], SYSDATE);
('[[ipvalue]]', '[[clocksvalue]]', '[[tempervalue]]', '[[loadvalue]]', '[[powervalue]]', SYSDATE);
('<<ipvalue>>', '<<clocksvalue>>', '<<tempervalue>>', '<<loadvalue>>', '<<powervalue>>', SYSDATE);

The inputs data are all strings.

Configuration is not wrong.

I think my method is wrong.
Can you help me?

Connectivity

Best answer by KANGJAEHYUCK

hi.

Thank you for your reply.

The problem has been solved.

I put it in SQL(Command).

and

I've used the following methods:

INSERT INTO kjhTemperTest(IP, CPUCLOCKS, CPUTEMPER, CPULOAD, CPUPOWERS, CURDATES)
VALUES([[ipvalue]], [[clocksvalue]], [[tempervalue]], [[loadvalue]], [[powervalue]], SYSDATE)

And then I removed the annotation.

The annotation was bad.

raluca_edu

17-Peridot

Hi,

Second service is correct, PracticeInsert, always an insert should be put in a SQL(Command).

Have you provided values for all the parameters? Try without "<< >>".

In the Application.log of Thingworx what error do you see? Can you please translate in English the SQL Exception?

Thank you,

Raluca Edu

K

KANGJAEHYUCK

AuthorAnswer