CODEWITHSUNDEEP
javadatabaseoracle-databaseoracle-sqldevelopersoda
Maddin
Maddin

Reputation: 184

Can't SELECT on a document store added in SODA in Java Application

I have written a little application to add documents to a collection in an Oracle Express Edition 18c database. I use the SODA library to do so.

OracleCollection col = db.admin().createCollection("MyJSONCollection");

Now, I want to select all entries in SQLDeveloper. The table is listed among all other tables, and i can view that it has the contents, i gave it in my program, but I got the message undefined table when trying to SELECT, and when executing the command, it won't find it. (table or view does not exist)

SELECT * FROM MyJSONCollection;

What am I missing here?

Upvotes: 0

Views: 131

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22427

try

SELECT * FROM "MyJSONCollection";

How does the table show in the navigator in SQL Developer? Is it all uppercase or is it case sensitive?

Upvotes: 1

Related Questions