jGuru: Java400 FAQ Home Page

Forgot your
password?

HOME

FAQS

FORUMS

DOWNLOADS

ARTICLES

PEERSCOPE

LEARN

Search

Java400 FAQ Home Page

FAQ Manager is guru Joe Sam Shirah PREMIUM.

The AS/400 is a backbone system for hundreds of thousands of businesses worldwide. The platform scales from the departmental level to thousands of users and has introduced seamless new hardware and OS capabilities with every release. OS/400 is a layered, object-based operating system with numerous integrated capabilities including security, a UDB DB2 compatible database and Java. The Java400 FAQ focuses on learning and leveraging AS/400 specific areas of Java while maintaining portability wherever possible.

What's New

What ports does the AS/400 Toolbox JDBC driver ( com.ibm.as400.access.AS400JDBCDriver ) use? My application needs to use JDBC through a firewall.
Platform:AS/400
Eric Kramer, Mar 15, 2002
Here's a wonderfully helpful document from IBM summarizing the ports used by the various Toolbox features (including JDBC): Server Ports Used From...

Is there a way to detect the AS/400 File EOF or BOF?
Platform:AS/400
Joe Sam Shirah PREMIUM, Sep 19, 2001
Because of the terms you are using, I assume you are referring to Record Level Access ( JTOpen covers a lot of territory ). I personally don't use the...

The RPG programm should act as a part of a transaction. That means, do some update via JDBC, call RPG, do some more updates via JDBC. Then do a commit or rollback that should affect all the updates from...
Platform:AS/400
sepp muegeli, Jul 25, 2001
One way I've found is: 1. Use commitment control from JDBC as usual ( auto-commit off, transaction isolation level != none ). 2. Use the keyword &...

Toolbox driver vs native IBM driver My program works fine from winNT and on the AS/400 using the Toolbox driver( com.ibm.as400.access.AS400JDBCDriver). However, it doesn't work using the native driver...
Platform:AS/400
Joe Sam Shirah PREMIUM, Apr 25, 2001
I can't be sure from the information given, but the most likely cause is that not only the driver class but also the JDBC database URL is different for...

Are there any Java classes available that provide SQL builder/SQL by example functionality?
Java:API:JDBC, Platform:AS/400
Joe Sam Shirah PREMIUM, Jan 31, 2001
One resource is the SQLQueryBuilderPane contained in JTOpen. Although much of the code in JTOpen is oriented towards and specific to the AS/400, this...

Why do my transactions fail when I invoke executeUpdate()? I've set autocommit to false, but I get the SQLException: "The file is not valid for the operation" and getTransactionIsolation()...
Java:API:JDBC, Platform:AS/400
Joe Sam Shirah PREMIUM, Jan 27, 2001
Transactions require underlying support. In general, there must be 1) A database table. 2) The database must support transactions. 3) Any...

How can I print out a file to the printer directly using Java on an AS/400?
Platform:AS/400
Joe Sam Shirah PREMIUM, Dec 31, 2000
The most basic method is to use System.out.println() and submit the job to batch. As Running Java in a batch job discusses, default handling sends System.err...

How can I use the library list for specific objects with the Toolbox? "*LIBL" doesn't seem to work properly.
Platform:AS/400
Joe Sam Shirah PREMIUM, Dec 29, 2000
'*' is used for a wildcard character. Instead, use surrounding '%' signs, as "%LIBL%". For example, to find the message queue MYMSGQ, use: ...

Are there any JDBC drivers available that support using SSL to communicate between the Java program and the database server?
Java:API:JDBC, Java:API:Security, Platform:AS/400
John Zukowski PREMIUM, Dec 29, 2000
For Oracle, the JDBC-OCI driver can use SSL with native threads, but not with green threads. The JDBC-Thin driver cannot use SSL, but can use ANO encryption...

How can I use the library list to access tables and files with JDBC?
Platform:AS/400
Joe Sam Shirah PREMIUM, Dec 22, 2000
Set the 'naming' driver property to 'system'. This works for both the Toolbox and native driver. One caution, the library list used comes from the job...

How do I get and install JDK 1.3?
Platform:AS/400
Joe Sam Shirah PREMIUM, Dec 19, 2000
For V4R5, see V4R5 5769-JV1 Option 5 (JDK 1.3) AS/400 Install Instructions. This is off of the Java Deployment page. There should also be instructions...

I want to use the Developer Kit's native JDBC driver to retrieve data from other AS/400s on a network. I've added the proper Relational Database Entries, but when I try to connect to the remote machines,...
Platform:AS/400
Joe Sam Shirah PREMIUM, Dec 9, 2000
If you're at V4R3 or below, the recommendation is to use the Toolbox driver rather than the native driver. If you're at V4R4 or later, and up to date...

Where can i get instructions on how to use JNI on AS/400?
Java:API:JNI, Platform:AS/400
Davanum Srinivas PREMIUM, Nov 23, 2000
http://www.as400.ibm.com/developer/java/devkit/rzaham70.htm

How can I programmatically determine the level of the AS/400 Toolbox for Java?
Platform:AS/400
Joe Sam Shirah PREMIUM, Nov 6, 2000
Download and use the AboutToolbox class.

How do I package my Java application for deployment to an AS/400 box?
Platform:AS/400
Todd Mason, Oct 27, 2000
Java source and class files reside in the AS/400's IFS ( Integrated File System, ) as ASCII text files. You can create a Java source file in IFS via several...

Are there any IDEs or addons and tools for IDEs that are aimed specifically at the AS/400? What do Java400 developers use?
Platform:AS/400
Todd Mason, Oct 23, 2000
IBM's Visual Age for Java Enterprise comes with a feature called "ET/400": Enterprise Toolkit 400. It allows the developer to easily export...

How can I create a Java program that starts as a daemon every time the machine is powered on?
Platform:AS/400
Rob Derr, Oct 15, 2000
Several methods come to mind. Let's see... 1. write a CL program that calls your java app and place a reference to that CL command in QSYS/QSTRUP. This...

When I use the AS400JDBCDatabaseMetadata.getColumns(), the columns arrive in alphabetical order not in physical order. Is there a way other than SELECT * FROM... to get the physical order ?
Java:API:JDBC, Platform:AS/400
Joe Sam Shirah PREMIUM, Sep 30, 2000
Unfortunately, if you look at the Toolbox documentation for AS400JDBCDatabaseMetaData.getColumns(), you'll see this statement: "The following column...

Why do I get "Invalid Cursor State" errors when I insert/update/delete data with executeQuery()?
Java:API:JDBC, Platform:AS/400
Joe Sam Shirah PREMIUM, Sep 30, 2000
The base answer is that you should be using executeUpdate() for these operations. The JDBC spec specifically "allows any query string to be passed...

Where do I get JDBC drivers for the AS/400's database?
Java:API:JDBC, Platform:AS/400
Joe Sam Shirah PREMIUM, Sep 30, 2000
The native driver and a version of the Toolbox for Java, which includes the type 4 driver, comes with OS/400. One can also purchase or get an evaluation...

« previous

beginning

Related Links

AS/400 Java Home

Java Development Topics

Search400

Wish List
Features
About jGuru
Contact Us

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info

Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers

Whitepapers and eBooks
IBM Whitepaper: Innovative Collaboration to Advance Your Business Internet.com eBook: Real Life Rails Avaya Article: Call Control XML - Powerful, Standards-Based Call Control Internet.com eBook: The Pros and Cons of Outsourcing Go Parallel Article: Scalable Parallelism with Intel(R) Threading Building Blocks Internet.com eBook: Best Practices for Developing a Web Site IBM CXO Whitepaper: The 2008 Global CEO Study "The Enterprise of the Future"		Avaya Article: Call Control XML in Action - A CCXML Auto Attendant Go Parallel Article: James Reinders on the Intel Parallel Studio Beta Program IBM CXO Whitepaper: Unlocking the DNA of the Adaptable Workforce--The Global Human Capital Study 2008 Adobe Acrobat Connect Pro: Web Conferencing and eLearning Whitepapers Go Parallel Article: Getting Started with TBB on Windows HP eBook: Storage Networking , Part 1 MORE WHITEPAPERS, EBOOKS, AND ARTICLES

Webcasts
Go Parallel Video: Intel(R) Threading Building Blocks: A New Method for Threading in C++ HP Video: Is Your Data Center Ready for a Real World Disaster? Microsoft Partner Portal Video: Microsoft Gold Certified Partners Build Successful Practices HP On Demand Webcast: Virtualization in Action Go Parallel Video: Performance and Threading Tools for Game Developers		Rackspace Hosting Center: Customer Videos Intel vPro Developer Virtual Bootcamp HP Disaster-Proof Solutions eSeminar HP On Demand Webcast: Discover the Benefits of Virtualization MORE WEBCASTS, PODCASTS, AND VIDEOS

Downloads and eKits
Microsoft Download: Silverlight 2 Software Development Kit Beta 2 30-Day Trial: SPAMfighter Exchange Module Red Gate Download: SQL Toolbelt		Iron Speed Designer Application Generator Microsoft Download: Silverlight 2 Beta 2 Runtime MORE DOWNLOADS, EKITS, AND FREE TRIALS

Tutorials and Demos
IBM IT Innovation Article: Green Servers Provide a Competitive Advantage Microsoft Article: Expression Web 2 for PHP Developers--Simplify Your PHP Applications		Featured Algorithm: Intel Threading Building Blocks - parallel_reduce MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES