On 4 Apr 2013, at 18:46, Aaron Jackson <[email protected]> wrote:
> Hi, Hi there, > We are using SDB (1.3.5-SNAPSHOT) backed by Oracle to store and access > triples, and encountered this error: .... > Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already > used by an existing object ... > com.hp.hpl.jena.sdb.layout2.TupleLoaderBase.createTempTables(TupleLoaderBase.java:344) > We do have multiple threads potentially creating new Stores and SDB models > to the same underlying named models. Also, we tend to see Oracle churning > quite heavily (70% internal usage) during operation. Is SDB creating > indexes or constraints on the fly as data is inserted? Each SDB store has an associated loader. The loader uses temporary tables suppress duplicates in the node and tuple tables -- these loader tables are very plain, no indexes or constraints. What might cause your problem is reusing db connections with different stores -- although it ought to work if you close the store. Alternatively it may also be that temporary tables are visible between connections (I've been bitten by that on some databases). Damian
