Hello didnt take time to run your sample - it is pretty late there ;) - but think you need to add <non-jta-datasource> to the persistence.xml instead of using javax.persistence properties to setup the connection. Think we workaround this EE constraint on tomee 7 but no more sure for 1.x.
Romain Manni-Bucau @rmannibucau <https://twitter.com/rmannibucau> | Blog <https://blog-rmannibucau.rhcloud.com> | Old Wordpress Blog <http://rmannibucau.wordpress.com> | Github <https://github.com/rmannibucau> | LinkedIn <https://www.linkedin.com/in/rmannibucau> | Tomitriber <http://www.tomitribe.com> | JavaEE Factory <https://javaeefactory-rmannibucau.rhcloud.com> 2016-06-22 22:48 GMT+02:00 eclideria <[email protected]>: > Hello guys, > > I try to make a simple app using a rest service, eclipseLink and mysql. I > want to make this run on a TomEE server (apache-tomee-plume-1.7.4). > > But I'm facing a strange issue: > > java.sql.SQLSyntaxErrorException: user lacks privilege or object not found > > The query is running perfectly on mysql console. > > A strange thing is that I get the same issue if my mysql server is not > running, so i suppose that the db server is never reach. > > Here is my logs: > logsWhenAccessingURL.txt > < > http://tomee-openejb.979440.n4.nabble.com/file/n4679015/stackWhenAccessingURL.txt > > > logsWhenDeploying.txt > < > http://tomee-openejb.979440.n4.nabble.com/file/n4679015/stackWhenDeploying.txt > > > persistence.xml > <http://tomee-openejb.979440.n4.nabble.com/file/n4679015/persistence.xml> > > My code is accessible on gitlab <https://gitlab.com/julienD/MyTestApp> > > I have also ask the question on stackoverflow > < > http://stackoverflow.com/questions/37954385/javaee-eclipselink-tomee-gives-java-sql-sqlsyntaxerrorexception-user-lacks > > > > Thanks a lot for your help > > > > -- > View this message in context: > http://tomee-openejb.979440.n4.nabble.com/JavaEE-eclipseLink-TomEE-gives-java-sql-SQLSyntaxErrorException-user-lacks-privilege-or-object-not-fd-tp4679015.html > Sent from the TomEE Users mailing list archive at Nabble.com. >
