java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

283 100+

hi frnds,
im trying to convert my servlets database configuration from ms access to mysql database.however im getting some error like no driver found exception.
to verify this error ive made a simple database in jsp(just to check if my mysql is working smoothly otherwise) which access' the username.....but in the process im getting a error-->
java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

i have no idea wat this error is as this is the first time im working with mysql.

my jsp code is-->

Expand|Select|Wrap|Line Numbers

 
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

    pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*" %>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Insert title here</title>

</head>

<%! Connection conn=null;

PreparedStatement pr=null;

ResultSet rs=null;

%>

<body>

<%

try

{

    Class.forName("org.gjt.mm.mysql.Driver");

    conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/TEST");

    String uName=request.getParameter("userName");

    pr=conn.prepareStatement("SELECT * FROM LOGIN WHERE name=?");

    pr.setString(1,uName);

    rs=pr.executeQuery();

    while(rs.next())

    {

        String str=rs.getString(1);

        out.println("<br>"+str);

        str=rs.getString(2);

        out.println("<br>" +str);

    }

    conn.close();

}

catch(Exception e)

{

    System.out.println(e);

}

%>

</body>

</html>

and my stack trace is--->
Sep 3, 2007 6:09:24 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.5.0_10\bin;.;C:\WINDOWS\system32;C :\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOW S\System32\Wbem;C:\WINDOWS\Downloaded Program Files;C:\IBMTOOLS\Python22;C:\Program Files\PC-Doctor for Windows\services;C:\Program Files\Java\jdk1.5.0_10\bin;C:\PROGRA~1\IBM\SQLLIB\ BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IB M\SQLLIB\SAMPLES\REPL1;C:\logging-log4j-1.2.14\dist\lib\log4j-1.2.14.jar;C:\xerces\xml-apis.jar;C:\xerces\xercesImpl.jar
Sep 3, 2007 6:09:24 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Sep 3, 2007 6:09:24 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 875 ms
Sep 3, 2007 6:09:24 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Sep 3, 2007 6:09:24 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Sep 3, 2007 6:09:24 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Sep 3, 2007 6:09:25 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Sep 3, 2007 6:09:25 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Sep 3, 2007 6:09:25 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='resources.application', returnNull=true
Sep 3, 2007 6:09:25 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Sep 3, 2007 6:09:25 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Sep 3, 2007 6:09:26 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='resources.application', returnNull=true
Sep 3, 2007 6:09:26 PM org.apache.struts.tiles.xmlDefinition.I18nFactoryS et initFactory
SEVERE: null : Can't find file '/WEB-INF/tiles-defs.xml'
Sep 3, 2007 6:09:26 PM org.apache.struts.tiles.TilesPlugin init
SEVERE: Can't create Tiles definition factory for module ''.
Sep 3, 2007 6:09:26 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /servintostruts1 threw load() exception
org.apache.struts.tiles.FactoryNotFoundException: null : Can't find file '/WEB-INF/tiles-defs.xml'
at org.apache.struts.tiles.xmlDefinition.I18nFactoryS et.initFactory(I18nFactorySet.java:224)
at org.apache.struts.tiles.definition.ComponentDefini tionsFactoryWrapper.init(ComponentDefinitionsFacto ryWrapper.java:139)
at org.apache.struts.tiles.TilesUtilImpl.createDefini tionsFactory(TilesUtilImpl.java:168)
at org.apache.struts.tiles.TilesUtil.createDefinition sFactory(TilesUtil.java:205)
at org.apache.struts.tiles.TilesPlugin.init(TilesPlug in.java:230)
at org.apache.struts.action.ActionServlet.initModuleP lugIns(ActionServlet.java:1158)
at org.apache.struts.action.ActionServlet.init(Action Servlet.java:473)
at javax.servlet.GenericServlet.init(GenericServlet.j ava:212)
at org.apache.catalina.core.StandardWrapper.loadServl et(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(Stan dardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnSta rtup(StandardContext.java:3956)
at org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4230)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:736)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:443)
at org.apache.catalina.core.StandardService.start(Sta ndardService.java:448)
at org.apache.catalina.core.StandardServer.start(Stan dardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:433)
Sep 3, 2007 6:09:26 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Sep 3, 2007 6:09:26 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Sep 3, 2007 6:09:26 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/32 config=null
Sep 3, 2007 6:09:26 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Sep 3, 2007 6:09:26 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 2328 ms
java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

Sep 3 '07 #1

Subscribe Post Reply

28391

r035198x

13,262

8TB

hi frnds,
im trying to convert my servlets database configuration from ms access to mysql database.however im getting some error like no driver found exception.
to verify this error ive made a simple database in jsp(just to check if my mysql is working smoothly otherwise) which access' the username.....but in the process im getting a error-->
java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

i have no idea wat this error is as this is the first time im working with mysql.

my jsp code is-->

Expand|Select|Wrap|Line Numbers

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

    pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*" %>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>Insert title here</title>

</head>

<%! Connection conn=null;

PreparedStatement pr=null;

ResultSet rs=null;

%>

<body>

<%

try

{

    Class.forName("org.gjt.mm.mysql.Driver");

    conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/TEST");

    String uName=request.getParameter("userName");

    pr=conn.prepareStatement("SELECT * FROM LOGIN WHERE name=?");

    pr.setString(1,uName);

    rs=pr.executeQuery();

    while(rs.next())

    {

        String str=rs.getString(1);

        out.println("<br>"+str);

        str=rs.getString(2);

        out.println("<br>" +str);

    }

    conn.close();

}

catch(Exception e)

{

    System.out.println(e);

}

%>

</body>

</html>

and my stack trace is--->
Sep 3, 2007 6:09:24 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.5.0_10\bin;.;C:\WINDOWS\system32;C :\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOW S\System32\Wbem;C:\WINDOWS\Downloaded Program Files;C:\IBMTOOLS\Python22;C:\Program Files\PC-Doctor for Windows\services;C:\Program Files\Java\jdk1.5.0_10\bin;C:\PROGRA~1\IBM\SQLLIB\ BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IB M\SQLLIB\SAMPLES\REPL1;C:\logging-log4j-1.2.14\dist\lib\log4j-1.2.14.jar;C:\xerces\xml-apis.jar;C:\xerces\xercesImpl.jar
Sep 3, 2007 6:09:24 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Sep 3, 2007 6:09:24 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 875 ms
Sep 3, 2007 6:09:24 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Sep 3, 2007 6:09:24 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Sep 3, 2007 6:09:24 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Sep 3, 2007 6:09:25 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Sep 3, 2007 6:09:25 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Sep 3, 2007 6:09:25 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='resources.application', returnNull=true
Sep 3, 2007 6:09:25 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Sep 3, 2007 6:09:25 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Sep 3, 2007 6:09:26 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='resources.application', returnNull=true
Sep 3, 2007 6:09:26 PM org.apache.struts.tiles.xmlDefinition.I18nFactoryS et initFactory
SEVERE: null : Can't find file '/WEB-INF/tiles-defs.xml'
Sep 3, 2007 6:09:26 PM org.apache.struts.tiles.TilesPlugin init
SEVERE: Can't create Tiles definition factory for module ''.
Sep 3, 2007 6:09:26 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /servintostruts1 threw load() exception
org.apache.struts.tiles.FactoryNotFoundException: null : Can't find file '/WEB-INF/tiles-defs.xml'
at org.apache.struts.tiles.xmlDefinition.I18nFactoryS et.initFactory(I18nFactorySet.java:224)
at org.apache.struts.tiles.definition.ComponentDefini tionsFactoryWrapper.init(ComponentDefinitionsFacto ryWrapper.java:139)
at org.apache.struts.tiles.TilesUtilImpl.createDefini tionsFactory(TilesUtilImpl.java:168)
at org.apache.struts.tiles.TilesUtil.createDefinition sFactory(TilesUtil.java:205)
at org.apache.struts.tiles.TilesPlugin.init(TilesPlug in.java:230)
at org.apache.struts.action.ActionServlet.initModuleP lugIns(ActionServlet.java:1158)
at org.apache.struts.action.ActionServlet.init(Action Servlet.java:473)
at javax.servlet.GenericServlet.init(GenericServlet.j ava:212)
at org.apache.catalina.core.StandardWrapper.loadServl et(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(Stan dardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnSta rtup(StandardContext.java:3956)
at org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4230)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:736)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:443)
at org.apache.catalina.core.StandardService.start(Sta ndardService.java:448)
at org.apache.catalina.core.StandardServer.start(Stan dardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:433)
Sep 3, 2007 6:09:26 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Sep 3, 2007 6:09:26 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Sep 3, 2007 6:09:26 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/32 config=null
Sep 3, 2007 6:09:26 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Sep 3, 2007 6:09:26 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 2328 ms
java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

The error simply means that your log in details are incorrect.
Wrong password/username/database name. Verify that they are correct.

Sep 3 '07 #2

ajos

283

100+

The error simply means that your log in details are incorrect.
Wrong password/username/database name. Verify that they are correct.

hi,
i suppose that my username and password is root and my db name is TEST2...can u tell me how to check my username and password???im using the command prompt for this particular database problem...
regards
ajos

Sep 3 '07 #3

r035198x

13,262

8TB

hi,
i suppose that my username and password is root and my db name is TEST2...can u tell me how to check my username and password???im using the command prompt for this particular database problem...
regards
ajos

To test on the command prompt with username "root" and password called "password" you do

Expand|Select|Wrap|Line Numbers

 mysql -u root -p

password:                           /you type "password" here

From the Java program you do

Expand|Select|Wrap|Line Numbers

 conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/TEST", "root", "password");
 

Sep 3 '07 #4

ajos

283

100+

To test on the command prompt with username "root" and password called "password" you do

Expand|Select|Wrap|Line Numbers

mysql -u root -p

password: /you type "password" here

From the Java program you do

Expand|Select|Wrap|Line Numbers

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/TEST", "root", "password");

hey,
u know wat this is the 2 nd time u r helping me out and successfully though...thank u very much for this help...i appreciate it very much...now that ive come to know that i have a successful connection with mysql also, then why im getting an No Suitable Driver Exception....im my servlet which goes like this--->

Expand|Select|Wrap|Line Numbers

 
// Decompiled by DJ v3.4.4.74 Copyright 2003 Atanas Neshkov  Date: 7/4/2003 12:37:00 PM

// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!

// Decompiler options: packimports(3)

// Source File Name:   BdgtMaster.java

package publicity;
 
import java.io.*;

import java.sql.*;

import javax.servlet.*;

import javax.servlet.http.*;
 
public class BdgtMaster extends HttpServlet

{
 
    public synchronized void service(HttpServletRequest httpservletrequest, HttpServletResponse httpservletresponse)

        throws ServletException, IOException

    {

        //httpservletrequest.setAttribute(arg0, arg1);

        //HttpSession session=request.getSession();

        Object obj = null;

        String s3 = "";

        String s4 = "";

        out = httpservletresponse.getOutputStream();

        String s = "";

        String s1 = "";

        String s2 = httpservletrequest.getParameter("option");

        s3 = httpservletrequest.getParameter("branch");

        s4 = httpservletrequest.getParameter("publicity_code");

        String s5 = httpservletrequest.getParameter("budget");

         try

        {

            String s6 = "0";

            String s7 = "0";

            String s8 = "INSERT INTO Budget_Master(Branch,Publicity_Code,Budget_Alloted,Work_In_Progress,Amount_Paid) VALUES (?,?,?,?,?)";

            String s9 = "update budget_master set old_budget = budget_alloted where branch='" + s3 + "' and publicity_code=" + s4;

            String s10 = "UPDATE Budget_Master set budget_alloted=" + s5 + " where Branch='" + s3 + "' and publicity_code=" + s4;

            String url="jdbc:mysql://localhost:3306/";

            String dbName="test";

            String Driver="com.mysql.jdbc.Driver";

            //datasource = "jdbc:odbc:budget";

            String userName="root";

            String passWord="root";

            con = DriverManager.getConnection("jdbc.mysql://localhost:3306/test","root","root");

            int i = con.getTransactionIsolation();

            con.setTransactionIsolation(2);

            con.setAutoCommit(false);

            if("new".equalsIgnoreCase(s2))

            {

                PreparedStatement preparedstatement = con.prepareStatement(s8);

                preparedstatement.setString(1, s3);

                preparedstatement.setString(2, s4);

                preparedstatement.setString(3, s5);

                preparedstatement.setString(4, s7);

                preparedstatement.setString(5, s6);

                preparedstatement.executeUpdate();

                con.commit();

                preparedstatement.close();

            }

            if("update".equalsIgnoreCase(s2))

            {

                Statement statement = con.createStatement();

                statement.executeUpdate(s9);

                statement.executeUpdate(s10);

                con.commit();

            }

            con.setTransactionIsolation(0);

            htmlStart(out, "BUDGET MASTER");

            out.println("<p>&nbsp;</p><div align=\"left\">");

            out.println("<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"50%\">");

            out.print("<tr>");

            out.println("<td width=\"50%\"><strong><small><font face=\"Tahoma\">Branch </font></small></strong></td>");

            out.println("<td width=\"50%\"><small><font color=\"#004080\" face=\"Tahoma\">" + s3 + "</font></small></td></tr><tr>");

            out.println("<td width=\"50%\"><strong><small><font face=\"Tahoma\">Budget Alloted </font></small></strong></td>");

            out.println("<td width=\"50%\"><small><font color=\"#004080\" face=\"Tahoma\">" + s5 + "</font></small></td></tr><tr>");

            out.println("<td width=\"50%\"><small><strong><font face=\"Tahoma\">Publicity Code</font></strong></small></td>");

            out.println("<td width=\"50%\"><small><font color=\"#004080\" face=\"Tahoma\">" + s4 + "</font></small></td></tr></table></div>");

            htmlEnd(out);

            con.close();

        }

        catch(SQLException sqlexception)

        {

            cleanUp();

            printSQLException(sqlexception, out);

        }

        out.flush();

    }

    public void doGet(HttpServletRequest request,HttpServletResponse response)

    throws ServletException,IOException

    {
 
    }
 
    public void init(ServletConfig servletconfig)

        throws ServletException

    {

        super.init(servletconfig);

        try

        {

            Class.forName("com.mysql.jdbc.Driver");

            System.out.println("database connection established");

        }

        catch(Exception e)

        {

            System.out.println("error in database connection");

            System.out.println(e);

        }

        /*try

        {

            try {

                Class.forName("com.mysql.jdbc.Driver").newInstance();

            } catch (InstantiationException e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            } catch (IllegalAccessException e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            }

            System.out.println("conn est");

            return;

        }

        catch(ClassNotFoundException classnotfoundexception)

        {

            log("Couldn't load class com.mysql.jdbc.Driver");

            throw new ServletException(classnotfoundexception.getMessage());

        }*/

    }
 
    static void printSQLException(SQLException sqlexception, ServletOutputStream servletoutputstream)

        throws IOException

    {

        servletoutputstream.print("<b>SQLException</b>\n<p>\n\n");

        for(; sqlexception != null; sqlexception = sqlexception.getNextException())

        {

            servletoutputstream.print("<b>SQLState:</b> " + sqlexception.getSQLState() + "<br>\n");

            servletoutputstream.print("<b>Message:</b> " + sqlexception.getMessage() + "<br>\n");

            servletoutputstream.print("<b>Vendor:</b> " + sqlexception.getErrorCode() + "<br>\n");

        }
 
    }
 
    private static boolean checkForWarning(SQLWarning sqlwarning)

        throws SQLException

    {

        boolean flag = false;

        if(sqlwarning != null)

        {

            System.out.println("\n *** Warning ***\n");

            flag = true;

            for(; sqlwarning != null; sqlwarning = sqlwarning.getNextWarning())

            {

                System.out.println("SQLState: " + sqlwarning.getSQLState());

                System.out.println("Message:  " + sqlwarning.getMessage());

                System.out.println("Vendor:   " + sqlwarning.getErrorCode());

                System.out.println("");

            }
 
        }

        return flag;

    }
 
    void htmlStart(ServletOutputStream servletoutputstream, String s)

        throws IOException

    {

        servletoutputstream.println("<html><head><title>" + s + "</title></head>");

        servletoutputstream.println("<body topmargin=\"0\" leftmargin=\"0\" bgproperties=\"fixed\">");

        servletoutputstream.println("<div align=\"left\"><table border=\"0\" width=\"100%\">");

        servletoutputstream.println("<tr><td width=\"100%\" bgcolor=\"#DFDFFF\">");

        servletoutputstream.println("<font face=\"Tahoma\" color=\"#000000\"><strong>B u d g e t&nbsp;&nbsp; M a s t e r - D e t a i l s&nbsp;&nbsp; E n t e r e d</strong></font></td>");

        servletoutputstream.println("</tr></table>");

    }
 
    void htmlEnd(ServletOutputStream servletoutputstream)

        throws IOException

    {

        servletoutputstream.print("<hr>");

        servletoutputstream.print("</body></html>\n");

    }
 
    String link(String s, String s1)

    {

        return "<a href=\"" + s + "\">" + s1 + "</a>";

    }
 
    public String getServletInfo()

    {

        return "Display and SQL manipulate JDBC databases on the server.";

    }
 
    public void cleanUp()

        throws IOException

    {

        if(con != null)

            try

            {

                out.print("Closing database connection");

                con.setTransactionIsolation(0);

                con.close();

                return;

            }

            catch(SQLException _ex)

            {

                return;

            }

        else

            return;

    }
 
    public BdgtMaster()

    {

    }
 
    private Connection con;

    private String datasource;

    private String user;

    private String password;

    private String base;

    private ServletOutputStream out;

}

is it bcoz of the access queryy that ive not changed....but atleast it shud run,isnt it???

herz the stack trace--->
Sep 3, 2007 7:07:49 PM org.apache.catalina.core.AprLifecycleListener lifecycleEvent
INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre1.5.0_10\bin;.;C:\WINDOWS\system32;C :\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOW S\System32\Wbem;C:\WINDOWS\Downloaded Program Files;C:\IBMTOOLS\Python22;C:\Program Files\PC-Doctor for Windows\services;C:\Program Files\Java\jdk1.5.0_10\bin;C:\PROGRA~1\IBM\SQLLIB\ BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IB M\SQLLIB\SAMPLES\REPL1;C:\logging-log4j-1.2.14\dist\lib\log4j-1.2.14.jar;C:\xerces\xml-apis.jar;C:\xerces\xercesImpl.jar
Sep 3, 2007 7:07:49 PM org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Sep 3, 2007 7:07:49 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 875 ms
Sep 3, 2007 7:07:49 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Sep 3, 2007 7:07:49 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
Sep 3, 2007 7:07:49 PM org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
Sep 3, 2007 7:07:49 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Sep 3, 2007 7:07:49 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Sep 3, 2007 7:07:50 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='resources.application', returnNull=true
Sep 3, 2007 7:07:50 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings', returnNull=true
Sep 3, 2007 7:07:50 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='org.apache.struts.action.ActionResources', returnNull=true
Sep 3, 2007 7:07:50 PM org.apache.struts.util.PropertyMessageResources <init>
INFO: Initializing, config='resources.application', returnNull=true
Sep 3, 2007 7:07:50 PM org.apache.struts.tiles.xmlDefinition.I18nFactoryS et initFactory
SEVERE: null : Can't find file '/WEB-INF/tiles-defs.xml'
Sep 3, 2007 7:07:50 PM org.apache.struts.tiles.TilesPlugin init
SEVERE: Can't create Tiles definition factory for module ''.
Sep 3, 2007 7:07:50 PM org.apache.catalina.core.StandardContext loadOnStartup
SEVERE: Servlet /servintostruts1 threw load() exception
org.apache.struts.tiles.FactoryNotFoundException: null : Can't find file '/WEB-INF/tiles-defs.xml'
at org.apache.struts.tiles.xmlDefinition.I18nFactoryS et.initFactory(I18nFactorySet.java:224)
at org.apache.struts.tiles.definition.ComponentDefini tionsFactoryWrapper.init(ComponentDefinitionsFacto ryWrapper.java:139)
at org.apache.struts.tiles.TilesUtilImpl.createDefini tionsFactory(TilesUtilImpl.java:168)
at org.apache.struts.tiles.TilesUtil.createDefinition sFactory(TilesUtil.java:205)
at org.apache.struts.tiles.TilesPlugin.init(TilesPlug in.java:230)
at org.apache.struts.action.ActionServlet.initModuleP lugIns(ActionServlet.java:1158)
at org.apache.struts.action.ActionServlet.init(Action Servlet.java:473)
at javax.servlet.GenericServlet.init(GenericServlet.j ava:212)
at org.apache.catalina.core.StandardWrapper.loadServl et(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(Stan dardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnSta rtup(StandardContext.java:3956)
at org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4230)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:736)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:443)
at org.apache.catalina.core.StandardService.start(Sta ndardService.java:448)
at org.apache.catalina.core.StandardServer.start(Stan dardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:433)
Sep 3, 2007 7:07:51 PM org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Sep 3, 2007 7:07:51 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Sep 3, 2007 7:07:51 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/47 config=null
Sep 3, 2007 7:07:51 PM org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
Sep 3, 2007 7:07:51 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 2313 ms
database connection established

after making some changes in the servlet code ive got this exception
-->Closing database connectionSQLException
SQLState: null
Message: Transaction isolation level NONE not supported by MySQL
Vendor: 0

Sep 3 '07 #5

r035198x

13,262

8TB

Here are some important tips.
1.) If you are using "root" as root's password, then change your root password immediately
user instead and give them appropriate permission
2.) Do not post stacktraces that contain your system info in public forums
3.) Variable names like s1, s2, s3 ... are a good source for debugging headaches. Give meaningful names to your variables that easily relate to what the variable is pointing to.
4.) As for that stacktrace, I've never used tomcat before by I suspect your problem is on this line of the stacktrace

Expand|Select|Wrap|Line Numbers

Can't find file '/WEB-INF/tiles-defs.xml'

Have you tried restarting the application/server?

Sep 3 '07 #6

ajos

283

100+

Here are some important tips.
1.) If you are using "root" as root's password, then change your root password immediately
user instead and give them appropriate permission
2.) Do not post stacktraces that contain your system info in public forums
3.) Variable names like s1, s2, s3 ... are a good source for debugging headaches. Give meaningful names to your variables that easily relate to what the variable is pointing to.
4.) As for that stacktrace, I've never used tomcat before by I suspect your problem is on this line of the stacktrace

Expand|Select|Wrap|Line Numbers

Can't find file '/WEB-INF/tiles-defs.xml'

Have you tried restarting the application/server?

hey,
ive tried restarting and the stuff that is required...as for the password root..i'll make the necessary changes, the exception that i caught was--->

Closing database connectionSQLException
SQLState: null
Message: Transaction isolation level NONE not supported by MySQL
Vendor: 0

and the problem of tiles-def.xml arises in all the problems that i do...but that hasnt caused any problems when i was using access database....i think the problem is in the queries.....the queries above that i mentioned are access queries.....im not sure abt this(query thing).
regards,
ajos

Sep 3 '07 #7

r035198x

13,262

8TB

hey,
ive tried restarting and the stuff that is required...as for the password root..i'll make the necessary changes, the exception that i caught was--->

Closing database connectionSQLException
SQLState: null
Message: Transaction isolation level NONE not supported by MySQL
Vendor: 0

and the problem of tiles-def.xml arises in all the problems that i do...but that hasnt caused any problems when i was using access database....i think the problem is in the queries.....the queries above that i mentioned are access queries.....im not sure abt this(query thing).
regards,
ajos

When setting transaction isolation levels, use the constants defined in the docs here, not hardcoded int values.
The exception is probably because you're setting transaction isolation level to none (Connection.TRANSACTION_NONE) which as the docs explain there should not be used.

Edit: It's always a good idea to test to see if the database supports the isolation level first using DatabaseMetadata.supportsTransactionIsolationLevel

Sep 3 '07 #8

ajos

283

100+

When setting transaction isolation levels, use the constants defined in the docs here, not hardcoded int values.
The exception is probably because you're setting transaction isolation level to none (Connection.TRANSACTION_NONE) which as the docs explain there should not be used.

Edit: It's always a good idea to test to see if the database supports the isolation level first using DatabaseMetadata.supportsTransactionIsolationLevel

hey,
ive got ur point and done the necessary changes...and "IT WORKED" thanx for taking all the time for helping me out with my problems...u have been very kind and patient with me....i want to thank u for this.....hope to hear from u in the future posts..
regards ajos.....:)

Sep 3 '07 #9

java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)

Similar topics