Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Since upgrade to SGWT 12 application throws informix exception

    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)

    Last edited by siegersallee; 18 Sep 2018, 09:42.

    #2
    We have already responded to you multiple times here. Please continue with that thread.

    Please do not create a new thread for the same issue - when you do this it may be assigned to another engineer, who will look at it fresh, wasting time. This is particularly bad, because in this new thread, you failed to mention that the likely cause was already determined in that other thread.

    Comment

    Working...
    X