Menu
▾
▴
firebird-net-provider
|
From: Carlos G. A. <car...@te...> - 2003-07-11 09:26:15
|
Hello: After some time thinking on it i have decided to rewrite the GDS implementation, i decide this after see the result of the implementation of the protocol of a Data Provider for other RDBMS i have been developed since past month, i think that with the rewrite the GDS will more clear an easy of mantain and i expect faster too. The new GDS implementation will be included in 1.5 version ( i'm starting to work in it yet ), i'm planning to add for this version classes for metadata extraction, that will be accessed from a GetDbSchema method of FbConnection ( like for OleDb provider ) and some design time support for VS.NET ( non decided yet but i think this will be interesting ), but main objective is to rewrite the GDS implementation. This rewrite will affect only to internal classes, ADO.NET classes will expose the same members as in version 1.1. With this in mind the next version of the 1.1 branch will be Beta 1 and developement will be feature freeze and only bug fixes will accepted for this, probably there will be one more beta version and at least 3 release candidates. Comments are welcome !! :D -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G. A. <car...@te...> - 2003-09-25 09:48:18
|
Hello: 1. I have made today one fix to the FbDataReader class for a better handling of blob SUB_TYPE and added a new NUNit Text Fixture for blob fields. 2. I'm making some changes to the nant build file to test the msi task, i need to check some things but i'm thinking on use this for installation build instead of the Ghost installer (if msi nant task works ok), opinions are wellcome ?? 3. Another question is wich version of the .net framework will be used for future installations, as there are people working with both 1.0 and 1.1, opinions are wellcome ?? 4. Finally i cotinue to work in the ASP.NET sample app that can be found in the CVS at: NETPRovider/SampleApplication/ASP.NET/BugTracker -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Mike N. <mi...@ta...> - 2003-09-25 09:58:33
|
Hi, I'm using the standard data grid with the FbReader and I get an error when I try to enable paging on the grids. Is this something that is going to be looked at? Mike |
|
From: Carlos G. A. <car...@te...> - 2003-09-25 10:13:58
|
Hello: > I'm using the standard data grid with the FbReader and I get an error when I > try to enable paging on the grids. > > Is this something that is going to be looked at? Can you send a test case ?? And the stack trace of the exception ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Alessandro P. <pet...@in...> - 2003-09-25 10:11:36
|
"Carlos Guzman Alvarez" <car...@te...> wrote in message news:3F7...@te...... > Hello: > > 1. I have made today one fix to the FbDataReader class for a better > handling of blob SUB_TYPE and added a new NUNit Text Fixture for blob > fields. The cvs has been restored, I hope to be able to get this patch. > 2. I'm making some changes to the nant build file to test the msi task, > i need to check some things but i'm thinking on use this for > installation build instead of the Ghost installer (if msi nant task > works ok), opinions are wellcome ?? No idea, sorry. I don't use the installer. > 3. Another question is wich version of the .net framework will be used > for future installations, as there are people working with both 1.0 and > 1.1, opinions are wellcome ?? I think the 1.0 should be provided "on demand". > 4. Finally i cotinue to work in the ASP.NET sample app that can be found > in the CVS at: > > NETPRovider/SampleApplication/ASP.NET/BugTracker Have to find out some time to try it, sorry. Ciao, Alessandro Petrelli. |
|
From: Carlos G. A. <car...@te...> - 2003-09-25 10:15:11
|
Hello: > The cvs has been restored, I hope to be able to get this patch. If you want i can send to you a zip file with latest cvs sources. > No idea, sorry. I don't use the installer. :) > I think the 1.0 should be provided "on demand". Thanks :) > Have to find out some time to try it, sorry. No problem i'm working on it little by little :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Alessandro P. <pet...@in...> - 2003-09-25 13:51:36
|
"Carlos Guzman Alvarez" <car...@te...> wrote in message news:3F7...@te...... > Hello: > > > The cvs has been restored, I hope to be able to get this patch. > > If you want i can send to you a zip file with latest cvs sources. No problem, the cvs has the correct version. Thank you. Ciao, Alessandro Petrelli. |
|
From: Carlos G. A. <car...@te...> - 2003-10-06 15:09:31
|
Hello: First of all i want to suggest to all people that is using 1.5 version to upgrade to the latest version using CVS sources, i'm thinking in release next version soon, but until it's released it's better to be working with the latest version from CVS. MONO ---- 1. Information about the Firebird Data Provider at mono:: project web site has been update, you can see it here: http://www.go-mono.com/firebird.html 2. Named parameters. I have made some little tests of named parameters feature with mono 0.28 on linux and seems to be working now, for more information you can see this: http://bugzilla.ximian.com/show_bug.cgi?id=48666 3- Linux makefile. I have made some changes to the linux makefile for make the build of the NUnit test suite. 4. Exception formatting. Exceptions will be correct formatted in mono. Development ------------ 1. Build system. I have make some rework to the nant build files, now versions for MS .NET 1.0, MS .NET 1.1 and mono will be built at the same time with the same nant script. 2. Implicit transaction support. I have made a change to the implicit transaction support for make that commands without a transaction (explicit) can't be executed when the command connection have a active transaction that is not updated ( committed or roll backed ). 3. Firebird services implementation. A minor fix has been added to the FbService class for make the attachment in the same way as in old 1.1 sources. 4. Firebird Events implementation. A minor change has been added to the synchronization code. 5. Blob and array fields. Now it's possible to retrieve the value of blob and array fields as result of FbCommand.ExecuteScalar method, and as result of output parameters of stored procedure execution, for this i have added a new class to the GDS implementation called GdsValue.cs. 6. Design time support. Design time support for FbParameterCollection has been improved, for this there are two new classes: FbParameterCollectionEditor.cs FbParameterConverter.cs Toolbox images now have transparent background. ( Thanks to Luciano Passuello for his feedback on this issue ) 7. Cursor name property. FbCommand.CursorName property has been removed. 8. Command builder. Update and delete commands are now generated in different way ( similar to SqlClient and OleDb providers ) Example of Update Command: UPDATE "TEST_TABLE_01" SET "INT_FIELD" = ?, "CHAR_FIELD" = ?, "VARCHAR_FIELD" = ?, "BIGINT_FIELD" = ?, "SMALLINT_FIELD" = ?, "DOUBLE_FIELD" = ?, "NUMERIC_FIELD" = ?, "DECIMAL_FIELD" = ?, "DATE_FIELD" = ?, "TIME_FIELD" = ?, "TIMESTAMP_FIELD" = ?, "CLOB_FIELD" = ?, "BLOB_FIELD" = ?, "IARRAY_FIELD" = ?, "SARRAY_FIELD" = ?, "LARRAY_FIELD" = ?, "FARRAY_FIELD" = ?, "BARRAY_FIELD" = ?, "NARRAY_FIELD" = ?, "DARRAY_FIELD" = ?, "TARRAY_FIELD" = ?, "TSARRAY_FIELD" = ?, "CARRAY_FIELD" = ?, "VARRAY_FIELD" = ?, "BIG_ARRAY" = ? WHERE ( ("INT_FIELD" = ?) AND (("CHAR_FIELD" IS NULL) OR ("CHAR_FIELD" = ?)) AND (("VARCHAR_FIELD" IS NULL) OR ("VARCHAR_FIELD" = ?)) AND (("BIGINT_FIELD" IS NULL) OR ("BIGINT_FIELD" = ?)) AND (("SMALLINT_FIELD" IS NULL) OR ("SMALLINT_FIELD" = ?)) AND (("DOUBLE_FIELD" IS NULL) OR ("DOUBLE_FIELD" = ?)) AND (("NUMERIC_FIELD" IS NULL) OR ("NUMERIC_FIELD" = ?)) AND (("DECIMAL_FIELD" IS NULL) OR ("DECIMAL_FIELD" = ?)) AND (("DATE_FIELD" IS NULL) OR ("DATE_FIELD" = ?)) AND (("TIME_FIELD" IS NULL) OR ("TIME_FIELD" = ?)) AND (("TIMESTAMP_FIELD" IS NULL) OR ("TIMESTAMP_FIELD" = ?)) AND (("EXPR_FIELD" IS NULL) OR ("EXPR_FIELD" = ?)) ) Example of Delete Command: DELETE FROM "TEST_TABLE_01" WHERE ( ("INT_FIELD" = ?) AND (("CHAR_FIELD" IS NULL) OR ("CHAR_FIELD" = ?)) AND (("VARCHAR_FIELD" IS NULL) OR ("VARCHAR_FIELD" = ?)) AND (("BIGINT_FIELD" IS NULL) OR ("BIGINT_FIELD" = ?)) AND (("SMALLINT_FIELD" IS NULL) OR ("SMALLINT_FIELD" = ?)) AND (("DOUBLE_FIELD" IS NULL) OR ("DOUBLE_FIELD" = ?)) AND (("NUMERIC_FIELD" IS NULL) OR ("NUMERIC_FIELD" = ?)) AND (("DECIMAL_FIELD" IS NULL) OR ("DECIMAL_FIELD" = ?)) AND (("DATE_FIELD" IS NULL) OR ("DATE_FIELD" = ?)) AND (("TIME_FIELD" IS NULL) OR ("TIME_FIELD" = ?)) AND (("TIMESTAMP_FIELD" IS NULL) OR ("TIMESTAMP_FIELD" = ?)) AND (("EXPR_FIELD" IS NULL) OR ("EXPR_FIELD" = ?)) ) Example of Insert Command: INSERT INTO "TEST_TABLE_01" ("INT_FIELD", "CHAR_FIELD", "VARCHAR_FIELD", "BIGINT_FIELD", "SMALLINT_FIELD", "DOUBLE_FIELD", "NUMERIC_FIELD", "DECIMAL_FIELD", "DATE_FIELD", "TIME_FIELD", "TIMESTAMP_FIELD", "CLOB_FIELD", "BLOB_FIELD", "IARRAY_FIELD", "SARRAY_FIELD", "LARRAY_FIELD", "FARRAY_FIELD", "BARRAY_FIELD", "NARRAY_FIELD", "DARRAY_FIELD", "TARRAY_FIELD", "TSARRAY_FIELD", "CARRAY_FIELD", "VARRAY_FIELD", "BIG_ARRAY") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Thanks to all people that is using, testing and reporting issues about the Firebird .NET Data Provider. As always all comments and suggestions are wellcome. -- Best regards Carlos Guzmán Álvarez Vigo-Spain "Todos somos muy ignorantes. Lo que ocurre es que no todos ignoramos las mismas cosas." Albert Einstein. |
|
From:
<car...@te...> - 2003-10-27 11:53:21
|
Hello: Roadmap ------- * Next version will be Beta 4 after this release rc stage will be started, i have in mind to release at least 3 release candidates before 1.5 final release. Latest CVS changes ------------------ * There are some changes for improve performance of array datatype parameters (Thanks to Jesus for his feedback) and for allow partial updates of array datatype fields. * There are a few change on FbCommand class on blob parameters handling. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2003-11-20 11:03:01
|
Hello: Summary of changes in CVS ------- -- ------- -- --- * Changes to improve handling of query parameters, witch conversions of parameter values will be done only one time. * Changes in the wayof store rows fetched, until beta 4 an arraylist was used for store the rows fetched as result of a select query now an array of objects will be used. * FbConnection, FbCommand, FbCommandBuilder and FbDataAdapter has now better implementations of constructors and constructors ( i thnk ). * There are some changes in the Firebird Events API implementation. * Changes for try to get better charset support ( Thanks to Peter Jacobi and Oleg Ufaev ). * In FbCommand the exception that was raised when a string parameter has incorrect length has been removed, because firebird has an old bug that reports sqllen bad for fields of system tables. * In FbCommand, batch command execution is now restricted to ExecuteReader calls. * FbDataReader.GetSchema method will now return the size in characters for char ad varchar columns. * The Nunit test suite has been reworked for allow database creation in the fly, and the build file will use now NUnit 2.1 for the suite build. * FbCommand has some fixes for correct checkin of command[actualCommand] ( Thanks to Pierre Arnaud ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-01-07 19:26:18
|
Hello: 1.5 Sources: The only changes done here since RC2 release are back ported from 1.6 sources and are related to FbParameter and FbParameterCollection classes. - Added changes for better handling of parameter collections (checked against SqlClient provider): -Throw an exception when trying to add a parameter to a FbParameterCollection instance that is already owned by a different FbParameterCollection instance. -Generate a new parameter name when the parameter to add has no name. -Throw an exception when trying to add a parameter two times to the same collection. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-03-27 15:07:33
|
Hello: People that is using 1.6 sources from CVS will need to update their sources, i have committed today my latest CVS changes, their includes: * Some fixes for the FbCommand and FbCommandBuilder classes. * The implementation of ISerializable.GetObjectData in FbException class. * The initial implementation (not in use yet) for allow auto-generation of parameter descriptors (without make calls to isc_dsql_describe_bind implementation method) * Some other minor changes. I will try to release the 1.6 Beta 1 in one or two days. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-04-23 12:08:37
|
Hello:
* I have committed yesterday some changes (important in my opinion)
to the FbCommand.Connection and FbCommand.Transaction properties,
the SqlCommand.Connection .NET documentation says:
"If you set *Connection* while a transaction is in progress and the
Transaction <frlrfsystemdatasqlclientsqlcommandclasstransactiontopic.htm>
property is not null, an InvalidOperationException
<frlrfsysteminvalidoperationexceptionclasstopic.htm> is generated."
This is in both .NET Framework 1.0 and 1.1. documentation, but after
some tests
with SqlClient against MSDE 2000 Release A that seems to be untrue, i
have removed
that check and the exception than was raised.
* Today i have committed some changes for try to improve the DataReader
implementation:
- Make it more readable and easy to maintain.
- Changed open field by isClosed.
- Changed constructor parameters.
- Improved exception handling, now it's more close to SqlClient,
the sample used for test it, in SqlClient, was:
string sql = "SELECT * FROM Customers";
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
SqlDataReader reader = command.ExecuteReader();
while(reader.Read())
{
}
// Add calls to reader methods ere
reader.Close();
// Add calls to reader methods ere
connection.Close();
* I have started to work in the Borland Data Provider too, now than i have
installed the Delphi .NET trial and i can do some tests with it, but there
are no so much code done yet.
This was going to be implemented in a first time by Abel Eduardo Pereira
but
he seems to be busy (Abel Eduardo if you read this, please, contact me,
i have sent to you an email to your sourceforge account, because i have lost
my Address book and doesn't have your real email now :P)
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From:
<car...@te...> - 2004-04-24 11:54:41
|
Hello:
I'm doing an internal rework of data types and field/parameter values,
it's unfinished, until i finsh them CVS maybe unstable :) (the first block
of changes i have committed builds but i haven't tested them yet ;)).
I have added a CVS TAG to the sources befor teh commit:
NP_1_6_BETA3
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From:
<car...@te...> - 2004-05-02 14:17:16
|
Hello: I will try to release 1.6 Beta 3 by the middle of the next week, the changes will be mostly internal and some bug fixes. I will try to this next week to finish the implementation of some classes of the Borland Data Provider implementation, just curious :D , how much people here is using Delphi .NET with Firebird ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Greg P. <ma...@cw...> - 2004-05-02 17:28:59
|
You asked: "how much people here is using Delphi .NET with Firebird ??" I'm one. -- Greg Peterson |
|
From:
<car...@te...> - 2004-06-22 10:43:06
|
Hello: If all goes well the RC 2 should be the latest RC before the v1.6 final. The initial sources for the 1.7 are yet in the CVS, changes are mainly in internal cleanup and a reimplementation of the firebird events system, done only in the GDS implementation that implements the wire protocol (Thanks very much to Dmitry Yemanov for all his help and patience :)). 1.7 contains to documentation about the Firebird wire protocol. On the Borland Data Provider side i hope to release the Alpha 2 after the v1.6 final, it will be based on the 1.7 GDS implementations. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X