Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
DTP FAQ
Revision as of 12:42, 1 October 2009 by Bfitzpat.redhat.com (Talk | contribs) (New page: {{Back To|name=DTP Main Page|href=Data Tools Platform Project}} = DTP Frequently Asked Questions (FAQ) = == Connectivity == Q: How do I programmatically access an existing connection p...)
DTP Frequently Asked Questions (FAQ)
Connectivity
Q: How do I programmatically access an existing connection profile?
A: This is pretty simple:
IConnectionProfile profile = ProfileManager.getInstance().getProfileByName("myprofile");
Q: How do I connect to an existing connection profile programmatically?
A: Again, pretty simple:
IConnectionProfile profile = ProfileManager.getInstance().getProfileByName("myprofile"); IStatus status = profile.connect(); if (status.equals(IStatus.OK)) {
// success
} else {
// failure :(
if (status.getException() != null) {
status.getException().printStackTrace();
}
}
Q: How do I get the raw JDBC Connection from my connected connection profile?
public java.sql.Connection getJavaConnectionForProfile (IConnectionProfile profile) {
IConnection connection = ProfileConnectionManager.getProfileConnectionManagerInstance().getConnection(profile,"java.sql.Connection");
if (connection != null) {
return (java.sql.Connection) connection.getRawConnection();
}
return null;
}