Hi Alcides
We had a similar problem with one of our clients.
To avoid this problem we have changed the getConnection of
java.org.dspace/storage/rbdms/DatabaseManager.java
public static Connection getConnection() throws SQLException
{
initialize();
if (dataSource != null) {
Connection conn = dataSource.getConnection();
if (!StringUtils.isEmpty(sqlOnBorrow))
{
PreparedStatement pstmt =
conn.prepareStatement(sqlOnBorrow);
try
{
pstmt.execute();
}
finally
{
if (pstmt != null)
{
pstmt.close();
}
}
}
// ADDED!!
if (isOracle())
{
PreparedStatement pstmt = conn.prepareStatement("alter
session set nls_sort='binary'");
try
{
pstmt.execute();
}
finally
{
if (pstmt != null)
{
pstmt.close();
}
}
}
// END ADDED!!
return conn;
}
return null;
}
Also you can try to change your browseDao to solr.
regarsd
Adán Román Ruiz
ARVO Consultores
2014-08-12 16:07 GMT+02:00 Alcides Carlos de Moraes Neto <
[email protected]>:
> Olá Emílio =)
>
> Yes, we have a Oracle DB.
> I have noticed this also happens for the browse by title and by subject
> pages
> http://www2.senado.leg.br/bdsf/browse?type=subject
>
> Type "prol", the first subject that shows is *Projeto urbanístico,
> Brasília (DF) [1], * not *Proletarização [1]*
>
> http://www2.senado.leg.br/bdsf/browse?type=title
>
> Type "aboli", the first item shown's title is *Aceleração do consumo
> familiar acionou alarme *
> But there are titles that begin with Aboli, like* Abolição da escravatura
> [gravação de som]* (http://www2.senado.leg.br/bdsf/handle/id/96823)
>
>
>
>
>
> Ats,
>
>
> Alcides Carlos de Moraes Neto
> "Sometimes I think we're alone. Sometimes I think we're not. In either
> case, the thought is staggering."
> - R. Buckminster Fuller
>
>
> 2014-08-12 3:55 GMT-03:00 emilio lorenzo <[email protected]>:
>
> Bom dia, Alcides
>>
>> which database are you using ? oracle?
>> Do you always have the same behaviour in your repository´s browsing or
>> is it something new?
>>
>> Saudações
>> Emilio Lorenzo
>>
>>
>>
>> El 12/08/2014 1:18, Alcides Carlos de Moraes Neto escribió:
>>
>> Hello
>>
>> We have a running 3.2 dspace instance. It is showing abnormal behavior
>> on the browse by author page. More specifically, when there is some input
>> in the startsWith field.
>>
>> http://www2.senado.leg.br/bdsf/browse?type=author
>>
>> If you type something, like "Santos", the first author name shown is
>> "Santi", not "Santos".
>> There is no "Santos" author in the first page of results, only in the
>> next.
>>
>> Anyone knows what can cause this?
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>>
>>
>>
>> _______________________________________________
>> DSpace-tech mailing
>> [email protected]https://lists.sourceforge.net/lists/listinfo/dspace-tech
>> List Etiquette:
>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>>
>>
>>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
--
Adán Román Ruiz
[email protected]
------------------------------------------------------------------------------
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
