Hi, i'm working with AO but we are getting issues when we have differents databases.
Hi,
Please explain further, what do you mean "getting issues", what issues?
what do you mean by different databse? different between where to where? which databases type?
Hi @Nir Haimov Thanks for the response.
For example, this line:
MyDataAO[] mydata = ao.find(MyDataAO.class, Query.select().where("Name = ?", campo));
this on jira H2 databases works correctly when i'm developing, but when i install the plugin on a Jira with Postgresql Database i get this error:
org.postgresql.util.PSQLException: ERROR: doesn't exist the colum «Name»
So is solve this on Postgresql with this:
MyDataAO[] mydata = ao.find(MyDataAO.class, Query.select().where("\"NAME\" = ?", campo));
This is gona work on MySQL, H2 and postgres or i need to diferientate the SQL pending on the database installed?
Thanks
It's pretty weird that you need to change it to "\"NAME\" to work on postgress, i don't remember i had to do it in the past...
But ("Name = ?", campo)) will work on MySQL, so you don't need to do another change for MySQL
Hope my answer help
yes but for postgres it only work on me with this "\"NAME\"" so if this doesn't work for mysql and in mysql work with ("Name = ?", campo)) how i can know with database is selected to execute the one or the other?
It looks like you're new here. Sign in or register to get started.
