Does PlaySQL plugin support MySQL?

Does PlaySQL plugin support MySQL?

I configured the PlaySQL jndi datasource to mysql

but I got an exception:

Exception while querying the database: java.lang.RuntimeException: No column Position in this result set: org.apache.tomcat.dbcp.dbcp.DelegatingResultSet@168a0b

why ?

3 answers

Hi Zhang,

PostgreSQL and Hsql are the databases I support out-of-the-box (see specifications). As explained on the question about Oracle support, Play SQL should work nicely with any JDBC database but may not have some of the advanced features like autocomplete for table and column names.

It will be interesting to keep your question open and see whether any other user has experience to share about MySQL and Play SQL.

Adrien - do you have an update on this?

Hi Brian, There's been no change in the support of MySQL since your question: The base read-only plugin will work but may not show the list of tables and columns, whereas the Spreadsheet plugin won't work with MySQL for sure. Best regards, Adrien

Does this demo box still work? http://sandbox.play-sql.com/

I didn't have any luck opening it up. Sorry for posting here, couldn't figure out how to PM.

Hello,

I am not an expert in this plugin, but there could certainly be a number of our members that are. I would however suggest that you open a support case with the developer of the plugin. I am including a link to their support page on our market place below.

https://marketplace.atlassian.com/plugins/com.playsql.playsql-plugin/version/31/support

I would suggest contacting them directly to see if they can resolve the issue straight away. Our user community here is great and I am sure someone will have experienced this problem before. I just think it is a good plan to try to contact the source.

We are using the PlaySQL plugin with MySQL without any problems. Maybe the JNDI-Datasource is not configured the right way..

This should give you a guide: Does Play SQL support MS SQL, MySQL or Oracle?

That's great. and you have full functionality?

I'd like to emphasize that only Play SQL base will work. Play SQL Spreadsheets will only work with PostgreSQL.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,100 views 17 14
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you