Statement object using:

Question

I have Java code that connects to an SQL server DB but I cannot access the DB from the Java app. When I compiled the connection was successfully reported but I cannot execute any SQL statement. The error is that:

run:

The SQL connection was successful.
Exception in thread "main" java.lang.ClassCastException: com.microsoft.sqlserver.jdbc.SQLServerStatement cannot be cast to java.beans.Statement
        at project.getConnection.connection(getConnection.java:73)
        at project.Main.main(Main.java:31)
Java Result: 1
BUILD SUCCESSFUL (total time: 1 second)

here is the line 73 if i remove the (Statement)

 s = (Statement) connection.createStatement();

Isaac Truett · Accepted Answer · 2011-04-19 19:30:53Z

3

You want to import javax.sql.Statement, not java.beans.Statement.

answered Apr 19, 2011 at 19:30

Isaac Truett

8,8741 gold badge31 silver badges49 bronze badges

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

2 Comments

aida Over a year ago

sorry i run my java code after connecting to Db but i resived this error: run: The SQL connection was successful. JDBC Driver error:Invalid object name 'dbo.categories'. categories is an entity in my sql server DB thanks

Isaac Truett Over a year ago

@Aida That's a completely different problem. You should post it as a new question if you need help resolving it.

Collectives™ on Stack Overflow

Statement object using:

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related