The examples as shipped don't contain this line, so I am assuming that you are modifying the example to make use of MySQL. I suspect you need to call the prepareStatement() method on the Connection object. However, I wanted to make sure you are aware that RTI offers an off-the-shelf Database Integration Service with bidirectional integration; samples received can be stored in tables, and data inserted into tables can be published in Topics.
Yes I'm modifying the example with the help of MySQL. I have inserted the following into my program and the result is as shown in the pic(above). Not sure if the code below is the correct way to write it. (I'm using Visual Studio Code to write the Java example program of "Hello_World").
I hoped you might try my previous suggestion on the syntax: PreparedStatement(sql) --> prepareStatement(sql). Also, have you looked at Database Integration Service and concluded it doesn't suit your use case?
Your code appears to be referring to something that the compiler doesn't understand. When your code is compiled, the compiler needs to work out what each and every identifier in your code means. As the compiler is going through the code it will find something and know what to do with it or not. The general causes for a Cannot find symbol error are things like:
Incorrect spelling.
Wrong case. Halo is different from halo.
Improper use of acceptable identifier values (letters, numbers, underscore, dollar sign), my-class is not the same as myclass.
No variable declaration or variable is outside of the scope you are referencing it in.
The examples as shipped don't contain this line, so I am assuming that you are modifying the example to make use of MySQL. I suspect you need to call the prepareStatement() method on the Connection object. However, I wanted to make sure you are aware that RTI offers an off-the-shelf Database Integration Service with bidirectional integration; samples received can be stored in tables, and data inserted into tables can be published in Topics.
Regards,
Tom
Yes I'm modifying the example with the help of MySQL. I have inserted the following into my program and the result is as shown in the pic(above). Not sure if the code below is the correct way to write it. (I'm using Visual Studio Code to write the Java example program of "Hello_World").
I hoped you might try my previous suggestion on the syntax: PreparedStatement(sql) --> prepareStatement(sql). Also, have you looked at Database Integration Service and concluded it doesn't suit your use case?
Your code appears to be referring to something that the compiler doesn't understand. When your code is compiled, the compiler needs to work out what each and every identifier in your code means. As the compiler is going through the code it will find something and know what to do with it or not. The general causes for a Cannot find symbol error are things like: