Can't Connect to Mysql with JBuilder...

[Lilyana Saputra]

i have a problem....

i want to connect to mysql...using :

Class.forName("com.mysql.jdbc.Driver");
// or Class.forName("org.gjt.mm.mysql.Driver");

and ....

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

it has been work at Netbeans and TextPad...
but it fail in JBuilder...

I has been copy the driver into ...
C:\Program Files\Java\jdk1.5.0_04\jre\lib\ext

Thx

[Christophe Verré]

but it fail in JBuilder...

What is the error message ?

[Lilyana Saputra]

this is my method to connect:

  public void getConnected(String url)
    {
        try {
          //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//            Class.forName("com.mysql.jdbc.Driver");
            Class.forName("org.gjt.mm.mysql.Driver");
        }catch (java.lang.ClassNotFoundException e){
            System.err.print("ClassNotFoundException:");
//            System.err.println(e.getMessage());
        }
        try {
            //con = DriverManager.getConnection (url);
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/coba", "", "");
            stmt=con.createStatement();
            dmd = con.getMetaData();
        }catch(SQLException e) {
  //          e.toString();
  System.err.print("Error nih");
        }
    }

and this is error message that appear in log:

ClassNotFoundException:Error nihFeb 15, 2006 4:06:15 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet debugjsp threw exception
java.lang.NullPointerException
at database.Bean1.getDatabaseProductName(Bean1.java:108)
at org.apache.jsp.jsp1_jsp._jspService(org.apache.jsp.jsp1_jsp:69)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at [CODE]    

org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
[/CODE]

[George Stoianov]

Hi,

at database.Bean1.getDatabaseProductName(Bean1.java:108)

It seems that this is the line causing your problem but we have a different piece of code can you post that as well, and sorry if this sounds silly but do you have an anonymous user with access to that database from any host??

Could you also print the stack trace in your catch blocks so we can see some jvm output.

Thanks,
George