inserting data into database using jdbc

Question

I have a java Desktop application. I am trying to insert data from two text field in to Database. But getting some runtime error. Help me to resolve it.

Here is my code snippet

final String s1 = t1.getText();
final String s2 = t2.getText();
jb.addActionListener(new ActionListener() {

    public void actionPerformed(ActionEvent e) {
        String host = "jdbc:derby://localhost:1527/Details";
        String uName = "rajil";
        String uPass = "rajil";
        try {
            Connection con = DriverManager.getConnection(host, uName,uPass);
            Statement st = con.createStatement();
            String q1 = "insert into name (name,id) values('" + s1 + "','" + s2 + "')";
            st.executeQuery(q1);
        } catch (SQLException ex) {
            Logger.getLogger(DBConnect.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
});

java.sql.SQLException: executeQuery method can not be used for update. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.Statement.executeQuery(Unknown Source) — RAJIL KV
– RAJIL KV, Commented Dec 25, 2013 at 10:03
Don't put stack traces in comments. Instead, edit the question.. — Andrew Thompson
– Andrew Thompson, Commented Dec 25, 2013 at 10:17

AJ. · Accepted Answer · 2013-12-25 10:19:36Z

3

change st.executeQuery(q1); to st.executeUpdate(q1);

load drivers first

Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();

edited Dec 25, 2013 at 10:19

answered Dec 25, 2013 at 10:03

AJ.

4,5355 gold badges32 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

RAJIL KV Over a year ago

okay .But after getting another error java.sql.SQLSyntaxErrorException: Table/View 'DTS' does not exist. at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.Statement.executeUpdate(Unknown Source)

Deepak Over a year ago

@user3007882 Why are you toggling the Accepted answer ?

AJ. Over a year ago

@user3007882 Its your choice.

Deepak · Accepted Answer · 2013-12-25 10:15:39Z

1

You have to use below statement also for loading the Drivers classes

Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();

For eg mysql

Class.forName("com.mysql.jdbc.Driver");

See the below link for detail

http://www.vogella.com/articles/ApacheDerby/article.html

edited Dec 25, 2013 at 10:15

answered Dec 25, 2013 at 10:10

Deepak

2,9252 gold badges26 silver badges32 bronze badges

Collectives™ on Stack Overflow

inserting data into database using jdbc

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related