G�n�ration de DTD � partir d'une base de donn�e

Thread View: fr.comp.text.xml

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Guillaume Helle Wed, 30 Aug 2000 00:00

#10697

Author: Guillaume Helle
Date: Wed, 30 Aug 2000 00:00

9 lines
919 bytes

Bonjour,

je cherche � savoir s'il existe des outils (freeware de pr�f�rence)
permettant de g�n�rer automatiquement un DTD � partir des tables et des cl�s
d'une base de donn�es.

Merci pour vos r�ponses,

Guillaume Helle

Re: G�n�ration de DTD � partir d'une base de donn�e

#10703

Author: Doeni
Date: Wed, 30 Aug 2000 00:00

42 lines
2159 bytes

"Guillaume Helle" <ghelle@capgemini.fr> writes:

> Bonjour,
> 
> je cherche � savoir s'il existe des outils (freeware de pr�f�rence)
> permettant de g�n�rer automatiquement un DTD � partir des tables et des cl�s
> d'une base de donn�es.
> 

Oracle le permet en partie � l'aide du XML SQL Utility :

doeni:/home/doeni% java OracleXML getXML -user "scott/tiger" \
? -conn "jdbc:oracle:thin:@localhost:1521:V816" \
? -encoding "iso-8859-1" -withDTD \
? 'SELECT * FROM emp WHERE 1=2'
<?xml version = '1.0' encoding = 'iso-8859-1'?>
<!DOCTYPE ROWSET [
<!ELEMENT ROWSET (ROW)*>
<!ELEMENT ROW (EMPNO, ENAME?, JOB?, MGR?, HIREDATE?, SAL?, COMM?, DEPTNO?)>
<!ATTLIST ROW num CDATA #REQUIRED>
<!ELEMENT EMPNO (#PCDATA)>
<!ELEMENT ENAME (#PCDATA)>
<!ELEMENT JOB (#PCDATA)>
<!ELEMENT MGR (#PCDATA)>
<!ELEMENT HIREDATE (#PCDATA)>
<!ELEMENT SAL (#PCDATA)>
<!ELEMENT COMM (#PCDATA)>
<!ELEMENT DEPTNO (#PCDATA)>
]>
<ROWSET/>

Download gratuit de http://technet.oracle.com/tech/xml/
C'est une appli JDBC normale, et devrait avec un driver ad�quate
marcher avec d'autres bases qu'Oracle.

-- 
I am not listed on the United States Department of Treasury lists of
Specially Designated Nationals, Specially Designated Terrorists, and
Specially Designated Narcotic Traffickers, nor am I listed on the
United States Department of Commerce Table of Denial Orders.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads