Commander
Commander
590 views

AcuXdbcs from Java

Jump to solution

Hi.

I have installed AcuXDBC in a Power/AIX.

From local, executing asql.sh i don't have any problem.

The variables is seted to:

export GENESIS_HOME=/opt/acucorp/AcuXDBC

export PATH=/opt/acucorp/AcuXDBC/bin:$PATH
export LD_LIBRARY_PATH=/opt/acucorp/AcuXDBC/bin:/opt/acucorp/AcuXDBC/lib:$LD_LIBRARY_PATH
export LIBPATH=/opt/acucorp/AcuXDBC/bin:/opt/acucorp/AcuXDBC/lib:$LIBPATH
export CLASSPATH=/opt/acucorp/AcuXDBC/bin/vortex.jar:.
export VORTEX_HOME=/opt/acucorp/AcuXDBC

then i start the server with the following command:

acuxdbcs -start

When i try to access from Linux with a Java program, i use the following connection string:

"jdbc:vortex://system/manager/gds10:acuxdbc.cfg@20222:<IP SERVER>!acuxdbc04";

i obtain the following error:

java.sql.SQLException: dbChannel exception: DLLLOAD: gds10, 0509-022 Cannot load module /opt/acucorp/AcuXDBC/bin/gds10.so.
0509-150 Dependent module libcobrts64.2.so could not be loaded.
0509-022 Cannot load module libcobrts64.2.so.
0509-026 System error: A file or directory in the path name does not exist.
0509-022 Cannot load module /opt/acucorp/Ac
at vortex.sql.vortexConnection.<init>(vortexConnection.java:165)
at vortex.sql.vortexDriver.connect(vortexDriver.java:255)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)
at sample.main(sample.java:30)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:564)
at jdk.compiler/com.sun.tools.javac.launcher.Main.execute(Main.java:415)
at jdk.compiler/com.sun.tools.javac.launcher.Main.run(Main.java:192)
at jdk.compiler/com.sun.tools.javac.launcher.Main.main(Main.java:132)

i've verified the existence of the file /opt/acucorp/AcuXDBC/bin/gds10.so and, it is there.

Can anybody help me?

Fernando.-

0 Likes
1 Solution

Accepted Solutions
Commander
Commander

@Claudio_ContardiThanks a lot!

 

Regards

Fernando.-

View solution in original post

0 Likes
5 Replies
Micro Focus Expert
Micro Focus Expert

Good morning, @fbenedic 

Can you try this syntax?

"jdbc:vortex:system//manager/testjava:acuxdbc.cfg!acuxdbc04"

Taken from: https://bit.ly/34jkM68

 

----------------------------
Claudio Contardi
Product Support Engineer, Senior
Micro Focus
0 Likes
Micro Focus Expert
Micro Focus Expert

@fbenedic , 

I think the problem is in the library you are calling.

You should be using:

jdbc:vortex://system/manager/xvision:acuxdbc.cfg@20222:<IP SERVER>!acuxdbc04

rather than

jdbc:vortex://system/manager/gds10:acuxdbc.cfg@20222:<IP SERVER>!acuxdbc04

Looking forward for your feedback.

----------------------------
Claudio Contardi
Product Support Engineer, Senior
Micro Focus
0 Likes
Commander
Commander

Hi @Claudio_Contardi 

I've changed the string and i could advance.

Now i have the following message:

jdbc:vortex://system/manager/xvision:acuxdbc.cfg@20222:<IP SERVER>!acuxdbc04

java.sql.SQLException: VISION: License file '/opt/acucorp/AcuXDBC/bin/xvision.elc' inaccessible
at vortex.sql.vortexConnection.<init>(vortexConnection.java:142)
at vortex.sql.vortexDriver.connect(vortexDriver.java:255)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)
at sample.main(sample.java:30)

i found the file xvision.slc, is there any question of version?

Thanks

0 Likes
Micro Focus Expert
Micro Focus Expert

Excellent!

I am glad to see the connection-string issue is solved.
We'll amend our Documentation accordingly.

In order to work with the JDBC libraries, you need the license for AcuXDBC Enterprise Edition, which generates a file named xvision.elc.

xvision.slc is the license file for AcuXDBC Server, only.

Best Regards.

----------------------------
Claudio Contardi
Product Support Engineer, Senior
Micro Focus
0 Likes
Commander
Commander

@Claudio_ContardiThanks a lot!

 

Regards

Fernando.-

View solution in original post

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.