Column names

View: New views
3 Messages — Rating Filter:   Alert me  

Column names

by Doychi :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I've just discovered that the different version of MySQL or the JDBC
driver for MySQL return the column names in different cases.  This is
causing me some problems.  I was wondering how difficult it would be to
add an option some where to the API that says to return all column names
in a fixed case (either UPPER or lower, for me doesn't really mater as
long as it is consistent).


--
Doychi
spdoychiam@...

Re: Column names

by brianm :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

jDBI should be toUpperCase ing anything it puts into the map it  
returns (and upper casing anything retireved via get(..).

What behavior are you seeing that is causing the problem?

(see org.skife.jdbi.RowMap.java )

-Brian

On Apr 7, 2006, at 6:06 AM, Doychi wrote:

> Hi,
>
> I've just discovered that the different version of MySQL or the  
> JDBC driver for MySQL return the column names in different cases.  
> This is causing me some problems.  I was wondering how difficult it  
> would be to add an option some where to the API that says to return  
> all column names in a fixed case (either UPPER or lower, for me  
> doesn't really mater as long as it is consistent).
>
>
> --
> Doychi
> spdoychiam@...


Re: Column names

by Doychi :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Brian,

You are right. It came down to a problem I fixed in one area but not
another, relating to Bytes, Integers and booleans in MySQL and different
version of the connector.

Sorry to have bothered you with this.

Brian McCallister said the following on 8/04/2006 9:32 AM:
> jDBI should be toUpperCase ing anything it puts into the map it
> returns (and upper casing anything retireved via get(..).
>
> What behavior are you seeing that is causing the problem?
>
> (see org.skife.jdbi.RowMap.java )
<snip>

--
Doychi
spdoychiam@...