Hi All,
I am using hibernate3 to insert records to Oracle database.I am getting following exception during insertion.

Hibernate: insert into EMP (ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO, EMPNO) values (?, ?, ?, ?, ?, ?, ?, ?)
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Option type out of range
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)

But the record i am trying to insert is getting inserted to database.I couldn't understand why i am getting Option type out of range exception.I have searched in google to understand the meaning exception but i didn't get any information.Can anyone help me please.

Hello Friend:

After read this, I think you use "Oracle" to store your datas, but you use "Microsoft Jdbc Driver" to do any transaction to persist datas into Oracle.

So you got that exception.

Get a Jdbc Driver for your Oracle and you will solve your problem.

Regards.

Hi,
I used Microsoft Odbc Jdbc driver for inserting records into oracle.Insertion operation is working fine but i couldn't understand why i am getting option type out of range exception. .What is the meaning of that exception?Can anyone please help