First of all go to your default.properties file in your config folder under your j2sdkee1.2.1 and put the statement in rem where
you are connecting with the cloudscape , i.e
and then instead of this write the following statement
now save this file an start your j2ee server again.
Note : ejbdsn can be any userdsn name in which you are creating the database in which u are making the tables u want to connect to the bean.
While deploying your example inthe codede refrence name give jdbc/databasename and the jndi name as jdbc/sql and the other jndi name give it what you are giving in your lookup call in the client.
if you are not able to get through it. mail me back again , i'll send you the small coded example as an attachment. send me your personal mail id as sending attachment is not possible here.
Hope it works for you. if u have any further problems mail me at nidhimadan14 yahoo.com