[ http://issues.apache.org/jira/browse/TORQUE-41?page=all ]
Thomas Vandahl closed TORQUE-41. -------------------------------- > 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.3 > > > 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 > schema.xml -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]