AnsweredAssumed Answered

oracle DB in DevTest

Question asked by sharmadm on Oct 24, 2017
Latest reply on Oct 24, 2017 by sharmadm

I need to connect oracle database in JDBC step in DevTest.

I tried following format for connection info:

jdbc:- oracle.jdbc.driver.OracleDriver

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:



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.