Sun logo      �W�@��      �ؿ�      �U�@��     

Sun Java System Application Server Enterprise Edition 8.1 �޲z��n 2005Q1

�� 6 ��
JDBC �귽

��������p��t�m�s���Ʈw��3�ε{���ҭn�D�ϥΪ� JDBC �귽�C���]�t�H�U�p�`�G


��� JDBC �귽

JDBC �귽

���F�x�s�B��´�M�^���ơA�j�h��3�ε{�����ϥ����p����Ʈw�CJ2EE 3�ε{���z�L JDBC API �s�����p����Ʈw�C

JDBC �귽 (��Ʒ�) ��3�ε{�����ѤF�s�u�ܸ�Ʈw����k�C�q�`�A�޲z��n�����p�b��줤��3�ε{���s��C�Ӹ�Ʈw�إ� JDBC �귽�C(��O�A�i�H���@�Ӹ�Ʈw�إߦh�� JDBC �귽�C)

�Y�n�إ� JDBC �귽�A�Ы�w�ѧO�귽���ߤ@ JNDI �W�١C(�аѾ\�uJNDI �W�٩M�귽�v�@�`�C)JDBC �귽�� JNDI �W��3�b java:comp/env/jdbc �l��Ҥ��C�Ҧp�A�~��b���Ʈw�귽�� JNDI �W�٥i�H�� java:comp/env/jdbc/payrolldb�C�ѩ�Ҧ��귽 JNDI �W�٦�� java:comp/env �l��Ҥ��A�]���b�޲z�D���x����w JDBC �귽�� JNDI �W�ٮɶȻݿ�J jdbc/name�C�Ҧp�A����~��b���Ʈw�A�i�H��w jdbc/payrolldb�C

JDBC �s�u��

�Y�n�إ� JDBC �귽�A�Ы�w�P�����p���s�u�!C�h�� JDBC �귽�i��w��@�s�u�!C

JDBC �s�u�,O�w��S�w��Ʈw���@�եi���ƨϥΪ��s�u�C�ѩ�C�إߤ@�ӷs������s�u���|�ӶO�ɶ��A�]����A�����@�F�i�γs�u�%H�����į�C��3�ε{���ШD�s�u�ɡA���i�H�q�$���o�@�ӳs�u�C3�ε{����s�u�ɡA�s�u�N�Ǧ^�$��C

�s�u�*��S�ʥi��|�H��Ʈw��3�Ӫ����P�Ӧ��Ҥ��P�C���@�ǯS�ʬO�q�Ϊ��A�Ҧp��Ʈw�W�� (URL)�B�ϥΪ̦W�٩M�K�X�C

JDBC �귽�M�s�u�&p���P�u�@

���F�x�s�B��´�M�^���ơA�j�h��3�ε{�����ϥ����p����Ʈw�CJ2EE 3�ε{���z�L JDBC API �s�����p����Ʈw�C3�ε{���s���Ʈw���e�A�������o�s�u�C

�H�U�O�b��涥�q3�ε{���s�u�ܸ�Ʈw�ɩҵo�ͪ����p�G

  1. 3�ε{���z�L JNDI API �i��I�s�H���P��Ʈw���p�� JDBC �귽 (��Ʒ�)�C
  2. �p�G���w�F�귽�� JNDI �W�١A�R�W�M�ؿ�A�ȱN�d�� JDBC �귽�C�C�� JDBC �귽��w�@�ӳs�u�!C

  3. �z�L JDBC �귽�A3�ε{����o�@�Ӹ�Ʈw�s�u�C
  4. 3�ε{����A�����K�a�q�P�Ӹ�Ʈw�۹�3���s�u�$��^�����s�u�C�)w�q��Ʈw�W�� (URL)�B�ϥΪ̦W�٩M�K�X���s�u�ݩʡC

  5. �ѩ�w�N3�ε{���s�u�ܸ�Ʈw�A�]����3�ε{���i�HŪ��M�ק��Ʈw������ƥH�αN��Ʒs�W���Ʈw���C
  6. 3�ε{���z�L�� JDBC API �i��I�s�Ӧs���Ʈw�CJDBC �X�ʵ{���N3�ε{���� JDBC �I�s½Ķ����Ʈw��A������w�C

  7. �s���Ʈw��������A3�ε{���N��ӳs�u�C
  8. 3�ε{����A���N�s�u�Ǧ^�s�u�!C�s�u�Ǧ^�s�u�$���A�U�@��3�ε{���N�i�H�ϥθӳs�u�C


�]�w��Ʈw�s��

�]�w��Ʈw�s��@��B�J

  1. �w�ˤ䴩����Ʈw���~�C�p�ݦ��� Application Server �䴩����Ʈw���~���M��A�аѾ\�u��h��T�v�@�`����V�u��������v���s���C
  2. �w�˾A�Ω�Ӹ�Ʈw���~�� JDBC �X�ʵ{���C
  3. �Ϻ�쪺��A����ҥi�H�s���X�ʵ{���� JAR �ɮסC�аѾ\�u��X JDBC �X�ʵ{���v�C
  4. �إ߸�Ʈw�C�q�`�A3�ε{����3�{�����ѤF�Ω�إߩM��J��Ʈw���{���ɡC
  5. ����Ʈw�إ߳s�u�!C�аѾ\�u�إ� JDBC �s�u���v�C
  6. �إ߫�V�s�u�*� JDBC �귽�C�аѾ\�u�إ� JDBC �귽�v�C

��X JDBC �X�ʵ{��

JDBC �X�ʵ{���N3�ε{���� JDBC �I�s½Ķ����Ʈw��A������w�C�Y�n�N JDBC �X�ʵ{����X��޲z��줤�A�а��H�U�ާ@���@�G


��� JDBC �s�u��

�إ� JDBC �s�u��

JDBC �s�u�,O�w��S�w��Ʈw���@�եi���ƨϥΪ��s�u�C�ϥκ޲z�D���x�إߦ.ɡA�޲z���ڤW�O�b�w�q�P�S�w��Ʈw���s�u���U�Ӥ譱�C

�إߦ$��e�A�z��������w�˨þ�X JDBC �X�ʵ{���C

�ظm [�إ߳s�u��] �����ɡA������J�S�w�� JDBC �X�ʵ{���M��Ʈw��3�Ӫ��S�w��ơC�~��ާ@���e�A�Х�H�U��T�G

�Y�n�إ� JDBC �s�u�!A�а��H�U�B�J�G

  1. �b��Τ��󤤡A�i�} [�귽] �`�I�C
  2. �b [�귽] �`�I�U�A�i�} [JDBC] �`�I�C
  3. �b [JDBC] �`�I�U�A��� [�s�u��] �`�I�C
  4. �b [�s�u��] �������A��@�U [�s��]�C
  5. �b [�إ߳s�u��] ���Ĥ@�ӭ������A��w�H�U�@��]�w�G
    1. �b [�W��] ��줤�A��J�*��޿�W�١C
    2. �إ� JDBC �귽�ɱN��w���W�١C

    3. �q [�귽����] �զX�����@�Ӷ��ءC
    4. �q [��Ʈw��3��] �զX�����@�Ӷ��ءC
  6. ��@�U [�U�@�B]�C
  7. �b [�إ߳s�u��] ���ĤG�ӭ������A�� [DataSource ���O�W��] ����w�ȡC
  8. �p�G JDBC �X�ʵ{���㦳�P�b�W�@������w���귽�����M��Ʈw��3�Ӭ�3�� DataSource ���O�A�h�t�η|���� [DataSource ���O�W��] ��쪺�ȡC

  9. ��@�U [�U�@�B]�C
  10. �b [�إ߳s�u��] ���ĤT�Ӥ]�N�O�̫�@�ӭ������A���H�U�@�~�G
    1. �b [�@��]�w] �Ϭq���A����U�ӭȬO�_���T�C
    2. ��� [�3]�w]�B[�s�u����] �M [�@�~�ƥ�j��] �Ϭq�������A�O�d�w�]�ȡC
    3. �z�i�H�b�H��D�`��K�a�ܧ�o�dz]�w�C�аѾ\�u�s�� JDBC �s�u�!v�C

    4. �b [���[�S��] �?�A�s�W���ݪ��S�ʡA�Ҧp��Ʈw�W�� (URL)�B�ϥΪ̦W�٩M�K�X�C
  11. ��@�U [����]�C

���Ī� asadmin ��O���Gcreate-jdbc-connection-pool

�s�� JDBC �s�u��

[�s�� JDBC �s�u��] �������z���ѤF�ܧ�{���*��Ҧ��]�w (�*��W�ٰ��~) ����k�C

�Y�n�s�� [�s�� JDBC �s�u��] �����A��H�U�B�J�G

  1. �b��Τ��󤤡A�i�} [�귽] �`�I�C
  2. �b [�귽] �`�I�U�A�i�} [JDBC] �`�I�C
  3. �b [JDBC] �`�I�U�A�i�} [�s�u��] �`�I�C
  4. ��ܭn�s�誺�*��`�I�C
  5. �b [�s�� JDBC �s�u��] �������i�楲�n���ܧ�C
  6. �аѾ\�H�U�U�`�A�H��o����i�H�ܧ󪺳]�w������C

  7. ��@�U [�x�s]�C

�@��]�w

�@��]�w���Ȩ�M��w�˪��S�w JDBC �X�ʵ{���C�o�dz]�w�O Java �{���]�p�y���������O�W�٩Τ����W�١C

�� 6-1 JDBC �s�u�*��@��]�w

�Ѽ�

�y�z

DataSource ���O�W��

��@ DataSource/ConnectionPoolDataSource/XADataSource API ����3�ӯS�w�����O�W�١C�����O��� JDBC �X�ʵ{�����C

�귽����

�ﶵ�]�A javax.sql.DataSource (�ȭ��󥻾�@�~�ƥ�)�Bjavax.sql.XADataSource (����@�~�ƥ�) �M java.sql.ConnectionPoolDataSource (����@�~�ƥ�A�į�i��|�ﵽ)�C

�3]�w

�@�չ����Ʈw�s�u�O�s�b�$��C3�ε{���ШD�s�u�ɡA�N�q�$������ӳs�u�F��3�ε{���)�ӳs�u����A�s�u�N�Ǧ^��$��C

�� 6-2 JDBC �s�u�*��3]�w

�Ѽ�

�y�z

�*���l�j�p�M�̤p�j�p

�$��s�u���̤p�ƥءC�ӭ��ٽT�w�F�����إߦ)�3�ε{����A���Ұʮɸm��$����s�u���ƥءC

�*��̤j�j�p

�$��s�u���̤j�ƥءC

�3]�w�j�p�ƶq

��&V�̤p�$j�p���Y�ɡA�N����վ�j�p�C���ȽT�w�妸�����s�u�ƥءC�N�ӭȳ]�m�L�j�|����s�u�`��F�ӱN�ӭȳ]�m�L�p�h�|�ɭP�IJv���C�C

���m�O��

�s�u�b�$��O��m���A���̪�ɶ� (�H�?���)�C�@���W�L���ɶ��A�Y�q�$������ӳs�u�C

�̪�ݮɶ�

�ШD�s�u��3�ε{���b�F��s�u�O�ɤ��e���ݪ��ɶ��C�ѩ�w�]���ݮɶ��L��A3�ε{���i��|�X�{�L���w����p�C

�s�u����

��ܩʦa�A3�ε{����A���i�H�b�N�s�u�ǰe��3�ε{�����e���ҳs�u�C�p�G�ѩ���X�{�G�٩θ�Ʈw��A�����y����Ʈw���i�ΡA�����ұN���\3�ε{����A���۰ʭ��s�إ߸�Ʈw�s�u�C�s�u���ҷ|�ӥ��B�~���ɶ��A�÷|���L���C�į�C

�� 6-3 JDBC �s�u�*��s�u���ҳ]�w

�Ѽ�

�y�z

�s�u����

��� [�ݭn] �֨���H�ҥγs�u���ҡC

���Ҥ�k

3�ε{����A���i�H�ϥΤT�ؤ�k�����Ҹ�Ʈw�s�u�Gauto-commit�Bmetadata �M table�C

  • auto-commit �M metadata �w 3�ε{����A���z�L�I�s con.getAutoCommit () ��k�M con.getMetaData () ��k�����ҳs�u�C��O�A�ѩ�\�h JDBC �X�ʵ{���֨�F�o�ǩI�s�����G�A�]���o��ؤ�k�L�k�l�״��ѥi�a�����ҡC�лP�X�ʵ{����3�Ӷi��ֹ�A�H�T�w�o�ǩI�s�O�_�Q�֨�C
  • table �w 3�ε{���N�d�߫�w����Ʈw���C���?���s�b�åB�i�H�s��A��n�D�?�C�ơC�ФŨϥΥ]�t�\�h�C���{����θg�`�s���C

���W��

�p�G�q [���Ҥ�k] �զX�����F��A�Цb���B��w��Ʈw��檺�W�١C

�@������

���аO�� [��Ҧ��s�u] ���֨����A�p�G��@�s�u���ѡA3�ε{����A���N��$����Ҧ��s�u�A�M�᭫�s�إ߳o�dzs�u�C�p�G�����֨���A�h�u���n�ϥΦU�ӳs�u�ɤ~�|���s�إ߳o�dzs�u�C

�@�~�ƥ�j��

�ѩ�\�h�ϥΪ̳q�`�i�H�P�B�B�@�a�s��@�Ӹ�Ʈw�A�]���i��X�{�@�ӧ@�~�ƥ�b��s��Ʀӥt�@�ӧ@�~�ƥ�x�Ū��P�@��ƪ����p�C�@�~�ƥ󪺹j���h�ũw�q�F���b��s����ƹ���L�@�~�ƥ󪺥i��{�סC�p�ݦ���j���h�Ū��ԲӸ�T�A�аѾ\��Ʈw��3�Ӫ����C

�� 6-4 JDBC �s�u�*��@�~�ƥ�j���]�w

�Ѽ�

�y�z

�@�~�ƥ�j��

�ϱz�i�H���Ӧ*��s�u���@�~�ƥ�j���h�šC�p�G����w���ѼơA�s�u�N�ϥ� JDBC �X�ʵ{�����Ѫ��w�]�j���h�Ŷi��@�~�C

��O�ҹj���h��

�Ӷ��Ȧb��w�F�j���h�Ū����p�U�~�A�ΡC�p�G��� [��O��] �֨���A�h�q�$����Ҧ��s�u���㦳�ۦP���j���h�šC�Ҧp�A�p�G�W���ϥγs�u�ɵ{���� (�ϥ� con.setTransactionIsolation) �ܧ�F�s�u���j���h�šA�o�ؾ��|�N���A�ܧ�^��w���j���h�šC

�S��

�b [���[�S��] �?�A�i�H��w��Ʈw�W�� (URL)�B�ϥΪ̦W�٩M�K�X���S�ʡC�ѩ��H��Ʈw��3�Ӫ����P�A�S�ʤ]�|���Ҥ��P�A�]���Ьd�\��3�Ӥ��H��o�ԲӸ�T�C

���ҳs�u�3]�w

�Y�n���ҳs�u�3]�w�A�а��H�U�B�J�G

  1. �Ұʸ�Ʈw��A���C
  2. ��@�U [Ping]�C
  3. �޲z�D���x�N�xճs�u���Ʈw�C�p�G��ܿ�~�T���A���ˬd��Ʈw��A���O�_�w���s�ҰʡC

�R�� JDBC �s�u��

  1. �b��Τ��󤤡A�i�} [�귽] �`�I�C
  2. �b [�귽] �`�I�U�A�i�} [JDBC] �`�I�C
  3. �b [JDBC] �`�I�U�A��� [�s�u��] �`�I�C
  4. �b [�s�u��] �������A���n�R�����*��֨���C
  5. ��@�U [�R��]�C

���Ī� asadmin ��O���Gdelete-jdbc-connection-pool


��� JDBC �귽

�إ� JDBC �귽

JDBC �귽 (��Ʒ�) ��3�ε{�����ѳs�u�ܸ�Ʈw����k�C�إ� JDBC �귽���e�A��إ� JDBC �s�u�!C

�Y�n�إ� JDBC �귽�A�а��H�U�B�J�G

  1. �b��Τ��󤤡A�i�} [�귽] �`�I�C
  2. �b [�귽] �`�I�U�A�i�} [JDBC] �`�I�C
  3. �b [JDBC] �`�I�U�A��� [JDBC �귽] �`�I�C
  4. �b [JDBC �귽] �������A��@�U [�s��]�C
  5. �b [�إ� JDBC �귽] �������A��w�귽���]�w�G
    1. �b [JNDI �W��] ��줤�A��J�ߤ@���W�١C��ӺD�ҡA�ӦW��3�H jdbc/ �r��}�Y�C�Ҧp�Jjdbc/payrolldb�C�Ф��n�ѰO���׽u�C
    2. �q [�&W��] �զX����ܭn�P�s�� JDBC �귽���p���s�u�!C
    3. �̹w�]�A�إ߸귽����ߧY�i�H�ϥθ귽 (�w�ҥ�)�C�p�G�n�ϸ귽���i�ΡA�Ш���� [�ҥ�] �֨���C
    4. �b [�y�z] ��줤�A��J�귽��²�u�y�z�C
    5. �b [�ؼ�] �Ϭq�A��w�Ӹ귽�b�䤤�i�Ϊ��ؼ� (�O���M�W�ߦ�A�����)�C�b�������һݪ��ؼСA�M���@�U [�W�[] �H�N��W�[����ؼЪ��M�椤�C
  6. ��@�U [�T�w]�C

���Ī� asadmin ��O���Gcreate-jdbc-resource

�s�� JDBC �귽

  1. �b��Τ��󤤡A�i�} [�귽] �`�I�C
  2. �b [�귽] �`�I�U�A�i�} [JDBC] �`�I�C
  3. �b [JDBC] �`�I�U�A�i�} [JDBC �귽] �`�I�C
  4. ���n�s�誺 JDBC �귽���`�I�C
  5. �b [�s�� JDBC �귽] �������A�i�H���H�U�@�~�G
    1. �q [�&W��] �զX������L�s�u�!C
    2. �b [�y�z] ��줤�A�ܧ�귽��²�u�y�z�C
    3. ���Ψ����֨���H�ҥΩΰ��θ귽�C
    4. ��� [�ؼ�] ���ҡA�H�ܧ�㦳�i�θ귽���ؼ� (�O���M�W�ߦ�A�����)�C
    5. ���M�椤���{���ؼЪ��֨���A�M���@�U [�ҥ�] �H�ҥθӥؼЪ��귽�A�Ϊ̫�@�U [����] �H���θӥؼЪ��귽�C

      ��@�U [�޲z�ؼ�] �i�H�b�M�椤�W�[�β����ؼСC�b [�޲z�ؼ�] �������A�q������ [�i��] �M�椤���һݪ��ؼСA�M���@�U [�W�[] �H�N��W�[����ؼЪ��M�椤�C��@�U [����] �i�H�q [�w���] �M�椤�����ؼСC

      ��@�U [�T�w] �H�x�s��i�ΥؼЪ��ܧ�C

  6. ��@�U [�x�s] �H�M�νs��C

�R�� JDBC �귽

  1. �b��Τ��󤤡A�i�} [�귽] �`�I�C
  2. �b [�귽] �`�I�U�A�i�} [JDBC] �`�I�C
  3. �b [JDBC] �`�I�U�A��� [JDBC �귽] �`�I�C
  4. �b [JDBC �귽] �������A���n�R�����귽���֨���C
  5. ��@�U [�R��]�C

�ҥΩM���� JDBC �귽

  1. �b��Τ��󤤡A�i�} [JDBC �귽] �`�I�ήi�} [�W�߹��] �H��� [��A����Ҹ`�I�귽] ���ҡC
  2. �b [�귽] �������A���n�ҥΩΰ��Ϊ��귽���֨���C
  3. ��@�U [�ҥ�] �� [����]�C


������ʺ޲z�{���귽

�إ߫���ʺ޲z�{���귽

�V�U�ۮe�ʻݭn���\��C�Y�n�b���� 7 �� Application Server �W���A�ϥήe���޲z������� Bean (�@�� EJB ����) ��3�ε{���ݭn����ʺ޲z�{���귽�C

�Y�n�إ߫���ʺ޲z�{���귽�A�а��H�U�B�J�G

  1. �b��Τ��󤤡A�i�} [�귽] �`�I�C
  2. �b [�귽] �`�I�U�A��� [����ʺ޲z�{��] �`�I�C
  3. �b [����ʺ޲z�{��] �������A��@�U [�s��]�C
  4. �b [�إ߫���ʺ޲z�{��] �������A��w�H�U�]�w�G
    1. �b [JNDI �W��] ��줤�A��J�ߤ@���W�١A�Ҧp�Gjdo/mypm�C�Ф��n�ѰO���׽u�C
    2. �b [�u�t���O] ��줤�A�O�d���������Ѫ��w�]���O�A����J��L��@���O�C
    3. �q [�s�u��] �զX����ܷs������ʺ޲z�{���귽���ݪ��s�u�!C
    4. �̹w�]�A�N�ҥηs������ʺ޲z�{���귽�C�Y�n�N�䰱�ΡA�Ш���� [�ҥ�] �֨���C
    5. �b [�ؼ�] �Ϭq�A��w�㦳�i�θ귽���ؼ� (�O���M�W�ߦ�A�����)�C�b�������һݪ��ؼСA�M���@�U [�W�[] �H�N��W�[����ؼЪ��M�椤�C
  5. ��@�U [�T�w]�C

���Ī� asadmin ��O���Gcreate-persistence-resource

�s�����ʺ޲z�{���귽

�Y�n�s��{��������ʺ޲z�{���귽�S�ʡA�а��H�U�B�J�G

  1. �b [�s�����ʺ޲z�{���S��] ���Ҥ��A��� [�W�[�S��] ��s�C
  2. [���[�S��] �?�N�W�[�@�ӷs�C�C

  3. �W�[�һݪ��S�ʩM�ȡC

�޲z�귽�ؼ�

�Y�n�޲z�귽�ؼСA�а��H�U�B�J�G

  1. ��� [�ؼ�] ���ҡA�H�ܧ�귽�Ҧb���ؼ� (�O���M�W�ߦ�A�����)�C
  2. ���M�椤���{���ؼЪ��֨���A�M���@�U [�ҥ�] �H�ҥθӥؼЪ��귽�A�Ϊ̫�@�U [����] �H���θӥؼЪ��귽�C
  3. ��@�U [�޲z�ؼ�] �i�H�b�M�椤�W�[�β����ؼСC�b [�޲z�ؼ�] �������A�q������ [�i��] �M�椤���һݪ��ؼСA�M���@�U [�W�[] �H�N��W�[����ؼЪ��M�椤�C��@�U [����] �i�H�q [�w���] �M�椤�����ؼСC
  4. ��@�U [�T�w] �H�x�s��i�ΥؼЪ��ܧ�C
  5. ��@�U [�x�s]�C

�R������ʺ޲z�{���귽

  1. �b��Τ��󤤡A�i�} [����ʺ޲z�{��] �`�I�C
  2. ��� [����ʺ޲z�{��] �`�I�C
  3. �b [����ʺ޲z�{��] �������A���n�R��������ʺ޲z�{�����֨���C
  4. ��@�U [�R��]�C

���Ī� asadmin ��O���Gdelete-persistence-resource

�ҥΩM���Ϋ���ʺ޲z�{���귽

  1. �b��Τ��󤤡A�i�} [����ʺ޲z�{��] �`�I�C
  2. ���n�ҥΩΰ��Ϊ��귽���֨���C
  3. ��@�U [�ҥ�] �� [����]�C



�W�@��      �ؿ�      �U�@��     


Copyright 2004 - 2005 Sun Microsystems, Inc. ���v�Ҧ��C