B4J Question Any way to bundle jdbc jars?

[B4JExplorer]

Hi,

I'm able to execute code that accesses an Oracle database, using the AdditionalJar ojdbc6.jar. That's in Debug mode.

But when I set it to Release mode, it's apparently not able to locate the ojdbc6.jar. That happens inside the ide, or from the command line.

I noticed in the generated jar, that ojdbc6.jar isn't included. Which means that I would have to refer to it on the classpath.

Is there any way to bundle the AdditionalJar inside the generated Release Jar?


I know that Launch4J can generate Windows executables. Can it also generate standalone jars?

 

[Erel]

Have you set #MergeLibraries to true? It should embed the additional jars in the compiled jar. See DBUtils for example.

 

[B4JExplorer]

Have you set #MergeLibraries to true? It should embed the additional jars in the compiled jar. See DBUtils for example.

Yep, it's set to true. I had seen the DbUtils post and replicated that. But it's still missing the ojdbc6.jar.

Also, the Additional Libraries path is set to the folder where ojdbc6.jar resides.

 

[Erel]

How do you see that the jar file is not bundled? It can be confusing as the jar file is unpacked and added to all the other classes.

 

[Erel]

You can test it by running DBUtils in Release mode. If it works (and #MergeLibraries is true, which is the default value) then the jar file was included.

 

[B4JExplorer]

Yep, it's set to true. I had seen the DbUtils post and replicated that. But it's still missing the ojdbc6.jar.

Also, the Additional Libraries path is set to the folder where ojdbc6.jar resides.

To clarify further, the error

java.sql.SQLException: No suitable driver found for jdbcracle:thin....

is occurring. It happens in Release mode, and from the command line. But it does not happen, in Debug mode.

 

[Erel]

Does DBUtils work when you run it in Release mode?

 

[B4JExplorer]

Does DBUtils work when you run it in Release mode?

Yes, it does. But I just noticed that even the generated DbUtils.jar doesn't include the sqlite-jdbc-3.7.2.jar. It works, anyway.

 

[Erel]

See my answer in post #4.

This is how the compiled jar file looks:

SQLite jar classes are available under org folder.

 

[B4JExplorer]

Ok, so it actually pulls out the classes from the additional jars, and throw them in the main jar.

Yep, they seem to be inside my generated jar. So the reason for the 'no suitable drive' message, is something else.

Maybe Oracle uses a native dll, which isn't available in the Release mode paths. I'll look around, thanks.

 

[Erel]

You can set #MergeLibraries to False. The jars will not be embedded. However the referenced jars will be added to the main jar manifest file.

So all you need is to copy the referenced jars to a folder named libs and double click on the jar file.

 

[B4JExplorer]

If #MergeLibraries is set to false, then Release mode works in the IDE.

However, on the command line - After creating a libs folder in the generated jar file, and copying the additional jars which were referenced in the manifest, the command line now returns a

java.lang.NoClassDefFoundError: anywheresoftware/b4a/BA

error.


Exception in thread "main" java.lang.NoClassDefFoundError: anywheresoftware/b4a/BA
at java.lang.Class.getDeclaredMethods0(Native Method)
at java.lang.Class.privateGetDeclaredMethods(Class.java:2531)
at java.lang.Class.getMethod0(Class.java:2774)
at java.lang.Class.getMethod(Class.java:1663)
at sun.launcher.LauncherHelper.getMainMethod(LauncherHelper.java:494)
at sun.launcher.LauncherHelper.checkAndLoadMain(LauncherHelper.java:486)
Caused by: java.lang.ClassNotFoundException: anywheresoftware.b4a.BA
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
... 6 more

 

[B4JExplorer]

Got it. Resolved, thanks Erel.