jTDS install on Linux and usable by CF

[lnagy]

I'm running JRun4 in distributed mode with CFMX7 sitting on it, all managed by
SuSE Enterprise Linux 9.
I'm new to Linux and I'm trying to figure out how to install jTDS and
configure it to the CFadmin JDBC list because the driver I have by default is
slow as molasses with tables of record counts exceeding 500.

I've searched everywhere and can't find any references, other than it's been
around since forever and it's easy...
:/

[LL@Work]

Suse Linux 9 is not yet supported for CFMX 7.X. See [url]http://www.macromedia.com/software/coldfusion/productinfo/systemreqs/[/url]

[lnagy]

Um, yes it is. In fact, I had direct support a few months back without any
complaints...following your link, justifies my position...pasted here: ( see
below: SuSE Linux Enterprise Server 8, 9 )

Linux
ColdFusion Product Editions Enterprise, Standard, Developer
Processor 32-bit x86 processors (Intel Pentium II or AMD Athlon class
peformance or better)
Operating System Red Hat Enterprise Linux AS & ES 3.0 or 4.0
SuSE Linux Enterprise Server 8, 9
TurboLinux 8 Server (Japanese only)
Memory 512 MB RAM
Hard Disk Space 500 MB

[lnagy]

As a side note: I've gotten jTDS working with SuSE Linux 9, but not CFMX. I
built a Java class to pull from the remote SQL Server 2k db, and it snaps it
out fast.

The only issue is to get CFMX to see the driver to enable me to build a
reference that can be used in CFM,CFC code, I'm sure it's something rather
simple, yet not knowing what it is... leaves it still broken.

[lnagy]

:brokenheart;

Another disappointment in the CF arena. My entire dual-tiered, dual-clustered
system is depending on improving the SQL Server performance,.... 800 records in
5 seconds, indeed. And all I get from Adobe/MM is, it's not supported on Linux
9....err, although Adobe/MM markets that it is...we've only spent ca$h and
ti:me to build it....now it runs like a turtle. That'll make the CIO,CEO
happy. Go play with flash and the pretty pictures.

[dlasley]

Not to be an M$ basher, but are you tied to MSSQL? I have MX 7.0.1 running on
Solaris 9, hitting MySQL 5.0.16 via JDBC, and there are no perceptible
performance issues even under simultaneous load from batch jobs and transaction
users.

In the experience I've had with CF, from v3 on NT 4 to v7 on Solaris, MSSQL
has been problematic, with the possible short-term exception of the glory days
when we had v4 hooked up to SQL Server 7 on NT 4 back in 98/99.

If you are tied to MSSQL, and have to use ColdFusion on a non-windows
platform, I strongly encourage you to read this:

[url]http://www.devarticles.com/c/a/SQL-Server/How-to-Perform-a-SQL-Server-Performanc[/url]
e-Audit/

&laz;

*Side note: [url]http://www.redev.org/archives/000023.cfm[/url]

[lnagy]

Well, our company was going to use Oracle, I was pushing for Postgres or MySQL.
Then we were 'acquired' by a MS shop. They wanted us to dump the whole Linux
cluster; however, we convinced them...for the time being to leave it as it
is...although we had to comprimise on the database. So we're stuck with MSSQL.

I'll check out your link, thanks. :beer;