Oracle Error 942 Java.sql.sqlsyntaxerrorexception
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle DB table or view does not exist [closed] up vote -1 down vote favorite 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") java sql oracle share|improve this question edited Feb 7 '14 at 1:37 asked Feb 7 '14 at 1:28 Rajith Shanika 56210 closed as off-topic by Jim Garrison, Jayan, gpoo, Adam, Dhaval Marthak Feb 7 '14 at 7:49 This question appears to be off-topic. The users who voted to close gave this specific reason:"This question appears to be off-topic because it lacks sufficient information to diagnose the problem. Describe your problem in more detail or include a minimal example in the question itself." – Jim Garrison, Jayan, gpoo, Adam, Dhaval MarthakIf this question can be reworded to fit the rules in the help center, please edit the question. 1 Please post the code that results in your error. –rgettman Feb 7 '14 at 1:30 Are you connecting as the same user as you connected with in sqldeveloper? This error usually results from you not having select permission or the table is in another schema and there are no synonyms. –DCookie Feb 7 '14 at 1
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users http://stackoverflow.com/questions/21617648/oracle-db-table-or-view-does-not-exist Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Getting an exception ORA-00942: table or view does not exist - when http://stackoverflow.com/questions/6561650/getting-an-exception-ora-00942-table-or-view-does-not-exist-when-inserting-in inserting into an existing table up vote 7 down vote favorite 1 I am getting below exception, when trying to insert a batch of rows to an existing table ORA-00942: table or view does not exist I can confirm that the table exists in db and I can insert data to that table using oracle sql developer. But when I try to insert rows using preparedstatement in java, its throwing table does not exist error. Please find the stack trace of error below java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1889) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093) at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047) at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout>>(OracleStatement.java:2709) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) at quotecopy.DbConnection.insertIntoDestinationDb(DbConnection.java:591) at quotecopy.QuoteCopier.main(QuoteCopier.java:72) Can anyone suggest the reasons for this error ? Update : Issue solved There was no problem with my database connection properties or
and JChem Oracle Cartridge ORA-00942: table or view does not exist ORA-00942: table or view does not exist To watch this topic for replies Register (enables digests) or give email address: Display https://www.chemaxon.com/forum/ftopic943.html posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First View previous topic :: View next topic Author Message Julie Joined: 30 Dec 2004 Posts: 27 Back to top Posted: Tue Oct 11, 2005 9:35 pmPost subject: ORA-00942: table or view does not exist System: Oracle9i Enterprise Edition Release 9.2.0.6.0 Red Hat Linux 7.3 2.96-110 JChem v3.1.1 (upgrade from 3.0.13) I'd oracle error like to reference user prous, and their topic "Error updating structures table" I have a similar setup: I have a user JCHEM, in the oracle database, which is the owner of all JChem objects, structure table and property table. This user JCHEM does all maintenance on the tables he owns, in his schema, JCHEM....so I don't have the same permission problem on the sequence that user prous oracle error 942 had. I used jcman to regenerate the structure table, after installing jchem3.1.1, and when it finished, a window popped up with the message: SQL Warning SQL State:42000 Message ORA-00942: table or view does not exist Vendor: 942 Some background: Like user prous, I also have a java application which maintains the structure table. It's kicked off with a shell script on the Linux box. It updates the JCHEM.STRUCTURE table when we add a new structure to an MDL database, external to JCHEM. To test whether a JChem upgrade, and the subsequent regeneration works, I usually delete a few structures from the existing JCHEM.STRUCTURE table, start the script that runs the java, and those deleted structures are found in the MDL database and added back to the JCHEM.STRUCTURE table. Back to the error: I checked after the upgrade, and noticed no missing tables...I deleted a few structures from JCHEM.STRUCTURE, and ran my script, to see if that might shed more light on this error message. As with user prous, the deleted structures were imported correctly into the JCHEM.STRUCTURE table, but I got another ORA-000942: java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Pro