Hi,
after reading the vtrace you have sent to me I think it is a problem within your
dbprocedure.
This is the reply packet:
RECEIVE: ascii, full_swap, 70403-ODB (1 segment, len: 96)
(192.1487 page 193)
ok / RETURN SEGMENT 1 (2 parts, len: 96)
pl_sql_execute_fc, sqlstate: '00000'
errortext PART (1 argument, size: 32552)
buf(16): 'Unexpected error'
resultcount PART (1 argument, size: 32520)
result_count: 1
The call of the proc returns an error text "Unexpected error" but it doesn't return an
error number. So can it be that that you exit your dbproc with the command "stop 0".
Because "0" is not a valid error number the kernel returns ok instead of signaling an
error. This confuses the jdbc driver and it doesn't throw an exception.
If the usage of "stop 0" within your dbproc is not the reason for the problem, please
send me the definition of your dbproc and I will try to reproducing the error.
In general you should use a newer kernel release, because we have made a lot of
bugfixes concerning dbprocedure since release 7.4.3.10. We will release a new version
of SAP DB within the next few days.
Regards,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin
> -----Original Message-----
> From: Stewart.Gene [mailto:[EMAIL PROTECTED]
> Sent: Mittwoch, 11. Juni 2003 17:56
> To: Paskamp, Marco; [EMAIL PROTECTED]
> Subject: RE: Output Parameters
>
>
> 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]
> Parameter
> (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(DBTech
> Translator
> .java:790)
> at
> com.sap.dbtech.jdbc.translators.BooleanTranslator.getBoolean(B
> ooleanTran
> slator.java:82)
> at
> com.sap.dbtech.jdbc.CallableStatementSapDB.getBoolean(Callable
> StatementS
> apDB.java:835)
> at
> com.sap.dbtech.jdbc.trace.CallableStatement.getBoolean(Callabl
> eStatement
> .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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
