RE: JT400 - MCH1210 when refreshing Squirrel -- JAVA400-L

Sam,

Many thanks for the reply. I backed up JTOPEN to 7.2, then 7.0 with the
same results. The weird thing is that I just logged into another client's
V6R1 box and Squirrel works as expected. The box in question is V5R3.

Just joined the JT400-news list and will post this same message there.

JK

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Sam_L
Sent: Tuesday, June 21, 2011 7:19 PM
To: java400-l@xxxxxxxxxxxx
Subject: Re: JT400 - MCH1210 when refreshing Squirrel

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

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

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