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
