problem with accessing database

Hi everybody

I try to execute some wars included with the J2EE tutorial final version

and I follow all the steps in building and deploying the

specified wars, some of those wars is a punch of JSP pages and

Servlet that make access to database.

When I execute any war using the admin console at Sun application

Server 8.2 PE. I have got the message in all the JSP pages

That requires access to database.

Your request cannot be completed. The server got the following error:

"" javax.servlet.jsp.JspTagException: Error getting connection:

"java.sql.SQLException: No suitable driver" :

java.sql.SQLException: No suitable driver""

Am already starting the derby database server .

I don抰 know what the reason for that bug is.

Please help ?br>Best regards

[860 byte] By [kzakkar] at [2007-11-26 8:48:21]
# 1

> Hi everybody

> I try to execute some wars included with the J2EE

> tutorial final version

> and I follow all the steps in building and deploying

> the

> specified wars, some of those wars is a punch of JSP

> pages and

> Servlet that make access to database.

> When I execute any war using the admin console at Sun

> application

> Server 8.2 PE. I have got the message in all the JSP

> pages

> That requires access to database.

>

> Your request cannot be completed. The server got

> the following error:

> "" javax.servlet.jsp.JspTagException: Error getting

> connection:

> "java.sql.SQLException: No suitable driver" :

> java.sql.SQLException: No suitable driver""

>

>

> Am already starting the derby database server .

> I don抰 know what the reason for that bug is.

> Please help ?br>> Best regards

I suppose you've deployed the applications.

Can you check to see in the admin console if the resources and connection pools also have been defined?

Are the connection pools (database -- derby) reachable?

Can you ping the database through the connection pool?

Thanks,

Kedar

kedarmhaswade at 2007-7-6 22:36:40 > top of Java-index,Application & Integration Servers,Application Servers...
# 2
I don't know the details about your environment, but this error happens when you don't register the JDBC driver. You can do that manually (Class.forName("your.jdbc.driver.class")), or put the correct driver name in your pool settings.
JoaoGuilhermeDelValle at 2007-7-6 22:36:40 > top of Java-index,Application & Integration Servers,Application Servers...
# 3

It sounds like you do not have the right setup for javadb path. Check app-server.properties file and make sure the db.home set to a correct database path for your AppServer 8.2PE.

# AppServer 8.x

db.home=${javaee.home}/derby

# If using AppServer 9

db.home=${javaee.home}/javadb

davisn6 at 2007-7-6 22:36:40 > top of Java-index,Application & Integration Servers,Application Servers...