java.sql.SQLException: No suitable driver found for jdbc:sqlserver://...

[RambanamP]

Hi,

I am trying to access external database(sqlserver2005) from plugin for athis i placed sqljdbc4.jar under WEB-INF/lib folder it is worked good in jira 4.0.

where as it is not working in jira 4.4, even i tried by adding jtds-1.2.5.jar but no use it is throwing java.sql.SQLException: No suitable driver found for jdbc:sqlserver:... exception.

ps let me know which version or jar i have to add.

Thanks

Prasad

[RambanamP · Accepted solution]

I can able to intract with external Database by configuring JNDI in server.xml

[Nic Brough -Adaptavist-]

As per the instructions at http://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+SQL+Server+2005 the driver needs to go in the lib directory for TOMCAT, not Jira.

[Nic Brough -Adaptavist-]

Please read the bit I put in bold properly.

If I'd meant jira home, I'd have said jira home. If I meant the jira lib directory, I'd have put the jira lib directory

[RambanamP]

Hi Nick,

You mean jira home/lib folder? if it is yes then i tried by placing jars there also but no use getting same error :(

thanks for ur quick response

Prasad

[RambanamP]

Nick,

I placed jar under ...\Atlassian4.4\JIRA 4.4\lib, if it is wrong please let me know the path of TOMCAT lib directory

Thanks

[Nic Brough -Adaptavist-]

That might be the right place, but it depends on how you installed Jira.

If you used a WAR/EAR build, then you should really know the structure of your own Tomcat/other-app-server

But it sounds like you used Jira Standalone, so I think that's the right place - to check, can you confirm the lib directory had other files in there already? Check the ownership and permissions on the database .jar file are the same as the other .jar files that are already in there.

Also, is it definitely the right jar? You downloaded it directly, and you didn't use IE (which does stupid things with file names)

[RambanamP]

yes, i installed standalone jira on windows.

The lib directory already have some jars appart from those jars i added my jar also and ownership also same as other jars.

and i am tested by using chrome aswell Firefox, and sql jar downloaded using firefox

thanks

[Nic Brough -Adaptavist-]

Ok, that's all good, except that it means I'm struggling to work out what's wrong. (I've got a windows install on hand, just dropped that .jar into it and restarted and it's worked fine!).

Could you open it with a zip program and check it really is a proper .jar file? (Check one of the others if you don't know what the structure should be). Also, in Jira, can you check the Admin -> System Info for class paths, loaded libraries etc - there may be a clue there.

[RambanamP]

I can able to intract with external database from type one plugin where as not able to get connection from type to plugin getting java.sql.SQLException: No suitable driver found for jdbc:sqlserver... exception