0 Replies Latest reply on Jul 6, 2005 11:03 AM by Andres Navarro

    Problems on my oracle datasource connection

    Andres Navarro Newbie

      Hi:
      Look at this. I have a connection for oracle defined in a xxx-ds.xml.
      The connection works, but when i try a preparedStatement query with a string parameter, the query that has to find records, does't do it. The problem is that the oracle jdbc driver does not fixing char parameters or fields(or something like that). So, the result of that inconvinient is oracle comparing "STRING PARAMETER" = "STRING PARAMETER ". The padding or trimming that is oracle driver's responsability is not happening. I'v been searching out there on the internet but with not luck at all. The apparent solution is send a parameter to the driver manager told him about de fixedchar has to be true.

      that was my best try.......hope you under stand the explanation...