aspose file tools*
The moose likes JDBC and the fly likes problem connecting to Cloudscape database in WSAD Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem connecting to Cloudscape database in WSAD" Watch "problem connecting to Cloudscape database in WSAD" New topic
Author

problem connecting to Cloudscape database in WSAD

Niranjan Deshpande
Ranch Hand

Joined: Oct 16, 2005
Posts: 1277
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 ?


SCJP 1.4 - 95% [ My Story ] - SCWCD 1.4 - 91% [ My Story ]
Performance is a compulsion, not a option, if my existence is to be justified.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18114
    
    8

This is a database question, let's try the JDBC forum.
Kevin Mukhar
Ranch Hand

Joined: Nov 28, 2000
Posts: 83
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

Joined: Oct 16, 2005
Posts: 1277
will try this one//
thanks
Niranjan Deshpande
Ranch Hand

Joined: Oct 16, 2005
Posts: 1277
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

Joined: Oct 16, 2005
Posts: 1277
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

Joined: Oct 16, 2005
Posts: 1277
the problem persists..
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem connecting to Cloudscape database in WSAD
 
Similar Threads
Cloudscape 5.1
WSAD5.1 and Oracle9i
Create databases, tables in Cloudscape
WSAD 5.1 and Cloudscape 5.1
Creating Cloudscape database and data sources in Web Sphere