Re: JT400 - MCH1210 when refreshing Squirrel

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

Couple of suggestions:

1) Try going back to the last version of JTOPEN that worked.  It's easy 
to do.  And there is a version of JTOPEN somewhere in the Client Access 
folders if you want a really old one.  (When I upgraded to 3.2.0 I also 
installed the latest JTOPEN but had to go back to an earlier JTOPEN 
because it kept dropping the connection after 5 seconds of inactivity, 
so there may be something incompatible in it.)

2) There is a SQuirreL support list.  They are volunteers and they don't 
know anything much about AS/400s, but they are helpful and may have an idea.

Sam

On 6/21/2011 6:22 PM, JK wrote:
> All,
>
>
>
>   I’m having two problems configuring Squirrel which may or may not be
> related. Recent installs of Java (ver 1.6.0_21) JTOPEN (7.4) and Squirrel
> (3.2.1). I’m able to set the current lib via the jdbc connect string and run
> SQL statements in Squirrel just fine. Connect string =
> jdbc:as400://12.345.678.90/jking1.
>
>
>
> The Object Tree isn’t being populated, though, and without that function I’m
> still chained to the green-screen tools. I’ve experimented with the Driver
> Properties “database name” and “Libraries” to no positive effect.
>
>
>
> a)       The Object Tree shows the main object categories: ALIAS,
> SYSTEM_TABLE, TABLE, VIEW, etc, but each is category is empty. When I select
> “Connect database and refresh schema table” from the alias properties, the
> log file records an MCH1210 error.
>
>
>
> “2011-06-21 16:33:26,281 [AWT-EventQueue-1] ERROR
> net.sourceforge.squirrel_sql.client.session.SessionManager  - Failed to get
> allowed Schemas java.sql.SQLException: [MCH1210] Receiver value too small to
> hold result.
>
>
>
> b)       When I select one of the categories (say TABLE) and attempt to
> “Refresh Item” or “Refresh Tree and Cache”, the log file records a different
> error:
>
>
>
> “2011-06-21 17:09:46,046 [AWT-EventQueue-1] ERROR
> net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  - Error
> loading uncached tables java.sql.SQLException: [SQL0199] Keyword BY not
> expected. Valid tokens:<  >  =<>  <= !<  !>  !=>= ¬<  ¬>  ¬= IN IS NOT LIKE
> BETWEEN.”
>
>
>
>   Is this a JT400 thing or is there some combination of Driver Properties
> that I haven’t twigged to yet?
>
>
>
> This Java novice has about reached the limits of his knowledge – any
> assistance would be appreciated!
>
>
>
> JK