Skip to Content

Changes for page JDBC2XML Usage

Last modified by christoph_lechleitner@iteg_at on 2013-10-08 03.37:51
From version 6.1
edited by christoph_lechleitner@iteg_at
on 2012-11-27 04.29:08
Change comment: added exclude hint for MSSQL system tables
To version 2.1
edited by christoph_lechleitner@iteg_at
on 2012-08-03 06.12:17
Change comment: Examples of JDBC URLs, slight restructuring

Summary

Details

Page properties
Content
... ... @@ -8,7 +8,7 @@
8 8  
9 9  The following command overview only shows the absolut minimal number of options.
10 10  
11 -Usually more options are needed, especially {{code language="none"}}--user{{/code}}, {{code language="none"}}--password{{/code}}, and (Linux only, see bottom) {{code language="none"}}--jdbc-drivers{{/code}}.
11 +Usually more options are needed, especially {{code language="none"}}--user{{/code}}, {{code language="none"}}--password{{/code}}, and (Linux only) {{code language="none"}}--jdbc-drivers{{/code}}.
12 12  
13 13  See far below for a full list of options, as well as examples for JDBC URLs.
14 14  
... ... @@ -60,14 +60,12 @@
60 60  
61 61  {{code language="none"}}
62 62  # MySQL
63 -jdbc:mysql://localhost:3306/MYDATABASE?useCursorFetch=true
63 +jdbc:mysql://localhost:3306/MYDATABASE
64 64   
65 65  # MSSQL
66 66  jdbc:sqlserver://localhost:1433;databaseName=MYDATABASE;
67 67  {{/code}}
68 68  
69 -The use of cursor fetching in mysql is highly recommended in order to circumvent java heap space exceptions while dumping the content of large tables.
70 -
71 71  == {{id name="JDBC2XMLUsage-Fulllistofoptions"/}}Full list of options ==
72 72  
73 73  ==== {{id name="JDBC2XMLUsage-Databaseaccess"/}}Database access ====
... ... @@ -254,34 +254,3 @@
254 254  {{code language="none"}}
255 255  --debug-startup
256 256  {{/code}}
257 -
258 -=== {{id name="JDBC2XMLUsage-Driverpackagesandpaths"/}}Driver packages and paths ===
259 -
260 -====== {{id name="JDBC2XMLUsage-MySQL-Driver"/}}MySQL-Driver ======
261 -
262 -{{code language="none"}}
263 -apt-get install libmysql-java
264 - 
265 -jdbc2xml ... --jdbc-drivers /usr/share/java/mysql-connector-java.jar
266 -{{/code}}
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}}
275 -
276 -=== {{id name="JDBC2XMLUsage-Typicalspecialoptions"/}}Typical special options ===
277 -
278 -===== {{id name="JDBC2XMLUsage-MSSQL"/}}MSSQL =====
279 -
280 -{{code language="none"}}
281 -# MSSQL likes to create system tables which should not be exported or imported
282 -jdbc2xml ... --exclude-tables sysdiagrams,trace_xe_event_map,trace_xe_action_map
283 -{{/code}}
284 -
285 -
286 -
287 -
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -656820
1 +656884
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/JDBC2XML/pages/656820/JDBC2XML Usage
1 +https://clazzes.atlassian.net/wiki/spaces/JDBC2XML/pages/656884/JDBC2XML Usage