Hello everybody,
I am having the following problem:
When I execute the code below is generated an error referent to JDBC connection,
The error is generated when I execute this snippet of code into of a loop (several and several times) .
This problem be ocurring because the command "Configuration.releaseRootApplicationModule(am, true);" isn't releasing the connections.
Our friend "*Frank Nimphius*" through the link "http://forums.oracle.com/forums/thread.jspa?threadID=458356"
have oriented to do some configurations in the ApplicationModule, I have done, however I don't got successful.
Anyone can help me?
private void adicionaRegistroIcatbEstacaoComView(Estacao estacaoAcess){
String appModule = "hidro2.gov.snirh.ig.hidro.model.adf.app.AppModuleEstacao";
String config = "AppModuleEstacaoLocal"; // Config name
String viewObject = "IcatbEstacaoEnViewUp1";
ApplicationModule am = null;
try{
am = (ApplicationModule)Configuration.createRootApplicationModule(appModule, config);
ViewObject vo = am.findViewObject(viewObject);
Row row = vo.createRow();
row.setAttribute("EstId", estacaoAcess.getEstId());
row.setAttribute("EstNm" , estacaoAcess.getEstNm());
row.setAttribute("EstStrId",estacaoAcess.getEstStrId());
row.setAttribute("EstCdFlu", estacaoAcess.getEstCdFlu());
row.setAttribute("EstCdPlu", estacaoAcess.getEstCdPlu());
row.setAttribute("EstIcCampanha", 0);
vo.getApplicationModule().getTransaction().commit();
//try to release the INACTIVE connection
Configuration.releaseRootApplicationModule(am, true);
am.remove();
} catch (Exception e) {
e.printStackTrace();
}
}
Error generated:
Caused by: oracle.net.ns.NetException: Got minus one from a read call
at oracle.net.ns.Packet.receive(Packet.java:296)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:295)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1056)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
... 99 more
## Detail 0 ##
java.sql.SQLRecoverableException: Erro de ES: Got minus one from a read call
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:538)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:144)
at oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)
at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:195)
at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:166)
at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:590)
at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:323)
at oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:102)
at oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:66)
at oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolManagerImpl.java:52)
at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:129)
at oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:996)
at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1165)
at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:6728)
at oracle.jbo.server.DBTransactionImpl2.connect(DBTransactionImpl2.java:132)
at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:213)
at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:576)
at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:419)
at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:8933)
at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4496)
at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2458)
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2270)
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3168)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:460)
at oracle.jbo.http.HttpSessionCookieImpl.useApplicationModule(HttpSessionCookieImpl.java:234)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:431)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:426)
at oracle.jbo.client.Configuration.getApplicationModule(Configuration.java:1606)
at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1511)
at oracle.jbo.client.Configuration.createRootApplicationModule(Configuration.java:1482)
at hidro2.gov.snirh.ig.hidro.view.controller.importaDadosController.ImportarMDBController.retornarMaxId(ImportarMDBController.java:1128)
at hidro2.gov.snirh.ig.hidro.view.controller.importaDadosController.ImportarMDBController.preencheBeanEstacaoAcess(ImportarMDBController.java:159)
at hidro2.gov.snirh.ig.hidro.view.controller.importaDadosController.ImportarMDBController.inserirDados(ImportarMDBController.java:127)
at hidro2.gov.snirh.ig.hidro.view.controller.importaDadosController.ImportarMDBController.importarButton(ImportarMDBController.java:1102)
at hidro2.gov.snirh.ig.hidro.view.adf.intercambio.ImportarMDB$3.actionPerformed(ImportarMDB.java:247)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6267)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6032)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
at java.awt.Dialog$1.run(Dialog.java:1046)
at java.awt.Dialog$3.run(Dialog.java:1098)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Dialog.java:1096)
at java.awt.Component.show(Component.java:1563)
at java.awt.Component.setVisible(Component.java:1515)
at java.awt.Window.setVisible(Window.java:842)
at java.awt.Dialog.setVisible(Dialog.java:986)
at hidro2.gov.snirh.ig.hidro.view.MaquinaDeNavegacao.openImportarMDBPanelEdit(MaquinaDeNavegacao.java:1148)
at hidro2.gov.snirh.ig.hidro.view.Ouvidoria$ImportarMDBActionListener.actionPerformed(Ouvidoria.java:16056)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1223)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1264)
at java.awt.Component.processMouseEvent(Component.java:6267)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6032)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: oracle.net.ns.NetException: Got minus one from a read call
at oracle.net.ns.Packet.receive(Packet.java:296)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:295)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1056)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
... 99 more
Thanks in advance.
Edited by: Le on 03/08/2011 12:56