1 | /*
|
---|
2 | * usersDB2txt.java
|
---|
3 | * Copyright (C) 2008 New Zealand Digital Library, http://www.nzdl.org
|
---|
4 | *
|
---|
5 | * This program is free software; you can redistribute it and/or modify
|
---|
6 | * it under the terms of the GNU General Public License as published by
|
---|
7 | * the Free Software Foundation; either version 2 of the License, or
|
---|
8 | * (at your option) any later version.
|
---|
9 | *
|
---|
10 | * This program is distributed in the hope that it will be useful,
|
---|
11 | * but WITHOUT ANY WARRANTY; without even the implied warranty of
|
---|
12 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
---|
13 | * GNU General Public License for more details.
|
---|
14 | *
|
---|
15 | * You should have received a copy of the GNU General Public License
|
---|
16 | * along with this program; if not, write to the Free Software
|
---|
17 | * Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
|
---|
18 | */
|
---|
19 | package org.greenstone.gsdl3.util;
|
---|
20 |
|
---|
21 | import javax.swing.*;
|
---|
22 | import java.io.File;
|
---|
23 | import java.sql.Connection;
|
---|
24 | import java.sql.DriverManager;
|
---|
25 | import java.sql.ResultSet;
|
---|
26 | import java.sql.SQLException;
|
---|
27 | import java.sql.SQLWarning;
|
---|
28 | import java.sql.Statement;
|
---|
29 | import java.util.Properties;
|
---|
30 |
|
---|
31 | /**
|
---|
32 | To run this from the command-line, first make sure that the networked derby server is running (ant start-derby)
|
---|
33 | then run:
|
---|
34 |
|
---|
35 | java -Dgsdl3.writablehome=/full/path/to/GS3/web -cp ./web/WEB-INF/lib/gsdl3.jar:./web/WEB-INF/lib/gutil.jar:./web/WEB-INF/lib/derby.jar:./web/WEB-INF/lib/derbyclient.jar:./web/WEB-INF/lib/log4j-1.2.8.jar:./web/WEB-INF/classes org.greenstone.gsdl3.util.usersDB2txt web/etc/usersDB/
|
---|
36 |
|
---|
37 | if redirecting to a file append ">& filename.txt" to the above command
|
---|
38 | since the usersDB2txt program output goes to System.err and needs to be redirected to the file too
|
---|
39 |
|
---|
40 | Don't forget to stop the networked derby server again at the end, if you had started it: ant stop-derby
|
---|
41 |
|
---|
42 | Or if using embedded derby, ensure that tomcat is stopped, then run:
|
---|
43 | java -cp /full/path/to/GS3/web/WEB-INF/lib/gsdl3.jar:/full/path/to/GS3/web/WEB-INF/lib/derby.jar org.greenstone.gsdl3.util.usersDB2txt web/etc/usersDB/ [>& <output file>]
|
---|
44 | */
|
---|
45 | public class usersDB2txt
|
---|
46 | {
|
---|
47 | public static void main(String[] args) throws SQLException{
|
---|
48 | if (args.length!=1){
|
---|
49 | System.out.println("The path of usersDB has to be given!");
|
---|
50 | System.exit(0);
|
---|
51 | }
|
---|
52 | DerbyWrapper derbyWrapper=new DerbyWrapper(args[0]);
|
---|
53 | derbyWrapper.db2txt();
|
---|
54 | }
|
---|
55 | }
|
---|