Getting error while persisting Point Data

[mstahv]

Getting error while persisting Point Data

[pushpanktugnawat]

I am even facing the same problem while persisting the Point as well as Geometry data type.

Please help to resolve this ASAP.

[pushpanktugnawat]

@mstahv Please help to resolve this I have done this with same configuration as provided in code but still it causes the same problem.

Your kind help is appreciated.

[punit412]

Hello @mstahv , Please reply if you have some solution for the above-mentioned issue.

[mstahv]

I don't have the project open ATM and don't remember what column type was required by MySQL. Try changing the column type from "geometry" to "POINT": https://github.com/mstahv/spring-boot-spatial-example/blob/master/src/main/java/org/vaadin/example/SpatialEvent.java#L21-L22

[punit412]

Already, I do the changes as per your comment. Still, the same issue occurred. Please suggest.

[pushpanktugnawat]

@mstahv Thanks for reply ! we did the same but issue still persist. Please suggest a way to solve this as its causing the same issue as mentioned above again.

[mstahv]

I'd suggest to try with latest version of both database and hibernate. I'd need to re install MySQL to report a version that works for me.

[pushpanktugnawat]

We are working with latest DB version as well as Hibernate 5.1.0 which supports Spatial & JPA too.

Pl help as its very critical to resolve such issues.

[pushpanktugnawat]

@mstahv any update on issue ??

[mstahv]

IIRC, the Hibernate version you use (the default by spring boot 1.x) is bad for mysql. Use 5.2 series in the project. I guess this is the issue you have had. I tried with mysql 5.7.17 and all worked fine. Created a separate branch, configured for mysql, try with that:

https://github.com/mstahv/spring-boot-spatial-example/tree/mysql

[punit412]

@mstahv I have tried with your build only. and found the same issue again having latest hibernate version - 5.2.4.Final and Mysql - 5.7.12. Might be it is not related to the MySQL version.

[mstahv]

Did you try with the exact branch I just referred or with something else? Latest hibernate version is 5.2.10.Final and it works just fine for me. I can't debug an arbitrary project of yours with these details.

If you want somebody to debug your application, you should look into our services https://vaadin.com/pricing

[pushpanktugnawat]

@mstahv a quick help did u just changed the hibernate version or you have done any code based changes as I have just checked didn't find any such changes so if i am missing something than please let me know.

[punit412]

@mstahv Thanks for your time and efforts. I really appreciate your work. My issue is resolved now.

[mstahv]

Awesome! Would you share the solution, so @pushpanktugnawat would get it as well?