bad SQL grammar [SELECT JOB_INSTANCE_ID, JOB_NAME from BATCH_JOB_INSTANCE where JOB_NAME = ? and JOB_KEY = ?] Spring Boot / Spring Batch error. How to fix?

Reason for this error : Spring Boot / Spring Batch needs default tables where it can track the batch job related information. If the tables are not available in the database, we need to allow Spring to create them. To configure this please add the following line in application.properties: If this doesn’t work, you can … Read more

Get data from MongoDB in Cypress API testing

In this tutorial let’s see how you can get data from MongoDB and use the data when you test APIs with Cypress framework. Getting data from a database is not straightforward in Cypress as it basically runs the tests in a browser. Cypress allows to run backend node.js code in a separate files called plugins. A typical … Read more

Keep your Node.js app running in the background using PM2

Get started with the basics of PM2 and learn how to run your Node.js apps in the background using Node.js process manager PM2. PM2 is a daemon process manager that will help you manage and keep your Node.js application online 24/7. It’s a production grade process manager that let’s your node.js applications run in the background as microservices. PM2 … Read more

Alter table column size in Oracle

In this post, we will learn how to modify the size of an column in an Oracle table. It’s easy to alter the column size using the ALTER TABLE MODIFY statement.  Sometimes the column value will exceed from which we defined while creating the table. So in that case we need to update the size of the … Read more

How to know the primary key column in Oracle?

In this quick tutorial we will see how to get the primary key column in the table. Here we can use the below table to list the columns Syntax The constraint type ‘P’ refer for primary key, as like this the oracle has the key for every constraint type some are belows, Type Definition C … Read more

Configure Outlook email in Redmine

Configure your email Inside your config directory in redmineroot directory, create a new file called configuration.yml and configure your SMTP settings for redmine like this. Test and save redmine settings At the bottom of your email settings page, there is a link to test your email configuration.

Oracle INSERT INTO SELECT

In this post, we will see how to insert a data into a table with the result of select statement. Sometimes we want to move the data from one table to another, in that case we use insert into select statement. Syntax Let’s use the below STUDENT_MARKS table to understand the topic. Example 1 The above query will insert all the records from … Read more

Remove unused npm modules from package.json

Depcheck is a tool for analyzing the dependencies in a project to see: how each dependency is used, which dependencies are useless, and which dependencies are unused from package.json. To identify the unused package, just run npx depcheck in the project root directory Next step is to uninstall the npm packages using npm uninstall command.