Re: Problems with schema reverse engineer on Sybase 12.5.4 Solaris

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Jan 09 2007 - 13:45:37 EST

  • Next message: jerome moliere: "Re: Problems with schema reverse engineer on Sybase 12.5.4 Solaris"

    Since different frameworks behave the same, this points to a JDBC
    issue. Other than the obvious advice to check for the latest driver
    from Sybase, you may also try the jTDS driver, sometimes it works
    better than the vendor driver:

    http://jtds.sourceforge.net/

    Andrus

    On Jan 8, 2007, at 8:06 PM, jerome moliere wrote:

    > Hi all,
    > I'm facing a strange problem while reverse engineering with the
    > modeller my
    > schema living on a sybase host
    > (Solaris / 12.5.4).... It must be a tricky problem because
    > Hibernate tools
    > have the same problem:
    > both tools are unable to see primary keys !!!! or any other kind of
    > relations (foreign keys)..
    >
    > It's strange because with a ten lines program I can list the
    > primary keys
    > (same result as the sp_helpconstraint stored procedure)
    > greping through the code I can't find any usage from the
    > DatabaseMetadata.getPrimaryKeys()? strange isn't it ?
    > I guess that there must a better (unknown from me) while trying to
    > do a
    > reverse engineer from a schema ?
    >
    > Any pointer/remark welcome
    > cheers
    > Jerome
    > PS:
    > excuse my poor english written
    >
    > --
    > Jerome Moliere - Mentor/J
    > http://romjethoughts.blogspot.com/
    > auteur Eyrolles



    This archive was generated by hypermail 2.0.0 : Tue Jan 09 2007 - 13:46:10 EST