Hi,

I've read somewhere, than hibernate supports native sql command. I've tryied an select, it worked, but
I don't know how to insert into a table.

I've tried it with 'insert into .. values', there was no error, but
the row was not inserted (i checked throug a db visualiser)
public void insertStitek(
Integer a, Integer b,
String c) {

Query sqlQuery;
String queryString =
"insert into kstitek(a,b,c) values("
+ a.intValue()
+ ","
+ b.intValue()
+ ","
+ "\'" + c + "\')";

sqlQuery = getSession().createSQLQuery(queryString, "stitky", Object.class);

List list = null;
try {
list = sqlQuery.list();
}
catch (HibernateException he) {}
}

I'm usint HibernateDaoSupport, and as I said select works, but insert doesn't

use s.connection() if you want to do raw sql insert.

createSQLQuery() is for *query*ing not manipulation....

could yuo provide me a short example how to use connection() and native sql insert?

it's a standard JDBC connection!

just use it as you would normally use such a thing.