1. SmartGWTEE 2.5p / SmartGWTEE 3.0p
2. Internet Explorer
3. server.properties (to connect to Oracle 11)
sql.defaultDatabase: ORACLE
sql.ORACLE.database.type: oracle
sql.ORACLE.interface.type: driverManager
sql.ORACLE.pool.enabled: true
sql.ORACLE.interface.credentialsInURL: false
sql.ORACLE.driver: oracle.jdbc.OracleDriver
sql.ORACLE.driverName: oracle
sql.ORACLE.driver.url: jdbc:oracle:thin:@{hostname}:{port}/{SID}
sql.ORACLE.driver.user: {username}
sql.ORACLE.driver.password: {password}
I replaced {hostname}, {port}, {SID}, {username} and {password}.
4. Use Oracle JDBC Driver version - "10.2.0.5.0"
{myproject}\war\WEB-INF\lib\ojdbc14.jar exists.
5. Log
=== 2012-10-30 17:21:39,041 [60-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.shipunit_fetch] oracle.jdbc.OracleDriver lookup successful
=== 2012-10-30 17:21:39,042 [60-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.shipunit_fetch] DriverManager fetching connection for ORACLE via jdbc url jdbc:oracle:thin:@10.10.10.70:1521/TMSDEV11
=== 2012-10-30 17:21:39,043 [60-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.shipunit_fetch] Passing credentials getConnection separately from JDBC URL
=== 2012-10-30 17:21:41,206 [60-3] ERROR SQLConnectionManager - [builtinApplication.shipunit_fetch] Caught exception
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)
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:802)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.isomorphic.sql.PoolableSQLConnectionFactory.makeUnpooledObject(PoolableSQLConnectionFactory.java:237)
at com.isomorphic.sql.PoolableSQLConnectionFactory.makeObject(PoolableSQLConnectionFactory.java:339)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:74)
at com.isomorphic.sql.SQLConnectionManager.getConnection(SQLConnectionManager.java:150)
at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:300)
at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:277)
at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:271)
at com.isomorphic.sql.SQLDriver.getScalarResult(SQLDriver.java:364)
at com.isomorphic.sql.SQLDriver.executeScalar(SQLDriver.java:569)
at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:1482)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1287)
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:280)
at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:224)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:1229)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:721)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
at com.isomorphic.application.AppBase.execute(AppBase.java:491)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1775)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:199)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:156)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:121)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.api.socket.dev.DevSocketFilter.doFilter(DevSocketFilter.java:74)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.tools.development.ResponseRewriterFilter.doFilter(ResponseRewriterFilter.java:110)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:34)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:61)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:43)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.tools.development.StaticFileFilter.doFilter(StaticFileFilter.java:125)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.tools.development.BackendServersFilter.doFilter(BackendServersFilter.java:97)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
at com.google.appengine.tools.development.DevAppEngineWebAppContext.handle(DevAppEngineWebAppContext.java:94)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at com.google.appengine.tools.development.JettyContainerService$ApiProxyHandler.handle(JettyContainerService.java:380)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:755)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
6. war\ds\shipunit.ds.xml
<DataSource
ID="shipunit"
serverType="sql"
tableName="SHIPUNITS"
>
<fields>
<field name="shipunitID" type="integer" title="Ship Unit Id" primaryKey="true"/>
<field name="shipunitNO" type="text" title="Ship Unit No" required="true"/>
<field name="weight" type="integer" title="Weight" required="true"/>
</fields>
</DataSource>
In Oracle database, I have a table called 'SHIPUNITS' (with the above 3 columns).
7. Source Code
public void onModuleLoad() {
final ListGrid listGrid = new ListGrid();
listGrid.setWidth(700);
listGrid.setHeight(224);
listGrid.setAlternateRecordStyles(true);
listGrid.setDataSource(DataSource.get("shipunit"));
listGrid.setAutoFetchData(true);
listGrid.setShowFilterEditor(true);
listGrid.setCanEdit(true);
listGrid.setCanRemoveRecords(true);
VLayout layout = new VLayout(15);
layout.addMember(listGrid);
layout.draw();
}
Any clue why I am getting "The Network Adapter could not establish the connection"?
2. Internet Explorer
3. server.properties (to connect to Oracle 11)
sql.defaultDatabase: ORACLE
sql.ORACLE.database.type: oracle
sql.ORACLE.interface.type: driverManager
sql.ORACLE.pool.enabled: true
sql.ORACLE.interface.credentialsInURL: false
sql.ORACLE.driver: oracle.jdbc.OracleDriver
sql.ORACLE.driverName: oracle
sql.ORACLE.driver.url: jdbc:oracle:thin:@{hostname}:{port}/{SID}
sql.ORACLE.driver.user: {username}
sql.ORACLE.driver.password: {password}
I replaced {hostname}, {port}, {SID}, {username} and {password}.
4. Use Oracle JDBC Driver version - "10.2.0.5.0"
{myproject}\war\WEB-INF\lib\ojdbc14.jar exists.
5. Log
=== 2012-10-30 17:21:39,041 [60-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.shipunit_fetch] oracle.jdbc.OracleDriver lookup successful
=== 2012-10-30 17:21:39,042 [60-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.shipunit_fetch] DriverManager fetching connection for ORACLE via jdbc url jdbc:oracle:thin:@10.10.10.70:1521/TMSDEV11
=== 2012-10-30 17:21:39,043 [60-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.shipunit_fetch] Passing credentials getConnection separately from JDBC URL
=== 2012-10-30 17:21:41,206 [60-3] ERROR SQLConnectionManager - [builtinApplication.shipunit_fetch] Caught exception
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454)
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:802)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.isomorphic.sql.PoolableSQLConnectionFactory.makeUnpooledObject(PoolableSQLConnectionFactory.java:237)
at com.isomorphic.sql.PoolableSQLConnectionFactory.makeObject(PoolableSQLConnectionFactory.java:339)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:74)
at com.isomorphic.sql.SQLConnectionManager.getConnection(SQLConnectionManager.java:150)
at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:300)
at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:277)
at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:271)
at com.isomorphic.sql.SQLDriver.getScalarResult(SQLDriver.java:364)
at com.isomorphic.sql.SQLDriver.executeScalar(SQLDriver.java:569)
at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:1482)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1287)
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:280)
at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:224)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:1229)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:721)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
at com.isomorphic.application.AppBase.execute(AppBase.java:491)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:1775)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:199)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:156)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:121)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:259)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.api.socket.dev.DevSocketFilter.doFilter(DevSocketFilter.java:74)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.tools.development.ResponseRewriterFilter.doFilter(ResponseRewriterFilter.java:110)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.tools.development.HeaderVerificationFilter.doFilter(HeaderVerificationFilter.java:34)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.api.blobstore.dev.ServeBlobFilter.doFilter(ServeBlobFilter.java:61)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.apphosting.utils.servlet.TransactionCleanupFilter.doFilter(TransactionCleanupFilter.java:43)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.tools.development.StaticFileFilter.doFilter(StaticFileFilter.java:125)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at com.google.appengine.tools.development.BackendServersFilter.doFilter(BackendServersFilter.java:97)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:418)
at com.google.appengine.tools.development.DevAppEngineWebAppContext.handle(DevAppEngineWebAppContext.java:94)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at com.google.appengine.tools.development.JettyContainerService$ApiProxyHandler.handle(JettyContainerService.java:380)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:755)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
6. war\ds\shipunit.ds.xml
<DataSource
ID="shipunit"
serverType="sql"
tableName="SHIPUNITS"
>
<fields>
<field name="shipunitID" type="integer" title="Ship Unit Id" primaryKey="true"/>
<field name="shipunitNO" type="text" title="Ship Unit No" required="true"/>
<field name="weight" type="integer" title="Weight" required="true"/>
</fields>
</DataSource>
In Oracle database, I have a table called 'SHIPUNITS' (with the above 3 columns).
7. Source Code
public void onModuleLoad() {
final ListGrid listGrid = new ListGrid();
listGrid.setWidth(700);
listGrid.setHeight(224);
listGrid.setAlternateRecordStyles(true);
listGrid.setDataSource(DataSource.get("shipunit"));
listGrid.setAutoFetchData(true);
listGrid.setShowFilterEditor(true);
listGrid.setCanEdit(true);
listGrid.setCanRemoveRecords(true);
VLayout layout = new VLayout(15);
layout.addMember(listGrid);
layout.draw();
}
Any clue why I am getting "The Network Adapter could not establish the connection"?
Comment