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]

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Webstart Issue
    via by 3004,
  • count(1) problem
    via by 3004,
  • Kodo v4.0.0EA2 Bugs List
    via by 3004,
  • Query under Transaction Exception....
    via by 3004,
  • 3.0.0RC2 MappingTool producing bad SQL
    via by 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] 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) at kodo.jdbc.runtime.AbstractSelectResultObjectProvider.open(AbstractSelectResultObjectProvider.java:84) at com.solarmetric.rop.EagerResultList.<init>(EagerResultList.java:22)
    No Bugmate found.