kodo.persistence.PersistenceException: ORA-01790: expression must have same datatype as corresponding expression {prepstmnt 19411967 SELECT 0, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, 0, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 1, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CAR_CO_OID, t1.DEPT_ROLE_OID, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.SUB_DIV_ROLE_OID, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CAR_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 2, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CLIENT_CO_OID, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, t1.CAR_CO_ASSIGNED_VIP_PRIORITY, t1.CLIENT_CO_VIP_PRIORITY, t1.DEPARTMENT_OID, t1.FARE_CEILING_PER_RIDE, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.RIDE_RESTRICTIONS_OFF, t1.SUB_DIVISION_OID, t1.VIP_STATUS, '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CLIENT_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 3, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, 0, t2.CREATED_ON, '1969-12-31 19:00:00.0', t2.FOR_DEPT_OID, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, t2.status, t2.STATUS_DATE_TIME, t2.TYPE_NAME, t3.oid, t3.FOR_COMPANY_OID, t3.IS_IN_POC_MODE, t3.type_Name, t3.TYPE_OF_BUS_COMMENT, t3.TYPE_OF_BUSINESS, t4.oid, t4.CREATED_ON, t4.FOR_DEPT_ROLE_OID, t4.FOR_SUB_DIV_OID, t4.status, t4.STATUS_DATE_TIME, t4.TYPE_NAME, t5.oid, t5.FOR_COMPANY_OID, t5.IS_IN_POC_MODE, t5.type_Name, t5.TYPE_OF_BUS_COMMENT, t5.TYPE_OF_BUSINESS, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.HELP_DESK_EMPLOYEE t1, qopen.HELP_DESK_DEPARTMENT_ROLE t2, qopen.HELP_DESK_COMPANY_ROLE t3, qopen.HELP_DESK_SUB_DIV_ROLE t4, qopen.HELP_DESK_COMPANY_ROLE t5 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.DEPT_ROLE_OID = t2.oid(+) AND t1.SUB_DIV_ROLE_OID = t4.oid(+) AND t2.HELP_DESK_COMPANY_OID = t3.oid(+) AND t4.HELP_DESK_COMPANY_OID = t5.oid(+) UNION ALL SELECT 4, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, t2.FOR_COMPANY_OID, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, t2.IS_IN_POC_MODE, 0, t2.type_Name, '1969-12-31 19:00:00.0', t2.TYPE_OF_BUS_COMMENT, 0, 0, 0, t2.TYPE_OF_BUSINESS, '', '', t2.BILLING_ADDRESS_OID, '1969-12-31 19:00:00.0', t2.DEFAULT_DIS_ZONES_OID, t2.DEFAULT_RATE_BOOK_OID, '', '1969-12-31 19:00:00.0', '', t2.DISPATCH_CONTROL_OID, 0, 0, '', '', '', t2.DISPUTE_INVCD_MAX_DAYS, t2.NYS_SURCHAGE_PCT, t3.oid, t3.CREATED_ON, t3.FOR_DEPT_OID, t3.status, t3.STATUS_DATE_TIME, t3.TYPE_NAME, t4.oid, t4.FOR_COMPANY_OID, t4.IS_IN_POC_MODE, t4.type_Name, t4.TYPE_OF_BUS_COMMENT, t4.TYPE_OF_BUSINESS, t4.BILLING_ADDRESS_OID, t4.DEFAULT_DIS_ZONES_OID, t4.DEFAULT_RATE_BOOK_OID, t4.DISPATCH_CONTROL_OID, t4.DISPUTE_INVCD_MAX_DAYS, t4.NYS_SURCHAGE_PCT, t5.oid, t5.CREATED_ON, t5.FOR_DEPT_ROLE_OID, t5.FOR_SUB_DIV_OID, t5.status, t5.STATUS_DATE_TIME, t5.TYPE_NAME, t6.oid, t6.FOR_COMPANY_OID, t6.IS_IN_POC_MODE, t6.type_Name, t6.TYPE_OF_BUS_COMMENT, t6.TYPE_OF_BUSINESS, t6.BILLING_ADDRESS_OID, t6.DEFAULT_DIS_ZONES_OID, t6.DEFAULT_RATE_BOOK_OID, t6.DISPATCH_CONTROL_OID, t6.DISPUTE_INVCD_MAX_DAYS, t6.NYS_SURCHAGE_PCT FROM qopen.USER_1 t0, qopen.NEW_CO_EMPLOYEE t1, qopen.MGMT_CO_COMPANY_ROLE t2, qopen.MGMT_CO_DEPARTMENT_ROLE t3, qopen.MGMT_CO_COMPANY_ROLE t4, qopen.MGMT_CO_SUB_DIVISION_ROLE t5, qopen.MGMT_CO_COMPANY_ROLE t6 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.BELONGS_TO_NEW_CO_OID = t2.oid(+) AND t1.DEPT_ROLE_OID = t3.oid(+) AND t1.SUB_DIV_ROLE_OID = t5.oid(+) AND t3.FOR_MGMT_COMPANY_OID = t4.oid(+) AND t5.FOR_MGMT_COMPANY_OID = t6.oid(+) [params=(String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario] [reused=0]} [code=1790, state=42000]

Oracle Community | 666705 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    kodo.persistence.PersistenceException: expression must have same datatype

    Oracle Community | 1 decade ago | 666705
    kodo.persistence.PersistenceException: ORA-01790: expression must have same datatype as corresponding expression {prepstmnt 19411967 SELECT 0, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, 0, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 1, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CAR_CO_OID, t1.DEPT_ROLE_OID, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.SUB_DIV_ROLE_OID, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CAR_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 2, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CLIENT_CO_OID, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, t1.CAR_CO_ASSIGNED_VIP_PRIORITY, t1.CLIENT_CO_VIP_PRIORITY, t1.DEPARTMENT_OID, t1.FARE_CEILING_PER_RIDE, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.RIDE_RESTRICTIONS_OFF, t1.SUB_DIVISION_OID, t1.VIP_STATUS, '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CLIENT_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 3, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, 0, t2.CREATED_ON, '1969-12-31 19:00:00.0', t2.FOR_DEPT_OID, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, t2.status, t2.STATUS_DATE_TIME, t2.TYPE_NAME, t3.oid, t3.FOR_COMPANY_OID, t3.IS_IN_POC_MODE, t3.type_Name, t3.TYPE_OF_BUS_COMMENT, t3.TYPE_OF_BUSINESS, t4.oid, t4.CREATED_ON, t4.FOR_DEPT_ROLE_OID, t4.FOR_SUB_DIV_OID, t4.status, t4.STATUS_DATE_TIME, t4.TYPE_NAME, t5.oid, t5.FOR_COMPANY_OID, t5.IS_IN_POC_MODE, t5.type_Name, t5.TYPE_OF_BUS_COMMENT, t5.TYPE_OF_BUSINESS, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.HELP_DESK_EMPLOYEE t1, qopen.HELP_DESK_DEPARTMENT_ROLE t2, qopen.HELP_DESK_COMPANY_ROLE t3, qopen.HELP_DESK_SUB_DIV_ROLE t4, qopen.HELP_DESK_COMPANY_ROLE t5 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.DEPT_ROLE_OID = t2.oid(+) AND t1.SUB_DIV_ROLE_OID = t4.oid(+) AND t2.HELP_DESK_COMPANY_OID = t3.oid(+) AND t4.HELP_DESK_COMPANY_OID = t5.oid(+) UNION ALL SELECT 4, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, t2.FOR_COMPANY_OID, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, t2.IS_IN_POC_MODE, 0, t2.type_Name, '1969-12-31 19:00:00.0', t2.TYPE_OF_BUS_COMMENT, 0, 0, 0, t2.TYPE_OF_BUSINESS, '', '', t2.BILLING_ADDRESS_OID, '1969-12-31 19:00:00.0', t2.DEFAULT_DIS_ZONES_OID, t2.DEFAULT_RATE_BOOK_OID, '', '1969-12-31 19:00:00.0', '', t2.DISPATCH_CONTROL_OID, 0, 0, '', '', '', t2.DISPUTE_INVCD_MAX_DAYS, t2.NYS_SURCHAGE_PCT, t3.oid, t3.CREATED_ON, t3.FOR_DEPT_OID, t3.status, t3.STATUS_DATE_TIME, t3.TYPE_NAME, t4.oid, t4.FOR_COMPANY_OID, t4.IS_IN_POC_MODE, t4.type_Name, t4.TYPE_OF_BUS_COMMENT, t4.TYPE_OF_BUSINESS, t4.BILLING_ADDRESS_OID, t4.DEFAULT_DIS_ZONES_OID, t4.DEFAULT_RATE_BOOK_OID, t4.DISPATCH_CONTROL_OID, t4.DISPUTE_INVCD_MAX_DAYS, t4.NYS_SURCHAGE_PCT, t5.oid, t5.CREATED_ON, t5.FOR_DEPT_ROLE_OID, t5.FOR_SUB_DIV_OID, t5.status, t5.STATUS_DATE_TIME, t5.TYPE_NAME, t6.oid, t6.FOR_COMPANY_OID, t6.IS_IN_POC_MODE, t6.type_Name, t6.TYPE_OF_BUS_COMMENT, t6.TYPE_OF_BUSINESS, t6.BILLING_ADDRESS_OID, t6.DEFAULT_DIS_ZONES_OID, t6.DEFAULT_RATE_BOOK_OID, t6.DISPATCH_CONTROL_OID, t6.DISPUTE_INVCD_MAX_DAYS, t6.NYS_SURCHAGE_PCT FROM qopen.USER_1 t0, qopen.NEW_CO_EMPLOYEE t1, qopen.MGMT_CO_COMPANY_ROLE t2, qopen.MGMT_CO_DEPARTMENT_ROLE t3, qopen.MGMT_CO_COMPANY_ROLE t4, qopen.MGMT_CO_SUB_DIVISION_ROLE t5, qopen.MGMT_CO_COMPANY_ROLE t6 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.BELONGS_TO_NEW_CO_OID = t2.oid(+) AND t1.DEPT_ROLE_OID = t3.oid(+) AND t1.SUB_DIV_ROLE_OID = t5.oid(+) AND t3.FOR_MGMT_COMPANY_OID = t4.oid(+) AND t5.FOR_MGMT_COMPANY_OID = t6.oid(+) [params=(String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario] [reused=0]} [code=1790, state=42000]
  2. 0

    Kodo v4.0.0EA2 Bugs List

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ERROR: relation "kodo_sequence_table" does not exist {prepstmnt 31538514 SELECT SEQUENCE_VALUE FROM KODO_SEQUENCE_TABLE WHERE ID = ? FOR UPDATE [reused=0]} [code=0, state=42P01]
  3. 0

    Webstart Issue

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The column prefix 't3' does not match with a table name or alias name used in the query. {prepstmnt 1710895 SELECT DISTINCT t0.id_i, t0.classtype_id_vc, t0.rowversion_i, t0.active_b, t0.imagemimetype_vc, t0.lastupdated_dt, t0.newsdate_dt, t0.relatedurl_vc, t0.title_vc, t0.lastupdatedby_person_id_i, t0.postedby_person_id_i, t4.id_i, t4.rowversion_i, t4.active_b, t4.birthday_dt, t4.cellphone_vc, t4.created_dt, t4.createdby_person_id_i, t4.encryptedpassword_vc, t4.fax_vc, t4.firstname_vc, t4.hired_dt, t4.homephone_vc, t4.im_vc, t4.lastmodified_dt, t4.lastmodifiedby_person_id_i, t4.lastname_vc, t4.maincorrelat_organization_id_i, t4.middlename_vc, t4.nickname_vc, t4.officephone_vc, t4.primaryEmail_vc, t4.secondaryEmail_vc, t4.title_vc, t4.username_vc, t4.website_vc FROM cor.t_news t0 INNER JOIN cor.t_map_newsitem_organization t1 ON t0.id_i = t1.newsitem_id_i LEFT OUTER JOIN cor.t_person t2 ON t0.postedby_person_id_i = t2.id_i LEFT OUTER JOIN cor.t_person t4 ON t3.postedby_person_id_i = t4.id_i WHERE (t0.active_b = ? AND t0.newsdate_dt >= ? AND t1.organization_id_i = ?) AND t0.classtype_id_vc = ?} [code=107, state=HY000]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    count(1) problem

    Oracle Community | 1 decade ago | 3004
    kodo.util.UserException: com.solarmetric.jdbc.ReportingSQLException: Syntax error or access violation, message from server: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" {prepstmnt 3338151 SELECT COUNT(?) FROM [reused=0]} [code=1064, state=42000]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.solarmetric.jdbc.ReportingSQLException

      ORA-01790: expression must have same datatype as corresponding expression {prepstmnt 19411967 SELECT 0, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, 0, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 1, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CAR_CO_OID, t1.DEPT_ROLE_OID, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.SUB_DIV_ROLE_OID, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CAR_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 2, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t1.BELONGS_TO_CLIENT_CO_OID, 0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, t1.CAR_CO_ASSIGNED_VIP_PRIORITY, t1.CLIENT_CO_VIP_PRIORITY, t1.DEPARTMENT_OID, t1.FARE_CEILING_PER_RIDE, t1.LINE_MNG_END, t1.LINE_MNG_START, t1.MANAGES_LINE_NOW_OID, t1.RIDE_RESTRICTIONS_OFF, t1.SUB_DIVISION_OID, t1.VIP_STATUS, '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.CLIENT_COMPANY_EMPLOYEE t1 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid UNION ALL SELECT 3, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, 0, t2.CREATED_ON, '1969-12-31 19:00:00.0', t2.FOR_DEPT_OID, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, t2.status, t2.STATUS_DATE_TIME, t2.TYPE_NAME, t3.oid, t3.FOR_COMPANY_OID, t3.IS_IN_POC_MODE, t3.type_Name, t3.TYPE_OF_BUS_COMMENT, t3.TYPE_OF_BUSINESS, t4.oid, t4.CREATED_ON, t4.FOR_DEPT_ROLE_OID, t4.FOR_SUB_DIV_OID, t4.status, t4.STATUS_DATE_TIME, t4.TYPE_NAME, t5.oid, t5.FOR_COMPANY_OID, t5.IS_IN_POC_MODE, t5.type_Name, t5.TYPE_OF_BUS_COMMENT, t5.TYPE_OF_BUSINESS, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0, 0, '1969-12-31 19:00:00.0', 0, 0, '', '1969-12-31 19:00:00.0', '', 0, 0, 0, '', '', '', 0, 0, 0, 0, 0, 0.0 FROM qopen.USER_1 t0, qopen.HELP_DESK_EMPLOYEE t1, qopen.HELP_DESK_DEPARTMENT_ROLE t2, qopen.HELP_DESK_COMPANY_ROLE t3, qopen.HELP_DESK_SUB_DIV_ROLE t4, qopen.HELP_DESK_COMPANY_ROLE t5 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.DEPT_ROLE_OID = t2.oid(+) AND t1.SUB_DIV_ROLE_OID = t4.oid(+) AND t2.HELP_DESK_COMPANY_OID = t3.oid(+) AND t4.HELP_DESK_COMPANY_OID = t5.oid(+) UNION ALL SELECT 4, t0.oid, t1.oid, t1.name, t1.ROLE_TYPE_OID, t1.status, t1.STATUS_DATE_TIME, t1.EMP_GENERAL_INFO_OID, t1.END_TIME, t1.FOR_PERSON_OID, t1.START_TIME, t2.oid, t2.FOR_COMPANY_OID, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, 0, 0, 0, 0, 0.0, '1969-12-31 19:00:00.0', '1969-12-31 19:00:00.0', 0, t2.IS_IN_POC_MODE, 0, t2.type_Name, '1969-12-31 19:00:00.0', t2.TYPE_OF_BUS_COMMENT, 0, 0, 0, t2.TYPE_OF_BUSINESS, '', '', t2.BILLING_ADDRESS_OID, '1969-12-31 19:00:00.0', t2.DEFAULT_DIS_ZONES_OID, t2.DEFAULT_RATE_BOOK_OID, '', '1969-12-31 19:00:00.0', '', t2.DISPATCH_CONTROL_OID, 0, 0, '', '', '', t2.DISPUTE_INVCD_MAX_DAYS, t2.NYS_SURCHAGE_PCT, t3.oid, t3.CREATED_ON, t3.FOR_DEPT_OID, t3.status, t3.STATUS_DATE_TIME, t3.TYPE_NAME, t4.oid, t4.FOR_COMPANY_OID, t4.IS_IN_POC_MODE, t4.type_Name, t4.TYPE_OF_BUS_COMMENT, t4.TYPE_OF_BUSINESS, t4.BILLING_ADDRESS_OID, t4.DEFAULT_DIS_ZONES_OID, t4.DEFAULT_RATE_BOOK_OID, t4.DISPATCH_CONTROL_OID, t4.DISPUTE_INVCD_MAX_DAYS, t4.NYS_SURCHAGE_PCT, t5.oid, t5.CREATED_ON, t5.FOR_DEPT_ROLE_OID, t5.FOR_SUB_DIV_OID, t5.status, t5.STATUS_DATE_TIME, t5.TYPE_NAME, t6.oid, t6.FOR_COMPANY_OID, t6.IS_IN_POC_MODE, t6.type_Name, t6.TYPE_OF_BUS_COMMENT, t6.TYPE_OF_BUSINESS, t6.BILLING_ADDRESS_OID, t6.DEFAULT_DIS_ZONES_OID, t6.DEFAULT_RATE_BOOK_OID, t6.DISPATCH_CONTROL_OID, t6.DISPUTE_INVCD_MAX_DAYS, t6.NYS_SURCHAGE_PCT FROM qopen.USER_1 t0, qopen.NEW_CO_EMPLOYEE t1, qopen.MGMT_CO_COMPANY_ROLE t2, qopen.MGMT_CO_DEPARTMENT_ROLE t3, qopen.MGMT_CO_COMPANY_ROLE t4, qopen.MGMT_CO_SUB_DIVISION_ROLE t5, qopen.MGMT_CO_COMPANY_ROLE t6 WHERE (LOWER(t0.USER_NAME) = LOWER(?)) AND t0.PLAYS_EMPLOYEE_OID = t1.oid AND t1.BELONGS_TO_NEW_CO_OID = t2.oid(+) AND t1.DEPT_ROLE_OID = t3.oid(+) AND t1.SUB_DIV_ROLE_OID = t5.oid(+) AND t3.FOR_MGMT_COMPANY_OID = t4.oid(+) AND t5.FOR_MGMT_COMPANY_OID = t6.oid(+) [params=(String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario, (String) joeRozario] [reused=0]} [code=1790, state=42000]

      at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap()
    2. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:184)
      2. com.solarmetric.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:21)
      3. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1098)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:345)
      4 frames
    3. kodo.jdbc.kernel
      JDBCStoreManager$CancelPreparedStatement.executeQuery
      1. kodo.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1633)
      1 frame
    4. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:332)
      1 frame
    5. kodo.jdbc.sql
      Union.execute
      1. kodo.jdbc.sql.Union.execute(Union.java:425)
      2. kodo.jdbc.sql.Union.execute(Union.java:332)
      3. kodo.jdbc.sql.Union.execute(Union.java:313)
      4. kodo.jdbc.sql.SelectImpl.addEagerResults(SelectImpl.java:386)
      5. kodo.jdbc.sql.SelectImpl.execute(SelectImpl.java:350)
      6. kodo.jdbc.sql.SelectImpl.execute(SelectImpl.java:301)
      7. kodo.jdbc.sql.Union$UnionSelect.execute(Union.java:642)
      8. kodo.jdbc.sql.Union.execute(Union.java:326)
      9. kodo.jdbc.sql.Union.execute(Union.java:313)
      9 frames
    6. kodo.jdbc.kernel
      SelectResultObjectProvider.open
      1. kodo.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:98)
      1 frame
    7. com.solarmetric.rop
      EagerResultList.<init>
      1. com.solarmetric.rop.EagerResultList.<init>(EagerResultList.java:22)
      1 frame
    8. kodo.kernel
      DelegatingQuery.execute
      1. kodo.kernel.QueryImpl.toResult(QueryImpl.java:1445)
      2. kodo.kernel.QueryImpl.execute(QueryImpl.java:1167)
      3. kodo.kernel.QueryImpl.execute(QueryImpl.java:953)
      4. kodo.kernel.QueryImpl.execute(QueryImpl.java:871)
      5. kodo.kernel.DelegatingQuery.execute(DelegatingQuery.java:774)
      5 frames
    9. kodo.persistence
      QueryImpl.getResultList
      1. kodo.persistence.QueryImpl.execute(QueryImpl.java:241)
      2. kodo.persistence.QueryImpl.getResultList(QueryImpl.java:290)
      2 frames
    10. com.savantcg.blackcar
      AppConfigDecidesToViewRoleTypesEvent.performEvent
      1. com.savantcg.blackcar.business.securitydomain.Users.getUser(Users.java:48)
      2. com.savantcg.blackcar.business.businessevents.newco.AppConfigDecidesToViewRoleTypesEvent.performEvent(AppConfigDecidesToViewRoleTypesEvent.java:54)
      2 frames
    11. com.savantcg.business
      BusinessEvent.perform
      1. com.savantcg.business.businessevents.BusinessEvent.perform(BusinessEvent.java:62)
      1 frame
    12. com.savantcg.blackcar
      TestGetListOfRoleTypes.main
      1. com.savantcg.blackcar.tests.TestGetListOfRoleTypes.getAccts(TestGetListOfRoleTypes.java:39)
      2. com.savantcg.blackcar.tests.TestGetListOfRoleTypes.main(TestGetListOfRoleTypes.java:87)
      2 frames