Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Pinned topic trouble of connecting cloudscape data base sample from RSA class
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I have trouble of follow through the example from a RSA class. It came with a readonly cloudscape data base. RSA won't connect to it since it is a readonly one. How do I correct this problem? I tried to use cloudscape 10.1 to create a new database and restoreFrom the readonly database in "ij" tool. I was able to get the database into a derby database. But the RSA was looking for a db2j type. I tried to create a db2j data base, got error that it can not find the db2j service protocol. Does any one know how to get around this problem? Or if anyone has fixed this problem and have a good CloudscapePayroll database?
Updated on 2012-07-30T11:08:24Z at 2012-07-30T11:08:24Z by DarwinSubil
Re: trouble of connecting cloudscape data base sample from RSA class2006-02-08T17:02:26ZThis is the accepted answer. This is the accepted answer.Hi Ghkong -
There are at least two things happening. First the one that has a clear solution: As I think you suspect the error "can not find the db2j service protocol" happens when you attempt to access a Cloudscape database (classname identifier is 'com.ibm.db2j...') using Derby (classname identifier is 'org.apache.derby...'). The two are different products and the Cloudscape database needs to be migrated to derby if you truely want to use it with derby. The IBM Cloudscape Info center has a link to the Migration document and a tool to assist with the migration. See: http://publib.boulder.ibm.com/infocenter/cscv/v10r1/index.jsp
Follow the 'Migration' link in the 'Getting Started' section.
Second the one where I need to make some guesses:
You should be able to connect to a read-only DB2J database using a db2j.jar assuming it was created to be read-only (for more info see: http://publibfi.boulder.ibm.com/epubs/html/cloud51/doc/html/coredocs/deploy3.htm#807550). Note that the TMP dir and logFile need to be directed to writable locations as shown on the referenced page above.
If this does not resolve your problem I will need some additional information. I am not familiar with the RSA class database, is it supposed to be readonly? Have you checked permissions on the database files and directories to insure you can write to them? I will need to know what error / message you get when you attempt to connect in order to advise you furhter on this problem.
Re: trouble of connecting cloudscape data base sample from RSA class2006-02-08T22:43:52ZThis is the accepted answer. This is the accepted answer.I got this cloudscapepayroll.zip file, I unziped, it created a CloudscapePayroll directory with the log and seg0 subdirectories and a service.property file.
I tried to connect it from RSA, got the error "IWAS0126E error - Container was opened in read only mode" so it would not establish a connection. --- This might be a bug in RSA. I'm having trouble of getting around this problem.
I looked at the migration website, not sure if that would get me around the problem.
I looked at the read only website, try to set the location to "jar:(c:\cloudscapepayroll.zip)\CloudscapePayroll" in the Connection URL details, of the database location in the RSA tool, I got an error the "jar:(c:\cloudscapepayroll.zip)\CloudscapePayroll" not found.
Any idea on how to set it right in RSA?
Is there an easier way to use ij to fix the problem if I can't get around the problem in RSA?
Re: trouble of connecting cloudscape data base sample from RSA class2006-02-09T19:32:13ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
Yes, you should be able to access the database from IJ assuming it is not corrupted and you have the information required to establish a connection. Cloudscape can be packaged with a number of other technologies and configured in various ways that change how you establish a connection. The RSA database does not appear to be a default implementation (e.g. your last post indicates the database is in a zipfile a read-only configuration). The install guide for the application (the RSA tool?) should provide the information necessary to get the application working. Can the people who created the RSA tool assist you? For me to help you furhter I would need to see the install guide or have details on the RSA implementation. Is this class or the RSA tool available online where I could download it and take a look at it?
Re: trouble of connecting cloudscape data base sample from RSA class2006-07-01T05:23:36ZThis is the accepted answer. This is the accepted answer.I had this same problem and searched high and low for a solution. I finally got it to work by doing the following. I created a new cloudscape database, called CloudscapeDavid. I did this by specifying the new name in the wizard and checking the 'Create a New Database'. This created a new cloudscape database and created a new connection to it. I then disconnected this connection.
I then went into the CloudscapeDavid/seg0 directory and deleted all of the files. I then went back into the CloudscapePayroll/seg0 directory, copied all of these files and then pasted them into the CloudscapeDavid/seg0 directory.
I then reconnected to the CloudscapeDavid database and all of the exisitng tables showed up for me. You can also disconnect from the CloudscapeDavid database, delete the old CloudscapePayroll directory (database), change the name of CloudscapeDavid to CloudscapePayroll, change the connection information and then reconnect to the CloudscapePayroll database.
Not sure what the difference is, but it did work.
Re: trouble of connecting cloudscape data base sample from RSA class2006-07-05T22:17:13ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
It is safest to move or copy the entire Cloudscape database folder. There can be depedancies between the files in the seg0 and the log folders. Copying and renaming the entire database folder tree should not present any problems.
sanjay_dasgupta 12000051F21 Post
Re: trouble of connecting cloudscape data base sample from RSA class2007-11-25T02:23:29ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK