RE: Subject: Issue with Reverse Engineering Sybase Database

From: McDaniel, Joe R. (mcdanij..igr.org)
Date: Fri Aug 13 2004 - 16:10:55 EDT

  • Next message: Andrus Adamchik: "Re: NullPointerException"

    I am having the same problem now. First, I found that unless I used the
    JDBC3 drivers, I got a message about unsupported character sets...

    com.sybase.jdbc2.jdbc.SybSQLException: Error converting characters into
    server's character set. Some character(s) could not be converted.

            at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2535)
            at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1916)
            at
    com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
            at
    com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:201)
            at
    com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:182)
            at
    com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1455)
            at
    com.sybase.jdbc2.jdbc.SybCallableStatement.executeQuery(SybCallableState
    ment.java:69)
            at
    com.sybase.jdbc2.jdbc.SybDatabaseMetaData.returnResults(SybDatabaseMetaD
    ata.java:2284)
            at
    com.sybase.jdbc2.jdbc.SybDatabaseMetaData.getTables(SybDatabaseMetaData.
    java:1747)
            at
    org.objectstyle.cayenne.access.DbLoader.getTables(DbLoader.java:242)
            at
    org.objectstyle.cayenne.access.DbLoader.loadDataMapFromDB(DbLoader.java:
    683)
            at
    org.objectstyle.cayenne.access.DbLoader.createDataMapFromDB(DbLoader.jav
    a:643)
            at
    org.objectstyle.cayenne.access.DbLoader.createDataMapFromDB(DbLoader.jav
    a:629)
            at
    org.objectstyle.cayenne.modeler.action.ImportDbAction.loadMap(ImportDbAc
    tion.java:317)
            at
    org.objectstyle.cayenne.modeler.action.ImportDbAction.importDb(ImportDbA
    ction.java:188)
            at
    org.objectstyle.cayenne.modeler.action.ImportDbAction.performAction(Impo
    rtDbAction.java:338)
            at
    org.objectstyle.cayenne.modeler.action.CayenneAction.actionPerformed(Cay
    enneAction.java:184)
            at
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764)
            at
    javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractB
    utton.java:1817)
            at
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.ja
    va:419)
            at
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257)
            at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
            at
    javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113
    )
            at
    javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(B
    asicMenuItemUI.java:943)
            at java.awt.Component.processMouseEvent(Component.java:5134)
            at java.awt.Component.processEvent(Component.java:4931)
            at java.awt.Container.processEvent(Container.java:1566)
            at java.awt.Component.dispatchEventImpl(Component.java:3639)
            at java.awt.Container.dispatchEventImpl(Container.java:1623)
            at java.awt.Component.dispatchEvent(Component.java:3480)
            at
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450)
            at
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165)
            at
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095)
            at java.awt.Container.dispatchEventImpl(Container.java:1609)
            at java.awt.Window.dispatchEventImpl(Window.java:1590)
            at java.awt.Component.dispatchEvent(Component.java:3480)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:450)
            at
    java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThrea
    d.java:197)
            at
    java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.
    java:150)
            at
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144)
            at
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136)
            at java.awt.EventDispatchThread.run(EventDispatchThread.java:99)

    Now I am getting the same problem you reported with this traceback:
    com.sybase.jdbc3.jdbc.SybSQLException: No such object or user exists in
    the database.
            at com.sybase.jdbc3.tds.Tds.processEed(Tds.java:2942)
            at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2246)
            at
    com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
            at
    com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220)
            at
    com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203)
            at
    com.sybase.jdbc3.jdbc.SybStatement.queryLoop(SybStatement.java:1698)
            at
    com.sybase.jdbc3.jdbc.SybCallableStatement.executeQuery(SybCallableState
    ment.java:103)
            at
    com.sybase.jdbc3.jdbc.SybDatabaseMetaData.returnResults(SybDatabaseMetaD
    ata.java:2543)
            at
    com.sybase.jdbc3.jdbc.SybDatabaseMetaData.getExportedKeys(SybDatabaseMet
    aData.java:2091)
            at
    org.objectstyle.cayenne.access.DbLoader.loadDbRelationships(DbLoader.jav
    a:460)
            at
    org.objectstyle.cayenne.access.DbLoader.loadDataMapFromDB(DbLoader.java:
    688)
            at
    org.objectstyle.cayenne.access.DbLoader.createDataMapFromDB(DbLoader.jav
    a:643)
            at
    org.objectstyle.cayenne.access.DbLoader.createDataMapFromDB(DbLoader.jav
    a:629)
            at
    org.objectstyle.cayenne.modeler.action.ImportDbAction.loadMap(ImportDbAc
    tion.java:317)
            at
    org.objectstyle.cayenne.modeler.action.ImportDbAction.importDb(ImportDbA
    ction.java:188)
            at
    org.objectstyle.cayenne.modeler.action.ImportDbAction.performAction(Impo
    rtDbAction.java:338)
            at
    org.objectstyle.cayenne.modeler.action.CayenneAction.actionPerformed(Cay
    enneAction.java:184)
            at
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
            at
    javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractB
    utton.java:1839)
            at
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.ja
    va:420)
            at
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
            at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
            at
    javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113
    )
            at
    javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(B
    asicMenuItemUI.java:943)
            at java.awt.Component.processMouseEvent(Component.java:5100)
            at java.awt.Component.processEvent(Component.java:4897)
            at java.awt.Container.processEvent(Container.java:1569)
            at java.awt.Component.dispatchEventImpl(Component.java:3615)
            at java.awt.Container.dispatchEventImpl(Container.java:1627)
            at java.awt.Component.dispatchEvent(Component.java:3477)
            at
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
            at
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
            at
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
            at java.awt.Container.dispatchEventImpl(Container.java:1613)
            at java.awt.Window.dispatchEventImpl(Window.java:1606)
            at java.awt.Component.dispatchEvent(Component.java:3477)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
            at
    java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThrea
    d.java:201)
            at
    java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.
    java:151)
            at
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
            at
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
            at
    java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

    I don't have time to try to debug this right now -- maybe next week some
    time.

    Best,

    Joe



    This archive was generated by hypermail 2.0.0 : Fri Aug 13 2004 - 16:11:57 EDT