Activity for jTDS - SQL Server and Sybase JDBC driver

  • Wira Wira created ticket #785

    Issuing statement cancel from parallel thread is NOT thread-safe, leads to silently returning incorrect query results

  • juwoco juwoco posted a comment on ticket #725

    Thanks! You just saved me a lot of emergency work on a legacy system after our db sever went SSL only.

  • Anonymous posted a comment on ticket #138

    jtds 1.3.1 does not work on Android when MSSQL Server network configuration is set to use Force Encryption. Kindly advise.

  • And And posted a comment on ticket #138

    Hi, Does jtds 1.3.1.jar support TLS 1.2? If not, can you provide the jtds that can support TLS 1.2?

  • Vincent Bezzina Vincent Bezzina created ticket #784

    Thread lock up on getConnection()

  • AlBundy33 AlBundy33 posted a comment on ticket #138

    https://jtds.sourceforge.net/faq.html search for ssl

  • And And created ticket #138

    jtds-1.3.1.jar Support encryption?

  • Stan Mihaela Stan Mihaela posted a comment on ticket #759

    I think there is a bug in the communication between the client and the database in an SSL context in some situation like was described before: client hangs expecting answer from the server . The socket used for communication was closed too early and the client could not retrieve the data. I think the fix should take into consideration the moment when the socket gets closed (not after sending the request but after the entire response is received from the server)

  • Dina Dina created ticket #783

    Cannot import into SQL Server table. Import option is absent

  • JeP JeP posted a comment on discussion Help

    Hello, I want to use jtds with Windev to connect SyBase but i don't know how! Please help me.

  • Marshall Ellis Marshall Ellis posted a comment on discussion Help

    We are trying to utilize JTDS with Sybase and Android. We are using the "SQL Anywhere" formerly Sybase Anywhere (we think???) and it seems as if we are talking to Sybase (Sybase 9) because the exception is "Login Failure" and we are using a connection string such as: String conn_str = "jdbc:jtds:sybase://192.168.1.100:2638/dbname"; Then calling: conn = DriverManager.getConnection(conn_str, "user", "passwd"); We keep getting the login failure with a known good user and passwd??? VERY difficult to...

  • Leo Chen Leo Chen created ticket #782

    JtdsConnection is blocked

  • Pavi Pavi posted a comment on discussion Open Discussion

    I also get the same exception . Restarting the server solved this issue. Does anyone know the reason.

  • Rafael Rafael posted a comment on discussion Open Discussion

    Hi everyone, I read the overview documentation and looks like it works only up to Sybase 15. Do you know if is there any way to put it to work on Sybase 16?

  • Bladimir Silva Toro Bladimir Silva Toro posted a comment on discussion Open Discussion

    I have a mobile application developed in B4A that uses jTDS 1.3.1. This mobile application connects to Microsoft SQL Server Express 2019. It is currently working perfectly with 25 concurrent users. Very grateful to this library and the developers who are working to improve it.

  • Jorge Fernández Treviño Jorge Fernández Treviño posted a comment on discussion Help

    Hello everyone. I was wondering what's the latest (and working) Java version supporting jTDS driver (v1.3). I'm working on an integration (https://docs.splunk.com/Documentation/DBX/3.6.0/DeployDBX/Installdatabasedrivers) and in the documentation says that the only supported version is Java 8 but currently Java 11 (jre-11.0.11.0.1) is being used and it's working. Can anyone confirm if using jTDS v1.3 with Java 11 is fully supported? Or do we need to use the latest version of the jTDS driver? Thank...

  • James James posted a comment on discussion jTDS Developer

    Hi, I have a Crystal Report file ( *.rpt) and opened it in the SAP Crystal Report Application (Version 14.2). What Im looking for is, how can I extract(or show) the details of the Database connection URL (JDBC) of this report, if I open the Database Wizard and look into the "my Connection" tree, I see the connection and open it, but I cant see any details about the Connection-URL (see below picture), how can I extract(show) the ALL connection details of an opened report. Thanks!

  • Anonymous posted a comment on ticket #73

    +1 on request for resolution

  • Jeffrey P Nelson Jeffrey P Nelson posted a comment on discussion Open Discussion

    We have been using the drive in an application called Cleo Clarrify. Cleo uses this driver to call over to an mssql2012 server. Both servers are windows server 2012R2. This has been working flawlessly for years. We have just recently built a new VM (win2012R2) and installed SQL2016. Everything stayed the same on the Cleo server. The DBA team upgraded all mssql instances to 2016. Since then we have had many issues, The Cleo app makes the call using a string like: jdbc:jtds:sqlserver://srvName:1433;DatabaseName=Cleo;USENTLMV2=true;domain=myD.com...

  • ema mle ema mle posted a comment on discussion Open Discussion

    My expertise is that this venture is not lively. Somewhat disappointing to me as we've liked having one driving force for MSSQL and Sybase like this, but in case you're having problem with SQL Server, I'd advise the use of MS's motive force. I don't know that there is any advantage to jTDS at this point.

  • danilo mario danilo mario created ticket #781

    don't read table record

  • Brennan Sebastian Brennan Sebastian posted a comment on discussion Open Discussion

    Hi William. I have used JTDS on SQL Server 2014 (in the year 2015). This version was used in Production on a few very busy, mission critical, servers with no issues. By the way, more recently (maybe in 2018/2019) I've used the MS drivers and actually had issues with them in a non-production environment. Unfortunately I don't remember the details of the issues. On Tue, Oct 20, 2020 at 4:15 PM William Williford wwilliford@users.sourceforge.net wrote: Hi: There is concern that the current version of...

  • Brennan Sebastian Brennan Sebastian posted a comment on discussion Open Discussion

    Hi William. Don't know when it was last updated and no I have not used this version with the latest SQL Server. Regards Brennan On Tue, Oct 20, 2020 at 3:34 PM William Williford wwilliford@users.sourceforge.net wrote: Hi: When was the last time the JTDS driver was updated and has anyone used the most current version with Sql Server 2020? JTDS driver Support for current versions of SQL Server (2020/2021) https://sourceforge.net/p/jtds/discussion/104388/thread/1131695541/?limit=25#5351 Sent from sourceforge.net...

  • John Craig John Craig posted a comment on discussion Open Discussion

    I don't know that I've actually used it on anything later than 2016, but, IIRC, it does work there. I don't know that there've been any substantial changes to the TDS protocol with more recent versions of SQL Server, but I'm not up on the details of that any more. I think most people use Microsoft's own JDBC driver nowadays. That's what we use in production at my day job. I still use jTDS 1.3 with my own side business, but much of that is with older versions of SQL Server. I'm not sure there's terribly...

  • William Williford William Williford posted a comment on discussion Open Discussion

    Hi: There is concern that the current version of JTDS is not being updated to support the most current versions of Sql Server (2014 thru 2019). Can someone tell me when the last stable version of the JTDS driver and whether anyone is using this version for production work with more current SQL Server versions (2014, 2016, 2017, 2019)? Appreciate timely response.

  • William Williford William Williford posted a comment on discussion Open Discussion

    Hi: When was the last time the JTDS driver was updated and has anyone used the most current version with Sql Server 2020?

  • momo momo posted a comment on discussion Help

    What exactly do you expect? The ResultSet 'rs' should contain the query result but you never process that result. Everything looks okay so far... or do you get an exception? Where does the mentioned output come from?

  • momo momo posted a comment on discussion Help

    Such error is raised by the server whenever it cannot perform a conversion between client and server encoding. But I don't have an idea what is causing the error in your specific case. There are simply too much variables... Maybe you could try to add some debugging to your procedure to find the exact step that fails. And maybe write a Java 10-liner for calling the procedure and process the result that you can easily debug on the client side.

  • Ashok Ashok modified a comment on discussion Help

    try { string query = "select column1 from table 1 where key=primary key"; Statement state = conn.createStatement(); ResultSet rs = state.executeQuery(query); } catch (Exception e) { e.printStackTrace(); }

  • Samadrita Bhattacharya Samadrita Bhattacharya posted a comment on discussion Help

    We suspected that too so the stored proc was executed separately and it didn't raise any error. I see the TDS error token but also see that it comes during processing of the output of the stored proc. Any direction as to when such an error is raised?

  • Ashok Ashok posted a comment on discussion Help

    try { string query = "select column1 from table 1 where key=primary key"; Statement state = conn.createStatement(); ResultSet rs = state.executeQuery(query); } catch (Exception e) { e.printStackTrace(); }

  • momo momo posted a comment on discussion Help

    You can clearly see from the attached stacktrace that the driver receives a TDS error token, so the error is definitly raised by the server. I can only guess, but maybe the stored procedure successfully inserts the data and then raises the error?

  • Samadrita Bhattacharya Samadrita Bhattacharya posted a comment on discussion Help

    Thanks for the response. I will check out the connection property. However, when you say error is raised by the server, then the data should not have been inserted into the database. But in this case it does get inserted into the table, with a '?' and we get an error back. And we don't get the exception when inserting same data directly into the table, using a db client.

  • momo momo posted a comment on discussion Help

    The error is raised by the server. You should make sure that the "charset" connection property matches the character set the server was installed with. If you try inserting characters not supported by that charset, this should be handled by your client code. And maybe have a look at the "sendStringParametersAsUnicode" connection property...

  • momo momo posted a comment on discussion Help

    Your output looks like you simply called toString() on the result. Could you please share the source code?

  • Ashok Ashok posted a comment on discussion Help

    Hi, I am trying to retrieve VARBINARY column with huge binary data (zip) using jtds as below, but could not see the result. select column1 from table 1 where key=primary key; Output : net.sourceforge.jtds.jdbc.BlobImpl@e999cf31 ODBC could fetch the data but very slow and trying with jtds first time. Am I missnig something? Kindly help.

  • Samadrita Bhattacharya Samadrita Bhattacharya posted a comment on discussion Help

    Any help on this?

  • Samadrita Bhattacharya Samadrita Bhattacharya modified a comment on discussion Help

    Hi, I am working on a Mule (java based ESB) application that is required to invoke a sybase stored procedure that has some input parameters and 2 output parameters. We are using jtds 1.3.1 version as the driver to connect to the db and passed the charset in the url as ISO-8859-1 (as UTF 8 was not working for norwegian characters). Now the problem is for inputs with certain special characters, like, Łuczak, D'Amico and some other values which comes as part of user inputs (god knows where they copy...

  • Samadrita Bhattacharya Samadrita Bhattacharya posted a comment on discussion Help

    Hi, I am working on a Mule (java based ESB) application that is required to invoke a sybase stored procedure that has some input parameters and 2 output parameters. We are using jtds 1.3.1 version as the driver to connect to the db and passed the charset in the url as ISO-8859-1 (as UTF 8 was not working for norwegian characters). Now the problem is for inputs with certain special characters, like, Łuczak, D'Amico and some other values which comes as part of user inputs (god knows where they copy...

  • JAIME MIUR JAIME MIUR posted a comment on discussion Help

    I have an app developing with B4A, I want to connect to a remote Sql DB that is in amazon aws, but the driver only allows me to connect with IP addresses, how can I do it? ...... jdbc:jtds:sqlserver:database-1.cmb9999999.us-east-2.rds.amazonaws.com:1433 .......

  • Anonymous posted a comment on ticket #60

    Do we have any jtds versions supporting SSL for Sybsae? Whenever I try to connect, I get SocketException - Connection Reset Errors.

  • Anonymous posted a comment on ticket #130

    Honestly with the release of the Microsoft SQL driver you should just switch over to that. https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

  • Anonymous posted a comment on ticket #130

    How to apply the .patch file changes in the library in android

  • Gernot Gernot posted a comment on discussion Help

    I do have the similar problem using jtds 1.3.1 as well. I cannot turn of the minimal required TLS version at my azure database for connection. This is the exact error I get: java.sql.SQLException: Network error IOException: SSL handshake aborted: ssl=0x7cd9419c00: I/O error during system call, Broken pipe Does anyone do have a solution for that matter by now?

  • Tim Boemker Tim Boemker modified a comment on discussion Open Discussion

    The issue was actually Bug #725 jTDS driver ssl connection hangs with JRE 1.8 There is a patch in the thread for that bug, but it sure would be nice if there were a new release with that patch & any other critical ones. My point is that some companies pay for other, commercial drivers which are not as good as jTDS & would pay for someone to support jTDS. BTW, I did try applying that source patch & building. I am seeing a handful of errors in the unit tests. For someone who knows TDS and the code,...

  • Tim Boemker Tim Boemker modified a comment on discussion Open Discussion

    The issue might actually be Bug #725 jTDS driver ssl connection hangs with JRE 1.8 There is a patch in the thread for that bug, but it sure would be nice if there were a new release with that patch & any other critical ones. My point is that some companies pay for other, commercial drivers which are not as good as jTDS & would pay for someone to support jTDS. BTW, I did try applying that source patch & building. I am seeing a handful of errors in the unit tests. For someone who knows TDS and the...

  • Tim Boemker Tim Boemker posted a comment on discussion Open Discussion

    The issue might actually be Bug #725 jTDS driver ssl connection hangs with JRE 1.8 There is a patch in the thread for that bug, but it sure would be nice if there were a new release with that patch & any other critical ones. My point is that some companies pay for other, commercial drivers which are not as good as jTDS & would pay for someone to support jTDS.

  • momo momo posted a comment on discussion Open Discussion

    Hi Tim, ticket 129 has been closed years ago. Do you mean ticket 729? Cheers, momo

  • Tim Boemker Tim Boemker posted a comment on discussion Open Discussion

    I see that this project hasn't been maintained in quite a while, and the issue described in Ticket 129 still exists in the last official release. Someone skilled in the implementation could turn this into a commercial product. It's better than any other free or commercial driver I've seen.

  • Anonymous posted a comment on ticket #73

    +1 on request for resolution

  • Marcelo Pessoa Marcelo Pessoa modified a comment on discussion Help

    Hello, I am performing an MSSQL migration to Oracle. However, I am having trouble connecting. I am using SQL Developer 19.4.0.354 and java 1.8.0_221. I'm having a connection error when trying to establish a connection using hostname = host_ip \ instance. Does anyone have any tips? Thank you.

  • Marcelo Pessoa Marcelo Pessoa modified a comment on discussion Help

    Hello, I am performing an MSSQL migration to Oracle. However, I am having trouble connecting. I am using SQL Developer 19.4.0.354 and java 1.8.0_221. I'm having a connection error when trying to establish a connection using hostname = host_ip \ instance. Does anyone have any tips? Thank you.

  • Marcelo Pessoa Marcelo Pessoa posted a comment on discussion Help

    Hello, I am performing an MSSQL migration to Oracle. However, I am having trouble connecting. I am using SQL Developer 19.4.0.354 and java 1.8.0_221. I'm having a connection error when trying to establish a connection using hostname = host_ip \ instance. Does anyone have any tips? Thank you. [cid:image002.jpg@01D6134A.19C33720] Marcelo Augusto Pessoa Desenvolvimento Consórcio Tel: (11) 3478-4825 (11) 9-7560-9335 marcelo.pessoa@sinqia.com.brmarcelo.pessoa@sinqia.com.br Esta mensagem e seus anexos...

  • bhausaheb Shedbale bhausaheb Shedbale posted a comment on discussion jTDS Developer

    Hi All, We have SQl Server 2016 database and I am able to connect using windows authtentication, but for application we are not able to use indivisual user id and password, In my company we have created systema ccounts and for those accounts are part of active directory group, Now From my machine through Java I am trying to connect DB with service account but its fials withe below error. Error while creating database connection: java.sql.SQLException: Login failed. The login is from an untrusted...

  • japonese se japonese se modified a comment on discussion Help

    my probrem “ssl=require” does not solved. I recieve the error: Exception in thread "main" java.sql.SQLException: Network error Ioexception: Connection reset Unknown what the cause. Help me server is mssql2016

  • japonese se japonese se modified a comment on discussion Help

    my probrem “ssl=require” does not problem. I recieve the error: Exception in thread "main" java.sql.SQLException: Network error Ioexception: Connection reset Unknown what the cause. Help me server is mssql2016

  • japonese se japonese se posted a comment on discussion Help

    my probrem “ssl=require” does not problem. I recieve the error: Exception in thread "main" java.sql.SQLException: Network error Ioexception: Connection reset Unknown what the cause. Help me

  • Anonymous posted a comment on ticket #63

    Any Updates?

  • george george posted a comment on discussion Help

    iam trying to connect to MS Sql Server2005 , from android studio 3.5 , iam using jdk1.8 and jar library jtds1.3, and iam setting the following in system variables : _JAVA_HOME C:\Program Files\Java\jdk1.8.0_231 _JAVA_OPTIONS -Xmx512M CLASSPATH .;C:\Program Files\Java\jdk1.8.0_231\bin;C:\Program Files\Java\jre1.8.0_231\bin;C:\jtds-1.2.7\jtds-1.2.7.jar;C:\jtds-1.2.7\;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;C:\jdbc4.1\sqljdbc_4.1\enu\jre7\sqljdbc41.jar;%JAVA_HOME%\bin;%JRE_HOME%\bin;C:\Program...

  • Pallavi Khandekar Pallavi Khandekar posted a comment on discussion jTDS Developer

    I am using jdbc 7.4 for jre 8 version and latest jtds jar. I am trying to connect to sql server on azure. Connection works fine but when getTables in metadata class in jtds is call it creates query <database name=""> .. sp_tables which is not supported by Azure and throws exception. Any workaround for this? </database>

  • Manju Manju posted a comment on discussion Help

    Hi , I have an spring boot application that was using data from MS SQL server 2008 . Now the data is migrated to MS SQL sever 2017 , username and password was not changed. Since then every time when the application try to connect I get "Unable to acquire JDBC Connection; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection" I use the jtds 1.3.1 driver. I can connect to the database using the management tool with the same username and password.The...

  • Fernando Fernando posted a comment on discussion Open Discussion

    Hi Jun! Can you provide the solution please? Thanks,

  • Gajendra Agrawal Gajendra Agrawal posted a comment on discussion Help

    has JTDS added SSL Support for Sybase?

  • Peter Morgan Peter Morgan created ticket #780

    SQL syntax exception on first rs.next() on result set from PreparedStatement (...ResultSet.TYPE_SCROLL_SENSITIVE..)

  • Anonymous posted a comment on ticket #63

    Any updates?

  • john john posted a comment on discussion Help

    “ssl=require” solved my problem too. Thank you very much!

  • Nida Nida posted a comment on ticket #129

    I dont think anyone is actively working on the project. It did work for me when I manually built the project. Thanks, Nida On Tue, Sep 17, 2019 at 5:19 PM noreply@sourceforge.net wrote: Is this fixed ? [patches:#129] jTDS driver ssl connection hangs with JRE 1.8 Status: closed Group: v1.3 Created: Sun Oct 19, 2014 08:48 PM UTC by lkoniecki Last Updated: Tue Feb 05, 2019 05:34 AM UTC Owner: momo Attachments: TdsTlsOutputStream.diff (5.4 kB; application/octet-stream) Patch for https://sourceforge.net/p/jtds/bugs/725/...

  • Anonymous posted a comment on ticket #129

    Is this fixed ?

  • Erik McCarty Erik McCarty posted a comment on discussion Help

    ditto

  • Bernd Eckenfels Bernd Eckenfels posted a comment on discussion jTDS Developer

    you have to change the default in the source, it is 100 and cant be changed as a URL parameter. You can limit it on the statement, possibly your Pool implementation can be configured to set that on the new statements. https://github.com/seeburger-ag/jTDS/blob/jTDS_1.3_(stable)-seeburger/src/main/net/sourceforge/jtds/jdbc/JtdsStatement.java#L87

  • Muralidhar Tangudu Muralidhar Tangudu posted a comment on discussion jTDS Developer

    how can I pass fetchsize on the connection string for sql server? Anyone?

  • Muralidhar Tangudu Muralidhar Tangudu posted a comment on discussion jTDS Developer

    how can I pass fetchsize on the connection string for sql server? Anyone?

  • Muralidhar Tangudu Muralidhar Tangudu posted a comment on discussion jTDS Developer

    how can I pass fetchsize on the connection string for sql server? Anyone?

  • Muralidhar Tangudu Muralidhar Tangudu posted a comment on discussion jTDS Developer

    how can I pass fetchsize on the connection string for sql server? Anyone?

  • Muralidhar Tangudu Muralidhar Tangudu posted a comment on discussion jTDS Developer

    how can I pass fetchsize on the connection string for sql server? Anyone?

  • Eric Riddle Eric Riddle posted a comment on discussion Help

    I have no idea what a classpath is. I have searched everywhere and keep seeing that you are to drop the .jar file in the applications classpath. I have no idea what that is for SQL Server. Any help would be greatly appreciated.

  • AP AP posted a comment on discussion Open Discussion

    I am able to connect to the SQL server using user name & password from our application with kerberos authentication. But our customer prefers to use keytab file instead of passing the password over the network. When I try to use keytab I am facing some issues as below. Our SQL server's SPN is: MSSQLSvc/myhost:1433@MYDOMAIN.COM I have created keytab file as: ktpass -out "C:\Users\myuser\KerberosConf\MSSQL\myappserver.keytab" -princ MSSQLSvc/myhost:1433@MYDOMAIN.COM -mapUser mydomain\myuser-pass Test@123...

  • Anonymous posted a comment on ticket #73

    +1 on request for resolution

  • David Kuiper David Kuiper posted a comment on discussion Help

    I am unable to connect to a SQL 2012 database when it requires TLS1.2 encrytion. Using a string similar to "jdbc:jtds:sqlserver://servername:1433/databasename;domain=domainname;useNTLMv2=true;ssl=request" The server responds with " The connection test failed: Unable to open a connection to the database: Network error IOException: Connection reset". I am able to connect to a second database which does not require the TLS encryption.

  • David Kuiper David Kuiper posted a comment on discussion Help

    I have a similar problem using jtds 1.3.1 to connect to SQL 2012 from a jjava application running on linux. The connection succeeds using a simple string "jdbc:jtds:sqlserver://servername:14334/databasename;instance=instancename;domain=domainname;useNTLMv2=true" but fails when using a similar string connecting to a second database. The second DB forces TLS encryption. The string for the second connection also has the "ssl=request" parameter.

  • Taylan Kammer Taylan Kammer posted a comment on discussion jTDS Developer

    This is normal and a "limitation" of Android. (Or a feature, depending on how you look at it.) Not really related to jTDS. You should execute all code that may use the network in a background thread. Note that this includes operations on a ResultSet instance such as rs.getInteger("foo"). In my app, my strategy is to fully process the ResultSet into a Java object (or a list thereof) which represents the database objects, then call a main-thread callback with that data model object. Making heavy use...

  • Taylan Kammer Taylan Kammer posted a comment on discussion Help

    Same problem. In fact, even when just using ssl=request (not require) I get the "SSL handshake aborted ... Broken pipe" exception, regardless of whether the SQL Server wants to enforce encryption. In other words, jTDS is not even gracefully falling back to non-encrypted communication. Using 1.3.1 on Android.

  • Brenda Reeves Brenda Reeves posted a comment on discussion Help

    I have been using JTDS 1.3.0 for a while with great success. Recently I've been tasked with connecting to a MSSQL database with force-ssl = true. Prior to that change I was connecting to the same database without issue. Once that change was made, however, I have not been able to connect. First, with no changes to my connection string I received this error: java.sql.SQLException: I/O Error: DB server closed connection. Then, I attempted to change my connection string to add ssl=require. This provided...

  • SANTOSH SINGH NEGI SANTOSH SINGH NEGI posted a comment on discussion Open Discussion

    I am new to Jruby. please help me in creating sql connection in RUBY language how to make sql connection using jdbc/jTds how to execute sql query

  • AP AP modified a comment on discussion Open Discussion

    I am using below code with jtds-1.3.1.jar and getting some error try { String filePath = System.getProperty("user.dir") + File.separator + "KerberosConfDir"; Driver d = (Driver)Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); System.setProperty("java.security.krb5.debug", "true"); System.setProperty("java.security.auth.login.config", filePath+File.separator+"login.conf"); System.setProperty("java.security.krb5.conf", filePath+File.separator+"krb5.ini"); System.setProperty("javax.security.auth.useSubjectCredsOnly",...

  • AP AP modified a comment on discussion Open Discussion

    I am using below code with jtds-1.3.1.jar and getting some error try { String filePath = System.getProperty("user.dir") + File.separator + "KerberosConfDir"; Driver d = (Driver)Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); System.setProperty("java.security.krb5.debug", "true"); System.setProperty("java.security.auth.login.config", filePath+File.separator+"login.conf"); System.setProperty("java.security.krb5.conf", filePath+File.separator+"krb5.ini"); System.setProperty("javax.security.auth.useSubjectCredsOnly",...

  • AP AP modified a comment on discussion Open Discussion

    I am using below code with jtds-1.3.1.jar and getting some error try { String filePath = System.getProperty("user.dir") + File.separator + "KerberosConfDir"; Driver d = (Driver)Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); System.setProperty("java.security.krb5.debug", "true"); System.setProperty("java.security.auth.login.config", filePath+File.separator+"login.conf"); System.setProperty("java.security.krb5.conf", filePath+File.separator+"krb5.ini"); System.setProperty("javax.security.auth.useSubjectCredsOnly",...

  • AP AP posted a comment on discussion Open Discussion

    I am using below code with jtds-1.3.1.jar and getting some error try { String filePath = System.getProperty("user.dir") + File.separator + "KerberosConfDir"; Driver d = (Driver)Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); System.setProperty("java.security.krb5.debug", "true"); System.setProperty("java.security.auth.login.config", filePath+File.separator+"login.conf"); System.setProperty("java.security.krb5.conf", filePath+File.separator+"krb5.ini"); System.setProperty("javax.security.auth.useSubjectCredsOnly",...

  • AP AP posted a comment on discussion Open Discussion

    Can anyone respond to this? I am in need of the same..

  • Bernd Eckenfels Bernd Eckenfels posted a comment on discussion Open Discussion

    unfortunatelly yes since the default is no (you may of course recompile this)

  • Bernd Eckenfels Bernd Eckenfels posted a comment on discussion Open Discussion

    ... and if you specify the correct port you dont need to specify the instance name, it just slows down resolving and need the SQL Browser service which is no longer available by default.

  • Bernd Eckenfels Bernd Eckenfels posted a comment on discussion Open Discussion

    the 1.3.1 versions on maven central ave the XA emulation code working, not sure about the native/full XA support (but if you need that most likely the MS driver is better anyway)

  • Bernd Eckenfels Bernd Eckenfels posted a comment on discussion Open Discussion

    Why would you want to use any version older than 1.3.1? Anyway, the Kerberos readme was added in 2.x and since this is not yet available it was backported to 1.3.x here: https://sourceforge.net/p/jtds/code/1236/ which is not included in 1.3.0

  • Bernd Eckenfels Bernd Eckenfels posted a comment on discussion jTDS Developer

    David, I would not expect any upstream (here) releases anymore, it has been silent for years. There are a few forks/local builds where you get (some) patches, but I think all of them are basically on the 1.3.1 version. Having said that, this version does work for me for later SQL servers. So did you actually try it and are you sure you need a new release? (besides not beeng able to use later features of cause).

  • David Matoušek David Matoušek posted a comment on discussion jTDS Developer

    Hello, Is any possibility you will release driver version for SQL server 2017. Thank you for your answer.

  • AP AP posted a comment on discussion Open Discussion

    Can someone help me in which version of JTDS jar , the kerberos support was added? I am checking through many posts but still I could not get a clear info. Also if possible please post a sample code of kerberos in JTDS. Appreciating your help! Thanks

  • Anonymous posted a comment on ticket #101

    Can anyone answred this last question? I am looking for an answer on this. Please help.

  • Michael Wyraz Michael Wyraz modified a comment on ticket #679

    The fix is easy: In TypeInfo.normalizeDataType add "typeName" as parameter and pass the typeName on each call of this function. In the switch statement there, on case -9 return Types.DATE for typeName "date" and "datetime2". I'd provide a PR but it seems that the project is not alive anymore :-/ Edit: Feel free to use my patch: https://github.com/bi-web/jTDS/commit/9c463aaf3a77d3b5870404837a019d812af7aaa3 It's partial, I passed typeInfo only at the places where it was already in a variable. There...

  • Michael Wyraz Michael Wyraz posted a comment on ticket #679

    The fix is easy: In TypeInfo.normalizeDataType add "typeName" as parameter and pass the typeName on each call of this function. In the switch statement there, on case -9 return Types.DATE for typeName "date" and "datetime2". I'd provide a PR but it seems that the project is not alive anymore :-/

  • D Ramos D Ramos created ticket #779

    Intermittent error executing prepared statement in SQLServer 2012

1 >
MongoDB Logo MongoDB