AnsweredAssumed Answered

Getting Closed Connection error

Question asked by narasimharao.x.lingam on Jan 15, 2017
Latest reply on Jan 22, 2017 by narasimharao.x.lingam

Like • Show 0 Likes0
Comment • 6

Hi,

I have created a VS and deployed it to VSE. And the service runs without any issues for some time(May be 2 hours). VS is getting error ed out and getting following error.

============================================================================

| Exception:

============================================================================

| Message: Error doing random data sets

----------------------------------------------------------------------------

| Trapped Exception: Database query problem

| Trapped Message:

============================================================================

| Exception:

============================================================================

| Message: Database query problem

----------------------------------------------------------------------------

| Trapped Exception: Closed Connection

| Trapped Message: java.sql.SQLRecoverableException: Closed Connection

No one else has this question

Outcomes

IamAbhi Jan 16, 2017 8:58 AM

Hi Narasimha,

It seems to be Virtual Service related problem due to data sets, can you let me know which is the protocol your using to create/ what is the protocol in your Virtual Model file ?

Thanks,

Abhi

Actions

narasimharao.x.lingam @ IamAbhi on Jan 18, 2017 1:09 AM

Hi Abhi,

I have created VS from scratch.

Actions

IamAbhi @ narasimharao.x.lingam on Jan 18, 2017 9:18 AM

Is their any datasets involved in your Model file? If yes, then which type of datasets your using it?

Thanks,

Abhi

Actions

narasimharao.x.lingam @ IamAbhi on Jan 19, 2017 4:54 AM

Hi Abhi,

I am using "Read Rows from a JDBC table" Data set.

Actions

IamAbhi @ narasimharao.x.lingam on Jan 19, 2017 8:26 AM

Hi Narasimha,

From the error we can get to know that it's due to Data set.

What is the query you have wrote like(don't paste actual query) what its trying to query from DB? Because in error it says "Database query problem".

Let me know about it.

Thanks,

Abhi

Actions

narasimharao.x.lingam @ IamAbhi on Jan 22, 2017 11:47 PM

Hi Abhi,

I am using simple query as follows

select * from {{Table name}}

Actions

6 Replies

IamAbhi Jan 16, 2017 8:58 AM
Mark Correct
Correct Answer
Hi Narasimha,

It seems to be Virtual Service related problem due to data sets, can you let me know which is the protocol your using to create/ what is the protocol in your Virtual Model file ?

Thanks,
Abhi
Like • Show 0 Likes0
Actions
- narasimharao.x.lingam @ IamAbhi on Jan 18, 2017 1:09 AM
  Mark Correct
  Correct Answer
  Hi Abhi,
  I have created VS from scratch.
  Like • Show 0 Likes0
  Actions
  - IamAbhi @ narasimharao.x.lingam on Jan 18, 2017 9:18 AM
    Mark Correct
    Correct Answer
    Is their any datasets involved in your Model file? If yes, then which type of datasets your using it?
    
    Thanks,
    Abhi
    Like • Show 0 Likes0
    Actions
    - narasimharao.x.lingam @ IamAbhi on Jan 19, 2017 4:54 AM
      Mark Correct
      Correct Answer
      Hi Abhi,
      I am using "Read Rows from a JDBC table" Data set.
      Like • Show 0 Likes0
      Actions
      - IamAbhi @ narasimharao.x.lingam on Jan 19, 2017 8:26 AM
        Mark Correct
        Correct Answer
        Hi Narasimha,
        
        From the error we can get to know that it's due to Data set.
        
        What is the query you have wrote like(don't paste actual query) what its trying to query from DB? Because in error it says "Database query problem".
        Let me know about it.
        
        Thanks,
        Abhi
        Like • Show 0 Likes0
        Actions
        narasimharao.x.lingam @ IamAbhi on Jan 22, 2017 11:47 PM
        Mark Correct
        Correct Answer
        Hi Abhi,
        
        I am using simple query as follows
        
        select * from {{Table name}}
        Like • Show 0 Likes0
        Actions

Getting Closed Connection error

Outcomes

Related Content

Recommended Content