I'm stuck in the final stage of a project I've been working for the last weeks. I'm trying to get Processing to display a map I've made with TileMill, which is stored in a .mbtiles SQLite database. So far it has worked pretty fine running the app in the IDE, but when deploying the Applet in my website the DB isn't found. I believe it's because I'm trying to use a URL to get the DB.

I'm using Unfolding Maps. One of its classes uses the sqlitejdbc driver to get the DB. This is my code. If you take a look at the strings JDBC_CONN_STRING_TABLE and JDBC_CONN_STRING_TABLE, those are the ideal paths to connect to the DB. The local one works. The URL doesn't.

Which do you think would be the best way to access the database? Thanks!!

2. import de.fhpotsdam.unfolding.mapdisplay.*;
3. import de.fhpotsdam.unfolding.utils.*;
4. import de.fhpotsdam.unfolding.marker.*;
5. import de.fhpotsdam.unfolding.tiles.*;
6. import de.fhpotsdam.unfolding.interactions.*;
7. import de.fhpotsdam.unfolding.*;
8. import de.fhpotsdam.unfolding.core.*;
9. import de.fhpotsdam.unfolding.geo.*;
10. import de.fhpotsdam.unfolding.events.*;
11. import de.fhpotsdam.utils.*;
12. import de.fhpotsdam.unfolding.providers.*;
13. import processing.opengl.*;
14. import codeanticode.glgraphics.GLConstants;
15. 
    
16. import java.util.Map;
17. 
    
18. de.fhpotsdam.unfolding.Map map;
19. public static final String JDBC_CONN_STRING_TABLE = "jdbc:sqlite:http://dansd.com/sflive/SF.mbtiles";
20. // Connection to SQLite/MBTiles in dev environment (link to the project)http://dansd.com/sflive/SF.mbtiles
21. public static final String JDBC_CONN_STRING_MAC = "jdbc:sqlite:/SF.mbtiles";
22. 
    
23. 
    
24. 
    
25. ArrayList coordinates,copyc;
26. float[] mightymarblesx, mightymarblesy, rem;
27. int timestart, elapsed;
28. String[] stations, code,seconds;
29. PImage mapa, tram;
30. boolean refresh=true;
31. PFont fonti;
32. void setup() {
33.   size(1126, 481);
34.   mapa=loadImage("map.png");
35.   tram=loadImage("tram.png");
36.   timestart=second()+minute()*60;
37.   ArrayList preds=predictionsurl();
38.   HashMap lista=(HashMap)preds.get(1);
39.   HashMap thelist=(HashMap)preds.get(0);
40.   HashMap fleet=listofservices(preds);
41.   smooth();
42.   coordinates=coords(lista, fleet);
43.   mightymarblesx=new float[coordinates.size()];
44.   mightymarblesy=new float[coordinates.size()];
45.   seconds=new String[coordinates.size()];
46.   
47.   fonti=loadFont("helb.vlw");
48.   
49.   map = new de.fhpotsdam.unfolding.Map(this, new de.fhpotsdam.unfolding.providers.MBTilesMapProvider(JDBC_CONN_STRING_MAC));
50.   map.zoomAndPanTo(new Location(37.7664,-122.446),13);
51.   MapUtils.createDefaultEventDispatcher(this, map);
52.   map.setZoomRange(12, 16);
53. }
54. void draw(){
55.   map.draw();
56.   elapsed=(second()+minute()*60)-timestart;
57.   if (elapsed>5) {
58.     refresh=true;
59.   }
60.   updateposition();
61.   for (int i=0;i<mightymarblesx.length;i++) {
62.     Location vehloc=new Location(mightymarblesx[i],mightymarblesy[i]);
63.     float xy[]=map.getScreenPositionFromLocation(vehloc);    
64.     fill(255);
65.     if (dist(xy[0],xy[1],mouseX,mouseY)<=5){ 
66.       fill(255,0,0);
67.       int longi=-220;
68.       ellipse(xy[0],xy[1],5,5);
69.       fill(234,232,232);
70.       rect(xy[0]-3,xy[1]-3,longi,-70);
71.       PImage linem=loadImage(seconds[i].split(",")[2].substring(0,1)+".png");
72.       image(linem,xy[0]+longi+10,xy[1]-60,50,50);
73.       fill(0);
74.       text("Will arrive in "+seconds[i].split(",")[0].substring(0,seconds[i].split(",")[0].indexOf("."))+" seconds \nto "+seconds[i].split(",")[1],xy[0]+longi+65,xy[1]-50);
75.       textFont(fonti,10);
76.       text("Will arrive in "+seconds[i].split(",")[0].substring(0,seconds[i].split(",")[0].indexOf("."))+" seconds \nto "+seconds[i].split(",")[1],xy[0]+longi+65,xy[1]-50);
77.     }
78.     else{
79.     ellipse(xy[0],xy[1],5,5);
80.     }
81.   }
82. }
83. void updateposition(){
84.   if (refresh) {
85.     try{
86.     if (code[0].equals(loadStrings("ID.csv")[0])==false) {
87.       code=loadStrings("ID.csv");
88.       try {
89.         timestart=second()+minute()*60;
90.         mightymarblesx=new float[coordinates.size()];
91.         mightymarblesy=new float[coordinates.size()];
92.         seconds=new String[coordinates.size()];
93.         ArrayList preds=predictionsurl();
94.         HashMap lista=(HashMap)preds.get(1);
95.         HashMap thelist=(HashMap)preds.get(0);
96.         HashMap fleet=listofservices(preds);
97.         coordinates=coords(lista, fleet);
98.         println("now");
99.       }
100.       catch (Exception e) {
101.         coordinates=copyc;
102.       }
103.     }
104.     
105.       }catch (Exception e) {}
106.     copyc=coordinates;
107.     refresh=false;
108.   }
109.   for(int i=0;i<coordinates.size();i++){
110.     ArrayList thislist=(ArrayList)coordinates.get(i);
111.     for(int t=0;t<thislist.size();t++){
112.       String timestamp=(String)thislist.get(7);
113.       String[] hour= split(timestamp," ");
114.       float timebefore= float(hour[0])*60+float(hour[1]);
115.       float timenow= minute()*60+second();
116.       float actual=timenow-timebefore;
117.       String stationcode=(String)thislist.get(0);
118.       Integer secondas=(Integer)thislist.get(1);
119.       int secs=secondas.intValue();
120.       Integer totsecondas=(Integer)thislist.get(2);
121.       int totseconds=totsecondas.intValue();
122.       String lat=(String)thislist.get(3);
123.       String lon=(String)thislist.get(4);
124.       String lat2=(String)thislist.get(5);
125.       String lon2=(String)thislist.get(6);
126.       String name=(String)thislist.get(8);
127.       String linea=(String)thislist.get(9);
128.       float cartesianlat=map(secs-actual, totseconds, 0, float(lat), float(lat2));
129.       float cartesianlon=map(secs-actual, totseconds, 0, float(lon), float(lon2));
130.       mightymarblesx[i]=cartesianlat;
131.       mightymarblesy[i]=cartesianlon;
132.       seconds[i]=str(secs-actual)+","+name+","+linea;
133.     }
134.   }
135. }