Re: Error with database creation with SQL

Sergio Corato <[email protected]> Tue, 09 Mar 2010 21:31:40 +0100
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Drew Jensen ha scritto:
> 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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
Thank you very much: can I help you?

Sergio