back to forum.

Topic: Teradata jdbc ( how to configure it?)

Topic by
palestal

2009-04-09
09:27

Teradata jdbc ( how to configure it?)

Hi!
I am trying use teradata db.
I download teradata jdbc driver, but when i try useit with data cleaner it gives errors...

---
"settings" -> "database drivers"
-> "Register database driver"
-> "local JAR file ..."

I select "terajdbc4.jar"

Then I try select
"Driver class"

Can't find teradata or add own ...

Where I should add new jdbc driver?
Is there some configuration file or are those driver classes "hardcoded" to java byte code?



---Could not load driver


Message:
java.lang.ClassNotFoundException:
Level:
SEVERE
Stack Trace:

java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:242)
dk.eobjects.datacleaner.gui.model.DatabaseDriver.loadDriver(DatabaseDriver.java:89)
dk.eobjects.datacleaner.gui.dialogs.DatabaseDriverDialog$3.actionPerformed(DatabaseDriverDialog.java:315)
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
java.awt.Component.processMouseEvent(Component.java:5488)
javax.swing.JComponent.processMouseEvent(JComponent.java:3126)
java.awt.Component.processEvent(Component.java:5253)
java.awt.Container.processEvent(Container.java:1966)
java.awt.Component.dispatchEventImpl(Component.java:3955)
java.awt.Container.dispatchEventImpl(Container.java:2024)
java.awt.Component.dispatchEvent(Component.java:3803)
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
java.awt.Container.dispatchEventImpl(Container.java:2010)
java.awt.Window.dispatchEventImpl(Window.java:1774)
java.awt.Component.dispatchEvent(Component.java:3803)
java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

Reply by
palestal

2009-04-09
09:54

Reply by
palestal

2009-04-09
09:57
Topic "JDBC Relative Path" helps...
But what is

<property name="driverClass" value="xxxx" />

I dont know what to put there...

Reply by
franklin

2009-04-09
13:44
The JDBC driver class is a vendor-specific java class name. It may not be included in the list from which you can choose from, but you can enter it on your own (the list is just for easy access to most common class names).

Teradata will have the information you need somewhere in their documentation. The same goes for the connection string (URL) which you will need to connect to your database.

Reply by
kasper

2009-04-09
20:56
To expand on franklin's reply, here's what I could gather from taking a look at teradata's JDBC FAQ:
  • The driver class name is com.teradata.jdbc.TeraDriver (which can be used in either the Local JAR File dialog or the configuration file, depending on how you prefer to register the driver)
  • The connection string should look something like this: jdbc:teradata://<hostname>

Let us know if it works out. If it does I will add the driver class name to the dialog and the connection string template to the Open Database dialog for datacleaner 1.5.1

Reply by
kasper

2009-04-15
08:57
Hi Palestal.

Did it work? Please let us know so we can add the suggested class name etc. into the application code.

Best, Kasper

You need to be logged in to participate

In order to post your own comments on this topic, you need to be logged in.

Username:

Log in by clicking the login link at the top of the screen

 

Go back to forum.