Hi Deepak,
i m again facing problem with single element multiple tag in xml.
i m trying to read the tag values into my database but it gives nullpointerexception. pls guide me appropriatly.
MyXML Structure is ,
Test1.xml
<test1>
<Firsttab>This</Firsttab>
<Firsttab>Is</Firsttab>
<Firsttab>it</Firsttab>
</test1>
and to read this xml into my db(which is in mysql) i write the following code.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import org.w3c.dom.Document;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.NodeList;
import org.w3c.dom.Node;
import org.w3c.dom.Element;


public class Test1 extends Object {

public static void main (String args[]){

String testFile = "Test1.xml";
Document testDoc = null;
try {
DocumentBuilderFactory docbuilderfactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docbuilder = docbuilderfactory.newDocumentBuilder();
testDoc = docbuilder.parse(testFile);
System.out.println("File Readed Successfully");
} catch (Exception e) {
System.out.println("Cannot read the test file: "+e.getMessage());
}

//For the JDBC-ODBC bridge, use
//driverName = "sun.jdbc.odbc.JdbcOdbcDriver"
//and
//connectURL = "jdbc:odbc:orders"
String driverName = "com.mysql.jdbc.Driver";
String connectURL = "jdbc:mysql://localhost:3306/training";
Connection db = null;
try {
Class.forName(driverName);
db = DriverManager.getConnection(connectURL,"root","mysql");
System.out.println("Connect Successfullly");

//Get the root element and all order elements
Element testRoot = testDoc.getDocumentElement();
System.out.println(testRoot);
NodeList test = testRoot.getElementsByTagName("test1");
System.out.println(test);
for(int i = 0; i < test.getLength(); i++)
{
//For each order, get the order element
Element thisTest = (Element)test.item(i);
System.out.println(thisTest);
//Get name
String thisTestname = thisTest.getElementsByTagName("Firsttab").item(0).getFirstChild().getNodeValue();
System.out.println("Firsttab: " + thisTestname);
System.out.println();
}

}
catch (ClassNotFoundException e)
{
System.out.println("Error creating class: "+e.getMessage());
} catch (SQLException e) {
System.out.println("Error creating connection: "+e.getMessage());

} finally {
System.out.println("Closing connections...");
try {
db.close();
} catch (SQLException e) {
System.out.println("Can't close connection.");
}
}
}
}

please give me a solution.

Thanks,
Prashant