the JDBC driver pg73jdbc2.jar.
I'm trying to run code from my old CF 5 server, which used an ODBC driver.
On the new server, one of my queries is failing with the following error:
No class found for bit
at
org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connection.java:693)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:117)
at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:147)
etc.
etc.
etc.
This is for a table that contains three variables of type bit(1). When I
copy and paste this query into psql, it runs fine, so it isn't a problem
with the query itself, but with the driver interface. Apparently it doesn't
recognize bit type variables. Since these variables are basically for
"yes","no" answers, I wouldn't mind changing them all to boolean types, but
I can't seem to get the ALTER TABLE command to work to do an ALTER COLUMN
TYPE - I suspect because for some reason it doesn't have an implicit
assignment for how to convert type bit to type boolean. There's enough data
here that doing it by hand would be a huge task. (Don't even get me started
on why my student programmer chose a bit type for these instead of a
boolean type, which to my mind would have made more sense...)
Anyway, does anyone have any clues how to get this working? Anyone else
encounter problems with the JDBC driver not recognizing bit data types? I
am doing an export from the old server to the new server, so if there's a
way to have it import into a new data type, that would be another
solution... we haven't gone live with this server yet, so I can drop the
database and re-import it if needed...
Any and all suggestions welcome!
Mary
________________________________________________
Mary J. Winters-Meyer [EMAIL PROTECTED]
(217) 244-0712(Work) (217) 244-1230(Fax)
__________________________
Network Analyst, Dept. of Crop Sciences, University of Illinois
http://www.cropsci.uiuc.edu
_______________________
Every so often, I like to go to the window, look up, and smile for a
satellite picture.
-- Stephen Wright
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
