E
esmeralda sanches levario
Guest
I have a problem with prepared statements in jdbc against an OpenEdge database, when we get the following exception: java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Column Namn in table PUB.Brevlada has value exceeding its max length or precision.
I'm well aware of the fix for this with DBTool but I have another question. When we have used the prepared statement and got this Exception it can't be used again to fetch other entries in the table that hasn't got the width problem. We then get a slightly different exception:
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Column %s in table %s has value exceeding its max length or precision (7864)
Is this a problem with the SQL Statement Cache on the server and is there any workaround for this except fo reinitialization of the jdbc connection to the database?
Continue reading...
I'm well aware of the fix for this with DBTool but I have another question. When we have used the prepared statement and got this Exception it can't be used again to fetch other entries in the table that hasn't got the width problem. We then get a slightly different exception:
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Column %s in table %s has value exceeding its max length or precision (7864)
Is this a problem with the SQL Statement Cache on the server and is there any workaround for this except fo reinitialization of the jdbc connection to the database?
Continue reading...