Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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)
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
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)
Copy link to clipboard
Copied
I have just found out from the vendor that the JDBC driver for unidata has a known issue and will not work with CF 10 and some other servers. I will be attempting an ODBC connection instead.
Copy link to clipboard
Copied
Hello,
Thank you for the update.
Regards,
Anit Kumar