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 LEFTOUTER> > JOIN cor.t_person t2 ON t0.postedby_person_id_i = t2.id_i LEFT OUTERJOIN> > 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 = ?) ANDt0.classtype_id_vc> >= ? [code=107, state=HY000]

Solutions on the web44

  • via Oracle Community by 3004, 1 year ago
    [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
  • 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
  • via Oracle Community by 3004, 2 weeks ago
    .default_billingcode_id_i, t1.duedate_dt, t1.modifiedby_person_id_i, t1.percentcomplete_f, t1.priority_id_i, t1.projectedstartdate_dt, t1.snapshotdate_dt, t1.status_id_i, t1.task_id_i FROM cor.t_task t0 INNER JOIN cor.t_tasksnapshot t1 ON t0.id_i = t1.task_id_i WHERE t0.project_id_i = ? [reused=2]} [code=0, state=HY000]
  • Stack trace

    • 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 LEFTOUTER> > JOIN cor.t_person t2 ON t0.postedby_person_id_i = t2.id_i LEFT OUTERJOIN> > 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 = ?) ANDt0.classtype_id_vc> >= ? [code=107, state=HY000] at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:124) at com.solarmetric.jdbc.LoggingConnectionDecorator.access$600(LoggingConnectionDecorator.java:19) at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:708) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:351) at kodo.jdbc.runtime.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1706) at com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:338) at kodo.jdbc.runtime.JDBCStoreManager.getResultInternal(JDBCStoreManager.java:1010) at kodo.jdbc.runtime.JDBCStoreManager.getResult(JDBCStoreManager.java:983)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.