Menu
▾
▴
[Firebird-net-provider] Query regarding OCTET_LENGTH()
|
From: Kixzo D. T. <ki...@4c...> - 2008-04-29 07:29:15
|
Hello, I have one query regarding OCTET_LENGTH() function. As per my requirement, I am having a bunch of files those are going to store into Firebird 2.0 from my application. And while retrieving them from database, I want to display their size. As far as performance reason is concerned, I want to know that OCTET_LENGTH() 's working manner. So that I decide that which option is more helpful for my application... 1. Store file size while storing the file content. 2. Calculate file size while retrieving the file from database. For 2nd option, I am using SELECT query like... SELECT OCTET_LENGTH(blob field) FROM TABLE WHERE ID = 9; Is OCTET_LENGTH() calculates the content size without taking the whole blob field's data in memory? Or is there any other technique used by Firebird. Please explain in brief. Best Regards, Dikshita Paleja. -----Original Message----- From: fir...@li... [mailto:fir...@li...] On Behalf Of fir...@li... Sent: Monday, April 28, 2008 6:37 PM To: fir...@li... Subject: Firebird-net-provider Digest, Vol 24, Issue 17 Send Firebird-net-provider mailing list submissions to fir...@li... To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/firebird-net-provider or, via email, send a message with subject or body 'help' to fir...@li... You can reach the person managing the list at fir...@li... When replying, please edit your Subject line so it is more specific than "Re: Contents of Firebird-net-provider digest..." Today's Topics: 1. [FB-Tracker] Created: (DNET-162) Exception message: "No message for error code .... found" instead of normal error messages (Andre Grohmann (JIRA)) 2. Re: Exception Message - No message forerror code found (Jiri Cincura) 3. Visual Studio 2008 - Add data connection error (Mat Dunning) 4. Re: Visual Studio 2008 - Add data connection error (Jiri Cincura) 5. Re: Visual Studio 2008 - Add data connection (Mat Dunning) 6. Re: Visual Studio 2008 - Add data connection (Jiri Cincura) 7. Re: Your login SYSDBA is same as one of the (Marco) 8. Re: Your login SYSDBA is same as one of the (Marco) 9. Re: Visual Studio 2008 - Add data connection (Mat Dunning) 10. Re: Your login SYSDBA is same as one of the (Jiri Cincura) ---------------------------------------------------------------------- Message: 1 Date: Fri, 25 Apr 2008 03:22:08 -0400 (EDT) From: "Andre Grohmann (JIRA)" <tr...@fi...> Subject: [Firebird-net-provider] [FB-Tracker] Created: (DNET-162) Exception message: "No message for error code .... found" instead of normal error messages To: fir...@li... Message-ID: <20743827.1209108128390.JavaMail.root@Firebird2> Content-Type: text/plain; charset=UTF-8 Exception message: "No message for error code .... found" instead of normal error messages ---------------------------------------------------------------------------- -------------- Key: DNET-162 URL: http://tracker.firebirdsql.org/browse/DNET-162 Project: .NET Data provider Issue Type: Bug Affects Versions: 2.5.0 Alpha 2 Environment: Firebird Superserver 2.1.0.17798 WinXP SP2 Reporter: Andre Grohmann Assignee: Jiri Cincura Priority: Minor There is a Problem with the exception messages in version 2.5.0 (Subversion Revision 559). For Example if the DataSource in the connection string is set to a wrong value / host, the message of the raised exception looks like: "No message for error code 335544721 found" Nearly every exception message I have seen looks like this, respectively with another error code. When using .NET Provider 2.1.0 it works fine. The exception message looks like "Unable to complete network request to host ...". Sample Code: static void Main(string[] args) { FbConnectionStringBuilder csb = new FbConnectionStringBuilder(); csb.DataSource = "localhost"; csb.Dialect = 3; csb.Database = "C:\\temp\\TEST.GDB"; csb.UserID = "SYSDBA"; //wrong password csb.Password = "**********"; FbConnection con = new FbConnection(csb.ToString()); try { con.Open(); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { if (con != null) { con.Close(); } } Console.ReadLine(); } exception message with version 2.1.0 is: Your user name and password are not defined. Ask your database administrator to set up a firebird login. with version 2.5.0: No message for error code 335544472 found. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------ Message: 2 Date: Sat, 26 Apr 2008 10:16:49 +0200 From: "Jiri Cincura" <di...@ci...> Subject: Re: [Firebird-net-provider] Exception Message - No message forerror code found To: "For users and developers of the Firebird .NET providers" <fir...@li...> Message-ID: <d2f...@ma...> Content-Type: text/plain; charset=ISO-8859-1 Hello, I tested it, with same revision of FirebirdClient without problem (see tracker). In fact few weeks ago I've updated resources with error messages to match latest FB servers and I've tested whether everything works and it did. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------ Message: 3 Date: Mon, 28 Apr 2008 10:59:25 +0100 From: Mat Dunning <mdu...@no...> Subject: [Firebird-net-provider] Visual Studio 2008 - Add data connection error To: fir...@li... Message-ID: <fv4cum$8s7$1...@ne...> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Hi, Ive installed the Firebird client ok (FirebirdClient-2.5.0-Alpha2) , and proved via some code that Visual Studio can access and extract via query some data from a firebird table. However, I want to be able to add a data connection via the server explorer (and thereby using the built in data aware components). I've gone through the DDEX install (FirebirdDEXProvider-2.0.2.exe). and In the registry file, FirebirdDDEXProviderPackageLess32.reg, searched and replaced all occurrences of "8.0" with "9.0" and path, and updated the machine.config file. When I come to add a Data connection via the server explorer, I can Select "Firebird data source", and data provider as ".NET Framework Data Provider for Firdbird". After pressing continue, I can set the Connectionstring, which I set to Server=192.168.0.16;User=XXXXXX;Password=XXXXXXX;Database=/db/dp.fdb I can Test the connection which brings up Ok, but as soon as I try and "Ok" from this screen, I get an error "Failure has occured while loading a type" Anybody else hit this ? cheers Mat ------------------------------ Message: 4 Date: Mon, 28 Apr 2008 13:51:36 +0200 From: "Jiri Cincura" <di...@ci...> Subject: Re: [Firebird-net-provider] Visual Studio 2008 - Add data connection error To: "For users and developers of the Firebird .NET providers" <fir...@li...> Message-ID: <d2f...@ma...> Content-Type: text/plain; charset=ISO-8859-1 Check your GAC and machine.config. One of this isn't well setted. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------ Message: 5 Date: Mon, 28 Apr 2008 13:33:59 +0100 From: Mat Dunning <mdu...@no...> Subject: Re: [Firebird-net-provider] Visual Studio 2008 - Add data connection To: fir...@li... Message-ID: <fv4lev$asj$1...@ne...> Content-Type: text/plain; charset=ISO-8859-1; format=flowed is it ok to post (within the message, not as an attachment) my ddex registry file (the one I import) and my machine.config in this newsgroup to if anybody can spot a simple error. I've looked about 5 times but can't see the problem. cheers Mat ------------------------------ Message: 6 Date: Mon, 28 Apr 2008 14:31:40 +0200 From: "Jiri Cincura" <di...@ci...> Subject: Re: [Firebird-net-provider] Visual Studio 2008 - Add data connection To: "For users and developers of the Firebird .NET providers" <fir...@li...> Message-ID: <d2f...@ma...> Content-Type: text/plain; charset=ISO-8859-1 Check this out https://firebird.svn.sourceforge.net/svnroot/firebird/NETProvider/trunk/Data DesignerExtensibility/ReadMe.txt . -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------ Message: 7 Date: Mon, 28 Apr 2008 15:00:47 +0200 From: Marco <mar...@To...> Subject: Re: [Firebird-net-provider] Your login SYSDBA is same as one of the To: fir...@li... Message-ID: <fv4nfb$bat$1...@ne...> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Jiri Cincura ha scritto: > On 4/23/08, Marco <mar...@to...> wrote: >> "Your login SYSDBA is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login." > > This is trick, when you need to block sysdba account. Look at > firebird-support list for more info. > OK, thanks, but can I unlok this block? ------------------------------ Message: 8 Date: Mon, 28 Apr 2008 15:04:05 +0200 From: Marco <mar...@To...> Subject: Re: [Firebird-net-provider] Your login SYSDBA is same as one of the To: fir...@li... Message-ID: <fv4nlg$bat$2...@ne...> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Jiri Cincura ha scritto: > On 4/23/08, Marco <mar...@to...> wrote: >> "Your login SYSDBA is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login." > > This is trick, when you need to block sysdba account. Look at > firebird-support list for more info. > OK, thanks, but can I unlok this block? ------------------------------ Message: 9 Date: Mon, 28 Apr 2008 14:12:51 +0100 From: Mat Dunning <mdu...@no...> Subject: Re: [Firebird-net-provider] Visual Studio 2008 - Add data connection To: fir...@li... Message-ID: <fv4nnr$bek$1...@ne...> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Jiri Cincura wrote: > Check this out https://firebird.svn.sourceforge.net/svnroot/firebird/NETProvider/trunk/Data DesignerExtensibility/ReadMe.txt > . > Thanks for that, but I have already gone through these instructions. I've put the two main files here, if anybody wants to take a look http://www.nextgenconsoles.co.uk/vs/ cheers Mat ------------------------------ Message: 10 Date: Mon, 28 Apr 2008 15:06:43 +0200 From: "Jiri Cincura" <di...@ci...> Subject: Re: [Firebird-net-provider] Your login SYSDBA is same as one of the To: "For users and developers of the Firebird .NET providers" <fir...@li...> Message-ID: <d2f...@ma...> Content-Type: text/plain; charset=ISO-8859-1 On 4/28/08, Marco <mar...@to...> wrote: > OK, thanks, but can I unlok this block? You have to delete this role from account, that created it. This is here completely OT, follow the support list. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------ ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javao ne ------------------------------ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider End of Firebird-net-provider Digest, Vol 24, Issue 17 ***************************************************** |
