aspose file tools*
The moose likes JDBC and the fly likes connecting to Webtrends reporting DB using JDBC-ODBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "connecting to Webtrends reporting DB using JDBC-ODBC" Watch "connecting to Webtrends reporting DB using JDBC-ODBC" New topic
Author

connecting to Webtrends reporting DB using JDBC-ODBC

Suchitra Bhat
Ranch Hand

Joined: Dec 30, 2005
Posts: 62
Hi,

I am trying to connect to Webtrends reporting DB (ODDB)using JDBC-ODBC bridge.
Below is the code snippet i am trying to use and getting the SQL Exception
"Error code is :1012
Exception SQL java.sql.SQLException: [WebTrends ODBC Driver] Database connection string is invalid <DRIVER={WebTrends ODBC Driver}> "

Code goes as below

import java.sql.*;
public class TestWebTrend {
public static void main(String args[]){
TestWebTrend test = new TestWebTrend();
Connection con = test.getConnection();
System.out.println("Connection returned is " +con);
}
public Connection getConnection(){
Connection conn = null;
System.out.println("Inside conncetion object");
try {
// String driverName = "oracle.jdbc.driver.OracleDriver";
String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driverName);
//String url = "";
//String url = "jdbcracle:thin:@157.96.117.109:80:3mxn6tmzifg";
//System.out.println("url :"+url);
conn = DriverManager.getConnection("jdbcdbcriver={WebTrends ODBC Driver};Server=server name;Database=database name" ,"userID","password");

System.out.println("conn iside fucntion :"+conn);
} catch (ClassNotFoundException e) {
System.out.println("Exception ClassNotFoundException "+e);
} catch (SQLException e) {
System.out.println("Error code is :"+e.getErrorCode());
System.out.println("Exception SQL "+e);
} catch (Exception e) {
System.out.println("Exception general "+e);
}
return conn;
}
}


Can some one please help me solving this.

Thanks in advance
Suchitra
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2500
    
    8

Suchitra,

The error message you get is correct. It's not a valid connect string.

A valid string looks like: jdbcdbc:<datasourcename>
(e.g. jdbcdbc:mydatabase).
The bridge (+ connect string) is documented on the sun java site.

Does your documentation give you a step guide on how to set this up?

Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: connecting to Webtrends reporting DB using JDBC-ODBC