Win a copy of Mastering Non-Functional Requirements this week in the Design forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

connecting to Webtrends reporting DB using JDBC-ODBC  RSS feed

Suchitra Bhat
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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";
//String url = "";
//String url = "jdbcracle:thin:@";
//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
Jan Cumps
Posts: 2630
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!