> Am using SQLite jdbc 3.7.2 and in a scenario i have a table with 2300 column
> which eventually throwed too many columns exception since the maximum
> allowed column count is 2000.
> Is there any workaround available for this? Maybe a query to increase column
> limit in SQLite jdbc?
I cannot conceive of any way to hold the definitions of 2300 columns in your head at one time. Therefore your database is badly designed.
It might be worth remembering that given the design of SQLite, if you need the value of column 1900 of a specific row, SQLite has to read 1900 values in order to find that value.
Are these columns numbered ? If so, you have a relational database and should be using a related table.
Do the columns come in sets (e.g. 23 sensors each measuring 100 things) ? If so, you still have a relational database and should be using a table (e.g. of sensors) a relation.
I do understand its a bad DB design and i should be actually doing what you have mentioned. But as mentioned in SQLite site it is possible to increase column limit during compile time. So i just need to know out of curiosity how it can be done in SQLite jar (jdbc) 3.7.2?