Problem with JDBC driver config

[vincenzom86]

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:1521:XE","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:1521:XE

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

[masijade]

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

[vincenzom86]

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.

[masijade]

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.

jdbc:oracle:thin://locahost:1521:dbName

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

[vincenzom86]

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

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

but now i've this error:

14: Class.forName("oracle.jdbc.driver.OracleDriver");
15:
16: conn = DriverManager.getConnection("jdbc:oracle:thin://PC280631275888:1521:XE","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...

[masijade]

Is this the url you're using

jdbc:oracle:thin://PC280631275888:1521:XE

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

The Connection descriptor used by the client was:
localhost:1521:orcl

you are using:

jdbc:oracle:thin://localhost:1521:orcl

Maybe in another place in the code, or something?

[vincenzom86]

no...i'use only this string :

[TEX]conn = DriverManager.getConnection("jdbc:oracle:thin://PC280631275888:1521:XE"[/TEX].

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!!!

[vincenzom86]

conn string here :

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

sorry again:'(

[masijade]

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

[code]SID[/code]

will appear as

SID

[masijade]

no...i'use only this string :

[TEX]conn = DriverManager.getConnection("jdbc:oracle:thin://PC280631275888:1521:XE"[/TEX].

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!!!

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

[vincenzom86]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="content-type" content="text/html; charset=windows-1250">
  <title>DAO</title>
  </head>
  <body>

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

Connection conn = null;

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection("jdbc:oracle:thin://PC280631275888:1521:XE","vincenzom86","xxx");

Statement st = conn.createStatement();

String Nome = new String (request.getParameter("Nome"));
String Cognome = new String (request.getParameter("Cognome"));
String Retrib_Prog = new String (request.getParameter("Retrib_Prog"));
String Retrib_Spese = new String (request.getParameter("Retrib_Spese"));
String Retrib_Stip_Fer = new String (request.getParameter("Retrib_Stip_Fer"));
String Retrib_Stip_Fest = new String (request.getParameter("Retrib_Stip_Fest"));
String Retrib_Rep = new String (request.getParameter("Retrib_Rep"));
String Retrib_Rep_Ore = new String (request.getParameter("Retrib_Rep_Ore"));
String Retrib_Pos_Cont = new String (request.getParameter("Retrib_Pos_Cont"));
String Retrib_Costo_Fiss = new String (request.getParameter("Retrib_Costo_Fiss"));
String Commenti = new String (request.getParameter("Commenti"));


  
st.executeUpdate("INSERT INTO ValContrattualiDipendenti VALUES ('"+Nome+"','"+Cognome+"','"+Retrib_Prog+"','"+Retrib_Spese+"','"+Retrib_Stip_Fer+"','"+Retrib_Stip_Fest+"','"+Retrib_Rep+"','"+Retrib_Rep_Ore+"','"+Retrib_Pos_Cont+"','"+Retrib_Costo_Fiss+"','"+Commenti+"')");

st.close();
conn.close();
%>
<br><br>
</font>
  </body>
</html>

ty for the info. this is all the .jsp code

[masijade]

Like I say, you need to talk to the admins.

Also, you mistakenly provided m0lf3tt4 in an earlier post, so I would suggest getting your password changed.

Also, this DB code should not be included in a jsp as a scriptlet. It should be placed in a bean. Also, since this seems to be something that takes action, rather than simply presenting data, it should be done by a servlet, not a JSP.

Actions are handled by servlets, data is handled by beans (and other classes outside of the JSP/Servlet classes), and JSP is for the presentation.

MVC

Model -- The Data. "External" objects such as Beans
View -- The Presentation. The delivery of the actual HTML. JSP
Control -- Essentially performing action requested by the user. Servlet.

Edit:

The sql stuff should also take place in a try block with the close lines being placed in the finally block, otherwise, you will leave behind open connections with this code and will soon run out.