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]

Oracle Community | 3004 | 1 decade ago
  1. 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]
  2. 0

    Group by clause corresponding to a reference field

    Oracle Community | 1 decade ago | 3004
    java.lang.reflect.InvocationTargetException
  3. 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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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]
  6. 0

    Query under Transaction Exception....

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: DB2 SQL error: SQLCODE: -511, SQLSTATE: 42829, SQLERRMC: null {prepstmnt 107840951 SELECT t0.GROUPSETTINGID, t0.ALLOWDRAW, t0.ALLOWSTRIKE, t0.ALLOWTRANSFER, t0.ASCENDONLY, t0.AUTOAPPROVE, t0.BARVISIBLE, t0.DEFAULTLEVELNAME, t0.LASTMODIFY, t0.MAXDRAW, t0.MAXRECHARGE, t0.MAXROWS, t0.MAXSTRIKE, t0.MAXTRANSFER, t0.MINDRAW, t0.MINRECHARGE, t0.MINSTRIKE, t0.MINTRANSFER, t0.GROUPID, t0.RECHARGEABLE, t0.USERTYPEMODIFICATION FROM OLTP.GROUPSETTING t0 INNER JOIN OLTP.ORGANGROUP t1 ON t0.GROUPID = t1.GROUPID WHERE (t1.GROUPID = ?) FOR UPDATE [reused=0]} [code=-511, state=42829]

    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

      [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()
    2. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:124)
      2. com.solarmetric.jdbc.LoggingConnectionDecorator.access$600(LoggingConnectionDecorator.java:19)
      3. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:708)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:351)
      4 frames
    3. kodo.jdbc.runtime
      JDBCStoreManager$CancelPreparedStatement.executeQuery
      1. kodo.jdbc.runtime.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1706)
      1 frame
    4. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:338)
      1 frame
    5. kodo.jdbc.runtime
      AbstractSelectResultObjectProvider.open
      1. kodo.jdbc.runtime.JDBCStoreManager.getResultInternal(JDBCStoreManager.java:1010)
      2. kodo.jdbc.runtime.JDBCStoreManager.getResult(JDBCStoreManager.java:983)
      3. kodo.jdbc.runtime.AbstractSelectResultObjectProvider.open(AbstractSelectResultObjectProvider.java:84)
      3 frames
    6. com.solarmetric.rop
      EagerResultList.<init>
      1. com.solarmetric.rop.EagerResultList.<init>(EagerResultList.java:22)
      1 frame
    7. kodo.jdbc.runtime
      JDBCFetchConfigurationImpl.newResultList
      1. kodo.jdbc.runtime.JDBCFetchConfigurationImpl.newResultList(JDBCFetchConfigurationImpl.java:137)
      1 frame
    8. kodo.runtime
      CopyOnWriteFetchConfiguration.newResultList
      1. kodo.runtime.CopyOnWriteFetchConfiguration.newResultList(CopyOnWriteFetchConfiguration.java:217)
      1 frame
    9. kodo.query
      AbstractQuery.execute
      1. kodo.query.AbstractQuery.executeWithMap(AbstractQuery.java:854)
      2. kodo.query.AbstractQuery.executeWithArray(AbstractQuery.java:770)
      3. kodo.query.AbstractQuery.execute(AbstractQuery.java:746)
      3 frames
    10. com.correlat.intranet
      GlobalNavigateAction.actionPerformed
      1. com.correlat.intranet.news.NewsItemPeer.findActiveByAge(NewsItemPeer.java:60)
      2. com.correlat.intranet.news.swing.JNewsFilterList$1.getMatchingObjects(JNewsFilterList.java:24)
      3. com.correlat.intranet.swing.binding.KodoListFilter.getMatchingObjects(KodoListFilter.java:24)
      4. com.correlat.intranet.swing.content.DefaultJContentList$FilterQuery.getMatchingObjects(DefaultJContentList.java:314)
      5. com.correlat.intranet.swing.content.DefaultJContentList$FilterQuery.doQuery(DefaultJContentList.java:309)
      6. com.correlat.intranet.swing.content.DefaultJContentList$FilterQueryList.setQuery(DefaultJContentList.java:331)
      7. com.correlat.intranet.swing.content.DefaultJContentList.applyFilter(DefaultJContentList.java:260)
      8. com.correlat.intranet.swing.JMainFrame.setContentList(JMainFrame.java:302)
      9. com.correlat.intranet.swing.navigation.action.GlobalNavigateAction.actionPerformed(GlobalNavigateAction.java:35)
      9 frames
    11. Java RT
      AbstractButton.doClick
      1. javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(UnknownSource)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
      4. javax.swing.JToggleButton$ToggleButtonModel.setPressed(UnknownSource)
      5. javax.swing.AbstractButton.doClick(Unknown Source)
      6. javax.swing.AbstractButton.doClick(Unknown Source)
      6 frames
    12. com.correlat.intranet
      NewsAddAction.actionPerformed
      1. com.correlat.intranet.news.swing.action.NewsAddAction.actionPerformed(NewsAddAction.java:23)
      1 frame
    13. Java RT
      EventQueue.dispatchEvent
      1. javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(UnknownSource)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
      4. javax.swing.JToggleButton$ToggleButtonModel.setPressed(UnknownSource)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(UnknownSource)
      6. java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
      7. java.awt.Component.processMouseEvent(Unknown Source)
      8. java.awt.Component.processEvent(Unknown Source)
      9. java.awt.Container.processEvent(Unknown Source)
      10. java.awt.Component.dispatchEventImpl(Unknown Source)
      11. java.awt.Container.dispatchEventImpl(Unknown Source)
      12. java.awt.Component.dispatchEvent(Unknown Source)
      13. java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
      14. java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
      15. java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
      16. java.awt.Container.dispatchEventImpl(Unknown Source)
      17. java.awt.Window.dispatchEventImpl(Unknown Source)
      18. java.awt.Component.dispatchEvent(Unknown Source)
      19. java.awt.EventQueue.dispatchEvent(Unknown Source)
      19 frames
    14. net.sundog.swing
      WaitCursorEventQueue.dispatchEvent
      1. net.sundog.swing.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:21)
      1 frame
    15. Java RT
      EventDispatchThread.run
      1. java.awt.EventDispatchThread.pumpOneEventForHierarchy(UnknownSource)
      2. java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
      3. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      4. java.awt.EventDispatchThread.pumpEvents(Unknown Source)
      5. java.awt.EventDispatchThread.run(Unknown Source)
      5 frames