This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes myCon not recognised Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "myCon not recognised" Watch "myCon not recognised" New topic

myCon not recognised

Ian Cockcroft
Ranch Hand

Joined: Apr 05, 2001
Posts: 46
Hi all.
The following code is just a little utility to read data from a DAT file and put it in an access database.

(Its nothing special, I'm sure you guys have a better way of doing this.)
I am getting an error when I compile that it doesnt recognise myCon.
------- Compiler Output ------ cannot resolve symbol
symbol : variable myCon
location: class UpdateAccessUtility
Statement stm = myCon.createStatement();

Any ideas? I have declared it in the same class.
Thanks guys

- Make it idiot proof and they'll make a better idiot!
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
You declare adn intialize myCon in a try block so that the variable is local to that block. Move the declaration outside of the block and you'll be ok with that part. You're going to need to catch the SQLException that can be thrown by that statement though. All you catch is an IOException after that try block.
hope that helps

I agree. Here's the link:
subject: myCon not recognised
It's not a secret anymore!