[dba-dev] Calling a stored procedure returns sdbc.SQLException

2010-02-15 Thread Fernand Vanrie
I can get a resultset from a Stored Procedure (on MySQL) using a simple Statement or using a prepareStatement: "call StoredProcdurename()" but only once. after running the statement a second time OO trows a sdbc.SQLExepetion "Commands out of sync, you can not run this command now" I have to res

Re: [dba-dev] Problem: OpenOffice Base and PostgreSQL stored procedures

2010-02-15 Thread Fernand Vanrie
Drew , You says : "sure there is some access to the stored procedures with the current implementation but it isn't yet ready to take full advantage them" I know you are a bussy man and always prepared to help, but can you explaines a bit more and gives us some hints from wath can already been d