I try to transfer data from xml file to a table. Error is oracle.jdbc.driver.OracleDriver.

public class LoadJobs {
    public static void main(String[] args) throws Exception {
        DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
        Document document;
        try{
            DocumentBuilder builder = factory.newDocumentBuilder();
            document = builder.parse(new File("C:\\xml\\jobs.xml"));
            
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection con = DriverManager.getConnection(
                    "jdbc:oracle:thin:@localhost:1521:XE", // database url
                    "hr",  // username
                    "hr"); // password
            System.out.println("Connected to Oracle using Thin driver!");
            PreparedStatement ps = con.prepareStatement
                    ("insert into jobs values(?,?,?,?)");
            Element root = document.getDocumentElement();
            NodeList jobs = root.getChildNodes();
            
            for( int i = 0; i < jobs.getLength(); i ++ ){
                if( jobs.item(i).getNodeType() != Node.ELEMENT_NODE)
                    continue;
                // take details of job element
                NodeList details = jobs.item(i).getChildNodes();
                ps.setString(1, details.item(1).getFirstChild().getNodeValue());
                ps.setString(2, details.item(3).getFirstChild().getNodeValue());
                ps.setString(3, details.item(5).getFirstChild().getNodeValue());
                ps.setString(4, details.item(7).getFirstChild().getNodeValue());
                ps.executeUpdate(); // insert row into JOBS table
                System.out.println("Row got updated successfully!");
            }
            ps.close();
            con.close();
        }
        catch(Exception ex){
            System.out.println("Parsing error is " + ex.getMessage());
        }
    }
}

Welcome to the Ranch

Please click the "disable smilies" button for JDBC posts; I have disabled them for you, so your

changes to :o
Please provide more [ur=http://www.coderanch.com/how-to/java/TellTheDetails]details[/url] about the error. We can only help if you provide more information.

I try to read data from this xml file and post it into the table in database!

<?xml version="1.0" encoding="UTF-8"?>
<jobs>
<job>
<id>jp</id>
<title>Java Programmer</title>
<minsal>30000</minsal>
<maxsal>80000</maxsal>
</job>
<job>
<id>Dp</id>
<title>.Net Programmer</title>
<minsal>20000</minsal>
<maxsal>60000</maxsal>
</job>
</jobs>

Guys, I got it! Its a silly mistake! I haven't included the ojdbc14 file in this project!