On 30/04/12 06:50, Tayfun Gökmen HALAÇ wrote:
Thank you for your answer Andy.
I have already autoReconnect=true in my configuration file. Here's my SDB store
configuration. Is there any mistake?
<#sdbvoidstore> rdf:type sdb:Store ;
rdfs:label "SDB" ;
sdb:layout "layout2" ;
sdb:connection
[ rdf:type sdb:SDBConnection ;
sdb:sdbType "MySql" ;
sdb:sdbHost "localhost" ;
sdb:sdbName "voidstore" ;
sdb:sdbUser"****";
sdb:sdbPassword"****";
sdb:driver "com.mysql.jdbc.Driver" ;
sdb:jdbcURL "jdbc:mysql://localhost/voidstore?autoReconnect=true" ;
]
.
The first point is that Joseki does not catch a QueryStageException which
encapsulates mysql connection exception. It catches a JenaException.
I'm not sure why QueryStageException is being raised. In the rest of
the description are you using sdb:Model?
My modified SPARQL processor cannot obtain a connection although it tries for
the second time and autoreconnect is enabled.
That should work.
One way to keep the connection alive is to ask a lightweight query every
hour, e.g "ASK{:x :p :o}" -- the IRIs do not have to be in the data.
Andy
Tayfun
On 27/04/12 17:01, Tayfun Gökmen HALAÇ wrote:
Andy,
Do you have any comments on Joseki SPARQL processor? Message are answered on a "when
I can basis" My expeirnece was that if autoreconnect is enabled, then the first call
after a long idle period still failed. Retrying was necessary. But you still
need autoreconnect. Andy
