<< StringUtils | Home | visual rules 4: maven integration >>

RSS | Atom | E-mail

Navigate

Categories | Tags | Advanced Search

Tags

Recent Blog Entries

latest ibatis 2 documentation
With the move of the iBATIS persistence framework from apache to google code and the rename to mybatis it got a little bit complicated for end users of iBATIS 2.x to get the latest iBATIS 2 documentation documents...Read more...Tags : ibatis mybatis
Integration of SocialEngine with external user administration
I recently had the task to integrate a SocialEngine installation with an external user administration system (written in PHP). Social Engine users should be automatically created/enabled/disa...
mockito, spring & AbstractJUnit4SpringContextTests
I know some people consider it bad practise. But nethertheless I still believe that there is sometimes no alternative to tests that include startup of spring application contexts and initialization of in memory database. Actually I quite like those tests ...

Recent Responses

Re: ORA-00911: invalid character
Thanks very munch its working
Re: ORA-00911: invalid character
thanks... helped a lot..
Re: ORA-00911: invalid character
Thanks a lot. It Worked

Summary of blogs

Kai`s Blog

Kai`s Blog - deutschsprachiges Blog über Java, Software, Filme und mehr...

Kai`s Blog - yet another blog about java, software, movies and more...

ORA-00911: invalid character

So you've created unit test for your ibatis sqlmaps based DAOs with an in memory database like hsqldb but when it comes to the real live you are getting exceptions like the this?

Easy solution: make sure you don't have a ; character at the end of your statement. Hsql ignores this but oracle does not.

Responses[11]

Posted by Kai Grabfelder on January 26, 2008 2:48:00 PM CET #

Re: ORA-00911: invalid character

Comment from Anonymous on July 5, 2009 6:47:20 PM CEST #

Hi, It is working for me. I spent much time to solve finally just i made a google search and got this solution. Thank you very much.

Re: ORA-00911: invalid character

Comment from Christopher Hotchkiss on September 21, 2009 5:28:32 PM CEST #

Thank you very much for your tip! (Fixed a nasty issue for me).

Re: ORA-00911: invalid character

Comment from Anonymous on December 5, 2009 1:57:50 AM CET #

Thank you, i took almost 1 hr to figure out.

Re: ORA-00911: invalid character

Comment from Anonymous on August 24, 2010 3:00:16 PM CEST #

Thanks.

Re: ORA-00911: invalid character

Comment from Anonymous on October 4, 2010 6:05:12 PM CEST #

Thank you... I spent lot of time because of a ; .. Thank god finally I searched on google and find it

Re: ORA-00911: invalid character

Comment from Barnes on February 4, 2011 3:32:06 PM CET #

You saved my day. Thanks

Re: ORA-00911: invalid character

Comment from Anonymous on September 2, 2011 8:44:46 PM CEST #

The best answer i've ever seen. You saved me a lot of time and cheer me up the rest of day and the long weekend. Thanks much!

Re: ORA-00911: invalid character

Comment from Anonymous on September 21, 2011 7:02:08 PM CEST #

Thanks. I didn't notice this very small error. It should have taken hours to find out by myself.

January 2008
Sun	Mon	Tue	Wed	Thu	Fri	Sat
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31
Dec \| Today \| Feb

2012 May (0) April (0) March (0) February (0) January (0)	2011 December (0) November (0) October (1) September (0) August (0) July (1) June (0) May (0) April (1) March (0) February (0) January (0)
2010 December (2) November (1) October (0) September (0) August (1) July (0) June (1) May (0) April (0) March (0) February (0) January (0)	2009 December (0) November (0) October (1) September (1) August (0) July (0) June (0) May (1) April (1) March (2) February (2) January (0)
2008 December (0) November (1) October (2) September (1) August (1) July (2) June (0) May (2) April (0) March (1) February (2) January (1)	2007 December (1) November (2) October (0) September (0) August (0) July (1) June (0) May (2) April (1) March (2) February (3)

Re: ORA-00911: invalid character Comment from Anonymous on May 19, 2012 8:11:55 PM CEST #
Title
Body	HTML : b, strong, i, em, blockquote, br, p, pre, a href="", ul, ol, li, sub, sup
Name
E-mail address
Website
Remember me	Yes No
E-mail addresses are not publicly displayed, so please only leave your e-mail address if you would like to be notified when new comments are added to this blog entry (you can opt-out later).

Username
Password
Remember me