How do I make Cloudscape Connection Factories?

To make a Cloudscape ConnectionFactory, we need the following jars:

• cloudscape.jar
• cloudutil.jar
• RmiJdbc.jar

These three jars are located at server\lib\tp directory and are set in the classpath in the set.bat.

To view the power of the ext directory, remove the three jars from the server\lib\tp directory and perform the following steps:

1. Log in to the resource shell and create the JDBC Connection Factory in the interactive mode by giving add_jdbc_cf

2. Provide the following details:

   Table 1: Properties for Cloudscape ConnectionFactory

   Property	Description
   jndi name	Enter here the JNDI name.
   class name	Enter here the class name as COM.cloudscape.core.JDBCDriver.
   URL	Enter here the URL as jdbc:cloudscape:../templates/jmsdb.
   user name	Press Enter (null value).
   password	Press Enter (null value).
   classpath	Press Enter (null value).
   authorizedBy	Press Enter.
   test	Press Enter. The default value is true.

   This operation would fail as the Server does not get the class name in the classpath. We get a ClassNotFoundException.

3. Place the jars in the ext folder without stopping the Server, and try making the Connection Factory by giving the above values. The Connection Factory would be made as it picks the jars from the ext directory at runtime.

© Pramati Technologies 2007	Runs on Pramati Server | Feedback | Legal