Unable to add rows to new/existing tables
Description
Environment
Observations
When we create a new table it works fine. But when we try to add rows to it, it fails with Error : The row couldn't be created. I tried switching off the audit trial as well but no luck. I have attached stack trace and screenshot.
Attachments
Requirement Yogi
Activity
Adrien Ragot (Old account)March 15, 2016 at 3:33 PM
Ok,
It's great feedback, Hari, it means displaying the Postgres version when installing would help users a great deal.
Best regards,
Adrien
Hari PrabhuMarch 15, 2016 at 3:28 PM
Hi Adrien,
Sorry for delay in coming back to you. Yes I had one more postgres jar in /home directory (not in Confluence home). It's weird that when I removed that jar file and restarted Confluence it started working. I think it is the restart of Confluence that helped the issue rather than removing the jar file. It's all working now. Thanks for your help.
Regards,
Hari
Adrien Ragot (Old account)March 11, 2016 at 2:00 PM
Can you try to search for all postgres*.jar files in your Confluence installation directory and your Confluence home directory? You don't need to restart to confirm it works right now, I would just be happy if you confirm there are several .jar files. Thank you.
Adrien Ragot (Old account)March 7, 2016 at 5:10 PM
Hi Hari,
I don't reproduce this issue with a clean installation of Confluence 5.8.14, Play SQL 2.11.4 and postgresql-9.4-1202.jdbc41.jar.
The log says the class ByteConverter is missing. It was introduced in version 9.2 of the driver. Since you have migrated from an older Confluence, you might still have another version of the Postgres driver in the installation directory or in the data folder. Could you please check this?
Thank you,
Adrien
Hari PrabhuMarch 4, 2016 at 1:55 PM
Thanks Adrien.
Confluence 5.8.14 JDBC - 4.1