Seven Stars

Invalid state, the PreparedStatement object is closed.

Hi,

I am facing an issue with the below flow - 

 

tMap --> tJavaFlex-->tMSSQLOutput_1

   |

tMSSQLOutput_2

 

through tJavaFlex I could have multiple rows for one row. When I am executing the job. It is throwing the below error.

 

Exception in component tMSSqlOutput_2
java.sql.SQLException: Invalid state, the PreparedStatement object is closed.

 

Does anyone faced that issue or have a solution for that ?

5 REPLIES
Nine Stars

Re: Invalid state, the PreparedStatement object is closed.

Hi,

 

tMSSQLOutput_1 and tMSSQLOutput_2 using same DB object or different DB objects?

 

Regards,

 

Veeru Boppudi
Moderator

Re: Invalid state, the PreparedStatement object is closed.

Hello,

We will appreciate it a lot if you can upload your current job design screenshots on forum.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: Invalid state, the PreparedStatement object is closed.

Hi vbopuddi,

I have tried both the case - Same and different connection. What I have found - the problem is with tJavaFlex. If I remove the tJavaFlex, its executing fine.

As everytime I am getting two flows out of one through tJavaFlex. So for now to resolve the issue I have removed tJavaFlex and created one more flow out of tMap.

But in case if there are multiple flows, there must be a permanent solution.

Best Regards,
Abhishek
Seven Stars

Re: Invalid state, the PreparedStatement object is closed.

Hi xdishi,
Sorry, due to some security issues, I can not share the complete document. But the flow is like below-

tfilterRow -> tJavaRow -> tMap -> tJavaFlex->tMSSQLOutput_1
                                               |
                                    tMSSQLOutput_2

Best Regards,
Abhishek

Nine Stars

Re: Invalid state, the PreparedStatement object is closed.

Hi,

 

What are you doing in tJavaFlex component? 

 

Regards,

 

Veeru Boppudi