NullPointer in DataView with aggregate function in sql with the database Intersystems Caché.
I configure the JDCB Driver from Intersystems database Cachße 2007.1, after executing an
sql statement with an aggreate function: "SELECT COUNT(*) FROM Cinema.Film" the DataViewTablePanel get an
NullPointer exception. As far as i see the reason is an NullPointer in DBColumn (75) because the
table is NULL. I looks like that the ResulSetMetaData.getTableName() is also NULL.
This sounds a lot like the bug andrei from the deva alias was going to fix. sansan, are you "andrei?" If so, I'll
assign this bug to you.
No, sansan is not andrei ;) sansan = Andreas Schneider ( from firstname.lastname@example.org mailing list )
To make the issue more clear:
I see this NPE only with the JDBC Driver for InterSystems database Caché! Aggregate functions with MS SQL Server
Sorry, Andreas, I do that with names, it's a real weakness. Assigning to you, look forward to the patch.
Created attachment 73785 [details]
fix looks fine to me.
I say go ahead and commit the fix.
sansan, were you planning on integrating the fix ?
Sorry, I missed the patch being submitted! Yes, I agree, looks good.
Andreas (sansan) can't integrate the patch, he doesn't have commit rights.
John, do you want to go ahead and integrate it?
Thanks, Andreas! You may have fixed another bug for us too! :)
integrated fix by sansan
will this be in a daily build ?
This will be available in daily builds but probably not until Fri.
I can send you a jar file if you want to try it out, but this is not an official release
yes, if you could send me a jar I'll test it and see if that fixes the Sybase issue also.
I verified that this also fixes the NullPointerException when using the Merlia driver with MS SQLServer
Integrated into 'main-golden', will be available in build *200811191401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
User: John Baker <email@example.com>
Log: #153219 commit fix by user sansan
Verified according to comments.
*** Issue 150950 has been marked as a duplicate of this issue. ***
Should have been a P2 and also should be included in the 6.5 patch since this is probably a regression from 6.1
*** Issue 142612 has been marked as a duplicate of this issue. ***
The fix has been ported into the release65_fixes repository.
We get this issue on Sybase also so it's not just "Intersystems Caché"