[16869] | 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 | */
|
---|
[14328] | 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 |
|
---|
[30196] | 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 | */
|
---|
[14328] | 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 | }
|
---|