This content has been marked as final.
Show 2 replies
-
1. Re: Table not found sql exception while executing servlet i
sasoj Mar 30, 2005 7:28 AM (in response to shanker)The names of the objects in the database are case sensitive.
If you specify quotes arround the names, then the case is preserved, otherwise the names are converted to uppercase.
Example:
this two statements will create two different tables, "test" and "TEST" respectively
create table "test" (x int)
create table test (x int)
To solve your problem, enclose the name of the table in your select statement in quotes:
statement.executeUpdate("INSERT INTO \"Employee\" values(" + values + ");"); -
2. Re: Table not found sql exception while executing servlet i
shanker Mar 30, 2005 9:20 AM (in response to shanker)Thankyou very much. I will try. thanks again.