My Oracle Support Banner

RDBPROD: Oracle JDBC for Rdb Driver F.A.Q. (Doc ID 255447.1)

Last updated on SEPTEMBER 15, 2023

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.1.4 and later
Oracle JDBC for Rdb - Version 7.1.1 and later
Information in this document applies to any platform.

Purpose

The purpose of this F.A.Q. article is to answer some questions about the Oracle JDBC for Rdb Drivers.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Which JDBC driver should be downloaded, the Oracle JDBC for Rdb Driver or the Oracle JDBC Driver? What is the difference?
 Where to download the JDBC for Rdb driver? 
 Which version of the driver should be downloaded? There are versions 7.1.x, 7.2.x. and 7.3.x
 Does JDBC for Rdb work with JAVA 8?
 How to install the JDBC for Rdb driver? Is any Oracle Installer needed?
 Where to find more installation hints?
 What quotas are required?
 Where are more information about Java on OpenVMS?
 Is SQL/Services needed to use the JDBC for Rdb driver?
 The JDBC for Rdb driver is already installed, and Oracle Support is asking about the version that is installed. How to get this information?
 What is the difference between the "JDBC for Rdb Native Driver" and the "JDBC for Rdb Native Thin Driver"?
 How to talk via the Oracle JDBC for Rdb drivers to an Oracle Rdb database from a client that is not on the same node as the database?
 How to start the JDBC for Rdb Thin Server process?
 After setting up the JDBC driver, the error message Java JDBC Error: no rdbjdbcshr in java is seen. Why?
 How to change the default attributes of the RdbThin Server process?
 A previous version of the Oracle JDBC for Rdb driver had only standard configuration files. Are they still supported?
 Where to find an example to test the JDBC for Rdb Driver?
 While starting the RdbJdbcCheckup.class with the option "-t", the following exception is thrown:
Exception in thread "main" oracle.rdb.jdbc.common.RdbException: Io exception : connection refused 
 The RdbJdbcCheckup test is running, but a bunch of SYSTEM-I-EMULATED messages are coming up. Why?
 How to specify the connection string to use the JDBC for Rdb Driver?
 Oracle Support asked to switch on JDBC Tracing. How to do that?
 Though the trace value 0x4 has been set there are no SQL statements traced. What is the cause?
 How to send the trace information to a file?
 How to get the Rdb debug flags information for applications that connect to the Rdb database using the JDBC for Rdb driver?
 Is it possible to run more than one version of the JDBC for Rdb driver on the same system at the same time?
 The documentation says that the driver has "Full support for multi-threaded applications". The multithreaded Java application works when using the JDBC for Rdb Thin Driver, but not when using the JDBC for Rdb Native Driver. What is the reason?
 After changing a pool of Thin Server Processes to a pool of MP Thin Server Processes only one server process out of the pool seems to be used. Is that not supported?
 After reading the documentation it is still unclear what are the differences between a Thin Server, a Multi-Process Thin Server and a Pool Server.
 Is there a way to preattach an executor/server to the database to avoid the overhead of attach/deattach? 
 What is the best way to ensure that the JDBC for Rdb server is restarted on reboot?
 How much is the performance impact with a multi-process thin server connecting to an executor versus a thin server? 
 Is the pool server somehow able to determine which server is the busiest?
 How does authentication work? Is having the username/password in the database USER$ table enough? Does the username/password have to be an OpenVMS username? If having it in USER$ is enough - is there a way to force OpenVMS authentication?
 The pool server and the thin server processes are running under the account which started them. How to achieve that they run under a different acoount?
 How to manipulate list of byte varying fields in my database? The example in the rdbjdbc_readme.html file shows only how to read BLOBs.
 The example in note 254991.1 to insert and read BLOBs does not work properly. What is the reason?
 Can I use the JDBC for Rdb Native Driver together with Forms and Reports?
 Is the JDBC driver for Oracle Rdb XA compliant?
 Can we adjust the JDBC srv.idletimeout parameter, default 0, so attaches disconnect when they become inactive?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.