What version of JDBC driver do you use?

Thanks!
Roman Rokytskyy

--- In Firebird-Java@yahoogroups.com, "Robert (Jamie) Munro" <rjmunro-
egroups@i...> wrote:

> 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