3.1 Server setup Oracle 11g - reubenjohn/aceqlandroid GitHub Wiki

Prerequisites

You must already have Oracle 11g installed and tested.

About

This guide has been tested with Oracle 11g Rev 2. However, it should work with other versions.

Step 1

Choose you AceQL Edition
For starters, you need the Professional version in order to connect to a commercial DB such as Oracle 11g. This means that you can either purchase a license or go for the trial version. If your going for the trial version, then submit this form, and you should receive the trial licence via Email.

Step 2

Download & Installation
Download the AceQL Pro version and extract it to a path of your choice.

Step 3

In the conf folder you'll find a file called aceql-server.properties inside which, you must change the following values to match those that you received by email. The following is an example:

license.name = John Smith
license.email = [email protected] 
license.company = Smith Software
license.licenseKey = SERVER-HOST1-a8876f744027d35de7632ca0de9a49021487e671 

Step 4

Add your JDBC driver to AceQL installation
All you need to do is drop you JDBC driver jar into ACEQL_HOME/lib-server directory. In case of Oracle 11g, you can find it here. Personally, I downloaded the 'ojdbc6.jar'.

Step 5

Tomcat JDBC Connection Pool Section
Only the following four properties must be defined:

driverClassName | The fully qualified Java class name of the JDBC driver to be used(oracle.jdbc.driver.OracleDriver for oracle).
url | The connection URL to be passed to our JDBC driver to establish a connection(jdbc:oracle:thin:@localhost:1521:ORCL should work for Oracle).
username | The connection username to be passed to our JDBC driver to establish a connection.
password | The connection password to be passed to our JDBC driver to establish a connection.

Example:

driverClassName = oracle.jdbc.driver.OracleDriver
url = jdbc:oracle:thin:@localhost:1521:ORCL
username = your_username
password = your_password

Step 6

Create a start.bat and a shortcut to it with administrator access as explained here.

Step 7

Now, simply launch the shortcut, and you should get an output similar to this:

[ACEQL START] Starting AceQL Web Server...
[ACEQL START] AceQL Open Source v4.0 - 08-dec-2015
[ACEQL START] Using properties file: c:\Users\Mike\aceql-4.0-bin\conf\aceql-server.properties
[ACEQL START] Setting System Properties:
[ACEQL START] Setting Default Connector attribute values:
[ACEQL START]  -> maxThreads = 300
[ACEQL START] Setting Tomcat JDBC Pool attributes for ServerSqlManager Servlet:
[ACEQL START]  -> driverClassName = org.postgresql.Driver
[ACEQL START]  -> url = jdbc:postgresql://localhost:5432/kawansoft_example
[ACEQL START]  -> username = user1
[ACEQL START]  -> password = ********
[ACEQL START] Testing DataSource.getConnection() for ServerSqlManager Servlet:
[ACEQL START]  -> Connection OK!
[ACEQL START] ServerSqlManager Servlet Configurators:
[ACEQL START]  -> commonsConfiguratorClassName: org.kawanfw.commons.api.server.DefaultCommonsConfigurator
[ACEQL START]  -> sqlConfiguratorClassName    : org.kawanfw.sql.api.server.DefaultSqlConfigurator
[ACEQL START]  -> fileConfiguratorClassName   : org.kawanfw.file.api.server.DefaultFileConfigurator
[ACEQL START]  -> Configurators Status: OK.
[ACEQL START]  -> URL for client side         : jdbc:aceql:http://localhost:9090/ServerSqlManager
[ACEQL START] AceQL Web Server OK. Running on port 9090.
[ACEQL START] To close normally: java org.kawanfw.sql.WebServer -stop -port 9090
[ACEQL START] From command line, use [Ctrl]+[C] to abort abruptly

Finally, we still strongly recommend going through the Official user guide.