net.sf.hibernate.exception.GenericJDBCException: Could not execute query

Atlassian JIRA | Nick Minutello | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    We have a few issues with this re-indexing ... CONF-3977 (http://support.atlassian.com/browse/CSP-1450) and now this. Basically, when we re-index, we end up running out of cursors - get loads of the errors below: We had to set the number of open cursors limit (limit per connection) to the rather ridiculous value of 2000 before we could get a successful re-index completion. And when the re-index was completed, we had 5518 open cursors remaining... which kinda suggests some kind of leakage... So, I am not sure if the two are related... but I get the feeling they are... ======================================================= INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,561 ERROR [core.persistence.hibernate.AnyTypeHibernateObjectDao] Unable to get objects: Could not execute query INFO | jvm 1 | 2005/10/01 16:22:53 | net.sf.hibernate.exception.GenericJDBCException: Could not execute query INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1531) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1523) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getObjects(HibernateEntityObjectQueue.java:84) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getNextObjects(HibernateEntityObjectQueue.java:54) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.search.lucene.BatchIndexingThread.getNextObject(BatchIndexingThread.java:150) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.search.lucene.BatchIndexingThread.run(BatchIndexingThread.java:40) INFO | jvm 1 | 2005/10/01 16:22:53 | at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source) INFO | jvm 1 | 2005/10/01 16:22:53 | at java.lang.Thread.run(Thread.java:534) INFO | jvm 1 | 2005/10/01 16:22:53 | Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:815) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4C8TTILob.getLength(T4C8TTILob.java:260) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CConnection.length(T4CConnection.java:1896) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.sql.CLOB.length(CLOB.java:184) INFO | jvm 1 | 2005/10/01 16:22:53 | at org.springframework.jdbc.support.lob.OracleLobHandler.getClobAsString(OracleLobHandler.java:184) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.util.BucketClobStringType.nullSafeGet(BucketClobStringType.java:120) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.type.CustomType.nullSafeGet(CustomType.java:92) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:67) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.hydrate(Loader.java:690) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:631) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:590) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.getRow(Loader.java:505) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:218) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doQuery(Loader.java:285) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.list(Loader.java:1054) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554) INFO | jvm 1 | 2005/10/01 16:22:53 | ... 8 more

    Atlassian JIRA | 1 decade ago | Nick Minutello
    net.sf.hibernate.exception.GenericJDBCException: Could not execute query
  2. 0

    We have a few issues with this re-indexing ... CONF-3977 (http://support.atlassian.com/browse/CSP-1450) and now this. Basically, when we re-index, we end up running out of cursors - get loads of the errors below: We had to set the number of open cursors limit (limit per connection) to the rather ridiculous value of 2000 before we could get a successful re-index completion. And when the re-index was completed, we had 5518 open cursors remaining... which kinda suggests some kind of leakage... So, I am not sure if the two are related... but I get the feeling they are... ======================================================= INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,561 ERROR [core.persistence.hibernate.AnyTypeHibernateObjectDao] Unable to get objects: Could not execute query INFO | jvm 1 | 2005/10/01 16:22:53 | net.sf.hibernate.exception.GenericJDBCException: Could not execute query INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1531) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1523) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getObjects(HibernateEntityObjectQueue.java:84) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getNextObjects(HibernateEntityObjectQueue.java:54) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.search.lucene.BatchIndexingThread.getNextObject(BatchIndexingThread.java:150) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.search.lucene.BatchIndexingThread.run(BatchIndexingThread.java:40) INFO | jvm 1 | 2005/10/01 16:22:53 | at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source) INFO | jvm 1 | 2005/10/01 16:22:53 | at java.lang.Thread.run(Thread.java:534) INFO | jvm 1 | 2005/10/01 16:22:53 | Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:815) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4C8TTILob.getLength(T4C8TTILob.java:260) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CConnection.length(T4CConnection.java:1896) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.sql.CLOB.length(CLOB.java:184) INFO | jvm 1 | 2005/10/01 16:22:53 | at org.springframework.jdbc.support.lob.OracleLobHandler.getClobAsString(OracleLobHandler.java:184) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.util.BucketClobStringType.nullSafeGet(BucketClobStringType.java:120) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.type.CustomType.nullSafeGet(CustomType.java:92) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:67) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.hydrate(Loader.java:690) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:631) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:590) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.getRow(Loader.java:505) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:218) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doQuery(Loader.java:285) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.list(Loader.java:1054) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554) INFO | jvm 1 | 2005/10/01 16:22:53 | ... 8 more

    Atlassian JIRA | 1 decade ago | Nick Minutello
    net.sf.hibernate.exception.GenericJDBCException: Could not execute query
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    java.sql.SQLException: No value specified for parameter 1解决办法_IT知识问答_希赛网

    educity.cn | 2 years ago
    java.sql.SQLException: No value specified for parameter 1 代码如下 public boolean login(UserInfo user)throws Exception{ //用户登录 boolean flag=false; int userNo=Integer.parseInt(user.getUserNo()); String password=user.getPassword(); //测试是否从现在的user对象中取到了值 System.out.println(userNo+"我是USER对象的userNo"); System.out.println(password+"我是USER对象的password"); DatabaseConnection dbc=new DatabaseConnection();//取得数据库连接和关闭对象; try{ String sql="SELECT userNo FROM userInfo where userNo= and password= "; this.conn=dbc.getConnection(); this.pst=conn.prepareStatement(sql); //this.pst.setInt(1, userNo);//给sql中参数赋值 this.pst.setLong(1, userNo); this.pst.setString(2, password); ResultSet rs=pst.executeQuery(); if(rs.next()){//传入用户账号和对应的密码都存在时为真 flag=true; System.out.println(rs.getString(userNo)+"我是从数据库里取出来的"); System.out.print(flag+"测试flag");//测试flag,看是否进入了if里面,true则进入了 rs.close(); } }catch(Exception e){ e.printStackTrace(); }finally{ if(this.pst!=null){ this.pst.close(); } this.conn.close(); } return flag; } 报的错误信息如:
  5. 0

    java.sql.SQLException: No suitable driver - Toolbox for IT Groups

    ittoolbox.com | 9 months ago
    java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager .java:545) at java.sql.DriverManager.getConnection(DriverManager .java:171) at com.stc.sql.framework.jdbc.DBConnectionFactory.cre ateConnection(DBConnectionFactory.java:372) at com.stc.sql.framework.jdbc.DBConnectionFactory.get Connection(DBConnectionFactory.java:281) at com.stc.etl.engine.impl.SimpleTask.getConnection(S impleTask.java:254) at com.stc.etl.engine.impl.Extractor.getSelectData(Ex tractor.java:376) at com.stc.etl.engine.impl.Extractor.process(Extracto r.java:190) at com.stc.etl.engine.impl.ETLTaskThread.run(ETLTaskT hread.java:147)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-01000: maximum open cursors exceeded ORA-01000: maximum open cursors exceeded

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      CLOB.length
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      4. oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:815)
      5. oracle.jdbc.driver.T4C8TTILob.getLength(T4C8TTILob.java:260)
      6. oracle.jdbc.driver.T4CConnection.length(T4CConnection.java:1896)
      7. oracle.sql.CLOB.length(CLOB.java:184)
      7 frames
    3. Spring Framework
      OracleLobHandler.getClobAsString
      1. org.springframework.jdbc.support.lob.OracleLobHandler.getClobAsString(OracleLobHandler.java:184)
      1 frame
    4. bucket.util
      BucketClobStringType.nullSafeGet
      1. bucket.util.BucketClobStringType.nullSafeGet(BucketClobStringType.java:120)
      1 frame
    5. net.sf.hibernate
      SessionImpl.find
      1. net.sf.hibernate.type.CustomType.nullSafeGet(CustomType.java:92)
      2. net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:67)
      3. net.sf.hibernate.loader.Loader.hydrate(Loader.java:690)
      4. net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:631)
      5. net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:590)
      6. net.sf.hibernate.loader.Loader.getRow(Loader.java:505)
      7. net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:218)
      8. net.sf.hibernate.loader.Loader.doQuery(Loader.java:285)
      9. net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
      10. net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
      11. net.sf.hibernate.loader.Loader.list(Loader.java:1054)
      12. net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
      13. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
      14. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1531)
      15. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1523)
      15 frames
    6. bucket.core.persistence
      HibernateEntityObjectQueue.getNextObjects
      1. bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getObjects(HibernateEntityObjectQueue.java:84)
      2. bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getNextObjects(HibernateEntityObjectQueue.java:54)
      2 frames
    7. bucket.search.lucene
      BatchIndexingThread.run
      1. bucket.search.lucene.BatchIndexingThread.getNextObject(BatchIndexingThread.java:150)
      2. bucket.search.lucene.BatchIndexingThread.run(BatchIndexingThread.java:40)
      2 frames
    8. Dough Lea's util.concurrent package
      PooledExecutor$Worker.run
      1. EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
      1 frame
    9. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame