How to set JNDI name in JSP File

91 Views

Hi all,

I was updated Web.xml

<context-param>

<param-name>connection</param-name>

<param-value>jdbc:oracle:thin:@192.168.1.81:1521:orcl</param-value>

</context-param>

<context-param>

<param-name>JDBCClassName</param-name>

<param-value>C:/jdevstudio10133/jdbc/lib/ojdbc14.jar</param-value>

</context-param>

<context-param>

<param-name>login</param-name>

<param-value>act_db</param-value>

</context-param>

<context-param>

<param-name>password</param-name>

<param-value>act_db</param-value>

</context-param>

Sample .jsp

// ****** BEGIN SET RUNTIME DATABASE CREDENTIALS ****************

{

String connectString = "connection";

String driverName = "JDBCClassName";

* String JNDIName = "ORCL";*

String userName = "login"; // TODO: Fill in database user

String password = "password"; // TODO: Fill in password

// Switch all tables on the main report and sub reports

CRJavaHelper.changeDataSource(clientDoc, userName, password, connectString, driverName, JNDIName);

// logon to database

CRJavaHelper.logonDataSource(clientDoc, userName, password);

}

At the run time it is showing following error

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: InvalidURLOrClassName---- Error code:-2147467259 Error code name:failed

How to solve these Error Or to set jndi name

Regards ,

Amol Patil