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

Openfire

Oracle can't handle default test SQL

Created: 02/11/08 09:24 AM Updated: 04/09/08 11:31 AM

Component/s:

None

Affects Version/s:

None

Fix Version/s:

3.5.0

Time Tracking:

Not Specified

Support Plan Customer Issue:	No
Resolution Date:	02/11/08 10:41 PM
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

Subversion Commits

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Daniel Henninger - 02/11/08 10:01 AM

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

[ Permlink | « Hide ]

Erik Onnen - 02/18/08 03: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.

[ Permlink | « Hide ]

Erik Onnen - 02/18/08 03:53 PM

Work-around for 3.4.5 that is.

[ Permlink | « Hide ]

Daryl Beattie - 04/09/08 11:27 AM

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

[ Permlink | « Hide ]

Daniel Henninger - 04/09/08 11:31 AM

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