Super Contributor.. Giulio Soleni Super Contributor..
Super Contributor..
350 views

OO 10.70 trigger SQL command against MySQL database

Hello,
for testing purposes I am trying to run some SQL command against a MySQL db.

Looking at the specifics descriptions on Library/Operations/Databases/JDBC folder of Base CP I defined the following folder on my Studio installation path:
D:\Program Files\Hewlett Packard Enterprise\HPE Operations Orchestration\studio\lib\ext\com.hp.oo_oo-sql-legacy-plugin\

and I put the mysql-connector-java-5.1.30-bin.jar driver within the new created folder.

Then I specified the following inputs on my SQL Command step:
DBServerName: fqdn.of.mySql.server
DbType: MySQL
Username: mydbUser
Password: mydbPassword
DBPort: 3306
Database: myDbName
dbClass: mysql-connector-java-5.1.30-bin.jar
dbURL: jdbc:mysql://fqdn.of.mySql.server3306/myDbName
Command: my SQL Select command

However I keep getting an error:
exception=java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at com.iconclude.content.actions.sql.services.databases.MySqlDatabase.setUp(MySqlDatabase.java:21)
at com.iconclude.content.actions.sql.services.ConnectionService.setUpConnection(ConnectionService.java:81)
at com.iconclude.content.actions.sql.services.SQLCommandService.executeSqlCommand(SQLCommandService.java:24)
at com.iconclude.content.actions.sql.SQLCommand.execute(SQLCommand.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.hp.oo.sdk.plugins.abstracts.BaseActionPlugin.execute(BaseActionPlugin.java:53)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.hp.oo.maven.PluginAdapterImpl.executePlugin(PluginAdapterImpl.java:328)
at com.hp.oo.maven.PluginAdapterImpl.execute(PluginAdapterImpl.java:248)
at com.hp.oo.execution.control.actions.contentexecution.ContentExecutionActions.executeContentAction(ContentExecutionActions.java:97)
at sun.reflect.GeneratedMethodAccessor754.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at io.cloudslang.worker.execution.reflection.ReflectionAdapterImpl.executeControlAction(ReflectionAdapterImpl.java:62)
at io.cloudslang.worker.execution.services.ExecutionServiceImpl.executeStep(ExecutionServiceImpl.java:326)
at io.cloudslang.worker.execution.services.ExecutionServiceImpl.execute(ExecutionServiceImpl.java:80)
at io.cloudslang.worker.management.services.SimpleExecutionRunnable.executeRegularStep(SimpleExecutionRunnable.java:167)
at io.cloudslang.worker.management.services.SimpleExecutionRunnable.run(SimpleExecutionRunnable.java:120)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at io.cloudslang.worker.management.services.WorkerThreadFactory$1.run(WorkerThreadFactory.java:33)
at java.lang.Thread.run(Thread.java:745)

What should I do... maybe set different values for dbClass and/or dbURL ?

any help would be appreciated
Thank you
Giulio

 

0 Likes
2 Replies
AndreiTruta Outstanding Contributor.
Outstanding Contributor.

Re: OO 10.70 trigger SQL command against MySQL database

You seem to follow the right specifications.

You might provide some screenshots so we take a look and make sure you did not include something odd there.

Also, did you try by any chance to specify the version too and see if it works?

 

 

Andrei Vasile Truta
0 Likes
Super Contributor.. Giulio Soleni Super Contributor..
Super Contributor..

Re: OO 10.70 trigger SQL command against MySQL database

My fault... I just forgot to restart ALL the services: RAS, Central and Studio too.

After a full restart, everything went fine.

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.