SGWT: 12.0-p20180802
java 8
informix: 12.10.FC9E
We have just upgraded our SGWT from 5 to 12. We were using informix 12.10.FC9E and java 8 with SGWT 5 and all was well..
Now that we have upgraded to SGWT 12, we are getting this error in our gwt.logs:
Why is this happening ? If we take out the SGWT 12 libs and put the 5 back in, everything works.
According to IBM Informix:
-79757
Invalid sub-protocol
The current valid subprotocol supported by Informix is: informix-sqli.
In out server properties we stipulate
sql.cbcommon.driver.driverName: informix
sql.cbcommon.database.type: informix
sql.cbcommon.interface.type: driverManager
sql.cbcommon.driver.user: <user>
sql.cbcommon.driver.password: <password>
sql.cbcommon.interface.credentialsInURL: false
sql.cbcommon.driver.serverName: <Check connectionpool.properties>
sql.cbcommon.driver.portNumber: 9005
sql.cbcommon.driver.databaseName: <DBName>;
sql.cbcommon.driver: com.informix.jdbc.IfxDriver
is there property that we can set in this properties above to stipulate the subprotocol ?
=== 09/18/2018 13:18:59,319 - rcoleman [3-30] ERROR com.isomorphic.sql.SQLConnectionManager:213 - [builtinApplication.userPermiss
ionsDS_fetch] Caught exception while trying to obtain connection to server: cbcommon
java.sql.SQLException: Invalid sub-protocol Invalid sub-protocol: 'informix'
at com.informix.util.IfxErrMsg.getLocSQLException(IfxErrMsg.java:493)
at com.informix.jdbc.IfxDriver.a(IfxDriver.java:558)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:206)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.isomorphic.sql.SQLDriver.rawConnection(SQLDriver.java:815)
at com.isomorphic.sql.PoolableSQLConnectionFactory.makeUnpooledObject(PoolableSQLConnectionFactory.java:129)
at com.isomorphic.sql.PoolableSQLConnectionFactory.makeObject(PoolableSQLConnectionFactory.java:138)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
at com.isomorphic.pool.ISCObjectPool.borrowObject(ISCObjectPool.java:112)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:102)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:76)
at com.isomorphic.sql.SQLConnectionManager.getConnection(SQLConnectionManager.java:177)
at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:953)
at com.isomorphic.sql.SQLDriver.executeQuery(SQLDriver.java:1394)
at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:585)
at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:579)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1772)
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:439)
at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:384)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:2384)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:646)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:547)
at com.isomorphic.application.AppBase.execute(AppBase.java:490)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2835)
at eti.server.dmi.DMIBase.processDSRequest(DMIBase.java:90)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.isomorphic.base.Reflection._invokeMethod(Reflection.java:580)
at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:895)
at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:434)
at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2831)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:230)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:187)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:152)
at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:176)
java 8
informix: 12.10.FC9E
We have just upgraded our SGWT from 5 to 12. We were using informix 12.10.FC9E and java 8 with SGWT 5 and all was well..
Now that we have upgraded to SGWT 12, we are getting this error in our gwt.logs:
Why is this happening ? If we take out the SGWT 12 libs and put the 5 back in, everything works.
According to IBM Informix:
-79757
Invalid sub-protocol
The current valid subprotocol supported by Informix is: informix-sqli.
In out server properties we stipulate
sql.cbcommon.driver.driverName: informix
sql.cbcommon.database.type: informix
sql.cbcommon.interface.type: driverManager
sql.cbcommon.driver.user: <user>
sql.cbcommon.driver.password: <password>
sql.cbcommon.interface.credentialsInURL: false
sql.cbcommon.driver.serverName: <Check connectionpool.properties>
sql.cbcommon.driver.portNumber: 9005
sql.cbcommon.driver.databaseName: <DBName>;
sql.cbcommon.driver: com.informix.jdbc.IfxDriver
is there property that we can set in this properties above to stipulate the subprotocol ?
=== 09/18/2018 13:18:59,319 - rcoleman [3-30] ERROR com.isomorphic.sql.SQLConnectionManager:213 - [builtinApplication.userPermiss
ionsDS_fetch] Caught exception while trying to obtain connection to server: cbcommon
java.sql.SQLException: Invalid sub-protocol Invalid sub-protocol: 'informix'
at com.informix.util.IfxErrMsg.getLocSQLException(IfxErrMsg.java:493)
at com.informix.jdbc.IfxDriver.a(IfxDriver.java:558)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:206)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.isomorphic.sql.SQLDriver.rawConnection(SQLDriver.java:815)
at com.isomorphic.sql.PoolableSQLConnectionFactory.makeUnpooledObject(PoolableSQLConnectionFactory.java:129)
at com.isomorphic.sql.PoolableSQLConnectionFactory.makeObject(PoolableSQLConnectionFactory.java:138)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
at com.isomorphic.pool.ISCObjectPool.borrowObject(ISCObjectPool.java:112)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:102)
at com.isomorphic.pool.PoolManager.borrowObject(PoolManager.java:76)
at com.isomorphic.sql.SQLConnectionManager.getConnection(SQLConnectionManager.java:177)
at com.isomorphic.sql.SQLDriver.getTransformedResults(SQLDriver.java:953)
at com.isomorphic.sql.SQLDriver.executeQuery(SQLDriver.java:1394)
at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:585)
at com.isomorphic.sql.SQLDataSource.executeNativeQuery(SQLDataSource.java:579)
at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1772)
at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:439)
at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:384)
at com.isomorphic.datasource.DataSource.execute(DataSource.java:2384)
at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:646)
at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:547)
at com.isomorphic.application.AppBase.execute(AppBase.java:490)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2835)
at eti.server.dmi.DMIBase.processDSRequest(DMIBase.java:90)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.isomorphic.base.Reflection._invokeMethod(Reflection.java:580)
at com.isomorphic.base.Reflection.adaptArgsAndInvoke(Reflection.java:895)
at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:434)
at com.isomorphic.datasource.DataSourceDMI.execute(DataSourceDMI.java:64)
at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2831)
at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:230)
at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:187)
at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:152)
at com.isomorphic.servlet.IDACall._processRequest(IDACall.java:119)
at com.isomorphic.servlet.IDACall.doPost(IDACall.java:79)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:176)
Comment