Migrate oracle with pentaho

Steps to migrate Oracle with Pentaho   Step 1:- Run script as DB admin. Script is available in location:- biserver-ce\data\oracle10g. Modify configuration file:- applicationContext-spring-security-hibernate.properties. Location:- pentaho-solutions\system\applicationContext-spring-security-hibernate.properties. original code:- jdbc.driver=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb:hsql://localhost:9001/hibernate jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.HSQLDialect Modified code:- dbc.driver=oracle.jdbc.OracleDriver jdbc.url=jdbc:oracle:thin:@localhost:1521/sysdba jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.Oracle10gDialect hibernate-settings.xml Location:- pentaho-solutions\system\hibernate\hibernate-settings.xml. Original code <config-file>system/hibernate/hsql.hibernate.cfg.xml</config-file> Modified code:-


While working with database using plain old JDBC, it becomes cumbersome to write unnecessary code to handle exceptions, opening and closing database connections etc. But Spring JDBC Framework takes care of all the low-level details starting from opening the connection, prepare and execute the SQL statement, process exceptions, handle transactions and finally close the connection. …Read More

Start With SOAP

SOAP stands for Simple Object Access Protocol.SOAP is a protocol for accessing web services.SOAP is based on XML. What is SOAP? SOAP is a communication protocol SOAP is for communication between applications SOAP is a format for sending messages SOAP communicates via Internet SOAP is platform independent SOAP is language independent SOAP is based on …Read More


Transaction: the term transaction has many different yet related meanings in regards to persistence and Object/Relational Mapping. In most use-cases these definitions align, but that is not always the case. Might refer to the physical transaction with the database. Might refer to the logical notion of a transaction as related to a persistence context. Might …Read More

Unit Test and JUnit Introduction

Testing is the process of checking the functionality of the application whether it is working as per requirements and to ensure that at developer level, unit testing comes into picture. Unit testing is the testing of single entity (class or method). Unit testing is very essential to every software company to give a quality product …Read More

Learn Scheduling using Quartz

Why do we need scheduling? Scheduling is needed if you want to automate the repetition of a task at specific intervals or        particular date. You could of course manually watch the time and execute your task, albeit an inefficient task. If anyone wants to do particular task after every 3 seconds, then who wants to …Read More

Introduction to XSD – XML Schema Definition

This blog will talk about Introduction to XSD – XML Schema Definition   XML Schema Definition:- XML Schema describes the structure of an XML document, what a given XML document can contain, in the same way that a database schema describes the data that can be contained in a database (i.e. table structure, data types, …Read More

Create Organization using REST Webservice in Jasperserver / Jaspersoft

This blog will talk about how to create organizations using REST webservice in JasperServer. STEP 1:- Put the following jar files in lib folder: Commons-codec-1.4.jar Commons-io-1.4.jar http-core-4.1.jar httpclient-4.1.1.jar httpmime-4.1.jar Jakarta-httpcore.jar Restclient-cli.3.2.2-jar-with-dependencies.jar Servlet-api.jar   STEP 2:- Create a jsp page index.jsp: <html> <head> <meta http-equiv=“Content-Type” content=“text/html; charset=ISO-8859-1”> <title>Insert title here</title> </head> <body> <form action=“TestWebService“> <input type=“submit” …Read More

JSON – Brief Introduction

JSON stands for JavaScript Object Notation.it is  lightweight .It gives us text-based open standard designed for human-readable  collection of data that we can access in a really logical manner. It is used primarily to transmit data between a server and web application, as an alternative to XML. Although originally derived from the JavaScript scripting language, …Read More