I have added a new column to a database table which is already used as a data source in spotfire .

[Harry Harry]

Hi,I have added a new column to a database table which is already used as a data source in spotfire . How can iI refresh the table to show the new column in data source

/H

[Manoj Chaurasia]

Thanks Addy . Actually i did that but still it was not showing up and I am also aware of the process to add that in IL . Even I was expecting it to be showing when I do the refresh .

But when I once again made the connection to the database for that data source ( i just gave the password and saved it again as-is) the new column was showing ..

[Manoj Chaurasia]

What JDBC driver are you using

If it's Datadirect, then I would recommend you to switch to vendor specific JDBC drivers.

[Aditya Singh 3]

Yes, you might be using oracle datadirect driver, instead of this you have to use oracle jdbc driver which you can configure at configuration tool. I also faced exactly same issue two weeks back and based on Pavan's suggestion I changed my driver and all is well after that.

[Aditya Singh 3]

Refresh the datasource under Information designer, the column will be shown in table but it won't come automatically in IL. For this you have to add the required column manually by editing the IL.

[Ali El Shaia]

If you need to show the new columns in an existing report as well, you need to use "File -> Repalce Data" with your newly edited Information Link.

If the new columns are not showing up in the data source after refreshing, in Information Designer, it might be the cache that is the culprit. Try changing the min or max number of connections, then change it back to what it was, this should have enabled the "Save" button that will release the cache and read everything a new.

[christopher sawtelle 2]

To expand on Addy's comment once the columns show in the data source you will need to add them as new column elements where your other column elements are, then you can add those to the infolink.

Once added to the infolink try and reload the table and see if the columns are added. Generally they will be added with out any fuss. No need to replace data table.

[Hannelore Schmidt]

Restart the spotfire server, then you can see the new field.

[Alexis IW]

This worked. After waiting and refreshing at multiple levels, the data source did not display the new columns until I did this.