Hello Roman,

I have tried this under beta one and I get the following:

java.sql.SQLException: GDSException: org.firebirdsql.gds.GDSException:
Dynamic SQL Error
SQL error code = -901
feature is not supported
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:89)
at
org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:178)
at QASRipper.GuidGenerator$Key.loadKey(GuidGenerator.java:49)
at QASRipper.GuidGenerator$Key.<init>(GuidGenerator.java:28)
at QASRipper.GuidGenerator.getNextValue(GuidGenerator.java:76)
at QASRipper.Test.main(Test.java:24)

This is using a PreparedStatement, not just a normal statement.

Regards,

Stephen.

-----Original Message-----
From: rrokytskyy [mailto:rrokytskyy@...]
Sent: 31 May 2002 14:36
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: Selecting generators.


Hi,

> Am I correct in thinking that the following can not be performed in
> a prepared statement in the beta one release?
>
> SELECT GEN_ID(SEQUENCE_NAME, 1) AS NEWKEY FROM RDB$DATABASE

Do not know about beta 1, but current CVS version does allow this
(just checked it in JDBC explorer). But I think it works in beta 1
too.

Best regards,
Roman Rokytskyy



To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



-------------------------------------------------------------------------------------------

Copyright material and/or confidential and/or privileged information may be contained in this e-mail and any attached documents. The material and information is intended for the use of the intended addressee only. If you are not the intended addressee, or the person responsible for delivering it to the intended addressee, you may not copy, disclose, distribute, disseminate or deliver it to anyone else or use it in any unauthorised manner or take or omit to take any action in reliance on it. To do so is prohibited and may be unlawful. The views expressed in this e-mail may not be official policy but the personal views of the originator. If you receive this e-mail in error, please advise the sender immediately by using the reply facility in your e-mail software, or contact postmaster@.... Please also delete this e-mail and all documents attached immediately.
Many thanks for your co-operation.

BMW Financial Services (GB) Limited is registered in England and Wales under company number 01288537.
Registered Offices : Europa House, Bartley Way, Hook, Hants, RG27 9UF
------------------------------------------------------------------------------------------