You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Mario Henley Becerril Geldis <he...@uaemex.mx> on 2002/07/18 22:59:29 UTC

java jdbctest (fwd)


   $javac jdbctest.java run fine, but when i try $java jdbctest, this say:

  Exception in thread "main" java.lang.NoClassDefFoundError: jdbctest

   my
CLASSPATH=/usr/local/source/oraInventory/jdbc/lib/classes12.jar:
/usr/local/source/oraInventory/jdbc/lib/nls_charset12.jar:
/usr/java/j2sdk1.4.1/lib/tools.jar:/usr/java/j2sdk1.4.1/jre/lib/rt.jar:
/usr/local/tomcat/common/lib/servlet.jar:/usr/java/j2re1.4.1/lib


   my code:

  import java.sql.*; 
  import java.io.*; 
  import java.util.Date; 
  class JdbcTest
  { 

  public static void main (String args []) 

      throws SQLException, IOException

  { 

    System.out.println ("Loading Oracle driver"); 

    try 

    {
  Class.forName ("oracle.jdbc.driver.OracleDriver");
      
    } 

    catch (/*ClassNotFound*/ Exception e) 

    {

      System.out.println ("Could not load the driver"); 

      e.printStackTrace (); 

     }

    System.out.println ("Connecting to the local database"); 


    Connection conn =

      DriverManager.getConnection
        (
         "jdbc:oracle:thin:@myserver:1521:example",
             "example",  // ## fill in User here
             "example" // ## fill in Password here
        );
    
    
    System.out.println ("OK");
    Statement stmt = conn.createStatement (); 

    // Query the employee names 
    
    ResultSet rset = stmt.executeQuery ("SELECT field1 From
TDFDF97_NL");
    
    while (rset.next ()) 
      
      { 

        // Print the name out 

        System.out.println (rset.getString (1)); 

      } 
  } 
  
} 



  any ideas..???



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: java jdbctest (fwd)

Posted by Denis Haskin <De...@HaskinFerguson.net>.
Try

    java JdbcTest

(note capitalization must match the capitalization of your classname)

dwh


Mario Henley Becerril Geldis wrote:

>    $javac jdbctest.java run fine, but when i try $java jdbctest, this say:
>
>   Exception in thread "main" java.lang.NoClassDefFoundError: jdbctest
>
>    my
> CLASSPATH=/usr/local/source/oraInventory/jdbc/lib/classes12.jar:
> /usr/local/source/oraInventory/jdbc/lib/nls_charset12.jar:
> /usr/java/j2sdk1.4.1/lib/tools.jar:/usr/java/j2sdk1.4.1/jre/lib/rt.jar:
> /usr/local/tomcat/common/lib/servlet.jar:/usr/java/j2re1.4.1/lib
>
>    my code:
>
>   import java.sql.*;
>   import java.io.*;
>   import java.util.Date;
>   class JdbcTest

[...etc...]


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: java jdbctest (fwd)

Posted by Shahed Moolji <sh...@enoor.com>.
you need to add the current dir to your classpath

ie . $CLASSPATH=./:$CLASSPATH
----- Original Message -----
From: "Mario Henley Becerril Geldis" <he...@uaemex.mx>
To: <to...@jakarta.apache.org>
Sent: Thursday, July 18, 2002 3:59 PM
Subject: java jdbctest (fwd)


>
>
>    $javac jdbctest.java run fine, but when i try $java jdbctest, this say:
>
>   Exception in thread "main" java.lang.NoClassDefFoundError: jdbctest
>
>    my
> CLASSPATH=/usr/local/source/oraInventory/jdbc/lib/classes12.jar:
> /usr/local/source/oraInventory/jdbc/lib/nls_charset12.jar:
> /usr/java/j2sdk1.4.1/lib/tools.jar:/usr/java/j2sdk1.4.1/jre/lib/rt.jar:
> /usr/local/tomcat/common/lib/servlet.jar:/usr/java/j2re1.4.1/lib
>
>
>    my code:
>
>   import java.sql.*;
>   import java.io.*;
>   import java.util.Date;
>   class JdbcTest
>   {
>
>   public static void main (String args [])
>
>       throws SQLException, IOException
>
>   {
>
>     System.out.println ("Loading Oracle driver");
>
>     try
>
>     {
>   Class.forName ("oracle.jdbc.driver.OracleDriver");
>
>     }
>
>     catch (/*ClassNotFound*/ Exception e)
>
>     {
>
>       System.out.println ("Could not load the driver");
>
>       e.printStackTrace ();
>
>      }
>
>     System.out.println ("Connecting to the local database");
>
>
>     Connection conn =
>
>       DriverManager.getConnection
>         (
>          "jdbc:oracle:thin:@myserver:1521:example",
>              "example",  // ## fill in User here
>              "example" // ## fill in Password here
>         );
>
>
>     System.out.println ("OK");
>     Statement stmt = conn.createStatement ();
>
>     // Query the employee names
>
>     ResultSet rset = stmt.executeQuery ("SELECT field1 From
> TDFDF97_NL");
>
>     while (rset.next ())
>
>       {
>
>         // Print the name out
>
>         System.out.println (rset.getString (1));
>
>       }
>   }
>
> }
>
>
>
>   any ideas..???
>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
>


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>