RE: JT400 - MCH1210 when refreshing Squirrel

Hi, JK --

I'm assuming that you're running on Windows. I'm not a squirrel person but
after looking at squirrel-sql.bat, I'd think you can just start it with

squirrel-sql >c:\temp-or-whatever\my-stdout-file 2>>1

If that doesn't work, you'll need to change the actual batch file (make a
backup copy first) to include everything after squirrel-sql at the end of
the line starting

start "Squirrel SQL Client" ...

Gary

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx] On Behalf Of JK
Sent: Tuesday, June 21, 2011 11:03 PM
To: 'Java Programming on and around the IBM i'
Subject: RE: JT400 - MCH1210 when refreshing Squirrel

Gary,

Many thanks - a trace will likely be helpful if this thing ends up in a
bug report.

System.out does not appear in the Squirrel log directory, not can I
locate it in jtopen or jre6. Where should I look? Like I said - I'm
operating at the limits of my knowledge!

JK

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-
bounces@xxxxxxxxxxxx]
On Behalf Of Gary L Peskin
Sent: Tuesday, June 21, 2011 8:23 PM
To: 'Java Programming on and around the IBM i'
Subject: RE: JT400 - MCH1210 when refreshing Squirrel

I haven't used squirrel but try adding

toolbox trace=jdbc,trace=true

to the end of your URL so that it looks like:

jdbc:as400://12.345.678.90/jking1;toolbox trace=jdbc,trace=true

While this won't fix the problems, it should show you the SQL statement
that Squirrel is sending to the 400 that's generating the MCH1210 and
that might provide a clue as to what's going on. The trace shows up on
System.out.

HTH,
Gary

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

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

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/java400-l.