View Single Post

   
  #1 (permalink)  
Old 04-16-2008, 12:34 AM
Chris Gamache
 
Posts: n/a
Default stringtype=unspecified problem

I'm setting stringtype=unspecified in my connection URL to allow
prepared statements to manipulate non-jdbc types as strings, since
jdbc seems to choke on them otherwise.

I'm running into a problem when I want to explicitly set one of those
unspecified types to NULL. It appears that jdbc is preparing that
statement using an empty string, which is causing PostgreSQL to
error-out on the execution of that statement.

The postgresql type in particular is the contrib type "uniqueidentifier" ...

I didn't want to file a bug report until I brought it up on the list
in case I'm overlooking something.

CG

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote