Hibernate query

[saurav sarkar]

Hi All i was using Hibernate tutorial to learn Hibernate.

I had created the database table mentioned as 'Book' in the microsoft access.

For that i am getting this error.I found this error comes when the MS Access does not support datatypes as of mentioned in the SQL query.
I am not sure what datatype to mention the O-R mapping file as i am xtremely new to Hibernate

[code]

org.hibernate.exception.GenericJDBCException: could not insert: [roseindia.tutorial.hibernate.Book]
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1839)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2171)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:669)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:293)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at roseindia.tutorial.hibernate.IdIncrementExample.main(IdIncrementExample.java:33)
Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLBindInParameterBigint(JdbcOdbc.java:1225)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setLong(JdbcOdbcPreparedStatement.java:592)
at org.hibernate.type.LongType.set(LongType.java:40)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:62)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:44)
at org.hibernate.persister.entity.BasicEntityPersister.dehydrate(BasicEntityPersister.java:1603)
at org.hibernate.persister.entity.BasicEntityPersister.dehydrate(BasicEntityPersister.java:1569)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1820)
... 11 more

[code]

Please help me to resolve this problem.

Thanks in advance,
Saurav

[Jeanne Boyarsky]

We have a separate forum for ORMs like Hibernate. I'll move this there for you where people will know more about Hibernate.

[saurav sarkar]

Hibernate experts please help me.......i am desperate to learn
Hibernate...........Cheers

[Arun Kumarr]

Get us more details of your error. Post the hibernate.cfg file and tell us how do you get to the MS-Access datasource. Try using direct jdbc access drivers than a jdbc-odbc bridge. See if you have bound your DSN correctly.
[ July 30, 2007: Message edited by: Arun Kumarr ]

[saurav sarkar]

thanks Arun for the reply.

My Hibernate cfg file

 
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
 
<hibernate-configuration>
<session-factory>
      <property name="hibernate.connection.driver_class">sun.jdbc.odbc.JdbcOdbcDriver</property>
      <property name="hibernate.connection.url">jdbc :-o	 dbc:myaccess</property>
      <property name="hibernate.connection.username"></property>
      <property name="hibernate.connection.password"></property>
      <property name="hibernate.connection.pool_size">10</property>
      <property name="show_sql">true</property>
      <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
      <property name="hibernate.hbm2ddl.auto">update</property>
      <!-- Mapping files -->
      <mapping resource="contact.hbm.xml"/>
</session-factory>
</hibernate-configuration>

I am configuring the connection through the ODBC administrator of Windows.

PLease help

[Jaikiran Pai]

Caused by: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented

Microsoft Access driver might not have implemented this feature. Why not use some other database instead of MS Access? You could use MySQL which is a free.

[Jaikiran Pai]

Looking at the hibernate config that you posted, it appears that you are using MySQL dialect with your MS Access Database driver:

<property name="dialect">org.hibernate.dialect.MySQLDialect</property>

Better use MySQL database (and its corresponding driver) with this dialect

[Arun Kumarr]

Hi,
Did you try using direct jdbc driver? If not try getting one here.

I saw the example. They have specifically mentioned to create the table in MySQL. Why are you using MS-Access?

Check what you have mentioned in the mapping file and in the Class. Do you have "Long" in the POJO and "long" in the mapping file?

[saurav sarkar]

Thanks Jaikiran and Arun for your replies.
Problem i can download anything in my desktop.
Thata why i am going with Access.
I think the dialect property needs to be changed
as i am using MS Access.But i have not
found any dialect specific for MS Accesss in the
Hibernate Reference manual