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

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".