- Usage Restrictions
- not published
- Description
- describes a wizard which can be used to copy table like data from one
database to another.
- Interactions
-
There are various cases where the wizard needs to interact with the user (except of
course the obvious case to display and operate the wizard dialog itself). For those cases,
an interaction handler is needed, which is used for
- fulfilling parameter requests. This might become necessary if the copy source
describes a parametrized query.
- user interaction in case copying a row fails. If no copy table listener is
registered at the wizard, or none of the registered listener handles an error during
copying a row, or a registered listeners explicitly tells the wizard to ask the user
how to handle the error, then the interaction handler is used together with the
error (an
SQLException , usually) that happened.
- displaying other errors which happen during copying, in particular errors in
creating the target table or view.
When you do not specify an interaction handler by using the
createWithInteractionHandler constructor, the wizard will use the interaction
handler associated with the copy target, i.e. the interaction handler specified when loading
the document which the copy target refers to. If the copy target cannot be associated with
a database document (e.g. because it is a mere ConnectionResource , or a connection
not obtained from a data source), or if the copy target's database document cannot provide
an interaction handler, a newly-created instance of an interaction handler is used.
There's one exception to the above, however: Upon creating the copy table wizard,
the copy source and the copy target descriptors are used to create a Connection. For any
interaction during this phase - including, for instance, necessary authentication -, the
interaction handler of the respective data source is used, no matter what you specified
in createWithInteractionHandler. Only if there is no such interaction
handler, the processing described above, to find another handler, is applied.
- Since
- OOo 2.4
- See also
- ::com::sun::star::sdb::ParametersRequest, XCopyTableWizard::addCopyTableListener, CopyTableContinuation, ::com::sun::star::document::MediaDescriptor::InteractionHandler, ::com::sun::star::sdb::DatabaseDocument, ::com::sun::star::sdb::DataSource, ::com::sun::star::sdb::DataAccessDescriptor::ConnectionResource, ::com::sun::star::sdb::InteractionHandler
|