EGL Development User Group

EGL Development User Group

EGL Development User Group

The EGL Development User Group is dedicated to sharing news, knowledge, and insights regarding the EGL language and Business Developer product. Consisting of IBMers, HCL, and users, this community collaborates to advance the EGL ecosystem.

 View Only
Back to discussions
Expand all | Collapse all

sql connection with cursor holdability()

  • 1.  sql connection with cursor holdability()

    Posted Wed October 14, 2015 03:48 AM

    Hello, 

     

    I 'm trying to connect with two databases db2 and sql from  a richui project.

    I'm using open cursor  hold with from preparestatement to execute sql code and

    I m getting this error "java.lang.NullPointerException" from server console in a loop and I have to close workspace and start again.

    I used "hold" because I had first an output error and suggested me  to use method holdability();

     

    Thanks a lot.

    michaeldefox


  • 2.  Re: sql connection with cursor holdability()

    Posted Wed October 14, 2015 08:42 AM

    Are you able to provide the java stack trace for the null pointer exception? You might be able to find this in the Eclipse .log file.

    Jeff.Douglas


  • 3.  Re: sql connection with cursor holdability()

    Posted Thu October 15, 2015 09:43 AM

    Hi,

    In additional to Jeff's question...

    1.) Does the error only happen with one of the database types?    (db2 or SQL Server)?

    2.) Have you tried to use the EGL "open" statement rather than using a prepare of an open?  

    take care.

    Mark

    markevans


Related Content