Marco,
Actually there was no error message. Other than not returning an
output parameter all work was performed correctly within the called
stored procedure. As you asked I am including the jdbc trace file below.
Upon searching the List I happened to find a person who had a
problem similar to mine (Patch to workaround JDBC out parameter Problem
May 30, 2001). He said the problem was because the server and the client
had different swappings ( big endian - little endian). Which is my case
since I'm using Intel. He also had a work-around which was not
successful for my problem.
Thank you
Gene
---- Thread 1e4457d main Timestamp: 2003-06-11 11:07:22.982
==================================
package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG, 7.4.4 Build
001-000-156-754 on Java 1.4.1_01
new Connection 'jdbc:sapdb://192.168.0.50/FSIDEV'
using [EMAIL PROTECTED] on
Socket[addr=/192.168.0.50,port=7210,localport=1581]
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ({call
CREATE_USER(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)})
=> [EMAIL PROTECTED]
[EMAIL PROTECTED]
(23, 16)
[EMAIL PROTECTED] (1, Mrs.)
[EMAIL PROTECTED] (2, IV)
[EMAIL PROTECTED] (3, Sally)
[EMAIL PROTECTED] (4, A)
[EMAIL PROTECTED] (5,
Sunshine)
[EMAIL PROTECTED] (6, Crimson
Drive)
[EMAIL PROTECTED] (7, Test)
[EMAIL PROTECTED] (8, 15c)
[EMAIL PROTECTED] (9,
Covington)
[EMAIL PROTECTED] (10, KY)
[EMAIL PROTECTED] (11, 41011)
[EMAIL PROTECTED] (12,
859.291.8000)
[EMAIL PROTECTED] (13,
859.957.2015)
[EMAIL PROTECTED] (14,
859.222.1234)
[EMAIL PROTECTED] (15,
859.333.3211)
[EMAIL PROTECTED] (16,
[EMAIL PROTECTED])
[EMAIL PROTECTED] (17,
888-99-0110)
[EMAIL PROTECTED] (18, Hair
color)
[EMAIL PROTECTED] (19, red)
[EMAIL PROTECTED] (20,
ssunshine)
[EMAIL PROTECTED] (21,
password)
[EMAIL PROTECTED] (22, 1500)
[EMAIL PROTECTED] ()
=> false
[EMAIL PROTECTED] (23)
<-!
java.lang.NullPointerException
at
com.sap.dbtech.jdbc.translators.DBTechTranslator.isNull(DBTechTranslator
.java:790)
at
com.sap.dbtech.jdbc.translators.BooleanTranslator.getBoolean(BooleanTran
slator.java:82)
at
com.sap.dbtech.jdbc.CallableStatementSapDB.getBoolean(CallableStatementS
apDB.java:835)
at
com.sap.dbtech.jdbc.trace.CallableStatement.getBoolean(CallableStatement
.java:130)
at
com.fsi.persistence.SAPDBUserDAO.createUser(SAPDBUserDAO.java:148)
at
com.fsi.test.clients.DAOTestClient.createUser(DAOTestClient.java:206)
at
com.fsi.test.clients.DAOTestClient.main(DAOTestClient.java:70)
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
-----Original Message-----
From: Paskamp, Marco [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 10:01 AM
To: Stewart.Gene; [EMAIL PROTECTED]
Subject: RE: Output Parameters
Hi,
some more details about the problem would be very helpful. What error
message do you get? Did you have registered your output parameter? Can
you provide a jdbc trace (http://sapdb.2scale.net/moin.cgi/JdbcTrace)?
Regards,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin
-----Original Message-----
From: Stewart.Gene [mailto:[EMAIL PROTECTED]
Sent: Montag, 9. Juni 2003 16:04
To: [EMAIL PROTECTED]
Subject: Output Parameters
Hello,
I'm having a problem getting output parameters returned from a
stored procedure over JDBC. I'm using SAP 7.4.3.10 with Red Hat 8.0.
It's strange in that I can successfully return data into the Java result
set when I use a store procedure cursor, but nothing when I use output
parameters. Has anyone run into this problem or have any ideas in regard
to a solution.
Gene
Confidentiality Notice:
The information contained in this document (and any attached materials)
is privileged and confidential information, intended only for the use of
the individual(s) to whom this correspondence is addressed. If the
reader of this communication is not the intended recipient, you are
hereby notified that any dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, please immediately destroy it and notify
Financial Services International, Inc. immediately. Thank you for your
assistance.
Confidentiality Notice:
The information contained in this document (and any attached materials) is privileged
and confidential information, intended only for the use of the individual(s) to whom
this correspondence is addressed. If the reader of this communication is not the
intended recipient, you are hereby notified that any dissemination, distribution, or
copying of this communication is strictly prohibited. If you have received this
communication in error, please immediately destroy it and notify Financial Services
International, Inc. immediately. Thank you for your assistance.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
