This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem connecting to Cloudscape database in WSAD

 
Niranjan Deshpande
Ranch Hand
Posts: 1277
  • 0
  • 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 ?
 
Paul Clapham
Sheriff
Pie
Posts: 20185
26
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is a database question, let's try the JDBC forum.
 
Kevin Mukhar
Ranch Hand
Posts: 83
  • 0
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
will try this one//
thanks
 
Niranjan Deshpande
Ranch Hand
Posts: 1277
  • 0
  • 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
  • 0
  • 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
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the problem persists..
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic