| From: | Xavier Poinsard <xpoinsard(at)free(dot)fr> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Patch for jdbc escaped functions |
| Date: | 2004-11-22 14:09:39 |
| Message-ID: | 41A1F323.1070508@free.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Kris Jurka wrote:
> This code is not quite right in its determination of function arguments
> because it stops checking for literal and identifier markers.
> Consider that {fn concat('(', a."(")} should work.
Thanks for pointing these defects.
I added this to the parsing and your example to the tests.
>
> I also don't like the prospect of a giant if/else block that has every
> function that must do some kind of mapping/translation. What about a more
> pluggable architecture perhaps along the lines of the following:
>
> public interface StandardFunction {
> public void toSQL(StringBuffer sb, ArrayList args);
> }
>
> Then a static HashMap of say lowercase function name -> StandardFunction
> implementation can move all of the mapping/translation into a separate
> place. Maybe that's overkill in the opposite direction. Thoughts?
I used reflection to move the translation part to EscapedFunctions class.
Right ?
| Attachment | Content-Type | Size |
|---|---|---|
| escapedfunctions2.diff | text/x-patch | 14.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Robinson | 2004-11-22 16:44:05 | Any knowledgeable Object -> Relational coders in here? |
| Previous Message | Kris Jurka | 2004-11-22 08:36:32 | Re: jdk1.5, pgsql8 on WinXP: classpath problems |