Win a copy of Succeeding with AI this week in the Artificial Intelligence and Machine Learning forum!
    Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
  • Junilu Lacar
Sheriffs:
  • Tim Cooke
  • Jeanne Boyarsky
  • Knute Snortum
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Piet Souris
Bartenders:
  • salvin francis
  • fred rosenberger
  • Frits Walraven

JDBC/ODBC class not found exception

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Report post to moderator
This is the program:
-------------------------------------------
import java.sql.*;

public class DbConnetIds
{
public static void main (String [] rags)throws Exception
{
Class.forName("ids.sql.IDSDriver");

Connection con = DriverManager.getConnection("jdbc:ids://localhost:12/conn?dsn='oracle_odbc'","bstest02/pin2","pin2");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT aac_package FROM account_t WHERE aac_promo_code LIKE 'voip_slp_transitions_09%'");

System.out.print("rs.getInt(1)");
}

}
----------------------------------
I am getting following error during run time:
Exception in thread "main" java.lang.ClassNotFoundException: ids.sql.IDSDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at DbConnetIds.main(DbConnetIds.java:7)

-------------------------------------------------
Note : I installed IDS server on my my machine,updated the sytem PATH variable.
I am getting similar error with type1 driver.
 
Marshal
Posts: 68976
275
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please don't ask the same question twice.
 
Good night. Drive safely. Here's a tiny ad for the road:
Two software engineers solve most of the world's problems in one K&R sized book
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic