AcuXdbcs from Java

[fbenedic]

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.-

[Claudio_Contardi]

Good morning, @fbenedic 

Can you try this syntax?

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

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

[Claudio_Contardi]

@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.

[fbenedic]

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

[Claudio_Contardi]

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.

[fbenedic · Accepted solution]

@Claudio_ContardiThanks a lot!

Regards

Fernando.-