[firebird-support] Is it possible to convert binary blob to varchar?
Hi, I tried to convert binary blob field to varchar column in select statement but It did not work. Here is what I did: 1. I created a domain CREATE DOMAIN D_BIGVARCHAR AS VARCHAR(32000) CHARACTER SET OCTETS COLLATE OCTETS; Then when I use this query select cast(JOB_INFO as D_BIGVARCHAR) job_string from JOB_TASKS I expect to receive the value of blob field as varchar in the result set. In my java code I use: rs.getBytes(job_string) to get varchar as byte array. But for some reason where I have non-char values in the byte array I get (dec)46 instead of actual value. My Data source in the java is defined with NONE Encoding. Any ideas what I'm doing wrong? Thanks in advance Doychin Bondzhev
Re: [firebird-support] Re: Speed issues
On Feb 9, 2015, at 11:52 AM, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] firebird-support@yahoogroups.com wrote: What is your cache settings [2048] Zoran's complaint is about the first time the query is executed. In that case, nothing would be in cache and everything would still need to be loaded from disk. A 2048 page cache may be small enough that it would cause problems even during loading, given the size of his database and the tables involved. Having to reload the same pointer pages would exacerbate his problems. Given that the access is indexed, pointer pages and intermediate index pages may need to be loaded several times after they've forced all the metadata pages out. It can't hurt to us a much larger cache. Good luck, Ann
[firebird-support] Database shutdown leaves connections
I'm having problems shutting down a databases on the server. I have followed the instructions in the documentation: http://www.firebirdsql.org/manual/gfix-dbstartstop.html And by using the following command the database seems to be shut down: gfix -user SYSDBA -pas masterkey -shut full -force 0 C:\Database\MyDB.fdb This works to some degree as I can't connect to the database (using DB Workbench), but the shutdown still leaves something hanging as the file is still in use and I can neither move nor rename it. Why isn't this command working properly and what can I do to shut down the database so that I can rename it (in order to restore a backup). This is Firebird 2.1 on a Windows server with the default installation parameters. Sincerely Glenn Thomas Hvidsten Denne epost har blitt kontrollert for virus av Comendo Norge AS This e-mail has been scanned for viruses by http://www.comendo.no
RE: [firebird-support] Re: Speed issues
Ann, Zoran's complaint is about the first time the query is executed. In that case, nothing would be in cache and everything would still need to be loaded from disk. A 2048 page cache may be small enough that it would cause problems even during loading, given the size of his database and the tables involved. Having to reload the same pointer pages would exacerbate his problems. Given that the access is indexed, pointer pages and intermediate index pages may need to be loaded several times after they've forced all the metadata pages out. In the latest stats (post 8KB page restore) there are only 248 pages being read from disk, so that would fit into the cache without issues, no? It can't hurt to us a much larger cache. Bigger is always better (except when it comes to male anatomy ;-o) Sean
SV: [firebird-support] Re: Database shutdown leaves connections
And by using the following command the database seems to be shut down: gfix -user SYSDBA -pas masterkey -shut full -force 0 C:\Database\MyDB.fdb Why isn’t this command working properly and what can I do to shut down the database so that I can rename it (in order to restore a backup). Prior ro v2.5, database shutdown is not expected to unlock the database at the filesystem level. It just interrupts any activity but user sessions may remain connected. Any tips on what I can do instead of this command, like SQL or other commands, to ensure the database is shut down so that I can move/rename the database file? I know I can shut everything down by stopping the Windows service, but I'd rather not do that to the other databases running. Glenn Thomas Hvidsten Denne epost har blitt kontrollert for virus av Comendo Norge AS This e-mail has been scanned for viruses by http://www.comendo.no ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
