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

I want to save data in oracle

SOLVED
Regular Member

I want to save data in oracle

question1.PNGquestion2.PNG

question3.PNG

 

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?

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: I want to save data in oracle

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.

 

View solution in original post

2 REPLIES 2

Re: I want to save data in oracle

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

Re: I want to save data in oracle

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.

 

View solution in original post