view tests/Test_PSlargeresponse.java @ 91:6f74e01c57da embedded

Made fixings regarding the null values retrieval. The JDBC embedded connection is working!!! :) Some more testing, optimizations and compilations fixes are still required.
author Pedro Ferreira <pedro.ferreira@monetdbsolutions.com>
date Thu, 05 Jan 2017 17:57:57 +0000 (2017-01-05)
parents 04fbf3655452
children c38d4eaf5479
line wrap: on
line source
/*
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0.  If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 * Copyright 1997 - July 2008 CWI, August 2008 - 2017 MonetDB B.V.
 */

import java.sql.*;
import java.util.*;

public class Test_PSlargeresponse {
	public static void main(String[] args) throws Exception {
		// Class.forName("nl.cwi.monetdb.jdbc.MonetDriver");	// not needed anymore for self registering JDBC drivers
		Connection con = DriverManager.getConnection(args[0]);
		Statement stmt = con.createStatement();
		PreparedStatement pstmt;
		// retrieve this to simulate a bug report
		DatabaseMetaData dbmd = con.getMetaData();

		// >> true: auto commit should be on
		System.out.println("0. true\t" + con.getAutoCommit());

		try {
			System.out.print("1. DatabaseMetadata environment retrieval... ");
			if (args[0].startsWith(dbmd.getURL()))
				System.out.println("oke");
			else
				System.out.println("not oke " + dbmd.getURL());

			pstmt = con.prepareStatement("select * from columns");
			System.out.print("2. empty call...");
			try {
				// should succeed (no arguments given)
				pstmt.execute();
				System.out.println(" passed :)");
			} catch (SQLException e) {
				System.out.println(" FAILED :(");
				System.out.println("ABORTING TEST!!!");
				System.exit(-1);
			}
		} catch (SQLException e) {
			System.out.println("FAILED :( "+ e.getMessage());
			System.out.println("ABORTING TEST!!!");
		}

		con.close();
	}
}