Joe Sam,
I appreciate your thoughts.

Squirrel slowness ended after a forced shutdown of windows,
so I guess copying the jTDS .jar into jTDS's
"application classpath" caused Squirrel to miss-behave ?

After re-start Squirrel runs fine, but none of the three
jTDS drivers show checked, so I guess I'm missing an
install step . . . or maybe I need to move jtds-1.2.1.jar
from folder squirrel-sql-3.5.0 "down" to the lib folder ?

Hmm . . . moved the .jar to folder lib but, after closing
and re-starting Squirrel, I still don't see any jTDS drivers
checked ?

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Sam Shirah
Sent: Thursday, November 21, 2013 4:13 PM
To: Java Programming on and around the IBM i
Cc: Midrange Systems Technical Discussion
Subject: Re: problems attempting adding jTDS driver to Squirrel


Hi Gary,

Call me foolish, but after initially trying the jTDS, and after some starting mis-steps by M$, I went to the Microsoft JDBC Driver for SQL
Server:

http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx

I don't recall any specific complaints about jTDS. I think set up was a little different and there may not have been support for some things I needed at the time. So, this is not a "my dog's better than yours," but I haven't had any complaints so far, and it actually runs in the standard way.

I may sing a different tune in a few weeks as I have an upcoming client migration in which older versions of Glassfish, the JVM and JDBC drivers will be replaced with current versions on new hardware. I'll chime in if I encounter issues.

As to SQuirreL "runs very slowly" check any logs and driver set up.
Also logs on the SQL Server side. As noted, I haven't used the jTDS driver in some time, so google is your friend. Offhand, it sounds like the driver keeps trying to connect, sort of like a loop.

BTW, while cross posting to multiple forums seems like a good idea, if people notice, you often won't get answers on either one.

HTH,


Joe Sam

Joe Sam Shirah - www.conceptgo.com (904) 302-6870
conceptGO - Consulting/Development/Outsourcing
Java Filter Forum: www.ibm.com/developerworks/java
Just the JDBC FAQs: www.jguru.com/faq/JDBC Going International? www.jguru.com/faq/I18N
Que Java400? www.jguru.com/faq/Java400




-----Original Message-----
From: Gary Thompson
Sent: Thursday, November 21, 2013 2:18 PM
To: Java Programming on and around the IBM i
Cc: Midrange Systems Technical Discussion
Subject: problems attempting adding jTDS driver to Squirrel

I am following Dan Kimmel's suggestion to use the JTDS open-source-driver for connections to MS Sequel Server.

I think I got a good download of jTDS from Sourceforge

I think my extract was Ok, and I see a bunch of files and folders with same "Date Time mod" on my Win 7 laptop:

Files
CHANGELOG, jtds-1.3.1.jar, LICENSE, README, README.SSL
README.SSO, README.XA

Folders
x64
x86

Squirrel now runs very slowly and I can't select an SQL statement to run ??
the cursor, in Squirrel, seems un-responsive and will not allow a click on "run", etc

Have not yet been able to close Squirrel . . .




--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/java400-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.