Oracle Error 17132
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up sql error : Invalid conversion requested using Spring JdbcTemplate prepared statement up vote 1 down vote favorite I am getting the following "Invalid conversion requested" error when tried to insert a row in RECORDERS (oracle 11g) table using spring 3.0.5 JdbcTemplate API. Any help is much appreciated. Error 2013-12-03 19:14:40,125,ERROR,,,http-bio-8080-exec-3,RecorderController,Caught exception: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO RECORDERS(RECORDER_ID,RECORDER_NAME,RECORDER_TYPE,RECORDER_IP,RECORDER_URL,ACTIVE_IND)VALUES(?,?,?,?,?,?)]; SQL state [99999]; error code [17132]; Invalid conversion requested; nested exception is java.sql.SQLException: Invalid conversion requested Here is our RECORDERS table structure Column Length Type Nullable Primary Key RECORDER_ID 3 NUMBER N 1 RECORDER_NAME 20 VARCHAR2 N RECORDER_TYPE 1 CHAR(1) N RECORDER_IP 20 VARCHAR2 N RECORDER_URL 100 VARCHAR2 N ACTIVE_IND 1 CHAR(1) N DAO code: public class RecorderDAOImpl { @Autowired private JdbcTemplate jdbcTemplate; private static String INSERT_SQL="INSERT INTO RSDVR_RECORDERS" + "(RECORDER_ID,RECORDER_NAME,RECORDER_TYPE,RECORDER_IP,RECORDER_URL," + "ACTIVE_IND)VALUES(?,?,?,?,?,?)"; public void register(Recorder recorder) throws DataAccessException{ int nextRowNum = this.getNextRowNum(); char activeInd =this.getActiveIndicator(recorder.getState()); Object[] objArr = new Object[] {nextRowNum,recorder.getName(),recorder.getType().charAt(0), recorder.getIP(),recorder.getURL(),activeInd}; int[] objTypes = new int[]{Types.INTEGER,Types.VARCHAR,Types.CHAR, Types.VARCHAR,Types.VARCHAR,Types.CHAR}; this.jdbcTemplate.update(INSE
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users http://stackoverflow.com/questions/20364926/sql-error-invalid-conversion-requested-using-spring-jdbctemplate-prepared-stat Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Getting “Invalid column type” excecption, while using NamedParameterJDBCTemplate for insertion up vote 4 http://stackoverflow.com/questions/19069170/getting-invalid-column-type-excecption-while-using-namedparameterjdbctemplate down vote favorite 1 I am using below code while inserting a row into database(oracle 10g xe,jar: ojdbc14.jar) String sql = "INSERT INTO SPONSOR_TB(ID,NAME,INDUSTRY_TYPE,IS_REPORTING_SPONSOR,IS_NOT_SOLICITE) VALUES(SEQ_SPONSOR_ID.NEXTVAL,:NAME1,:INDUSTRY_TYPE,:IS_REPORTING_SPONSOR,:IS_NOT_SOLICITE)"; MapSqlParameterSource paramSource = new MapSqlParameterSource(); paramSource.addValue("NAME1",sponsor.getName()); paramSource.addValue("INDUSTRY_TYPE", sponsor.getIndustryType()); paramSource.addValue("IS_NOT_SOLICITE", sponsor.getNotSoliciteFlag()?'Y':'N'); paramSource.addValue("IS_REPORTING_SPONSOR", sponsor.getReportingFlag()?'Y':'N'); KeyHolder generatedKeyHolder = new GeneratedKeyHolder(); namedParameterJdbcTemplate.update(sql, paramSource, generatedKeyHolder,new String[]{"ID"}); int id = generatedKeyHolder.getKey().intValue(); Structure of the table is: create table SPONSOR_TB ( id INTEGER not null, name VARCHAR2(20), industry_type INTEGER not null, is_reporting_sponsor CHAR(1) not null, is_not_solicite CHAR(1) not null ) and SEQ_SPONSOR_ID is sequence And Sponsor class is: public class Sponsor{ private int id; private String name; private boolean reportingFlag; private boolean notSoliciteFlag; private int industryType; //getter setter } And db configuration in spring-servlet.xml is:
can return. The appendix is organized as follows: General Structure of JDBC Error Messages General https://docs.oracle.com/cd/E11882_01/java.112/e16548/apxermsg.htm JDBC Messages Native XA Messages TTC Messages Each of the message lists is first sorted by ORA number, and then alphabetically. See Also: "Processing SQL http://cleanupcomputerreviews.com/error-code-17132-oracle-database.php Exceptions" General Structure of JDBC Error Messages The general JDBC error message structure allows run-time information to be appended to the end of a message, oracle error following a colon, as follows:
of the error: Error Code 17132 Oracle Database This error is usually caused by misconfigured system files. So, from my experience, if you received a Error Code 17132 Oracle Database message then there is a 95% chance that your computer has registry problems. These Windows errors are easy to repair. By downloading and running the registry repair tool RegCure Pro, you can quickly and effectively fix this problem and prevent others from occuring. After fixing the registry, a quick scan with Spyhunter anti-malware tool will ensure that your PC has no more problems! Solution: 1. Error #799 Error Message: Internet Connection Sharing (ICS) cannot be enabled due to an IP address conflict on the network. PC Repairs you manually, in both against cyber-attack your PC problems The full verify - This optimize it's content pane Windows Registry by PC TuneUp Utilities Subscribe For Last version English OS: Windows registry Cleaner Myths Computer Windows Club & Windows 10 Freezing| Google + Youtube LinkedIn Internet Errors. Recomments to maintenance, free full version English 214,634 Total downloads 7 & Vista: Fix Company About Us Contact Customer Computer Next Articles frequent services for Windows 8 Windows Registry Dump Windows them in violation: 1. Simply click the links below for your free download. To Fix the problem you need to follow the 3 steps : STEP 1: Download & Install RegCure Pro for Free to Scan Your PC Choose the "Repair All" Button after the system has finished scanning. STEP 2: Download & Install Spyhunter Malware Removal Tool - Spyhunter will optimize your PC by removing all traces of Adware, Spyware and Malware. Your PC will run much smoother after this process is completed. Choose "Start New Scan" after installing STEP 3: Click the "Repair All" Button and follow directions on screen. That's All! Technical Description of System Error (for Experts only): Microsoft Windows [Version 5.2.4630] (C) Copyright 1985-2014 Microsoft Corp. C:\Documents and Setting