[JBoss JIRA] Created: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
9:05 p.m.
Designer importer fails to correctly import metadata from Sybase when using the JConnect
driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Fix For: 7.1.1
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:17 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIIDDES-666:
---------------------------------------
The defect from hell 666, be scared..
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Fix For: 7.1.1
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:19 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Paul Nittel updated TEIIDDES-666:
---------------------------------
Attachment: SybaseImportError.txt
Here's an exception I found in the Designer's log. Looks pertinent.
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Fix For: 7.1.1
Attachments: SybaseImportError.txt
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:37 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIIDDES-666:
---------------------------------------
I see this stack in my eclipse log
!ENTRY org.teiid.designer.jdbc 2 0 2010-10-19 14:24:06.627
!MESSAGE Unexpected exception while calling
com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getTableTypes() and processing results on
DatabaseNew Sybase ASE
!STACK 0
com.sybase.jdbc3.jdbc.SybSQLException: '"'TABLE '"' is
not a valid type name.
at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
at com.sybase.jdbc3.jdbc.SybCallableStatement.executeQuery(Unknown Source)
at com.sybase.jdbc3.jdbc.SybDatabaseMetaData.if(Unknown Source)
at com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getTables(Unknown Source)
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Fix For: 7.1.1
Attachments: SybaseImportError.txt, SybaseImportError_2.txt,
SybaseImportError_3.txt
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:37 p.m.
New subject: [JBoss JIRA] Updated: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Paul Nittel updated TEIIDDES-666:
---------------------------------
Attachment: SybaseImportError_2.txt
SybaseImportError_3.txt
Ought to check on these exceptions as well.
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Fix For: 7.1.1
Attachments: SybaseImportError.txt, SybaseImportError_2.txt,
SybaseImportError_3.txt
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:48 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIIDDES-666:
---------------------------------------
Looking through Sybase jConnect documentation, it looks like there is stored procedure you
need to run against it before it can report the tables correctly, this needs to be tested
again. Check the zip file for the doc and instructions.
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Fix For: 7.1.1
Attachments: SybaseImportError.txt, SybaseImportError_2.txt,
SybaseImportError_3.txt
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:41 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIIDDES-666:
---------------------------------------
Test sybase db's mater db is full to run the above stored procedures to test the above
instructions; so there may not be issue with Designer but can not validate at this time.
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Fix For: 7.1.1
Attachments: SybaseImportError.txt, SybaseImportError_2.txt,
SybaseImportError_3.txt
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:09 p.m.
New subject: [JBoss JIRA] Assigned: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Barry LaFond reassigned TEIIDDES-666:
-------------------------------------
Assignee: Paul Nittel
Based on Ramesh's comments, can you verify it's a Designer issue and not a Sybase
Setup issue? THx
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Paul Nittel
Fix For: 7.1.1
Attachments: SybaseImportError.txt, SybaseImportError_2.txt,
SybaseImportError_3.txt
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:27 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Paul Nittel commented on TEIIDDES-666:
--------------------------------------
Graciously accepting the challenge, I tried importing from another Sybase instance
(QE's version of BQT) and had the same experience. Can anyone point me to a
"good" Sybase instance?
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Paul Nittel
Fix For: 7.1.1
Attachments: SybaseImportError.txt, SybaseImportError_2.txt,
SybaseImportError_3.txt
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:34 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIIDDES-666:
---------------------------------------
Even if you select another database you need to run those procedures that come with the
driver before any JDBC connection can be attempted. At least that is what their document
says.
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Paul Nittel
Fix For: 7.1.1
Attachments: SybaseImportError.txt, SybaseImportError_2.txt,
SybaseImportError_3.txt
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:08 p.m.
New subject: [JBoss JIRA] Commented: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Paul Nittel commented on TEIIDDES-666:
--------------------------------------
I tried it with SQuirreL and jconn3.jar. The little rodent was able to successfully access
the metadata and display it. Ramesh and I agree it looks to be in the Designer. Sorry.
:-(
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Paul Nittel
Fix For: 7.1.1
Attachments: SybaseImportError.txt, SybaseImportError_2.txt,
SybaseImportError_3.txt
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:33 p.m.
New subject: [JBoss JIRA] Resolved: (TEIIDDES-666) Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
[
https://jira.jboss.org/browse/TEIIDDES-666?page=com.atlassian.jira.plugin...
]
Barry LaFond resolved TEIIDDES-666.
-----------------------------------
Assignee: Barry LaFond (was: Paul Nittel)
Resolution: Done
Sybase getTableTypes() was returning strings with extra space characters. i.e. "TABLE
". Just needed to add a trim() method call when loading the types viewer
table.
Designer importer fails to correctly import metadata from Sybase when
using the JConnect driver
-----------------------------------------------------------------------------------------------
Key: TEIIDDES-666
URL: https://jira.jboss.org/browse/TEIIDDES-666
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.1.1
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.1.1
Attachments: SybaseImportError.txt, SybaseImportError_2.txt,
SybaseImportError_3.txt
We have found that importing from sybase using their JConnect driver fails to correctly
import metadata. (It doesn't see the user tables.) However, using DTP and the
connection built by the import process, we can successfully query the database. So the
connection is good and the database accessible.
If I use the generic JTDS driver, it's all good (from what I've seen).
I can provide drivers for your use, if necessary.
Connection info:
jdbc:sybase:Tds:slntds17.mm.atl2.redhat.com:5000/bqt2
jdbc:jtds:sybase://slntds17.mm.atl2.redhat.com:5000/bqt2
Username is bqt2; password is metamatrix
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5170
days inactive
5192
days old
teiid-designer-issues@lists.jboss.org
11 comments
3 participants
participants (3)
-
Barry LaFond (JIRA) -
Paul Nittel (JIRA)
-
Ramesh Reddy (JIRA)