Installing error of Oracle lite

[Garlands]

Hello sir !
I am installing Oracle lite on my PC,The installer succeed in the copying process but after that it restrict me for further installation and occur a long list of java exceptions error like :

Parameter "orahome" = C:\Oracle
Parameter "instype" = custom
Parameter "inscomp" = net8,client
Parameter "insprtcl" = tcp,nmp
- - - -
-- - - -
---
Please give me some solutions to ignore this error message and can go further for next installation.

[opaper]

Installing error of Oracle lite :

You are installing the oracle lite and it occur the error message as a java exceptions,There are some prerequisites to which you need to follow as mentioned below:

• Install the JDK 1.2.2 before installing 9i Lite5.0
• The oracle lite should be installed in its own directory like d:\oracle\9iLite
• Configure the CLASSPATH for JDK 1.2.2 location.
• Make sure the instance has been completely shut down during installtion.
• The parameter WEBTOGO.WORLD should be specified in TNSNAMES.ORA file.

[MindSpace]

compatibility with Oracle lite to server :

There are some features it have which is not compatible with oracle server.

1- Java stored procedure can execute but whole PL/SQL is not supported.
2- It doesn't support the large server functionality for example : Java CORBA ORB's, SQL*Net Listeners
3- The rows are arranged and stored as a object and it contains a external object layer on top.
4- It provide some limited use of dictionaries like ALL_TABLES, ALL_VIEWS, ALL_USERS, CAT,etc.
5- The database of oracle lite can be fetched by only remote client in case of data replication.

[Modifier]

Oracle lite and relevant features

Oracle Light (POL) is a small software product to work with single-user object/relational database for limited configured hardwares like desktops, laptops, down to the smallest hand help devices. Mainly it is developed for constructing mobile and distributed applications.

It contains some features like :
-It can run with 1MB of RAM and 4MB of hard disk.
-The support of java and SQL are provided with this.
-ODBC and JDBC can be layered.
-It is capable to handle 16 concurrent application connections
-Compatible with WindowsNT, Windows95/98, WindowsCE, and PalmOS.

[Praetor]

Connecting with a Oracle Lite database :

To connect with Oracle lite database,you need to use the SYSTEM and password is avoided to use with this database but in the case of SQL*Plus need to set the password.The connection string is declared as ODBC.

The following statement would be used to access the oracle lite database using SQL*Plus utility :

sqlplus system/manager@odbc:polite:polite
SQL> select * from all_tables;

SQL> exit;

And with Oracle 9i use the Mobile SQL (msql) for login with same procedure.

[Katty]

Writing Java Stored Procedures :

To create a java procedure with oracle lite you need to follow the folllowing step :

create a Java class "Emp_class" in a file called EM.java to implement the get_salary method:

import java.sql.*;

public class Emp_class {

  public static int get_salary(Connection conn, int empno) throws Exception
  {
     Statement s = conn.createStatement();
     ResultSet r = s.executeQuery("SELECT sal, nvl(comm,0) FROM EMP WHERE empno="+empno);
     int     sal = 0;

     if (r.next()) {
        sal = r.getInt(1) + r.getInt(2);   /* sal = :sal + :comm */
     } else {
        throw new Exception("Employee "+empno+" is invalid.");
     }

     r.close();  s.close();
     System.out.println("Salary for employee "+empno+" is "+sal);
     return sal;
  }
}

And attach this java class to the table named Employees :

ALTER TABLE EMPLOYEES ATTACH SOURCE "Emp_class" IN '.';

To execute the Method within ODBC :

SQLExecDirect(hstm, "SELECT EMP."get_salary"(7369) FROM DUAL");