Month: September 2009

Active session in oracle

Below sql statement will show the active session for database select user_name, status, osuser, machine, a.sql_text from v$session b, v$open_cursor a where a.sid = b.sid AND status=’ACTIVE’ output USER_NAME                      STATUS   OSUSER                         MACHINE                                                          SQL_TEXT —————————— ——– —————————— —————————————————————- ———————————————————— KNS                            ACTIVE   kmanchikalapudi                WIN-SNRV23P3O51                                                  select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where KNS                            ACTIVE   kmanchikalapudi                WIN-SNRV23P3O51                                                  select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.fla KNS                            ACTIVE  …

Read More

LogOut/LogOff on KFS with CAS

Open immutableBar.tag, which is located at kfs/work.web-root/WEB-INF/tags/portal/ Search for <c:otherwise> and comment the code between otherwise. add below code & save file <a href=”/cas/logout?” style=”color:#FFFFFF;text-decoration:none;font-weight:bold;”>logoff</a>

Read More

How to Deal With OutOfMemory in tomcat

These errors are rather commonly seen during development phases, and even on production servers. These errors are even more annoying than others, because they do not show any stack trace. The reason for this is that a stack trace would not be of help for these errors. The code that fails with an Out Of…

Read More

Disable Impersonating User or Backdoor

Open immutableBar.tag, which is located at work/web-root/WEB-INF/tags/portal/ or work/web-root/WEB-INF/tags/rice-portal/ Search for <c:otherwise> and comment the code between otherwise.

Read More

Webservice security

To disable webservice security in KFS project, Search for kim.soapExposedService.jaxws.security in build.properties Replace value to flase Execute ant target dist-local & followed by make-source. Here is sample… WSDL url: http://localhost:8080/kfs-dev/remoting/kimIdentityServiceSOAP?wsdl Request <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:kim=”http://rice.kuali.org/wsdl/kim”> <soapenv:Header/> <soapenv:Body> <kim:getPrincipal> <principalId>admin</principalId> </kim:getPrincipal> </soapenv:Body> </soapenv:Envelope> Response <soap:Envelope xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope/”> <soap:Body> <ns2:getPrincipalResponse xmlns:ns2=”http://rice.kuali.org/wsdl/kim”> <return> <active>true</active> <entityId>1100</entityId> <principalId>admin</principalId> <principalName>admin</principalName> </return> </ns2:getPrincipalResponse> </soap:Body>…

Read More