java.sql.SQLException

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,
    • java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The cursor was not declared. at kodo.jdbc.sql.SQLExceptions.getDataStore(SQLExceptions.java:63) at kodo.jdbc.sql.SQLExceptions.getDataStore(SQLExceptions.java:51) at kodo.jdbc.runtime.AbstractSelectResultObjectProvider.handleCheckedException(AbstractSelectResultObjectProvider.java:150) at com.solarmetric.rop.EagerResultList.<init>(EagerResultList.java:32) 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(Unknown Source) 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(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) 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(Unknown Source) 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) Caused by: 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) ... 46 more
    No Bugmate found.