Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
Hibernate issue during startup
Mike Nehrkorn
2010-10-08 11:03:31.0
I'm trying to test out the HXTT JDBC drivers for use with Access and I seem to have a problem with Hibernate during startup. It seems to find the database OK but gets the following error.

Any idea what the issue is?

2010-10-08 12:15:43,703 [main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
2010-10-08 12:15:44,078 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JN
DI name configured
2010-10-08 12:15:44,078 [main] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - Running hbm2ddl schema update
2010-10-08 12:15:44,078 [main] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - fetching database metadata
2010-10-08 12:15:44,125 [main] ERROR org.hibernate.tool.hbm2ddl.SchemaUpdate - could not get database metadata
java.sql.SQLException: Please assign the operating table name directly
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.ae.a(Unknown Source)
at com.hxtt.sql.access.ae.new(Unknown Source)
at com.hxtt.sql.access.ae.if(Unknown Source)
at com.hxtt.sql.br.do(Unknown Source)
at com.hxtt.sql.br.if(Unknown Source)
at com.hxtt.sql.dj.a(Unknown Source)
at com.hxtt.sql.dj.a(Unknown Source)
at com.hxtt.sql.br.a(Unknown Source)
at com.hxtt.sql.br.a(Unknown Source)
at com.hxtt.sql.ai.a(Unknown Source)
at com.hxtt.sql.ai.a(Unknown Source)
at com.hxtt.sql.ai.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:151)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.(DatabaseMetadata.java:69)
at org.hibernate.tool.hbm2ddl.DatabaseMetadata.(DatabaseMetadata.java:62)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:170)
at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:386)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:891)
at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalCont
Re:Hibernate issue during startup
HXTT Support
2010-10-08 17:27:17.0
>java.sql.SQLException: Please assign the operating table name directly
Pleae check your jdbc url. It seems that your jdbc url and sql should has a wrong setting.
For instance, you can use
jdbc:access:////adatapath/abc.mdb select * from atable;
or
jdbc:access:////adatapath/ select * from abc.atable;
Re:Re:Hibernate issue during startup
Mike Nehrkorn
2010-10-09 06:28:37.0
My URL is stored in a property file that is used to build the connection string and is very simple --

database.url=jdbc:access:///c:/access/rule.mdb

The processing that is failing is during app start up when Hibernate is trying to access the database metadata.

Are there any known issues using Hibernate with Access and your driver?
Re:Re:Re:Hibernate issue during startup
HXTT Support
2010-10-12 19:29:47.0
>Are there any known issues using Hibernate with Access and your driver?
No issue.

>java.sql.SQLException: Please assign the operating table name directly
That issue should be resulted by one autogenerated sql by spring framework or hibernate. The latest package should have supported it. Please download it.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap