How hard would it be to add an oracle database connection to the PlaySQL plugin?

[Marsha Dorsey]

Currently the macro supports Postgres and the embedded database that comes with confluence. I am needing a connection to an oracle database to access an Element Data Dictionary. So my question is how hard would it be to add an oracle connection to the current macro configuration.

[Adrien Ragot 2 · Accepted solution]

Since the version 1.1.0, you can select "Generic Datasource" when your database is neither HSQL nor Postgres. Here is a blog post about How to Connect Play SQL with an Oracle Database. I've tried it and it works, but the following advanced functions will be disabled:

• Table and Column name autocomplete in the SQL editor,
• It could happen that I don't notice other minor bugs, so please send me a bug report when it happens.

Thanks.