Description of problem: Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
Barry LaFond <blafond> made a comment on jira TEIIDDES-1920 Lucie, Can you verify that you can successfully Test Connection in the Connection profile wizard? If Data Tools can't connect to your Sybase instance with your attached driver jar, then it's an Eclipse/Sybase issue and not a Designer issue.
Lucie Fabrikova <lfabriko> made a comment on jira TEIIDDES-1920 I can click on Test connection in the connection profile wizard "New Sybase ASE Connection Profile", on page "Specify a Driver and Connection Details" and the ping succeeds.
Lucie Fabrikova <lfabriko> made a comment on jira TEIIDDES-1920 Clicking on Test connection in the connection profile wizard "New Sybase ASE Connection Profile", on page "Specify a Driver and Connection Details": - Attached driver jconn4-26666.jar: ping fails - newly attached driver jconn4-26502.jar: ping succeeds, source model cannot be created
Van Halbert <vhalbert> made a comment on jira TEIIDDES-1920 Lucie, Have you been able to get any sybase driver to work that allows you to import and create the source model?
Barry LaFond <blafond> made a comment on jira TEIIDDES-1920 I was able to test connection and import into Teiid Designer using 1) jconn4-26502.jar and.... 2) used the Sybase JDBC Driver for Sybase ASA 10.x driver definition option 3) specified the driver class as: com.sybase.jbdc4.jdbc.SybDriver 4) Used a QE Sybase instance for BQT2, with port == 5000 There are 2 groups of Sybase connection profiles (ASE and ASA) and multiple flavors/versions for each of those. So I think you'll need to be clear/concise with your driver type in this test.
Barry LaFond <blafond> made a comment on jira TEIIDDES-1920 I was able to test connection and import into Teiid Designer using 1) jconn4-26502.jar and.... 2) used the Sybase JDBC Driver for Sybase ASA 10.x driver definition option 3) specified the driver class as: com.sybase.jbdc4.jdbc.SybDriver 4) Used a QE Sybase instance for BQT2, with port == 5000 There are 2 groups of Sybase connection profiles (ASE and ASA) and multiple flavors/versions for each of those. So I think you'll need to be clear/concise with your driver type in this test. NOTE: Both Preview Data fails for the imported tables as does Execute VDB containing the Sybase model.
Barry LaFond <blafond> made a comment on jira TEIIDDES-1920 I was able to test connection and import into Teiid Designer using 1) jconn4-26502.jar and.... 2) used the Sybase JDBC Driver for Sybase ASA 10.x driver definition option 3) specified the driver class as: com.sybase.jbdc4.jdbc.SybDriver 4) Used a QE Sybase instance for BQT2, with port == 5000 There are 2 groups of Sybase connection profiles (ASE and ASA) and multiple flavors/versions for each of those. So I think you'll need to be clear/concise with your driver type in this test. NOTE: * Preview Data fails for the imported tables * Execute VDB containing the Sybase model. * Sample Contents fails using the Data Tools direction Connection to the DB
Barry LaFond <blafond> made a comment on jira TEIIDDES-1920 I was able to test connection and import into Teiid Designer using 1) jconn4-26502.jar and.... 2) used the Sybase JDBC Driver for Sybase ASA 10.x driver definition option 3) specified the driver class as: com.sybase.jbdc4.jdbc.SybDriver 4) Used a QE Sybase instance for BQT2, with port == 5000 There are 2 groups of Sybase connection profiles (ASE and ASA) and multiple flavors/versions for each of those. So I think you'll need to be clear/concise with your driver type in this test. NOTE: * Preview Data fails for the imported tables * Execute VDB fails containing the same Sybase mode/tables * Sample Contents fails using the Data Tools direction Connection to the DB
Lucie Fabrikova <lfabriko> made a comment on jira TEIIDDES-1920 I reproduced the import described in Barry's previous comment; - the preview of data gives the same error message in log as described in TEIID-2730. @Van Halbert: My original setup was Sybase ASE 15.x, jconn4-25602 and I couldn't complete the import wizard from the bqt2 database (but from a different one, with different structure, I could).
Lucie Fabrikova <lfabriko> made a comment on jira TEIIDDES-1920 I reproduced the import described in Barry's previous comment; - the preview of data gives the same error message in log as described in TEIID-2730. @Van Halbert: My original setup was Sybase ASE 15.x, jconn4-25602 and I couldn't complete the import wizard from the bqt2 database (but from a different database, with different structure, I could).
Lucie Fabrikova <lfabriko> made a comment on jira TEIIDDES-1920 I reproduced the import described in Barry's previous comment; - the preview of data gives the same error message in log as described in TEIID-2730. @Van Halbert: My original setup was Sybase ASE 15.x, jconn4-25602 and I couldn't complete the import wizard from the bqt2 database (but from a different database, with different structure, I could). The model can be imported with jconn4-25602 and Sybase ASA 10.x.
Barry LaFond <blafond> made a comment on jira TEIIDDES-1920 Data Tools Connection Profile for jconn4-26502.jar
Barry LaFond <blafond> updated the status of jira TEIIDDES-1920 to Resolved
Barry LaFond <blafond> made a comment on jira TEIIDDES-1920 Was able to create proper connection profile (attached), connect to sybase, sample data (data tools) and import model.
Barry LaFond <blafond> updated the status of jira TEIIDDES-1920 to Closed