File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Parameters on Oracle JDBC URL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Parameters on Oracle JDBC URL" Watch "Parameters on Oracle JDBC URL" New topic

Parameters on Oracle JDBC URL

Nathan Russell
Ranch Hand

Joined: Aug 18, 2004
Posts: 75
I wonder if anyone can help.
I am writing a class which uses a JDBC PreparedStatement object to call a stored procedure on an Oracle database.
To create the PreparedStatement object I use the prepareStatement method of the Connection object.
I do not create the Connection object - this is important - it is passed into my method by another piece of code I cannot change.

I need to specify some connection properties - specifically 'SetBigStringTryClob'. All the documentation I can find says that properties such as this can be passed to the Connection when it is created via a Properties object like this:

I cant do this as I dont create the Connection object. What I can do is specify the URL, so I'm thinking I should be able to specify my connection properities as url parameters - but I cant get it to work and I cant find anything anywhere that tells me how to do it.

Any ideas?

Alternatively I'm thinking that maybe there is a method of Connection where I can specify these properties - essentially after its been created - but again, I cant find anything

Any help with this would be very much appreciated;


I agree. Here's the link:
subject: Parameters on Oracle JDBC URL
It's not a secret anymore!