Re: [Squirrel-sql-develop] JDBC 3.0 compliant == md.supportsSavepoints()?

[Joseph W. <jo...@be...>]

At 10:33 AM 9/22/2006, Joseph Weinstein wrote:
>At 09:57 AM 9/22/2006, Stan Berka wrote:
>>Joseph,
>>FYI, there is a nice and stable driver for Sybase that doesn't have this problem and seems actually better than the jConnect.  It's called jTDS and is here: http://sourceforge.net/projects/jtds
>>-- 
>>Best regards,
>>Stan Berka
>
>Actually, I take my post back mostly. The Squirrel
>code is determining whether a driver is 3.0 compliant
>if that method exists and doesn't throw an exception.
>It seems the Sybase driver does implement the call
>(the driver does implement JDBC 3.0) but the method
>is one that the driver has implemented to throw an
>exception about not using it. This is because the
>Sybase driver can be used with a gateway to ASA (a
>lighter-weight DBMS) as well as ASE. ASA doesn't support
>savepoints, so the driver cannot definitvely answer
>the method's question, and I expect that the jTDS driver
>could also connect to ASA through the same gateway,
>and in that case, it's supportsSavePoint() method
>would return the wrong value.
>   I would suggest that squirrel introspect the
>DatabaseMetaData object and determine 3.0 compliance
>(to a first rough guess) if the object simply has a
>supportsSavePoints() method.
>
>HTH,
>Joe Weinstein at BEA Systems


I would suggest changing the Session.java to do this:

isJDBC3.0Compliant = false;
try {
   md.getClass().getMethod("supportsSavepoint", null);
   isJDBC3.0Compliant = true;
} catch ( Exception ignore){}

Joe Weinstein at BEA Systems





>>Joseph Weinstein wrote:
>>>Hi.
>>>I saw a sybase driver newsgroup post about squirrel saying
>>>sybase's 3.0 driver wasn't JDBC 3.0 compliant. I looked at
>>>Session.java, which decides a driver isn't 3.0 compliant
>>>if the DBMS doesn't support savepoints. That seems silly.
>>>HTH,
>>>Joe Weinstein at BEA Systems
>>>
>>>  
>>>>>Register now for BEA World 2006 --- See http://www.bea.com/beaworld<<
>>>>>      
>>>_______________________________________________________________________
>>>Notice:  This email message, together with any attachments, may contain
>>>information  of  BEA Systems,  Inc.,  its subsidiaries  and  affiliated
>>>entities,  that may be confidential,  proprietary,  copyrighted  and/or
>>>legally privileged, and is intended solely for the use of the individual
>>>or entity named in this message. If you are not the intended recipient,
>>>and have received this message in error, please immediately return this
>>>by email and then delete it.
>>>
>>>-------------------------------------------------------------------------
>>>Take Surveys. Earn Cash. Influence the Future of IT
>>>Join SourceForge.net's Techsay panel and you'll get the chance to share your
>>>opinions on IT & business topics through brief surveys -- and earn cash
>>>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>>_______________________________________________
>>>Squirrel-sql-develop mailing list
>>>Squ...@li...
>>>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
>>>
>>>  

>>Register now for BEA World 2006 --- See http://www.bea.com/beaworld<<
_______________________________________________________________________
Notice:  This email message, together with any attachments, may contain
information  of  BEA Systems,  Inc.,  its subsidiaries  and  affiliated
entities,  that may be confidential,  proprietary,  copyrighted  and/or
legally privileged, and is intended solely for the use of the individual
or entity named in this message. If you are not the intended recipient,
and have received this message in error, please immediately return this
by email and then delete it.