Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (herse.apache.org: local policy)
From: "Flavio Palumbo" <f.palumbo@silmasoftware.com>
To: "Derby Discussion" <derby-user@db.apache.org>
Subject: R: R: R: Use SQL parsing
Date: Mon, 4 Dec 2006 09:08:01 +0100
Message-ID: <000301c7177b$5189cc70$5200000a@PALUMBOXP>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
In-Reply-To: <45704D0E.9030102@apache.org>
Importance: Normal

Hi Dan,

I think you've well summarized what's my aim ;-)) and also that your
proposal of solution seems very handy.

I'll stay "tuned" to try to test this new release as soon as it will be
available.

Thanks a lot

Flavio

> -----Messaggio originale-----
> Da: Daniel John Debrunner [mailto:djd@apache.org]
> Inviato: venerd� 1 dicembre 2006 16.41
> A: Derby Discussion
> Oggetto: Re: R: R: Use SQL parsing
>
>
> Flavio Palumbo wrote:
> > Well, I made a little tool where a user can submit free SQL
> statements ...
> > I'd like to parse it before submitting to trap sintax errors.
>
> So I assume you are looking to make sure that well-formed SQL statements
> are created before the statement is sent to the real database. I guess
> that a statement such as:
>
>    SELECT A,B FROM T
>
> needs to be seen as valid, even if  T does not exist, or A, B are not
> valid columns in T.
>
> Derby does not support that yet, but it's possible to add that type of
> functionality. I could imagine something like a database type of
> 'syntax' that would only provide syntax checking on a prepare, e.g. a
> JDBC URL of
>
>   jdbc:derby:syntax:
>
> There would be no store behind this "database", just the SQL layer of
> Derby. In the past I've run Derby like this to show how the layers are
> independent of each other, i.e. a storeless Derby that could perform any
> SQL query that did not go against a real database object (e..g VALUES 1).
>
> I've been messing with the some code in this area now (and in the past)
> so I'll look into making progress on this for the next major release of
> Derby.
>
> Dan.
>


-----------------------------------------------------------
Il presente messaggio non costituisce un impegno contrattuale tra SILMA S.r.l. ed il destinatario.
Le opinioni ivi espresse sono quelle dell'autore.
SILMA S.r.l. non assume alcuna responsabilita riguardo al contenuto del presente messaggio.
Il messaggio � destinato esclusivamente al destinatario.
Il contenuto e gli allegati sono da considerarsi di natura confidenziale

Nel caso abbiate ricevuto il presente messaggio per errore siete pregati di comunicarlo
alla casella segreteria@silmasoftware.com.