Re: [Squirrel-sql-develop] SQL Squirrel now works with Ingres?

[Colin B. <col...@bi...>]

Hi Tolley,


On Mon, 2003-12-15 at 12:57, Tolley Shorn wrote:
> Hi Folks,
> 
> A while ago I posted about SQuirreL not working with Ingres and how I had to patch it.
> This morning I finally got some time to create a diff of my one-liner to get Ingres working with SQuirreL.
> 
> So to prepare, I downloaded 1.2 beta4... and now it works with Ingres! 
> 
> Did you guys do this on purpose, or is it a by-product of some other change?
> (The root-cause of the problem was that the values returned from the getSchemas() method needed to be trimmed before being sent to getTables()).

Bypoduct of another change I think. I've got a note in my todo list to
make sure that all usages of schemas and catalogs are trimmed.

> 
> If you did it on purpose, then that's fine.
> If it's a side-effect, I just wanted to tell you about it so that you didn't remove it in some later version.
> Of course, we've upgraded to a new service pack for Ingres, so that might have fixed the problem too.
> 
> Anyway, if you like, you can now add Ingres to the list of supported DBs for SQuirreL.
> 
> I would suggest a line like:
> CA Ingres 2.6 SP2 with EDBC driver v1.8 (probably works with Caribou Lake driver too)

Thanks, I'll add that.

> 
> And you might needd an Ingres FAQ along the lines of:
> 
> Question:
> Ingres reports "Error: contsbt: ca.edbc.util.EdbcEx: No MST is currently in progress, cannot declare another cursor." when I connect and nothing is listed under the schema name in the Object Tree.
> Workaround:
> Right-click on the schema in the explorer and select refresh, objects should appear as normal.

I might be able to do a bit better than that. I suspect that this is a
threading issue that I'll be looking at early next year. In the mean
time I'll certainly add this to the FAQ.

-- 
Colin Bell
http://squirrel-sql.sf.net