Connect Java Application to Oracle Server

Use the following connection string to connect Java Applications to Oracle Database Serve

User Name: un
Password: p/w

jdbc:oracle:thin:@IP_Address_or_DomainName:1521:ora11g

Oracle Mapbuilder Example:

Oracle Commands

• To connect from client use sqlplus and type (username/password@hostname/servicename(sid))
• To list all tables names for the logged in user (select table_name from user_tables;)
• To select cashed maps (select name from user_sdo_cached_maps;)

• java.lang.OutOfMemoryError: Java heap space; It means Map builder requires more heap memory to load spatial data. To solve it.: Open the command line and start the Map Builder application as follows. java -jar -Xmx1024M D:\mapbuilder.jar