SQL Server JDBC - No suitable driver found (223 Views)
Reply
Advisor
arputh
Posts: 30
Registered: ‎06-19-2012
Message 1 of 1 (223 Views)

SQL Server JDBC - No suitable driver found

We have an integration with a SQL 2008 server and use Web Services to read the SQL server table and then create a request for a new entry in the table that was setup for us.

 

The SQL server was not in a failover implementation. The DB was moved over into a failover SQL server environment.

 

Our integration process worked 100% until we tested the new connection and experiences the following error (See text in green below):

**********************************************************************************************************************

CL Local Exec

Source Command:Run Interface V1 sh ./interfaces/EITI_IRFS/bin/runInterface.sh ./interfaces/EITI_IRFS http://dppm11.vodacom.corp:8082/itg/ -jdbc jdbc:sqlserver:zamds20710\collaboration;databaseName=ppm;selectMethod=cursor -dbUser ppm -dbPassword V0d@c0m082 sh: SHELLOPTS: readonly variable '/apps/ppmadmin/ppm/dev/conf:/apps/ppmadmin/ppm/dev/lib/jboss/boot/knta_logging.jar:/apps/ppmadmin/ppm/dev/lib/jboss/boot/log4j-boot.jar:/apps/ppmadmin/ppm/dev/lib/jboss/boot/run.jar:/apps/ppmadmin/ppm/dev/server/dev/deploy/itg.war/html/client/itgcore_resources*.jar:/apps/ppmadmin/ppm/dev/conf/custom_resources/mobility_access:/apps/ppmadmin/ppm/dev/conf/custom_resources/msp:/apps/ppmadmin/ppm/dev/conf/custom_resources/suggested_items:/apps/ppmadmin/jdk1.7.0_17//lib/tools.jar' Interface repositoryDir: ./interfaces/EITI_IRFS serviceURLbaseParameter: http://dppm11.vodacom.corp:8082/itg/ jdbcURL: jdbc:sqlserver:zamds20710\collaboration;databaseName=ppm;selectMethod=cursor dbUser: ppm dbPassword: V0d@c0m082 --------------------------------------------------------- Jan 15, 2014 8:10:53 PM org.apache.axis2.deployment.DeploymentEngine prepareRepository INFO: no services directory found under /apps/ppmadmin/ppm/dev/interfaces/EITI_IRFS Jan 15, 2014 8:10:54 PM org.apache.axis2.deployment.DeploymentEngine doDeploy INFO: Deploying module : rampart-1.1 Jan 15, 2014 8:10:54 PM org.apache.axis2.deployment.DeploymentEngine doDeploy INFO: Deploying module : addressing-1.1 Imported interrupted due to error: No suitable driver found for jdbc:sqlserver:zamds20710\collaboration;databaseName=ppm;selectMethod=cursor ------------------------------------------------------ exit code = 1 Errors occurred during command execution.

*******************************************************************************************************************

 

If anyone has a suddestion?

 

Regards

 

Alfred

 

Alfred Puth
PPM Consultant
EOH Application Management
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.