sachin mesala

Originally posted by sachin mesala:



Hi,

yes i am using eclipse and i did the way you said but the error is



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:aks

Originally posted by Roger Chung-Wee:
Are you running this from eclipse? If so, you must add the JAR file containing the driver to the build path.

Right click on the project and select Properties. In the left column select Java Build Path. To the right select the Libraries tab. Click the Add External JARs... button. Search through the file system until you find the JAR file and Click OK.

You may need to rebuild your project to pick up the latest classpath.

Hi,

I did like but i am getting error as

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:aks

Originally posted by Ulf Dittmer:
How are you adding the JDBC driver to the classpath? It apparently isn't part of it.

Hi, I gave in the environment variables , in the user variables I gave variable classpath and the value as . ;C:\oracle\ora92\jdbc\lib\classes12.jar.

But i even tried with the �. Classes14.jar

Still same error.

Originally posted by Ulf Dittmer:
How are you adding the JDBC driver to the classpath? It apparently isn't part of it.

Hi,

i really dont know how to add the JDBC driver to the classpath, can you guide me please.

Originally posted by Ulf Dittmer:
What is "some exception"? In which line does it happen?

Its on the mine number 9 and the exception is

exception occuredjava.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Hi everyone,

I am using oracle 10g, my jdk is 1.4 and my IDE is eclipse and I am trying to connect the oracle data base with the following code, but I am always getting some exception.

I know time is precious.

import java.sql.*; import java.io.*; public class NotesDB2 { public static void main(String[] args) throws SQLException, IOException{ System.out.println ("Loading Oracle driver..."); try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loading!"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:aks","scott","tiger"); System.out.println("Got Connected" +con); con.close(); } catch(Exception e) { e.printStackTrace(); System.out.println("exception occured" +e); } } }

Originally posted by Ben Souther:


Yes. Pick up a good book on the subject.
I used Core Servlet and Java Server Pages years ago.
I know there is a newer edition of it out there but haven't looked at it yet.
Another one that is popular is the Head First Servlets book.

Hi Bean,

Thank you for the information.

sachin

Originally posted by Ben Souther:
There's nothing missing as far as the attribute goes.
You're binding it to request scope.
Your JSP is reading it back from session scope.

What's missing is the forward from the servlet to the JSP.

Download the SimpleMVC example in our code barn.
Drop the war file in your webapps directory and Tomcat will deploy it.

You will then have a working example that does all of this.

Hi,

I used the example which you mentioned and added the requestdispatcher in the servlet and now its working.

Thanks a lot




Any good suggestion from you to me, after seeing my errors , as i want to be a good programmer.

Thanks.
ashwin

Originally posted by Ben Souther:
Your not writing any output or forwarding to any JSPs in your servlet.
public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { String name = request.getParameter("title"); response.setAttribute("paul", name); }

There is no reason why it should show you anything.

<%= request.getAttribute("name") %>

In the jsp file I gave the above expression code and I knew that it wont be sufficient for the link between the servlet and the jsp.

Still some thing is missing in the servlet which has to be given so that string can be passed from html form to the jsp.

Originally posted by Ben Souther:
The 3 dots (an ellipse) mean that I left the rest out for brevity.

Make sure your tag is complete.

obviously i dint gave like that. i gave the remainning code.

still there is some thing missing.

Originally posted by Ben Souther:


I wasn't suggesting that you put the full path in your form.
I just wanted you to post it here so we can see what it is.
Your application is not the root application in your server.
It has a contextPath of "Lasto".
Therefore, Lasto needs to be part of your URL when calling your servlet.

<form action="/Lasto/xyz" ...

I kept in the form action="Lasto/xyz" ....

and when i enter some text in the form , i can see that jsp excutes but i am getting only a blank page, there is no display of any string which i enter in the html nor some text inside the JSP.

Originally posted by Ben Souther:
"coz" isn't a word.


Post the full path to your servlet class file.

Example:
c:\tomcat\webapps\myapp\WEB-INF\classes\com\mypackage\MyServlet.class

If you're not sure what this means, post the FULL path to your HTML file, starting with the drive letter of your hard drive.



so i gave as

<html> <body> <form name="input" action="C:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps\Lasto\WEB-INF\classes\Test1.class" method="post"> TITLE: <input type="text" name="title" size="20"> <br> <br> <br> <input type="submit" value="SUBMIT"> </form> </body> </html>


but no results.

Originally posted by Ben Souther:
"coz" isn't a word.


Post the full path to your servlet class file.

Example:
c:\tomcat\webapps\myapp\WEB-INF\classes\com\mypackage\MyServlet.class

If you're not sure what this means, post the FULL path to your HTML file, starting with the drive letter of your hard drive.



so i gave as

<html> <body> <form name="input" action="C:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps\Lasto\WEB-INF\classes\Test1.class" method="post"> TITLE: <input type="text" name="title" size="20"> <br> <br> <br> <input type="submit" value="SUBMIT"> </form> </body> </html>

Originally posted by Ben Souther:
No, that's not what I was asking.
Is your app THE root web application for your container?

Please post the full path to your servlet.

Really i could not get you, but if you clearly show me it will be really greatful, coz i am trying too hard but no good result.

Originally posted by Ben Souther:
Is your app the root webapp inside your container?

If you're not sure what this means, post the FULL path to your HTML file, starting with the drive letter of your hard drive.

Ya my application root is inside the container.