I am currently writing my first
Java program which is intended to talk to an Oracle database. I have an Oracle db setup, version 8i.
I have looked through online tutorials as to how to make my db query an Oracle db. However, "import oracle.sql.*" and "import oracle.jdbc.driver.*" give me the error "Package oracle.sql not found in import".
Through reading this board, I saw some of you mention that you had to make sure that classes12.zip was in your CLASSPATH. So I placed it there. Still get the same errors.
The database is currently being run locally on the same machine... just to make it easier for me to play with the db and my program at the same time.
I am not quite sure how my code I already have in my program for Oracle will work, logging into the db as well as queries and inserts, but I cannot even try yet until these imports work.
Suggestions would be greatly appreciated. And a little example snippet of code to log into a db in the main would be great as well... just so I can compare it to mine when I figure that mine probably will not work once the imports do.
I am running Visual Cafe 4.0 for a Java Compiler.