Extracting Oracle Java installation from exe

This has been tested in JDK 7. Please download 7Zip application. WinRAR does not assist along this process 1.Download a desired JDK version from prior downloads at http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase7-521261.html 2.Create a folder in where you want to keep the jdk, 3.Copy the downloaded .exe file in here, 4.Right click on exe and 7-Zip>>Extract Here, 5.Right click on

Spring Task Example

pom.xml [code] <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.tugrulaslan</groupId> <artifactId>SpringScheduledTaskExample</artifactId> <version>1.0-SNAPSHOT</version> <packaging>jar</packaging> <name>SpringScheduledTaskExample</name> <url>http://maven.apache.org</url> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <spring.version>3.1.2.RELEASE</spring.version> </properties> <dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>3.8.1</version> <scope>test</scope> </dependency> </dependencies> </project> [/code] batch.xml in src>java>resources [code] <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:task="http://www.springframework.org/schema/task" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/task

Liquibase Spring batch xml for Oracle RDBMS

  [code] <?xml version="1.0" encoding="UTF-8"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd"> <changeSet id="1.0.0_SPRING_BATCH_INFRASTRUCTURE" author="a243229"> <createSequence sequenceName="BATCH_STEP_EXECUTION_SEQ" startValue="0" minValue="0" maxValue="9223372036854775807" cycle="false" /> <createSequence sequenceName="BATCH_JOB_EXECUTION_SEQ" startValue="0" minValue="0" maxValue="9223372036854775807" cycle="false" /> <createSequence sequenceName="BATCH_JOB_SEQ" startValue="0" minValue="0" maxValue="9223372036854775807" cycle="false" /> <createTable tableName="BATCH_JOB_INSTANCE"> <column name="JOB_INSTANCE_ID" type="BIGINT"> <constraints primaryKey="true" nullable="false" /> </column> <column name="VERSION" type="BIGINT" /> <column name="JOB_NAME" type="VARCHAR(100)"> <constraints nullable="false" /> </column>

Running sql queries in Liquibase

Make sure the user that you’ll use to issue this command will have privileges. In this query I create a user on Oracle DB [code] <?xml version="1.0" encoding="UTF-8"?> <databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd"> <changeSet id="1.0.0_RBACK_USER" author="a243229"> <!– TO BE ABLE TO RUN THIS SCRIPT, MAKE SURE YOUR NON-SYS USER HAS SUCH PRIVILEGES OTHERWISE RUN THE

Running Liquibase xml file from command line

I’ve tested the code against Oracle database at work. First download the jar and issue the command similar to below, make sure you are in the xml file’s location [code] java -jar C:\Users\A243229\Desktop\liquibase.jar –driver=oracle.jdbc.OracleDriver –classpath=C:\JavaDev\mavenRepository\oracle\ojdbc14\10.2.0.3.0\ojdbc14-10.2.0.3.0.jar –changeLogFile=changelog-1.0.0.xml –url=jdbc:oracle:thin:@localhost:1521:xe –username=RBAC_TEST –password=rbactest1 update [/code] ref: http://www.liquibase.org/documentation/command_line.html