Advanced Oracle JDBC Connection Support

By default the connection string for the database used for the product is as per the JDBC standard and is in the format:

jdbc:oracle:thin:@[hostname]:[dbport]:[database]

where
[hostname] - Database hostname
[dbport] - Database Listener portname
[database] - Database Name

The URL format is described in the Oracle JDBC documentation.

This configuration setting is sufficient for the majority of the environments at a site. If your site requires a specialist URL, for RAC support (for example) then you must override the default URL.

To enable the use of this functionality, you must install Patch 7924537 (for V2.2 customers)/7534052 (for V2.1 customers) from Metalink

After installing the patch, you can create a file called dbconn_override.txt in the environment under the $SPLEBASE\etc for Linux/UNIX (or %SPLEBASE%/etc for Windows) folder containing the override string. This setting will replace the database connection URL used by all modes of access at configuration time.

To reflect the change into the product you must:

  • Execute configureEnv[.sh] to detect the override file when using the "p" option to process the configuration file. Note: The dbconn_override.txt must exist each time you run configureEnv[.sh]

  • Execute initialSetup[.sh] to place the override in the appropriate hibernate.properties files. Note: When running initialSetup[.sh] any manual customization (outside of the normal configuration process) will need to be manually reapplied.

  • Redeploy the Web Applications using the appropriate deploy commands.
    These are a few examples of database connection overrides.

Example contents of dbconn_override.txt using Oracle JDBC thin client (for Oracle Real Application Clustering):

jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = machine-name)(PORT = 1251))
(ADDRESS = (PROTOCOL = TCP)(HOST = machine-name)(PORT = 1251)
(LOAD_BALANCE = yes)
(FAILOVER=YES)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SID.WORLD)
)
)

Example contents of dbconn_override.txt Oracle JDBC thick client:

jdbc:oracle:oci:@SID.WORLD

Note: For thick client to work, the Oracle client library directory must be added to the library search path. Oracle client libraries are installed under $ORACLE_HOME/lib and ORACLE_HOME/lib32 directories. Add this directory to the library search path environment variable. The library search path environment for AIX is LIBPATH, for HP-UX is SH_LIB_PATH for Linux is LD_LIBRARY_PATH and for Windows is PATH.

Comments:

That's a great way to use JDBC Connection.

Posted by Surachart Opun on April 06, 2009 at 12:08 PM EST #

check your db connection

Posted by hs jo on April 08, 2009 at 12:16 PM EST #

Well I'm going to have to look up a couple more things but this was a pretty good place to start.

Posted by wireless network manager on January 14, 2010 at 09:09 PM EST #

Good Morning, Thanks for the excellent post, I dont usually leave messages but your post inspired me!! I just had a look at one of those Ipads and they look great, although the screen is huge I like it. I can see a lots of them needing support when the screen breaks :) Keep up the great work and look forward to more posts

Posted by PC Support on May 27, 2010 at 02:22 PM EST #

Nice post. Just found it on Yahoo. Thanks 4 the useful info. Keep up the good work :)

Posted by Reynaldo Yarnell on June 20, 2010 at 04:40 AM EST #

Great insight on proxies. Thanks! Would a proxy also be be worthwill for browsing the internet?

Posted by Proxy on July 15, 2010 at 04:07 AM EST #

sir i had eclipse europa and oracle 11g sofware but doesn't connect this what will do and how will connect

Posted by balan on July 19, 2010 at 03:50 PM EST #

Pretty useful info here. BTW, I think I read a really similar article on an additional blog today, in fact i'm pretty certain. I 'll check it out and let you know, maybe they copied your content, who knows.

Posted by federal firearms license on September 20, 2010 at 03:47 PM EST #

Thanks for this post, your website is carrying out excellent service to the fashion sector! I graduated Otis Parsons School of Design and am currently doing work on building an on-line discussion board for those earning a living within the market to affix with each other. Thanks for the helpful info.

Posted by fashion on October 01, 2010 at 12:28 PM EST #

To be honest I am still struggling in internet marketing. What would be the number 1 advice? What is the most crucial lesson you have learned?

Posted by Heimarbeit Geld Verdienen on October 07, 2010 at 05:33 PM EST #

The desire of knowledge, like the thirst for riches, increases ever with the acquisition of it.

Posted by Elinor Khalil on October 22, 2010 at 10:09 PM EST #

If i gave a dollar for the amount of great articles you have written you would be rich. Just thought i would let you know how grateful i am.

Posted by shower bench on October 27, 2010 at 01:59 PM EST #

oversize log you include

Posted by Federico Mckiver on November 01, 2010 at 03:02 AM EST #

I am a relative newbie to some of the online marketing tactics. What would be your first step if you were a complete beginner who knows what you know now?

Posted by James Stemp on November 16, 2010 at 07:23 AM EST #

In searching for sites related to web hosting and specifically comparison hosting linux plan web, your site came up.

Posted by Immigration on December 03, 2010 at 11:11 PM EST #

I question if the juices that people promote do really work ? I know a close booster that tells it does, I gotta try then.

Posted by Houston Lawyers on December 27, 2010 at 07:03 PM EST #

“Gravitation is not responsible for people falling in love.” -Albert Einstein.

Posted by Erin Marriott on January 06, 2011 at 03:03 AM EST #

what a wonderful way to start blogging

Posted by blogging on January 06, 2011 at 03:19 AM EST #

“Change will not come if we wait for some other person or some other time. We are the ones we’ve been waiting for. We are the change that we seek.” – Barack Obama

Posted by Jorge Greenham on January 06, 2011 at 08:42 AM EST #

“Obstacles are those frightful things you see when you take your eyes off your goals.” – Sydney Smith

Posted by Grant Jentsch on January 06, 2011 at 10:15 AM EST #

I found your site from wikipedia and read a few of your other blog posts.They are cool. Pls continue this great work. Later on other fantastic American rock acts such as Lynrd Skynrd, The Eagles, America, the Allman Brothers, and the Doobie Brothers would come on the scene and shake up the world with their string of hit songs.

Posted by cheap Zithromax canada on January 21, 2011 at 04:07 PM EST #

Good article, but I can't see this clearly I think.

Posted by printable coupons on January 23, 2011 at 03:29 PM EST #

This Blog was most helpful, your ideas are straight to the point, and the colors are cool too.

Posted by Josphine Councilman on February 04, 2011 at 08:06 AM EST #

Your thoughts and opinions help me see the light. Thanks.

Posted by Tyson Prvitt on February 04, 2011 at 08:42 AM EST #

Great wordpress blog here.. It's hard to find quality writing like yours these days. I really appreciate people like you! take care :)

Posted by Link Building on March 12, 2011 at 12:30 PM EST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Anthony Shorten
Hi, I am Anthony Shorten, I am the Principal Product Manager for the Oracle Utilities Application Framework. I have been working for over 20+ years in the IT Business and am the author of many a technical whitepaper, manual and training material. I am one of the product managers working on strategy and designs for the next generation of the technology used for the Utilities and Tax markets. This blog is provided to announce new features, document tips and techniques and also outline features of the Oracle Utilities Application Framework based products. These products include Oracle Utilities Customer Care and Billing, Oracle Utilities Meter Data Management, Oracle Utilities Mobile Workforce Management and Oracle Enterprise Taxation and Policy Management. I am the product manager for the Management Pack for these products.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
9
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today