473,395 Members | 1,986 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

DB2 v9.1 jdbc xml sample

Chaps,

I'm trying to get the Simple_XmlProc jdbc xml sample to work. Has
anyone managedf to run it?

The sample is located in Program
files/IBM//SQLLIB/samples/xml/java/jdbc

I'm running
db2 V9.1 WSE for windoze
Compiling and running it from the command line using the provided
spcat_xml.bat file

When I try running "java Simple_XmlProc_Client" I get an error which
states:-

SQL20203N User defined function or procedure "<function-name>" has a
Java method with an invalid signature.

Explanation: The signature of the java method used to implement the
function or procedure was invalid. For example, the method may have
parameters that are not mappable to the parameters on the corresponding
create statement or the method for a procedure may specify a return
value.

User Response: Reissue the corresponding CREATE statement specifying
parameters that match the Java method, or correct the parameters or
return type of the Java method and rebuild the class.

sqlcode: -20203

sqlstate: 46007

One of my own stored procedures written in the Development Workbench
generates the same error.

Any help apreciated
Alex

Aug 31 '06 #1
0 1468

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: vishnu mahendra | last post by:
Hello to all, I am using windows 2000 and i want to connect to ms sql server with jdbc type 4 driver. can you give me sample code and few tips to get me through this., thank you in advance,...
0
by: Andreas Paeffgen | last post by:
I tried to integrate the db2java.zip as a jdbc driver into eclipse. On win2k, db2 8.2., eclipse 2.1. Other jdbc drivers are working properly. eclipse recognizes the driver at...
2
by: Raquel | last post by:
Read this about the Universal JDBC Driver.... "In a Type 2 mode, the Universal JDBC driver provides local application performance gains (because it avoids using TCP/IP protocol to communicate to...
0
by: Raquel | last post by:
UDB PE 8.1 on Win XP. Per the manual: DB2 JDBC traces always begin with a header that lists important system information such as key environment variable settings, the JDK or JRE level, the...
8
by: deegs_ca | last post by:
So I had my jdbc db28.2 fix pack 9 client running because I had taken the jars from <DB2ROOT>/java folder from Enterprise Edition 8.2 fix pack 9, db2java.zip, db2jcc.zip, and the license jar. ...
2
by: Hans Horn | last post by:
Folks, I just upgraded to ESE UDBv91 (from v82) and found that there's no COM.ibm.db2.jdbc.net.DB2Driver in db2java.zip anymore. the only one that's there is the COM.ibm.db2.jdbc.app.DB2Driver...
9
by: Kenevel | last post by:
Hi everyone, Has anyone come across a problem where on Linux using DB2 9.1 Express- C with the packaged jcc-JDBC driver that it fails correctly to parse a returned date value? I'm simply calling...
3
by: %NAME% | last post by:
When using embedded SQL for db2 under solaris, you do not need to give username and password since the system will use your unix-login as default credential. However, with JDBC seems I always need...
0
by: neuraljay | last post by:
hi everyone. I am trying to build a jsp using webwork, hibernate and mysql. And right now I am doing its unit testing. Everytime I run the test I am getting this error: Error JDBC exception on...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.