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

This widget could not be displayed.

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.

This widget could not be displayed.

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.

This widget could not be displayed.

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 Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

368 views 2 5
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