You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Eduardo Resende <ed...@brisa.org.br> on 2003/12/17 13:22:32 UTC

Oracle selects on links

Hi, i have a problem when I make some query on a Oracle database link, i've
mapped it on repository_user.xml this way:

<class-descriptor
  class="br.org.brisa.lg.portal.model.ProdutoReclassificadoVO"
  table="mkt.vw_produto_reclassificado@lnk_m_producao"
>

... Fields ...

</class-descriptor>

I get this error only when I try to query the object
ProdutoReclassificadoVO:

Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException: ORA-12154:
TNS:could not resolve service name
            at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
            at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
Source)
            at
org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Unknown
Source)
            at
org.apache.ojb.broker.core.ReportRsIteratorFactoryImpl.createRsIterator(Unkn
own Source)
            at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
            at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIteratorFromQ
uery(Unknown Source)
            at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIteratorByQue
ry(Unknown Source)
            at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getReportQueryIterato
rByQuery(Unknown Source)
            at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getReportQueryIterato
rByQuery(Unknown Source)
            at
br.org.brisa.lg.portal.dao.ProdutoReclassificadoDAO.findTiposDeProdutoPorUni
dade(ProdutoReclassificadoDAO.java:40)
            ... 45 more


I use OJB RC4, with Tomcat 4.1.24 and Oracle 9i.

Thanks in advance,

Eduardo Resende
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003


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

RES: Oracle selects on links

Posted by Eduardo Resende <ed...@brisa.org.br>.
I found the solution to my problem :)

I created synonyms for the database links, it worked well.

Thanks
Eduardo

-----Mensagem original-----
De: Eduardo Resende [mailto:eduardo.resende@brisa.org.br]
Enviada em: quarta-feira, 17 de dezembro de 2003 09:23
Para: OJB Users List
Assunto: Oracle selects on links


Hi, i have a problem when I make some query on a Oracle database link, i've
mapped it on repository_user.xml this way:

<class-descriptor
  class="br.org.brisa.lg.portal.model.ProdutoReclassificadoVO"
  table="mkt.vw_produto_reclassificado@lnk_m_producao"
>

... Fields ...

</class-descriptor>

I get this error only when I try to query the object
ProdutoReclassificadoVO:

Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException: ORA-12154:
TNS:could not resolve service name
            at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
            at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
Source)
            at
org.apache.ojb.broker.accesslayer.ReportQueryRsIterator.<init>(Unknown
Source)
            at
org.apache.ojb.broker.core.ReportRsIteratorFactoryImpl.createRsIterator(Unkn
own Source)
            at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn
own Source)
            at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIteratorFromQ
uery(Unknown Source)
            at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getReportQueryIteratorByQue
ry(Unknown Source)
            at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getReportQueryIterato
rByQuery(Unknown Source)
            at
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getReportQueryIterato
rByQuery(Unknown Source)
            at
br.org.brisa.lg.portal.dao.ProdutoReclassificadoDAO.findTiposDeProdutoPorUni
dade(ProdutoReclassificadoDAO.java:40)
            ... 45 more


I use OJB RC4, with Tomcat 4.1.24 and Oracle 9i.

Thanks in advance,

Eduardo Resende
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.551 / Virus Database: 343 - Release Date: 11/12/2003


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