| 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"; }
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> |
|---|---|---|
| ||
| Previous by Date: | error in WSAD, Akalamkam, Pardha |
|---|---|
| Next by Date: | Re: [cinjug-users] Help: JDBC connection for WIndows CE embedded Java device fails, Kevin Finley |
| Previous by Thread: | error in WSAD, Akalamkam, Pardha |
| Next by Thread: | Re: [cinjug-users] Help: JDBC connection for WIndows CE embedded Java device fails, Kevin Finley |
| Indexes: | [Date] [Thread] [Top] [All Lists] |