Skip to Main Content

SQL Developer

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!

Where to add Third Party JDBC Driver in SQL Developer 4.1 EA2

user11068621May 1 2015 — edited May 1 2015

In SQL Developer 4.0.3 under Tools - Preferences - Database there was an option to add a  Third Party JDBC Driver so we could use the same tool for a PostgresSQL database.  I cannot find in in SQL Developer 4.1.0.18

Comments

2827010
Why do you want to use portlets based upon ADF?
Why not just expose them as taskflows. There are many drawbacks from using ADF Portlets like iframe rendering, performance, page size increase,...
878913
Hi Yannick,

Thanks for ur reply can you pls tell me how to expose them as a taskflows.....

can you pls tell me the procedure...? or any links related to this task


Thanks.
Daniel Merchán
Hi.

To work with Task Flow you have to create "Bounded Task Flow" that can be integrated with WebCenter Portal.

To build reusable bounded Task Flow I recommend you follow next steps:
- Create a Fusion Web Application in JDeveloper separate of Portal Application to develop.
- Create in the Fusion Web Application your Bounded Task Flow and test it independetly if it's possible.
- Create an ADF JAR Library of you Fusion Web Application and integrate it to your WebCenter Portal (as internal library or deployed shared lib).
- Add your Task Flow to your Resource Catalog.

Links that can help you to achieve your purpose:
- Yannick Ongena Blog about build and expose TF (http://yonaweb.be/webcenter_tutorial/part_6_building_taskflow_and_consuming_it_webcenter_portal)
- My own blog (in spanish) talking about 3 ways to integrate your ADF JAR Library in a WebCenter Portal Project (http://danielmerchanoracle.blogspot.com/2011/08/integrar-adf-task-flows-propios-en-una.html).
- Also if you search in google about ADF Task Flow and Bounded Task Flow and how to reuse you will find a lot of tutorials like http://www.oracle.com/webfolder/technetwork/tutorials/obe/jdev/obe11jdev/ps1/boundedtaskflow/bounded_task_flow.html and more...

I hope this help you.

Regards.
878913
Hi Daniel,

Thanks for reply the information you were given on task flows in web center portal its working fine ...

But i want to use same task flow in web center spaces.

Please tell me the procedure for taskflows using in web center spaces...


Thanks Daniel...
Daniel Merchán
Hi.

My recommendation is to deploy your ADF JAR Library as shared-lib in WebLogic. Is the best way to reuse the same lib between WebCenter Portal and WebCenter Spaces.

If you worked extending WebCenter Spaces you know that it works with shared-lib to add the new functionallity.
You can do the same with WebCenter Portal.

Then follow next steps:
1) Create your Task Flow inside of the Fusion Web Application.
2) Create ADF JAR Library from your Fusion Web Application.
3) Depending of Portal or Spaces:
- WebCenter Portal: Add your library to Portal classpath (following the links that I shared) but configure your deployment option to not deploy this library. Follow a guide of how to deploy your ADF JAR library as shared lib in WebLogic. Register the shared-lib in your weblogic.xml and redeploy your Portal Application.
- WebCenter Spaces: Register your shared-lib in weblogic.xml and redeploy WebCenter Spaces using the scripts. Or add your libraries to the default shared-lib that deploy the scripts.

This guides will help you to deploy your code in WebCenter Spaces
http://www.oracle.com/technetwork/middleware/webcenter/portal/owcs-ps5-wcs-ext-samples-wp-1423852.pdf (Samples)
http://docs.oracle.com/cd/E23943_01/webcenter.1111/e10148/jpsdg_wcsres.htm (Understand how Spaces works)

I hope this help you.

Edited by: Daniel Merchán on 12-mar-2013 10:20
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 29 2015
Added on May 1 2015
2 comments
578 views