db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Nabbefeld <Peter.Nabbef...@gmx.de>
Subject Re: Automatic database and schema creation
Date Fri, 22 Apr 2005 12:46:58 GMT
Thank You, it works now.

Peter


Øystein Grøvlen - Sun Norway schrieb:
> Peter Nabbefeld wrote:
> 
>>
>> Hello,
>>
>> I just want to create a database, if it does not yet exist. Database 
>> creation works, schema creation does not. I'm using the following 
>> syntax (in Java):
>>
>>     Statement stmt = con.createStatement();
>>     stmt.execute("CREATE SCHEMA USER");
>>
>> The result is an SQLException with SQLState = 42X01 (Syntax error).
>> What am I doing wrong? Before creation, I'm trying to insert a record. 
>> If an Exception is thrown, I ask for status 42Y07 (Schema does not 
>> exist). Derby is stable version (10.0.2.1).
>>
> 
> USER is a reserved word.  I think it would be nice if the error message 
> reflected that.
> 
> -- 
> Øystein
> 


Mime
View raw message