Re: Error with database creation with SQL

Drew Jensen <[email protected]> Tue, 09 Mar 2010 02:45:10 -0500
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Sergio Corato wrote:
> os Windows Vista -  OOo 3.2.0
>
> I have the following error in a macro that:
> -create a database
> -register the database in the data sources
> -create the tables in the database*
>
> *the error happens here
>
> ---error----
> Exception:
> Type: com.sun.star.sdbc.SQLException
> Message: Error in reading/writing on file error java.io.IOException: 
> S1000 invalid storage class: java.lang.NullPointerException opening 
> file - file C:\Users\HiIcsToolsDb.odb.data in statement [create table 
> "icstoolsdb.art"].
>
> This doesn't happen with OOo 3.1.1
> If I only register the db, close OOo and reopen, I can create the 
> tables without problems.
>
> Macro are these ones:
>

Hello Sergio,

It appears that under 3.2

oContext.registerObject(HIDB, oDb)

silently fails to register the data source.

Tried with Ubuntu here - I'll go ahead and open an issue and attach an 
example file, if you like?

Drew