• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Table doesn't exist! but it exist!

 
Mouza Ali
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I hope this time I get some answers for this very ambiguise point about "Network Derby Server". I have created the Database through the command line, and created a table named 'CLIENTINFOR' in that database. However, when my java code tries to connect to this table is throws and SQLException saying that: table/view 'CLIENTINFOR' doesn't exist!

How it says that it doesn't exist? I searched for a veeeery long time on the Internet about this, and most of the topics posted that it is a case sensetivity level, but in my case it is not.

I have a user name and a passowrd associated with my database.


So, please can anyone help me with this?!?!
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you connecting to the same schema with both applications (yours and the command line app)?
 
Mouza Ali
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Paul,

Thanks for your response. It is really strange. Each time I face a problem and post it here, directly after few minutes I know its answer. Even though I spent months trying to solve it.

For example, for this problem, I was trying to solve it for a month and a half, and since there is not much documentation for the "Network Server", I couldn't figure out the solution. However, I've just figured the solution for the problem

For my problem, I shouldn't associate a user name and password for the database that has been created from the command line in the java code. I simply deleted the Properties from the java code and it worked.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic