In addition:

the query is:
select contact0_.contact_id as contact_id0_, contact0_.account_id as
account_id0_, contact0_.created as created0_, contact0_.first_name as
first_name0_, contact0_.last_name as last_name0_, contact0_.middle_name
as middle_n6_0_, contact0_.home_phone as home_phone0_,
contact0_.cell_phone as cell_phone0_, contact0_.business_phone as
business9_0_, contact0_.additional_phone as additio10_0_, contact0_.fax
as fax0_, contact0_.email as email0_, contact0_.email2 as email20_,
contact0_.res_address as res_add14_0_, contact0_.res_city as res_city0_,
contact0_.res_country as res_cou16_0_, contact0_.res_postal as
res_postal0_, contact0_.res_province as res_pro18_0_,
contact0_.mail_address as mail_ad19_0_, contact0_.mail_city as
mail_city0_, contact0_.mail_country as mail_co21_0_,
contact0_.mail_postal as mail_po22_0_, contact0_.mail_province as
mail_pr23_0_, contact0_.mail_same as mail_same0_, contact0_.modified as
modified0_ from contact contact0_ where contact0_.contact_id=?

(it was automatically generated by hibernate)

And the table is:
CREATE TABLE contact
(
contact_id int8 NOT NULL,
account_id varchar(30) NOT NULL,
created timestamp NOT NULL,
first_name varchar(255),
last_name varchar(255),
middle_name varchar(255),
home_phone varchar(255),
cell_phone varchar(255),
business_phone varchar(255),
additional_phone varchar(255),
fax varchar(255),
email varchar(255),
email2 varchar(255),
res_address varchar(255),
res_city varchar(255),
res_country int8,
res_postal varchar(10),
res_province varchar(255),
mail_address varchar(255),
mail_city varchar(255),
mail_country int8,
mail_postal varchar(10),
mail_province varchar(255),
mail_same bool,
modified timestamp NOT NULL,
CONSTRAINT contact_pkey PRIMARY KEY (contact_id),
CONSTRAINT "$1" FOREIGN KEY (account_id) REFERENCES account
(account_id) ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH OIDS;


On Tue, 2005-01-25 at 14:20, Pavel Jbanov wrote:
> Sorry, gone unfinished. :/
>
> The exception is:
> Caused by: org.postgresql.util.PSQLException: ???????????? Byte f
> at
> org.postgresql.jdbc1.AbstractJdbc1ResultSet.getByt e(AbstractJdbc1ResultSet.java:244)
> at
> org.postgresql.jdbc1.AbstractJdbc1ResultSet.getByt e(AbstractJdbc1ResultSet.java:491)
> at net.sf.hibernate.type.ByteType.get(ByteType.java:1 8)
> at
> net.sf.hibernate.type.NullableType.nullSafeGet(Nul lableType.java:62)
> at
> net.sf.hibernate.type.NullableType.nullSafeGet(Nul lableType.java:53)
> at net.sf.hibernate.type.AbstractType.hydrate(Abstrac tType.java:66)
> at net.sf.hibernate.loader.Loader.hydrate(Loader.java :686)
> at net.sf.hibernate.loader.Loader.loadFromResultSet(L oader.java:627)
> at
> net.sf.hibernate.loader.Loader.instanceNotYetLoade d(Loader.java:586)
> at net.sf.hibernate.loader.Loader.getRow(Loader.java: 501)
> at
> net.sf.hibernate.loader.Loader.getRowFromResultSet (Loader.java:213)
> at net.sf.hibernate.loader.Loader.doQuery(Loader.java :281)
> at
> net.sf.hibernate.loader.Loader.doQueryAndInitializ eNonLazyCollections(Loader.java:133)
> at net.sf.hibernate.loader.Loader.doList(Loader.java: 1033)
> at net.sf.hibernate.loader.Loader.list(Loader.java:10 24)
> at
> net.sf.hibernate.hql.QueryTranslator.list(QueryTra nslator.java:854)
> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl .java:1544)
> ... 36 more
>
> What should I look at? Where can be the cause?
>
> Thanks.
>
> > Hi,
> >
> > I have postgresql 7.4.6-6, hibernate-2.1.6, jdbc3 (pg74.215.jdbc3.jar).
> > I get this exception:
> >
> >
> > I have a pretty complex structure, but here I try to do a simple thing:
> >
> > SomeBean foo = (SomeBean) session.get(SomeBean.class,
> > primary_key_value);
> >
> > I have: <property name="show_sql">true</property>, so I tried executing
> > the query it generated directly, it executed without problems.
--
Pavel Jbanov
http://www.spicesoft.com/~pavel/


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match