Problem solve Get help with specific problems with your technologies, process and projects.

Working with ODBC and JDBC

How can I create an ODBC connection to the iSeries, and create a statement with Java to insert to a file on the database?
ODBC is standard -- you use ODBC to the iSeries in the same way you use ODBC to connect to Oracle. The iSeries Navigator contains a good ODBC driver (it is also free).

JDBC is standard -- you use insert to iSeries from Java exactly as you would insert to Oracle. The Java Toolbox contains a solid JDBC driver for iSeries (it is also free).

Click here for sample code.


Visit the ITKnowledge Exchange and get answers to your connectivity questions fast.

The Best Web Links: Tips, tutorials and more.

PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

This was last published in May 2005

Dig Deeper on iSeries Java programming

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.



  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...