Scripts and Java and MS Access

Hi,

I have an overnight script that imports data from an MS Access query into a list, this worked fine with the old certs and the 1-3-3-3 environment. Now I have had to update my scripts and use 1.4.2 and there seems to be a problem with the url.

Old script

-jdbcurl "jdbc:odbc:EPOS" -jdbcquery "SELECT * FROM qry_EPOSLive"

-jdbcurl has been dropped as a valid option in a script, and therefore I have to create a properties file, which I have done.

Properties file top line now reads

jdbc.connect.url = jdbc:odbc:EPOS

However, when I run the script I am getting the following error

Anaplan API: Could not connect to database! (SQL: No suitable driver found for jdbc:odbc:EPOS)

What do I need to do to correct this, as we run this script every night and it is vital to our data set.

thanks

Accepted answers

All comments

ben_speight

It looks like you're making use of the JDBC-ODBC bridge driver which was discontinued by Oracle from Java 8 onwards. There exists at least one commercial drop-in replacement, you may be able to rip the existing one out of Java 7 (very fiddly and not at all recommended), or you can use a direct JDBC driver (such as UCanAccess) that avoids ODBC and opens the Access database directly - in which case the JDBC URL will be different.

DeveloperCYT

Thanks, we went to Java 8 a long time ago, and scripts have been running just fine with the bridge.

It's only since moving to Anapaln 1.4.2 scripts (yesterday) that has caused problems

I have removed the Access requirement now, and created csv files from access separately using Scheduler, then importing using a script, seemed like a sensible move.

thanks for response

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385