Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-1920

Cannot create relational source with Sybase jconn4.jar

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Blocker
    • 8.3
    • 8.3
    • Import/Export
    • None
    • Hide

      1. add module sybase to DV6.ER3 (jboss-eap-6.1/modules/system/layers/dv/com/sybaseDS/sybase/main), add driver to standalone.xml
      2. in teiid designer, create connection profile to sybase database with jconn4.jar
      3. Create source model from jdbc connection profile -> select the profile -> click Next

      Show
      1. add module sybase to DV6.ER3 (jboss-eap-6.1/modules/system/layers/dv/com/sybaseDS/sybase/main), add driver to standalone.xml 2. in teiid designer, create connection profile to sybase database with jconn4.jar 3. Create source model from jdbc connection profile -> select the profile -> click Next

    Description

      Creating a relational source model from jdbc connection profile to Sybase database (1st page of wizard, connecting to database of given profile) which uses jconn4.jar results in error message :
      java.sql.SQLException: JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation.
      at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybConnection.handleSQLE(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybConnection.checkMDA(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybConnection.getMDA(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybLob.<init>(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybCharClientLob.<init>(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybConnection.resetNullLobs(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybConnection.init(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybConnection.<init>(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybConnection.<init>(Unknown Source)
      at com.sybase.jdbc4.jdbc.SybDriver.connect(Unknown Source)
      at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:298)
      at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
      at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
      at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:81)
      at org.eclipse.datatools.enablement.sybase.ase.internal.connection.JDBCASEConnectionFactory.createConnection(JDBCASEConnectionFactory.java:32)
      at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
      at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
      at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
      at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
      at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)

      Errors log:
      Modeler Core Exception: Status ERROR: org.teiid.core.designer code=0 JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation. null
      at org.teiid.designer.jdbc.JdbcManagerImpl.createConnection(JdbcManagerImpl.java:202)
      at org.teiid.designer.jdbc.JdbcManagerImpl.createConnection(JdbcManagerImpl.java:211)
      at org.teiid.designer.jdbc.ui.util.JdbcUiUtil$1.run(JdbcUiUtil.java:80)
      at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

      Attachments

        1. bqt2_sybase_ase_CP.xml
          3 kB
        2. jconn4-26502.jar
          578 kB
        3. jconn4-26666.jar
          1.37 MB

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. TEIID-2730 Cannot query Sybase database with jconn3.jar

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              blafond Barry LaFond
              lfabriko@redhat.com Lucie Krejcirova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: