Subject | Re: [Firebird-Java] Re: JayBird: Problems with Prepared Statements |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-09-06T15:31:52Z |
> Can I post a direct link to my post here at YahooGroups - would thatJust type few words - Yahoo might decide to remove their message database.
> suffice as a feature request description?
> I have a single 'statementExecutor()' method in my Java program thatThen why do you need SQLstatement parameter later? For now I can imagine
> takes an 'SQLstatement' String as input parameter. I thought, I can
> spare another method for executing the prepared statement on its own
> (as I have to also execute non-prepared CREATEs: in addition to the
> mentioned INSERTs).
only one usage for it - take an object (instance of java.sql.Statement
interface) and display it to the user.
But then, if you have a single method that takes string as parameter, why do
you need to call toString() method to return the SQL string that you just
passed?
If you expect the toString() method to convert parameter marks ('?') into
the specified string values - that's another story. It was already discussed
here and the resolution was:
"We need to create good SQL parser and so far nobody in the project has
enough time to write one. If and when you write and test it, we will be glad
to commit it to the project".
Roman