Though this is not directly related to EJB, I found it pertinent, so please bear with me. We have been using a Type-4 JDBC driver for our application (that uses swing etc). Now when we are trying to move to a web-based application using Servlets + EJB, we figured we could as well use type-1 driver (jdbc-odbc), if only to test some of our code. Yes, we are on NT4.0. But we see plenty of differences in terms of actual implementation. What I mean is the code that was working smmothly with the other driver needs to be tinkered with to make it work here. e.g.: if I have a query that goes ... "select a,b, from tablex" (using jdbc-odbc bridge driver), a) I am forced to 'get' the columns in the same order as in the query, a first and then b. b) the odbc- layer is case sensitive. (column names) c) there seems to be some difference in the way a stored proc is called. Are we expected to live with one 'driver' ? I always dreamt that changing the driver should not result in changes at the code level... =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
