Bugs item #506549, was opened at 2002-01-21 09:54
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=506549&group_id=22866
Category: JBossCX
Group: v2.4 (stable)
>Status: Closed
>Resolution: Fixed
Priority: 5
Submitted By: Mike Park (johnnycannuk)
Assigned to: Nobody/Anonymous (nobody)
Summary: jboss XADatasourceImpl scrollable rs pro
Initial Comment:
I'm using jboss2.4.4-tomcat4.0.1 on wint nt 4.0. I
have code in my session bean for getting a dynamic
list of records. Code looks like this
con=this.getConnection();//private method for getting
connections
PreparedStatement ps=con.prepareStatement
(sql,ResultSet.SCROLL_INSENSITIVE,ResultSet.CONCURR_UPD
ATEABLE);
ResultSet rs=ps.executeQuery();
rs.last();
When this is executed with the oracle datasource
configured with the org.jboss.xs....XADataSourceImpl
(the default in the jcml) it returns a forward-only
ResultSet instead of a scroll-insensitive one (like I
asked for)
I can fix this by changing to the OracleXADatasource
class but this causes more problems (like I suddenly
can't insert and get a wack of pl/sql errors).
Funny, I just tested this again but the version from
jboss.2.0_FINAL works fine with the
XADataSourceImpl ...
So is ther a patch or fix for this?
Mike
----------------------------------------------------------------------
>Comment By: Scott M Stark (starksm)
Date: 2002-04-05 09:04
Message:
Logged In: YES
user_id=175228
Fixed for 2.4.5
----------------------------------------------------------------------
Comment By: Mike Park (johnnycannuk)
Date: 2002-01-21 14:16
Message:
Logged In: YES
user_id=6289
Here is the patch that fixes this:
The old call to con.prepareStatement(sql,int,int)
was implemented like this:
public PreparedStatement prepareStatement(String sql, int
resultSetType, int resultSetConcurrency) throws
SQLException {
return this.prepareStatement(sql);
}
it should be like so:
public PreparedStatement prepareStatement(String sql, int
resultSetType, int resultSetConcurrency) throws
SQLException {
if(con == null) throw new SQLException(CLOSED);
try {
return con.prepareStatement(sql, resultSetType,
resultSetConcurrency);
} catch(SQLException e) {
setError(e);
throw e;
}
}
I have tested this out (although not with the test suite
and it works well.
I have included the minimally changed
XAClientConnection.java file
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=506549&group_id=22866
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
