Issue 66559 - allow parameters in native queries (HSQLDB)
Summary: allow parameters in native queries (HSQLDB)
Status: ACCEPTED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m172
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks: 69258
  Show dependency tree
 
Reported: 2006-06-19 15:41 UTC by Frank Schönheit
Modified: 2017-05-20 10:47 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2006-06-19 15:41:01 UTC 
Currently, when you switch on the "Run SQL Direct" option in the query designer
(e.g. because you want to use SQL which OOo's own SQL parse does not yet
understand), you cannot use parameters in those queries: For finding out which
parameters a queries contains, it needs to parse them, so this isn't possible here.

However, database backends themself are of course possible to parse all (valid)
statements, and also to tell about the parameters therein.

Since with HSQLDB, OOo Base ships a database engine which we have somewhat
control over, we should investigate the possibilities to ask the HSQL engine for
the parameters in an SQL statement. This way, we would be able to support
parameters in "native" queries, too.
Comment 1 Frank Schönheit 2006-06-19 15:41:28 UTC 
accepting
Comment 2 Frank Schönheit 2006-08-06 21:30:31 UTC 
HSQLDB already supports ParameterMetaData at a prepared statement
(http://java.sun.com/j2se/1.5.0/docs/api/java/sql/ParameterMetaData.html), but
for the purpose of OOo, it would be convenient to have more information. In
particular, parameter names would be interesting.
Comment 3 Frank Schönheit 2007-10-25 09:58:01 UTC 
moving target
Comment 4 Frank Schönheit 2009-10-08 14:15:45 UTC 
moving target milestone to something ... less unrealistic
Comment 5 Marcus 2017-05-20 10:47:57 UTC 
Reset assigne to the default "issues@openoffice.apache.org".