topic Re: General JDBC create a Db Connection that doesn't work in Talend Studio

General JDBC create a Db Connection that doesn't work

_AnonymousUser — Sat, 16 Nov 2024 13:49:03 GMT

Hi,
I need to use several types of databases in my project so I want to use a JDBC connection.
For example, I want to create a MS SQL Server connection. I have downloaded the driver on the MS website :
http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en
Like all other connections I have made a right click on "Db Connections", then "Create connection". I filled a "Name", click "Next" and I have choosen those settings :
- DB Type : General JDBC
- Driver jar : C:\sqljdbc4.jar
- JDBC URL : jdbc:sqlserver://dbhost:1433;databaseName=test
- Class name : com.microsoft.sqlserver.jdbc.SQLServerDriver
- User name : user
- Password : /
- Mapping file : id_MSSQL
Connection is successfull after trying it with the button "Check" and I clicked "Finish". The new connection is created in the "Db Connections" menu.
When I tried to drag and drop a element from the "Db Connections" menu to the job I have a java.lang.NullPointerException. The log file at "C:\TOS-Win32-r26090-V3.1.3\workspace\.metadata" contains this error :
!ENTRY org.eclipse.jface 4 2 2009-08-17 16:25:46.927
!MESSAGE Problems occurred when invoking code from plug-in: "org.eclipse.jface".
!STACK 0
java.lang.NullPointerException
at org.talend.designer.core.ui.editor.cmd.QueryGuessCommand.execute(Unknown Source)
at org.eclipse.gef.commands.CommandStack.execute(Unknown Source)
at org.talend.designer.core.ui.editor.process.TalendEditorDropTargetListener.execCommandStack(Unknown Source)
at org.talend.designer.core.ui.editor.process.TalendEditorDropTargetListener.createNewComponent(Unknown Source)
at org.talend.designer.core.ui.editor.process.TalendEditorDropTargetListener.handleDrop(Unknown Source)
(...)
Can you say if I have made a mistake for creating the connection or does I have to post it in the bug tracker ?
Best regards,
Kazuki.

Re: General JDBC create a Db Connection that doesn't work

Anonymous — Tue, 18 Aug 2009 04:39:57 GMT

Hello
I got the same the problem, please report a bug on our bugtracker.
Thanks for your support!!
Best regards

shong

Re: General JDBC create a Db Connection that doesn't work

_AnonymousUser — Tue, 18 Aug 2009 07:39:00 GMT

Hi,
I have reported the bug -> http://www.talendforge.org/bugs/view.php?id=8752
Thank you for your answer 😃
Best regards,
Kazuki.

Re: General JDBC create a Db Connection that doesn't work

_AnonymousUser — Tue, 21 Feb 2012 17:21:55 GMT

Hi,
I am looking at this product and it tutorials and I also get the above error when I double click onto a demoMysql 0.1 connection
I also cannot seem to create a connection. If I right click on Db Connections I can perform any of the options except for the create. When I click on create nothing happens.
I am using Talend Open Studio for MDM (5.0.1.r74687)
I would be delighted if someone could tell me what to do to resolve this as it is currently blocking my progression through the tutorials and my getting to grips with the product.
Cheers,
Conor

Re: General JDBC create a Db Connection that doesn't work

_AnonymousUser — Tue, 21 Feb 2012 17:36:09 GMT

Hi,
Apologies, it would appear my approach was probably incorrect. As I said above, I'm am a new comer looking into this product and I had been on the MDM tab on top right. When I switched this to Integration it seems to be working fine.
It may be that I should have known that from the start!
Cheers.