Advantage Database server connection

Question

I am very new to Advantage Database Server.

I am trying to connect to a ADS database using Java. Please give me a step by step solution how to do this.

I installed the necessary JAR file, but still can not connect.

Here is my connection code.

Connection.java

public Connection getConnection() {
    Connection conn = null;
    try {
        Driver dr = (Driver) Class.forName(
          "com.extendedsystems.jdbc.advantage.ADSDriver"
        ).newInstance();
        System.out.println(
              dr.getClass() 
            + " getMajorVersion() **" 
            + Integer.toString( dr.getMajorVersion() )
            + "  .getMinorVersion() **" 
            + Integer.toString( dr.getMinorVersion() )
        );
        conn = DriverManager.getConnection(
          "jdbc:extendedsystems:advantage://server:6262;
                  catalog =C:\\Program Files (x86)\Advantage 11.10\\testDemoExample.add","adssys","adssys"
        );
    } catch (Exception er) {
        er.printStackTrace();
    }
    return conn;
}

PS: Maybe this question is already been asked before, but i could not find a proper solution.

How does your function behave? What error messages do you get? — Jens Mühlenhoff, Dec 05 '14 at 10:50
Do you get an exception? An error message? You've not provided any information about what happens when you execute the code you've posted. — Ken White, Dec 11 '14 at 00:16

Nikunj Panelia · Answer 1 · 2015-01-20T04:49:48.510

0

Remove "testDemoExample.add" from catalog path if you are using free tables and if you are using database table, change \\ to // in catalog path.

edited Jan 20 '15 at 04:49

answered Jan 20 '15 at 04:12

Nikunj Panelia

1
1

Advantage Database server connection

1 Answers1