How Connect MS-SQL in java

[kanmbk]

Hi

I write a simple program to connect MS-SQL in java. But it not work fine.

So i want the exact code to connect MS-SQL with java.


Thanks
Bharathi..

[madhoriya22]

Hi

I write a simple program to connect MS-SQL in java. But it not work fine.

So i want the exact code to connect MS-SQL with java.


Thanks
Bharathi..

Hi,
Plz send the code whatever u hav written

Thanks and regards,
madhoriya

[r035198x]

Hi

I write a simple program to connect MS-SQL in java. But it not work fine.

So i want the exact code to connect MS-SQL with java.


Thanks
Bharathi..

What error messages do you get?

[kanmbk]

Hi madhoriya,

This is the code that i have written,

 <%@page language="java"%>
<%@page import="java.io.*"%>
<%@page import="java.lang.*"%>
<%@page import="java.util.*"%>
<%@page import="java.sql.*"%>
<%
String recid="HDR";
String subid="S002";
String file_id="X234";
String trandate="2007/02/14";
String prod="PROD";
String filler="Yes";
 
    try
     {
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        Connection C = DriverManager.getConnection("jdbc:microsoft:sqlserver://PEOPLET3:1433;DatabaseName=fox;SelectMethod=Cursor");
        Statement st = C.createStatement();
        st.executeUpdate("INSERT INTO `PDE_HDR_TBL` (`record_id` , `submitter_id` , `file_id` , `transaction_date` , `prod_cert_test_indicator` , `filler` )VALUES('"+ recid +"' , '"+ subid +"' , '"+ file_id +"' , '"+ trandate +"' , '"+ prod +"' , '"+ filler +"')");
        out.println("inserted");
     }
    catch(Exception e)
    {
    out.println("Exception is :"+e);
    }
%>

Thanks and regards,
Bharathi

[sicarie]

What's the error/problem you are having?

You are not passing it login credentials (unless you're passing it some really funky login/pw), is your db set up to allow this?

[madhoriya22]

Hi madhoriya,

This is the code that i have written,

 <%@page language="java"%>
<%@page import="java.io.*"%>
<%@page import="java.lang.*"%>
<%@page import="java.util.*"%>
<%@page import="java.sql.*"%>
<%
String recid="HDR";
String subid="S002";
String file_id="X234";
String trandate="2007/02/14";
String prod="PROD";
String filler="Yes";
 
    try
     {
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        Connection C = DriverManager.getConnection("jdbc:microsoft:sqlserver://PEOPLET3:1433;DatabaseName=fox;SelectMethod=Cursor");
        Statement st = C.createStatement();
        st.executeUpdate("INSERT INTO `PDE_HDR_TBL` (`record_id` , `submitter_id` , `file_id` , `transaction_date` , `prod_cert_test_indicator` , `filler` )VALUES('"+ recid +"' , '"+ subid +"' , '"+ file_id +"' , '"+ trandate +"' , '"+ prod +"' , '"+ filler +"')");
        out.println("inserted");
     }
    catch(Exception e)
    {
    out.println("Exception is :"+e);
    }
%>

Thanks and regards,
Bharathi

Hi,
What errors u r getting? I hope there vil be lot of error?

Thanks and regards,
madhoriya

[kanmbk]

Hi madhoriya,

Actually i got the following error

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Plz help me..


Thanks..
Bharathi.

[praveen2gupta]

Hi

Your are missing driver of sql-server. Go to WEB-INF Then classes folder. now copy and paste sql server driver here.
Code is correct.

[madhoriya22]

Hi madhoriya,

Actually i got the following error

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Plz help me..


Thanks..
Bharathi.

Hi,
Here is the right syntax for getConnection method :----

Connection conn = DriverManager.getConnection("URL","UserName","Password");
 

Make sure u r providing these data correctly. Here URL is the location where ur database server is residing, and rest two variables u can understand.
The error which u r getting is due to wrong socket u r providing, so check it again.

thanks and regards,
madhoriya