B4J Question jRDC2 using JDBC driver with embedded file

cliv · May 10, 2019

I try to create a jRDC server using a JDBC driver (cData) for a friend.

Creating a JDBC Data Source
Create a JDBC data source to connect from your Java application. Creating a JDBC data source based on the CData JDBC Driver consists of three basic steps:

Add the driver JAR to the classpath:
The JAR is located in the lib subfolder of the installation directory. Note that the .lic file must be located in the same folder as the JAR.

Provide the driver class:
cdata.jdbc.XXX

Provide the JDBC URL. For example:
jdbc:XXX:dataSource=C:\\mydb
The URL must start with "jdbc:XXX:" and can include any of the connection properties in name-value pairs separated with semicolons.

Driver have 2 additional file to be located in the lib subfolder of the installation directory.
("The JAR is located in the lib subfolder of the installation directory. Note that the .lic file must be located in the same folder as the JAR.")

B4X:

cdata.jdbc.XXX.jar cdata.jdbc.XXX.lic cdata.jdbc.XXX.remoting.ini

Driver file can be added in code with:

B4X:

#AdditionalJar:cdata.jdbc.XXX

...but how to add .lic file and .ini file?

cliv · May 10, 2019

I think that's the right way...yes?

"Erel, post: Create a zip file with a folder named lib and the files inside it.
Rename it to MyAdditionalDlls.JAR, put it in the additional libraries folder and add a reference with #AdditionalJar: MyAdditionalDlls

https://www.b4x.com/android/forum/threads/how-to-add-addtional-jar-into-exe-file.91458/#post-577766

... I'm not home so I can not test it until Monday!

EnriqueGonzalez · May 10, 2019

Hi! you could try
https://www.b4x.com/android/forum/threads/modules-attributes.35451/

the merging libraries attribute, so the cdata.jar will not be inside the jar file but aside, then you technically needs the other 2 files beside the jar.

cliv · May 11, 2019

merging libraries attribute

Yes, you are right, but then .lic file will be visible to everyone.

B4J Question jRDC2 using JDBC driver with embedded file

cliv

Member

cliv

Member

EnriqueGonzalez

Expert

cliv

Member

Similar Threads

B4J Question jRDC2 using JDBC driver with embedded file

cliv

Member

cliv

Member

EnriqueGonzalez

Expert

cliv

Member

Similar Threads

Privacy & Transparency

Privacy & Transparency