From: Robert Manning <robert.manning@gm...> - 2007-10-17 20:04:02
I've reached a conclusion on this issue. I spent a number of hours
downloading and installing SUSE SLES9 into a vmware image, and I
finally got Informix 10 installed and managed to setup an ANSI
database (no log buffering). At first I wasn't seeing the issue as I
had created a non-ANSI database. However, when I created an ANSI
database I managed to get the same behavior you described!!! (Thank
you for waiting so patiently :) I've determined that it's probably a
jdbc driver bug. The good news for you is that there appears to be a
simple work-around. You see, I notice that the problem goes away when
you use the driver that ships with Informix 10 in the
$INFORMIXDIR/extend/krakatoa directory. It's version is
"2.21.JC4N450" which you can verify in SQuirreL by looking at the
"getDriverVersion" key's value in the metadata tab when you select the
root node in the object tree. The version of the driver that produces
the bug you encountered - for me, at least - is "3.00.JC3".
On 10/11/07, M=AA Jos=E9 Casany <mjcasany@...> wrote:
> Hi Rob,
> thanks a lot for answering.
> I only have access to an informix 10.0 for windows. This one I could
> upload it for you in an FTP server.
> Apart from that, one of my students told me that from the IBM web site
> you can download a 3 month trial of the informix 10.0 server for linux.
> M=AA Jos=E9
> Robert Manning wrote:
> >On 10/9/07, M=AA Jos=E9 Casany <mjcasany@...> wrote:
> >>Hi Rob,
> >> I am using SQuirrel to access an informix 10.0 database.
> >> I'm the owner of an ANSI database but it seems that I can't see the
> >>list of column names of the tables.
> >> I can only see the column list when the database is NOT ANSI. The syst=
> >>does not return any exception or message at all, it simply does not sho=
> >>the column
> >>I would appreciate if you could answer my question.
> >I would like to help you, but I don't have access to an Informix 10.0
> >database. I do have an Informix 11 database server that Doug Lawry
> >helped me setup on my Fedora Core 6 Linux machine. However, I had to
> >get the software from him because I am not a licensee of Informix. Is
> >there a way that I could get version 10 also ? (I believe I was
> >getting version 11 through an arrangement between Informix and the
> >Informix User's Group - IUG). I don't see the problem you are
> >describing with version 11. I would need to step through the code
> >with a debugger after connecting to the database.
> M=AA Jos=E9 Casany - UPC
> +34 93 413 78 88