JDBC to Ingres Woessss....

From: James Kimble (jkimble_at_one.net)
Date: 10/29/03 

Date: 29 Oct 2003 13:53:42 -0800

I'm sure I'm missing something simple here but I'm not getting it.

I've got a simple select example (right out of O'Reilly!!) application
that should be connecting to my ingres database but I can't even get
the driver to load.

The CBF utility shows a JDBC server running on our database. I've confirmed
that the driver is in a jar file in the ingres directory. When I run
the program it just says it failed to load the driver. Can someone
tell me what I'm doing wrong? Path to driver maybe? Help....

////////////////////////////////////////////////////////////////////////

import java.sql.*;
 

public class SelectApp
{
    public static void main ( String args[] )
    {
            String url = "jdbc:edbc://hp:bb7/ing26;UID=t108hjk;PWD=iron2gold";
 
            try
        {
                  Class.forName("ca.edbc.jdbc.EdbcDriver").newInstance();
            }
            catch( Exception e )
        {
                  System.out.println("Failed to load Ingres driver.");
                  return;
            }

            try
        {
                  Connection con = DriverManager.getConnection(url);
                  Statement select = con.createStatement();
                  ResultSet result =
                        select.executeQuery ("SELECT slx_ord_no FROM gi");
 
                  System.out.println("Got results:");

            // Process results one row at a time

                  while ( result.next() )
            {
                String slx_ord_no = result.getString(8);
 
                System.out.println("slx_ord_no = " + slx_ord_no);
                  }

                  select.close();
                  con.close();
            }

            catch ( Exception e )
        {
                  e.printStackTrace();
            }
    }
}

///////////////////////////////////////////////////////////////////////

Relevant Pages

  • Re: White progress bar during startup
    ... Loaded driver \WINDOWS\system32\ntoskrnl.exe ... Did not load driver ACPI Uniprocessor PC ... Did not load driver Audio Codecs ...
    (microsoft.public.windowsxp.help_and_support)
  • XP Pro crashes
    ... The bootlog shows an awful lot of 'Failed to load' entries so I'm taking the liberty of posting the whole bootlog here in the hope that someone can give me some pointers as to what is going on. ... Did not load driver WAN Miniport ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Newbie Questiion
    ... You also come across as a very inexperienced driver when you say that a driver is stuck to take a illegal load. ... Microsoft actually paid no tax at all in 1999, despite $12.3 billion in reported U.S. profits. ... Corporate tax welfare slashed Worldcom’s tax bill by $5.3 billion over the past five years. ...
    (misc.transport.trucking)
  • Re: DRI seems to bee broken
    ... May 3 11:23:06 schlepptop kernel: The Regents of the University of California. ... Adds ~128k to driver. ... # To include support for VGA VESA video modes ... Load "dbe" ...
    (freebsd-current)
  • Re: Driver Load Sequence
    ... Yes i have changed the load order in platform.reg ... There are some other USB related modules which might ... > Have you tried changing the order of the USB Host driver so that it loads ... the Host driver loads the FTDI_SER.DLL at boot time. ...
    (microsoft.public.windowsce.platbuilder)