Hi,

First of all apologies for the duplicating posting witht he last message, result of going back within Explorer and resubmitting the posting by mistake.

Anyway I have been doing some investigation of the issue here and it looks like the issue is Geronimo knows nothing about the service which should be found at

http://localhost:8080/ode/services/jdbc/CustomerMySqlDb

If I do http://localhost:8080/ode/services/jdbc I get the following exception

<Exception>org.apache.axis2.AxisFault: The service cannot be found for the endpoint reference (EPR) /ode/services/jdbc .....

So I am now thinking it is either a configuration problem or a deployment problem.

With deployment I am just hitting the deployment button, selecting all the components and deploying which I presume is right so it must be a configuration issue but I cannot see it!

Anybody any clues?

Thanks

Paul

Hi,

Got it working :-)


It looks like the MySql bundle had some how reset itself so once changed that to be correct, everything worked.

I honestly had set it up correctly, honest.

Thanks to everyone for helping me solve this.

Can now go on to create my demo with hopefully some confidence and a greater understanding of how everything works under the hood

Paul

Hi,
I am also getting the following error "Cant find static SQL query definition" in the server log and a big statck trace. U also had a similar problem how did it get solved u said sql bundle got correct can u plz say what u did and the process u followed.Am a beginner and need your help desperately.

Please reply

Many thanks.

Hi,

Have a look on this for setting jdbc connector configuration for designer and server http://bpms.intalio.com/reference-guides/intalio-bpms-connector-for-jd...

Make sure that you place the jdbc driver jar file under
[geronimo-home]\repository\com\intalio\bpms\pxe\5.1.2\pxe-5.1.2.war\WEB-INF\lib

I hope it may resolve your issue. Try it and let me know how it goes.

Thanks,
Chandra.

hi, i'm new and i am trying to execute a process, but the same error is happening: Cant find static SQL query definition for operation {1} in service {0}.

I followed all the steps of http://bpms.intalio.com/reference-guides/intalio-bpms-connector-for-jd... but the error remains.

Before, the database was not been recognized, but when i saw the tutorial the problem was resolved and now the problem is what i said above.

Can anyone help me?