Re: Problems with schema reverse engineer on Sybase 12.5.4 Solaris

From: jerome moliere (jerome.molier..mail.com)
Date: Wed Jan 10 2007 - 04:42:15 EST

  • Next message: Andrus Adamchik: "Re: Problems with schema reverse engineer on Sybase 12.5.4 Solaris"

    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 - 04:42:52 EST