db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thoralf Rickert (JIRA)" <j...@apache.org>
Subject [jira] Created: (TORQUE-41) JDBC Task: Getting Foreign Keys from Views in Sybase throws SybSQLException
Date Wed, 12 Jul 2006 09:05:30 GMT
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
        Type: Bug

  Components: Generator  
    Versions: 3.2.1    
 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

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:
For more information on JIRA, see:

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

View raw message