You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jena.apache.org by Rudi Lutz <ru...@gmail.com> on 2011/03/16 10:18:39 UTC

SDB Errors

Hi!
   I have installed Jena and SDB 1.3.3 and am trying to configure it to work
with MySQL. As far as I can tell everything is configured properly. However
when I run the SDB test suite in testing/testing/manifest-sdb.ttl I get 6
errors and a failure. The failure is a Unicode error that lots of people
seem to get, but the others are "Null bridge" errors whatever they are. Can
anyone suggest a way round this. I have seen a vague suggestion (doing a
Google search) that there may be a patch. Anyone know anything about this?
Or should I use an earlier version of SDB?

Thanks very much for any help/advice

Regards,
           Rudi

PS I running this on a Mac Air
PPS Here is the output from the test suits:

$ bin/sdbtest -v  -sdb=sdb.ttl testing/manifest-sdb.ttl
Manifest: testing/manifest-sdb.ttl
Test: Term-01
Test: Term-02 - plain string
Test: Term-03
Test: Term-04
Test: Term-05 - unknown type
Test: Term-06
Test: Term-07
Test: Term-08
Test: Term-09
Test: Term-10
Test: Term-11
Test: Term-12
Test: Vars-1
Test: Vars-2
Test: Vars-3
Test: Vars-4
Test: Vars-5
Test: Unicode-1
Test: Unicode-2
Test: Unicode-3
Test: Unicode-4
Test: Unicode-5
------------------- Unicode-5
**** Expected (Standard engine)-------------------------------------------
| p                    | o                |
===========================================
| <http://example/p27> | "Left arrow:←"   |
| <http://example/p24> | "E-acute:é"      |
| <http://example/p25> | "Alpha:α"        |
| <http://example/p26> | "Arabic 123:١٢٣" |
-------------------------------------------
**** Got (SDB engine)
-------------------------------------------
| p                    | o                |
===========================================
| <http://example/p27> | "Left arrow:?"   |
| <http://example/p25> | "Alpha:?"        |
| <http://example/p26> | "Arabic 123:???" |
| <http://example/p24> | "E-acute:é"      |
-------------------------------------------
** Failure:  Unicode-5(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB)
  Results sets not the same
junit.framework.Assert.fail(Assert.java:47)
Test: Basic - Empty pattern, all variables
Test: Basic - Empty pattern -name variable
Test: Basic - 1 - Single triple pattern
Test: Basic - 2 - Two triple patterns, common subject pair, object-subject
path
Test: Basic - 3 - Three triple patterns, common subject
Test: Triple - 1
Test: Triple - 2
Test: Triple - 3
Test: Triple - 4
Test: Optional - 1
Test: Optional - 2
Test: Optional - 3
Test: Optional - 4
Test: Coalesce - 1
Test: Coalesce - 2
Test: Coalesce - 3
Test: Partially optimized - 1
Test: Partially optimized - 2
Test: Partially optimized - 3
Test: Partially optimized - 4
Test: Regex-1
Test: Regex-2
Test: Regex-3
Test: Regex-opt-1
Test: Regex-opt-2
Test: Regex-opt-3
Test: Regex-opt-4
Test: Equals-1
Test: Equals-2
Test: Nested Optionals - 1
Test: Nested Optionals - 2
Test: Optional-filter - 1
Test: Filter-nested - 1
Test: Filter-nested - 2
Test: Structure - 1
Test: Structure - 2
Test: Structure - 3
Test: Structure - 4
Test: Structure - 5
Test: Structure - 6
Test: Structure - 10
Test: Quads-1
Test: Quads-2
Test: Quads-2a
Test: Merge-1
Test: Merge-2
Test: Merge-3
Test: Merge-4
Test: Merge-5
Test: Merge-6
Test: Merge-A
Test: Merge-B
Test: Slice 1
ERROR [main] (SDB_QC.java:64) - Null bridge
** Error:    Slice 1(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB)
com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:65)
Test: Slice 2
ERROR [main] (SDB_QC.java:64) - Null bridge
** Error:    Slice 2(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB)
com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:65)
Test: Slice 3
ERROR [main] (SDB_QC.java:64) - Null bridge
** Error:    Slice 3(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB)
com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:65)
Test: Slice 4
ERROR [main] (SDB_QC.java:64) - Null bridge
** Error:    Slice 4(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB)
com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:65)
Test: Slice 5
ERROR [main] (SDB_QC.java:64) - Null bridge
** Error:    Slice 5(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB)
com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:65)
Test: Slice 6
ERROR [main] (SDB_QC.java:64) - Null bridge
** Error:    Slice 6(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB)
com.hp.hpl.jena.sdb.compiler.SDB_QC.exec(SDB_QC.java:65)
Test: Distinct 1
Test: Distinct 2

===========================================
Tests = 82 : Successes = 75 : Errors = 6 : Failures = 1

Error:    Slice 1(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB): null

Error:    Slice 2(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB): null

Error:    Slice 3(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB): null

Error:    Slice 4(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB): null

Error:    Slice 5(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB): null

Error:    Slice 6(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB): null

Failure:  Unicode-5(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB): Results
sets not the same

Re: SDB Errors

Posted by Andy Seaborne <an...@epimorphics.com>.

On 16/03/11 09:18, Rudi Lutz wrote:
> Hi!
>     I have installed Jena and SDB 1.3.3 and am trying to configure it to work
> with MySQL. As far as I can tell everything is configured properly. However
> when I run the SDB test suite in testing/testing/manifest-sdb.ttl I get 6
> errors and a failure. The failure is a Unicode error that lots of people
> seem to get, but the others are "Null bridge" errors whatever they are. Can
> anyone suggest a way round this. I have seen a vague suggestion (doing a
> Google search) that there may be a patch. Anyone know anything about this?

Try this:

http://openjena.org/repo-dev/com/hp/hpl/jena/sdb/1.3.4-SNAPSHOT/

it's the development build of SDB and has (should have ...) that issue 
fixed.

> Or should I use an earlier version of SDB?
>
> Thanks very much for any help/advice
>
> Regards,
>             Rudi
>
> PS I running this on a Mac Air
> PPS Here is the output from the test suits:
>
> Test: Unicode-5
> ------------------- Unicode-5
> **** Expected (Standard engine)-------------------------------------------
> | p                    | o                |
> ===========================================
> |<http://example/p27>  | "Left arrow:←"   |
> |<http://example/p24>  | "E-acute:é"      |
> |<http://example/p25>  | "Alpha:α"        |
> |<http://example/p26>  | "Arabic 123:١٢٣" |
> -------------------------------------------
> **** Got (SDB engine)
> -------------------------------------------
> | p                    | o                |
> ===========================================
> |<http://example/p27>  | "Left arrow:?"   |
> |<http://example/p25>  | "Alpha:?"        |
> |<http://example/p26>  | "Arabic 123:???" |
> |<http://example/p24>  | "E-acute:é"      |
> -------------------------------------------
> ** Failure:  Unicode-5(com.hp.hpl.jena.sdb.test.junit.QueryTestSDB)
>    Results sets not the same

This means the database, server or JDBC connection is not set to UTF-8.

If you have control of the server, set it to work in UTF-8 by default.

If you don't, make sure the DB is UTF-8 and also the JDBC connection 
itself (the DB setting does not affect the connection - the default 
server setting does)

http://openjena.org/wiki/SDB/NotesMySQL

	Andy