Queries in Derby Embedded Database

Question

I tried this query

String sql1="select * from custinf";
        try {
            stmt=conn.createStatement();
            stmt.execute(sql1);
            stmt.close();
        } catch (SQLException ex) {
            Logger.getLogger(Database.class.getName()).log(Level.SEVERE, null, ex);
        }

It throws

java.sql.SQLSyntaxErrorException: Table/View 'CUSTINF' does not exist.
    at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
    at org.apache.derby.client.am.ClientStatement.execute(Unknown Source)
    at com.atuts.cms.database.Database.addCustomer(Database.java:57)
    at com.atuts.cms.database.Database.main(Database.java:31)
Caused by: ERROR 42X05: Table/View 'CUSTINF' does not exist.
    at org.apache.derby.client.am.ClientStatement.completeSqlca(Unknown Source)
    at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
    at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
    at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
    at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
    at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
    at org.apache.derby.client.am.ClientStatement.readPrepareDescribeOutput(Unknown Source)
    at org.apache.derby.client.am.ClientStatement.flowExecute(Unknown Source)
    at org.apache.derby.client.am.ClientStatement.executeX(Unknown Source)
    ... 3 more

When i change the query to String sql1="select * from \"custinf\""; It's working. I haven't faced this problem while using mysql db. can anybody explain it?

exist other wise second query won't work "select * from \"custinf\"" — Bruce
– Bruce, Commented Jun 6, 2015 at 4:56

Community · Accepted Answer · 2017-05-23 11:43:57Z

1

To quote from an answer to a different question:

select * from table3
will be automatically processed by the database as if it was
select * from TABLE3
while
select * from "table3"
will successfully match the table you created as create table "table3"

So if your table was created as custinf you must use "custinf". Using custinf without quotes will convert your query to use the table name CUSTINF which probably does not exist.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Jun 6, 2015 at 5:16

user1907906

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

Comments

Rajesh · Accepted Answer · 2015-06-06 05:18:22Z

0

Derby table names are case sensitive. It may be "Custinf" or "custinf".

You may drop custinf table and recreate with proper case.

edited Jun 6, 2015 at 5:18

answered Jun 6, 2015 at 5:08

Rajesh

2,1551 gold badge14 silver badges14 bronze badges

Collectives™ on Stack Overflow

Queries in Derby Embedded Database

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related