java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

Question

I have all table names in a drop down list in a java application. I want display the number of records in a table on JLabel. but I'm getting the following error

java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

I have tried this:

try {
        String tableName = LoginFrame.userName + "." +    this.ddlTableName.getSelectedItem().toString();
        JOptionPane.showMessageDialog(null, tableName);
        pst = (OraclePreparedStatement) con.prepareStatement("select count(*) as num from '" + tableName + "'");
        rs = pst.executeQuery();
        while (rs.next()) {
            this.lblRecordStat.setText(rs.getString("num"));
        }
    } catch (SQLException ex) {
        JOptionPane.showMessageDialog(null, ex);
        System.out.println(ex);
    }

console print table name and check if it exists.

Naruto
– Naruto

2016-04-10 07:20:42 +00:00
Commented Apr 10, 2016 at 7:20 — Naruto
– Naruto, Commented Apr 10, 2016 at 7:20

Mureinik · Accepted Answer · 2016-04-10 07:21:57Z

5

In Oracle, quotes ('s) are used to denote string literals. Object names (such as tables) should not be surrounded by them. Lose the quotes and you should be OK:

pst = (OraclePreparedStatement) con.prepareStatement
          ("select count(*) as num from " + tableName);

answered Apr 10, 2016 at 7:21

Mureinik

316k54 gold badges400 silver badges405 bronze badges

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

Comments

Mitiku · Accepted Answer · 2019-05-09 14:13:29Z

2

You are passing string as table name. Table names in Oracle can be either inside `` qoutes or without any quotes.

pst = (OraclePreparedStatement) con.prepareStatement("select count(*) as num from " + tableName );

or

pst = (OraclePreparedStatement) con.prepareStatement("select count(*) as num from `" + tableName + "`");

edited May 9, 2019 at 14:13

answered Apr 10, 2016 at 7:24

Mitiku

5,4223 gold badges21 silver badges39 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related