Re: JSP database connectivity [message #91106] |
Sun, 07 April 2002 08:19 |
khaja
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
Hi,
as said above u need jdbc driver for oracle, but usually u will have it when u have oracle in oarcle/jdbc directory like classes111.jar/zip.
include it in your classpath. and u can make a bean accessing the database and include it in a jsp page by "usebean" syntax.
normally when you deploy the jsp module then u need to add the driver classes in a lib directory for example on tomcat, refer according to different application servers.
but if you use iPlaner with forte for java might be u dont need to add the library, but u have to configure the datasource for iplanet application server.
and concerning the connection try to use connection Pool which reduce the burden of database connection. which u can get from oracle.
concerning the source code i hope u probably know how to access the database using the resultset object.
any way if you have any further ?s pls mail me..
from a Indian.... have fun
|
|
|