Can i use table column in Sqlite database as a resource variable?
up vote
0
down vote
favorite
i have some code like this
Orignally:
String path = "android.resource://" + getPackageName() + "/" + R.raw.video;
videoView.setVideoURI(Uri.parse(path));
videoView.requestFocus();
videoView.start();
And the videoView works perfectly.
Then I changed the code into
String path = "android.resource://" + getPackageName() + "/" + Dbhelper.COLUMN_Path;
videoView.setVideoURI(Uri.parse(path));
videoView.requestFocus();
videoView.start();
I stored "R.raw.video" into the COLUMN.Path in the database. It works. But why the videoView doesnt work? It told me "Cant play this video"
android database sqlite 
android-studio asked Nov 22 at 17:10
dead pooh
31
add a comment |
up vote
0
down vote
favorite
i have some code like this
Orignally:
String path = "android.resource://" + getPackageName() + "/" + R.raw.video;
videoView.setVideoURI(Uri.parse(path));
videoView.requestFocus();
videoView.start();
And the videoView works perfectly.
Then I changed the code into
String path = "android.resource://" + getPackageName() + "/" + Dbhelper.COLUMN_Path;
videoView.setVideoURI(Uri.parse(path));
videoView.requestFocus();
videoView.start();
I stored "R.raw.video" into the COLUMN.Path in the database. It works. But why the videoView doesnt work? It told me "Cant play this video"
android database sqlite android-studio asked Nov 22 at 17:10
dead pooh
31
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
i have some code like this
Orignally:
String path = "android.resource://" + getPackageName() + "/" + R.raw.video;
videoView.setVideoURI(Uri.parse(path));
videoView.requestFocus();
videoView.start();
And the videoView works perfectly.
Then I changed the code into
String path = "android.resource://" + getPackageName() + "/" + Dbhelper.COLUMN_Path;
videoView.setVideoURI(Uri.parse(path));
videoView.requestFocus();
videoView.start();
I stored "R.raw.video" into the COLUMN.Path in the database. It works. But why the videoView doesnt work? It told me "Cant play this video"
android database sqlite android-studio asked Nov 22 at 17:10
dead pooh
31
i have some code like this
Orignally:
String path = "android.resource://" + getPackageName() + "/" + R.raw.video;
videoView.setVideoURI(Uri.parse(path));
videoView.requestFocus();
videoView.start();
And the videoView works perfectly.
Then I changed the code into
String path = "android.resource://" + getPackageName() + "/" + Dbhelper.COLUMN_Path;
videoView.setVideoURI(Uri.parse(path));
videoView.requestFocus();
videoView.start();
I stored "R.raw.video" into the COLUMN.Path in the database. It works. But why the videoView doesnt work? It told me "Cant play this video"
android database sqlite android-studio android database sqlite android-studio asked Nov 22 at 17:10
dead pooh
31
asked Nov 22 at 17:10
dead pooh
31
asked Nov 22 at 17:10
dead pooh
31
asked Nov 22 at 17:10
dead pooh
31
asked Nov 22 at 17:10
dead pooh
31
31
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
accepted
If you stored the integer value of R.raw.video then this is an integer number that the system assigned the this resource video file when the project was compiled.
I believe you retrieved it at runtime and saved it to the db.
This integer value is valid as long as you use the apk built at the time of that compilation.
But if you make any changes (especially to your resources) and recompile, there is no guarantee that this value will still be valid and correspond to this resource, because resource values may be reassigned new values.
So your way is wrong.
One way to solve this issue is to store in the db the string "name" of the resource, meaning: "video" (not the fully qualified R.raw.video).
Now when you want to retrieve the file from the raw folder,
after you get the value from the db to a variable like videoName, do this:
int id = getResources().getIdentifier(videoName, "raw", getPackageName());
This is the way to retrieve the integer id of the resource named videoName which resides in the raw folder.
If your code is not inside an activity you need to supply a valid Context, like this:
int id = context.getResources().getIdentifier(videoName, "raw", context.getPackageName());
and finally:
String path = "android.resource://" + getPackageName() + "/" + id;
Edit
If you stored R.raw.video as a string in db, then this cannot help you because this full string has no value assigned to it as I explained earlier.
answered Nov 22 at 17:40
forpas
6,3281218
I completely do as you said, but still it doesn't work!! Why?
– dead pooh
Nov 22 at 17:57
i have already sure that i got the correct value from the db, exactly the same name of that resource,
– dead pooh
Nov 22 at 18:00
Then put a breakpoint at the lineint id =.....and check if you get a valid id and then if this lineString path = "android.resource://" + getPackageName() + "/" + id;is valid
– forpas
Nov 22 at 18:02
the id becomes 0
– dead pooh
Nov 22 at 18:20
there for it becomes android.resource://getPackageName()/0
– dead pooh
Nov 22 at 18:23
|
show 9 more comments
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53435651%2fcan-i-use-table-column-in-sqlite-database-as-a-resource-variable%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
accepted
If you stored the integer value of R.raw.video then this is an integer number that the system assigned the this resource video file when the project was compiled.
I believe you retrieved it at runtime and saved it to the db.
This integer value is valid as long as you use the apk built at the time of that compilation.
But if you make any changes (especially to your resources) and recompile, there is no guarantee that this value will still be valid and correspond to this resource, because resource values may be reassigned new values.
So your way is wrong.
One way to solve this issue is to store in the db the string "name" of the resource, meaning: "video" (not the fully qualified R.raw.video).
Now when you want to retrieve the file from the raw folder,
after you get the value from the db to a variable like videoName, do this:
int id = getResources().getIdentifier(videoName, "raw", getPackageName());
This is the way to retrieve the integer id of the resource named videoName which resides in the raw folder.
If your code is not inside an activity you need to supply a valid Context, like this:
int id = context.getResources().getIdentifier(videoName, "raw", context.getPackageName());
and finally:
String path = "android.resource://" + getPackageName() + "/" + id;
Edit
If you stored R.raw.video as a string in db, then this cannot help you because this full string has no value assigned to it as I explained earlier.
answered Nov 22 at 17:40
forpas
6,3281218
I completely do as you said, but still it doesn't work!! Why?
– dead pooh
Nov 22 at 17:57
i have already sure that i got the correct value from the db, exactly the same name of that resource,
– dead pooh
Nov 22 at 18:00
Then put a breakpoint at the lineint id =.....and check if you get a valid id and then if this lineString path = "android.resource://" + getPackageName() + "/" + id;is valid
– forpas
Nov 22 at 18:02
the id becomes 0
– dead pooh
Nov 22 at 18:20
there for it becomes android.resource://getPackageName()/0
– dead pooh
Nov 22 at 18:23
|
show 9 more comments
up vote
0
down vote
accepted
If you stored the integer value of R.raw.video then this is an integer number that the system assigned the this resource video file when the project was compiled.
I believe you retrieved it at runtime and saved it to the db.
This integer value is valid as long as you use the apk built at the time of that compilation.
But if you make any changes (especially to your resources) and recompile, there is no guarantee that this value will still be valid and correspond to this resource, because resource values may be reassigned new values.
So your way is wrong.
One way to solve this issue is to store in the db the string "name" of the resource, meaning: "video" (not the fully qualified R.raw.video).
Now when you want to retrieve the file from the raw folder,
after you get the value from the db to a variable like videoName, do this:
int id = getResources().getIdentifier(videoName, "raw", getPackageName());
This is the way to retrieve the integer id of the resource named videoName which resides in the raw folder.
If your code is not inside an activity you need to supply a valid Context, like this:
int id = context.getResources().getIdentifier(videoName, "raw", context.getPackageName());
and finally:
String path = "android.resource://" + getPackageName() + "/" + id;
Edit
If you stored R.raw.video as a string in db, then this cannot help you because this full string has no value assigned to it as I explained earlier.
answered Nov 22 at 17:40
forpas
6,3281218
I completely do as you said, but still it doesn't work!! Why?
– dead pooh
Nov 22 at 17:57
i have already sure that i got the correct value from the db, exactly the same name of that resource,
– dead pooh
Nov 22 at 18:00
Then put a breakpoint at the lineint id =.....and check if you get a valid id and then if this lineString path = "android.resource://" + getPackageName() + "/" + id;is valid
– forpas
Nov 22 at 18:02
the id becomes 0
– dead pooh
Nov 22 at 18:20
there for it becomes android.resource://getPackageName()/0
– dead pooh
Nov 22 at 18:23
|
show 9 more comments
up vote
0
down vote
accepted
up vote
0
down vote
accepted
If you stored the integer value of R.raw.video then this is an integer number that the system assigned the this resource video file when the project was compiled.
I believe you retrieved it at runtime and saved it to the db.
This integer value is valid as long as you use the apk built at the time of that compilation.
But if you make any changes (especially to your resources) and recompile, there is no guarantee that this value will still be valid and correspond to this resource, because resource values may be reassigned new values.
So your way is wrong.
One way to solve this issue is to store in the db the string "name" of the resource, meaning: "video" (not the fully qualified R.raw.video).
Now when you want to retrieve the file from the raw folder,
after you get the value from the db to a variable like videoName, do this:
int id = getResources().getIdentifier(videoName, "raw", getPackageName());
This is the way to retrieve the integer id of the resource named videoName which resides in the raw folder.
If your code is not inside an activity you need to supply a valid Context, like this:
int id = context.getResources().getIdentifier(videoName, "raw", context.getPackageName());
and finally:
String path = "android.resource://" + getPackageName() + "/" + id;
Edit
If you stored R.raw.video as a string in db, then this cannot help you because this full string has no value assigned to it as I explained earlier.
answered Nov 22 at 17:40
forpas
6,3281218
If you stored the integer value of R.raw.video then this is an integer number that the system assigned the this resource video file when the project was compiled.
I believe you retrieved it at runtime and saved it to the db.
This integer value is valid as long as you use the apk built at the time of that compilation.
But if you make any changes (especially to your resources) and recompile, there is no guarantee that this value will still be valid and correspond to this resource, because resource values may be reassigned new values.
So your way is wrong.
One way to solve this issue is to store in the db the string "name" of the resource, meaning: "video" (not the fully qualified R.raw.video).
Now when you want to retrieve the file from the raw folder,
after you get the value from the db to a variable like videoName, do this:
int id = getResources().getIdentifier(videoName, "raw", getPackageName());
This is the way to retrieve the integer id of the resource named videoName which resides in the raw folder.
If your code is not inside an activity you need to supply a valid Context, like this:
int id = context.getResources().getIdentifier(videoName, "raw", context.getPackageName());
and finally:
String path = "android.resource://" + getPackageName() + "/" + id;
Edit
If you stored R.raw.video as a string in db, then this cannot help you because this full string has no value assigned to it as I explained earlier.
answered Nov 22 at 17:40
forpas
6,3281218
edited Nov 22 at 17:52
answered Nov 22 at 17:40
forpas
6,3281218
answered Nov 22 at 17:40
forpas
6,3281218
answered Nov 22 at 17:40
forpas
6,3281218
6,3281218
I completely do as you said, but still it doesn't work!! Why?
– dead pooh
Nov 22 at 17:57
i have already sure that i got the correct value from the db, exactly the same name of that resource,
– dead pooh
Nov 22 at 18:00
Then put a breakpoint at the lineint id =.....and check if you get a valid id and then if this lineString path = "android.resource://" + getPackageName() + "/" + id;is valid
– forpas
Nov 22 at 18:02
the id becomes 0
– dead pooh
Nov 22 at 18:20
there for it becomes android.resource://getPackageName()/0
– dead pooh
Nov 22 at 18:23
|
show 9 more comments
I completely do as you said, but still it doesn't work!! Why?
– dead pooh
Nov 22 at 17:57
i have already sure that i got the correct value from the db, exactly the same name of that resource,
– dead pooh
Nov 22 at 18:00
Then put a breakpoint at the lineint id =.....and check if you get a valid id and then if this lineString path = "android.resource://" + getPackageName() + "/" + id;is valid
– forpas
Nov 22 at 18:02
the id becomes 0
– dead pooh
Nov 22 at 18:20
there for it becomes android.resource://getPackageName()/0
– dead pooh
Nov 22 at 18:23
I completely do as you said, but still it doesn't work!! Why?
– dead pooh
Nov 22 at 17:57
I completely do as you said, but still it doesn't work!! Why?
– dead pooh
Nov 22 at 17:57
i have already sure that i got the correct value from the db, exactly the same name of that resource,
– dead pooh
Nov 22 at 18:00
i have already sure that i got the correct value from the db, exactly the same name of that resource,
– dead pooh
Nov 22 at 18:00
Then put a breakpoint at the line
int id =..... and check if you get a valid id and then if this line String path = "android.resource://" + getPackageName() + "/" + id; is valid– forpas
Nov 22 at 18:02
Then put a breakpoint at the line
int id =..... and check if you get a valid id and then if this line String path = "android.resource://" + getPackageName() + "/" + id; is valid– forpas
Nov 22 at 18:02
the id becomes 0
– dead pooh
Nov 22 at 18:20
the id becomes 0
– dead pooh
Nov 22 at 18:20
there for it becomes android.resource://getPackageName()/0
– dead pooh
Nov 22 at 18:23
there for it becomes android.resource://getPackageName()/0
– dead pooh
Nov 22 at 18:23
|
show 9 more comments
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53435651%2fcan-i-use-table-column-in-sqlite-database-as-a-resource-variable%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
