[Squirrel-sql-develop] Tree support for database specific procedures

[Height, J. <jh...@su...>]

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.