Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Nice, France
    Posts
    9

    Question Unanswered: Still in trouble with Progress and JDBC

    Hello guys, I start wondering if it can be harder to connect to a Progress DB with JDBC!!!
    As I mentionned in a previous thread, documentation from Progress, and even from Sun didn't help me to figure out how and where to place and setup JDBC Progress Driver.
    Problems of classpath, path and right directories makes me wonder that I probably don't know how to read! Anyway...
    I thought I solved my problem since I didn't get the error message anymore concerning the loading of the driver. Well, now, it sends me an error as 'No Suitable Driver', even though I use the ones delivered by Progress and built by Merant. Also, when I check the log on the Progress server, no sign of connections appear.
    So, if someone could help me on getting this to work, that would be awesome!!

    Here is a code sample:

    import java.sql.*;

    public class JdbcCon {
    public static void main(String[] args) {

    String url = "jdbc:JdbcProgress:T:10.1.1.57:3050:vehi";
    //Or String url = "jdbc:JdbcProgress://lambda:3050/vehi";

    Connection con = null;

    try {

    Class.forName("com.progress.sql.jdbc.JdbcProgressD river");

    } catch (java.lang.ClassNotFoundException e) {
    System.err.print("ClassNotFoundException: ");
    System.err.println(e.getMessage());
    }

    //This prints out correctly
    System.out.println("Loading Driver Successful!!!");

    try {
    System.out.println("Before connection...");

    con = DriverManager.getConnection(url, "someone", "somethg");
    //Then it stops here

    System.out.println("After connection...");
    } catch (SQLException e) {
    System.err.print("SQLException: ");
    System.err.println(e.getMessage());
    System.err.print("Error code: ");
    System.err.println(e.getErrorCode());
    System.err.print("SQL State: ");
    System.err.println(e.getSQLState());
    } catch (StringIndexOutOfBoundsException ex) {
    System.err.print("StringIndexOutOfBoundsException: ");
    System.err.println(ex.getMessage());
    }
    }
    }

    3050 is the port by default to the Progress Db and 3060 is the ODBC port if I want to use an ODBC driver. None of them allows me to connect.
    The classpath contains the location of J2SDK\bin, progress.zip and jdbc.zip.

    I hope it will help you find out!! I continue to look for an answer.

    Thank you all!

  2. #2
    Join Date
    Sep 2003
    Location
    Nice, France
    Posts
    9

    Thumbs down

    Well, I have the definite answer for this JDBC Progress connection.
    In fact, Progress, on SCO unix machine DOES NOT support SQL92 and JDBC, despite the hundreds of documentations delivered explaining how to do it!
    I have to use SQL89 and find the drivers (if possible free!) for Jdbc.
    If anyone can help!! I know that DataDirect has it but it is not free.
    Let me know, thx!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •