I have encountered a huge problem. I have an application that is connected to a derby database. I populate my form objects with methods like the one below
The method in question have worked fine until suddenly I received the following error message
I know since earlier that theese errors can occur when you do not put quotes around variables in a query, but here i use parameters so I can't see what goes wrong with the query in question. This is how affected table structure looks like
Oh, a note, I have my tables stored in text files where each line is delimeted with a ";" - mark. I would be very greatful for any kind of help or hint.
Thanks a lot in advance to anyone who has taken time to read this post.
I haven't got a clue on what's going on here with my select statement. The tables are created through a method that parses textfiles so I am pretty sure that the table in this question "tbl_language" really is there. The table has three columns, "id"-column", "name"-column and one "lang"-column.
I have adopted your suggested code change. I agree it was a little bit tricky to read, sorry. I am not sure though what you are meaning with "print or log your sql string" ?
I think I have found out what the problem is. I have tried to read the values from a table that hasn't the lang column in its field list.
Thats why the tbl_agerating showed up in the sql log string, and that table only has a name column. What a miss! I have
to change this right away.
Terribly sorry for this and thank you so much for your kind replies!
Just an FYI: Your close statements should be in the reverse order that the resources were opened in. So, you've got them backwards. 'rs' was the last resource to be opened/created, so it should be the first to be closed().