Hi,
> Okay, can you DESCRIBE the table in Oracle, and pass along the
> definition? Also, can you say whether you are using the standard JAWS
> mappings or a customized one, and if customized, can you include the
> Oracle section you are using?
I am using the standard JAWS mappings.
The table (MANDANT):
FIRMENLOGO BLOB,
BEZEICHNUNG VARCHAR2(40),
NUMMER NUMBER(3,0)
BANKVERBINDUNG BLOB
Here my jaws.xml:
---- snip ----
<?xml version="1.0" encoding="Cp1252"?>
<jaws>
<datasource>OraclePool</datasource>
<type-mapping>Oracle8</type-mapping>
<enterprise-beans>
<entity>
<ejb-name>Adresse</ejb-name>
<table-name>Adresse</table-name>
<create-table>true</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>Strasse</field-name>
<column-name>Strasse</column-name>
<sql-type>VARCHAR2(40)</sql-type>
<jdbc-type>CHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>Land</field-name>
<column-name>Land</column-name>
<sql-type>VARCHAR2(3)</sql-type>
<jdbc-type>CHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>Typ</field-name>
<column-name>Typ</column-name>
<sql-type>CHAR(1)</sql-type>
<jdbc-type>CHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>PLZ</field-name>
<column-name>PLZ</column-name>
<sql-type>DECIMAL(5)</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>Mandant</field-name>
<column-name>Mandant</column-name>
<sql-type>DECIMAL(3)</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>Ort</field-name>
<column-name>Ort</column-name>
<sql-type>VARCHAR2(40)</sql-type>
<jdbc-type>CHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>Nummer</field-name>
<column-name>Nummer</column-name>
<sql-type>DECIMAL(10)</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
</entity>
<entity>
<ejb-name>Mandant</ejb-name>
<table-name>Mandant</table-name>
<create-table>true</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<cmp-field>
<field-name>Nummer</field-name>
<column-name>Nummer</column-name>
<sql-type>DECIMAL(3)</sql-type>
<jdbc-type>INTEGER</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>FirmenLogo</field-name>
<column-name>FirmenLogo</column-name>
<sql-type>BLOB</sql-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>Bezeichnung</field-name>
<column-name>Bezeichnung</column-name>
<sql-type>VARCHAR2(40)</sql-type>
<jdbc-type>CHAR</jdbc-type>
</cmp-field>
<cmp-field>
<field-name>BankVerbindungen</field-name>
<column-name>BankVerbindungen</column-name>
<sql-type>BLOB</sql-type>
<jdbc-type>JAVA_OBJECT</jdbc-type>
</cmp-field>
</entity>
<entity>
[...]
</enterprise-beans>
</jaws>
---- snap ----
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]