Error while runneing select query in sql developer

Question

I am using Oracle SQL Developer version 4.1.0.19. So this can be a very simple issue but I cannot seem to find the solution anywhere as I have just started using SQL Developer. I type in this query

create table Student(Stu_id INTEGER,Stu_name VARCHAR(60),Stu_email VARCHAR(60))
select * from Student

And when I Run the SELECT query, I get an error something like this:

Method oracle/jdbc/driver/T4CCallableStatement.isClosed()Z is abstract

I have no idea as to why this is happening , this may be very stupid but I cannot seem to find a solution. BTW I am using Oracle 11g version.

In a reply to an answer by another poster (now deleted by that responder), you said you have TWO statements: the CREATE TABLE and then the SELECT. But in your post you don't have the semicolons you have in that reply to the deleted answer, and you say "I type in this query" - which is singular, not plural. Please edit your post to correct the grammar and to add the semicolons - I read your post exactly the same way as that other responder, and I saw your corrections only there. They belong in the original post. — user5683823
– user5683823, Commented Jun 26, 2017 at 3:22

thatjeffsmith · Accepted Answer · 2017-06-25 18:42:22Z

1

How did you install SQL Developer? Can you download the zip off of OTN and extract it to a fresh directory and try running it from there?

Your error message indicates something VERY bad is wrong with one of the drivers. Which makes me wonder if you messed with one of the JARs or are attempting to use an old Oracle Client with a THICK connection.

answered Jun 25, 2017 at 18:42

thatjeffsmith

22.7k6 gold badges44 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Sanya Over a year ago

I was given the setup by someone. Sure let me just download the zip. I'll update you.

thatjeffsmith Over a year ago

what do your connection properties look like and what version of Java are you running?

Mark Rotteveel Over a year ago

The error doesn't mean that "something VERY bad is wrong", it means the driver is very old (pre-Java 6), as Statement.isClosed was introduced in Java 6 / JDBC 4.0

thatjeffsmith Over a year ago

@MarkRotteveel And for the driver to be very old means something very bad is wrong.

Collectives™ on Stack Overflow

Error while runneing select query in sql developer

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related