My goal is to eventually write java applications that will interact (through the Progress JDBC driver) with the Progress 9.1d databases we have running on an AIX server.
I'm currently attempting to write a little java program whose sole purpose is to connect to the database. It basically takes the following format:
1. Load JDBC driver
2. Connect
I.E.:
Class.forName("com.progress.sql.jdbc.JdbcProgressDriver");
Connection con = DriverManager.getConnection(url,usr,pw);
My problem is that I can't even get past compiling my little procedure.
I get the following error msgs:
1. java.lang.ClassNotFoundException;must be caught or declared to be thrown
2. java.sql.SQLException;must be caught or declared to be thrown
It seems that it can't find the driver.
I've gone through the documentation provided by Progress and made sure I have all the relevant files and have configured the environment variables appropriately (at least the way they instruct). Technically all is where it should be. In fact, I can connect successfully to a database with the SQL Explorer Tool (or so it tells me, but I can't seem to execute any queries) and from what I've read that should indicate a proper configuration.
I'm stumped and was hoping maybe someone else has worked through the same sort of problem.
Some other relevant info:
I'm using the JCreator IDE for my java programs and running Windows XP Pro SP2.
Thanks,
I'm currently attempting to write a little java program whose sole purpose is to connect to the database. It basically takes the following format:
1. Load JDBC driver
2. Connect
I.E.:
Class.forName("com.progress.sql.jdbc.JdbcProgressDriver");
Connection con = DriverManager.getConnection(url,usr,pw);
My problem is that I can't even get past compiling my little procedure.I get the following error msgs:
1. java.lang.ClassNotFoundException;must be caught or declared to be thrown
2. java.sql.SQLException;must be caught or declared to be thrown
It seems that it can't find the driver.
I've gone through the documentation provided by Progress and made sure I have all the relevant files and have configured the environment variables appropriately (at least the way they instruct). Technically all is where it should be. In fact, I can connect successfully to a database with the SQL Explorer Tool (or so it tells me, but I can't seem to execute any queries) and from what I've read that should indicate a proper configuration.
I'm stumped and was hoping maybe someone else has worked through the same sort of problem.
Some other relevant info:
I'm using the JCreator IDE for my java programs and running Windows XP Pro SP2.
Thanks,