1 /*
2 * $Source$
3 * $Revision$
4 *
5 * Copyright (C) 2007 Tim Pizey
6 *
7 * Part of Melati (http://melati.org), a framework for the rapid
8 * development of clean, maintainable web applications.
9 *
10 * Melati is free software; Permission is granted to copy, distribute
11 * and/or modify this software under the terms either:
12 *
13 * a) the GNU General Public License as published by the Free Software
14 * Foundation; either version 2 of the License, or (at your option)
15 * any later version,
16 *
17 * or
18 *
19 * b) any version of the Melati Software License, as published
20 * at http://melati.org
21 *
22 * You should have received a copy of the GNU General Public License and
23 * the Melati Software License along with this program;
24 * if not, write to the Free Software Foundation, Inc.,
25 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA to obtain the
26 * GNU General Public License and visit http://melati.org to obtain the
27 * Melati Software License.
28 *
29 * Feel free to contact the Developers of Melati (http://melati.org),
30 * if you would like to work out a different arrangement than the options
31 * outlined here. It is our intention to allow Melati to be used by as
32 * wide an audience as possible.
33 *
34 * This program is distributed in the hope that it will be useful,
35 * but WITHOUT ANY WARRANTY; without even the implied warranty of
36 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
37 * GNU General Public License for more details.
38 *
39 * Contact details for copyright holder:
40 *
41 * tim Pizey <timp At paneris.org>
42 * http://paneris.org/~timp
43 *
44 */
45 package org.melati.poem.dbms;
46 import java.sql.Connection;
47 import java.sql.DriverManager;
48 import java.sql.SQLException;
49 import java.sql.Statement;
50
51 /**
52 * @author toby
53 * @since 8 Feb 2007 copied from http://www.mckoi.com/database/UseEmbeddedApp.html
54 *
55 */
56 public final class DebugMckoiConnection {
57
58 private DebugMckoiConnection () {}
59
60 public static void main(String[] args) {
61
62 // Register the Mckoi JDBC Driver
63 try {
64 Class.forName("com.mckoi.JDBCDriver").newInstance();
65 }
66 catch (Exception e) {
67 System.out.println(
68 "Unable to register the JDBC Driver.\n" +
69 "Make sure the JDBC driver is in the\n" +
70 "classpath.\n");
71 System.exit(1);
72 }
73
74 // This URL specifies we are connecting with a local database
75 // within the file system. './db.conf' is the path of the
76 // configuration file of the database to embed.
77 String url = "jdbc:mckoi:local://./db.conf";
78
79 // The username / password to connect under.
80 String username = "as";
81 String password = "as";
82
83 // Make a connection with the local database.
84 Connection connection;
85 try {
86 connection = DriverManager.getConnection(url, username, password);
87 }
88 catch (SQLException e) {
89 System.out.println(
90 "Unable to make a connection to the database.\n" +
91 "The reason: " + e.getMessage());
92 System.exit(1);
93 return;
94 }
95
96 try {
97
98 // .... Use 'connection' to talk to database ....
99
100 Statement s = connection.createStatement();
101 s.executeUpdate("create table t11 (id int not null, name varchar(22))");
102
103 // Close the connection when finished,
104 connection.close();
105 System.out.println("Finished");
106 }
107 catch (SQLException e) {
108 System.err.println(
109 "An error occured\n" +
110 "The SQLException message is: " + e.getMessage());
111 return;
112 }
113
114 }
115
116 }