[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Originally posted by Sue Hunt:
Jeanne thanks for that.
I've managed to get it to compile and it's loading the connection to the database and I have set up the odbc connection in the control panel.
It's running through the program, prompting the user to input, however, I am unable to get it to return any value from the database.
Also, it doesn't like the line query=cn.createStatement(), however, if I comment it out, the program, does compile.
Really happy it's compiling...
Cheers
Sue
Ever Existing, Ever Conscious, Ever-new Bliss
Originally posted by Sue Hunt:
Deep Bowing.
Thanks for pointing out the c in CreateStatement...should be createStatement. That now compiled.
I've added another try towards the end, before the catch statement.
It compiles nicely, and then it gives me the prompts, however, when I select C, it then gives me the choices of cars to pick from, when I pick BMW, it gives me this
Problem accessing the database java.sql.SQLException: [Microsfot][ODBC Microsoft Access Driver] The Microsoft Jet database enging cannot find the input table or query �Employee�. Make sure it exists and that its name is spelled correctly.
If I pick A, I get this error.
Problem accessing the database java.sql.SQLException: Column not found
If I pick B, it prompts me for the salary amount, and then I get this error.
Problem accessing the database java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
If I pick Q, I get this error.
Problem accessing the database java.sql.SQLException: Invalid handle
(I'm not overly good at Access, either....)
You guys have patience of saints. I know I keep saying it, but you all help to keep me sane, and I really do appreciate it.
I'm wondering, although I mapped the ODBC to go to the folder that is holding the company database, I'm wondering if it should be in the same folder as the class.
Sue
Ever Existing, Ever Conscious, Ever-new Bliss
Originally posted by Sue Hunt:
Sadanand
It seems that the quit does stop the processing, however, when you select q, it will give you the close message, however, it then gives you the final catch message,
Problem accessing the database java.sql.SQLException: Invalid handle
Not sure how to get it so it doesn't print that line, when quit is selected.
Probably something glaringly obvious, but it's been over a week and almost 8 hours a day, trying to sort it out, and I'm brain dead...
Thanks again for the assistance.
Sue
[ May 05, 2004: Message edited by: Sue Hunt ]
Ever Existing, Ever Conscious, Ever-new Bliss
Originally posted by Sue Hunt:
Keep forgetting to do that...re: posting the code again
Thanks
Sue
Ever Existing, Ever Conscious, Ever-new Bliss