Re: [uportal-dev] Hibernate 4.1.9 & the jTDS (SQL Server) driver

[Eric Dalquist]

Yeah, we've seen that same error reported on the lists with some older Oracle drivers as well though the 11.x series work correctly.

-Eric


On 1/11/13 3:51 PM, Makarov, Konstantin V. wrote:

I'll see if I can get a JDK7 nightly build of 4.0 setup early next week so we can verify that it works there as well.

Erik,

I was not aware of the importance of the NaturalID feature.



Is anybody running 4.0.9 on JDK7 already? I may give it a try as well.





Thank you,

Kostya

Before Drew suggested rolling back to 4.1.6 I was about to look at the MS JDBC 4.0 driver. I think I'll give it a try with hibernate 4.1.9. BTW, below is the exception I was getting when trying to import some portlet-definition files. java.lang.AbstractMethodError: net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setCharacterStream *From:*bounce-26616313-58214...@lists.wisc.edu [mailto:bounce-26616313-58214...@lists.wisc.edu] *On Behalf Of *Eric Dalquist

*Sent:* Friday, January 11, 2013 5:01 PM
*To:* uportal-dev@lists.ja-sig.org










-Eric

On 1/11/13 2:37 PM, Drew Wills wrote:

    Hey folks,

    Kostya at SCSU brought an issue to my attention that I think is
    worth noting...

    It seems that -- starting with v4.1.7 -- Hibernate requires JDBC4
    support:

      - https://hibernate.onjira.com/browse/HHH-7778

    But the jTDS driver is targeting JDBC4 for their 1.3 line:

      -
    
http://sourceforge.net/p/jtds/news/2012/10/jtds-jdbc-driver-127-and-130-released/

    JTDS is a popular 3rd-party driver for MS SQL Server.

    The issue is that 1.3 also (apparently) _requires_ Java 7. I know
    there has been much recent work to support Java 7... where are we
    on that?  Is that (as I seem to remember) a uP 4.1 only thing?

    The uP4 manual still says Java 7 not supported:

      - https://wiki.jasig.org/display/UPM40/Requirements

    I have suggested that _perhaps_ rolling the version of hibernate
    back (from 4.1.9 currently) to 4.1.6 would allow the most recent
    jTDS 1.2 driver to work.

    drew

--

You are currently subscribed to uportal-dev@lists.ja-sig.org as: 
eric.dalqu...@doit.wisc.edu
To unsubscribe, change settings or access archives, see 
http://www.ja-sig.org/wiki/display/JSG/uportal-dev

*Subject:* Re: [uportal-dev] Hibernate 4.1.9 & the jTDS (SQL Server) driver uPortal 4.0.9 should run on JDK7, I'm not sure about build time issues but they should be easy to resolved and it would be nice if 4.0.10 could build and run on both 6 and 7. I already did work so that 4.0.10 will run on Tomcat 6 and 7. While I realize we need to get a real solution out it seems rather poor of jTDS to not support the JDBC4 spec with a JDK6 driver since the JDBC4 spec was _part of_ the JDK6 release. Hibernate 4.1.7, 4.1.8, and 4.1.9 all contain patches for the NaturalID feature that uPortal 4.0 is using heavily and can be affected by in some cases. I'd be strongly opposed to rolling back the hibernate dependency and potentially introducing bugs that would affect everyone due to jTDS's poor API tracking. Honestly I'd get start a thread with jTDS and then cross-post it to the uportal-user email list encouraging everyone that uses MSSQL to chime in. Its rather poor form that they don't support a JDBC API that has existed since day one in Java 6 (as far as I can tell anyways)

smime.p7s
Description: S/MIME Cryptographic Signature