I am trying to map my oracle datatype (NUMBER) to something that will work
within the JAWS module.  I keep getting type mismatch errors when trying to
my create methods on my entity bean:  Thus far I have tried:

JAWS SQL Type: NUMBER
JAWS JDBC Type: DOUBLE
JAWS Java Type: DOUBLE
My EB's PK type: double

JAWS SQL Type: NUMBER
JAWS JDBC Type: Double
JAWS Java Type: Double
My EB's PK type: Double

JAWS SQL Type: NUMBER
JAWS JDBC Type: Double
JAWS Java Type: Double
My EB's PK type: int

JAWS SQL Type: NUMBER
JAWS JDBC Type: Integer
JAWS Java Type: Integer
My EB's PK type: int

None of the above mappings work.  The first config listed above yeilds a
class cast exception.  The rest give a vague exception about a field
mismatch.

I wrote a small program that will yeild the SQL and Database datatypes and
the SQL type IS NUMBER, the JDBC type is Double (java.sql.Type=8).  The
return java object type is Double.  What is up with this?  I have mapped
every conceivable way to make the thing Double.

In reality the column is an abstract key generated from an Oracle sequence
that will always be a positive integer of Oracle type Number.  Nothing
unusual here.

Thanks for any help,


Bill Pfeiffer
Arbitration Forums, Inc
[EMAIL PROTECTED]
[EMAIL PROTECTED]



--
--------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]

Reply via email to