Javatpoint Logo
JavaTpoint

org.hibernate.exception.GenericJDBCException: Cannot open connection

By: noemai*** On: Wed Oct 03 12:08:48 IST 2012     Question Reputation0 Answer Reputation0 Quiz Belt Series Points0  0Blank User
Hi,
Can you please tell me how to resolve this exception. The generated exception is:

Exception in thread "main" org.hibernate.exception.GenericJDBCException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354)
at com.javatpoint.Store.main(Store.java:15)
Caused by: java.sql.SQLException: Invalid Oracle URL specified
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:538)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
... 5 more
Up0Down

 
Check that you have written the correct URL for the database in the configuration file. If you are using oracle 10g, it must be
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>
Image Created0Down
By: [email protected] On: Wed Oct 03 12:10:27 IST 2012 Question Reputation0 Answer Reputation20 Belt Series Points0 20User Image
Are You Satisfied :3Yes7No
 
Hi,
Soono This is Yogesh i am trying to use your hibernate first example but i am getting exceptions please let me know what is the problem. I already added all hibernate jars and ojdbc14.jar files in build path?
exceptions are as follows

log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
at com.hibernate.StoreData.main(StoreData.java:32)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:xe
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
... 5 more


Please reply soon.
Thanks:
Image Created0Down
By: [email protected] On: Thu Dec 26 08:34:34 IST 2013 Question Reputation0 Answer Reputation0 Belt Series Points0 0User Image
Are You Satisfied :1Yes2No
 
Same exception i got but resolved.Kindly check once driver class name and username and password.If u get again write a simple core java program to establish jDBC connection by using what ever parameters u have been used for hibernate and check.Image Created0Down
By: [email protected] On: Thu Sep 04 08:48:13 IST 2014 Question Reputation0 Answer Reputation0 Belt Series Points0 0User Image
Are You Satisfied :0Yes0No
 
Kindly check once driver class name and username and password.If u r not able to get once done kindly write simple java program and test the connection establishing or not.Image Created0Down
By: [email protected] On: Thu Sep 04 08:49:10 IST 2014 Question Reputation0 Answer Reputation0 Belt Series Points0 0User Image
Are You Satisfied :0Yes0No
 
yes i'm also getting same exception

if anyone have resolved then try to instruct me

thanks in advance 		Image Created0Down
By: [email protected] On: Thu Oct 29 11:43:53 IST 2015 Question Reputation0 Answer Reputation0 Belt Series Points0 0User Image
Are You Satisfied :0Yes0No
 
I am also getting same problem ..please help me...

I am using oracle 11g database		Image Created0Down
By: [email protected] On: Sat May 28 19:06:54 IST 2016 Question Reputation0 Answer Reputation0 Belt Series Points0 0User Image
Are You Satisfied :0Yes0No