Skip to Content

Changes for page JDBC2XML Usage

Last modified by christoph_lechleitner@iteg_at on 2013-10-08 03.37:51
From version 9.1
edited by christoph_lechleitner@iteg_at
on 2013-10-08 03.37:50
Change comment: Added auth options to most command introductions
To version 5.1
edited by christoph_lechleitner@iteg_at
on 2012-11-27 02.27:45
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -15,7 +15,7 @@
15 15  ==== {{id name="JDBC2XMLUsage-DumpingaDBtoXML"/}}Dumping a DB to XML ====
16 16  
17 17  {{code language="none"}}
18 -jdbc2xml --url <jdbc-url> --user <jdbc-user> --password <jdbc-password> --file <path-to-file>
18 +jdbc2xml --url <jdbc-url> --file <path-to-file>
19 19  {{/code}}
20 20  
21 21  See below for details and example for JDBC URLs.
... ... @@ -23,13 +23,13 @@
23 23  ==== {{id name="JDBC2XMLUsage-RestoringaDBfromXML"/}}Restoring a DB from XML ====
24 24  
25 25  {{code language="none"}}
26 -xml2jdbc --file <path-to-file> --url <jdbc-url> --user <jdbc-user> --password <jdbc-password>
26 +xml2jdbc --file <path-to-file> --url <jdbc-url>
27 27  {{/code}}
28 28  
29 29  ==== {{id name="JDBC2XMLUsage-CopyingfromoneDBtoanother"/}}Copying from one DB to another ====
30 30  
31 31  {{code language="none"}}
32 -jdbc2jdbc --from-url <jdbc-url> --to-url <jdbc-url> --user <jdbc-user> --password <jdbc-password>
32 +jdbc2jdbc --from-url <jdbc-url> --to-url <jdbc-url>
33 33  {{/code}}
34 34  
35 35  ==== {{id name="JDBC2XMLUsage-ParseandcopyanXMLfile"/}}Parse and copy an XML file ====
... ... @@ -43,13 +43,13 @@
43 43  ==== {{id name="JDBC2XMLUsage-TestDBconnectionandserverstatus"/}}Test DB connection and server status ====
44 44  
45 45  {{code language="none"}}
46 -jdbcping --url <jdbc-url> --user <jdbc-user> --password <jdbc-password>
46 +jdbcping --url <jdbc-url>
47 47  {{/code}}
48 48  
49 49  ==== {{id name="JDBC2XMLUsage-ExtractpartsofaDB"/}}Extract parts of a DB ====
50 50  
51 51  {{code language="none"}}
52 -jdbcextr --url <jdbc-url> --user <jdbc-user> --password <jdbc-password> --file <path-to-file>
52 +jdbcextr --url <jdbc-url> --file <path-to-file>
53 53  {{/code}}
54 54  
55 55  == {{id name="JDBC2XMLUsage-JDBCURLs"/}}JDBC URLs ==
... ... @@ -255,13 +255,20 @@
255 255  --debug-startup
256 256  {{/code}}
257 257  
258 -=== {{id name="JDBC2XMLUsage-Driverpackagesandpaths,andotherBackendspecifictips"/}}Driver packages and paths, and other Backend specific tips ===
258 +=== {{id name="JDBC2XMLUsage-Driverpackagesandpaths"/}}Driver packages and paths ===
259 259  
260 -See
260 +====== {{id name="JDBC2XMLUsage-MySQL-Driver"/}}MySQL-Driver ======
261 261  
262 -(% style="list-style-type: square;" %)
263 -* [[MySQL Tips>>doc:JDBC2XML.JDBC2XML Usage.MySQL Tips.WebHome]]
264 -* [[doc:JDBC2XML.JDBC2XML Usage.MSSQL Tips.WebHome]]
265 -* [[doc:KH.Database Tips.JDBC Snippets.WebHome]] with common JDBC URL examples
262 +{{code language="none"}}
263 +apt-get install libmysql-java
264 + 
265 +jdbc2xml ... --jdbc-drivers /usr/share/java/mysql-connector-java.jar
266 +{{/code}}
266 266  
267 -
268 +====== {{id name="JDBC2XMLUsage-MSSQL-Driver"/}}MSSQL-Driver ======
269 +
270 +{{code language="none"}}
271 +apt-get install apache-karaf-mssql
272 + 
273 +jdbc2xml ... --jdbc-drivers /usr/share/apache-karaf/lib/sqljdbc4.jar
274 +{{/code}}
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -656916
1 +656871
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/JDBC2XML/pages/656916/JDBC2XML Usage
1 +https://clazzes.atlassian.net/wiki/spaces/JDBC2XML/pages/656871/JDBC2XML Usage