Re: BUG #8248: se presenta una excepcion cuando intento realizar consultas des la aplicacion en netbeasns

On Fri, Jun 21, 2013 at 2:06 PM,  <javelasco30@misena.edu.co> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      8248
> Logged by:          Jefferson Velasco
> Email address:      javelasco30@misena.edu.co
> PostgreSQL version: 8.4.0
> Operating system:   windows
> Description:
>
> Exception [EclipseLink-4002] (Eclipse Persistence Services -
> 2.2.0.v20110202-r8913): org.eclipse.persistence.exceptions.DatabaseExcept=
ion
> Internal Exception: org.postgresql.util.PSQLException: ERROR: no est=E1n
> implementadas las referencias entre bases de datos:
> =ABfarmacia.public.usuario=BB Error Code: 0 Call: SELECT idusuario, clave=
,
> nombreusuario, rol, idpersona FROM Farmacia.public.usuario WHERE
> ((nombreusuario =3D ?) AND (clave =3D ?)) bind =3D> [2 parameters bound] =
Query:
> ReadAllQuery(referenceClass=3DUsuario sql=3D"SELECT idusuario, clave,
> nombreusuario, rol, idpersona FROM Farmacia.public.usuario WHERE
> ((nombreusuario =3D ?) AND (clave =3D ?))")
>
>

This is not actually a bug but a well known postgresql limitation, you
can't use database references in the from.

I answered to the OP, explaining that and redirecting him to pgsql-es-ayuda=
@

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n
Phone: +593 4 5107566         Cell: +593 987171157