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:
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
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