Hi i would to share with you derby installation tutorial in the linux platform
the procedure is very simple.
Follow the below steps to make life much easier.
Actually it becomes much easy when you go through the installation document.
Download the tar or zip of derby installation package from the url:Download Derby installation package.
1.Extract the Package in directory Database\db-derby-10.9.1.0-bin\docs\pdf\getstart
Here the document gives you complete installation steps,but still i would like share the derby installation on unbuntu machine.
2. set environment variables in unbuntu terminal as below open the terminal make sure you are in the home location.
Set the derby_home environment variable to path where you have extracted the
Derby bin package .Command to set the derby_home environment variable
sudo pico .bashrc
export DERBY_HOME=/home/gamma/Database/db-derby-10.9.1.0-bin
b.
Add the derby_home/bin directory to the PATH environment variable inorder to run the sql scripts from the script location
export PATH=$PATH:$derby_home/bin
3.Add the Derby Jar files to the CLASSPATH environment variable
export CLASSPATH=$CLASSPATH:$derby_home/lib/derby.jar:
$derby_home/lib/derbytools.jar:$derby_home/lib/derbyclient.jar:
$derby_home/lib/derbyrun.jar
How to Start with Derby Tool
4.The derbyrun.jar file is a special JAR file that is used to invoke/start the Network Server and Derby tools
home>:~/Database/db-derby-10.9.1.0-bin$ java -jar $derby_home/lib/derbyrun.jar server start
ij: this is an interactive tool used to connect to a database and perform SQL commands.
The ij program is executed from the command prompt. Executing ij will open the program and show you the ij prompt.
The following shows a sample execution of the ij program.
home:~/Database/db-derby-10.9.1.0-bin/$ ij
ij version 10.9
ij>
You have now started the ij program and are ready to connect to a database.
5.At the ij prompt you can connect to a database by issuing the connect command. This command takes a string identifying the location of the database to connect to.
The following example connects to the database
ij> CONNECT 'jdbc:derby://localhost:1527/Mydb;user=tute;password=db';
Connected to derby database perform ur Sql operations
Telecomm Billing Tutorial
This blog posts techi stuff related to telecomm domain
Friday, October 5, 2012
Sunday, September 23, 2012
Learn IMS
IMS Definition : IMS is defined IP Multimedia System.
IMS is new way to deliver multi media services such as Voice,Video,Data etc..Regardless of the device(landlane,mobile,cable,internet etc) or access medium (cellular ,WIFI,broadband,fixed lane etc..) .This model separates services offered by fixed line ,mobile and converged service providers from the access network used to receive those services.
Saturday, January 28, 2012
Diameter
I have to test the diameter application and its commands , i have tried with open source tool seagull for unbuntu for testing .Initially i have downloaded the source package and tried to compile but unfortunatly i coundnt succeed to make that work in ubuntu and it works for windows if you want test the diameter applicaiton using windows environment it works.
Seagull open source testing tool http://gull.sourceforge.net/
Wednesday, August 31, 2011
Some Billing tutorial sites
Hi folks this post is exclusive about the sites posting the telecommunication billing information so that will be very useful to easily get more information about the telecomm domain.
Some sites:
http://www.billingworld.com/
http://www.billingoss.com/telecom-billing.htm
Thursday, August 11, 2011
Sendmail with attachment to multiple recepients i.e Mutiple TO Address
#!/usr/bin/ksh
# Address used to be A@B.com,B@C.com,D@E.com
/usr/sbin/sendmail $EMAIL1,$EMAIL2,$EMAIL3 << END_MAIL
From:
To: $EMAIL1,$EMAIL2,$EMAIL3
Subject: HI
$MSG
Regards,
`uuencode ${DIR}/attachment.gz changedfilename.gz 2>/dev/null`
END_MAIL
exit 0
# Address used to be A@B.com,B@C.com,D@E.com
/usr/sbin/sendmail $EMAIL1,$EMAIL2,$EMAIL3 << END_MAIL
From:
To: $EMAIL1,$EMAIL2,$EMAIL3
Subject: HI
$MSG
Regards,
`uuencode ${DIR}/attachment.gz changedfilename.gz 2>/dev/null`
END_MAIL
exit 0
Thursday, August 4, 2011
CAMEL
Visit the below site for basic understanding of camel application
http://www.3g4g.co.uk/Tutorial/ZG/zg_camel.html
http://www.3g4g.co.uk/Tutorial/ZG/zg_camel.html
Subscribe to:
Posts (Atom)