wood burning stoves 2.0
The moose likes JDBC and Relational Databases 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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "connecting to Webtrends reporting DB using JDBC-ODBC" Watch "connecting to Webtrends reporting DB using JDBC-ODBC" New topic

connecting to Webtrends reporting DB using JDBC-ODBC

Suchitra Bhat
Ranch Hand

Joined: Dec 30, 2005
Posts: 62

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

Joined: Dec 20, 2006
Posts: 2551


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
I agree. Here's the link: http://aspose.com/file-tools
subject: connecting to Webtrends reporting DB using JDBC-ODBC
It's not a secret anymore!