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
ServerWatch.com Article: Virtualization Enters the SMB World ITChannelPlanet.com Article: Emerging E-Discovery Market Grows More Vital for VARs StoreVault Whitepaper: Introduction to Networked Storage Oracle eBook: Implementing Business Intelligence in Your Organization Hoovers Sales Tip: Building Credibility with New Clients SAP Whitepaper: A Corporate Guide to Better Decisions Through IT Microsoft Article: Flexibility, Agility the Keys to Dynamic IT Microsoft Article: Improving Infrastructure Management for Mid-Size Companies IBM Whitepaper: CIO Insights--Ignite Innovation by Fusing Business and IT IBM Whitepaper: Transforming Legacy Apps into SOA Internet.com eBook: All About Botnets Intel Article: 8 Simple Rules for Designing Threaded Applications Symantec Whitepaper: E-Mail Discovery--Worst-Case Scenarios Versus Best Practices		Ipswitch Whitepaper: Secure File Transfer In the Era of Regulatory Compliance Symantec Whitepaper: A Unified, Proactive Approach to Endpoint Security APC eBook: Putting the Green in IT Intel Whitepaper: Best Practices for Developing and Optimizing Threaded Applications Symantec Whitepaper: Emerging Trends in Fighting Spam Oracle eBook: Guide to Oracle 11g and Database Migration Symantec Whitepaper: Best Practices for IM Archiving & Compliance Intel Article: The Challenges of Developing Multithreaded Processing Pipelines Avaya Whitepaper: SIP--Creating Next-Generation Telecom Applications Avaya Article: Event Processing Demands Real-Time Response for Communications-Enabled Business Apps MessageLabs Whitepaper: Spam Spikes--A Real Risk to Your Business Symantec Article: Guarding the Corporate Gateway MORE WHITEPAPERS, EBOOKS, AND ARTICLES

Webcasts
Epicor Webcast: Requirements to Consider When Looking at ITSM Tools Intel Video: Three Must-Knows for Parallelism Microsoft: NXT Web Seminar Series Microsoft Partner Program Video: The Secrets to Partner Success		Rational Asset Manager: Succeed with Asset-based Development Microsoft Silverlight Video: Creating Fading Controls with Expression Design and Expression Blend 2 MORE WEBCASTS, PODCASTS, AND VIDEOS

Downloads and eKits
NXPowerLite: Desktop Edition Software Trial IBM Rational Systems Development Solution e-Kit IBM SOA Development Survival Guide eKit Evaluate IBM Rational Build Forge Online IBM Enterprise Architect eKit for SOA		Evaluate Rational Application Developer Online Iron Speed Designer Application Generator Symantec IM Detection Utility MORE DOWNLOADS, EKITS, AND FREE TRIALS

Tutorials and Demos
IBM Overview Video: Next Generation Data Warehousing IBM Tutorial: Intro to XML User Interface Language (XUL) Development Microsoft How-to Article: Get Going with Silverlight and Windows Live IBM Tutorial: The Ajax Transport Method		IBM Tutorial: Learning PHP IBM Tutorial: Validating XML MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES