Q7) How to configure JDBC and datasource in websphere

Configuration:
àAdminConsoleàResourcesàJDBCprovidersà
àSelect the scope (cell level or node level)
àclick new
àselect the Database type (Sybase,oracle,etc)
à select the provider type (oracle jbdc driver)
à select the implementation type (connection pool)
àclick on the driver
àselect the DataSource
àClick on new
àgive a name to the datasource
àoracleDatasourceProperties(URL:jdbc:oracle:thin:@192.168.1.14:1521:XE)
àclick on J2EE Connector Architecture (J2C) authentication data entries
àGive username and password and
àgive the component-managed authentication aliases
àand set the environment variable
àgo to Environmentàwebsphere variablesàclick on the level-àclick on
newàOracle_jdbc_driver_path and give the address of the 14.jar
-àTest the connection