Re: Problems with schema reverse engineer on Sybase 12.5.4 Solaris

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Jan 10 2007 - 10:18:32 EST

  • Next message: Andrus Adamchik: "Re: nested dataContexts"

    This is the class that we are using. It does call "getPrimaryKeys(..)"

    http://tinyurl.com/ylzfzb

    Andrus

    On Jan 10, 2007, at 11:42 AM, jerome moliere wrote:

    > 2007/1/9, Andrus Adamchik <andru..bjectstyle.org>:
    >>
    >> 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/
    >
    >
    > As stated in my previous message, I made a few code lines in JDBC
    > using meta
    > data and it works perfectly...
    > Moreover I can't find in your code usage from the
    > DatabaseMetaData.getPrimaryKeys() method so how do you fetch this
    > information?
    >
    >
    > 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
    >>
    >>
    >
    >
    > --
    > Jerome Moliere - Mentor/J
    > http://romjethoughts.blogspot.com/
    > auteur Eyrolles



    This archive was generated by hypermail 2.0.0 : Wed Jan 10 2007 - 10:19:19 EST