Monday, September 10, 2012

Where are the DB connections stored in JDeveloper?

Hi,
For those of you who ever wondered:
Where does JDeveloper hold all those DB connections??

The answer is:

Per Version:
11gR1
C:\x\system11.1.1.5.37.60.13\o.jdevimpl.rescat2

C:\x\system11.1.1.6.38.61.92\o.jdevimpl.rescat2
11gR2
 C:\s\system11.1.2.2.39.61.83.1\o.jdeveloper.rescat2.model

In those folders you will notice the following structure:






The most interesting part is the file inside the connections folder. if you open the folder you will see the file:
connections.xml
here is a sample part of that file:

      
      
         
            XE
         
         
            oraJDBC
         
         
            localhost
         
         
            hr
         
         
            1521
         
         
         
            true
         
         
            thin
         
      
   



hooray!! there is our connection!
We can simple take the xml and place it there! all will be fine!
Well, not exactly, if you notice the xml more carefully, you will see that there is no password information.. and you can easily guess that the cwallet.sso file must be holding those references.
Alright then! lets just copy those ones only.
To be honest, I just did it and I must say that I do not see any problems what so far..
The down side: You have to restart JDeveloper in order the changes to take effect. Which in my opinion, it will take more time to export and import properly.

In conclusion, we now know where the DB connections are stored in our various versions of JDeveloper.

I will still use export and import as the prefered process. 

cheers.

References:

http://www.baigzeeshan.com/2012/07/sharing-common-connections-between.html

No comments:

Post a Comment

LinkWithin

Related Posts Plugin for WordPress, Blogger...