Java program will read from database, but not write to it

Question

I have a Java program that successfully connects to a mysql database that is hosted on godaddy's server. I can read from that db with out issue, however, when I try to write to it with INSERT or UPDATE for example, the query does not execute. I am using the 'admin' account that I set up through godaddy, I realize this is not the root account. I have checked and verified that the connection is not read only, and have logged out of phpmyadmin while the query ran. I'm not sure what else I can try or if anyone has experienced this issue.

Maybe a setting to the connection I have failed to set? Or maybe its not possible since the db is hosted on godaddy's servers?

Any help is great!

Thanks.

Here is some relevant code:
Connection to db:

Connection con;
public DBconnection(String url, String user, String pass)
{
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            con = DriverManager.getConnection (url,user,pass);


            if(!con.isClosed())
                System.out.println("connecton open");
        } 
        catch (InstantiationException e) {e.printStackTrace();} 
        catch (IllegalAccessException e) {e.printStackTrace();} 
        catch (ClassNotFoundException e) {e.printStackTrace();} 
        catch (SQLException e) {e.printStackTrace();}
}

Send Query:

public ResultSet executeQuery(String query)
{
    ResultSet rs = null;

    try {
        Statement stmt = (Statement) con.createStatement();
        rs = stmt.executeQuery(query);

        //while(rs.next())
            //System.out.println(rs.getString("ticket_num"));
    } 
    catch (SQLException e) {}   

    return rs;
}

Insert Query (works in phpmyadmin):

conn.executeQuery("INSERT INTO tickets VALUES(55555,'12/01/2012','me','reports','test','','','0','Nope')");

For INSERT statements you have to use executeUpdate, not executeQuery — Ian Roberts
– Ian Roberts, Commented Dec 5, 2012 at 17:01
I suggest printing out your exception when you do a query. At the moment, you just let it fall through, so that won't tell you what is happening. Come back with a stack trace and we can have a look. — knownasilya
– knownasilya, Commented Dec 5, 2012 at 17:03
Always insist upon using parameterized SQL to mitigate SQL injection attacks (whatever technology you're using). — Lion
– Lion, Commented Dec 5, 2012 at 17:12

PermGenError · Accepted Answer · 2012-12-05 17:08:17Z

3

Use, statement.executeUpdate() to do an INSERT query.

FROM API of Statement.executeUpdate(String sql):

Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.

 executeUpdate("INSERT INTO tickets VALUES(55555,'12/01/2012','me','reports','test','','','0','Nope')");

And i strongly advice you to use PreparedStatemnt rather than simple Statement to perform SQL using JDBC.

edited Dec 5, 2012 at 17:08

answered Dec 5, 2012 at 16:59

PermGenError

46.5k8 gold badges90 silver badges107 bronze badges

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

1 Comment

Chris K Over a year ago

Thanks for the help! It works now and I'm in the process of studying/switching to prepared statements. Thanks again.

Sashi Kant · Accepted Answer · 2012-12-05 17:01:10Z

0

The Username and password with which you are instantiating the connection object, only has the permission to read from the database not write. You need to change the credentials for connecting to the database, or you need to provide the permission to the concerned user

answered Dec 5, 2012 at 17:01

Sashi Kant

13.5k9 gold badges50 silver badges71 bronze badges

Collectives™ on Stack Overflow

Java program will read from database, but not write to it

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related