Palm, Oracle 9iLite and JDBC problem

I'm developing a Palm application in Java (using IBMs Visual Age

Micro-Edition) which talks to an Oracle lite database sitting on the Palm

device. I want to use SQL and JDBC to connect to and query the database. I

know that I have to use the java.sql package from Sun's jdk 1.2 but I am not

sure of which classes to use from Oracle (OLITE40.jar or classes12.zip?). I

also need to know the JDBC link to connect to the database. Below is some

example SQL/JDBC code.:

import java.sql.*;

import oracle.jdbc.driver.*;

import oracle.sql.*;

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver ());

String url = "jdbc:oracle:oci8:_at_";

// Connect to the database

OracleConnection conn = (OracleConnection)DriverManager.getConnection (url,

"scott", "tiger");

.

.

.

I assume this is the way to connect to an Oracle lite database which would

reside on the Palm. I need to know if I'm correct or otherwise what is the

correct way.

Your help is greatly appreciated.

Best Regards,

Dinesh. Received on Tue Jan 29 2002 - 14:15:22 CET