Skip to main content
J
jdavenport11
Inspiring
July 9, 2013
Question

CF 10 Datasource to Unidata Database will not connect

  • July 9, 2013
  • 1 reply
  • 1705 views

I am trying to upgrade an existing system from CF 8 to CF 10.  I have a datasource that connects to a Unidata database.  The datasource connects on the CF 8 server using driver class com.ibm.u2.jdbc.UniJDBCDriver and driver uniJDBC.  I set the datasource up on CF 10 the same way it is set up on CF 8.  I copied over the unijdbc.jar and asjava.zip files from /opt/coldfusion8/wwwroot/WEB-INF/classes on the old server and put them in /opt/coldfusion10/cfusion/wwwroot/WEB-INF/classes on the new server.  I updated the Coldfusion Class Path to

/opt/coldfusion10/cfusion/wwwroot/WEB-INF/classes/unijdbc.jar,/opt/coldfusion10/cfusion/wwwroot/WEB-INF/classes/asjava.zip,"%CLASSPATH%"

on the Java & JVM settings page in the CF 10 Administrator and restarted coldfusion before I tried adding the datasource.  When I try to verify the datasource I get this error:

Connection verification failed for data source: colleague

java.lang.AbstractMethodError: com.ibm.u2.jdbc.UniJDBCDatabaseMetaData.getJDBCMajorVersion()I

The root cause was that: java.lang.AbstractMethodError: com.ibm.u2.jdbc.UniJDBCDatabaseMetaData.getJDBCMajorVersion()I

The database I am connecting to has not changed, it is still the same version and in the same location.  What exactly does this error mean?  Would I need updated versions of the unijdbc.jar and asjava.zip files to go with CF 10, even though the database has not changed?

Thanks in advance for any help,

Julie

    This topic has been closed for replies.

    1 reply

    J
    jdavenport11Author
    Inspiring
    July 15, 2013

    When I try to verify the datasource, I get this error stack in the exception.log file, perhaps this means something to someone?  thanks...

    "Error","ajp-bio-8012-exec-30","07/15/13","10:21:46",,""

    java.lang.AbstractMethodError

            at coldfusion.server.j2ee.sql.JRunConnection.<init>(JRunConnection.java:133)

            at coldfusion.server.j2ee.sql.pool.JDBCPool.create(JDBCPool.java:555)

            at coldfusion.server.j2ee.sql.pool.JDBCPool._checkOut(JDBCPool.java:472)

            at coldfusion.server.j2ee.sql.pool.JDBCPool.checkOut(JDBCPool.java:378)

            at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:825)

            at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:125)

            at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:135)

            at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:42)

            at coldfusion.sql.Executive.verifyDatasource(Executive.java:492)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:597)

            at coldfusion.runtime.StructBean.invoke(StructBean.java:508)

            at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2465)

            at cfudflibrary2ecfm1867463752$funcVERIFYDSN.runFunction(E:\cf10_final\cfusion\wwwroot\CFIDE\administrator\datasources\udflibrary.cfm:14)

            at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)

            at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)

            at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)

            at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)

            at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)

            at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2624)

            at cfindex2ecfm782328217._factor12(E:\cf10_final\cfusion\wwwroot\CFIDE\administrator\datasources\index.cfm:450)

            at cfindex2ecfm782328217._factor17(E:\cf10_final\cfusion\wwwroot\CFIDE\administrator\datasources\index.cfm:396)

            at cfindex2ecfm782328217._factor18(E:\cf10_final\cfusion\wwwroot\CFIDE\administrator\datasources\index.cfm:168)

            at cfindex2ecfm782328217.runPage(E:\cf10_final\cfusion\wwwroot\CFIDE\administrator\datasources\index.cfm:1)

            at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)

            at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)

            at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)

            at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)

            at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:443)

            at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)

            at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)

            at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)

            at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)

            at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)

            at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)

            at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)

            at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)

            at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)

            at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)

            at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151)

            at coldfusion.CfmServlet.service(CfmServlet.java:204)

            at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

            at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)

            at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)

            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

            at coldfusion.filter.ClickjackingProtectionFilter.doFilter(ClickjackingProtectionFilter.java:75)

            at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)

            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:224)

            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)

            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

            at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)

            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)

            at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:203)

            at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)

            at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)

            at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

            at java.lang.Thread.run(Thread.java:662)

    Priyank Shrivastava.
    Priyank Shrivastava.
    Inspiring
    July 15, 2013

    Hi,

    Can you please copy this jar file to this location and try again.

    ,/opt/col dfusion10/cfusion/runtime/lib/

    restart the service and try to create the connection again.

    Regards,

    Priyank

    Thanks, Priyank Shrivastava
    J
    jdavenport11Author
    Inspiring
    July 16, 2013

    Hello,

    thank you very much for your suggestion.  I did try it, but still get this same error when try to verify the datasource:

    Connection verification failed for data source: colleague

    java.lang.AbstractMethodError: com.ibm.u2.jdbc.UniJDBCDatabaseMetaData.getJDBCMajorVersion()I

    The root cause was that: java.lang.AbstractMethodError: com.ibm.u2.jdbc.UniJDBCDatabaseMetaData.getJDBCMajorVersion()I

    and the following is seen in the /opt/coldfusion10/cfusion/logs/exception.log:

    "Error","ajp-bio-8012-exec-3","07/16/13","14:56:00",,"com.ibm.u2.jdbc.UniJDBCDatabaseMetaData.getJDBCMajorVersion()I"
    java.lang.AbstractMethodError: com.ibm.u2.jdbc.UniJDBCDatabaseMetaData.getJDBCMajorVersion()I
            at coldfusion.server.j2ee.sql.JRunConnection.<init>(JRunConnection.java:133)
            at coldfusion.server.j2ee.sql.pool.JDBCPool.create(JDBCPool.java:555)
            at coldfusion.server.j2ee.sql.pool.JDBCPool._checkOut(JDBCPool.java:472)
            at coldfusion.server.j2ee.sql.pool.JDBCPool.checkOut(JDBCPool.java:378)
            at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:825)
            at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:125)
            at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:135)
            at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:42)
            at coldfusion.sql.Executive.verifyDatasource(Executive.java:492)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:597)
            at coldfusion.runtime.StructBean.invoke(StructBean.java:508)
            at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2465)
            at cfudflibrary2ecfm1867463752$funcVERIFYDSN.runFunction(E:\cf10_final\cfusion\wwwroot\CFIDE\administrator\datasources\udflibrary.cfm:14)
            at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
            at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
            at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
            at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
            at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
            at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2624)
            at cfindex2ecfm782328217._factor12(E:\cf10_final\cfusion\wwwroot\CFIDE\administrator\datasources\index.cfm:450)
            at cfindex2ecfm782328217._factor17(E:\cf10_final\cfusion\wwwroot\CFIDE\administrator\datasources\index.cfm:396)
            at cfindex2ecfm782328217._factor18(E:\cf10_final\cfusion\wwwroot\CFIDE\administrator\datasources\index.cfm:168)
            at cfindex2ecfm782328217.runPage(E:\cf10_final\cfusion\wwwroot\CFIDE\administrator\datasources\index.cfm:1)
            at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
            at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
            at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
            at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
            at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:443)
            at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
            at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
            at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
            at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
            at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
            at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
            at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
            at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
            at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
            at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
            at coldfusion.CfmServlet.service(CfmServlet.java:204)
            at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
            at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
            at coldfusion.filter.ClickjackingProtectionFilter.doFilter(ClickjackingProtectionFilter.java:75)
            at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
            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:224)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
            at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
            at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:203)
            at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
            at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
            at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
            at java.lang.Thread.run(Thread.java:662)

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices