Hi,

I am trying to execute a sql select statement via a web service from within a process and am struggling to work out why it is not working!

I am getting the following error:

fault:
exceptionClass: org.apache.axis2.AxisFault
message: Read timed out

I would appreciate any pointers to where I am going wrong.

Many thanks

Clemo

I suggest ...
1. Remove 'Task' from pool 'WSDL'
2. In process explorer, expand 'WSDL'
3. Drag 'GetCustomer' (marked with cogwheel icon) into pool 'WSDL'
4. Select "Provide operation .... (single task)"
5. Provide message connections between 'CustomerMySQL...' and the operation that you have just created in pool 'wsdl'

Hi,

Thanks for getting back to me, as you can see I am a beginner!

I just want to clarify what you are proposing

Within the Process Pool - I keep the CustomerMySqlDbCustomer which I created by dragging

WSDL>CustomerMySqlDb>CustomerMySqlDbPort>GetCustomer

on to the pool and dropping as an Invoke.....

Within thje WSDL pool, I remove the Task and replace with

WSDL>CustomerMySqlDb>CustomerMySqlDbPort>GetCustomer

on to the pool and dropping as a Provide.....

Then I link these 2 together with some message links.

Is that correct?

Many thanks for your help and advice in this matter.

Paul

Sorry, I missed that you had created CustomerMySql\DbCustomer task by dragging from wsdl . Replace that task with a standard task .
I was trying to get your bpm to a state that I am familiar with ... you may have been approaching the problem correctly from another direction

Not a problem.

Have I think done what you suggested but am still getting some issues :-(

Geronimo log is showing the following error


10:15:26,234 WARN [QueryMessageReceiver] SQL query request processing failed wi
th message for service CustomerMySqlDb, operation uni :Cant find static SQL quer
y definition for operation {1} in service {0}
com.intalio.bpms.connector.jdbc.core.JdbcConnectorException: Cant find static SQ
L query definition for operation {1} in service {0}
at com.intalio.bpms.connector.jdbc.runtime.QueryRequestMessage.checkDefi
nition(QueryRequestMessage.java:139)
at com.intalio.bpms.connector.jdbc.runtime.QueryRequestMessage.loadExecu
te(QueryRequestMessage.java:166)
at com.intalio.bpms.connector.jdbc.runtime.QueryRequestMessage.parse(Que
ryRequestMessage.java:123)
at com.intalio.bpms.connector.jdbc.runtime.QueryRequestMessage.<init>(Qu
eryRequestMessage.java:93)
at com.intalio.bpms.connector.jdbc.runtime.QueryMessageReceiver.invokeBu
sinessLogic(QueryMessageReceiver.java:42)

Am I not settinmg up some parameters or something?

Thanks once again for your help at least now I know I am attacking the problem in the correct way.

Have attached project just in case you get time to look at it again.

Paul

Not a problem.

Have I think done what you suggested but am still getting some issues :-(

Geronimo log is showing the following error


10:15:26,234 WARN [QueryMessageReceiver] SQL query request processing failed wi
th message for service CustomerMySqlDb, operation uni :Cant find static SQL quer
y definition for operation {1} in service {0}
com.intalio.bpms.connector.jdbc.core.JdbcConnectorException: Cant find static SQ
L query definition for operation {1} in service {0}
at com.intalio.bpms.connector.jdbc.runtime.QueryRequestMessage.checkDefi
nition(QueryRequestMessage.java:139)
at com.intalio.bpms.connector.jdbc.runtime.QueryRequestMessage.loadExecu
te(QueryRequestMessage.java:166)
at com.intalio.bpms.connector.jdbc.runtime.QueryRequestMessage.parse(Que
ryRequestMessage.java:123)
at com.intalio.bpms.connector.jdbc.runtime.QueryRequestMessage.<init>(Qu
eryRequestMessage.java:93)
at com.intalio.bpms.connector.jdbc.runtime.QueryMessageReceiver.invokeBu
sinessLogic(QueryMessageReceiver.java:42)

Am I not settinmg up some parameters or something?

Thanks once again for your help at least now I know I am attacking the problem in the correct way.

Have attached project just in case you get time to look at it again.

Paul