ERROR [JRCCommunicationAdapter] JRCAgent1 detected an exception: java.lang.NullPointerException

I am viewing reports (crystal) from my web application built using java , jsp and struts with SQL Server as database but when i changed my database to Oracle 9i then i get the following exception and could not view the reports.  Could you please tell me why this exception occured?  My reportt has a sub report linked with the parameter 'as_session_id'.

14:30:42,401 INFO  [STDOUT] 14:30:42,401 INFO  [datainterface] Connection opened (Connection:  databaseType=JDBC  serverName=java:comp/env/MLO_DS  state=open  databaseDriverName=crdb_jdbc.dll).
14:30:42,401 INFO  [STDOUT] 14:30:42,401 INFO  [queryengine] Executing query: select max(deposit_no) deposit_no,
 max(deposit_date) deposit_date
FROM lcps.t_rpt_of_collections  
   WHERE lcps.t_rpt_of_collections.session_id in ( {?as_session_id} )
14:30:42,433 INFO  [STDOUT] 14:30:42,433 ERROR [JRCCommunicationAdapter] JRCAgent1 detected an exception: java.lang.NullPointerException.

Sreekanth_NagabandiAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mlmccConnect With a Mentor Commented:
Did you change the reports to use the new database?

mlmcc
0
 
Mayank SAssociate Director - Product EngineeringCommented:
>> java.lang.NullPointerException.

Can you print the stack trace of the exception? That will help identify at which line it occurs.
0
 
Sreekanth_NagabandiAuthor Commented:
we are getting datasource from JNDI lookup.
0
 
mlmccCommented:
Glad i could help

mlmcc
0
 
Mayank SAssociate Director - Product EngineeringCommented:
What was the solution
0
All Courses

From novice to tech pro — start learning today.