JDBC T2 driver returns error 8813 accessing the ResultSet of a select count(*) statement
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Released
|
High
|
Pavani Puppala |
Bug Description
With the JDBC T2 driver, fetching the ResultSet of a select count(*) statement returns the following error:
*** ERROR[8813] Trying to fetch from a statement that is in the closed state.
This is seen using the beta build trafodion-
Here is a small JDBC program to reproduce this problem:
-bash-4.1$ cat mytest.java
import java.sql.*;
import java.math.*;
import java.util.*;
import java.io.*;
public class mytest
{
public static void main(String[] args) //throws java.io.IOException
{
Properties props = null;
Connection conn = null;
ResultSet rs = null;
String cat = null;
String sch = null;
String url = null;
String query = null;
try
{
String propFile = System.
if (propFile != null)
{
url = props.getProper
cat = props.getProper
sch = props.getProper
}
else
{
}
conn = DriverManager.
rs = conn.createStat
if (rs.next() != false)
{
}
}
catch (SQLException se)
{
}
catch (Exception e)
{
}
}
}
Here is the output of the program:
-bash-4.1$ myrun.sh
select count(*)
rs.next()
ERROR: SQLException
*** ERROR[8813] Trying to fetch from a statement that is in the closed state.
Changed in trafodion: | |
milestone: | none → r0.7 |
tags: |
added: client-jdbc-t2 removed: sql |
Changed in trafodion: | |
status: | New → In Progress |
Changed in trafodion: | |
assignee: | nobody → Kevin Xu (kai-hua-xu) |
Changed in trafodion: | |
assignee: | Kevin Xu (kai-hua-xu) → Pavani Puppala (pavani-puppala) |
Changed in trafodion: | |
status: | In Progress → Fix Committed |
information type: | Proprietary → Public |
Try them on the beta v39140 build, the problem still exists
-bash-4.1$ myrun.sh
select count(*)
rs.next()
ERROR: SQLException
*** ERROR[8813] Trying to fetch from a statement that is in the closed state.