GeneXus - Problema Conexion DataStore DB2 for iSeries

   
Vista:

Problema Conexion DataStore DB2 for iSeries

Publicado por ENRIQUE (39 intervenciones) el 17/04/2013 22:59:20
Hola a todos . Alguien podria ayudarme respecto a lo siguiente?
cree un datastore (DB2 for iseries) para conectarme a una base de datos que esta en el sistema AIX.

estoy usando Genexus X Evol2 y genero con Java, usando Oracle

el error que tengo al hacer un test conection es el siguiente:}

HTTP Status 500 - java.sql.SQLException: The application requester cannot establish the connection. (Connection refused: connect)

--------------------------------------------------------------------------------

type Exception report

message java.sql.SQLException: The application requester cannot establish the connection. (Connection refused: connect)

description The server encountered an internal error that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: java.sql.SQLException: The application requester cannot establish the connection. (Connection refused: connect)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2856)
at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1242)
at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1105)
at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:355)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.genexus.db.driver.GXConnection$1.run(Unknown Source)
at com.genexus.platform.NativeFunctions11.executeWithPermissions(Unknown Source)
at com.genexus.db.driver.GXConnection.connectJDBCDriver(Unknown Source)
at com.genexus.db.driver.GXConnection.connect(Unknown Source)
at com.genexus.db.driver.GXConnection.<init>(Unknown Source)
at com.genexus.db.driver.GXConnection.<init>(Unknown Source)
at com.genexus.db.driver.ReadWriteConnectionPool.createConnection(Unknown Source)
at com.genexus.db.driver.ConnectionPool.checkOut(Unknown Source)
at com.genexus.db.driver.DataSourceConnectionPool.checkOut(Unknown Source)
at com.genexus.db.ServerUserInformation.getConnection(Unknown Source)
at com.genexus.db.ServerDBConnectionManager.getConnection(Unknown Source)
at com.genexus.db.DefaultConnectionProvider.getConnection(Unknown Source)
at com.genexus.db.DataStoreProviderBase.getConnection(Unknown Source)
at com.genexus.db.SentenceProvider.getPreparedStatement(Unknown Source)
at com.genexus.db.ForEachCursor.preExecute(Unknown Source)
at com.genexus.db.DataStoreProvider.execute(Unknown Source)
at com.genexus.db.DataStoreProvider.execute(Unknown Source)
at gx0070_impl.rf0B2(gx0070_impl.java:535)
at gx0070_impl.refresh(gx0070_impl.java:516)
at gx0070_impl.we0B2(gx0070_impl.java:456)
at gx0070_impl.renderHtmlContent(gx0070_impl.java:241)
at promptmasterpage_impl.wb_table2_8_032(promptmasterpage_impl.java:598)
at promptmasterpage_impl.wb_table1_2_032(promptmasterpage_impl.java:336)
at promptmasterpage_impl.wb030(promptmasterpage_impl.java:100)
at promptmasterpage_impl.rf032(promptmasterpage_impl.java:265)
at promptmasterpage_impl.refresh(promptmasterpage_impl.java:253)
at promptmasterpage_impl.we032(promptmasterpage_impl.java:230)
at promptmasterpage_impl.webExecute(promptmasterpage_impl.java:58)
at gx0070_impl.webExecute(gx0070_impl.java:123)
at com.genexus.webpanels.GXWebObjectBase.doExecute(Unknown Source)
at gx0070.doExecute(gx0070.java:21)
at com.genexus.webpanels.GXWebObjectStub.callDoExecute(Unknown Source)
at com.genexus.webpanels.GXWebObjectStub.callExecute(Unknown Source)
at com.genexus.webpanels.GXWebObjectStub.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.genexus.filters.ExpiresFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1822)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

com.genexus.webpanels.GXWebObjectStub.callExecute(Unknown Source)
com.genexus.webpanels.GXWebObjectStub.doGet(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
com.genexus.filters.ExpiresFilter.doFilter(Unknown Source)


note The full stack trace of the root cause is available in the Apache Tomcat/7.0.35 logs.

--------------------------------------------------------------------------------
Apache Tomcat/7.0.35


toda ayuda es bienvenida. Mil gracicas desde ya!. saludos cordiales

ENRIQUE
Valora esta pregunta
Me gusta: Está pregunta es útil y esta claraNo me gusta: Está pregunta no esta clara o no es útil
0
Responder

Problema Conexion DataStore DB2 for iSeries

yo te ayudo

tienes varios errores

1 se actualizo tu java (jdk)
y no corresponde al tomcat

hay que regresar al instaldor original del java (jdk)

2 tu error de conexion a bd es por los puertos
y/o firewall te puedo ayudar via teamviewer

ojitosverdes77@hotmail.com

contactame
Valora esta respuesta
Me gusta: Está respuesta es útil y esta claraNo me gusta: Está respuesta no esta clara o no es útil
0
Comentar