[Squirrel-sql-develop] Tree support for database specific procedures
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Height, J. <jh...@su...> - 2004-03-31 23:55:09
|
Hi All, I have finalised the multiple windows patch that enables multiple trees and sql worksheets to be acive for a given session. I have sent this to colin (directly) and I expect it to be applied when he gets back. Moving on now, I am looking at an issue with the oracle plugin/database. In oracle, and I am sure that this is the same with other databases, there are a number of different types of stored procedures. There are procedures, functions and packages. Unfortunately at the moment the base tree functionality of squirrel has a standard expander for procedures that uses the DatabasemetaData.getProcedures. What this means is that all procedures appear under a "Procedures" node in the tree. The oracle plugin then adds a "Functions" and a "Packages" node, but the problem is that the procedures that should ONLY appear beneath the "Functions" or "Packages" node also appear beneath the "Procedures" node. I would like to be able to override/remove the standard tree procedure expander when the session is an oracle one, but I am a bit stumped on how to do it. I could add a "IObjectTreeAPI.setStandardExpander(DatabaseObjectType dboType, INodeExpander expander)" method but I am concerned on how to prevent multiple plugins overlapping. Does anyone have any ideas? Thanks Jason Height Senior Software Engineer Software Engineering Systems/Technologies Department Australian Submarine Corporation -------------------------------------------------------------------------------------------------------------------- This e-mail (including attachments) is confidential information of Australian Submarine Corporation Pty Limited (ASC). It may also be legally privileged. Unauthorised use and disclosure is prohibited. ASC is not taken to have waived confidentiality or privilege if this e-mail was sent to you in error. If you have received it in error, please notify the sender promptly. While ASC takes steps to identify and eliminate viruses, it cannot confirm that this e-mail is free from them. You should scan this e-mail for viruses before it is used. The statements in this e-mail are those of the sender only, unless specifically stated to be those of ASC by someone with authority to do so. |