How to convert an entity to Json?

Is there a Java framework to convert JSON to SQL queries?

  • i want to know is there a framework which can convert json (given in some format) sql to queries.

  • Answer:

    restSQL is an ultra-lightweight data access layer for HTTP clients. restSQL is a persistence framework or engine in the middle tier of a classic three tier architecture: client, application server and database. It may also be embedded in any middle-tier as a Java library.Latest Release: restSQL 0.8.11, released Nov 11, 2015, expands SQL operator support and improves resource customization. See the http://restsql.org/doc/release/ReleaseNotes_0.8.11.html for more detail.If you would like to be notified of new releases, please http://restsql.org/doc/Subscribe.html to our mailing list.What it is an SQL generator with Java and HTTP APIs uses a simple RESTful HTTP API with XML or JSON serialization presents flat or hierarchical views of relational database tables organizes access through query-able and updatable database views called SQL Resources uses declarative authorization offers declarative and plugin mechanisms for implementing domain constraints and business logic a JEE web application or a Java library platform, JEE container and database agnostic What it is Not an HTTP to JDBC/ODBC bridge that tunnels SQL over HTTP an Object-Relational Mapping tool (ORM) that maps tables to objects a database or a data storage engine a sophisticated query or report generator an OLAP-style cube or data warehousing engine Where it could be UsedApplications needing: basic CRUD (Create-Read-Update-Delete) access to relational databases a database abstraction layer a lighter-weight alternative to ORM (e.g. ADO or EJB) a lighter-weight alternative to WSDL/SOAP MotivationFor many apps: Conventional ORM is too heavyweightWe’ve gone overboard with objectsOodles of classes, interfaces, deployment descriptorsOQL - another language to learn Conventional ORM is inflexibleA domain object layer rarely serves multiple apps wellEntity objects can’t be joined into arbitrary viewsMore accidental complexity: code required to join entities Conventional Web Services is too heavyweightWSDL and SOAP are complicatedRESTful Web Services and WADL are simpler http://restsql.org/doc/Overview.html

Yernar Amergaliyev at Quora Visit the source

Was this solution helpful to you?

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.