configuration


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.

 

© 2008-2012 Mirko Solazzi | Website Templates by IceTemplates.com
Please Read: Privacy Policy and Terms of Use