Synaptica srl http://www.synaptica.info Thu, 11 Mar 2010 20:22:29 +0000 http://wordpress.org/?v=2.7.1 en hourly 1 Ubuntu 9.10 and iNvidia drivers for dual monitor http://www.synaptica.info/2010/03/11/ubuntu-910-and-invidia-drivers-for-dual-monitor/langswitch_lang/en/ http://www.synaptica.info/2010/03/11/ubuntu-910-and-invidia-drivers-for-dual-monitor/langswitch_lang/en/#comments Thu, 11 Mar 2010 12:35:03 +0000 ivan http://www.synaptica.info/?p=902&langswitch_lang=it This morning i got a problem configuring my dual monitor on my ubuntu 9.10… after had enabled the propetary driver from invidia when i try to write the xorg.conf i got an error from the interface of that driver like : can’t parse the /etc/X11/xorg.conf.

So i opened my shell and i do that [...]]]> This morning i got a problem configuring my dual monitor on my ubuntu 9.10… after had enabled the propetary driver from invidia when i try to write the xorg.conf i got an error from the interface of that driver like : can’t parse the /etc/X11/xorg.conf.

So i opened my shell and i do that on my risks .

1) backuped the original xorg.conf (that function well with a single monitor) lik :

  1.  
  2.    sudo cp /etc/X11/xorg.conf /etc/X11/xorg.conf.backup
  3.  

2) i deleted the original xorg.conf

  1.  
  2.   $ cd /etc/X11
  3.   $ sudo rm xorg.conf
  4.  

3) i run the nvidia setting with sudo like :

  1.  
  2.   $ sudo nvidia-settings
  3.  

4) after this i saved the xorg.conf with the nvidia configuration tool :

nvidia

5) before restart i checked if the xorg.conf exits and i watched what was happend :

  1.  
  2. $ more xorg.conf
  3.  
  4. Section "ServerLayout"
  5.     Identifier     "Layout0"
  6.     Screen      0  "Screen0" 1680 0
  7.     Screen      1  "Screen1" LeftOf "Screen0"
  8.     InputDevice    "Keyboard0" "CoreKeyboard"
  9.     InputDevice    "Mouse0" "CorePointer"
  10. EndSection
  11.  
  12. Section "Files"
  13. EndSection
  14.  
  15. Section "Module"
  16.     Load           "dbe"
  17.     Load           "extmod"
  18.     Load           "type1"
  19.     Load           "freetype"
  20.     Load           "glx"
  21. EndSection
  22.  
  23. Section "ServerFlags"
  24.     Option         "Xinerama" "0"
  25. EndSection
  26.  
  27. Section "InputDevice"
  28.     # generated from default
  29.     Identifier     "Mouse0"
  30.     Driver         "mouse"
  31.     Option         "Protocol" "auto"
  32.     Option         "Device" "/dev/psaux"
  33.     Option         "Emulate3Buttons" "no"
  34.     Option         "ZAxisMapping" "4 5"
  35. EndSection
  36.  
  37. Section "InputDevice"
  38.     # generated from default
  39.     Identifier     "Keyboard0"
  40.     Driver         "kbd"
  41. EndSection
  42.  
  43. Section "Monitor"
  44.     # HorizSync source: edid, VertRefresh source: edid
  45.     Identifier     "Monitor0"
  46.     VendorName     "Unknown"
  47.     ModelName      "NEC LCD2170NX"
  48.     HorizSync       31.0 - 92.0
  49.     VertRefresh     56.0 - 85.0
  50.     Option         "DPMS"
  51. EndSection
  52.  
  53. Section "Monitor"
  54.     # HorizSync source: edid, VertRefresh source: edid
  55.     Identifier     "Monitor1"
  56.     VendorName     "Unknown"
  57.     ModelName      "ACI ASUS VK221"
  58.     HorizSync       30.0 - 85.0
  59.     VertRefresh     55.0 - 75.0
  60.     Option         "DPMS"
  61. EndSection
  62.  
  63. Section "Device"
  64.     Identifier     "Device0"
  65.     Driver         "nvidia"
  66.     VendorName     "NVIDIA Corporation"
  67.     BoardName      "GeForce 9500 GT"
  68.     BusID          "PCI:1:0:0"
  69.     Screen          0
  70. EndSection
  71.  
  72. Section "Device"
  73.     Identifier     "Device1"
  74.     Driver         "nvidia"
  75.     VendorName     "NVIDIA Corporation"
  76.     BoardName      "GeForce 9500 GT"
  77.     BusID          "PCI:1:0:0"
  78.     Screen          1
  79. EndSection
  80.  
  81. Section "Screen"
  82.     Identifier     "Screen0"
  83.     Device         "Device0"
  84.     Monitor        "Monitor0"
  85.     DefaultDepth    24
  86.     Option         "TwinView" "0"
  87.     Option         "metamodes" "DFP: nvidia-auto-select +0+0"
  88.     SubSection     "Display"
  89.         Depth       24
  90.     EndSubSection
  91. EndSection
  92.  
  93. Section "Screen"
  94.     Identifier     "Screen1"
  95.     Device         "Device1"
  96.     Monitor        "Monitor1"
  97.     DefaultDepth    24
  98.     Option         "TwinView" "0"
  99.     Option         "metamodes" "CRT: nvidia-auto-select +0+0"
  100.     SubSection     "Display"
  101.         Depth       24
  102.     EndSubSection
  103. EndSection
  104.  
  105.  

and i restarded the system and all function well….

bst rgds
i

]]> http://www.synaptica.info/2010/03/11/ubuntu-910-and-invidia-drivers-for-dual-monitor/feed/langswitch_lang/en/ Oracle Tips #6 [Metadata Info X] http://www.synaptica.info/2010/03/10/oracle-tips-6-metadata-info-x/langswitch_lang/en/ http://www.synaptica.info/2010/03/10/oracle-tips-6-metadata-info-x/langswitch_lang/en/#comments Wed, 10 Mar 2010 18:06:21 +0000 ivan http://www.synaptica.info/?p=897&langswitch_lang=it In Oracle ,to get some ddl information and source you can call system tables like user_objects. So with a particular function called DBMS_METADATA.GET_DDL you can have the entire source of an object passing two parameter : first: the object type and the second parameter is the name of the object that you want to know [...]]]> In Oracle ,to get some ddl information and source you can call system tables like user_objects. So with a particular function called DBMS_METADATA.GET_DDL you can have the entire source of an object passing two parameter : first: the object type and the second parameter is the name of the object that you want to know the ddl definition.

I the next example i’ll get all ddl about all trigger in my schema :

  1.  
  2.    
  3.  
  4.  SELECT
  5.    U.OBJECT_NAME,U.STATUS ,DBMS_METADATA.GET_DDL(U.object_type,u.object_name)
  6.  FROM
  7.    user_objects u
  8.  WHERE
  9.    object_type = ‘TRIGGER’;
  10.    
  11.    
  12.    
  13.    
  14. SELECT object_type, COUNT(*) FROM USER_OBJECTS
  15. GROUP BY OBJECT_TYPE
  16.  
  17.  
  18.  

so you can also access to metadata api to export full schema , by creating a table and a procedure you can have full schema inside the new table. I took the example from http://www.di.unipi.it the code :

creating table:

  1. .
  2.   CREATE TABLE my_metadata (md CLOB);
  3.  
  1.  
  2. – Create a table to store the retrieved objects.
  3. CONNECT scott/tiger
  4. DROP TABLE my_metadata;
  5. CREATE TABLE my_metadata (md CLOB);
  6. CREATE OR REPLACE PROCEDURE get_schema_md IS
  7.  
  8. – Define local variables.
  9. h       NUMBER;         – handle returned by OPEN
  10. th      NUMBER;         – handle returned by ADD_TRANSFORM
  11. doc     CLOB;           – metadata is returned in a CLOB
  12. BEGIN
  13.  
  14. – Specify the object type.
  15.  h := DBMS_METADATA.OPEN(‘SCHEMA_EXPORT’);
  16.  
  17.  – Use filters to specify the schema.
  18.  DBMS_METADATA.SET_FILTER(h,‘SCHEMA’,‘<### YOUR SCHEMA NAME ####>’);
  19.  
  20.  – Request that the metadata be transformed into creation DDL.
  21.  th := DBMS_METADATA.ADD_TRANSFORM(h,‘DDL’);
  22.  
  23.  – Fetch the objects.
  24.  LOOP
  25.    doc := DBMS_METADATA.FETCH_CLOB(h);
  26.  
  27.    – When there are no more objects to be retrieved, FETCH_CLOB returns NULL.
  28.    EXIT WHEN doc IS NULL;
  29.  
  30.    – Store the metadata in the table.
  31.    INSERT INTO my_metadata(md) VALUES (doc);
  32.    COMMIT;
  33.  END LOOP;
  34.  
  35.  – Release resources.
  36.  DBMS_METADATA.CLOSE(h);
  37. END;
  38. /
  39.  
  40.  

you only need to replace <### YOUR SCHEMA NAME ####> with your real schema name or add a parameter to your procedure.

after your can call from a sql interface like

  1. .
  2.   exec get_schema_md;
  3.  

now inside your table “my_metadata” there is all your db schema.

rgds
i

]]> http://www.synaptica.info/2010/03/10/oracle-tips-6-metadata-info-x/feed/langswitch_lang/en/ Oracle Tips #5 [Exception on the fly] http://www.synaptica.info/2010/03/10/oracle-tips-5-exception-on-the-fly/langswitch_lang/en/ http://www.synaptica.info/2010/03/10/oracle-tips-5-exception-on-the-fly/langswitch_lang/en/#comments Wed, 10 Mar 2010 17:07:09 +0000 ivan http://www.synaptica.info/?p=891&langswitch_lang=it to raise an Exception from a Trigger, Stored Procedure or Function without needing enithing you can use the function : raise_application_error.

Syntax : raise_application_error(<your excpetion integer code>, <your string description>);

]]> to raise an Exception from a Trigger, Stored Procedure or Function without needing enithing you can use the function : raise_application_error.

Syntax : raise_application_error(<your excpetion integer code>, <your string description>);

]]> http://www.synaptica.info/2010/03/10/oracle-tips-5-exception-on-the-fly/feed/langswitch_lang/en/ ClipArt & Icons for All http://www.synaptica.info/2010/03/10/clipart-icons-for-all/langswitch_lang/en/ http://www.synaptica.info/2010/03/10/clipart-icons-for-all/langswitch_lang/en/#comments Wed, 10 Mar 2010 15:33:19 +0000 ivan http://www.synaptica.info/?p=886&langswitch_lang=it

http://www.openclipart.org , non lo conoscevo e ne sono rimasto veramente impressionato, è un archivio di ClipArt in fomrato vettoriale SVG enorme, qualsiasi cosa ho scritto nella ricerca mi son trovato l’immagine corrispondente. Come direbbe il signor Burns dei Simpons “Eccellente”. Ogni immagine selezionata è disponibile per il download in [...]]]> clipart

http://www.openclipart.org , non lo conoscevo e ne sono rimasto veramente impressionato, è un archivio di ClipArt in fomrato vettoriale SVG enorme, qualsiasi cosa ho scritto nella ricerca mi son trovato l’immagine corrispondente. Come direbbe il signor Burns dei Simpons “Eccellente”. Ogni immagine selezionata è disponibile per il download in formato sia svg che png.

Ogni immagine è sotto la copertura delle Creative Commons, quindi in teoria l’uso commerciale è consentito a patto che se ne citi la fonte, il che mi sembra veramente un requisito minimo. Se penso al tempo che ho buttato creandomi delle immagini oscene per le mie presentazioni - siti e applicazioni ad un sito così mi sarei felicemente abbonato.

a presto

ivan

]]> http://www.synaptica.info/2010/03/10/clipart-icons-for-all/feed/langswitch_lang/en/ Oracle Tips #4 [Trigger : Mutating Tables & Autonomos Transactions] http://www.synaptica.info/2010/03/08/oracle-tips-4-trigger-mutating-tables-autonomos-transactions/langswitch_lang/en/ http://www.synaptica.info/2010/03/08/oracle-tips-4-trigger-mutating-tables-autonomos-transactions/langswitch_lang/en/#comments Mon, 08 Mar 2010 16:47:44 +0000 ivan http://www.synaptica.info/?p=878&langswitch_lang=it Oracle Version : 10g

As you know inside a Oracle row trigger you cannot access to the base table, for example when you make a trigger like this, on a table named “activity“.

  CREATE OR REPLACE TRIGGER UNAME.ACTIVITY_FK_MENU_INTEGRITY AFTER INSERT OR UPDATE ON UNAME.ACTIVITY REFERENCING NEW AS New OLD AS Old FOR EACH ROW DECLARE   tmpVar NUMBER; e_Menu_Already_Exists EXCEPTION;   BEGIN           [...]]]> Oracle Version : 10g

As you know inside a Oracle row trigger you cannot access to the base table, for example when you make a trigger like this, on a table named “activity“.

  1.  
  2. CREATE OR REPLACE TRIGGER UNAME.ACTIVITY_FK_MENU_INTEGRITY
  3. AFTER INSERT OR UPDATE
  4. ON UNAME.ACTIVITY
  5. REFERENCING NEW AS New OLD AS Old
  6. FOR EACH ROW
  7. DECLARE
  8.  
  9. tmpVar NUMBER;
  10. e_Menu_Already_Exists EXCEPTION;
  11.  
  12. BEGIN
  13.            SELECT count(*) INTO tmpVar FROM Activity aa WHERE (aa.fk_menu = :new.fk_menu)AND(aa.pk_id <> :new.pk_id);
  14.            
  15.            
  16.           – if (tmpVar > 0) then
  17.              –:New.FK_MENU := null;
  18.                 – raise e_Menu_Already_Exists;
  19.           – end if;
  20.            
  21. END ACTIVITY_FK_MENU_INTEGRITY;
  22.  

when you try to use the table making an update happen this :

toaderror

To avoid this error and obviusly assuming the risk about ricorsive trigger, you can define a custom transaction for your trigger, so you can access to data inside the mutating table. To do this you need to declare “PRAGMA AUTONOMOUS_TRANSACTION;” means that the trigger give a specific transaction. So now you need to specify an explicit “commit;” at the end of the trigger.

The example will result like:

  1.  
  2. CREATE OR REPLACE TRIGGER UNAME.ACTIVITY_FK_MENU_INTEGRITY
  3. AFTER INSERT OR UPDATE
  4. ON UNAME.ACTIVITY
  5. REFERENCING NEW AS New OLD AS Old
  6. FOR EACH ROW
  7. DECLARE
  8. PRAGMA AUTONOMOUS_TRANSACTION;
  9. tmpVar NUMBER;
  10. e_Menu_Already_Exists EXCEPTION;
  11.  
  12. BEGIN
  13.            SELECT count(*) INTO tmpVar FROM Activity aa WHERE (aa.fk_menu = :new.fk_menu)AND(aa.pk_id <> :new.pk_id);
  14.            
  15.            commit;  
  16.            
  17. END ACTIVITY_FK_MENU_INTEGRITY;
  18.  

that’s all until next tip
bye
ivan

]]> http://www.synaptica.info/2010/03/08/oracle-tips-4-trigger-mutating-tables-autonomos-transactions/feed/langswitch_lang/en/ Sync two directories with rsync and ssh through the internet http://www.synaptica.info/2010/02/26/sync-two-directories-with-rsync-and-ssh-through-the-internet/langswitch_lang/en/ http://www.synaptica.info/2010/02/26/sync-two-directories-with-rsync-and-ssh-through-the-internet/langswitch_lang/en/#comments Fri, 26 Feb 2010 10:34:31 +0000 Riccardo http://www.synaptica.info/?p=854&langswitch_lang=it Hello,

we want to sync two directories in two different server that are connected to the internet. We want to use ssh as channel protocol because we already have the firewall rules to connect and because it is encrypted. First of all we need that machine A will connect to machine B without password asking, this can [...]]]> view-refresh2Hello,

we want to sync two directories in two different server that are connected to the internet. We want to use ssh as channel protocol because we already have the firewall rules to connect and because it is encrypted.
First of all we need that machine A will connect to machine B without password asking, this can be achieved by generating public key from machine A and copy it to machine B. Here are the commands:
generate the key from machine A.

  1. ssh-keygen -t rsa

the public key will be created in /home/[user]/.ssh/id_rsa.pub
then we copy it to the machine B

  1. scp /home/[user]/.ssh/id_rsa.pub [user]@[machine-B]

now we have to append the contents of the file id_rsa.pub in ./ssh/authorized_keys

  1. cat id_rsa.pub >>~/.ssh/authorized_keys

Now we can connect with ssh from machine A to machine B without password asking.
Now we use rsync from machine A to sync the directories.

  1. rsync -zave ssh –numeric-ids –recursive –delete [user]@[machine-B]:/dir1 /dir2

After this command we found /dir2/dir1 on machine A, backupped and synced. Put the commands in cron to have sync over time.

We can now sleep peacefully. :)

]]> http://www.synaptica.info/2010/02/26/sync-two-directories-with-rsync-and-ssh-through-the-internet/feed/langswitch_lang/en/ FOSS [ Free and Open Source Software ] http://www.synaptica.info/2010/02/25/foss-free-and-open-source-software/langswitch_lang/en/ http://www.synaptica.info/2010/02/25/foss-free-and-open-source-software/langswitch_lang/en/#comments Thu, 25 Feb 2010 15:21:14 +0000 ivan http://www.synaptica.info/?p=851&langswitch_lang=it L’inversione di tendenza ? ma speriamo di no, che l’Open Source abbia permesso a milioni di società e di individui singoli di poter accedere ,e dare il proprio contributo ,a Software prima inarrivabili è ormai noto. Era normale aspettarsi che tutti coloro che giustamente vivono sulle licenze dei “loro” software non vedano di buon occhio [...]]]> L’inversione di tendenza ? ma speriamo di no, che l’Open Source abbia permesso a milioni di società e di individui singoli di poter accedere ,e dare il proprio contributo ,a Software prima inarrivabili è ormai noto. Era normale aspettarsi che tutti coloro che giustamente vivono sulle licenze dei “loro” software non vedano di buon occhio questa nuova filosofia, che a detta di molti non è una cosa che va contro le regole del mercato.
In questo senso non mi esprimo, ma credo che fino ad oggi la bilancia dei vantaggi e svantaggi di questa nuova filosofia di cooperazione penda fortemente dalla parte dei vantaggi.
Ulitmamente mi capita di leggere cose che mi lasciano un po sconcertato, una di queste fù l’articolo pubblicato da Riccardo che ad una riunione presso un grosso cliente sentì dire la frase “l’open source è illegale”.
Oggi leggendo ,come di mio consueto, il blog http://www.ossblog.it , che è un blog a mio avviso molto “fico” e attendibile mi ritrovo quest’articolo : “Usate software FOSS? Allora siete dei pirati!“.
C’era da aspettarselo? boh non credo comunque sia non sta a me decidere, penso che in tutte le cose ci voglia moderazione e in questo caso son andati un po oltre, creando anche una lista nera di paesi additati per questo.

a presto
ivan

]]> http://www.synaptica.info/2010/02/25/foss-free-and-open-source-software/feed/langswitch_lang/en/ Oracle Tips #3 [Extract Metadata Info ] http://www.synaptica.info/2010/02/19/oracle-tips-3-extract-metadata-info/langswitch_lang/en/ http://www.synaptica.info/2010/02/19/oracle-tips-3-extract-metadata-info/langswitch_lang/en/#comments Fri, 19 Feb 2010 17:11:45 +0000 ivan http://www.synaptica.info/?p=844&langswitch_lang=it by using some simple view in Oracle you can extract a lot of information about your DB schema, some explicit samples :

(assuming that MyDBOwner is the owner of the DB and ACTIVITY is a table of a schema, this sample is succesfully tested on Oracle 10g)

  – LIST OF USERS   SELECT OWNER,COUNT(DISTINCT TABLE_NAME) FROM ALL_TAB_COLUMNS [...]]]> by using some simple view in Oracle you can extract a lot of information about your DB schema, some explicit samples :

(assuming that MyDBOwner is the owner of the DB and ACTIVITY is a table of a schema, this sample is succesfully tested on Oracle 10g)

  1.  
  2. – LIST OF USERS
  3.  
  4. SELECT OWNER,COUNT(DISTINCT TABLE_NAME) FROM ALL_TAB_COLUMNS GROUP BY OWNER
  5.  
  6.  
  7. – LIST OF TABLES PER OWNER
  8.  
  9. SELECT table_name FROM ALL_TAB_COLUMNS  WHERE owner = ‘MyDBOwner’ GROUP BY table_name
  10.  
  11. – LIST OF FIELDS PER TABLE
  12.  
  13. SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE, CHAR_LENGTH FROM ALL_TAB_COLUMNS  WHERE owner = ‘MyDBOwner’ AND TABLE_NAME = ‘ACTIVITY’
  14.  
  15. – FINDING PRIMARY KEYS
  16.  
  17. SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE, CHAR_LENGTH FROM ALL_TAB_COLUMNS  WHERE owner = ‘MyDBOwner’ AND TABLE_NAME = ‘ACTIVITY’
  18.  
  19.  
  20. – A single character that indicates the type of constraint: ‘C’ = NOT NULL, ‘P’ = PRIMARY KEY, ‘U’ = UNIQUE, and ‘R’ = FOREIGN KEY.
  21.  
  22.  
  23. SELECT UC.CONSTRAINT_NAME, UCC.* FROM USER_CONSTRAINTS UC, USER_CONS_COLUMNS UCC WHERE UC.OWNER=‘MyDBOwner’ AND UC.TABLE_NAME = ‘ACTIVITY’ AND UC.CONSTRAINT_TYPE = ‘P’ AND UC.CONSTRAINT_NAME = UCC.CONSTRAINT_NAME
  24.        
  25.  
  26.  
  27.  

a great article about this is : http://college.yukondude.com/2002_09_comp210/html/note-container.php?file=10^Handout^Oracle_Metadata and on wiki too at this address http://en.wikipedia.org/wiki/Oracle_metadata#Example_2:_finding_columns

bye ivan

]]> http://www.synaptica.info/2010/02/19/oracle-tips-3-extract-metadata-info/feed/langswitch_lang/en/ Java to Delphi througth Midas and ClientDataSet http://www.synaptica.info/2010/02/17/java-to-delphi-througth-midas-and-clientdataset/langswitch_lang/en/ http://www.synaptica.info/2010/02/17/java-to-delphi-througth-midas-and-clientdataset/langswitch_lang/en/#comments Wed, 17 Feb 2010 19:50:35 +0000 ivan http://www.synaptica.info/?p=841&langswitch_lang=it (This article is a draft but if something is of interesting …. )

The fantastic world of old Midas now called DataSnap introduced the TClientDataSet component , that is a in memory DataSet for Delphi and C++ Builder. With TClientDataSet was introduced the concept of Brief Case model Application Style. A brief case [...]]]> (This article is a draft but if something is of interesting …. )

The fantastic world of old Midas now called DataSnap introduced the TClientDataSet component , that is a in memory DataSet for Delphi and C++ Builder. With TClientDataSet was introduced the concept of Brief Case model Application Style.
A brief case model App. is the best concept application that exchnage data between server when and where there is a connection. Now TClientDataSet have two type of rapresenting the in memory data, one binary and one in a static xml format that is well explained in this article on Embarcadero site : http://edn.embarcadero.com/article/10405.
Using Java , the world of JDBC and ,of course, Tomcat we are trying to provide data to a client dataset via some Servlet and update data parsing the Delta sended by our TclientDataSet. So that we can connect to Oracle for example without usinig direct connection or driver.
We also found a similar project done with pHp posted on the Zend site at this url : http://www.zend.com//code/codex.php?ozid=1049&single=1.
Soon we will post all about that.

stay tuned
bye ivan

]]> http://www.synaptica.info/2010/02/17/java-to-delphi-througth-midas-and-clientdataset/feed/langswitch_lang/en/ Happy birday Delphi … http://www.synaptica.info/2010/02/15/happy-birday-delphi/langswitch_lang/en/ http://www.synaptica.info/2010/02/15/happy-birday-delphi/langswitch_lang/en/#comments Mon, 15 Feb 2010 16:49:52 +0000 ivan http://www.synaptica.info/?p=832&langswitch_lang=it

Delphi was born exactly fifteen years ago from Today, Marco Cantu on his web site have posted a great article on this because he is one of the first guru of this beatifull dev language… the article

]]> safe_imagephp

Delphi was born exactly fifteen years ago from Today, Marco Cantu on his web site have posted a great article on this because he is one of the first guru of this beatifull dev language… the article

]]> http://www.synaptica.info/2010/02/15/happy-birday-delphi/feed/langswitch_lang/en/