JDBC driver Oracle example api run problem
627919Nov 23 2008 — edited Nov 26 2008Hello
I am trying to run the demo application of the Mashing Google Maps with Oracle Database but I'm getting errors. The application I'm trying to run you can find it here:
http://www.oracle.com/technology/pub/articles/schalk-googlemaps.html
Following the steps in the setup file are not helping because I still don't know what to put here:
private static String jdbcURL = "jdbc:oracle:thin:@localhost:1521:orcl";
I have searched for the jdbc driver to install and learned that is already included in oracle jdeveloper I think. I don't know if is the thin driver or another type nor where to find out that. Also about the database orcl ....I have no idea what to pun in that field. (localhost:1521:orcl";)
When I use sql plus or developer or forms I connect using host strings localhost/xe and in my tnsnames.ora the setting are the following:
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = //localhost/xe)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
If I run the acme_hotels.html from jdeveloper I get this error
While trying to retrieve the URL: http://10.9.1.157:8988/ACME-Hotel-Locator/acme_hotels.html
The following error was encountered:
* Access Denied.
Please help me with this problem and let me know how to understand the host name and database I am supposed to pun in the fields for the application to work.
Thanks!