MS SQL Server JDBC connect problem

[2002 JI Open Discussion]

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_id=36382&atid=416705

 

Thank you,

Teodor