aspose file tools*
The moose likes JDBC and the fly likes java.sql.SQLException: Io exception: The Network Adapter could not establish the connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: Io exception: The Network Adapter could not establish the connection " Watch "java.sql.SQLException: Io exception: The Network Adapter could not establish the connection " New topic
Author

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

dattathreya bonakurthi
Greenhorn

Joined: Sep 17, 2008
Posts: 20
Hi,

I have written an simple jsp code to connect to the database and retrive some records.

In the first stage, it is giving me below error message.

" java.sql.SQLException: Io exception: The Network Adapter could not establish the connection "

I m running it on the eclipse.

Jsp code file :

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

try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin://10.26.71.17:1521/preclrty","cprg","c10");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from service_types");
%>
<% if(rs.next())
{
rs.previous();
%>
<table width="830" border="1" align="center" bordercolor="#000000">
<tr>
<td width="63" align="center"><span class="style25">Your Account Balance: <b>Rs.</b></span></td>
<%

while(rs.next())
{
%>
<td width="63" align="center"><span class="style25"><%=rs.getString(2)%></span></td>
</tr>



<%
}

}
else
{
%>

<%
}

}catch(Exception e)
{
out.println("the error is "+e);
}
%>

Note : I have removed the html tags from the file.

Can someone help help.
I m trying to learn basic programming using the JSPs, to build an front for my daily activities.

I think I have missed out some configurations.

Please help me thank you in advance.













dattathreya
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61239
    
  66

If you are just starting to use JSP then you need to know that you are doing it wrong. Putting Java code into a JSP is a practice that has been obsolete and discredited for 12 years now. 12 years!

You should be putting such code in Java classes and not in the JSPs.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
dattathreya bonakurthi
Greenhorn

Joined: Sep 17, 2008
Posts: 20
Hi Bear,
I know that I m not following any architecture but I want to know the reason beyond the error displayed.
If I can resolve this one, I would be going to do it in an MVC.

In my first step, I m facing the problem.
What could be the reason for it.

If any jar files are missed by me ?

Thanks,
Pras Tiwari
Ranch Hand

Joined: Nov 07, 2005
Posts: 186
Hi,

Can you try with -



Also check for IP address of Db service its mapping present in /etc/hosts file (On Windows machine eg. - C:/Program Files/System32/Drivers/etc/hosts)

--Pras


********Deserve Before You Desire********
dattathreya bonakurthi
Greenhorn

Joined: Sep 17, 2008
Posts: 20
Thank u.
its working.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection