Java Database Connectivity (JDBC)

Hi everybody.

As the title says we are having trouble in all our select clauses because we think the driver is not trimming the trailing white spaces.

We are using spring jdbc support and when executing a simple query like:

Select names from foo where name = ‘bar’

The column names is defined as varchar(5), so bar is not found

But when executing:

Select names from foo where name = ‘bar _ _’ (_ are spaces :))

Bar is found.

We used to have the same problem in Informix and found a configuration parameter called IFX_TRIMTRAILINGSPACES=1, we use this parameter in the jdbc connection url, but in oracle we haven’t found an equivalent.

That’s why we are here…

Any suggestions opinions or work arounds are welcome

Thanks in advance…

Hector Lazo