Snippets

Converting to a String to XML Document

Tagged:
import java.io.IOException;
import java.io.StringReader;
 
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.parsers.ParserConfigurationException;
import javax.xml.transform.TransformerException;
 
import org.w3c.dom.Document;
import org.xml.sax.InputSource;
import org.xml.sax.SAXException;
 
 
/**
 * StringToXMLDoc.java
 * 
 * Example to convert String to XML Document object
 *
 *
 */
public class StringToXMLDoc {
	public static void main(String[] args) throws Exception {
 
 
		String sourceXML

Executing a Stored Procedure using Java

You can execute a stored procedure using Java using a CallableStatement
 Connection connection = null;
        try {
            // Instantiate  the appropriate JDBC driver
            final String driverName = "oracle.jdbc.driver.OracleDriver";
            Class.forName(driverName);
 
            // Connection parameters
            final String databaseHost = "databaseHost";
            final String portNumber = "1527"; //Port Number
            final String sid = "dbname";
            final String url = "jdbc:oracle:thin:@" + databaseHost + ":" 

Connecting to Oracle Database using JDBC

Connection connection = null;
try {
 // Instantiate  the appropirateJDBC driver
    final String driverName = "oracle.jdbc.driver.OracleDriver";
    Class.forName(driverName);
 
    // Connection parameters
    final String databaseHost = "hotsname";
    final String portNumber = "1521"; //Port on which oracle database is running
    final String sid = "dbname";
    final String url = "jdbc:oracle:thin:@" + databaseHost + ":" + portNumber + ":" + sid;
    final String username = "username";
    final String password = "password";
    connection = DriverManager.g
Syndicate content