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:[EMAIL PROTECTED] 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="[EMAIL PROTECTED]" > ... 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
