Skip to Content
0
Jun 14, 2007 at 08:55 AM

Error Creating Excel File in Java

47 Views

Hi to All;

I use jxl.jar to create an excel file.

But After I have entered some records to database, Portal needs to be restart.

(I create excel file from portal database records). I saw this log information.

Thanks for your helps. Also if someone want to saw creating excel file. I can send it.

#1.5#00112529C72600740000053800006B74000432D85B775477

#1181804735718#com.sap.sql.jdbc.NativeConnectionFactory

#sap.com/BILIMBLOG_EAR#com.sap.sql.jdbc.

NativeConnectionFactory#xhbilgen#84169##bilepdev_D50

_19030650#xhbilgen#7142a1901a4511dcab9b00112529c726#

SAPEngine_Application_Thread[impl:3]_13##0#0#Error#1#

/System/Database/sql/jdbc#Java#com.sap.sql_0002##SQL error occurred on connection jdbc:oracle:thin:@bilepdev:1527:D50:

code=0, state="null", message="Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

".

[EXCEPTION]

#6#0#<null>#Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

#jdbc:oracle:thin:@bilepdev:1527:D50#<null>#java.sql.SQLException: Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException( DatabaseError.java:261)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection .<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection (NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java :285)

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:120)

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java :320)

at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:234)

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java :51)

at util.DbClass.getConnection(DbClass.java:33)

at util.DbClass.Read(DbClass.java:44)

at jsp_admin1180621474062._jspService(jsp_admin1180621474062.java:346)

at com.sap.engine.services.servlets_jsp.server.jsp.JspBase.service (JspBase.java:112)

at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:544)

at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:186)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest (HttpHandlerImpl.java:264)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java :325)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process (ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java :170)

#

#1.5#00112529C72600740000053900006B74000432D85B7758A2#1181804735734#com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl#sap.com/BILIMBLOG_EAR#com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl#xhbilgen#84169##bilepdev_D50_19030650#xhbilgen#7142a1901a4511dcab9b00112529c726#SAPEngine_Application_Thread[impl:3]_13##0#0#Error##Plain###ManagedConnectionFactoryImpl.createManagedConnection(): SQLException occured while creating ManagedConnection: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

#

#1.5#00112529C72600740000053B00006B74000432D85B787712#1181804735796#com.sap.engine.services.dbpool#sap.com/BILIMBLOG_EAR#com.sap.engine.services.dbpool#xhbilgen#84169##bilepdev_D50_19030650#xhbilgen#7142a1901a4511dcab9b00112529c726#SAPEngine_Application_Thread[impl:3]_13##0#0#Error#1#/System/Server#Java#dbpool_0300##ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

#3#ResourceException#ConnectionFactoryImpl.getConnection()#com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

#

#1.5#00112529C72600740000053C00006B74000432D85B7888D1#1181804735812#com.sap.engine.services.dbpool#sap.com/BILIMBLOG_EAR#com.sap.engine.services.dbpool#xhbilgen#84169##bilepdev_D50_19030650#xhbilgen#7142a1901a4511dcab9b00112529c726#SAPEngine_Application_Thread[impl:3]_13##0#0#Error#1#/System/Audit#Java###Exception #1#com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection (ConnectionFactoryImpl.java:59)

at util.DbClass.getConnection(DbClass.java:33)

at util.DbClass.Read(DbClass.java:44)

at jsp_admin1180621474062._jspService(jsp_admin1180621474062.java:346)

at com.sap.engine.services.servlets_jsp.server.jsp.JspBase.service (JspBase.java:112)

at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:544)

at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:186)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest (HttpHandlerImpl.java:264)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java :325)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process (ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java :170)

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:188)

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:320)

at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:234)

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:51)

... 21 more

Caused by: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:261)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection .<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection (NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java :285)

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:120)

... 24 more

#

#1.5#00112529C72600740000053D00006B74000432D85B788D80#1181804735812#System.err#sap.com/BILIMBLOG_EAR#System.err#xhbilgen#84169##bilepdev_D50_19030650#xhbilgen#7142a1901a4511dcab9b00112529c726#SAPEngine_Application_Thread[impl:3]_13##0#0#Error##Plain###com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection (ConnectionFactoryImpl.java:59)

at util.DbClass.getConnection(DbClass.java:33)

at util.DbClass.Read(DbClass.java:44)

at jsp_admin1180621474062._jspService(jsp_admin1180621474062.java:346)

at com.sap.engine.services.servlets_jsp.server.jsp.JspBase.service (JspBase.java:112)

at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:544)

at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:186)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest (HttpHandlerImpl.java:264)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java :325)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process (ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java :170)

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:188)

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:320)

at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:234)

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:51)

... 21 more

Caused by: java.sql.SQLException: Listener refused the connection with the following error:

ORA-12518, TNS:listener could not hand off client connection

The Connection descriptor used by the client was:

bilepdev:1527:D50

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:261)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection .<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection (NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java :285)

at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:120)

... 24 more

#

#1.5#00112529C72600740000053E00006B74000432D85B789A0D#1181804735812#com.sap.engine.services.servlets_jsp.client.RequestInfoServer#sap.com/BILIMBLOG_EAR#com.sap.engine.services.servlets_jsp.client.RequestInfoServer#xhbilgen#84169##bilepdev_D50_19030650#xhbilgen#7142a1901a4511dcab9b00112529c726#SAPEngine_Application_Thread[impl:3]_13##0#0#Error##Plain###Processing HTTP request to servlet [jsp] finished with error. The error is: java.lang.NullPointerException

at util.DbClass.Read(DbClass.java:45)

at jsp_admin1180621474062._jspService(jsp_admin1180621474062.java:346)

at com.sap.engine.services.servlets_jsp.server.jsp.JspBase.service (JspBase.java:112)

at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:544)

at com.sap.engine.services.servlets_jsp.server.servlet.JSPServlet.service(JSPServlet.java:186)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest (HttpHandlerImpl.java:264)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java :325)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process (ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java :170)

#

#1.5#00112529C72600740000054000006B74000432D85B789D00#1181804735812#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#sap.com/BILIMBLOG_EAR#com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl#xhbilgen#84169##bilepdev_D50_19030650#xhbilgen#7142a1901a4511dcab9b00112529c726#SAPEngine_Application_Thread[impl:3]_13##0#0#Error#1#/System/Server/WebRequests#Plain###Processing HTTP request to servlet [jsp] finished with error.

The error is: java.lang.NullPointerException: null

Exception id: [00112529C72600740000053E00006B74000432D85B789A0D]#

Message was edited by:

Eray