8 Replies Latest reply: Oct 7, 2008 2:39 PM by leloj RSS

    strange error in JDeveloper 11.1.1.0 Technology Preview 4

    441675
      I download starter workspace from

      http://www.oracle.com/technology/oramag/oracle/08-jul/o48frame.html

      A Home for Your Chrome and open in JDev 11g TP4 then go to Application Resources and change scott connection Oracle JDBC and test the connection I get Success!.

      when Run HRModule and select Departments to show data I get this error

      (oracle.jbo.SQLStmtException) JBO-27122: SQL error during statement preparation. Statement: SELECT Dept.DEPTNO, Dept.DNAME, Dept.LOC FROM DEPT Dept
      If press Details button in error I get

      (oracle.jbo.SQLStmtException) JBO-27122: SQL error during statement preparation. Statement: SELECT Dept.DEPTNO, Dept.DNAME, Dept.LOC FROM DEPT Dept
      ----- Level 1: Detail 0 -----
      (java.sql.SQLException) ORA-01866: the datetime class is invalid

      In Log:

      C:\jdevstudio1111\jdk\bin\javaw.exe -client -classpath C:\jdevstudio1111\BC4J\jlib\bc4jtester.jar;C:\jdevstudio1111\BC4J\lib\bc4jsyscat.jar;C:\jdevstudio1111\BC4J\lib\db-ca.jar;C:\jdevstudio1111\BC4J\jlib\bc4jwizard.jar;C:\jdevstudio1111\jlib\jdev-cm.jar;C:\jdevstudio1111\lib\xmlparserv2.jar;C:\jdevstudio1111\jlib\ohj.jar;C:\jdevstudio1111\jlib\help-share.jar;C:\jdevstudio1111\jlib\share.jar;C:\jdevstudio1111\jlib\jewt4.jar;C:\jdevstudio1111\jlib\oracle_ice.jar;C:\jdevstudio1111\jlib\ojmisc.jar;C:\jdevstudio1111\ide\lib\idert.jar;C:\jdevstudio1111\ide\lib\javatools.jar;C:\jdevstudio1111\jdk\jre\lib\rt.jar;C:\jdevstudio1111\jdk\jre\lib\i18n.jar;C:\jdevstudio1111\jdk\jre\lib\sunrsasign.jar;C:\jdevstudio1111\jdk\jre\lib\jsse.jar;C:\jdevstudio1111\jdk\jre\lib\jce.jar;C:\jdevstudio1111\jdk\jre\lib\charsets.jar;C:\jdevstudio1111\jdk\jre\classes;C:\jdevstudio1111\mywork\FrameworksJulAug2008\.adf;C:\jdevstudio1111\mywork\FrameworksJulAug2008\Model\classes;C:\jdevstudio1111\BC4J\lib\adf-share-support.jar;C:\jdevstudio1111\BC4J\lib\adf-sh are-ca.jar;C:\jdevstudio1111\BC4J\lib\adf-share-base.jar;C:\jdevstudio1111\jlib\identitystore.jar;C:\jdevstudio1111\BC4J\lib\adfm.jar;C:\jdevstudio1111\BC4J\lib\groovy-all-1.0.jar;C:\jdevstudio1111\jlib\commons-el.jar;C:\jdevstudio1111\jlib\jsp-el-api.jar;C:\jdevstudio1111\jlib\oracle-el.jar;C:\jdevstudio1111\jlib\resourcebundle.jar;C:\jdevstudio1111\lib\java\api\jaxb-api.jar;C:\jdevstudio1111\lib\java\api\jsr173_api.jar;C:\jdevstudio1111\j2ee\home\lib\activation.jar;C:\jdevstudio1111\lib\java\shared\sun.jaxb\2.0\jaxb-xjc.jar;C:\jdevstudio1111\lib\java\shared\sun.jaxb\2.0\jaxb-impl.jar;C:\jdevstudio1111\lib\java\shared\sun.jaxb\2.0\jaxb1-impl.jar;C:\jdevstudio1111\BC4J\lib\adfshare.jar;C:\jdevstudio1111\adfdt\lib\adf-dt-at-rt.jar;C:\jdevstudio1111\adfdt\lib\adf-transactions-dt.jar;C:\jdevstudio1111\adfdt\lib\adfdt_common.jar;C:\jdevstudio1111\mds\lib\mdsrt.jar;C:\jdevstudio1111\j2ee\home\lib\servlet.jar;C:\jdevstudio1111\jdbc\lib\ojdbc5dms.jar;C:\jdevstudio1111\jlib\commons-c li-1.0.jar;C:\jdevstudio1111\jlib\xmlef.jar;C:\jdevstudio1111\jlib\dms.jar;C:\jdevstudio1111\j2ee\home\lib\oc4j-unsupported-api.jar;C:\jdevstudio1111\lib\xml.jar;C:\jdevstudio1111\lib\java\api\cache.jar;C:\jdevstudio1111\j2ee\home\lib\pcl.jar;C:\jdevstudio1111\ucp\lib\ucp.jar;C:\jdevstudio1111\lib\java\shared\oracle.javatools\11.1.1.0.0\dafrt.jar;C:\jdevstudio1111\lib\java\shared\oracle.javatools\11.1.1.0.0\javatools-nodeps.jar;C:\jdevstudio1111\j2ee\home\jazn.jar;C:\jdevstudio1111\j2ee\home\jazncore.jar;C:\jdevstudio1111\j2ee\home\jps-api.jar;C:\jdevstudio1111\j2ee\home\jps-common.jar;C:\jdevstudio1111\j2ee\home\jps-internal.jar;C:\jdevstudio1111\j2ee\home\jps-fmw.jar;C:\jdevstudio1111\j2ee\home\jps-unsupported-api.jar;C:\jdevstudio1111\j2ee\home\lib\jacc-api.jar;C:\jdevstudio1111\j2ee\home\lib\security-api.jar;C:\jdevstudio1111\jlib\orai18n.jar;C:\jdevstudio1111\jlib\ojdl.jar;C:\jdevstudio1111\dvt\lib\dvt-jclient.jar;C:\jdevstudio1111\dvt\lib\dvt-utils.jar;C:\jdevstudio1111 \jlib\LW_PfjBean.jar; oracle.jbo.jbotester.MainFrame -X 11A6DAF0C7F -H "jar:file:/C:/jdevstudio1111/jdev/doc/studio_doc/ohj/bc4j_f1.jar!/bc4j_f1.hs"
      Jun 9, 2008 5:16:08 PM oracle.security.jps.internal.config.xml.XmlConfigurationFactory handleLocation
      WARNING: [XmlConfigurationFactory.handleLocation] Exception occurred when handling origLocation=/C:/jdevstudio1111/j2ee/home/config/system-jazn-data.xml : no protocol: /C:/jdevstudio1111/j2ee/home/config/system-jazn-data.xml
      Jun 9, 2008 5:16:08 PM oracle.security.jps.internal.config.xml.XmlConfigurationFactory handleLocation
      WARNING: [XmlConfigurationFactory.handleLocation] Exception occurred when handling origLocation=/C:/jdevstudio1111/j2ee/home/config/system-jazn-data.xml : no protocol: /C:/jdevstudio1111/j2ee/home/config/system-jazn-data.xml
      [JpsAuth] For permisson ( CredentialAccessPermission credstore.provider.credstore.ADF.anonymous#scott read), domain that failed: ProtectionDomain cs(file:/C:/jdevstudio1111/BC4J/lib/adf-share-support.jar), []

      If I build new JSF page and drag and drop Departments to show as read only table when run page I show the Table without data but only statement
      Fetching Data…

      Please if anybody can help me and tell me where is the problem.

      Note1: This error happen in all application created in Jdev 11g TP4 I have Jdev 10g and it is working perfect.

      Note2:In Log Please show this message:

      [JpsAuth] For permisson ( CredentialAccessPermission credstore.provider.credstore.ADF.anonymous#scott read), domain that failed: ProtectionDomain cs(file:/C:/jdevstudio1111/BC4J/lib/adf-share-support.jar), []

      Best Regards
      Zuhair Jawish