Results 1 to 2 of 2

Thread: why connection is closed?

  1. #1
    Join Date
    Sep 2004
    Posts
    6

    Default why connection is closed?

    why connection is closed?
    Code:
    org.springframework.jdbc.UncategorizedSQLException: (executing StatementCallback): encountered SQLException [Connection is closed.]; nested exception is java.sql.SQLException: Connection is closed.
    	org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:94)
    	org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:281)
    	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:210)
    	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:266)
    	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:270)
    	com.bjhuajia.silver.dao.sqlserver.SchemaDao.getSchemaList(SchemaDao.java:173)
    	com.bjhuajia.silver.util.loader.SchemaLoader.load(SchemaLoader.java:29)
    	com.bjhuajia.silver.util.CacheConfig.load(CacheConfig.java:34)
    	com.bjhuajia.silver.util.CacheConfig.get(CacheConfig.java:46)
    	com.bjhuajia.silver.control.SilverServlet.init(SilverServlet.java:64)
    	org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:175)
    	org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
    	org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:207)
    	org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:647)
    	org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:497)
    	org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:575)
    	org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:649)
    	java.lang.Thread.run(Thread.java:536)

  2. #2
    Join Date
    Aug 2004
    Location
    Southampton, UK
    Posts
    826

    Default

    Any chance you could actually post the code? From the information you have provided I have absolutely no idea why the connection is closed.

    Rob

Similar Threads

  1. Connection closed after transaction commit
    By alirussi in forum Data
    Replies: 4
    Last Post: Dec 17th, 2011, 06:41 AM
  2. Replies: 6
    Last Post: May 25th, 2005, 01:56 AM
  3. Calling procedure when connection is 'got'
    By mlythgoe in forum Data
    Replies: 10
    Last Post: May 6th, 2005, 04:01 AM
  4. Replies: 7
    Last Post: Apr 15th, 2005, 08:43 PM
  5. Replies: 0
    Last Post: Apr 6th, 2005, 08:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •