RE: *FILE not found calling stored procedure

Roman,

Looks like your using the SQL naming convention to run this, which will
default the schema to the user name.
You need to set the naming property to system, libraries property on the
database driver to *libl

cheers
Colin.W
 
Extension   5800
Direct dial   0870 429 5800


-----Original Message-----
From: Prigozhin, Roman [mailto:Roman.Prigozhin@xxxxxxxxxxxxxxx] 
Sent: 13 October 2004 01:53
To: java400-l@xxxxxxxxxxxx
Subject: *FILE not found calling stored procedure


Hi All,
        I have implemented stored procedure in System naming convention,
than checked that executing query :
        select *  from sysprocs where specific_schema = 'PROD' and  it
displays *LIBL in SQL_PATH. So this procedure will use a library list of the
use which will be running this procedure.

        Then I've checked this procedure via Websphere Development Studio
Client.  I ran it with parameters and it returned results fine..
        
        Now here is the problem :
        When I'm calling this procedure from java class ( java and db2
running on the same AS400 ) I'm getting exception :
      com.ibm.db2.jdbc.app.DB2DBException: TEST in ROMAN type *FILE not
found.

        TEST is my table I'm using in the stored procedure, its located in
library DATA. But stored
        procedure located in library PROD

        I'm running this procedure under user ROMAN. and I have PROD and
DATA schema in my library list.
      Why is it not working from JAVA ? Should I specify something in the
statement object ?

        Just in case here is the my java code :

        SCStatement = SCConn.prepareCall("{ ? = call
SP_INS_PROCESS(?,?,?,?,?,?,?,?,?,?,?,?,?)}");
        SCStatement.clearParameters();
        SCStatement.registerOutParameter(1, Types.INTEGER);
        .
      .   
      SCStatement.execute();     


        Here is how I connect to the database using Proxool 

jdbc-0.proxool.alias=CPS jdbc-0.proxool.driver-url=jdbc:db2://localhost
jdbc-0.proxool.driver-class=com.ibm.db2.jdbc.app.DB2Driver
jdbc-0.user=tester
jdbc-0.password=tester jdbc-0.proxool.maximum-connection-count=10
jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
jdbc-0.proxool.verbose=false jdbc-0.proxool.maximum-active-time=60000000
jdbc-0.proxool.maximum-connection-lifetime=180000000


I even tried to add this line to the jdbc driver, thinking that it may find
this library jdbc-0.libraries=DATA,PROD but it doesn't work


Thanks,
Roman



###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.