SetBigStringTryClob property in JDBC

[Stephen Huey]

I specify my database connection URL used by my web app in one place, and I've never had to add properties to it, but apparently for accessing a CLOB over JDBC I should do the following when getting a connection:

        Properties props = new Properties();
        props.put("SetBigStringTryClob", "true");
        connection = DriverManager.getConnection("jdbc:oracle:thin:scott/tiger@192.168.1.188:1521 :o rclbox1", props);

I know you can also add the user and password to the properties, but for now I'm just focusing on the CLOB stuff. Since there's only one place in my whole web app where I specify how to get a connection, I'm planning on just attaching that property for the CLOB. However, I'm wondering if there's a performance hit associated with accessing "normal" data when that property is set to true (enough that I wouldn't want to have it turned on all the time).

I'm new to Oracle, and trying to piece together the right way to do this CLOB stuff over JDBC with the thin client in 10g has been a bit tiresome since some of my books disagree or lack the complete info!

[edited to disable smilies]
[ December 21, 2004: Message edited by: Jeanne Boyarsky ]

[Jeanne Boyarsky]

Stephen,
I wouldn't expect there to be a performance hit. However, the easiest way to find out is to try it both ways and log how long queries take.