|
The access to Oberon can be realized in
three ways:
A - using a desktop client directly linked to the database
B - using a desktop client linked to an Oberon RMI
server
C - using a browser with a HTTP(s)/SOAP connection
to an application server. In this case, the application server
can access to Oberon directly or throw the Oberon RMI server.
The desktop client (or web client), the Oberon RMI server, the Application
Server and the database may be physically located on different machines.

A - When a desktop client is directly connected to the database
we must declare in the configuration file (oberon.ini ) all
connection parameters:
|
|
Description |
Samples |
| [CONNECTION] |
|
|
|
class
|
jdbc driver class |
class=oracle.jdbc.driver.OracleDriver
class=org.gjt.mm.mysql.Driver
class=org.postgresql.Driver
|
|
drvurl
|
jdbc driver url |
drvurl=jdbc:oracle:thin:@%s:%p:%d
drvurl=jdbc:oracle:oci8:@OBERON_SID
drvurl=jdbc:mysql://%s/%d
drvurl=jdbc:postgresql://%s/%d
|
|
server
|
database server IP or name |
server=127.0.0.1
server=localhost
|
|
port
|
database server port |
port=1521
port=3306
|
|
database
|
database (schema) name |
database=OBERON
|
|
dbuser
|
database user name
(in Oracle is the user associated to the schema) |
dbuser=OBERON
|
|
dbpwd
|
database user password |
dbpwd=OBERONPWD
|
|
tablespace
|
Set "false" if your database doesn't support tablespaces |
tablespace=false
|
|
connections
|
number of SQL connections to open |
connections=3
|
|
mailserver
|
mail server IP or name (for external mail) |
mailserver=localhost
|
|
serverURL
|
application server URL (for webservices) |
serverURL=http://localhost:8080/oberon
|
|
svn
|
subversion (SVN) repository account URL |
application=user:password@https://host/svn
|
|
application
|
application main menu to load with Oberon Client;
remove the declaration if you want select the application from
a list |
application=SR_Application
|
|
uid
|
Oberon user name
(set it to directly access Oberon without login)
|
uid=Richard.Green
|
|
pwd
|
Oberon user password |
pwd=mypassword
|
|
debug
|
Set "true" to add debug information
when Oberon compile the java source code |
debug=true
|
Notes:
- server/port and database are not required
for the Oracle OCI connection as they are specified in the tnsnames.ora
file and identified with the Oracle SID.
- if uid and pwd are not defined they will be asked
during the Oberon login.
- the dbuser is not required when the Oberon connects to
database with default user name
- the dbpwd is not required when the database user has the
default password
You can find examples for the oberon.ini
configuration into the /etc/samples folder.
B - If the desktop client access Oberon throw the Oberon
RMI server we need to set the RMI service URL in the configuration file (oberon.ini )
|
|
Description |
Samples
|
| [CONNECTION] |
|
|
|
registry
|
RMI service URL |
registry=//127.0.0.1:1079/OberonRMI;
//127.0.0.1:1089/OberonRMI
|
|
mailserver
|
mail server IP or name (for
external mail) |
mailserver=localhost
|
|
serverURL
|
application server URL (for
webservices) |
serverURL=http://localhost:8080/oberon
|
|
svn
|
subversion (SVN) repository account URL |
application=user:password@https://host/svn
|
|
application
|
application main menu to load with Oberon Client;
remove the declaration if you want select the application from
a list |
application=SR_Application
|
|
uid
|
Oberon user name
(set it to directly access Oberon without login) |
uid=Richard.Green
|
|
pwd
|
Oberon user password |
pwd=mypassword
|
|
debug
|
Set "true" to add debug information
when Oberon compile the java source code |
debug=true
|
Notes:
- registry can contain multiple URLs; this allows the client
to connect to multiple Oberon RMI server instances on different
servers and/or ports.
- if uid and pwd are not defined they will be asked
during the Oberon login.
In addition to the client configuration we must set the Oberon RMI
server parameters in the oberonRMI.ini
|
|
Description |
Samples
|
| [CONNECTION] |
Connection Section |
|
|
type
|
|
type=connection
|
|
driver
|
driver used (one of the subsequent
sections) |
driver=Oracle
|
|
connections
|
number of concurrent database
connections |
connections=20
|
|
database
|
database name |
database=OBERON
|
|
dbuser
|
database user name |
dbuser=OBERON
|
|
dbpwd
|
database user password |
dbpwd=OBERONPWD
|
|
mailserver
|
mail server IP or name (for
external mail) |
mailserver=localhost
|
|
debug
|
Set "true" to add debug information
when Oberon compile the java source code |
debug=true
|
| |
|
|
|
[Oracle]
|
Driver sections (one for
each available drivers) |
|
| type |
|
type=driver |
|
class
|
jdbc driver class |
class=oracle.jdbc.driver.OracleDriver
|
|
drvurl
|
jdbc driver url |
drvurl=jdbc:oracle:thin:@%s:%p:%d
|
| server |
database server IP or name |
server=127.0.0.1
|
|
port
|
database server port |
port=1521
|
This file is subdivided in two part: the connection
section and the driver list section. In the first part we must define
the driver parameter selecting one of the driver name form
the driver list section. Each driver section contains the connection
parameters to different database type.
When the Oberon RMI server starts, it opens multiple database connections,
this number is fixed with the connection parameters. If we
start up multiple RMI servers, the total number of database connections
is given by the sum of the connections for each server.
C - The usual access to Oberon is done by a web-browser,
in this case the configuration file to edit is located on the application
server, its name is : WEB-INF/classes/oberon.properties
| |
Description |
Samples
|
|
class
|
jdbc driver class |
class=oracle.jdbc.driver.OracleDriver
|
|
drvurl
|
jdbc driver url |
drvurl=jdbc:oracle:thin:@%s:%p:%d
|
|
server
|
database server IP or name |
server=127.0.0.1
|
|
port
|
database server port |
port=1521
|
|
database
|
database name |
database=OBERON
|
|
dbuser
|
database user name |
dbuser=OBERON
|
|
dbpwd
|
database user password |
dbpwd=OBERONPWD
|
|
connections
|
number of concurrent database
connections |
connections=20
|
|
mailserver
|
mail server IP or name (for
external mail) |
mailserver=localhost
|
|
debug
|
Set "true" to add debug information
when Oberon compile the java source code |
debug=true
|
When the application server accesses to Oberon
indirectly via the Oberon RMI server(s), the oberon.properties must
contains the RMI server URL(s):
| |
Description |
Samples
|
|
registry
|
RMI service URL |
registry=//127.0.0.1:1079/OberonRMI;
//127.0.0.1:1089/OberonRMI
|
|
mailserver
|
mail server IP or name (for
external mail) |
mailserver=localhost
|
|
debug
|
Set "true" to add debug information
when Oberon compile the java source code |
debug=true
|
and each RMI server must be properly configured editing
the relative oberonRMI.ini file.
|