Hi Frank,
first, is your syntax correct: SELECT INTO, not INSERT INTO? (may be this is
just misprint)
Our experience with JDBC drivers for SQL 7 was the following: JDBC-ODBC
bridge works perfect except the cases when we forget to close connection,
for example. In these cases it crushes, instead of throwing exception.
Driver shipped with Advanced or Enterprise Edition (from Merant) was awful:
it worked fine for simple queries, but for complex ones driver accidentially
moved closing parenthesis to the end of query (this effect can be seen using
SQL Server Profiler). I tried to get help here without success.
Regards,
Vitaly.
----- Original Message -----
From: "Frank W. Hill" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 9:30 PM
Subject: Looking for good JDBC-ODBC Drivers
> Hello all,
>
> I am working on an application that will have around 100 to 125 concurrent
> web based connections to MS SQL Server 7.0. The java servlet/html form
> application will allow data entry and edits to the database from remote
> sites while the corporate staff will access it via an MS Access front end
> (to be developed by my clients internal staff).
>
> I have been developing against an Access 97 database as the selection of
SQL
> Server 7.0 was just made. When I try the following:
>
> String SQLString = "SELECT INTO mytable (Field1, Field2, Field3, Field4)
> VALUES (?, ?, ?, ?);
> PreparedStatement ps = dbConnection.prepareStatement(SQLString);
> ps.setString(1, stringVariable);
> ps.setDate(2, java.sql.DateVariable);
> ps.setTime(3, java.sql.TimeVariable);
> ps.setDouble(4, doubleVariable);
> int NumberOfRecordsInserted = ps.executeUpdate();
> ps.close();
>
> the freebie JDBC-ODBC Bridge from Sun crashes javaw.exe on my server (JRun
> 2.3.3 an JRun 3.0). Anyway, I believe that is what is happening after
> checking the web for clues. The stdout.log tells me that I have a syntax
> error in the query, but I just don't see it. I have run similar, though
> less complex, queries without error. Those applications did not maintain
a
> connection pool and were limited to one user at a time.
>
> So, I downloaded aveConnect from Atinav and after installing it, my server
> has become so unstable that I have elected to wipe it and start over. I
may
> have made an error installing it, so if you folks tell me that aveConnect
is
> the greatest thing since slice bread, I'm willing to give it another go.
>
> Now, after that long diatribe, what I'd like help with is the selection of
a
> "GOOD" and "AFFORDABLE" JDBC driver for MS SQL Server 7.0 and, optionally,
> for MS Access 97/2000 also. A point in the right direction to get clear
> installation and configuration help would also be appreciated.
>
> Thanks in advance.
> Frank Hill
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
