[
https://issues.apache.org/jira/browse/DERBY-5195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13030175#comment-13030175
]
Mike Matrigali commented on DERBY-5195:
---------------------------------------
o personally I would rather not see these types of tools added as supported to
the DERBY project, but rather either as unsupported
SANE tools or as tools on top of derby in another project. I don't think
the production derby.jar should be weighed down with debugging code/tools.
If we decide to start "supporting" more
tools i think they should be checked into a different part of the codeline
and a different jar file. I do think it would be nice if there
was a place to check in unsupported tools on top of DERBY, and we have
discussed it in the past but nothing came of it. A number
of other things come to mind like user definined functions and datatypes. I
think there have been some useful VTI's that would
also fit into this.
o I scanned the DataReader file and it looked like it did not depend on store
at all, so would also benefit from not being in the
store file structure so that it keeps that independence.
o I also worry if we productize these then they could be used in unintended
ways and may cause problems by their use. The intent
is to use single user on a copy of the database, but what happens if people
start running these against a running database either
by choice or accidently. A lot of the existing corruptions of DERBY have
come from users manipulating the log and datafiles by hand. I
would rather not encourage more to do so.
o These tools basically let anyone scan a table (sort of), how does that fit in
with SQL security?
> Create tools for browsing the files in the database log directory.
> ------------------------------------------------------------------
>
> Key: DERBY-5195
> URL: https://issues.apache.org/jira/browse/DERBY-5195
> Project: Derby
> Issue Type: Task
> Affects Versions: 10.9.0.0
> Reporter: Rick Hillegas
> Attachments: ControlFileReader.java, ControlFileReader.java,
> LogFileReader.java, LogFileReader.java, LogFileReader.java
>
>
> It would be nice to have some tools to examine the contents of the log
> directory. The tools should be able to read the files in that directory
> without disturbing them.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
