Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
Reality V15.2 Online Documentation (MoTW) Revision 3
Description of the Example Application (RealSQL-JDBC) (appdesc.htm)
The example application, ExampleApp, connects to a Reality database and executes an SQL query to list all items in the table of employees. This example application
com.northgateis.reality.realsql.RealSQLDriverjdbc:realsql://magpie:1203/TESTDBASE -
to connect to the Reality database TESTDBASE on the magpie system.java.util.Properties object to store the connection
properties. These properties comprise
the user-id and password on the remote host and database, and the name of the
Reality account. accountpwd is set to null because there is no
password for this account.DriverManager.getConnection()methods, passing the URL and the connection
properties.createStatement() in the
Connection class to create a statement
object for sending the SQL query to the database.Statement.executeQuery()
method, which returns a single result set.ResultSetMetaData object created during the
executeQuery()
from the ResultSet object.ResultMetaData class (getColumnCount(),
getColumnDisplaySize() and getColumnLabel()) to retrieve the column property
information, then calls methods in ResultSet to retrieve the column data for all rows in EMP.