This week's book giveaway is in the HTML Pages with CSS and JavaScript forum.
We're giving away four copies of Testing JavaScript Applications and have Lucas da Costa on-line!
See this thread for details.
Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript 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
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

problem connecting to Cloudscape database in WSAD

 
Ranch Hand
Posts: 1277
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

I am trying to connect to a Cloudscape database. I am getting a connection, but i am getting a error "Table VENDOR does not exist

do we have some client that will help me peep into the database files to see whether some tables actually exist ?
 
Marshal
Posts: 25682
69
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is a database question, let's try the JDBC forum.
 
Ranch Hand
Posts: 83
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It probably depends on which Cloudscape version you are running. Here is one possible tool: http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/Tools4.html#64964


The Cloudscape product includes a text-based, interactive tool called ij. (This tool is not supported by Sun Microsystems, Inc.) You can run the ij tool by typing this command:

 
Niranjan Deshpande
Ranch Hand
Posts: 1277
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
will try this one//
thanks
 
Niranjan Deshpande
Ranch Hand
Posts: 1277
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Man...thanks a lot...

I did start the cloudscape serve and did run the command that you told me..and i was able to see the table coloumns at least...

now i need to connect to the databse in similar way using WSAD...

will get back to you if needed...
 
Niranjan Deshpande
Ranch Hand
Posts: 1277
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i tried the tool man..
i did get to see that the tables exist in the database... but when i tried quering -

select * from vendor where username = 'SMITH'

i got '0 rows returned'

the databse directory that i am investigating is from a CD that came with a book..and the book says that all tha tables have data for a user by name smith..

again the problem persists...my IDE still says 'table does not exist'
 
Niranjan Deshpande
Ranch Hand
Posts: 1277
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the problem persists..
 
Don't get me started about those stupid light bulbs.
    Bookmark Topic Watch Topic
  • New Topic