I'm trying to connect a Oracle database to my JAVA web project.
and when creating the connection to the database using system user connection is successfully established.
But when I execute a simple select * command in the connection it says
Error code 942, SQL state 42000: ORA-00942: table or view does not exist.
These sql queries work in sqldeveloper. No errors.
I'm using oracle 10g thin client ojdbc6 driver and jdk 1.7
what can be the problem?
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Error Code: 942
Call: SELECT USERID, FULLNAME, USERNAME, USER_CREDENTIALSID, USER_TYPEID FROM USERS
Query: ReadAllQuery(referenceClass=Users sql="SELECT USERID, FULLNAME, USERNAME, USER_CREDENTIALSID, USER_TYPEID FROM USERS")
解决方案
Problem was connecting as the system user. I saw an account in oracle administration page called JPAMAGAZINE. connected using that account and it worked.