Atteya

How To Config SQL Intelligent

1) Install JDK by running jdk-6u45-windows-i586.exe
No changes in default settings required.
2) Install Tomcat by running apache-tomcat-6.0.37.exe
Please use directory like C:\Tomcat
3) Go to System properties -> Advanced -> Environment variables -> System variables
Create new variables:
CATALINA_HOME			C:\Tomcat
JAVA_HOME			C:\Program Files\Java\jdk1.6.0_45\bin\
4) Stop Tomcat in services if it is running
Find service "Apache Tomcat 6"
5) Configure UTF-8
Edit Tomcat\conf\server.xml
and add useBodyEncodingForURI="true" into connector for port 8080
Result:
<Connector port="8080" protocol="HTTP/1.1" useBodyEncodingForURI="true"
               connectionTimeout="20000" 
               redirectPort="8443" />
6) Configure maximum heap size
Maximum heap size: this is the maximum amount of heap memory the Java Virtual Machine (JVM) is allowed to allocate. For most JVMs, the default setting of the maximum heap size is 64MB. You can increase the maximum heap size of applications by setting the -Xmx JVM parameter. For example -Xmx1024m allows maximum 1GB (1024MB) heap to be allocated for the JVM.
Note: it is recommended to specify a considerably lower value than the amount of physical RAM in your system, so the operating system and other applications will also have enough space. Otherwise the swap memory of the operating system will be used, which can result in high disk activity, and reduced system performance.
7) Run Tomcat in Services
8) Go to Apache Tomcat 6 properties in Services and change Startup type to Automatic
9) Use web brouser http://127.0.0.1:8080/
Click on Manager and deploy SqlStream.war
10) Click to SqlStream or use link http://127.0.0.1:8080/SqlStream/SqlStream.do
11) You are on the configuration screen.
a) Insert your DB server
b) Insert DB server listener port
c) Insert DB server instance name/service/SID
d) Choose type of user login
  I) Oracle DB type - every user has his own account in your database
  II) Oracle EBS type - every user has his own account in your Oracle EBS system
e) Insert DB account and DB password
- For User type (I) it will not be saved and it is only for DB connection control.
- For user type (II) it will be saved and used for every contact with DB.
f) Insert your ADMIN user - this will be controlled against real users
g) After DB connection is successful and ADMIN is correct you can go to SQL Intelligent
12) Make you own SQL forms

 

 

obr-loga