Following SQLs commands can be used to replace the content of the column using new values rather than writing new scripts to update values.
SELECT pdf_location,
REPLACE(pdf_location, '/2026/08/', '/2026/09/') AS new_pdf_location
FROM cib_pdf_bill
WHERE pdf_location LIKE '/c01/cipdf/2026/08/%' and account_no = '33700503';
UPDATE cib_pdf_bill
SET pdf_location = REPLACE(pdf_location, '/2026/25/', '/2026/08/')
WHERE pdf_location LIKE '/c01/cipdf/2026/25/%' and account_no = '33700503';
Following commands and details will be helpful when configuring Debezium to sync data from Informix to Oracle database.
1. Docker compose to create Kafka connect, Kafka, Zookeeper
Copy Informix connector and streaming jar files into connectors directory in docker compose file exists
Following python script can use to check HTTPS certifcate expiry.
You can use following code to process images using Googel Gemini LLM.
Following commands can be used in mongo db shell.
show dbs
use shops
db.createCollection("products")
show collections
db.products.insertOne({"name":"prod_name1"})
db.products.insertMany([{"name":"prod_name2"},{"name":"prod_name3"}])
db.products.insertOne({"name":"test_prod4","vendor":{"name":"vendor_1","address":"address_1"}})
db.student.insertOne({"name":"test_prod5",,"vendor":{"name":"vendor_1","address":{"address_line1":"line1","address_line2":"line2","city":"city"}}})
db.products.find()
db.products.update({name:"test_prod1"},{$set:{price:"120.00"}})
db.student.update({"name":"test_6"},{$set:{age:26}},{multi:true})
db.student.update({_id:ObjectId("64dc5856e4cebb07084d8c45")},{$unset:{price:"120.00"}})
db.teaches.update({"th_name":"test_th_2"},{$set:{student:[{"std_name":"test_1"},{"std_name":"test_2"}]}})
db.student.find({$and:[{"name":"test_4"},{"age":"40"}]})
db.student.find({$or:[{"name":"test_4"},{"name":"test_2"}]})
db.student.drop()
db.teaches.remove({"name":"t_name1"})
db.teaches.deleteOne({"name":"t_name2"})
db.student.aggregate([{$lookup:{from:"teaches",localField:"std_name",foreignField:"student.std_name",as:"studentDetails"}}])
db.mycol.find().pretty()
#!/bin/bash
ps -ef |grep "java -jar" > /apps/appcheck
x=$(cat /apps/appcheck |grep "TestApp.jar" |wc -l)
echo $x
if [ $x = 0 ]
then
date
echo "stopping..."
cat /apps/appcheck|grep "TestApp.jar" | awk -F " " '{print $2}' | xargs kill -9
echo "stopped"
date
echo "starting..."
cd /apps/sujith/test
nohup java -jar -Xms128m -Xmx256m ThripleNine.jar 2>> TestApp.log &
else
echo "error occurred. check."
fi
kubectl get nodes returns available nodes in k8s cluster
kubectl get po returns available pods in k8s cluster
kubectl get po -o wide return ip address and other details of pod
kubectl create -f poddemo.yml create pod using yml file. this will create a pod with nginx
Sample yaml file for pod creation
apiVersion: v1
kind: Pod
metadata:
name: nginx-pod
labels:
app: nginx
tier: dev
spec:
containers:
- name: nginx-container
image: nginx
In RabbitMQ command prompt, use following commands to enable plugins.
rabbitmq-plugins enable rabbitmq_management
If you have changed your certificate of your git repository, you will receive the following error message.
fatal: Authentication failed for for 'https://bitbucket.*****/***/usermgt*.git/'
You can follow following steps to resolve the issue.
1. Retrieve the remote URL
git remote -v
2. Remove the remote URL
git remote rm origin
3. Add URL as new remote URL
git remote add origin https://bitbucket.*****/***/usermgt*.git
4. Make changes and push
git push origin master
List of important commands for git CLI users
Create a new repository on the command line
Push an existing repository from the command line
When you add new file(which has already in the git repository) to git ignore file, run below command to ignore it.
Configure git for the first time
If your code is already tracked by git then set this repository as your "origin" to push.
You can use the git cherry-pick command to merge one branch to another.
(Replace d4d8e7c with relevant commit id you need to merge from another branch to this branch)
You can revert to previous commit.
Let's say you want to merge local development branch into local staging branch.
Then first you need to checkout stating branch with this command.
Then you can do merging with this command.
How to merge development branch changes to staging branch.
1. First checkout to staging branch
2. Then execute below command
You have to configure mail server in Linux server. Then you can use following command to send mails.
For mail -
mail -s "subject" recipients_emails < mail body
For SMS -
mail -s "subject" number@your_email_domain < mail body
#!/bin/bash
ps -ef |grep "java -jar" > /apps/sujith/apps
x=$(cat /apps/sujith/apps |grep "SMS_App.jar" |wc -l)
echo $x
if [ $x = 0 ]
then
date
echo " Starting ......Please check logs !! "
echo ""
cd /apps/sujith/sms
nohup java -jar -Xms32m -Xmx128m SMS_App.jar 2>> SMS_App.err &
elif [ $x = 1 ]
then
date
echo "STOPPING "
cat /apps/sujith/apps |grep "SMS_App.jar" | awk -F " " '{print $2}' | xargs kill -9
echo "STOPPED "
date
echo "STARTING"
cd /apps/sujith/sms
nohup java -jar -Xms32m -Xmx128m SMS_App.jar 2>>SMS_App.err &
else
echo "SMS App"
fi
You can add following Dockerfile to JAVA docker image.
checking current installed docker version
run hello-world docker image. if image is not available in local repository, above command will download the image from docker-hub
You can use ConfigurableApplicationContext to shutdown/closes all resources used by application as follows.
public static void main(String[] args) {
ConfigurableApplicationContext ctx=SpringApplication.run(Application.class, args);
ctx.close();
}
@Bean
public CommandLineRunner commandLineRunner(RestTemplate restTemplate) {
return args -> {
}
}
Following JAVA annotation can be used to avoid <return> tag from SOAP web service response.
@WebService(serviceName = "Operations")
public class Service {
@WebMethod(operationName = "processUser")
@SOAPBinding(parameterStyle=ParameterStyle.BARE)
public Result processUser(@WebParam(name = "userName")String userName) {
Result result = new Result();
result.setResultCode("1");
result.setResultDesc("success");
return result;
}
}
ParameterStyle.BARE will return SOAP response with your defined object attributes.
du -sh *
Above command can be used to grep directory sizes in Linux. Go to required directory and execute above command.
