String queryString = "LOAD DATA INFILE 'C:/Documents and Settings/mob100001791/Desktop/vendor1.csv' INTO TABLE vendor1 " ;
session.createQuery(queryString);
when i try to execute the above line i m getting th e following Exception

java.lang.IllegalArgumentException: node to traverse cannot be null!

please get me out of this Exception.

more over please suggest how to convert mysql query into HQL query

That type of query can't be converted to HQL. You might try with session.createSQLQuery(). If that doesn't work either you'll have to use JDBC via session.doWork().

Hi

We considering DB migration may happen so we should stick with hibernate alone.

when i tried with the following query :
session.createSQLQuery("LOAD DATA INFILE D:/Jiyas/HeatMap/vendor1.csv INTO TABLE vendor1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' ").executeUpdate();

i am getting org.hibernate.exception.SQLGrammarException: could not execute native bulk manipulation query
.....
....
...
Caused by: java.sql.SQLException: No value specified for parameter 1

LOAD DATA INFILE is not very standard in the SQL world, so I doubt that it can work on other database systems than MySQL.

my intension is to insert .csv file content which will contain huge data in to mysql data base .

i need query in HQL

when i tried like this

session.createSQLQuery("LOAD DATA LOCAL INFILE :filename INTO TABLE vendor1 FIELDS TERMINATED BY ','(Int_ID, ISIN, COUPON_RTE, FIRST_PY_DTE, ISSU_DTE, LAST_PAYDTE, MATURITY_DTE, NEXT_PAYDATE, PAY_FRQY, PAY_DWN_FAC, DENOM_CURR)").setString("filename", "D:/Jiyas/HeatMap/vendor1.csv").executeUpdate();

csv content is inserted in to DB.

thanks for your response.