Announcement Announcement Module
No announcement yet.
Roo dbre for Sybase - don't use jtds, try JConnect Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Roo dbre for Sybase - don't use jtds, try JConnect

    Just wanting to share my recent experience in case it is helpful to anyone.

    Using Roo 1.2.2 and the jtds 1.2.4 wrapper - the generated schema had name="" for all foreign-key elements.
    <table alias="Evibs" name="testTableUser">
    <column name="au_lname" primaryKey="true" required="true" scale="0" size="40" type="12,varchar"/>
    <foreign-key foreignTable="testTablePhil" name="" onDelete="restrict" onUpdate="restrict">
    <option key="foreignSchemaName" value="Evibs"/>
    <option key="exported" value="true"/>
    <reference foreign="au_lname" local="au_lname"/>
    <unique name="testTableU_4890527781">
    <unique-column name="au_lname"/>
    <unique name="au_lname_index">
    <unique-column name="au_lname"/>

    The root cause of this is an issue between the jtds driver and the Sybase sp_fkeys system procedure call. Refer to:

    The end result is that I moved to the jConnect (Sybase's) JDBC driver Version 6.00

    I wrapped this by making a new wrapper for jConnect based on:

    Built this and installed in Roo 1.2.2 and now both introspect and reverse are working.

    If anyone is facing a similar issue, would be happy to provide additional info.