jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes jdbc compilation error too weird Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc compilation error too weird" Watch "jdbc compilation error too weird" New topic

jdbc compilation error too weird

gopal krishnan

Joined: Dec 17, 2007
Posts: 18
i am trying to execute the below simple java program
but i am getting the below error..

getting the below compilation error, seems to be too weired.

C:\Documents and Settings\gopc\workspace\JDBC_Connection\src>javac SqlConnection.java
SqlConnection.java:9: error: incompatible types
con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Acess Driver (*.accdb)}; DBQ=C:\\Users\\gopc\\odbc_sql.accdb","","");
required: Connection
found: java.sql.Connection
SqlConnection.java:10: error: cannot find symbol
Statement statement = con.createStatement();
symbol: method createStatement()
location: variable con of type Connection
2 errors

C:\Documents and Settings\gopc\workspace\JDBC_Connection\src>

Campbell Ritchie

Joined: Oct 13, 2005
Posts: 44616
What does it say in the getConnection method documentation?
Have you got another Connection class of your own?
gopal krishnan

Joined: Dec 17, 2007
Posts: 18
i'm not defining it.. using the existing..
Wendy Gibbons

Joined: Oct 21, 2008
Posts: 1107

on the line you declare the con variable explicitly give the whole lot: java.sql.connection (getting the case correct).
and the same for driver mananger java.sql.DriverManager.
Just to see if somehow you are not using the classes you expect to be.
Matthew Brown

Joined: Apr 06, 2010
Posts: 4541

It does look like you have another Connection class in the same package. Possibly a compiled version that's hanging around even if you've deleted the source code. If you examined what Connection.class referred to it would confirm it.
I agree. Here's the link: http://aspose.com/file-tools
subject: jdbc compilation error too weird
It's not a secret anymore!