Hi,
I am trying to connect to a Cloudscape 10.1 database, right now I
can't connect to the Cloudscape database in the Tomcat JSP. Every time
I get this error message:

An Exception was caught while connecting to the database.

 java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getConnection(DriverManager.java:532)
	at java.sql.DriverManager.getConnection(DriverManager.java:193)...

Can you please help me solve this problem? Can you make the solution
as detailed as possible?
Thanks,
Dan

Yes, Its a problem with the Driver.

for any database, to be accessed through JDBC we need to have
corresponding driver.
read the following documentation. it may help you.

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408anderson/#cs_rdbms

Hi Dan,

You need the appropriate JDBC driver for Cloudscape. Typically, it is
a jar file that usually ships with the database or is available for
download from the database. *Please read the licensing instructions
carefully*.

Once you download the jar file, copy it to the WEB-INF/lib folder
available at the root of the context. Copying this jar will help make
it available in Tomcat application's classpath and helps to resolve
the driver problem you are having.

Hope this helps

And of cource you must "load" class of driver (once, on server startup):
Class.forName("<driver class name>");

For example to load MySQL driver you must write this:
Class.forName("com.mysql.jdbc.Driver");

And after that you can get connection using
DriverManager.getConnection(connString, user, password);