sql error

[Aris Doxakis]

How can i declare my database through servlets???

Class.forName("org.gjt.mm.mysql.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/e_store");

[Ben Souther]

That will work.
You might also want to look into whatever your app server offeres for connection pooling and JNDI datasources.

[Aris Doxakis]

actually it doesn't work
i compile it with jcreator and the error is :

incompatible types

found java.sql.Connection
required Connection

any idea \

thnx

[Shailesh Chandra]

Originally posted by Aris Doxakis:
actually it doesn't work
i compile it with jcreator and the error is :

incompatible types

found java.sql.Connection
required Connection

can you put complete code !! I dont find the reason for fail in compiling.

 con = DriverManager.getConnection("jdbc:mysql://localhost/e_store")

are you sure that con is java.sql.Connection Type

Shailesh

[Craig Jackson]

I think, I received an error similar to this in the past. The problem was in my import statements. I imported the same Class from different packages. For example

import java.sql.*;
import com.mysql.jdbc.*;
 

Not knowing, I imported the the same class from two different packages.

Could this be your problem.

[Aris Doxakis]

this is my test project so i can open a database connection

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Connection extends HttpServlet
{
Connection con;
public void init()
{
try
{
Class.forName("org.gjt.mm.mysql.Driver");
String conne = "jdbc:mysql://localhost/e_store";
con = DriverManager.getConnection(conne);
}
catch (ClassNotFoundException e)
{
log("Couldn't find mm.mysql driver");
}

catch (SQLException e)
{
log("Sql Exception while connecting to MySQL",e);
}
}

public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
{
response.setContentType("text/html;charset=ISO-8859-7");
PrintWriter out = response.getWriter();

if (con!=null)
{
out.println("Sindethika epituxos");
out.println("<br> Onomata stin Basi Dedomenod:");

try
{
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("show tables;");
while (rs.next())
{
String tableName = rs.getString(1);
out.println("<br> + tableName");
}
}

catch (SQLException e)
{
log("SQL Exception",e);
}
}
else
{
out.println("Den mporesa na syndetho me tin BD");
}
}

public void destroy()
{
if (con!=null)
{
try
{
con.close();
}

catch (SQLException e)
{
log("Couldn't close Connection",e);
}
}
}
}

[Carol Enderlin]

Change the name of your class, it is Connection!

[Shailesh Chandra]

Originally posted by Carol Enderlin:
Change the name of your class, it is Connection!

Aris,

Carol gave you the solution

one NOT recommended approach would be that declare you con variable as

java.sql.Connection con;

but again I insist on what carol said "Change the name of class"
[ April 06, 2005: Message edited by: Shailesh Chandra ]

[Aris Doxakis]

maybe that will work thnx

[Aris Doxakis]

it did work actually

one more question(im new so be easy on me)

how can i see my servlet running on internet explorer???

with tomcat

in which folder should i put it and so on

thnx

[Saket Barve]

The complied servlet needs to go to the classes folder inside of your context's WEB-INF.

You might want to refer to the docs before proceeding further.

Regards,
Saket