sorted by: recent | see : popular

Content Tagged with Oracle + plugin

QuantumDB is a simple but powerful database access plug-in for the Eclipse Development Platform. QuantumDB allows you to: * connect to databases using standard JDBC drivers * review schemas, tables, views and sequences * look up column, index and foreign key information * issue ad-hoc queries or other SQL statements against the database * manage, edit, and work with SQL files (*.sql) * issue updates, deletes, and inserts using simple, easy-to-use wizards

The PL/SQL editor is a plugin for the eclipse integrated development environment that allows you to more easily develop and test PL/SQL code.

It’s been a while since the MySQL Management Plug-in 0.42 was released. Since then, I quietly updated it to version 1.0. The changes were very few; the biggest news was that the plug-in was certified by Oracle and added to OTN Oracle 10g Grid Control Extensions Exchange (see at the bottom).

I think the next version is due, as a few people have come back to me with some issues. The biggest was compatibility with Windows. Since I used the command line MySQL client, *nix and Windows shell incompatibilities were a major headache to solve, and I still couldn’t make it work reliably. I wanted to use DBI and DBD:MySQL, but it required installing and compiling Perl packages, which makes the deployment process very inconvenient.

Finally, I found a solution — Net::MySQL is a native Perl implementation of the MySQL client. I had to fix some bugs and add a few improvements to it, and I hope to get the author to re-introduce them back to the new CPAN distribution. Net::MySQL is dependent on IO::Socket, which is a core module that comes with the standard Perl distributed with the Oracle Management Agent.

Version 1.1 turned out to be a major rewrite for the Perl collection scripts and the net result is that compatibility across platforms is greatly improved. I have successfully tested the new version on Linux and Windows Agent hosts.

So what’s new in version 1.1 compared to 0.42?

• certified by Oracle; see OTN Extensions Exchange
• no MySQL client is required on Agent hosts. The Perl Net::MySQL package is distributed with the plug-in
• fully compatible with Windows
• MySQL client path property removed
• added support for local connection using Unix sockets
• added connection error message when target is down — can be seen in Availability History
• commands statistics skips collection for never-executed commands so less data is collected; thus, I could safely increased default collection frequency; command names are formated better
• changed default collection frequency for network, joins and sort statistics
• % command executions are collected right now — the “Questions” statistic didn’t match the total of all Com_ statistics.
• metric “Processes by Action” now excludes the plug-in’s own connection which was always adding one to “Query”
• a few minor typos fixed

Downloads, requirements, and installation instructions — as well as the datasheet — are available at the MySQL Plug-in for Oracle Grid Control home page.