Topic: Teradata jdbc ( how to configure it?)

Go back to forum.

Topic by palestal 2009-04-09 11: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 11:54
Reply by palestal 2009-04-09 11:57	Topic "JDBC Relative Path" helps... But what is I dont know what to put there...
Reply by franklin 2009-04-09 15: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 22: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:// 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 10: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: your comments Log in by clicking the login link at the top of the screen

Go back to forum.