I need to connect oracle database in JDBC step in DevTest.
I tried following format for connection info:
connect string :- jdbc:oracle:thin:username/password@//host/DBname
I could test the connection successfully, however, I am not able to run and sql query and getting error "There was a SQLException: java.sql.SQLException: ORA-00933: SQL command not properly ended"
for the following sql command:
SELECT XX FROM AX.XARX;
Can you please help me in case:
1) If I am incorrectly creating the connection.
2) If I am writing the query in a wrong way.
3) If you have worked with oracle DB in DevTest.
There is one more thing that I need to tell:
In oracle database named DBname I am able to log in using sqldeveloper but I could not see any table under tables field. However, I have to go to the "Other Users" field and there I could see all the tables under "table" field.