Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

Table doesn't exist! but it exist!

 
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?!?!
 
Bartender
Posts: 10336
Hibernate Eclipse IDE 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.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic