java.sql.SQLException: [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.

Oracle Community | 3004 | 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

    Webstart Issue

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: [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.
  2. 0

    JDBC | SQL Server connection error

    Stack Overflow | 6 years ago | MMRUser
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 2: Incorrect syntax near '|'.
  3. 0

    Cannot access portal after datbase-transfer from cloudscape to SQL Server

    Google Groups | 1 decade ago | Hari
    com.ibm.wps.util.DataBackendException: EJPDB0064E: SQL Exception caught when initializing the IDFactory.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hibernate Community • View topic - auto generated Id with stored procedure

    hibernate.org | 2 years ago
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Syntaxe incorrecte vers le mot clé 'identity'.
  6. 0

    Hibernate Community • View topic - hibernate and SQL server throwing - Invalid object name

    hibernate.org | 1 year ago
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'echo_message'.

    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. java.sql.SQLException

      [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.

      at com.microsoft.jdbc.base.BaseExceptions.createException()
    2. com.microsoft.jdbc
      BasePreparedStatement.executeQuery
      1. com.microsoft.jdbc.base.BaseExceptions.createException(UnknownSource)
      2. com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
      3. com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(UnknownSource)
      4. com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(UnknownSource)
      5. com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(UnknownSource)
      6. com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(UnknownSource)
      7. com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(UnknownSource)
      8. com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(UnknownSource)
      9. com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
      10. com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(UnknownSource)
      11. com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(UnknownSource)
      11 frames
    3. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:353)
      2. com.solarmetric.jdbc.PoolConnection$PoolPreparedStatement.executeQuery(PoolConnection.java:333)
      3. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:351)
      4. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:704)
      5. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:351)
      5 frames
    4. kodo.jdbc.runtime
      JDBCStoreManager$CancelPreparedStatement.executeQuery
      1. kodo.jdbc.runtime.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1706)
      1 frame
    5. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeQuery
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:338)
      1 frame
    6. 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
    7. com.solarmetric.rop
      EagerResultList.<init>
      1. com.solarmetric.rop.EagerResultList.<init>(EagerResultList.java:22)
      1 frame
    8. kodo.jdbc.runtime
      JDBCFetchConfigurationImpl.newResultList
      1. kodo.jdbc.runtime.JDBCFetchConfigurationImpl.newResultList(JDBCFetchConfigurationImpl.java:137)
      1 frame
    9. kodo.runtime
      CopyOnWriteFetchConfiguration.newResultList
      1. kodo.runtime.CopyOnWriteFetchConfiguration.newResultList(CopyOnWriteFetchConfiguration.java:217)
      1 frame
    10. 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
    11. 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
    12. 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
    13. com.correlat.intranet
      NewsAddAction.actionPerformed
      1. com.correlat.intranet.news.swing.action.NewsAddAction.actionPerformed(NewsAddAction.java:23)
      1 frame
    14. 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
    15. net.sundog.swing
      WaitCursorEventQueue.dispatchEvent
      1. net.sundog.swing.WaitCursorEventQueue.dispatchEvent(WaitCursorEventQueue.java:21)
      1 frame
    16. 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