RE: *FILE not found calling stored procedure

Colin,

 I've changed my connection line to
jdbc:db2://*LOCAL;naming=SYSTEM;libraries=*LIBL;
and it worked fine.

Thanks a lot !

Roman

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Colin Williams
Sent: Wednesday, October 13, 2004 12:58 AM
To: 'Java Programming on and around the iSeries / AS400'
Subject: 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.

--
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 message has been scanned by F-Secure Anti-Virus for Microsoft
Exchange.
For more information, connect to http://www.F-Secure.com/