Java SQL Update statement

Question

I'm trying to execute the following method

String sqlQuery = "UPDATE ACCOUNTS"
                    + " SET LAST_LOGIN_DATE=LOGIN_DATE,"
                    + " LOGIN_DATE=SYSTIMESTAMP" 
                    + " WHERE CUSTOMER_ID=? AND USER_ID=?";

        logger.debug("[{}] sqlQuery={}", methodName, sqlQuery);

        String connectionName = properties.getProperty(JNDI_NAME);
        Connection connection = null;
        PreparedStatement pstmt = null;

            connection = getJNDIConnection(connectionName);
            pstmt = connection.prepareStatement(sqlQuery);
             // set the input parameters
            pstmt.setString(1, customerId);
            pstmt.setString(2, userId);

                        if (pstmt.executeUpdate() > 0)

When I get to the last line it gives me false and the query is not executed. Please, help

Maybe there is no such Account with that customerID and userID — mvieghofer, Nov 26 '13 at 11:17
I tried the query in SQL console - it works fine, I get the needded user. — Slava Chirița, Nov 26 '13 at 11:24
If you put a SELECT in your code with the same ``CUSTOMER_ID=?`` and ``USER_ID=?`` parameters, and run pstmt.executeQuery() do you get a result? — brettw, Nov 26 '13 at 11:45
brettw, I changed as you said and also added pstmt.executeQuery().next() which returned 'false'. — Slava Chirița, Nov 26 '13 at 12:05

score 0 · Accepted Answer · edited May 23 '17 at 12:12

0

I'm not that familiar with Oracle, but are you sure the JNDI connection is connecting to the same tablespace/database/schema as your SQL console? This answer makes me think maybe you are somehow not connecting to what you think you are.

edited May 23 '17 at 12:12

Community

1
1

answered Nov 26 '13 at 14:01

brettw

10,664
2
42
59

Indeed it was a connection trouble. Thank's a lot, everybody – Slava Chirița Nov 26 '13 at 14:14

score -1 · Answer 2 · answered Nov 26 '13 at 11:18

-1

Try appending table after update like update table ACCOUNTS

answered Nov 26 '13 at 11:18

shreyansh jogi

2,082
12
20

score -1 · Answer 3 · answered Nov 26 '13 at 12:19

-1

From the documentation:

Returns: either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing.

The update statement returns nothing, so the executeUpdate will return 0.

answered Nov 26 '13 at 12:19

Alexei

1,028
1
11
17

Java SQL Update statement

3 Answers3