netbeans

[Nishanthi]

right now i m working in netbeansIDE with web application i m trying to connect to sql server 2005 database using the preceding coding


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:data");
Statement st=con.createStatement();
st.executeUpdate("insert into audio values(11)");
con.close();
st.close();


now no data are inserted int the audio table what is the solution for this.Its windows authentication i m using in Sql server 2005 pls help me to solve this

[r035198x]

Did you get an exception? What was the return value of the executeUpdate method?

[Nishanthi]

in the sqlserver 2005 the record was not inserted

[r035198x]

You did not answer any of the questions I posted above.

[Nishanthi]

thr was no return type... the record didnt insert into database.... i didnt get any exception..........

[dswastik]

Is there any issue with the connection better to say is the connection successful, or its not just inserting the record?

[marcellis]

Try to insert the record on database level, maybe you get more information about the error

[Tolls]

Post your proper code, including the try/catch block surrounding it.
Whatever is wrong is probably in code you're not showing us.

[Nishanthi]

import java.io.*;
import java.net.*;

import javax.servlet.*;
import javax.servlet.http.*;

/**
*
* @author Owner
* @version
*/
public class NewServlet extends HttpServlet {

/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:data");
Statement st=con.createStatement();
st.executeUpdate("insert into audio values(11)");
con.close();
st.close();
}
catch(Exception e)
{
}
}

[masijade]

No wonder you're "not getting any exception".

catch(Exception e)
{
}

Don't do that, ever.

Add e.printStackTrace() (at a minimum) to that catch block. How are you ever going to know what is going wrong when you are ignoring the errors?

[Tolls]

That's what I thought...
Do as masijade suggests, and find out what exception is being thrown.

[atom86]

Masi has a point.....and if you want my opinion, i suggest you to catch an SQLException instead than a general Exception.... an Exception could be EVERYTHING... nullPointer... IndexOutOfBound...... Heap Memory Error... FileNotFound... BadFileDescriptor... and more.........[...]

So in this case it's better if you catch an SQLException because connecting to a DB and executing a query is the most important operation you do in this part of your code.. and probably (probably not sure) one of this 2 instruction can throw an SQLException.. in this situation