JUDDI's blog

How to resolve "Several ports (8005, 8080, 8009) required by Tomcat Server at localhost are already in use"

2013-11-04T20:59:00.003-08:00

Hi
Apache tomcat server default port is 8080. sometime Follow error occur when you running apache tomcat server "Several ports (8005, 8080, 8009) required by Tomcat Server at localhost are already in use" I can change port 8080 into server.xml for tomcat config. It is easy
so I will found What process running use in 8080?
If you are running on windows try this in the command line prompt: >netstat -a it's show all process You will find process with 8080 port

>netstat -aon It's show allo process with PID

Go to Task manager and find process by PID from process list. You'll know what process using port 8080. In my machine Oracle Database Express used to 8080 port. Default insttallation setting up port 8080.
How to change Oracle Database Express default port? Try this in the command line prompt:

>sqlplus / as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on Mi Jan 25 11:44:33 2006

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

SQL> -- get current status
SQL> select dbms_xdb.gethttpport as "HTTP-Port"
            , dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port   FTP-Port
---------- ----------
     8080          0


You can change the http port and the ftp port to whatever you

like (keep in mind that you need special privileges for ports < 1024 on Unix/Linux systems).


SQL> -- set http port and ftp port
SQL> begin
 2    dbms_xdb.sethttpport('80');
 3    dbms_xdb.setftpport('2100');
 4  end;
 5  /

PL/SQL procedure successfully completed.

SQL> select dbms_xdb.gethttpport as "HTTP-Port"
            , dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port   FTP-Port
---------- ----------
       80       2100

thanks Juddi

Resolve: java.lang.AssertionError: CurrencyKey not preserved error for ADF web application

2012-11-09T01:19:00.001-08:00

Hi, I used to dvt:hierarchyViewer component into fragment page. then I depoyed adf web application to IntegratedWeblogicServer(Default Domain) . It's okey. but deploy to custom weblogic domain (You can read here about ADF application deployment to custom weblogic domain) following error:

I resolved the error by follow step.
1. open setDomainEnv.cmpd(Windows) or setDomainEnv.sh(Linux).
2. -da:org.apache.myfaces.trinidad.component.UIXCollection add to setDomainEnv.sh like a follow pic.

3. execute setDomainEnv.sh
4. restart weblogic domain.

well done :)

thanks juddi

How to resolve 'INST-07309: Specified Master Repository credentials are not valid' error

2012-05-28T20:24:00.000-07:00

Hi, The error occured while installing oracle data integrator(ODI) you know, how to install Oracle Data Integrator. Error log detail: INST-07309: Specified Master Repository credentials are not valid. Verify the values. Make sure the Master Database is up and running and connect string, user name, password, ODI supervisor username and ODI supervisor password are correct.

Oracle components are Weblogic 10.3.5, Oracle Data Integrator 11.1.1.5.0. but RCU component was older version rcu 11.1.1.4.0. so I was able to get it right by downloading a newer version of RCU. Using 11.1.1.5.0. instead of 11.1.1.4.0. solved the problem thanks juddi

Establish a DBAdapter Deployment Plan Directory

2012-02-24T03:36:00.001-08:00

In my previous post http://juddi-oracle.blogspot.com/2012/02/oracle-service-bus-11g-and-soa-suite-db.html here. I posted about JCA adapter service. The below picture:

What mean JNDI name?
I get service datas from Hr schema. The first I need to create Hr Data Source in weblogic. here How to create Data source in weblogic 11g console.

Create an Outbound Connection Pool
1. Click Deployments in Domain Structure pane.

2. Click DBadapter in Summary of Deployments pane.
3. Click Configuration -> Outbound Connection Pools tab.
4. Click New button.

5.Select javax.resource.cci.ConnectionFactory and click Next.

6. Enter JNDI Name: eis/DB/HrDS

Click finish.

7. Assign Data Source to Connection Pool
a. Click newly created outbound connection pool. eis/DB/HrDS

b. Click properties tab and enter xADataSourceName. Insert jdbc/HrDS value.

8. Redeploy DbAdapter.
select DbAdapter from deployments. Click Update button then select Redeploy this application using the following deployment files. click finish

select DbAdapter from deployments. select Start dropdown and select Servicing all requests.

How to create a DataSource in WebLogic Server 11g console

2012-02-24T01:21:00.005-08:00

In this post, You will learn how to create data source in weblogic 11g administration console.

thanks.

Oracle Service Bus 11g and SOA Suite DB Adapter

2012-02-13T07:59:00.006-08:00

I have not enough experience for Oracle Service Bus and SOA Suite. I have been working on Web Service(OSB) for about 2 years.
In today, I am posting about DB adapter to use create business service on OSB.

The post will show How to get data rows from any Database . My Data is into HR schemas. HR schema is oracle database demo schema and you can download if you have not. First project is SOA SUITE application on JDeveloper.

1. Start jdeveloper IDE. Create new Application. New Gallery dialog will show.

select SOA Project from items and click Ok.insert to Application name "SOA_HR".
2. Create new SOA Project. right click in the application project and new project.

3. Create Inbound DB adapter.

select DB Adapter and drag to SCA Composite. follow dialog appear. Click next.

4. Insert service name and click next. Service named "Department".

5. Service connection dialog appear. select a database connection already defined in your project or create new connection. HrDS connection is HR schemas. I hope You can create database connection for JDeveloper IDE. You need to attension to JNDI name. This string configured on DbAdapter jar. click next.

6. DbAdapter have some operation types. You can call procedure or function already defined in Database. else execute Insert,Update and Delete operations. or execute pure SQL query. select statement from dialog. click next.

7.Click Import tables. click next.

8. If your imported tables are relationship tables You can set relationship between tables. If no , click next button.

9. Attribute filtering choose dialog. If you would like to exclude all attributes from the database, check all.Primary key attributes cannot be excluded. That's are disabled.

10. You can define selection criteria.

11.Click next .

12.Import jdeveloper project to eclipse workspace. You need to do follow steps.
The first, you must be create OSB Configuration project and OSB project into workspace.

13. then Run JCA business service and input dep_id parameter. click execute.

well, I hope this post help you teaching adapter service and osb. next time I will post get data to use FTP and FILE adapters.

How to Install Oracle Weblogic Server 10.0.3.4

2012-01-14T00:28:00.009-08:00

In this post I will how to install oracle weblogic server for Windows OS and Linux OS. my screenshots and steps are pertain for Windows, but they're almost same. You can download latest version of weblogic server from here
Weblogic install package is not same. Some are with Oracle Coherence and Oracle Enterprice Pack for Eclipse(OEPE).
If you have already JVM on your server. You can choose generic install package.

Hardware requirement:
Processor Type: Intel Xeon or Pentium IV
Processor Speed: 2.4 GHz or higher
Number of Processors: 1 or more (if required)
Memory 2 GB
Hard Disk Space: 20 GB (initial size)
Operating System: RedHat Enterprise Linux 4 Update 5

There are three installation mode.
Graphical Mode- GUI based
Console Mode- console
Silent Mode- use XML properties file

1. Go to install directory. click installer file (exe on windows, bin on Linux)

2. The choose oracle home directory screen appears. Create Oracle Middleware home. If you have already Oracle Middleware Home you can select existing Oracle Home.

3. then uncheck Security Updates.

4.Two installation type:
a. Typical
b. Custom
in the choose install type screen. the choose custom option and click next.

5. select the bundled JDK. If you have already installed JDK in the computer. You can choose local JDK.

6. Oracle Home Directory and some products locations appears. For example: WebLogic server, oracle coherence. click next.

7.Click next.

8. In the installation summary. The screen shows your selected component and products. they will install to your oracle home directory. click next.

9. Installation process appears.

10. Installation process finished. click finish.

How to JDeveloper memory settings

2011-12-02T07:38:00.001-08:00

Before, Did you get warning message the "Low memory warning" on JDeveloper .

I will describe how to fix it. There are two config files on jdeveloper installation directory.
the first one is jdev.conf file. the file located in \jdeveloper\jdev\bin
increase the memory values for the following parameters:
AddVMOption -XX:MaxPermSize=1024M

the second one is ide.conf file on \jdeveloper\ide\bin.

AddVMOption -Xmx1024M
AddVMOption -Xms1024M

For now start JDeveloper. if jdeveloper can not start, decrease memory allocated values and retry to start jdeveloper

How to change jdeveloper domain creation location

2011-12-01T20:38:00.001-08:00

when you run any adf web application using integrated weblogic server, domain not create oracle product home directory and
The domain located to default location. for example

C:\Users\Administrator\AppData\Roaming\JDeveloper\system11.1.1.4.37.59.23 like this.

to change values of two variables :JDEV_USER_HOME,JDEV_USER_DIR

1. to to oracle product installed directory
2. \jdeveloper\jdev\bin
3. open jdev.boot file.
4. check below line as picture.

to set environment variables set:
this will create two variable in system variable.
It shows follow pictures.

for now. Restart jdeveloper and run adf application and will create new integreted domain to pointed your location.

ADF Query Component Usage with ADF Panel Stretch Layout

2011-11-30T03:31:00.001-08:00

There is a very nice layout component in ADF 11g - af:panelStretchLayout (ADF Panel Stretch Layout). This component comes with 5 facets - Bottom, Center, End, Start and Top. It allows to split your page layout in more easy way - you can put menu component into Top facet, functional logic into Center facet.

Everything seems okej and clear, however there is hidden issue when you need to have menu elements in Top facet dependent on ADF Query from Center facet. For example, menu item can be enabled/disabled based on ADF Query results:

click here detail read post

project workspace download :PanelStretchLayoutADFQuery.zip

JDeveloper 11g and ADF Task Flow Parameters

2011-11-30T03:30:00.001-08:00

Developed sample application - TaskFlowParamaters.zip is based on standard HR schema, Departments and Employees entities. Unbounded task flow contains selectDepartments page and call to separate bounded task flow. Bounded task flow contains employees page and Task Flow Return component, this component allow to return to calling ADF Task Flow.

When I was creating this application, I have used Fusion Web Application (ADF) as a template for developed sample application. Empty unbounded task flow was created automatically - adfc-config.xml. My next step was to create bounded task flow - task-flow-definition.xml:
click here detail read post

project workspace download :TaskFlowParamaters.zip

Create, Edit and Delete operations in ADF Faces af:table component

2011-11-30T03:29:00.001-08:00

Developed sample application EditableTable11.zip, provides read-only table with those actions - Delete, Create, Edit, Save, Cancel. Row selected for editing is shown in editable mode and can be updated. Application is based on HR schema that comes with Oracle XE database. Application logic is based on Jobs entity from HR schema.
This sample is developed using the same principle as described in my previous post. I will describe what are the differences in implementation:
click here detail read post

project workspace download :EditableTable11.zip

Install Oracle JDevevoper

2011-11-28T20:50:00.001-08:00

In this post, I will explain how to install oracle jdeveloper tools on windows and linux os. which is almost same way.
1. first of all you must download jdeveloper installer from here.
2. click the exe installer file

3. click next.

4. choose oracle middleware home. if you have already oracle home which is show on and didn't have select create new middleware home.

5. click next

6. Installation process will install the following software products
JDeveloper and ADF
Weblogic Server

7. choose JDK

If you had already installed jdk, you can set the jdk location. if not new jdk will install on your oracle home.
8. click next

9. click next.

here you can insert Node manager port. Default value is 5556. if select YES nodemanager automatically runs when start OS

10. starting install
11. Installation Summary

that's finish

ADF application deployment to custom weblogic domain

2011-11-27T20:51:00.001-08:00

few days ago, I had problems for adf web application deployment to weblogic custom domain.
today is, I will post about the web deploy to custom domain.

There are some some useful posts:
http://blogs.oracle.com/shay/entry/common_pitfalls_when_deploying
http://radalcove.com/blog/?p=34
http://www.oracle.com/webfolder/technetwork/jdeveloper/howto/11114/managedserver/wlsadfms.html
http://chrismuir.sys-con.com/node/952411/mobile
http://technology.amis.nl/blog/6167/deploying-and-running-adf-11g-applications-on-weblogic-11g

If below error occurs while deploying the error fixed by follow steps

1. Caused by: java.lang.ClassNotFoundException: oracle.adf.model.servlet.ADFBindingFilter
See server logs or server console for more details.

----check ADF Web Runtime

2. Caused by: java.lang.ClassNotFoundException: oracle.bc4j.mbean.BC4JConfigLifeCycleCallBack
See server logs or server console for more details.

----check BC4J Runtime

3. Caused by: java.lang.ClassNotFoundException: oracle.jsp.runtimev2.JspServlet
See server logs or server console for more details.

----
ojsp.jar: copy ojsp.jar file to domain lib directory and restart domain

4.Caused by: java.lang.ClassNotFoundException: oracle.adf.library.webapp.ResourceServlet
See server logs or server console for more details.

----ADF Common Web Runtime

go to Project properties->deployments->Edit->WEB-INF/lib->contributors on left tab panel then check libraries.

okey ,now deployment success finished. The application worked normal. but showed up warning message on admin consle and UI.

I added to the groovy-all jar file to the CLASSPATH in setDomainEnv.sh.

Passing Parameters from ADF Task Flow with Fragments into ADF Bounded Task Flow

2011-10-25T10:00:00.004-07:00

It is a common use case to pass parameters from ADF Task Flow with fragments into another ADF Task Flow without fragments. I got this question for my previous blog post - Parent Action Activity in ADF Task Flow. The use case:http://www.blogger.com/img/blank.gif

1. We have ADF Bounded Task Flow, it contains two main elements - page P1 and another ADF Task Flow call - C1
2. Page P1 included ADF region, this region comes from ADF Task Flow with Fragments
3. We need to pass parameter from ADF region available in P1 into ADF Task Flow call C1

click here detail read post

project workspace download :ADFRegionNavigation2.zip

MySQL Unicode Datasource Problem

2011-10-25T09:25:00.001-07:00

recently, I had problem about mysql database unicode on adf web application. In my table on mysql database table row is inserted to fine by unicode utf8 . but when insert new row to database from adf web application , unicode utf8 is not working. so i added follow connection string .

jdbc:mysql://localhost:3306/dbname?useUnicode=yes&characterEncoding=UTF8

and you need to check follow steps.
1. go to menu Tools->Preferences Encoding select UTF8
2. check encoding of all type page

ADF Task Flow in JDeveloper 11g

2011-10-25T06:49:00.001-07:00

In JDeveloper 10g there is only one possibility to design application page flow structure - using JSF navigation flows. But sometimes, use cases require to implement complex page flow, that is not supported by JSF navigation flows. JDeveloper 11g brings ADF task flows in addition to JSF navigation flows. From Oracle JDeveloper 11g Technology Preview, Fusion Developer's Guide for ADF:

Task flows provide a more modular and transactional approach to navigation and application control. Like standard JSF navigation flows, task flows mostly contain pages that will be viewed. However, instead of describing navigation between pages, task flows facilitate transitions between activities. Aside from navigation, task flow activities can also call methods on managed beans, evaluate an EL expression, or call another task flow, all without invoking a particular page. This facilitates reuse, as business logic can be invoked independently of the page being displayed.

click here detail read post

In developed sample application - ADFTaskFlow.zip

TrackQueryPerformed Property Usage and ADF Task Flows

2011-10-25T06:03:00.001-07:00

I will describe following scenario - two ADF Task Flows, second ADF Task Flow is opened as Isolated. First ADF Task Flow provides query functionality implemented as View Criteria, and second ADF Task Flow accepts current row key value and allows to edit data. Scenario is pretty simple, and can be implemented in Oracle ADF very fast. However, there is one trick if you open second ADF Task Flow as Isolated. I will describe it and provide solution.

click here detail read post

project workspace download :TrackQueryPerformed.zip

Communicating Between ADF Regions Without Contextual Events Framework

2011-10-20T09:57:00.001-07:00

Download sample application - RegionCommunicationPPR.zip. This sample is based on two ADF Regions - one brings Employees table data, another - Employes form data. User can select data in the table, form in the second ADF Region will be refreshed automatically and will show synchronized data

PopUpFetch Option for Property Listener

2011-10-20T09:54:00.001-07:00

With previous JDeveloper/ADF 11g releases it was quite complicated to catch popup fetch event, we were overriding popup fetch listener inside managed bean and processing it. Its a good hint, things are simpler now - there is popupFetch property with Set Property Listener component:click here detail read post

Download sample application - PopUpFetchListener.zip

Database Connection in ADF BC 11g

2011-10-20T09:49:00.001-07:00

I started to dig more and I saw that Number type is displayed as oracle.jbo.domain.Number, usually it is shown just as Number:click here detail read post

project workspace download:DatabaseConnectionADFBC.zip

This is start

2011-10-20T09:38:00.001-07:00

Hi All,
I'm java developer, few months ago, I started to study oracle technology about fusion middleware. I haven't enough experience for adf , jdeveloper, etc.But I wanna to share my just now learning knowledge to other people. I will post adf, jdeveloper, and other fusion middleware product's some knowledge. the post will contain video lesson, screenshot tutorials, examples.

Oracle Database 11g Installing and create database on windows

2011-10-20T09:37:00.001-07:00

I decided i wanted to post oracle database 11g install on window os. My laptop is running on windows 64 bit. I made screenshot for each step. i inserted those screenshot the post. next time I will post some information to install oracle db 11g on linux and Windows and Linux oracle db GUI install type is almost same.

1. You need to download oracle database 11g set up. You can download here
2. Go to install folder. execute setup.exe.

3. If you want to update you check it or unckeck

4. select one from these three install options:
a. create database and install db software
b. only install database install
c. you can upgrade an existing database
select a option.

5. Select Desktop class option.

6.You will perform a basic installation with a starter database. Enter mydb for the Global Database Name and oracle for Database Password and Confirm Password. Then, click Next.

7. you do it if you want to save installation response file to disk .

8. now starting installation process.

9. while installing on windows these error message occurs but on linux os it is fine.

10. it is finish.

11. Listener configuration:

Parent Action Activity in ADF Task Flow

2011-10-20T08:45:00.001-07:00

The problem is, that I have bounded ADF Task Flow, however main page is using region and this region can't see declared navigations from this ADF Task Flow: click here detail read post

project workspace download : ADFRegionNavigation.zip

Yes-No Check Box in Query Criteria

2011-10-20T08:33:00.001-07:00

visit to here and show detail post.

Project workspace download here: YesNoSearchBox.zip