I have to make native sql query without knowing in advace which query it will be, for example something like this:

sqlQuery=... // a query string get from a input file from a socket
List results = systemSession.createSQLQuery(sqlQuery).list();

is it possible in Hibernate? All the example i found need a scalar to be added or a entity class to be added, but I can't do that as i don't know how the sql statement will be (possibly i don't want to make a sql parser to get which is the pieces in the sql statement).

Thanks

Hi Julius,

if you do not specify addScalar or addEntity then hibernate will use
type autodetection. The types are defined in the Dialect-Class.

Hi steckemetz

Thanks for your reply, this is a first step in the right direction!