Redirecting SQL select query output to HTML file - shell script, spool

This post main aim is to redirect the SQL select query output to a file for example to make a simple HTML file to display the select query output.

In this example I created two sample files one is 1.sh and another one is select.sh

File 1:

bash-3.00# cat 1.sh
sqlplus PV_ADMIN/PV@PV<< EOF
@select.sql
exit
EOF

File 2 :

bash-3.00# cat select.sql
set linesize 200
set pages 1000
set feedback off
set markup html on spool on
spool test.html
select * from PV_REPORT.AGINFO;
spool off;

so when I run the 1.sh it simply calls select.sh to spool the output to a test.html which will contain the select of the required SQL query.

Another simple file
bash-3.00# cat selctftp.sh
#!/bin/sh
#
# This script will make connection to Proviso DB
# and selects the data required from a particular
# table to populate it in a file and uploads to
# your target server
#
#
NOW=`(date +"%b-%d-%y")`
echo $NOW
echo "$0 Running on $NOW"
LOGFILE="log-$NOW.log"
echo $LOGFILE
su - oracle <

id
sqlplus PV_ADMIN/PV@PV
set wrap off
spool $LOGFILE
select * from PV_REPORT.AGINFO;
sppol off
quit

kk

Wednesday, September 29, 2010 // Labels: Database, Oracle, Shell Scripting // 0 comments //

Indian government services online

// Labels: Tips // 2 comments //

shell script to upload/ftp files to remote machine automatically

Shell script to upload files using FTP from one machine to remote machine automatically

The below simple shell script will automate the FTP steps, to upload file(s) from one machine to other easily ...
edit it according to ur convinece ..

nc184120:/opt/builds # cat ftp.sh
#!/bin/bash

HOST='9.142.193.94'
USER='root'
PASSWD='havefun'

ftp -i -n $HOST <<kris
user ${USER} ${PASSWD}

binary
cd /opt
put cds_db2_admin.sql
quit
kris

nc184120:/opt/builds # ./ftp.sh
Connected to virgo.in.ibm.com.
220-FTP Server (user 'krishna.g@in.ibm.com')
220
331-Password:
331
230-230 User root logged in.
230
Remote system type is UNIX.
Using binary mode to transfer files.
200 Type set to I.
250 CWD command successful.
local: cds_db2_admin.sql remote: cds_db2_admin.sql
229 Entering Extended Passive Mode (|||64693|)
150 Opening BINARY mode data connection for cds_db2_admin.sql.
100% |**************************************************************************************************************************************| 1101 6.73 MB/s 00:00 ETA
226 Transfer complete.
1101 bytes sent in 00:00 (4.48 KB/s)
221-You have transferred 1101 bytes in 1 files.
221-Total traffic for this session was 1601 bytes in 1 transfers.
221-Thank you for using the FTP service on virgo.
221 Goodbye.

Wednesday, September 15, 2010 // Labels: Shell Scripting, UNIX // 0 comments //

Rational purify coverage for J2EE application deployed in Websphere

Code coverage for J2EE applications deployed in Websphere using Rational Purify plus

Rational's purify plu s is one of the best code coverage tool I have seen till today, It has multiple capabilities in which I got a chance to work with is code coverage capability. Some times it is required for Developers and testers to know what part of the code is not getting executed, which part is getting executed during specific scenario of usage etc. In this case it is always good to use a code coverage too like purify plus to monitor our application while running and analyze the results of code run. The general process of code coverage is simple for any normal java applications, but when comes to a J2EE applications deployed and running under Websphere application server as a service needs more settings and configurations. In the web we can find many documents for configuring simple Java applications and other for code coverage.

So this post main aim is to explain the steps to configure the code coverage for J2EE application deployed under websphere and running as a system service.

Environment description :

Operating system : Windows XP / 2003

Webserver / Applicaiton server : Websphere

Application : J2EE type

Running as : Windows service.

Collect data by changing the WAS configuration file
When the Java process for hosting WAS is initialized, it gets its command line options from the server configuration file. This file exists for every WAS node and every WAS server. The location and name of this file is defined as follows:
<WAS root>\profiles\<your active profile>\config\cells\< cell id>\nodes\<node id>\servers\<server name>\server.xml

For example, if WAS is installed in C:\WAS, the profile name is ‘MyProfile’, the cell id is ‘MyCellId’, the node id is ‘MyNodeId’, and the server name is ‘MyServer’. The configuration file path will be defined like this:

C:\WAS\profiles\MyProfile\config\cells\MyCellId\nodes\MyNodeId\servers\MyServer\server.xml

Ex :

C:\Program Files\IBM\WebSphere\AppServer\profiles\AppSrv01\config\cells\ibm-b51282f6ec3Node01Cell\nodes\ibm-b51282f6ec3Node01\servers\CDSServer

For example:
<jvmEntries xmi:id="JavaVirtualMachine_1284026476671" verboseModeClass="false" verboseModeGarbageCollection="false" verboseModeJNI="false" runHProf="false" debugMode="false" debugArgs="-Djava.compiler=NONE -Xdebug -Xnoagent -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=7777" genericJvmArguments="-DPD_DT_ENABLED=true -XrunPureJVMPI:Coverage" executableJarFileName="-Xbootclasspath/a:%PPLUS_HOME%\Rational.jar" disableJIT="false">

The best way to change the profile is to use the WAS administrative console. However, if you do not have access to the console or do not have sufficient rights to edit the server configuration, you may edit the XML file directly. You should locate the jvmEntries element in this file and change the appropriate VM options by adding the JVMPI loading option: -XrunPureJVMPI:.

After saving the file or applying these changes from the administrative console you should restart the server process. After the new instance of WAS starts, it will run with the appropriate profiler attached.

So to do the code coverage for any J2EE applications deployed under web sphere and WAS server is running as a system service. So if we edit prefilters in the default settings, this is not going to have any effect on the running service. This is because PureCoverage is saving the default settings in the folder named "c:\documents and settings\\application data\rational\purecoverage\coverage.ini"

Whereas WAS running as a service is using the configuration file named "c:\documents and settings\localservice\application
data\rational\purecoverage\coverage.ini"
In other words, the service profile doesn't correspond to the
PureCoverage profile, therefore they are trying to access different
default INI files.

There are several ways to work around this problem:
1. Edit prefilters in the application settings, not the default
settings.
2. Copy the coverage.ini file from your profile to the service profile
(see above)
3. Run WAS as a user process, not as a system service.(User should be same the user with which purify was run)
4. Change the user associated with the service to be the same as the one
running the coverage.
5. Manually edit the coverage.ini file in the local service profile.

so the best I followed after changing the server.xml file is 3rd one , run you websphere service as the user with which purify coverage was run ...

Go to Windows

Start > Run > services.msc > Locate your service ex :
IBM WebSphere Application Server V6.1 - CDSServer
> Right click on it > Properties > go to Log on Tab > Select This Account > Provide the user and passwords which is same as the user which is running Purify coverage. > Apply > Ok.

Now launch the Purify coverage once.
Empty coverage window opens up ...
Then now re-strat the Websphere service.

Now coverage should automatically pick up the chnages and pick the classed which you want to instrument.

How to apply filters in Purify plus / coverage :

License issues in the Purify plus :

Tuesday, September 14, 2010 // Labels: Automations, Java // 0 comments //

Vinayaka chavithi and Ramzan / Ramadan Wishes

Today is really a special day I felt ..as the country like India which follows "Unity in diversity" with perfect mix of Hindus and Muslims celebrating the same day as "Ganesh Chaturthi" and "Ramzan" festivals.

I wish you all Indians happy Ramzan and Ganesh chaturthi...
Here are few useful things for this special day ...
Vinayaka Chavithi Vratha Kalpam PDF and MP3 Downloads
Download
Vinayaka Chavithi Vratha Kalpam(PDF Format)
Source2:
Vinayaka Chavithi Vratha Kalpam(PDF Format)
Vinayaka Chavithi Vratha Kalpam - part1(MP3 Format)
Vinayaka Chavithi Vratha Kalpam - part2(MP3 Format)
Kanipakam Ganesh Special Coverage

వినాయక చవితి శుభాకాంక్షలు

More downloads from Eeenadu site click this ...

Saturday, September 11, 2010 // Labels: India // 11 comments //

ETV D5 JODI

ETV D5 - JODI

Yes you herd it right !! ETV D5 * JODI is ready and launched ...It is on air already..

Missed to see launch episodes of it ..here are they for you ..Enjoy. BTW in this episode you can see D4 Winners announcement too ...

UdayaBhanu is still continued to be the anchor for the show but this time JODI special judges are different , Rekha and Prakash.

D1 - Prabhu Deva

D2 - Jr. NTR

D3 - Allu Arjun

D4 - Shreya

Finals were pranced by most famous celebrities of the Telugu industry till today ...let's see who is going to be the brand ambassador for this D5 - JODI special.

Some of the masters involved in this show are ..

Dhee Finals :
Sekhar master and poppy master reached finals.
And Sekhar won the finals.
D5 Brand ambassador was Young Rebel star " Prabhas ".
All show parts aired on

Episode 1 - Sept 1 : Link

Friday, September 03, 2010 // Labels: ETV Dhee // 0 comments //

Krishna's page

Redirecting SQL select query output to HTML file - shell script, spool

Indian government services online

shell script to upload/ftp files to remote machine automatically

Rational purify coverage for J2EE application deployed in Websphere

Vinayaka chavithi and Ramzan / Ramadan Wishes

వినాయక చవితి శుభాకాంక్షలు

More downloads from Eeenadu site click this ...

ETV D5 JODI

Popular Posts

Popular posts

Buffs ...

Tags

Archives

TechCorner