The following:
lastExport = dbConn.createStatement().executeQuery(
"select \"PacketID\" from \"FiBRE$PacketsTransferred\"");
lastExport.next();
previousExportID = new Long(lastExport.getLong("PacketID"));

Gives me the error 'Column Unknown PACKETID'. It used to work when the
colum was called PACKETID, but now I have made it mixed case, and edited
all the code in my program appropriately. I also tried:

previousExportID = new Long(lastExport.getLong("\"PacketID\""));

Which gave the error 'Column Unknown "PACKETID"'. Why is it being forced
upper case? Is there a way to access lower case stuff by name? I have
uninstalled Interserver, so I don't know what that did. I know I can use
getLong(1), and I will do that temporarily, but I prefer to use names to
make it clear which field I mean.

Robert Munro
--
Robert (Jamie) Munro - IT department
Viva Network - Helping 'children at risk'
by linking & enhancing the Christian Response
http://www.viva.org/
PO Box 633, Oxford, England, OX2 0XZ
Tel : +44 1865 320131 Switchboard : +44 1865 320 100