File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Java Interview Guide this week in the Jobs Discussion 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: 2565


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:
subject: connecting to Webtrends reporting DB using JDBC-ODBC
It's not a secret anymore!