Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Retrieve data from SQLite Database
-
Hi everyone,
I want to create a SQL Datasource and use a SQLite database. I've done it with a MySQL Database and it works perfectly well.
I tried to search on the board and I found that I need to add the driver in WEB-INF/lib. So i downloaded the SQLiteJDBC (3.7.2) and i added it in the lib folder.
I would like to know if it was the right thing to do and then, what should i do now? Do i need to modify some files (i guess i have to) ? Is there a documentation explaining how to add another sql driver to Mango ?Best regards,
P.S : Sorry for my english, i'm not fluent
-
Correct so far. A quick search suggests that the driver class name for sqlite is org.sqlite.JDBC. I think that is all you should need.
-
Ok thanks, I'll try and come back if i have a problem.
-
I do not have a username & password for my sqlite db and how should i formulate the connection string? Please help.
Thanks so much!
Anirudh
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login