By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,911 Members | 1,170 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,911 IT Pros & Developers. It's quick & easy.

Adding a parameter to a Java SP

P: n/a
I need to add an additional String parameter to a Java SP (DB2 8.1 0 using
DB2 Development Center - FP4).

Everytime I do this I get the following error message when building:-
"G2REPORT.G2REP_INTERMEDIARY_SS" contains an invalidly formatted
library/function identification in the EXTERNAL NAME clause. LINE
NUMBER=12. SQLSTATE=42878

G2REPORT.G2REP_Intermediary_SS - Build failed.
G2REPORT.G2REP_Intermediary_SS - Roll back completed successfully.

The current parameters for the SP look as below - which works/builds fine.
As soon as I add an additional String parameter (immediately before the
resultset) I get the error above when building. Any ideas ?, are there any
limitations on size/number of parameters a Java SP can take ?

Thanks

public class G2REP_Intermediary_SS
{

public static void g2REP_Intermediary_SS ( String prmRoleName,

String prmFSAReferenceNo,

String prmRelationshipType,

String prmHeadIntermediaryNo,

String prmIntermediaryNo,

String prmIntermediaryName,

String prmFSAChngOptnCode,

String prmClientMoneyOptn,

ResultSet[] rs ) throws SQLException, Exception
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Steve,

Can you post the create procedure statement, and anything that appears
in the db2diag.log during the build? One possibility could be that the
old version of the class is loaded, and is preventing the new jar from
being laid down...you might want to recycle db2 and retry as a sanity check.

Steve Smith wrote:
I need to add an additional String parameter to a Java SP (DB2 8.1 0 using
DB2 Development Center - FP4).

Everytime I do this I get the following error message when building:-
"G2REPORT.G2REP_INTERMEDIARY_SS" contains an invalidly formatted
library/function identification in the EXTERNAL NAME clause. LINE
NUMBER=12. SQLSTATE=42878

G2REPORT.G2REP_Intermediary_SS - Build failed.
G2REPORT.G2REP_Intermediary_SS - Roll back completed successfully.

The current parameters for the SP look as below - which works/builds fine.
As soon as I add an additional String parameter (immediately before the
resultset) I get the error above when building. Any ideas ?, are there any
limitations on size/number of parameters a Java SP can take ?

Thanks

public class G2REP_Intermediary_SS
{

public static void g2REP_Intermediary_SS ( String prmRoleName,

String prmFSAReferenceNo,

String prmRelationshipType,

String prmHeadIntermediaryNo,

String prmIntermediaryNo,

String prmIntermediaryName,

String prmFSAChngOptnCode,

String prmClientMoneyOptn,

ResultSet[] rs ) throws SQLException, Exception


Nov 12 '05 #2

P: n/a
Steve,

Can you please e-mail me your jar file? I want to see what's up, but
can't hit the error path without having the jar file installed (we fail
because we can't find a matching jar file first)...

Thanks!

Steve Smith wrote:
Sean,

There's nothing in db2diag.log

The output from the build (including the create proc stmt is attached).

We have stopped & restarted DB2 a few times too. Doesn't seem to make any
difference. I've also played around with the parameter sizes a bit (as 8
time 32 is 256 - a suspicious number if ever I saw one). That doesn't seem
to make any difference either.

Steve

"Sean McKeough" <mc******@nospam.ca.ibm.com> wrote in message
news:bp**********@hanover.torolab.ibm.com...
Steve,

Can you post the create procedure statement, and anything that appears
in the db2diag.log during the build? One possibility could be that the
old version of the class is loaded, and is preventing the new jar from
being laid down...you might want to recycle db2 and retry as a sanity


check.
Steve Smith wrote:
I need to add an additional String parameter to a Java SP (DB2 8.1 0
using
DB2 Development Center - FP4).

Everytime I do this I get the following error message when building:-
"G2REPORT.G2REP_INTERMEDIARY_SS" contains an invalidly formatted
library/function identification in the EXTERNAL NAME clause. LINE
NUMBER=12. SQLSTATE=42878

G2REPORT.G2REP_Intermediary_SS - Build failed.
G2REPORT.G2REP_Intermediary_SS - Roll back completed successfully.

The current parameters for the SP look as below - which works/builds
fine.
As soon as I add an additional String parameter (immediately before the
resultset) I get the error above when building. Any ideas ?, are there
any
limitations on size/number of parameters a Java SP can take ?

Thanks

public class G2REP_Intermediary_SS
{

public static void g2REP_Intermediary_SS ( String prmRoleName,

String prmFSAReferenceNo,

String prmRelationshipType,

String prmHeadIntermediaryNo,

String prmIntermediaryNo,

String prmIntermediaryName,

String prmFSAChngOptnCode,

String prmClientMoneyOptn,

ResultSet[] rs ) throws SQLException, Exception

G2REPORT.G2REP_Intermediary_SS - Build started.
C:\PROGRA~1\IBM\SQLLIB\java\jdk\bin\javac -classpath ".;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROG RA~1\IBM\SQLLIB\java\runtime.zip;C:\PROGRA~1\IBM\S QLLIB\java\sqlj.zip" "G2REP_Intermediary_SS.java"
G2REPORT.G2REP_Intermediary_SS - Javac completed.
C:\PROGRA~1\IBM\SQLLIB\java\jdk\bin\jar cf SQL31018041007790.jar G2REP_Intermediary_SS.class
G2REPORT.G2REP_Intermediary_SS - Jar file created.
Call sqlj.install_jar ('file:///C|/Documents and Settings/A261009/Application Data/IBM/DB2/DC/Projects/bld1069315923047/SQL31018041007790.jar', '"G2REPORT".SQL31018041007790', 0)
G2REPORT.G2REP_Intermediary_SS - sqlj.install_jar using jar name "G2REPORT".SQL31018041007790 completed.
Call sqlj.refresh_classes( )
G2REPORT.G2REP_Intermediary_SS - sqlj.refresh_classes completed.
Call sqlj.updatejarinfo ('"G2REPORT".SQL31018041007790', 'G2REP_Intermediary_SS', 'file:///C|/Documents and Settings/A261009/Application Data/IBM/DB2/DC/Projects/bld1069315923047/dc_1')
G2REPORT.G2REP_Intermediary_SS - Source updated.
CREATE PROCEDURE G2REPORT.G2REP_Intermediary_SS ( IN prmRoleName CHARACTER(32),
IN prmFSAReferenceNo CHARACTER(32),
IN prmRelationshipType CHARACTER(32),
IN prmHeadIntermediaryNo CHARACTER(32),
IN prmIntermediaryNo CHARACTER(32),
IN prmIntermediaryName CHARACTER(32),
IN prmFSAChngOptnCode CHARACTER(32),
IN prmClientMoneyOptn CHARACTER(32),
IN prmTest1 CHARACTER(32) )
DYNAMIC RESULT SETS 1
NOT DETERMINISTIC
LANGUAGE Java
EXTERNAL NAME '"G2REPORT".SQL31018041007790:G2REP_Intermediary_S S.g2REP_Intermediary_SS'
FENCED
PARAMETER STYLE JAVA
[IBM][CLI Driver][DB2/6000] SQL0449N The statement defining routine "G2REPORT.G2REP_INTERMEDIARY_SS" contains an invalidly formatted library/function identification in the EXTERNAL NAME clause. LINE NUMBER=12. SQLSTATE=42878

G2REPORT.G2REP_Intermediary_SS - Build failed.
G2REPORT.G2REP_Intermediary_SS - Roll back completed successfully.


Nov 12 '05 #3

P: n/a
Sean,

jar file attached.

Thanks
Steve
"Sean McKeough" <mc******@nospam.ca.ibm.com> wrote in message
news:bp**********@hanover.torolab.ibm.com...
Steve,

Can you please e-mail me your jar file? I want to see what's up, but
can't hit the error path without having the jar file installed (we fail
because we can't find a matching jar file first)...

Thanks!

Steve Smith wrote:
Sean,

There's nothing in db2diag.log

The output from the build (including the create proc stmt is attached).

We have stopped & restarted DB2 a few times too. Doesn't seem to make any difference. I've also played around with the parameter sizes a bit (as 8
time 32 is 256 - a suspicious number if ever I saw one). That doesn't seem to make any difference either.

Steve

"Sean McKeough" <mc******@nospam.ca.ibm.com> wrote in message
news:bp**********@hanover.torolab.ibm.com...
Steve,

Can you post the create procedure statement, and anything that appears
in the db2diag.log during the build? One possibility could be that the
old version of the class is loaded, and is preventing the new jar from
being laid down...you might want to recycle db2 and retry as a sanity


check.
Steve Smith wrote:

I need to add an additional String parameter to a Java SP (DB2 8.1 0


using
DB2 Development Center - FP4).

Everytime I do this I get the following error message when building:-
"G2REPORT.G2REP_INTERMEDIARY_SS" contains an invalidly formatted
library/function identification in the EXTERNAL NAME clause. LINE
NUMBER=12. SQLSTATE=42878

G2REPORT.G2REP_Intermediary_SS - Build failed.
G2REPORT.G2REP_Intermediary_SS - Roll back completed successfully.

The current parameters for the SP look as below - which works/builds


fine.
As soon as I add an additional String parameter (immediately before the
resultset) I get the error above when building. Any ideas ?, are there


any
limitations on size/number of parameters a Java SP can take ?

Thanks

public class G2REP_Intermediary_SS
{

public static void g2REP_Intermediary_SS ( String prmRoleName,

String prmFSAReferenceNo,

String prmRelationshipType,

String prmHeadIntermediaryNo,

String prmIntermediaryNo,

String prmIntermediaryName,

String prmFSAChngOptnCode,

String prmClientMoneyOptn,

ResultSet[] rs ) throws SQLException, Exception

G2REPORT.G2REP_Intermediary_SS - Build started.
C:\PROGRA~1\IBM\SQLLIB\java\jdk\bin\javac -classpath ".;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROG RA~1\IBM\SQLLIB\java\runti
me.zip;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip" "G2REP_Intermediary_SS.java" G2REPORT.G2REP_Intermediary_SS - Javac completed.
C:\PROGRA~1\IBM\SQLLIB\java\jdk\bin\jar cf SQL31018041007790.jar G2REP_Intermediary_SS.class G2REPORT.G2REP_Intermediary_SS - Jar file created.
Call sqlj.install_jar ('file:///C|/Documents and Settings/A261009/Application
Data/IBM/DB2/DC/Projects/bld1069315923047/SQL31018041007790.jar',
'"G2REPORT".SQL31018041007790', 0) G2REPORT.G2REP_Intermediary_SS - sqlj.install_jar using jar name "G2REPORT".SQL31018041007790 completed. Call sqlj.refresh_classes( )
G2REPORT.G2REP_Intermediary_SS - sqlj.refresh_classes completed.
Call sqlj.updatejarinfo ('"G2REPORT".SQL31018041007790', 'G2REP_Intermediary_SS', 'file:///C|/Documents and
Settings/A261009/Application
Data/IBM/DB2/DC/Projects/bld1069315923047/dc_1') G2REPORT.G2REP_Intermediary_SS - Source updated.
CREATE PROCEDURE G2REPORT.G2REP_Intermediary_SS ( IN prmRoleName CHARACTER(32), IN prmFSAReferenceNo CHARACTER(32), IN prmRelationshipType CHARACTER(32), IN prmHeadIntermediaryNo CHARACTER(32), IN prmIntermediaryNo CHARACTER(32), IN prmIntermediaryName CHARACTER(32), IN prmFSAChngOptnCode CHARACTER(32), IN prmClientMoneyOptn CHARACTER(32), IN prmTest1 CHARACTER(32) ) DYNAMIC RESULT SETS 1
NOT DETERMINISTIC
LANGUAGE Java
EXTERNAL NAME '"G2REPORT".SQL31018041007790:G2REP_Intermediary_S S.g2REP_Intermediary_SS' FENCED
PARAMETER STYLE JAVA
[IBM][CLI Driver][DB2/6000] SQL0449N The statement defining routine "G2REPORT.G2REP_INTERMEDIARY_SS" contains an invalidly formatted
library/function identification in the EXTERNAL NAME clause. LINE
NUMBER=12. SQLSTATE=42878
G2REPORT.G2REP_Intermediary_SS - Build failed.
G2REPORT.G2REP_Intermediary_SS - Roll back completed successfully.



Nov 12 '05 #4

P: n/a
Steve,

The install & create proc went ok for me on 8.2...I couldn't find a fp4
build to try this on. You may just need to move up...if fp4 doesn't work
for you, then you'll need to contact service to get a special build
containing whatever was done to fix this.

Steve Smith wrote:
Sean,

jar file attached.

Thanks
Steve
"Sean McKeough" <mc******@nospam.ca.ibm.com> wrote in message
news:bp**********@hanover.torolab.ibm.com...
Steve,

Can you please e-mail me your jar file? I want to see what's up, but
can't hit the error path without having the jar file installed (we fail
because we can't find a matching jar file first)...

Thanks!

Steve Smith wrote:
Sean,

There's nothing in db2diag.log

The output from the build (including the create proc stmt is attached).

We have stopped & restarted DB2 a few times too. Doesn't seem to make
any
difference. I've also played around with the parameter sizes a bit (as 8
time 32 is 256 - a suspicious number if ever I saw one). That doesn't
seem
to make any difference either.

Steve

"Sean McKeough" <mc******@nospam.ca.ibm.com> wrote in message
news:bp**********@hanover.torolab.ibm.com...
Steve,

Can you post the create procedure statement, and anything that appears
in the db2diag.log during the build? One possibility could be that the
old version of the class is loaded, and is preventing the new jar from
being laid down...you might want to recycle db2 and retry as a sanity

check.
Steve Smith wrote:
>I need to add an additional String parameter to a Java SP (DB2 8.1 0

using
>DB2 Development Center - FP4).
>
>Everytime I do this I get the following error message when building:-
>"G2REPORT.G2REP_INTERMEDIARY_SS" contains an invalidly formatted
>library/function identification in the EXTERNAL NAME clause. LINE
>NUMBER=12. SQLSTATE=42878
>
>G2REPORT.G2REP_Intermediary_SS - Build failed.
>G2REPORT.G2REP_Intermediary_SS - Roll back completed successfully.
>
>The current parameters for the SP look as below - which works/builds

fine.
>As soon as I add an additional String parameter (immediately before the
>resultset) I get the error above when building. Any ideas ?, are there

any
>limitations on size/number of parameters a Java SP can take ?
>
>Thanks
>
>public class G2REP_Intermediary_SS
>{
>
>public static void g2REP_Intermediary_SS ( String prmRoleName,
>
>String prmFSAReferenceNo,
>
>String prmRelationshipType,
>
>String prmHeadIntermediaryNo,
>
>String prmIntermediaryNo,
>
>String prmIntermediaryName,
>
>String prmFSAChngOptnCode,
>
>String prmClientMoneyOptn,
>
>ResultSet[] rs ) throws SQLException, Exception
>
>
G2REPORT.G2REP_Intermediary_SS - Build started.
C:\PROGRA~1\IBM\SQLLIB\java\jdk\bin\javac -classpath
".;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROG RA~1\IBM\SQLLIB\java\runti
me.zip;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip" "G2REP_Intermediary_SS.java"
G2REPORT.G2REP_Intermediary_SS - Javac completed.
C:\PROGRA~1\IBM\SQLLIB\java\jdk\bin\jar cf SQL31018041007790.jar
G2REP_Intermediary_SS.class
G2REPORT.G2REP_Intermediary_SS - Jar file created.
Call sqlj.install_jar ('file:///C|/Documents and
Settings/A261009/Application
Data/IBM/DB2/DC/Projects/bld1069315923047/SQL31018041007790.jar',
'"G2REPORT".SQL31018041007790', 0)
G2REPORT.G2REP_Intermediary_SS - sqlj.install_jar using jar name
"G2REPORT".SQL31018041007790 completed.
Call sqlj.refresh_classes( )
G2REPORT.G2REP_Intermediary_SS - sqlj.refresh_classes completed.
Call sqlj.updatejarinfo ('"G2REPORT".SQL31018041007790',
'G2REP_Intermediary_SS', 'file:///C|/Documents and
Settings/A261009/Application
Data/IBM/DB2/DC/Projects/bld1069315923047/dc_1')
G2REPORT.G2REP_Intermediary_SS - Source updated.
CREATE PROCEDURE G2REPORT.G2REP_Intermediary_SS ( IN prmRoleName
CHARACTER(32),
IN prmFSAReferenceNo
CHARACTER(32),
IN prmRelationshipType
CHARACTER(32),
IN
prmHeadIntermediaryNo CHARACTER(32),
IN prmIntermediaryNo
CHARACTER(32),
IN prmIntermediaryName
CHARACTER(32),
IN prmFSAChngOptnCode
CHARACTER(32),
IN prmClientMoneyOptn
CHARACTER(32),
IN prmTest1
CHARACTER(32) )
DYNAMIC RESULT SETS 1
NOT DETERMINISTIC
LANGUAGE Java
EXTERNAL NAME
'"G2REPORT".SQL31018041007790:G2REP_Intermediary_S S.g2REP_Intermediary_SS'
FENCED
PARAMETER STYLE JAVA
[IBM][CLI Driver][DB2/6000] SQL0449N The statement defining routine
"G2REPORT.G2REP_INTERMEDIARY_SS" contains an invalidly formatted
library/function identification in the EXTERNAL NAME clause. LINE
NUMBER=12. SQLSTATE=42878
G2REPORT.G2REP_Intermediary_SS - Build failed.
G2REPORT.G2REP_Intermediary_SS - Roll back completed successfully.



Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.