Commands:
SELECT SESSION_ID
FROM DBA_DML_LOCKS
WHERE NAME = Table Name;
SELECT SID,SERIAL#
FROM V$SESSION
WHERE SID IN (SELECT SESSION_ID
FROM DBA_DML_LOCKS
WHERE NAME = Table Name)
ALTER SYSTEM KILL SESSION 'SID,SERIALl#';
SELECT SESSION_ID
FROM DBA_DML_LOCKS
WHERE NAME = ‘EPUB_DEPLOYMENT’;
SELECT SID,SERIAL#
FROM V$SESSION
WHERE SID IN (SELECT SESSION_ID
FROM DBA_DML_LOCKS
WHERE NAME = ‘EPUB_DEPLOYMENT’)
ALTER SYSTEM KILL SESSION ‘37,40724’;
We had the requirement to append Order ID for each logging statement. This is how we achieved that.
Create Component:
\atg\dynamo\service\logging\LogQueue.properties
$class=atg.nucleus.logging.CustomLogListenerQueue
logListeners=LogDispatch
customLogging=true
Path of property file should not be changed.
CustomLogListenerQueue.java
package atg.nucleus.logging;
import atg.commerce.order.OrderHolder;
import atg.core.util.StringUtils;
import atg.nucleus.logging.LogEvent;
import atg.nucleus.logging.LogListenerQueue;
import atg.servlet.ServletUtil;
public class CustomLogListenerQueue extends LogListenerQueue {
private boolean mCustomLogging;
private static String ORDER_PATH = “/atg/commerce/ShoppingCart”;
/**
* @return the customLogging
*/
public boolean isCustomLogging() {
return mCustomLogging;
}
/**
* @param pCustomLogging
* the customLogging to set
*/
public void setCustomLogging(boolean pCustomLogging) {
mCustomLogging = pCustomLogging;
}
/* (non-Javadoc)
* @see atg.nucleus.logging.LogListenerQueue#logEvent(atg.nucleus.logging.LogEvent)
* Following would append order id in front of all log messages
*/
@Override
public synchronized void logEvent(LogEvent pArg0) {
if (isCustomLogging()) {
String lCustomLogMessage = “”;
if (null != pArg0 && !StringUtils.isBlank(pArg0.mMessage) && null != ServletUtil.getCurrentRequest()) {
OrderHolder lOrderHolder = (OrderHolder) ServletUtil.getCurrentRequest().resolveName(ORDER_PATH);
if (null != lOrderHolder && null != lOrderHolder.getCurrent(Boolean.FALSE)) {
lCustomLogMessage = “OrderID: ” + lOrderHolder.getCurrent().getId() + ” “;
}
pArg0.mMessage = lCustomLogMessage + pArg0.mMessage;
}
}
super.logEvent(pArg0);
}
}
Parent JSP:
<dsp:include page=”/common/getTaxedPrice.jsp”>
<dsp:param name=”freePrice” value=”${paymentCost}”/>
</dsp:include>
Child JSP:
Read passed value:
<dsp:getvalueof param=”freePrice” var=”freePrice”/>
Pass value to parent JSP:
Option 1 – DSP TAGS:
<dsp:getvalueof param=”intergerlVal” var=”integerValue” scope=”request” />
<dsp:getvalueof param=”decimalVal” var=”decimalValue” scope=”request”/>
Option 2 – JSTL:
<c:set var=”integerValue” scope=”request” value=”integerValue”></c:set>
<c:set var=”decimalValue” scope=”request” value=”decimalValue”></c:set>
Parent JSP:
Variables can be printed or used as:
${integerValue}
${decimalValue}
We have found latest version of different browsers are not working with https. Please find details on this issue below.
Affected Browser:
Issue:
Security protocol used for https, SSLv3 has security vulnerability, it is known as POODLE(Padding Oracle On Downgraded Legacy Encryption) attack which can be used for Man-In-Middle attack.
Hence browser companies have stopped support for SSL 3.0 in latest versions, please read these articles for more details. Internet Explorer Firefox Chrome
In latest version of browsers we can see page like following on hitting https flow.
Fix:
Server must use >TLS 1.0 protocol instead of SSL 3.0.
Apache server is already configured with protocol > TLS 1.0. Hence no changes are required for environment where apache is configured correctly.
For the environments where application server ports (weblogic) are expected to be used over web server ports (Apache), please do following change.
<use-java>true</use-java>
<jsse-enabled>true</jsse-enabled>
<ciphersuite>SSL_RSA_WITH_RC4_128_MD5</ciphersuite>
8. Save file
9. Start application server
Please follow the similar sequence of tags else there can be issue. Do not worry about tags you do not have in your config file.
Note:
This fix is to be used for development environments only, for TEST and higher environments web server (APACHE) is to be used.
If this fix is required in higher environments, confirmation from product company(Oracle) is must.
Problem:
Java file has line numbers like following:
Tools:
Notepad++
Steps:
Issue:
If Jenkins fails to restart with error “System error 1067 has occurred.”
Solution:
How to run
./logScript.sh (Default tail parameter = 50)
./logScript 1000 (User defined tail parameter)
log_colorizer.properties
LOG_FILE=”/<PathToLogDir>/<LogFileName>”;
LOG_TAIL_PARAM=50
DIR_TEMP=”tmp”;
OLD_FILE_TIMER=”5″;
Script:
#source property file
. log_colorizer.properties
#Getting tail parameter as argument
TEMP_LOG_TAIL_PARAM=$1
#Checking if passed argument is null
if [ "$TEMP_LOG_TAIL_PARAM" != '' ]; then
LOG_TAIL_PARAM="$1"
fi
#Clearning old temp files
find $DIR_TEMP/ -name 'tmp*' -type f -mmin +$OLD_FILE_TIMER -delete
#Creating temp file to keep track of what is printed
TEMP_FILE=`mktemp $DIR_TEMP/tmp.XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX`
#Infinite loop
while :
do
TEMP=`tail -$LOG_TAIL_PARAM $LOG_FILE`
#File separator
IFS='
'
for item in $TEMP
do
#Checking if current line is already printed
if ! grep -qF "$item" $TEMP_FILE ; then
#Appending colors in front of various key parameters
echo $item | perl -pe 's/.*info.*/\e[1;32m$&\e[0m/g;s/.*debug.*/\e[1;33m$&\e[0m/g;s/.*\*\*\*\*\ Error.*/\e[1;31m$&\e[0m/g;s/.*Warning.*/\e[1;36m$&\e[0m/g;s/.*HTTP request.*/\e[1;35m$&\e[0m/g;s/.*<?xml.*/\e[1;35m$&\e[0m/g'
fi
done
#Redirect currently read tail content to a temp file
echo $TEMP > $TEMP_FILE
sleep 1
done
Resolution:
I created new reverse engineering XML “hibernateII.reveng.xml” from Hibernate tool plugin in STS eclipse, and it resolved the problem.
Though i had also tried changing content of existing file, but that did not work out and content of old and new files were same, weird, but new file solved the issue.
Tools:
Issue:
If your script invokes some GUI on windows and Jenkins is installed as window service, it would not have access to desktop tools.
Resolution:
Open windows service manager
Look for Jenkins services
Open “Log on” tab.
Check “Allow service to interact with desktop.”
Restart service.
Now when your script will invoke, GUI, it should go fine.
Anti Theft System
Automated Ballot Vote
Automation Of Analysis And Development Management
Autonomous Deployment Of Heterogeneous Mobile Sensors
Bandwidth Recycling
Barcode Generation
Basic English Teacher
Call Blocker
Call Listener
Call Recoreder
Card Management System
Chat Client
Citizen Card System
Company Information Tracking System
Company Security Reporting System
Continuous Monitoring Of Distance Based Range Queries
Contract Labor Management System
Control Theoretic Approach to Distributed Optimal Configuration of 802.11 WLANs
Cooperative Clustering Protocol For Energy Saving Of Mobile Devices
Credit Card Management System
Crosslayer Optimization For Multimedia Transport Over Multicode CDMA Networks
Data Delivery Properties of Human Contact Networks
Data Leakage Detection
Design and Performance Analysis of Mobility Management
Digital Encryption System
Display Location when calling
Distributed Transaction Proxy
District Collector
Doctor Online
Document Scanner
Dynamic Conflict Free Transmission Scheduling for Sensor Network Queries
Dynamic Time Slot Partitioning For Multimedia Transmission In Two Hop Cellular Networks
E Cops
E Tutor Online Jobs
Earth Quake Monitor
Ecrime <a href=”http://www.collegelib.com/t-elastic-quotas-seminar-seminar-report-abstract.html”>File Management System</a>
Effective Audio Video Transfer Using Real Time Protocol
Effective Scheduling In Infrastructure Based Cognitive Radio Networks
Effectiveness of Monitoring for Intrusion Detection in Mobile Ad Hoc Networks
Efficient Location Training Protocols for Heterogeneous Sensor and Actor Networks
Email Client
Emergency Call
Ensuring Data Storage Security in <a href=”http://www.collegelib.com/t-cloud-computing-seminar-preparation.html”>Cloud Computing</a>
Enterprise Fleet Management System
Enterprise Hazard Management
ERP System
Exam Suite
Extended XML Tree Pattern Matching
Ezee Mail System
Facebook client
Fast Detection Of Mobile Replica Node Attacks
Fault Tolerant Token Based Atomic Broadcast Algorithm
<a href=”http://www.collegelib.com/t-elastic-quotas-seminar-seminar-report-abstract.html”>File</a> Manager
File Security System
Friend Mapper on Mobiles
Global Tracker
Group Alarm system
Group Calendar
Group Chat
Handset Theft Monitoring
Health Monitor
Heart beat monitor
Image Compression and De compression
Image Processing Editor
Implementation and Validating Environmental and Health
Improving Utilization Of <a href=”http://www.collegelib.com/t-cloud-computing-seminar-preparation.html”>Infrastructure Clouds</a>
Inter Bank Fund Transfer in Distributed Network
Intranet Chatting
Intranet Mailing System
Intrusion Detection System
IRC Chat Client
Issue Tracker
IT Project and Process Management
Lending Tree
Live Wall Paper
Load Shedding In Mobile Systems With Mobiqual
Location Based Reminder on Mobiles
Marine Operations And Management System
Medical Image Compression
Meet Friends
Micro Banking
Mindtech Bug And Component Systems
Minimum Bandwidth Reservations For Periodic Streams In Wireless Real Time Systems
Mobi Thesaurus
Mobi Travel Guide
Mobile Banking System
Mobile Electronic Program Guide
Mobile Gadgeteer
Mobile i Broker
Mobile internet banking
Mobile Invoice
Mobile Location Alarm
Mobile Phone Tracking
Mobile Sampling of Sensor Field Data
Mobile Video Archive
Mobility Management Approaches for Mobile IP Networks
Mobility Management Schemes Based On Pointer Forwarding For Wireless Mesh Networks
Modeling and Detection of Camouflaging Worm
Multi Lingual Website
Multi User Chat System
MultiAuctioneer Progressive Auction For Dynamic Spectrum Access
Multihoming Route Control
Multiple Routing Configurations for Fast IP Network Recovery
My Jewellery
Natural Image Segmentation Based On Tree Equipartition
Navigation Help
Net SMS
Noise Reduction By Fuzzy Image Filtering
Blocking Misbehaving Users in Anonymizing Networks
Offline Broser
On Line Help Desk
Online Crime <a href=”http://www.collegelib.com/t-elastic-quotas-seminar-seminar-report-abstract.html”>file</a> Management
Online Real Estate Property Management
Online Recruitment System
Online Rental House Web Portal
Online TV system
Online University
Optimal Channel Access Management with QoS Support for Cognitive Vehicular Networks
Optimal Jamming Attacks and Network Defense Policies in Wireless Sensor Network
PDF Reader
Peer To Peer
Personal Authentication Based On Iris Recognition
Personal Finance
Photo sharing
Play the the selected station
Prepaid Recharging System on Banking
Product Management System
Product Wiki
Project Metrics
Publishing Search Logs
Questionnaire Game
Radiation Reducer
Ranking Spatial Data by Quality Preferences
Real Time Detection Of Clone Attacks
Remote Administration using Mobile
Remote PC Administration Using J2ME
Resilient Online Coverage For Surveillance Applications
Ride Sharing
RITAS: Services For Randomized Intrusion Tolerance
RSS Feed Reader
Save station in the list
Script Identification Through Temporal Sequence Of The Strokes
Search stations of interest based on different keywords
Secret Key Establishment Using Temporally and Spatially Correlated Wireless Channel Coefficients
Secure Data Transmission
Select list of music station
Ship Store System
Smart Leap
Smart Polling
Smart Tendering
SMS Based Mobile Banking with Security
Snake Game
SodoKo Game
Stateless FSA based Packet Filters
Speaking Dictionary
Speech Control
Speed Tracker
Staying Connected in a Mobile Healthcare System
Stealthy Attacks In Wireless Ad Hoc Networks
Steganography In Audio <a href=”http://www.collegelib.com/t-elastic-quotas-seminar-seminar-report-abstract.html”>Files</a>
Stop Watch
Swich connection dynamically
Tanrox Work Force
Text Encryption And Decryption
Tool to announce arrival
TV Remote from Android Mobile
Twitter Client For Android Based Smart Phone
VAS for Hand Held Device
Virtual Office Management
Virtual Router Using Destination Sequenced Distance Vector
Voyage Management
Weather Monitor
Web Blossom Bazzar
Web browser
Web Enabled Automated Manufacturing System
Wireless Health Care System
| 3- Ringtone Creator. |
| This project is about developing Ringtones creator app for Wp7 and Android. This app lets you fill in a text field and submit it to a web service . The text is used to generate a text to speech ringtone. |
| 1- Data hiding in images (Steganography). | ||
| Steganography is by practice of hiding private or sensitive file within an image life.
The project has two methods.
It is a desktop application in which user can hide text files within an image. Upon request image can be decrypted and the text file can be viewed. |
||
| Arooj Arshad (08-SE-78)
|