SSO- External Application

Q) When password changes in external application, how can we reflect this in SSO?
A) When we register an external application and when user access it for the first time, he has to enter userid and password for this application these details get stored in orasso schema.
Details: use toad and login using system user into oracle application server infrasturcture.
switch to orasso schema, the entry is made in WWSEC_ENABLER_CONFIG_INFO$ table
, If you remove the entry for a specific user the user will again be prompted to enter his user name and password.

SSO: Customize Login Page

Way 1:
Edit the default SSO login page available at the following location,
$ORACLE_HOME/j2ee/OC4J_SECURITY/applications/sso/web/login.jsp
Way 2:
To install your own login and change password pages, provide the following parameters in $ORACLE_HOME/sso/conf/policy.properties
#Custom login page link
loginPageUrl=login_page_URL
#Custom change password page link
chgPasswordPageUrl=change_password_page_URL

Good Sites

HTML DESIGNER
http://www.dynamicdrive.com/

MY FAVOURITE JAVASCRIPT LIBRARIES
http://extjs.com/products/extjs/

Important Sites and Links

Link to upload large size documents and send via mail
www.youSENDit.com

Proxy links
kproxy
http://www.publicproxyservers.com/page1.html
http://www.terj.info
http://aflu.info
http://www.anonymoususer.biz
http://deeproxy.com
http://www.rosc.info

Java- Searching a matching countrycode column from database, exception code

String myNumber = destNumber.substring(1);
if(myNumber.startsWith("00")){
myNumber = myNumber.substring(2);
} else if(myNumber.startsWith("0")) {
myNumber = myNumber.substring(1);
} else if(myNumber.startsWith("+")){
myNumber = myNumber.substring(1);
}
try
{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection (dbUrl);
s = conn.createStatement();
s.executeQuery("SELECT CountryCode, CountryName, CallRate FROM ratestable");
rs = s.getResultSet();
boolean myMatch = false;
while(rs.next())
{
String myLocalNumber = "";
String myCountryCode = rs.getString(1);
if(myNumber.startsWith(myCountryCode)){
myMatch = true;
myLocalNumber = myNumber.substring(myCountryCode.length());
System.out.println("Country Code:"+myCountryCode+"Local no="+myLocalNumber);
myArrayList.add(myCountryCode);
myArrayList.add(rs.getString(2));
myArrayList.add(rs.getString(3));
myArrayList.add(myConnectionType);
myArrayList.add(myLocalNumber);
return myArrayList;
}
}

Date Query (Records between fromdate and to date) in MYSQL DB

SELECT calldate FROM dateTable WHERE calldate between STR_TO_DATE('05/01/2009','%m/%d/%Y') and STR_TO_DATE('05/25/2009','%m/%d/%Y')

Sampel Date Example in JAVA

package mysamplesprj;import java.util.*;
public class DateSample2
{
public static void main(String[] args)
{
Calendar c1 = Calendar.getInstance();
System.out.println(c1.get(Calendar.YEAR));
int month = Integer.parseInt(String.valueOf(c1.get(Calendar.MONTH))) ;
month = month + 1;
System.out.println(month);
System.out.println(c1.get(Calendar.DATE));
}
}