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]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web49

  • 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 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) at kodo.jdbc.runtime.JDBCFetchConfigurationImpl.newResultList(JDBCFetchConfigurationImpl.java:137) at kodo.runtime.CopyOnWriteFetchConfiguration.newResultList(CopyOnWriteFetchConfiguration.java:217) at kodo.query.AbstractQuery.executeWithMap(AbstractQuery.java:854) at kodo.query.AbstractQuery.executeWithArray(AbstractQuery.java:770) at kodo.query.AbstractQuery.execute(AbstractQuery.java:746) at com.correlat.intranet.news.NewsItemPeer.findActiveByAge(NewsItemPeer.java:60) at com.correlat.intranet.news.swing.JNewsFilterList$1.getMatchingObjects(JNewsFilterList.java:24) at com.correlat.intranet.swing.binding.KodoListFilter.getMatchingObjects(KodoListFilter.java:24) at com.correlat.intranet.swing.content.DefaultJContentList$FilterQuery.getMatchingObjects(DefaultJContentList.java:314) at com.correlat.intranet.swing.content.DefaultJContentList$FilterQuery.doQuery(DefaultJContentList.java:309) at com.correlat.intranet.swing.content.DefaultJContentList$FilterQueryList.setQuery(DefaultJContentList.java:331) at com.correlat.intranet.swing.content.DefaultJContentList.applyFilter(DefaultJContentList.java:260) at com.correlat.intranet.swing.JMainFrame.setContentList(JMainFrame.java:302) at com.correlat.intranet.swing.navigation.action.GlobalNavigateAction.actionPerformed(GlobalNavigateAction.java:35) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(UnknownSource) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.JToggleButton$ToggleButtonModel.setPressed(UnknownSource) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at com.correlat.intranet.news.swing.action.NewsAddAction.actionPerformed(NewsAddAction.java:23) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(UnknownSource) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.JToggleButton$ToggleButtonModel.setPressed(UnknownSource) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(UnknownSource) at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at net.sundog.swing.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:21) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(UnknownSource) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source)

    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’re the first here who have seen this exception.