Recently, I often touch the JSP page error, return to see WebLogic error record, such as display:
INSERT INTO PM_AIR_CONDITION (Air_Condition_ID, Install_Position, Equipment_Type, PR
Oduce_Factory, Install_time, Air_Condition_capacition, Cabinet_air_Condition, Adding
_damp, equipment_number, stakeout_service, technique_data, service_state, technique_l
Evel, Creat, Create_Date, DePt_no) Values (?,?,?,?, to_date (?, 'YYYY-MM-DD HH24: MI:
SS '),?,?,?,?,?,?,?,?,?, To_date (?,' YYYY-MM-DD HH24: MI: SS '),?)
Java.sql.sqlexception: ORA-00904: Invalid column name
Because I know the invalid column name, I am looking for a suitable location in Bean, but if the field is more, a look is very troublesome, and this error code is available behind? Directly copy the record directly to Toad Then don't do it.
At this time, we can quickly find the small error caused by the "invalid column name" in Toad, edit a small SQL statement.
select air_condition_id, install_position, equipment_type, produce_factory, install_time, air_condition_capacition, cabinet_air_condition, adding_damp, equipment_number, stakeout_service, technique_data, service_state, technique_level, creator, create_date, dept_no from pm_air_condition
The "From Table name" will quickly find the wrong field, and you will have a bright language in Toad, it is really a convenient and quick way.
I have to learn there.I, the experience is still lacking!
