hi 

in my postgresql database i have a table customer with a field sex witch
is a char that can be either 'M' or 'W' .My cmp entity  beans has a var
: char sex;

when i try to load the entity i get Database error: Bad Short M; witch
comes from  org.postgresql.jdbc2.ResultSet.getShort . in the
database-schema i have that entry  <type-mapping type="char" name="char"
/>
  
here's the complete error message 
////////////////////////////////////////////////////////////////////////////////
com.evermind.server.rmi.OrionRemoteException: Transaction was rolled
back: Database error: Bad Short M
        at
customerHome_EntityHomeWrapper2.findAll(customerHome_EntityHomeWrapper2.java:1202)
        at
__jspPage0_jsp_list_jsp._jspService(__jspPage0_jsp_list_jsp.java:132)
        at com.orionserver.http.OrionHttpJspPage.service(Unknown Source)
        at com.evermind._ah._rad(Unknown Source)
        at com.evermind.server.http.JSPServlet.service(Unknown Source)
        at com.evermind._cxb._abe(Unknown Source)
        at com.evermind._cxb._uec(Unknown Source)
        at com.evermind._io._twc(Unknown Source)
        at com.evermind._io._gc(Unknown Source)
        at com.evermind._if.run(Unknown Source)

        Nested exception is:
Bad Short M
        at org.postgresql.jdbc2.ResultSet.getShort(ResultSet.java:232)
        at
customerHome_EntityHomeWrapper2.findAll(customerHome_EntityHomeWrapper2.java:1118)
        at
__jspPage0_jsp_list_jsp._jspService(__jspPage0_jsp_list_jsp.java:132)
        at com.orionserver.http.OrionHttpJspPage.service(Unknown Source)
        at com.evermind._ah._rad(Unknown Source)
        at com.evermind.server.http.JSPServlet.service(Unknown Source)
        at com.evermind._cxb._abe(Unknown Source)
        at com.evermind._cxb._uec(Unknown Source)
        at com.evermind._io._twc(Unknown Source)
        at com.evermind._io._gc(Unknown Source)
        at com.evermind._if.run(Unknown Source)
////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////
here's my complete postgresql.xml 

<?xml version="1.0"?>
<!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema"
"http://www.orionserver.com/dtds/database-schema.dtd";>

<database-scheme name="PostGreSQL" not-null="not null" null="null"
primary-key="primary key">
        <type-mapping type="java.lang.String" name="varchar(255)" />
        <type-mapping type="int" name="integer" />
        <type-mapping type="long" name="integer" />
        <type-mapping type="float" name="float" />
        <type-mapping type="double" name="double precision" />
        <type-mapping type="byte" name="smallint" />
        <type-mapping type="char" name="char" />
        <type-mapping type="short" name="integer" />
        <type-mapping type="boolean" name="bool" />
        <type-mapping type="java.util.Date" name="timestamp" />
        <type-mapping type="java.io.Serializable" name="oid" />

        <disallowed-field name="position" />
        <disallowed-field name="parent" />
        <disallowed-field name="username" />
        <disallowed-field name="date" />
        <disallowed-field name="order" />
    <disallowed-field named="abort" />^M
    <disallowed-field named="analyze" /> ^M
    <disallowed-field named="binary" /> ^M
    <disallowed-field named="cluster" />^M
    <disallowed-field named="constraint" />^M
    <disallowed-field named="copy" />^M
    <disallowed-field named="do" /> ^M
    <disallowed-field named="explain" />^M
    <disallowed-field named="extend" />^M
    <disallowed-field named="listen" />^M
    <disallowed-field named="load" />^M
    <disallowed-field named="lock" /> ^M
    <disallowed-field named="move" /> ^M
    <disallowed-field named="new" />^M
    <disallowed-field named="none" />^M
    <disallowed-field named="notify" /> ^M
    <disallowed-field named="offset" /> ^M
    <disallowed-field named="reset" /> ^M
    <disallowed-field named="setof" />^M
    <disallowed-field named="show" />^M

<disallowed-field named="transaction" />^M
    <disallowed-field named="unlisten" />^M
    <disallowed-field named="until" /> ^M
    <disallowed-field named="vacuum" />^M
    <disallowed-field named="verbose" />^M
</database-scheme>

I really dont know what it could be now.
anyone has an idea ???

David Plante



Reply via email to