Topic Teradata jdbc ( how to configure it?)

palestal started the topic:
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)
palestal replied:
2009-04-09 09:54
palestal replied:
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...
franklin replied:
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.
Kasper Sørensen replied:
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
Kasper Sørensen replied:
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 are not signed in.
You need to be signed in to participate in the discussion.