users
[Top] [All Lists]

Help: JDBC connection for WIndows CE embedded Java device fails

To: users@xxxxxxxxxx
Subject: Help: JDBC connection for WIndows CE embedded Java device fails
From: "Manisha Kode" <mkkode@xxxxxxxxxxx>
Date: Fri, 25 Jun 2004 14:52:48 -0400
Bcc:
Delivered-to: mailing list users@cinjug.org
Mailing-list: contact users-help@cinjug.org; run by ezmlm
Hello All,

I am sure everyone is ready for weekend... I have to fix this problem to demo the application on Monday at client site... I know its crazy... Any and all help is really appreciated... I have exhausted all my resources.. You guys are the last and only hope...

I have an applet which makes a JDBC connection to the database which is residing on the same server as the web server

This applet works fine from the server and remote client which has windows 2000 OS.

I am testing the same applet from a device which has WIndows CE .Net with CrEme JVM

The applet comes up.. but gets an error "No Suitable Driver " in getConnection method while trying to establish the DB connection.

Changing the driver class file gives me an error class not found.. SO i am sure that the driver class is found

I have tried all the different URL connection strings given on the oracle FAQ site as well as in any message on the web.. All those strings work on the server with windows 2000...but do not work on the windows CE device

Do I need to change any settings of the DB on the server to allow CE devices to connect to DB?
I have taken care of the security permissions needed for this in java.policy file ..
grant {
permission java.util.PropertyPermission "oracle.jdbc.J2EE13Compliant", "read";
permission java.util.PropertyPermission "oracle.jserver.version", "read";
}



Below is the code.. the commented statements can be used and they work..

try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//Class.forName ("oracle.jdbc.driver.OracleDriver").newInstance();
System.out.println("Registred the driver");
// con = DriverManager.getConnection("jdbc:oracle:thin:@//b2d-devserver:1521/b2d9isvr.b2dsolutions.com","b2d3","b2d2003");
con = DriverManager.getConnection
("jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS =(HOST=b2d-devserver)(PROTOCOL=TCP)(PORT = 1521))(CONNECT_DATA =(service_name=b2d9isvr.b2dsolutions.com)))","b2d3","b2d2003");
empValues.setText("Connected to the Database. Fetching Values from PLANT Table.\n");
fetchValues();
} catch (SQLException ex) {
System.out.println("Connection Error = " + ex.toString());
ex.printStackTrace();
}
catch (Exception E) {
System.err.println("Unable to load JDBC driver.");
E.printStackTrace();
}
------------------------------------------


I really appreciate any suggestions.

Thanks,
Manisha.

_________________________________________________________________
MSN Movies - Trailers, showtimes, DVD's, and the latest news from Hollywood! http://movies.msn.click-url.com/go/onm00200509ave/direct/01/



<Prev in Thread] Current Thread [Next in Thread>