db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fischer (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (TORQUE-41) JDBC Task: Getting Foreign Keys from Views in Sybase throws SybSQLException
Date Sat, 15 Jul 2006 08:02:15 GMT
     [ http://issues.apache.org/jira/browse/TORQUE-41?page=all ]

Thomas Fischer resolved TORQUE-41.

    Fix Version/s: 3.2.1
       Resolution: Fixed
         Assignee: Thomas Fischer

Fixed by catching SQL exceptions when retrieving the foreign keys for a table.

> JDBC Task: Getting Foreign Keys from Views in Sybase throws SybSQLException
> ---------------------------------------------------------------------------
>                 Key: TORQUE-41
>                 URL: http://issues.apache.org/jira/browse/TORQUE-41
>             Project: Torque
>          Issue Type: Bug
>          Components: Generator
>    Affects Versions: 3.2
>         Environment: Sybase ASE 12.5
> jConnect for JDBC 2.0 v5.5 Build 25137 or v6.05 Build 25828
> Java Tds Server Classes v5.5 Build 25138 or v6.0 Build 25828
>            Reporter: Thoralf Rickert
>         Assigned To: Thomas Fischer
>             Fix For: 3.2.1
> Assuming TORQUE-40 is resolved - the JDBC task would throw an exception if it is examining
a sybase database with views.
> com.sybase.jdbc3.jdbc.SybSQLException: No such object or user exists in the database.
> ...
> at org.apache.torque.task.TorqueJDBCTransformTask.getForeignKeys(TorqueJDBCTransformTask.java:488)
> ...
> This happens because the JDBC driver in Sybase seems to not support foreign keys in views.
A workaround for this would be to catch exceptions in org.apache.torque.task.TorqueJDBCTransformTask#getForeignKeys()
and return an empty list (or collection). With this fix it would be possible to generate a

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

View raw message