aspose file tools*
The moose likes Websphere and the fly likes WSAD 5.1 and Cloudscape 5.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "WSAD 5.1 and Cloudscape 5.1" Watch "WSAD 5.1 and Cloudscape 5.1" New topic
Author

WSAD 5.1 and Cloudscape 5.1

Michael James Payne
Greenhorn

Joined: Jan 29, 2004
Posts: 9
I am trying to connect to a Cloudscape 5.1 database in WSAD 5.1.

After I add databast to project, I get at error stating that the database is not a Cloudscape 5.1 database.

Any help would be appreciated.

Thanks,
Mike


Michael J. Payne
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3879
Hi -- this configuration does work -- I just did an example of it last week. Could you post both the exact error message you're receiving and the exact series of steps you're carrying out that leads to the message?

Kyle


Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
Michael James Payne
Greenhorn

Joined: Jan 29, 2004
Posts: 9
Here are the steps I followed:

1) I created the database in Cloudscape 5.1 and can use Cloudscape to access it and read the data find.

2) In my WSAD project, I created a database definition as follows:

Database Name: BooksDB
Database Vendortype: Cloudscape 5.1

3) I then attempted to create a new database connection as follows:

Connection Name: Con1
Database Name: BooksDB
User ID and password: Empty because the database doesn't have any
Database Vendortype: Cloudscape 5.1
JDBC Driver: Cloudscape Embedded JDBC Driver
Database Location: C:\Cloudscape_5.1\frameworks\embedded\bin\BooksDB
JDBC Driver Class: com.ibm.db2j.jdbc.DB2jDriver
Class Location: C:\Cloudscape_5.1\lib\db2jtools.jar;
C:\Cloudscape_5.1\lib\license.jar;
C:\Cloudscape_5.1\lib\db2j.jar
Connection URL:
jdbc b2j:C:\Cloudscape_5.1\frameworkds\embedded\bin\BooksDB

Then when I click the finish button, I get the following message in WSAD 5.1:

IWAS0126E Problems encountered while trying to establish connection Con1 trying to connect to Con1
Reason: 'IWAS0223E The server at
'jdbc b2j:C:\Cloudscape_5.1\frameworkds\embedded\bin\BooksDB' is not a
'Cloudscape, V5.1' database. Ensure the database vendor type currently
specified for the connection matches the version installed on the server
and try again.'

Thanks for all your help.
Mike Payne
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: WSAD 5.1 and Cloudscape 5.1
 
Similar Threads
Cloudscape 5.1
Displaying Stored Procedures in Data Perspective in WSAD
websphere test environment 5.1 and WSAD 5.1.0
View table data using WSAD
JSP 2.0 and WSAD 5.0