MS SQL Server JDBC connect problem

By: Mark Smith - paddysmith
MS SQL Server JDBC connect problem
2003-02-06 05:00
Hi,

I am trying to run the demo sample “Query” in the 0.45.

The problem occur when I try to run the ant fill target on MS SQL Server with a new JDBC driver.
I have installed the exact same data and tables on both the provided hsqldb and the MS SQL server (created a database test and migrated the table and data input script to run on both servers)

I have updated the getConnction method with the following.

//String driver = "org.hsqldb.jdbcDriver";
//String connectString = "jdbc:hsqldb:hsql://localhost";
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String connectString = "jdbc:microsoft:sqlserver://cgsnextbigthing:1433;DatabaseName=racts2";

I receive the error message:

fill:
[java] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
[java] at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
[java] at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
[java] at com.microsoft.jdbc.base.BaseResultSet.validateClosedState(Unknown Source)
[java] at com.microsoft.jdbc.base.BaseResultSet.getStatement(Unknown Source)
[java] at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:381)
[java] at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)
[java] at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)
[java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:138)
[java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:106)
[java] at QueryApp.main(QueryApp.java:148)

[java] NESTED BY :
[java] dori.jasper.engine.JRException: Error closing ResultSet or Statement for report data source : QueryReport
[java] at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:390)
[java] at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:114)
[java] at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:217)
[java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:138)
[java] at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:106)
[java] at QueryApp.main(QueryApp.java:148)


Any help will be appreciated. The JDBC driver works fine for other applications.

Mark





By: Teodor Danciu - teodord
RE: MS SQL Server JDBC connect problem
2003-02-06 05:39

Hi,

OK. I get it now.
I'll post a patch for this.

Thank you,
Teodor





By: Teodor Danciu - teodord
RE: MS SQL Server JDBC connect problem
2003-02-06 06:00

The patch is here:

https://sourceforge.net/tracker/index.php?func=detail&aid=681655&group_i...

Thank you,
Teodor