HELP ME !! PB With temporary Table !!!

[khsam2001]

i used a jasperServer vers 3.7.0 and i have creatde a report unit, i have a sql query with the temporay table like :

SELECT dvi.code_dvi, ....................
INTO #elisData
FROM exp_exploitation exp, ------------
 WHERE dvi.code_dvi = XXXXXXX

where i run this report at the first there are no pb,but at the second  it show me an exception,  "There is already an object named '#elisData' in the database :

 

i don t  know why he did t drop this table after close connection !!

!!!   I use a sybase server dataBase 

PLEASE !!

Code:

com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : estimate_master	at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141)	at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:161)	at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.createQueryDataSource(EngineServiceImpl.java:761)	at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillQueryReport(EngineServiceImpl.java:779)	at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:728)	at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:385)	at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:871)	at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:57)	at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:319)	at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:383)	at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:373)	at com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:255)....	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)	at java.lang.Thread.run(Thread.java:619)Caused by: com.sybase.jdbc3.jdbc.SybSQLException: There is already an object named '#elisData' in the database.	at com.sybase.jdbc3.tds.Tds.a(Unknown Source)	at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)	at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)	at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)	at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)	at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)	at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)	at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)	at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135)... 114 more

Post Edited by khsam2001 at 07/19/2010 09:36