Database Drivers

The jBASE design provides for database independence by allowing end users to code additional database drivers thus enabling a infinite number of database types to be used by the same application. In addition jBASE provides an example of how to interface to the jBASE jEDI drivers.

EXAMPLE OF APPLICATION INTERFACE INTO JBASE JEDI DRIVERS.

Copy the "jediCExample.c" program from the "src" subdirectory in the jBASE release directory and compile.

Unix
cc jediCExample.c -o CExample -I$JBCRELEASEDIR/include -ljedi -lld

Windows
cl /Zi -o CExample jediCExample.c /I%JBCRELEASEDIR%\include libjbase.lib

Execute CExample as

CExample -Options InputFile OutputFile

EXAMPLE OF JBASE JEDI DRIVER.

Copy the "jediDExample.c" program from the "src" subdirectory in the jBASE release directory and compile.

Unix
cc jediDExample.c -c -I$JBCRELEASEDIR/include
jBuildSLib jediDExample.o -o $HOME/lib/ddrivers.so

Windows
cl /Zi /c jediDExample.c /I%JBCRELEASEDIR%\include
jBuildSLib jediDExample.obj -o %HOME%\lib\libdrivers.dll

Create jBASE File Pointer
ED . EXAMPLE
001 JBC__SOB ExampleInit .d

Create standard directory with ".d" suffix
mkdir EXAMPLE.d

Edit jBASE File Pointer
ED EXAMPLE 1 2 3

List directory EXAMPLE.d
jdir or ls EXAMPLE.d

EXAMPLE JBASE JEDI SUBROUTINE DRIVER

Copy the "GEN_SUB.b" program from the "src" subdirectory in the jBASE release directory and compile.
jbc -c GEN_SUB.b
jBuildSLib -o $HOME/lib/libGEN.so GEN_SUB.o
jBuildSLib -o %HOME%\lib\libGEN.so GEN_SUB.obj

Create normal HASH files.
CREATE-FILE GENFILE 1 1

Create jBASE File Pointer
ED . GENFILEX
JBC__SOB JediInitSUB GEN_SUB GENFILE

Edit jBASE File Pointer.
ED GENFILEX 1 2 3

List hash file.
LIST GENFILE

EXAMPLE JBASE JEDI SUBROUTINE DRIVER FOR ORACLE ON WINDOWS

Copy the "ORA_SUB.b" program and "sqlsubs.pc" from the "src" subdirectory in the jBASE release directory and pre compile with ORACLE compiler and then compile.

Set library path to include Oracle libraries
set lib=%ORACLE_HOME%\pro21\lib;%lib%

Set jBASE environment variables for ORACLE NT libraries and precompiler options.
set JBC_SQLPREPROC=proc21 mode=oracle iname=
set JBC_SQLLIBS=/MD SQLLIB17.LIB

Copy jBASE jmv.exe to move.exe as required by jbc -Jqo options
cp C:\JBASE30\bin\jmv.exe C:\JBASE30\bin\move.exe

In SQL*PLUS create SQL table:
SQL> CREATE TABLE ORATABLE ( ORAID VARCHAR(8) NOT NULL PRIMARY KEY, ORARECORD VARCHAR2(1500));

Precompile sqlsubs error functions:
proc21 mode=oracle iname=sqlsubs.pc

Compile sqlsubs.c in to a .obj
cl /c /Zi /D_X86=1 /DWIN32 sqlsubs.c /IC:\JBASE30\include

Precompile the ORA_SUB.b subroutine:
jbc -c -Jqo -Jv ORA_SUB.b

Build a dynamic linked library contain your subroutine and error functions:
jBuildSLib -o libORA.dll ORA_SUB.obj sqlsubs.obj -l SQLLIB17.LIB

Copy dll and def to your %HOME% "lib" subdirectory so it can be found by jEDI:
cp libORA.dll %HOME%\lib
cp libORA.def %HOME%\lib
cp libORA.lib %HOME%\lib

Create jBASE File Pointer
ED . EXAMPLE1
Top
.I
000+ JBC__SOB JediInitORA ORA_SUB ORATABLE
000+
.FI

Access SQL table via jEDI subroutine driver
ED ORATABLE A B C
LIST ORATABLE
COUNT ORATABLE

In SQL*PLUS check updates

Index