This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.
The moose likes JDBC and the fly likes Current Schema doesnt work for procedure access Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Current Schema doesnt work for procedure access" Watch "Current Schema doesnt work for procedure access" New topic
Author

Current Schema doesnt work for procedure access

jaspal singh
Ranch Hand

Joined: Sep 15, 2005
Posts: 54
Hi,

I am using WAS 6 with db2.

I've used currentSchema i.e deafault schema property in Datasource for JDBC connectiion pooling.

However this doesent work while accessing any procedure.

I've to explicity provide e.g. call Schema.xyzProce

Any suggestions as why this is happening.

Thanks,
Jass


Teach me the art of forgetting, for I always remember wat I have forgotten.
Maneesh Godbole
Saloon Keeper

Joined: Jul 26, 2007
Posts: 8567

Triplicate (not duplicate) thread.
http://www.coderanch.com/forums/
http://www.coderanch.com/t/307465/JDBC/java/Current-Schema-doesnt-work-procedure
http://www.coderanch.com/t/79654/Websphere/Current-Schema-doesnt-work-procedure


[Donate a pint, save a life!] [How to ask questions] [Onff-turn it on!]
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 26499
    
  78

Originally posted by jaspal singh:
However this doesent work while accessing any procedure.

What does "doesn't work" mean? Do you get an error message? exception? does the code silently fail?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Current Schema doesnt work for procedure access
 
Similar Threads
JDBC, Create Stored Procedure, delimiters
Current Schema doesnt work for procedure access
Only one question in Stored procedure.
Grails and legacy database
java.sql.SQLException: invalid name pattern