Re: DO NOT REPLY [Bug 6333] New: - Class TorqueJDBCTransformTask doesn't close Oracle ResultSet

[Daniel Rall <dl...@finemaltcoding.com>]

Did someone point out that this was fixed in CVS?  If so, let me know
and I'll close it.

Thanks, Dan


bugzilla@apache.org writes:

> DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
> RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
> <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=6333>.
> ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
> INSERTED IN THE BUG DATABASE.
>
> http://nagoya.apache.org/bugzilla/show_bug.cgi?id=6333
>
> Class TorqueJDBCTransformTask doesn't close Oracle ResultSet
>
>            Summary: Class TorqueJDBCTransformTask doesn't close Oracle
>                     ResultSet
>            Product: Turbine
>            Version: 2.1 final
>           Platform: All
>         OS/Version: Linux
>             Status: NEW
>           Severity: Normal
>           Priority: Other
>          Component: Torque
>         AssignedTo: turbine-dev@jakarta.apache.org
>         ReportedBy: ronant@infogain.co.uk
>                 CC: ronant@infogain.co.uk
>
>
> Hello,
> I've downloaded Turbine2.1 to reverse engineer an Oracle8.1.6 schema in XML,
> and the following code reports the following error :
> ORA-1000 Maximum open cursors exceeded.
>
> public class TestReverseXML
> {
>     public static void main(String[] args) {
>         TurbineConfig tc = new TurbineConfig("/home/ronant/torque",
>           "TurbineResources.properties");
>         tc.init();
>
>         TorqueJDBCTransformTask txml = new TorqueJDBCTransformTask();
>         txml.setDbDriver("oracle.jdbc.driver.OracleDriver");
>         txml.setDbUrl("jdbc:oracle:thin:@SherKhan:1521:FSTART");
>         txml.setDbUser("cy_schema");
>         txml.setDbPassword("cy_schema");
>         txml.setOutputFile("/home/ronant/torque/cy-schema.xml");
>         try {
>             txml.execute();
>             txml.generateXML();
>         } catch (Exception x)
>         {
>             System.out.println("Error in TestReverseXML : " + x.toString());
>         }
>     }
> }
>
> The fix I found is to actually close the ResultSet in the methods
> getTableNames, getColumns, getPrimaryKeys, and getForeignKeys.
>
> Besides, the <column> tags generated in the XML have an empty type attribute, like :
> <table name="AIRLINES">
>         <column name="AL_CODE" size="10" type=""/>
>         <column name="AL_NAME" size="50" type=""/>
>         <column name="AL_SHORTNAME" size="30" type=""/>
>         <column name="AL_CODE" size="10" type=""/>
>         <column name="AL_NAME" size="50" type=""/>
>         <column name="AL_SHORTNAME" size="30" type=""/>
>     </table>
> which is annoying :)
>
> Cheers,
>
> Ronan Tanguy
>
> --
> To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>