× 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.



Dan Kimmel wrote:
James, I saw this inquiry on Midrange-L, as well. From there it looks
like you're trying to access database tables (*FILE objects in a *LIB
object) as opposed to files, which on this forum tends to refer to
IFS stream files.

You are correct.

How are you trying to access the tables. Through JDBC using the JDBC
driver from JT400? Are you using JT400 or JT400Native? What does your
connection url look like? One of the important things to remember is
the userid and password for the connection are in this url in most
circumstances. The userid under which the JVM running Tomcat is
running has no bearing on the database connection unless you're
running JT400Native.

Unfortunately, it's not my code (and I don't deal with Toolbox classes enough to know one driver from another), so I wouldn't know whether it's JT400 or JT400Native. And to complicate matters, the customer's box is behind a firewall, and I don't think they're inclined to even temporarily open up the ports needed for us to, say, connect with Squirrel SQL.

But I see this in a configuration file we use for BIRT:

<property name="odaDriverClass">com.ibm.as400.access.AS400JDBCDriver</property> <property name="odaURL">jdbc:as400://127.0.0.1/WTI1###;prompt=false</property> <property name="odaUser"></property> <encrypted-property name="odaPassword" encryptionID="base64"></encrypted-property>

Since the "WTI1###" library name was causing some interesting effects elsewhere, I set up a similar library here, on our box, and BIRT had no trouble at all accessing the database on our box.

If you're running JDBC through JT400, there should be info in the
joblogs for the QZDASOINIT job that is serving your connection. That
job log will have info about why the file couldn't be found (no
privilege, etc.). Use WRKOBJLCK xxx *USRPRF where xxx is the user in
the JDBC connection string to find the QZDASOINIT job.

Since I *do* have terminal sessions on the box in question, I'll start looking for QZDASOINIT jobs thereon.

--
JHHL

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.