File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes org.hibernate.exception.JDBCConnectionException: Cannot open connection facing Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "org.hibernate.exception.JDBCConnectionException: Cannot open connection facing" Watch "org.hibernate.exception.JDBCConnectionException: Cannot open connection facing" New topic
Author

org.hibernate.exception.JDBCConnectionException: Cannot open connection facing

Rd Dari
Ranch Hand

Joined: Feb 22, 2010
Posts: 211

Hi,

I have an Excel sheet having three sheets.


In first sheet 380 records are there , in second sheet 1596 and in third sheet 5998 records are there but at the insertion time first and second sheet data is inserting successfully but in third sheet the data is varying at the insertion time means some times its inserting 2000 something , sometimes 3000 something and throwing the exception below:-


my code is :




can any one tell me the solution.

Thanks in advanced.
K. Tsang
Bartender

Joined: Sep 13, 2007
Posts: 2615
    
    9

The java code seems to be okay. From the stack trace, the db connection is already opened or in use.

Are you using connection pool? What do the configuration files look like?


K. Tsang JavaRanch SCJP5 SCJD/OCM-JD OCPJP7 OCPWCD5 OCPBCD5
Rd Dari
Ranch Hand

Joined: Feb 22, 2010
Posts: 211

Thank K. TSang for reply
I am using this datasource:

DataSource.xml



cxf.xml



and Hibernate.xml
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: org.hibernate.exception.JDBCConnectionException: Cannot open connection facing