Wednesday, August 27, 2014

Set MTU Size In LAN Network

Windows 2008 Server SP2 Standard
Windows XP Client SP3

The Default MTU size of different media can be seen here .
For LAN Ethernet Default is 1500.

To check MTU size from a client machine to LAN Server, execute following command in Command Prompt.

ping IPAddress -f -l MTUSize. (l is small L)

For Example -  ping 172.16.100.205 -f -l 1500

If Packet needs to be fragmented but DF set. shows in command prompt, you should set MTU size by lowering the packet size.




Repeat the above process by entering lower MTU size until you do not see Packet Fragmented message. Repeat same process by adding 1 in MTU like 1272+1 = 1273. If you see Packet Fragmented message, then 1272 is correct MTU & not 1273.



After determining correct MTU size for Server, log in to Server by Administrator Account.
In Command Prompt execute -

netsh interface ipv4 show interfaces



 Execute following command in cmd for setting MTU size -

netsh interface ipv4 set subinterface 11 mtu=1272 store=persistent





Monday, August 25, 2014

Enter Only Numeric In ADF InputText In JDeveloper 11g

Oracle JDeveloper 11.1.2.3
ADF Faces Rich Component

To enter only numbers/numeric value in ADF InputText,
<af:validateRegExp/> can be used from Operations node in Component Palette.

 <af:inputText value="#{bindings.EmployeeNo1.inputValue}" label="#{bindings.EmployeeNo1.hints.label}"  
                  required="#{bindings.EmployeeNo1.hints.mandatory}"  
                  columns="#{bindings.EmployeeNo1.hints.displayWidth}"  
                  maximumLength="#{bindings.EmployeeNo1.hints.precision}"  
                  shortDesc="#{bindings.EmployeeNo1.hints.tooltip}" id="it18"  
                  autoSubmit="true"  
                  valueChangeListener="#{backingBeanScope.book.employeeDetails}">  
             <f:validator binding="#{bindings.EmployeeNo1.validator}"/>  
   <af:validateRegExp pattern="[0-9]{1,10}" messageDetailNoMatch="Enter Only Numbers"/>  
 </af:inputText>  

Sunday, August 24, 2014

Dynamically Set Value In ADF InputText By Runtime JavaScript In JDeveloper 11g

Oracle JDeveloper 11.1.2.3
ADF Faces Rich Component
ADF Business Components

Sometime requirement is to set the value in Text Component by JavaScript.
We can set the value in Adf InputText dynamically by Server Side JavaScript.

Sample is based on Oracle HR Schema & can be downloaded from here.

In the sample, after pressing CreateInsert button a blank form is displayed for 
New Record Entry.




After entering a unique DepartmentId (25)DepartmentName field is automatically
populated with TestDept value.






Saturday, August 23, 2014

Publish Windows Server Drive To FTP Service To Access From FTP Client FileZilla Or Browser

Windows Server Standard 2008 SP2
FileZilla Client
IIS 6.0

Sometimes we need to access our Local/Intranet Server Drives by FTP Client for downloading or uploading files or folders. We can publish our Drives as Virtual Directory on FTP Service to access from FTP client or Browser.

FTP services in Windows do require IIS to be installed on the host machine before FTP can be installed and configured. 


1. Click Start - Settings - Control Panel - Administrative Tools - Server Manager




2. If IIS is not installed, start from below screenshot. Right click on Roles node & select
    "Add Roles".




3. Click Next .




4. Select Web Server (IIS) . I have already installed, so Installed is shown next.




5. Click Next to show Role Services List. Note, if IIS is already installed in server, 
    skip the above steps 2,3 & 4. In the step 1, expand Roles node. Right Click on 
    Web Server (IIS) , click Add Role Services to show Role Services List.




6. In Role Services List select FTP Server as shown below in screenshot. Finish the wizard by 
    clicking Next.





7. Select Internet Information Services (IIS) Manager node. Expand ServerName node 
    from Connections pane.




8. Click FTP Sites. Click Click here to launch from right side.




9. In the open dialog should see Default FTP Site. Expand the node if not visible.




10. Right click on Default FTP Site, New & click Virtual Directory like in below screenshot.





11. Click Next.





12. Enter a short Alias name for Virtual Directory. Click Next.





13. Click Browse & select path of Directory for mapping. I am mapping C:\ Drive. Click Next.





14. Assign permission for Virtual Directory. Click Next & Finish the wizard.






15. Virtual Directory should be listed under Default FTP Site.




16. Also check that FTP Service running normally by clicking Web Server (IIS) node.




17. In the browser, type ftp://IPAddressOfServer/CDrv & check that Directory are listed or not.




18. Now, after confirming that FTP site shows Directory Listing , we can also use FileZilla 
      FTP client to make connection. Open Site Manager in FileZilla.




19. Click New Site & enter details in  General tab like below.




20. Click Advanced tab & enter Alias Name (CDrv) in Default remote directory: like below.




21. Click Connect to see Directory listing from Server.




















Monday, August 4, 2014

Configure History Columns In Entity Object In ADF

Oracle JDeveloper 11.1.2.3
ADF Business Component



By Default Entity Object creates 5 history column. We can include a new history attribute if required, in Entity Object creation. Open the below dialog from Tools > Preferences. 0 to 10 TypeID are reserved for internal use.



We can create a new History column TypeID starting from 11 to 127. Trying to create with Type Id=6 gives below error "The History Type Id....for internal use".