Re: [Squirrel-sql-develop] Oracle woes

[Rob M. <Rob...@co...>]

Gerd Wagner wrote:

> Rob,
>
> just to make sure I understand things right.
>
> 1. You found out that bug "[1276957] Oracle Protocol Violation" is a 
> concurrency problem?
>
> 2. "[1276957] Oracle Protocol Violation" is the same problem you 
> discussed with Andrea?
>
> 3. "[1276957] Oracle Protocol Violation" is also the problem that 
> keeps some of your colleagues from using SQuirreL
>
> 3. You solved the problem doing some synchronization and for this 
> "touched many places in the code"?
>
> 4. Your version that solved the problem is here: 
> http://squirrel-sql.sourceforge.net/downloads/squirrel-sql-2.1_robs_build-install.jar? 
>
>
> 5. The work you did to solve the problem makes worse the freezing of 
> SQuirreL during the opening of a Session mostly on Oracle.
>
> 6. You found a way to reduce the freezing on Oracle by providing an 
> alternative INodeExpander implementation for DatabaseObjectType 
> SESSION that reduces Schema loading and this INodeExpander 
> implementation of yours is placed in the Oracle Plugin?

Yes to all of the above.  I have done this over the past two weeks, so I 
had forgotten how much work I've done.

>
> If you say yes to all of these questions I'd recommend you to commit 
> your work.
>
Ok.  It occurred to me that I need to cover the case where we login as a 
"system" user on Oracle. 
So, once that is solved I'll checkin the plugin changes I've made.  I'll 
also get the core changes in as soon as
I can.

> I tested your version against several RDBMses including our not so 
> small database via two VPN connections: From my home to work and from 
> there to on of our customers. I felt the freezing was acceptable.

Thanks for testing it out. 

>
> Perhaps we should hint Oracle users that they better use the Oracle 
> Plugin. Perhaps we should do this during installation as well as on 
> our Web page.

Yes indeed.  Thanks again for the followup - It's good to have you back.

Rob


CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83