RmiJdbc/Inprise JBuilder Demo Application

JBuilder is a Java development environment, from Inprise Corporation (ex Borland).

The RmiJdbc demo application for Inprise JBuilder is a JBuilder project.

It illustrates the connection to Interbase and/or Microsoft Access databases, in both local (using the JDBC/ODBC Bridge) and client/server (using RmiJdbc and the JDBC/ODBC Bridge) modes.

To download and install the demo:

Download the demo (rjdemo.jar file, 44799 bytes)
Copy rjdemo.jar in your JBuilder directory (for example, C:\JBuilder)
Un-jar it: jar xvf rjdemo.jar
Start JBuilder, and open the myprojects\rjdemo.jpr project!

Setup & Run instructions follow (extracted from the "Project Notes" html file included in the rjdemo JBuilder project).

Important notice: UNDER DEVELOPMENT!

RmiJdbc / JBuilder integration is in progress, still under development.
The following example is an alpha version, subject to changes.
Report bugs by e-mail!

THE TEST HAS BEEN RUN ON WINDOWS NT 4.0 WORKSTATION WITH INPRISE JBUILDER CLIENT/SERVER, INTERBASE AND MICROSOFT ACCESS.

Setup & Run instructions...

Install and start RmiJdbc

We'll assume Inprise JBuilder is installed under C:\JBuilder.
Download and install RmiJdbc (copy RmiJdbc.jar under C:\JBuilder\lib).
Make your CLASSPATH point on RmiJdbc.jar
(set CLASSPATH=%CLASSPATH%;C:\JBuilder\lib\RmiJdbc.jar, or update the CLASSPATH Environment variable in the System part of the Configuration Panel).
Go in the C:\JBuilder\lib directory.
Start the RmiJdbc server component with the following arguments:
java RmiJdbc.RJJdbcServer sun.jdbc.odbc.JdbcOdbcDriver

Setup the ODBC datasource

Interbase

In the Configuration Panel, double-click ODBC
Click "System DSN...", then "Add..."
Choose "Interbase 4.x Driver by Visigenic (*.gdb)"
Type "rjdemo_interbase" in the Data Source Name text box, "C:\JBuilder\myprojects\rjdemo\rjdemo.gdb" in the Database box.
Setup the user name and password (in the example, I use "SYSDBA" as user name and "masterkey" as password).

Microsoft Access

In the Configuration Panel, double-click ODBC
Click "System DSN...", then "Add..."
Choose "Microsoft Access Driver (*.mdb)"
Type "rjdemo_access" in the DSN name text box, and browse to select "rjdemo.mdb" as the corresponding database (should be in the rjdemo directory).
Setup the user name and password in the extended options (in the example, I use "admin" as user name and "rjdemo" as password).

Run the example

Note:
By default, the example uses Interbase. If you want to use Microsoft Access, you must change the JDBC URL in the Java code: change "rjdemo_interbase" to "rjdemo_access" everywhere you find it (and update user&password info).

Start Inprise JBuilder
Open the "rjdemo.jpr" project
Run it (thus making sure everything is well configured).

Click in "Local DB Access" card or in "RmiJdbc DB Access" to query the database locally or through RmiJdbc

Note: the example WON'T RUN if RmiJdbc.RJJdbcServer is not properly launched !!
You can stop RmiJdbc.RJJdbcServer then start the application to see what happens (an exception is raised and only the local data are available), then exit the application, restart RmiJdbc.RJJdbcServer and restart the application (it should work fine again).