ClassCastException in QueryBuilder

[email protected] Thu, 17 Mar 2005 22:44:03 +0100
Newsgroups gmane.comp.java.enhydra.dods
Message-ID <[email protected]>
This is a multi-part message in MIME format...

------------=_1111095849-5787-156
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I'm getting a ClassCastException when using QueryBuilder.



2005.03.17 15:40:50: Quovix,ERROR+ com.lutris.dods.builder.generator.query.QueryException: SQL=[select project.company, count(issue.oid), project.company, count(issue.oid) from issue, project_room, project WHERE project_room.oid = issue.projectRoomId AND project_room.projectId = project.oid group by project.company]: Unable to get query results: java.lang.ClassCastException

2005.03.17 15:40:50: Quovix,ERROR+      at com.lutris.dods.builder.generator.query.QueryBuilder.getNextRow(Unknown Source)

2005.03.17 15:40:50: Quovix,ERROR+      at com.lutris.dods.builder.generator.query.QueryBuilder.getRows(Unknown Source)

2005.03.17 15:40:50: Quovix,ERROR+      at quovix.business.project.IssueBO.getIssuesCountMap(IssueBO.java:1068)

2005.03.17 15:40:50: Quovix,ERROR+      at quovix.presentation.account.CustomerReportHTMLBuilder.<init>(CustomerReportHTMLBuilder.java:45)

2005.03.17 15:40:50: Quovix,ERROR+      at quovix.presentation.account.AdminWorkSpaceHTMLBuilder.setCustomerSummary(AdminWorkSpaceHTMLBuilder.java:63)





It looks like this bit of code in StandardDBQuery.release() is the problem.  QueryBuilder extends Query and not ExtendedQuery.



    public synchronized void release() {

 

            try {

                java.sql.Statement stmt=null;

                try {

                    if (resultSet != null) {

                        resultSet.close();

                    }

                }catch(SQLException sqle) {

                    logDebug(sqle.toString());

                }

                stmt = ((ExtendedQuery)queryInterface).getStatement();

                if (stmt!=null){

                    stmt.close();

                }

            } catch (SQLException e) {

                conn.handleException(e);

            }





Any suggestions?


------------=_1111095849-5787-156
Content-Type: text/plain; name="message.footer"
Content-Disposition: inline; filename="message.footer"
Content-Transfer-Encoding: 8bit


--
You receive this message as a subscriber of the [email protected] mailing list.
To unsubscribe: mailto:[email protected]
For general help: mailto:[email protected]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

------------=_1111095849-5787-156--