Today about simple but burdensome exception from ADF model tester.
This exception is usually "guaranteed" when you try to run Model tester against non-Oracle database and do not set up your Model project properly:
C:\Oracle\Middleware2\Oracle_Home\oracle_common\jdk\bin\javaw.exe -server -classpath C:\Oracle\Middleware2\Oracle_Home\oracle_common\jdk\jre\lib\resources.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\jdk\jre\lib\rt.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\jdk\jre\lib\sunrsasign.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\jdk\jre\lib\jsse.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\jdk\jre\lib\jce.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\jdk\jre\lib\charsets.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\jdk\jre\lib\jfr.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\jdk\jre\classes;C:\JDeveloper\mywork\reposvn\FunZone1\.adf;C:\JDeveloper\mywork\reposvn\FunZone1\Model\classes;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.share_12.1.3\adf-share-support.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.share.ca_12.1.3\adf-share-ca.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.share.ca_12.1.3\adf-share-base.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.share_12.1.3\adflogginghandler.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.share_12.1.3\adfsharembean.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jmx_12.1.3\jmxframework.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jmx_12.1.3\jmxspi.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.idm_12.1.3\identitystore.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.model_12.1.3\adfm.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.model_12.1.3\bc4j-mbeans.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\groovy-all-2.1.6.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.xdk_12.1.3\xmlparserv2.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.model_12.1.3\db-ca.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.model_12.1.3\jdev-cm.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.ldap_12.1.3\ojmisc.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.share_12.1.3\commons-el.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.share_12.1.3\jsp-el-api.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.share_12.1.3\oracle-el.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.javatools_12.1.3\resourcebundle.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\javax.mail_2.0.0.0_1-4-4.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.model_12.1.3\adftransactionsdt.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.view_12.1.3\adf-dt-at-rt.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.model_12.1.3\adfdt_common.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.model_12.1.3\adflibrary.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.security_12.1.3\adf-share-security.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.security_12.1.3\adf-controller-security.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.mds_12.1.3\mdsrt.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.mds_12.1.3\oramds.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\javax.servlet_2.2.0.0_3-0.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\javax.jsp_4.0.0.0_2-2.jar;C:\Oracle\Middleware2\Oracle_Home\jdeveloper\ide\macros\..\..\..\oracle_common\modules\oracle.jdbc_12.1.0\ojdbc6dms.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\jlib\commons-cli-1.0.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.bali.share_12.1.3\share.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.xmlef_12.1.3\xmlef.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.dms_12.1.3\dms.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.xdk_12.1.3\xml.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.nlsrtl_12.1.0\orai18n.jar;C:\Oracle\Middleware2\Oracle_Home\coherence\lib\coherence.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.ucp_12.1.0.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.odl_12.1.3\ojdl.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.javatools_12.1.3\javatools-nodeps.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\javax.management.j2ee_1.2.0.0.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.toplink_12.1.3\eclipselink.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jdbc_12.1.0\ojdbc6dms.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.ldap_12.1.3\ldapjclnt11.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jps_12.1.3\jps-api.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jps_12.1.3\jps-common.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jps_12.1.3\jps-ee.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jps_12.1.3\jps-internal.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jps_12.1.3\jps-unsupported-api.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jps_12.1.3\jps-manifest.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jps_12.1.3\jacc-spi.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.pki_12.1.3\oraclepki.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.osdt_12.1.3\osdt_core.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.osdt_12.1.3\osdt_cert.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.osdt_12.1.3\osdt_xmlsec.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.osdt_12.1.3\osdt_ws_sx.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.iau_12.1.3\fmw_audit.jar;C:\Oracle\Middleware2\Oracle_Home\wlserver\modules\javax.security.jacc_1.2.0.0_1-1.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.model.generic_12.1.3\bc4jdomgnrc.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.view_12.1.3\dvt-jclient.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.view_12.1.3\dvt-utils.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.view_12.1.3\dvt-jclient-adf.jar;;C:\Oracle\Middleware2\Oracle_Home\jdeveloper\BC4J\jlib\bc4jtester.jar;C:\Oracle\Middleware2\Oracle_Home\jdeveloper\BC4J\jlib\bc4jrecorder.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.model_12.1.3\adfm-debugger.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.adf.model_12.1.3\regexp.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.help_5.0\ohj.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.help_5.0\help-share.jar;C:\Oracle\Middleware2\Oracle_Home\jdeveloper\jlib\jewt4.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.help_5.0\oracle_ice.jar;C:\Oracle\Middleware2\Oracle_Home\jdeveloper\ide\lib\idert.jar;C:\Oracle\Middleware2\Oracle_Home\jdeveloper\ide\lib\javatools.jar;C:\Oracle\Middleware2\Oracle_Home\jdeveloper\ide\lib\peek.jar;C:\Oracle\Middleware2\Oracle_Home\jdeveloper\ide\lib\uic.jar;C:\Oracle\Middleware2\Oracle_Home\jdeveloper\ide\lib\TimingFramework.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.javatools_12.1.3\oicons.jar;C:\Oracle\Middleware2\Oracle_Home\wlserver\server\lib\weblogic.jar;C:\Oracle\Middleware2\Oracle_Home\oracle_common\modules\oracle.jrf_12.1.3\jrf-api.jar;C:\Oracle\Middleware2\Oracle_Home\jdeveloper\BC4J\jlib\jpda-examples-1.6.0_21.jar; -Djavax.net.ssl.trustStore=C:\Users\Mariusz\AppData\Local\Temp\trustStore5333221060235758664.jks -XX:MaxPermSize=128M -Dbc4jtester_port=23322 -Djdev.range=100 -Dmodel_project_file_path=/C:/JDeveloper/mywork/reposvn/FunZone1/Model/Model.jpr -Doracle.mds.cache=simple -Duser.language=en -Duser.country=US -Duser.variant= -Doracle.security.jps.config=/C:/JDeveloper/mywork/reposvn/FunZone1/src/META-INF/\jps-config.xml -Duser.language=en -Duser.country=US -Duser.variant= -Doracle.security.jps.config=/C:/JDeveloper/mywork/reposvn/FunZone1/src/META-INF/\jps-config.xml -Duser.language=en -Duser.country=US -Duser.variant= -Doracle.security.jps.config=/C:/JDeveloper/mywork/reposvn/FunZone1/src/META-INF/\jps-config.xml -Duser.language=en -Duser.country=US -Duser.variant= -Doracle.security.jps.config=/C:/JDeveloper/mywork/reposvn/FunZone1/src/META-INF/\jps-config.xml -Duser.language=en -Duser.country=US -Duser.variant= -Doracle.security.jps.config=/C:/JDeveloper/mywork/reposvn/FunZone1/src/META-INF/\jps-config.xml -Duser.language=en -Duser.country=US -Duser.variant= -Doracle.security.jps.config=/C:/JDeveloper/mywork/reposvn/FunZone1/src/META-INF/\jps-config.xml oracle.jbo.jbotester.MainFrame -X 14D7BFF4B90
May 22, 2015 4:20:44 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
May 22, 2015 4:20:45 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
oracle.jbo.DMLException: JBO-26061: Error while opening JDBC connection.
at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:204)
at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:163)
at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:581)
at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:314)
at oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:99)
at oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:63)
at oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolManagerImpl.java:53)
at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:172)
at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:45)
at oracle.jbo.server.ConnectionPoolDataSource.getConnection(ConnectionPoolDataSource.java:74)
at oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:998)
at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1183)
at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:7091)
at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:297)
at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:328)
at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:202)
at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:630)
at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:426)
at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9542)
at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4526)
at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2453)
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2263)
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3162)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:590)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:523)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:518)
at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:637)
at oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:1010)
at oracle.jbo.jbotester.binding.TesterBinding.getConnectionInfo(TesterBinding.java:135)
at oracle.jbo.jbotester.MainFrame.initializeDataControl(MainFrame.java:1107)
at oracle.jbo.jbotester.MainFrame.loadConfiguration(MainFrame.java:740)
at oracle.jbo.jbotester.MainFrame.processArgs(MainFrame.java:716)
at oracle.jbo.jbotester.MainFrame.main(MainFrame.java:533)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:postgresql://127.0.0.1:5432/abcdefg?defaultAutoCommit=false&debug=2
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:187)
at oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)
at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:192)
... 32 more
## Detail 0 ##
java.sql.SQLException: No suitable driver found for jdbc:postgresql://127.0.0.1:5432/abcdefg?defaultAutoCommit=false&debug=2
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:187)
at oracle.jbo.server.URLConnectionHelper.getConnectionFromDriver(URLConnectionHelper.java:50)
at oracle.jbo.server.ConnectionPool.createConnection(ConnectionPool.java:192)
at oracle.jbo.server.ConnectionPool.instantiateResource(ConnectionPool.java:163)
at oracle.jbo.pool.ResourcePool.createResource(ResourcePool.java:581)
at oracle.jbo.pool.ResourcePool.useResource(ResourcePool.java:314)
at oracle.jbo.server.ConnectionPool.getConnectionInternal(ConnectionPool.java:99)
at oracle.jbo.server.ConnectionPool.getConnection(ConnectionPool.java:63)
at oracle.jbo.server.ConnectionPoolManagerImpl.getConnection(ConnectionPoolManagerImpl.java:53)
at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:172)
at oracle.jbo.server.URLConnectionHelper.getConnection(URLConnectionHelper.java:45)
at oracle.jbo.server.ConnectionPoolDataSource.getConnection(ConnectionPoolDataSource.java:74)
at oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:998)
at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:1183)
at oracle.jbo.server.DBTransactionImpl.initTxn(DBTransactionImpl.java:7091)
at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:297)
at oracle.jbo.server.DBTransactionImpl2.connectToDataSource(DBTransactionImpl2.java:328)
at oracle.jbo.common.ampool.DefaultConnectionStrategy.connect(DefaultConnectionStrategy.java:202)
at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolConnect(ApplicationPoolMessageHandler.java:630)
at oracle.jbo.server.ApplicationPoolMessageHandler.doPoolMessage(ApplicationPoolMessageHandler.java:426)
at oracle.jbo.server.ApplicationModuleImpl.doPoolMessage(ApplicationModuleImpl.java:9542)
at oracle.jbo.common.ampool.ApplicationPoolImpl.sendPoolMessage(ApplicationPoolImpl.java:4526)
at oracle.jbo.common.ampool.ApplicationPoolImpl.prepareApplicationModule(ApplicationPoolImpl.java:2453)
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2263)
at oracle.jbo.common.ampool.ApplicationPoolImpl.useApplicationModule(ApplicationPoolImpl.java:3162)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:590)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:523)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:518)
at oracle.adf.model.bc4j.DCJboDataControl.initializeApplicationModule(DCJboDataControl.java:637)
at oracle.adf.model.bc4j.DCJboDataControl.getApplicationModule(DCJboDataControl.java:1010)
at oracle.jbo.jbotester.binding.TesterBinding.getConnectionInfo(TesterBinding.java:135)
at oracle.jbo.jbotester.MainFrame.initializeDataControl(MainFrame.java:1107)
at oracle.jbo.jbotester.MainFrame.loadConfiguration(MainFrame.java:740)
at oracle.jbo.jbotester.MainFrame.processArgs(MainFrame.java:716)
at oracle.jbo.jbotester.MainFrame.main(MainFrame.java:533)
May 22, 2015 4:20:55 PM oracle.jbo.jbotester.MainFrame exit
INFO: BC4J Tester exit code(-3)
Process exited with exit code -3.
To resolve this issue you should add appriopriate JDBC driver to the classpath of the Model project:
No comments:
Post a Comment