[BioC] RSQLite error when using AnnotationDbi/SQLForge

Tim Rayner tfrayner at gmail.com
Mon Jul 14 18:11:36 CEST 2008


Hi,

I'm having a problem building a custom AnnotationDbi-style package
using the SQLForge functions. It appears that something from the
RSQLite package is disagreeing with the makeHUMANCHIP_DB function,
such that there's an "attempt to write a readonly database". See below
for a full transcript:

> library('AnnotationDbi')
Loading required package: Biobase
Loading required package: tools

Welcome to Bioconductor

  Vignettes contain introductory material. To view, type
  'openVignette()'. To cite Bioconductor, see
  'citation("Biobase")' and for packages 'citation(pkgname)'.

Loading required package: DBI
Loading required package: RSQLite
> makeHUMANCHIP_DB(
    affy=FALSE,
    prefix='Human25kOligoSet.db',
    fileName='refseq.txt',
    baseMapType='refseq',
    outputDir='.',
    version='0.1',
    manufacturer='MRC',
    chipName='Human 25k Oligo Set',
    manufacturerUrl='http://www.geneservice.co.uk')
baseMapType is refseq
Prepending Metadata
Creating Genes table
Error in sqliteExecStatement(con, statement, bind.data) :
  RS-DBI driver: (RS_SQLite_exec: could not execute1: attempt to write
a readonly database)
> sessionInfo()
R version 2.7.1 (2008-06-23)
i386-apple-darwin8.10.1

locale:
en_GB.UTF-8/en_GB.UTF-8/C/C/en_GB.UTF-8/en_GB.UTF-8

attached base packages:
[1] tools     stats     graphics  grDevices utils     datasets  methods
[8] base

other attached packages:
[1] AnnotationDbi_1.2.2 RSQLite_0.6-9       DBI_0.2-4
[4] Biobase_2.0.1


All the packages were installed with biocLite(..., type='source'). The
"refseq.txt" file is a two-column file with arbitrary probe
identifiers linked to Refseq accessions, as described in the SQLForge
vignette. Has anyone else seen this problem? Can anyone point me to
where my error might be?

Many thanks in advance,

Tim Rayner



More information about the Bioconductor mailing list