[#JM-1266] Oracle can't handle default test SQL

Openfire (ARCHIVED)

Oracle can't handle default test SQL

Created: 02/11/08 05:24 PM Updated: 04/09/08 06:31 PM

Component/s:

None

Affects Version/s:

None

Fix Version/s:

3.5.0

Time Tracking:

Not Specified

Resolution Date:	02/12/08 06:41 AM
Acceptance Test - Add?:	No

Description

« Hide

Apparently Oracle can't handle a simple SELECT 1. facepalm Need to figure out how best to handle this. Different statement that maybe works across the board? Special case for Oracle? Some other solution?

All

Comments

Work Log

Change History

FishEye

Sort Order:

[ Permalink | « Hide ]

Daniel Henninger added a comment - 02/11/08 06:01 PM

SELECT 1 FROM dual
works under oracle
and mysql
but not much else
gotta love consistency

[ Permalink | « Hide ]

Erik Onnen added a comment - 02/18/08 11:53 PM

Daniel, do you have a work-around for this? I've manually installed the schema via SQL script but setup still won't let me pass.

[ Permalink | « Hide ]

Erik Onnen added a comment - 02/18/08 11:53 PM

Work-around for 3.4.5 that is.

[ Permalink | « Hide ]

Daryl Beattie added a comment - 04/09/08 06:27 PM

I just installed 3.5.0 and this problem is still around, even though the bug says it's fixed for 3.5.0.

[ Permalink | « Hide ]

Daniel Henninger added a comment - 04/09/08 06:31 PM

What's in your openfire.xml? is testSQL set to anything?
I tested it on our Oracle server and it's working great there