Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JDBC driver Oracle example api run problem

627919Nov 23 2008 — edited Nov 26 2008
Hello

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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2008
Added on Nov 23 2008
16 comments
2,610 views