× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.