My
java program which parses an xml file for connecting to MySql database shows an error when i tried to run it.The error is
java.lang.ClassNotFoundException: driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at JAXP1.main(JAXP1.java:50)
The XML file is as shown below.
<dbconnection>
<username> abc </username>
<password> abc123 </password>
<url>
jdbc:mysql://192.168.1.83/abc </url>
<driver> com.mysql.jdbc.Driver </driver>
</dbconnection>
and the java code is
import java.sql.*;
import javax.xml.parsers.*;
import org.w3c.dom.*;
import org.xml.sax.*;
import java.io.IOException;
import java.util.StringTokenizer;
public class JAXP1
{
static Connection con=null;
static Statement stmt=null;
static ResultSet resultset;
static
String username=" ";
static String password=" ";
static String url=" ";
static String driver=" ";
static String s=" ";
static String ss=" ";
public static void main(String[] args)
{
try
{
DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
DocumentBuilder parser = factory.newDocumentBuilder();
JAXP1 counter = new JAXP1();
for (int i = 0; i < args.length; i++)
{
try
{
Document d = parser.parse(args[i]);
display(d);
}
catch (SAXException e)
{
System.err.println(e);
}
catch (IOException e)
{
System.err.println(e);
}
}
try
{
System.out.println("Driver " + driver);
System.out.println("URL "+url);
System.out.println("user"+username +", password"+ password);
Class.forName(driver).newInstance();
con=DriverManager.getConnection(url,username,password);
stmt=con.createStatement();
if(con.isClosed())
System.out.println("Connected");
else
System.out.println("Not Connected");
}
catch(Exception e)
{
e.printStackTrace();
}
}
catch (ParserConfigurationException e)
{
System.err.println(e);
}
}
public static void display(Node node)
{
if (node.hasChildNodes())
{
NodeList children = node.getChildNodes();
for(int i=0;i<children.getLength();i++)
{
ss=node.getNodeName();
if(ss.equals("username"))
{
username =ss;
}
if(ss.equals("password"))
{
password =ss;
}
if(ss.equals("url"))
{
url =ss;
}
if(ss.equals("driver"))
{
driver =ss;
}
System.out.println("Tag Name= "+ss);
display(children.item(i));
}
}
int type = node.getNodeType();
NodeList child = node.getChildNodes();
if(type==Node.TEXT_NODE)
{
s=node.getNodeValue();
for (int i=0; i < child.getLength(); i++)
{
s=node.getNodeValue();
if(ss.equals("username"))
{
username = s;
}
if(ss.equals("password"))
{
password = s;
}
if(ss.equals("url"))
{
url = s;
}
if(ss.equals("driver"))
{
driver = s;
}
}
/*try
{
Class.forName(driver).newInstance();
con=DriverManager.getConnection(url,username,password);
stmt=con.createStatement();
if(con.isClosed())
System.out.println("Connected");
else
System.out.println("Not Connected");
}
catch(Exception e)
{
e.printStackTrace();
}
}*/
System.out.println(ss+s);
}
}
}
I am not getting connected to the data base.
could any one help me....?