connecting to Excel sheet through hibernate

[yekkala krishna]

Hi,

Could we connect to excel sheet via hibernate.
i am getting below exception when connceting to excel sheet via hiberante

 java.sql.SQLException: [Microsoft][ODBC Excel Driver]Optional feature not implemented
	sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
	sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
	sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(Unknown Source)
	sun.jdbc.odbc.JdbcOdbcConnection.setAutoCommit(Unknown Source)
	org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:135)

my hibernate.cfg.xml

<hibernate-configuration>
	<session-factory>
		<property name="connection.driver_class">sun.jdbc.odbc.JdbcOdbcDriver</property>
		<property name="connection.url"> jdbc:odbc:exceldsn</property>
		<property name="connection.username"></property>
		<property name="connection.password"></property>
		<property name="connection.pool_size">1</property>
		<property name="dialect"> org.hibernate.dialect.MySQLDialect</property>
		<property name="current_session_context_class">thread</property>
		<property name="cache.provider_class"> org.hibernate.cache.NoCacheProvider </property>
		<property name="show_sql">true</property>
		<!-- <property name="hbm2ddl.auto">update</property>-->
		<property name = "hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>
		<mapping class="com.veera.struts2.model.Contact" />
	</session-factory>
</hibernate-configuration>

could anybody suggest me.
How can i solve this issue?
Regards,
Rama

[Paul Sturrock]

Not something you can do. Hibernate is designed to work with relational data sources. Excel is not a relational data source, so Hibernate is not an appropriate tool to be using. Have you looked at Apache POI?