hi 'm aparna...

Am developing a web application with j2ee and sql 2005 Express edition as the back end.. When i connect with the jdbc driver in system DSN and test the connection, the connection turns out to be successful, and when I run the application, the web page is opening, but I'am not able to insert values or retrieve values from the database. C
PLz some one help me out.

This sounds like more of a j2ee problem than an SQL one. If you can run queries with TSQL but not j2ee & the ODBC driver then you're probably posting in the wrong forum.

ya am able to run queries, sorry about posting it wrong, coz am new to this forum. do u know the way to solve the problem??

No i'm not sure. I do .NET development with MSSQL. There is also a Java forum on Daniweb where you could ask:
http://www.daniweb.com/forums/forum9.html

Please do not create a new thread to ask the same question though. A moderator will be along shortly and route your message to the proper forum so hopefully someone can help you :)

OK, post moved to Java section.

Would you mind to post relevant code to we can see what is going on in the application?

i have attached one part of my stateless session bean code..

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package forum;

import com.sun.jmx.trace.Trace;
import javax.ejb.Stateless;
import java.util.*;
import java.sql.*;


/**
 *
 * @author Arthi
 */
@Stateless
public class MembersBean implements MembersLocal {
    private int memberid;
    private String username, password, firstname, lastname, email, regdate, type;

    public int getMemberid() {
        return memberid;
    }

    public void setMemberid(int memberid) {
        this.memberid = memberid;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return username;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getFirstname() {
        return firstname;
    }

    public void setFirstname(String firstname) {
        this.firstname = firstname;
    }

    public String getLastname() {
        return lastname;
    }

    public void setLastname(String lastname) {
        this.lastname = lastname;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getRegdate() {
        return regdate;
    }

    public void setRegdate(String regdate) {
        this.regdate = regdate;
    }

    public String getType() {
        return type;
    }

    public void setType(String type) {
        this.type = type;
    }

    public boolean checkReg(String username) {
        String query = "SELECT member_id FROM Members WHERE [username]='" + username + "'";

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
            Statement stat = con.createStatement();
            ResultSet rst = stat.executeQuery(query);
            System.out.println(con);
            if(rst.next() == false) {
                con.close();
                return true;
            }
            else {
                con.close();
                return false;
            }
        }
        catch(Exception e) {
            e.printStackTrace();
            return false;
        }
    }

    public boolean authenticate() {
        String query = "SELECT * FROM Members";
        String DbUsername = "admin ";
        String DbPassword = "admin";

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
            Statement stat = con.createStatement();
            ResultSet rst = stat.executeQuery(query);
            System.out.println("connec"+con);

            while(rst.next()) {
                //DbUsername = rst.getString("username");
                //DbPassword = rst.getString("password");

                System.out.println ("DBusername"+ rst.getString("username"));
                System.out.println ("DBpassword"+rst.getString("password"));
                System.out.println ("username"+username);
                System.out.println ("password"+password);
                if(username.equals(DbUsername) && password.equals(DbPassword)) {
                    con.close();
                    return true;
                }
            }
            return false;
        }
        catch(Exception e) {
            e.printStackTrace();
            return false;
        }
    }

    public boolean regMember() {
        memberid = (int) (1000 + Math.random()* 1000);
        firstname = "";
        lastname = "";
        email = "";
        regdate = new java.util.Date().toString();
        type = "Member";

        String query = "INSERT INTO Members (member_id, [username], [password], [firstname], [lastname], [email], [regdate], [type]) " +
                        "VALUES (" + memberid + ", " +
                        "'" + username + "', " +
                        "'" + password + "', " +
                        "'" + firstname + "', " +
                        "'" + lastname + "', " +
                        "'" + email + "', " +
                        "'" + regdate + "', " +
                        "'" + type + "')";
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
            Statement stat = con.createStatement();
            stat.execute(query);
            System.out.println(con);
            con.close();
            return true;
        }
        catch(Exception e) {
            e.printStackTrace();
            return false;
        }
    }

    public boolean setMember(String username) {
        String password_upd = "";

        if(password != null) {
            password_upd = "password='" + password + "', ";
        }

        String query = "UPDATE Members SET " + password_upd +
                        "firstname='" + firstname + "', " +
                        "lastname='" + lastname + "', " +
                        "email='" + email + "' WHERE [username]='" + username + "'";

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
            Statement stat = con.createStatement();
            stat.execute(query);
            System.out.println(con);
            con.close();
            return true;
        }
        catch(Exception e) {
            e.printStackTrace();
            return false;
        }
    }

    public boolean setMember(int memberid) {
        String password_upd = "";

        if(password != null) {
            password_upd = "password='" + password + "', ";
        }

        String query = "UPDATE Members SET " + password_upd +
                        "username='" + username + "', " +
                        "firstname='" + firstname + "', " +
                        "lastname='" + lastname + "', " +
                        "email='" + email + "', " +
                        "type='" + type + "' WHERE member_id=" + memberid;

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
            Statement stat = con.createStatement();
            stat.execute(query);
            System.out.println(con);
            con.close();
            return true;
        }
        catch(Exception e) {
            e.printStackTrace();
            return false;
        }
    }

    public boolean getMember(String username) {
        String query = "SELECT * FROM Members WHERE [username]='" + username + "'";

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
            Statement stat = con.createStatement();
            ResultSet rst = stat.executeQuery(query);
System.out.println(con);
            while(rst.next()) {
                memberid = rst.getInt("member_id");
                this.username = rst.getString("username");
                firstname = rst.getString("firstname");
                lastname = rst.getString("lastname");
                email = rst.getString("email");
                regdate = rst.getString("regdate");
                type = rst.getString("type");
            }
            con.close();
            return true;
        }
        catch(Exception e) {
            e.printStackTrace();
            return false;
        }
    }

    public boolean getMember(int memberid) {
        String query = "SELECT * FROM Members WHERE member_id=" + memberid;

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
            Statement stat = con.createStatement();
            ResultSet rst = stat.executeQuery(query);
System.out.println(con);
            while(rst.next()) {
                this.memberid = rst.getInt("member_id");
                username = rst.getString("username");
                firstname = rst.getString("firstname");
                lastname = rst.getString("lastname");
                email = rst.getString("email");
                regdate = rst.getString("regdate");
                type = rst.getString("type");
            }
            con.close();
            return true;
        }
        catch(Exception e) {
            e.printStackTrace();
            return false;
        }
    }

    public int getNumPosts(int memberid) {
        int numMsgs = 0;
        String query = "SELECT thread_id FROM Threads WHERE member_id=" + memberid;

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
            Statement stat = con.createStatement();
            ResultSet rst = stat.executeQuery(query);
System.out.println(con);
            while(rst.next()) {
                numMsgs++;
            }
            con.close();
        }
        catch(Exception e) {
            e.printStackTrace();
        }
        return numMsgs;
    }

    public List getMembers() {
        List members = new LinkedList();
        String query = "SELECT member_id FROM Members ORDER BY member_id";

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
            Statement stat = con.createStatement();
            ResultSet rst = stat.executeQuery(query);
System.out.println(con);
            while(rst.next()) {
                memberid = rst.getInt("member_id");
                members.add(new Integer(memberid));
            }

            con.close();
        }
        catch(Exception e) {
            e.printStackTrace();
        }
        return members;
    }

    public List getMods() {
            List members = new LinkedList();
            String query = "SELECT member_id FROM Members WHERE type='Administrator' OR type='Moderator' ORDER BY member_id";

            try {
                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
                Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
                Statement stat = con.createStatement();
                ResultSet rst = stat.executeQuery(query);
System.out.println(con);
                while(rst.next()) {
                    memberid = rst.getInt("member_id");
                    members.add(new Integer(memberid));
                }

                con.close();
            }
            catch(Exception e) {
                e.printStackTrace();
            }
            return members;
    }

    public boolean delMember(int memberid) {
        String query = "DELETE FROM Members WHERE member_id=" + memberid;

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
            Statement stat = con.createStatement();
            stat.execute(query);
            System.out.println(con);
            con.close();
            return true;
        }
        catch(Exception e) {
            e.printStackTrace();
            return false;
        }
    }

    // Add business logic below. (Right-click in editor and choose
    // "Insert Code > Add Business Method" or "Web Service > Add Operation")

}

Edited 3 Years Ago by Reverend Jim: Fixed formatting

i have attached one part of my stateless session bean code..

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package forum;

import com.sun.jmx.trace.Trace;
import javax.ejb.Stateless;
import java.util.*;
import java.sql.*;


/**
*
* @author Arthi
*/
@Stateless
public class MembersBean implements MembersLocal {
private int memberid;
private String username, password, firstname, lastname, email, regdate, type;

public int getMemberid() {
return memberid;
}

public void setMemberid(int memberid) {
this.memberid = memberid;
}

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

public String getPassword() {
return username;
}

public void setPassword(String password) {
this.password = password;
}

public String getFirstname() {
return firstname;
}

public void setFirstname(String firstname) {
this.firstname = firstname;
}

public String getLastname() {
return lastname;
}

public void setLastname(String lastname) {
this.lastname = lastname;
}

public String getEmail() {
return email;
}

public void setEmail(String email) {
this.email = email;
}

public String getRegdate() {
return regdate;
}

public void setRegdate(String regdate) {
this.regdate = regdate;
}

public String getType() {
return type;
}

public void setType(String type) {
this.type = type;
}

public boolean checkReg(String username) {
String query = "SELECT member_id FROM Members WHERE [username]='" + username + "'";

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
ResultSet rst = stat.executeQuery(query);
System.out.println(con);
if(rst.next() == false) {
con.close();
return true;
}
else {
con.close();
return false;
}
}
catch(Exception e) {
e.printStackTrace();
return false;
}
}

public boolean authenticate() {
String query = "SELECT * FROM Members";
String DbUsername = "admin ";
String DbPassword = "admin";

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
ResultSet rst = stat.executeQuery(query);
System.out.println("connec"+con);

while(rst.next()) {
//DbUsername = rst.getString("username");
//DbPassword = rst.getString("password");

System.out.println ("DBusername"+ rst.getString("username"));
System.out.println ("DBpassword"+rst.getString("password"));
System.out.println ("username"+username);
System.out.println ("password"+password);
if(username.equals(DbUsername) && password.equals(DbPassword)) {
con.close();
return true;
}
}
return false;
}
catch(Exception e) {
e.printStackTrace();
return false;
}
}

public boolean regMember() {
memberid = (int) (1000 + Math.random()* 1000);
firstname = "";
lastname = "";
email = "";
regdate = new java.util.Date().toString();
type = "Member";

String query = "INSERT INTO Members (member_id, [username], [password], [firstname], [lastname], [email], [regdate], [type]) " +
"VALUES (" + memberid + ", " +
"'" + username + "', " +
"'" + password + "', " +
"'" + firstname + "', " +
"'" + lastname + "', " +
"'" + email + "', " +
"'" + regdate + "', " +
"'" + type + "')";
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
stat.execute(query);
System.out.println(con);
con.close();
return true;
}
catch(Exception e) {
e.printStackTrace();
return false;
}
}

public boolean setMember(String username) {
String password_upd = "";

if(password != null) {
password_upd = "password='" + password + "', ";
}

String query = "UPDATE Members SET " + password_upd +
"firstname='" + firstname + "', " +
"lastname='" + lastname + "', " +
"email='" + email + "' WHERE [username]='" + username + "'";

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
stat.execute(query);
System.out.println(con);
con.close();
return true;
}
catch(Exception e) {
e.printStackTrace();
return false;
}
}

public boolean setMember(int memberid) {
String password_upd = "";

if(password != null) {
password_upd = "password='" + password + "', ";
}

String query = "UPDATE Members SET " + password_upd +
"username='" + username + "', " +
"firstname='" + firstname + "', " +
"lastname='" + lastname + "', " +
"email='" + email + "', " +
"type='" + type + "' WHERE member_id=" + memberid;

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
stat.execute(query);
System.out.println(con);
con.close();
return true;
}
catch(Exception e) {
e.printStackTrace();
return false;
}
}

public boolean getMember(String username) {
String query = "SELECT * FROM Members WHERE [username]='" + username + "'";

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
ResultSet rst = stat.executeQuery(query);
System.out.println(con);
while(rst.next()) {
memberid = rst.getInt("member_id");
this.username = rst.getString("username");
firstname = rst.getString("firstname");
lastname = rst.getString("lastname");
email = rst.getString("email");
regdate = rst.getString("regdate");
type = rst.getString("type");
}
con.close();
return true;
}
catch(Exception e) {
e.printStackTrace();
return false;
}
}

public boolean getMember(int memberid) {
String query = "SELECT * FROM Members WHERE member_id=" + memberid;

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
ResultSet rst = stat.executeQuery(query);
System.out.println(con);
while(rst.next()) {
this.memberid = rst.getInt("member_id");
username = rst.getString("username");
firstname = rst.getString("firstname");
lastname = rst.getString("lastname");
email = rst.getString("email");
regdate = rst.getString("regdate");
type = rst.getString("type");
}
con.close();
return true;
}
catch(Exception e) {
e.printStackTrace();
return false;
}
}

public int getNumPosts(int memberid) {
int numMsgs = 0;
String query = "SELECT thread_id FROM Threads WHERE member_id=" + memberid;

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
ResultSet rst = stat.executeQuery(query);
System.out.println(con);
while(rst.next()) {
numMsgs++;
}
con.close();
}
catch(Exception e) {
e.printStackTrace();
}
return numMsgs;
}

public List getMembers() {
List members = new LinkedList();
String query = "SELECT member_id FROM Members ORDER BY member_id";

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
ResultSet rst = stat.executeQuery(query);
System.out.println(con);
while(rst.next()) {
memberid = rst.getInt("member_id");
members.add(new Integer(memberid));
}

con.close();
}
catch(Exception e) {
e.printStackTrace();
}
return members;
}

public List getMods() {
List members = new LinkedList();
String query = "SELECT member_id FROM Members WHERE type='Administrator' OR type='Moderator' ORDER BY member_id";

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
ResultSet rst = stat.executeQuery(query);
System.out.println(con);
while(rst.next()) {
memberid = rst.getInt("member_id");
members.add(new Integer(memberid));
}

con.close();
}
catch(Exception e) {
e.printStackTrace();
}
return members;
}

public boolean delMember(int memberid) {
String query = "DELETE FROM Members WHERE member_id=" + memberid;

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1269;DatabaseName=Forum");
Statement stat = con.createStatement();
stat.execute(query);
System.out.println(con);
con.close();
return true;
}
catch(Exception e) {
e.printStackTrace();
return false;
}
}

// Add business logic below. (Right-click in editor and choose
// "Insert Code > Add Business Method" or "Web Service > Add Operation")

}
This article has been dead for over six months. Start a new discussion instead.