apex-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vlad Rozov <v.ro...@datatorrent.com>
Subject Re: DB connection getting lost
Date Wed, 19 Apr 2017 00:20:46 GMT
Do you call JdbcStore from an operator thread or do you share it across 
multiple threads? In the later case the behavior is undefined.

Thank you,

Vlad

On 4/17/17 02:10, Priyanka Gugale wrote:
> Can you make sure you have called connect first before createStatement.
> Also if possible please share code where you do make connection and 
> create statement in operator.
>
> -Priyanka
>
> On Mon, Apr 17, 2017 at 2:22 PM, chiranjeevi vasupilli 
> <chiru.vcj@gmail.com <mailto:chiru.vcj@gmail.com>> wrote:
>
>     We have utility class from where we are connecting to DB
>     using com.datatorrent.lib.db.jdbc.JdbcStore.
>
>     On Mon, Apr 17, 2017 at 1:50 PM, Priyanka Gugale
>     <priyag@apache.org <mailto:priyag@apache.org>> wrote:
>
>         Have you written any custom operator or you are
>         using JdbcInputOperator from Malhar?
>
>         -Priyanka
>
>         On Mon, Apr 17, 2017 at 1:27 PM, chiranjeevi vasupilli
>         <chiru.vcj@gmail.com <mailto:chiru.vcj@gmail.com>> wrote:
>
>             Hi Priyanka,
>
>             In logs we can see NullPointer exception while
>             preparing createStatment .
>
>             I have verified after calling connect() method of
>             JdbcStore, i have called store.getConnection to print the
>             connection object. But when i use the connection to
>             prepare the createStatment we are getting NullPointer
>             exception.
>
>             We are not sure , why it is becoming null or we received
>             any dead connection.
>
>             Please suggest.
>
>             Thanks
>             Chiranjeevi V
>
>             On Mon, Apr 17, 2017 at 12:19 PM, Priyanka Gugale
>             <priyag@apache.org <mailto:priyag@apache.org>> wrote:
>
>                 Do you see any exceptions in your log file? If yes
>                 please share.
>                 Also you mentioned "connection getting established" -
>                 how do you verify that?
>
>                 -Priyanka
>
>                 On Thu, Apr 13, 2017 at 3:17 PM, chiranjeevi vasupilli
>                 <chiru.vcj@gmail.com <mailto:chiru.vcj@gmail.com>> wrote:
>
>                     Hi Team,
>
>                     In my use case , im using JdbcStore from Malhar
>                     lib to get oracle connection . But im getting some
>                     strange behavior. Connection getting established
>                     and when i call *store.getConnection* it is
>                     returning null. Due to this the containers getting
>                     killed in my App.
>
>                     The established connection became dead and unable
>                     query, Please suggest how to handle such scenario.
>
>                     Thanks
>                     Chiranjeevi V
>
>
>
>
>
>
>             -- 
>             ur's
>             chiru
>
>
>
>
>
>     -- 
>     ur's
>     chiru
>
>


Mime
View raw message