Question & Answer
Question
Can I access my IBM i database with Java but without JDBC?
Answer
The answer is Yes, here are a few alternatives (and there are certainly more):
- Use the record-level database access classes provided in the IBM Toolbox for Java. These bypass JDBC and SQL altogether. Using record-level database access, your program can read and write database files using record formats specific to IBM i. These classes communicate using DRDA and are often faster than JDBC, but they are also somewhat proprietary (whereas JDBC is somewhat standardized across the industry).
- Write your own client/server. You can then code your server program in whatever language you want (Java included). The server program can access the database using native methods.
Some examples:
- Write a servlet that gets called by the web server when a client requests a given URL.
- Write a server program that reads requests from and sends replies to data queues. The client program can then use the IBM Toolbox for Java data queue classes to communicate with an IBM i system.
- The client can call IBM i programs directly using the IBM Toolbox for Java program call classes. Parameter passing and messages are supported.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Product Synonym
IBM i
Was this topic helpful?
Document Information
Modified date:
17 March 2020
UID
ibm11117947