Return-Path: 
 <ojb-dev-return-13586-apmail-db-ojb-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ojb-dev-archive@www.apache.org
Received: (qmail 77699 invoked from network); 10 Feb 2006 21:13:52 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 10 Feb 2006 21:13:52 -0000
Received: (qmail 65054 invoked by uid 500); 10 Feb 2006 21:09:22 -0000
Delivered-To: apmail-db-ojb-dev-archive@db.apache.org
Received: (qmail 65014 invoked by uid 500); 10 Feb 2006 21:09:21 -0000
Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:ojb-dev-unsubscribe@db.apache.org>
List-Help: <mailto:ojb-dev-help@db.apache.org>
List-Post: <mailto:ojb-dev@db.apache.org>
List-Id: "OJB Developers List" <ojb-dev.db.apache.org>
Reply-To: "OJB Developers List" <ojb-dev@db.apache.org>
Delivered-To: mailing list ojb-dev@db.apache.org
Received: (qmail 29943 invoked by uid 99); 10 Feb 2006 20:18:31 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Message-ID: <1773123589.1139602688891.JavaMail.jira@ajax.apache.org>
Date: Fri, 10 Feb 2006 21:18:08 +0100 (CET)
From: "Jakob Braeuchi (JIRA)" <jira@apache.org>
To: ojb-dev@db.apache.org
Subject: [jira] Resolved: (OJB-95) Retrieving collections when FK is a
 VARCHAR
In-Reply-To: <1394058226.1139409868872.JavaMail.jira@ajax.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

     [ http://issues.apache.org/jira/browse/OJB-95?page=all ]
     
Jakob Braeuchi resolved OJB-95:
-------------------------------

    Fix Version: 1.1 CVS
     Resolution: Invalid

Relationships based on non primarykey fields are no supported in ojb 1.0.x

> Retrieving collections when FK is a VARCHAR
> -------------------------------------------
>
>          Key: OJB-95
>          URL: http://issues.apache.org/jira/browse/OJB-95
>      Project: OJB
>         Type: Bug
>   Components: PB-API
>     Versions: 1.0.4
>     Reporter: Alessandro Vincelli
>      Fix For: 1.1 CVS

>
> Hi,
> I encountered a weird problem in simply retrieving objects mapped to the following table:
>     <class-descriptor class="w4b.com.cassagest.db.Docassiste" table="DOCASSISTE">
>         <field-descriptor name="dbprogre" primarykey="true" default-fetch="true" autoincrement="true" sequence-name="public.docassiste_dbprogre_seq" column="DBPROGRE" jdbc-type="INTEGER"/>
>         <field-descriptor name="dbcodass" default-fetch="true" column="DBCODASS" jdbc-type="VARCHAR"/>
>         <field-descriptor name="dbdocume" default-fetch="true" column="DBDOCUME" jdbc-type="INTEGER"/>
>         <field-descriptor name="dbobblig" default-fetch="true" column="DBOBBLIG" jdbc-type="VARCHAR"/>
>         <field-descriptor name="dbannota" default-fetch="true" column="DBANNOTA" jdbc-type="CHAR"/>
>         <reference-descriptor name="dbcodassRef" class-ref="w4b.com.cassagest.db.Passiste" auto-update="false" auto-delete="false" proxy="false">
>             <foreignkey field-ref="dbcodass"/>
>         </reference-descriptor>
>         <reference-descriptor name="dbdocumeRef" class-ref="w4b.com.cassagest.db.Docuassist" auto-update="false" auto-delete="false" proxy="false">
>             <foreignkey field-ref="dbdocume"/>
>         </reference-descriptor>
>     </class-descriptor>
> The problem seems to be with one of the two foreign keys (dbcodass), which is a VARCHAR.
> If I fill the dbcodass field with numeric values, everything works fine: I am able to retrieve a collection of Docassiste objects using getCollectionByQuery().
> The problem comes when I really use the dbcodass field as a VARCHAR field. As soon as I populate the table with alphanumeric values, nothing works anymore. getCollectionByQuery throws the following exception:
> QUERY BY CRITERIA _______ QueryByCriteria from class w4b.com.cassagest.db.Docassiste  where [DBCODASS = PR1]
> java.lang.NumberFormatException: For input string: "PR1"
>         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
>         at java.lang.Integer.parseInt(Integer.java:468)
>         at java.math.BigInteger.<init>(BigInteger.java:314)
>         at java.math.BigInteger.<init>(BigInteger.java:447)
>         at java.math.BigDecimal.<init>(BigDecimal.java:216)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.numericValueOf(AbstractJdbc2Statement.java:1477)
>         at org.postgresql.jdbc2.AbstractJdbc2Statement.setObject(AbstractJdbc2Statement.java:1520)
>         at
> (full stacktrace below)
> NOTE: If I remove form  <class-descriptor class="w4b.com.cassagest.db.Passiste" table="PASSISTE">:
> 	    <reference-descriptor name="dbcodassRef" class-ref="w4b.com.cassagest.db.Passiste" auto-update="false" auto-delete="false" proxy="false">
> 			<foreignkey field-ref="dbcodass"/>
> 		</reference-descriptor>
> and  this lines from NOTE: If I remove form  <class-descriptor class="w4b.com.cassagest.db.Docassiste" table="DOCASSISTE">::
> 	    <collection-descriptor name="docassisteList" element-class-ref="w4b.com.cassagest.db.Docassiste" auto-update="false" auto-delete="false" proxy="false" auto-retrieve="false">
> 			<inverse-foreignkey field-ref="dbcodass"/>
> 		</collection-descriptor>		
> The method getCollectionByQuery() work fine!!
> Any ideas?
> Alessandro 
> COMPLETE REPOSITORY:
> 	<class-descriptor class="w4b.com.cassagest.db.Passiste" table="PASSISTE">
> 		<field-descriptor name="pbprogre" primarykey="true" default-fetch="true" autoincrement="true" sequence-name="public.passiste_pbprogre_seq" column="PBPROGRE" jdbc-type="INTEGER"/>
> 		<field-descriptor name="pbcodass" nullable="false" default-fetch="true" column="PBCODASS" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbdtinval" default-fetch="true" column="PBDTINVAL" jdbc-type="DATE" conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFieldConversion"/>
> 		<field-descriptor name="pbdtfival" default-fetch="true" column="PBDTFIVAL" jdbc-type="DATE" conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFieldConversion"/>
> 		<field-descriptor name="pbdescri" default-fetch="true" column="PBDESCRI" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbgglimd" default-fetch="true" column="PBGGLIMD" jdbc-type="SMALLINT"/>
> 		<field-descriptor name="pbdtlimd" default-fetch="true" column="PBDTLIMD" jdbc-type="DATE" conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFieldConversion"/>
> 		<field-descriptor name="pbdtlavf" default-fetch="true" column="PBDTLAVF" jdbc-type="DATE" conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFieldConversion"/>
> 		<field-descriptor name="pbnumean" default-fetch="true" column="PBNUMEAN" jdbc-type="SMALLINT"/>
> 		<field-descriptor name="pbfamili" default-fetch="true" column="PBFAMILI" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbachias" default-fetch="true" column="PBACHIAS" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbunicae" default-fetch="true" column="PBUNICAE" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbpercen" default-fetch="true" column="PBPERCEN" jdbc-type="NUMERIC"/>
> 		<field-descriptor name="pbricvot" default-fetch="true" column="PBRICVOT" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbimpoun" default-fetch="true" column="PBIMPOUN" jdbc-type="NUMERIC"/>
> 		<field-descriptor name="pbimpmax" default-fetch="true" column="PBIMPMAX" jdbc-type="NUMERIC"/>
> 		<field-descriptor name="pbvotoin" default-fetch="true" column="PBVOTOIN" jdbc-type="INTEGER"/>
> 		<field-descriptor name="pbvotofi" default-fetch="true" column="PBVOTOFI" jdbc-type="INTEGER"/>
> 		<field-descriptor name="pbricore" default-fetch="true" column="PBRICORE" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pblimore" default-fetch="true" column="PBLIMORE" jdbc-type="SMALLINT"/>
> 		<field-descriptor name="pboresim" default-fetch="true" column="PBORESIM" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbprogra" default-fetch="true" column="PBPROGRA" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbrimimp" default-fetch="true" column="PBRIMIMP" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbetaini" default-fetch="true" column="PBETAINI" jdbc-type="SMALLINT"/>
> 		<field-descriptor name="pbetafin" default-fetch="true" column="PBETAFIN" jdbc-type="SMALLINT"/>
> 		<field-descriptor name="pbassstu" default-fetch="true" column="PBASSSTU" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbnuasdl" default-fetch="true" column="PBNUASDL" jdbc-type="SMALLINT"/>
> 		<field-descriptor name="pbnuasll" default-fetch="true" column="PBNUASLL" jdbc-type="SMALLINT"/>
> 		<field-descriptor name="pbdtinco" default-fetch="true" column="PBDTINCO" jdbc-type="DATE" conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFieldConversion"/>
> 		<field-descriptor name="pbdtfico" default-fetch="true" column="PBDTFICO" jdbc-type="DATE" conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFieldConversion"/>
> 		<field-descriptor name="pbconreg" default-fetch="true" column="PBCONREG" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbtidata" default-fetch="true" column="PBTIDATA" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbannota" default-fetch="true" column="PBANNOTA" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbdescr1" default-fetch="true" column="PBDESCR1" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbdescr2" default-fetch="true" column="PBDESCR2" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbdescr3" default-fetch="true" column="PBDESCR3" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbdescr4" default-fetch="true" column="PBDESCR4" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbumisu1" default-fetch="true" column="PBUMISU1" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbumisu2" default-fetch="true" column="PBUMISU2" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbumisu3" default-fetch="true" column="PBUMISU3" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbumisu4" default-fetch="true" column="PBUMISU4" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbformul" default-fetch="true" column="PBFORMUL" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="pbnummes" default-fetch="true" column="PBNUMMES" jdbc-type="SMALLINT"/>
> 		<field-descriptor name="pbtipolo" default-fetch="true" column="PBTIPOLO" jdbc-type="CHAR"/>
> 		<field-descriptor name="pbassfis" default-fetch="true" column="PBASSFIS" jdbc-type="SMALLINT"/>
> 	    <collection-descriptor name="docassisteList" element-class-ref="w4b.com.cassagest.db.Docassiste" auto-update="false" auto-delete="false" proxy="false" auto-retrieve="false">
> 			<inverse-foreignkey field-ref="dbcodass"/>
> 		</collection-descriptor>		
> 		<collection-descriptor name="regassisteList" element-class-ref="w4b.com.cassagest.db.Regassiste" auto-update="false" auto-delete="false" proxy="false" auto-retrieve="false">
> 			<inverse-foreignkey field-ref="rbcodass"/>
> 		</collection-descriptor>
> 	</class-descriptor>
> 	<class-descriptor class="w4b.com.cassagest.db.Docassiste" table="DOCASSISTE">
> 		<field-descriptor name="dbprogre" primarykey="true" default-fetch="true" autoincrement="true" sequence-name="public.docassiste_dbprogre_seq" column="DBPROGRE" jdbc-type="INTEGER"/>
> 		<field-descriptor name="dbcodass" default-fetch="true" column="DBCODASS" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="dbdocume" default-fetch="true" column="DBDOCUME" jdbc-type="INTEGER"/>
> 		<field-descriptor name="dbobblig" default-fetch="true" column="DBOBBLIG" jdbc-type="VARCHAR"/>
> 		<field-descriptor name="dbannota" default-fetch="true" column="DBANNOTA" jdbc-type="CHAR"/>
> 	    <reference-descriptor name="dbcodassRef" class-ref="w4b.com.cassagest.db.Passiste" auto-update="false" auto-delete="false" proxy="false">
> 			<foreignkey field-ref="dbcodass"/>
> 		</reference-descriptor>
> 		<reference-descriptor name="dbdocumeRef" class-ref="w4b.com.cassagest.db.Docuassist" auto-update="false" auto-delete="false" proxy="false">
> 			<foreignkey field-ref="dbdocume"/>
> 		</reference-descriptor>
> 	</class-descriptor>
> 	<class-descriptor class="w4b.com.cassagest.db.Docuassist" table="DOCUASSIST">
> 		<field-descriptor name="dgprogre" primarykey="true" default-fetch="true" autoincrement="true" sequence-name="public.docuassist_dgprogre_seq" column="DGPROGRE" jdbc-type="INTEGER"/>
> 		<field-descriptor name="dgdescri" default-fetch="true" column="DGDESCRI" jdbc-type="CHAR"/>
> 		<field-descriptor name="dgdescre" default-fetch="true" column="DGDESCRE" jdbc-type="VARCHAR"/>
> 		<collection-descriptor name="docassisteList" element-class-ref="w4b.com.cassagest.db.Docassiste" auto-update="false" auto-delete="false" proxy="false" auto-retrieve="false">
> 			<inverse-foreignkey field-ref="dbdocume"/>
> 		</collection-descriptor>
> 		<collection-descriptor name="docregassList" element-class-ref="w4b.com.cassagest.db.Docregass" auto-update="false" auto-delete="false" proxy="false" auto-retrieve="false">
> 			<inverse-foreignkey field-ref="dfdocume"/>
> 		</collection-descriptor>
> 		<collection-descriptor name="docassistsList" element-class-ref="w4b.com.cassagest.db.Docassists" auto-update="false" auto-delete="false" proxy="false" auto-retrieve="false">
> 			<inverse-foreignkey field-ref="dbdocume"/>
> 		</collection-descriptor>
> 	</class-descriptor>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org