Database ORALCE 9i version 9.2.0.1.0server: WebLogic 814 Database connection: Hibernate3 DataSource ConnectionPool
Question: I occasionally inserting a blog object into the database (not every time, the phenomenon is the first time no error, then each error) error, the error is exception: {Org.springframework.jdbc.uncategorizedsqlexception: Hibernate Operation: Could not execute JDBC batch update: encountered SQLException [ORA-01483: invalid length for DATE or NUMBER bind variable]; nested exception is java.sql.BatchUpdateException: ORA-01483: invalid length for DATE or NUMBER bind variable.java.sql. BatchUpdateException: ORA-01483: Invalid Length for date or number bind variable
Cause Analysis: After this problem, the org.springframework.jdbc.datasource.driverManagerDataSource provided by Spring is not a problem, because the DataSource ConnectionPool configured on Server is used, the database driver is Server selection. of. Find, Server selection is% bea_home% / weblogic81 / server / lib / ojdbc14.jar (Version 10.1.6.6). This problem no longer appears in the drive in the classpath.
Solution: Use Version to 10.1.0.4.0 Ojdbc.jar instead of% bea_home% / weblogic81 / server / lib / ojdbc14.jar.