Roxit_Support
New Contributor
Joined 12 years ago
User Profile
User Widgets
Contributions
Re: [Resolved] commit my delete statement in JDBC step
OK. Thanks for the replies Is there another way (besides JDBC staps) to come to the same result? That is: "Remove data added by the previous steps in the project" Due to the single statement per step I already have 12 JDBC steps, to commit I also have to add another 12. The project's size is quadrupled because the addition of JDBC steps.4.6KViews0likes0Comments[Resolved] commit my delete statement in JDBC step
when i run my JDBC steps with content like: "delete from domain_object where id in (select id from zaak where extern_zaaknummer = :extern)" the records are still available. When i run the queries straight on the DB AND add a commit statement the records are deleted. However when I add a new line with 'commit' to the query in my JDBC step, SOAP returns an error:" ORA-00933: SQL command not properly ended" I also tried 'go', 'submit' however the same error returns. Adding ";" does not work either because it is JDBC, it then returns the error: "ORA-00911 invalid character" How can I send a comitted delete statement to my Oracle 11 DB??6.2KViews0likes7CommentsRe: [Resolved] Error when using property in Sql query
are there more properties in your jdbc step?? you can only define the properties used in your query in the jdbc step, otherwise SOAp is confused. So split your properties into use per step where you need them. Then there should be no problem anymore1.3KViews0likes0Comments