Shulou(Shulou.com)06/01 Report--

ORA-00911: invalid character problem case and solution? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

1. The original java insert database table data is written like this.

String sql = "INSERT INTO AAA (id1,id2,id3,id4) VALUES;"; baseDao.exexuteBySql (sql)

2. The baseDao.exexuteBySql method called is like this

Public int exexuteBySql (String sql) throws Exception {try {log.debug ("sql: {}", sql); SQLQuery query = null; Session session = this.getHibernateTemplate (). GetSessionFactory (). GetCurrentSession (); query = session.createSQLQuery (sql); return query.executeUpdate ();} catch (RuntimeException re) {log.error ("exexuteBySql (String sql)", re) Throw re;}}

3. My database is oracle11g, and when executing, an error ORA-00911: invalid character is reported.

4. Remove the ";" at the end of sql.

String sql = "INSERT INTO AAA (id1,id2,id3,id4) VALUES"; baseDao.exexuteBySql (sql)

Thank you for reading! After reading the above, do you have a general understanding of ORA-00911: invalid character problem cases and solutions? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.