• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: [WO5.2.3] Problem with char parameter in stored procedure(EOF mapping)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [WO5.2.3] Problem with char parameter in stored procedure(EOF mapping)


  • Subject: Re: [WO5.2.3] Problem with char parameter in stored procedure(EOF mapping)
  • From: email@hidden
  • Date: Mon, 8 Aug 2005 19:06:00 +0200

Hi Stephan,
 
Its your choice to force them or not. My opinion its not a solution. its the *last* solution.
 
My question, Why forcing, when it runs? you have something streng (3.....), but it works. Unless the database admins are just changed the column into Char for fun (what i cant imagine).
 
PS: i wonder that they did that! i had char columns in ms-sql db. and forced to change the columns into varchar to be able to use Triggers. However, another db another problems. :)
 
Sako.
 
----- Original Message -----
From: Stresing, Stephan
To: email@hidden
Cc: email@hidden
Sent: Monday, August 08, 2005 6:59 PM
Subject: AW: [WO5.2.3] Problem with char parameter in stored procedure(EOF mapping)

Hi Janine,
 
I was not quite sure, but I thought to remember something similar in the far-away-back of my mind. I think that I'll force ;-) the database guy to turn the changes back.
 
Thank you,
    Stephan.
 


Von: email@hidden [mailto:email@hidden]
Gesendet: Montag, 8. August 2005 18:54
An: Stresing, Stephan
Cc: email@hidden
Betreff: Re: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)

I belong to an Oracle discussion list (oracle-l) and just last week someone mentioned that they had debugged a Java app that was having performance issues and found the same thing - when a procedure parameter is defined as CHAR, something (probably the Oracle driver but I don't think the guy ever determined that for certain) was padding out the field to the full possible length of a CHAR.

I wasn't paying that close attention but I think his solution was to switch back to VARCHAR2. If that's possible in your case it might be the easiest fix.

janine

On Aug 8, 2005, at 9:00 AM, Stresing, Stephan wrote:

Hi,

since I had a pause of over 1 year in WO development I guess this is a rookie question… At least I hope so. (I'm pretty sure I'll be ashamed after your answers.) :-)

Our database experts changed the interfaces of some stored procedures we're forced to use. ;-) Mainly they modified some string parameters and changed the type from VARCHAR2 to CHAR (length was/is defined as 10 chars for either solution). I thought that I only had to change my EOModel in order to reflect these changes. So I switched the parameter type from VARCHAR2 to CHAR and didn't touch the width definition (10).

Now after executing the "new" procedure with EOUtilities.executeStoredProcedureNamed the result was surprising (especially to me): the expected 10 chars String had a length of 32512. I checked the "old" (VARCHAR2) procedure and got the expected 10 chars. What am I missing? (Is this the revenge for not developing with WO for so long? ;-))

We're developing with WO 5.2.3 on Windows XP (Eclipse/WOLips), Oracle Thin connecting to a remote Oracle 9i.

Since I'm stuck I'd appreciate fast help!

TIA,
   Stephan.

Stephan Stresing
IT Entwicklung & Systemintegration
ING-DiBa AG
Postfach 18 49
90007 Nürnberg
Besucher:
Südwestpark 97
90449 Nürnberg
Fon +49 (0)9 11 - 1 49 - 2 25 37
Fax +49 (0)9 11 - 1 49 - 2 25 48
eMail mailto:email@hidden
WWW http://www.ing-diba.de


Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your email sent to email@hidden
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References: 
 >AW: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping) (From: "Stresing, Stephan" <email@hidden>)

  • Prev by Date: AW: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
  • Next by Date: Re: ConnectorJ and MySQL4.1
  • Previous by thread: AW: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
  • Next by thread: AW: [WO5.2.3] Problem with char parameter in stored procedure (EOF mapping)
  • Index(es):
    • Date
    • Thread