Bug 1028379

Summary:	Cannot create relational source with Sybase jconn4.jar
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Lucie Fabrikova <lfabriko>
Component:	Tooling	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED WONTFIX	QA Contact:
Severity:	urgent	Docs Contact:
Priority:	unspecified
Version:	6.0.0	CC:	atangrin, fnguyen, lfabriko, vhalbert
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2013-11-21 14:03:20 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Bug Depends On:	1028380
Bug Blocks:

Description Lucie Fabrikova 2013-11-08 10:32:14 UTC

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:

Comment 2 JBoss JIRA Server 2013-11-08 15:03:19 UTC

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.

Comment 3 JBoss JIRA Server 2013-11-11 08:05:46 UTC

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.

Comment 4 JBoss JIRA Server 2013-11-11 08:10:42 UTC

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

Comment 6 JBoss JIRA Server 2013-11-19 14:49:54 UTC

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?

Comment 7 JBoss JIRA Server 2013-11-19 16:58:40 UTC

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.

Comment 8 JBoss JIRA Server 2013-11-19 19:10:32 UTC

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.

Comment 9 JBoss JIRA Server 2013-11-19 19:25:45 UTC

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

Comment 10 JBoss JIRA Server 2013-11-19 19:26:37 UTC

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

Comment 11 JBoss JIRA Server 2013-11-20 08:57:33 UTC

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).

Comment 12 JBoss JIRA Server 2013-11-20 08:59:09 UTC

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).

Comment 13 JBoss JIRA Server 2013-11-20 09:01:53 UTC

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.

Comment 14 JBoss JIRA Server 2013-11-20 15:40:51 UTC

Barry LaFond <blafond> made a comment on jira TEIIDDES-1920

Data Tools Connection Profile for jconn4-26502.jar

Comment 15 JBoss JIRA Server 2013-11-20 15:43:34 UTC

Barry LaFond <blafond> updated the status of jira TEIIDDES-1920 to Resolved

Comment 16 JBoss JIRA Server 2013-11-20 15:43:34 UTC

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.

Comment 18 JBoss JIRA Server 2014-05-07 21:04:19 UTC

Barry LaFond <blafond> updated the status of jira TEIIDDES-1920 to Closed