Hi all this is my problem:


description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Exception in JSP: /DAO.jsp:16

13:
14: Class.forName("oracle.jdbc.driver.OracleDriver");
15:
16: conn = DriverManager.getConnection("jdbc:oracle:thin:vincenzom86@localhost:1521E","xxx","xxx");
17:
18: Statement st = conn.createStatement();
19:


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

javax.servlet.ServletException: No suitable driver found for jdbc:oracle:thin:vincenzom86@localhost:1521E


I use Oracle 10g and Tomcat for web server...i try all config for my connect driver but i'v always the same exception.
Thanks for the warning

Vincenzo

Place the Oracle Driver jar into tomcats common/lib directory.

thanks for the answer...i ve do it but always the same problem...i'm trying to download another driver.there' s some configuration for 1 xml file to do?because i've read something about server.xml file configuration.

Make sure it is actually the thin driver that you have, and not the oci driver. My first response was incorrect, ClassNotFound is classpath, no suitable driver is a misspelled url, or you have the oci driver installed rather than the thin driver.

Also, I don't believe you want username@hostname, but rather just hostname. i.e.

Read the documentation for the driver you do have for the proper url.

masijade thanks for the attention.i've try to change the driver conn with:

jdbc:oracle:thin://PC280631275888:1521E","xxx","xxx"

but now i've this error:

14: Class.forName("oracle.jdbc.driver.OracleDriver");
15:
16: conn = DriverManager.getConnection("jdbc:oracle:thin://PC280631275888:1521E","vincenzom86","m0lf3tt4");
17:
18: Statement st = conn.createStatement();
19:


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

javax.servlet.ServletException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:orcl


i've see the listner.ora file and this is my config:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = PC280631275888)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)


i've also try to reboot server and db but always the same...

Is this the url you're using

Since you're not using code tags, I can't tell because you keep getting a "smilely" I don't recognise.

Seemingly, though, according to the error message
you are using:
Maybe in another place in the code, or something?

no...i'use only this string :

E"" alt="conn = DriverManager.getConnection("jdbc:oracle:thin://PC280631275888:1521E"" border="0" />.

scuse me for the emoticons but i'dont know how to format the text..but is XE
i've read that seems to use orcl and not XE but i don't know where...!!!in the tnsnames.ora and listener.ora SID name are all = XE!!!

conn string here :

conn = DriverManager.getConnection("jdbc:oracle:thin://PC280631275888:1521E"


sorry again

Surround your code (and the conn line from above) with code tags. i.e.

[code]SID[/code]

will appear as

Then, I can only say that you need to get the Oracle admins to check it out.