Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After rs.updateString(ColNbr) and rs.updateRow() ==> rs.getString(sameCol) is null #37

Closed
isfce opened this issue Apr 17, 2021 · 5 comments

Comments

@isfce
Copy link

isfce commented Apr 17, 2021

Jaybird v3 or v4 with JAVA 11 (classpath):

Simple Test with TestNG

	try(Statement q07= connexion.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);){
		ResultSet rs=q07.executeQuery("SELECT * FROM COUNTRY");				
		rs.absolute(5);
		String n=rs.getString(2);
		//update column
		rs.updateString(2, n+"_1");
		rs.updateRow();
		
		String r=rs.getString(2);//r is null ????
		assertEquals(r,n+"_1");
		
	} catch (SQLException e) {
		fail();
	}
@mrotteveel
Copy link
Member

The workaround is to add a rs.refreshRow() after rs.updateRow().

@mrotteveel
Copy link
Member

This issue is not reproducible with Jaybird 3. What is the type of the field you're using?

@mrotteveel
Copy link
Member

Fix will be included with Jaybird 4.0.4 and Jaybird 5. Thanks for reporting.

I will close this issue now, but if you are able to reproduce it with Jaybird 3.0.11, then I'd really like a complete reproduction script, including database setup.

@isfce
Copy link
Author

isfce commented Apr 18, 2021

Sorry, It's working fine with Jaybird 3.0.11!

@mrotteveel
Copy link
Member

Sorry, It's working fine with Jaybird 3.0.11!

Thanks for confirming. I'm not yet sure when I'm going to release Jaybird 4.0.4, but if you'd like a snapshot build, let me know.

@mrotteveel mrotteveel added type: bug and removed bug labels Oct 2, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants