Openfire - Oracle Connection Problem

Openfire Openfire Support
1

Hi,

i’m using Oracle 10g XE v2 on same server.

Own user with objects from openfire_oracle.sql created and login is possible.

Openfire Version: 3.4.5

ojdbc14.jar in openfire/lib

connection string with ssid usage: jdbc:oracle:thin:@127.0.0.1:1521:xe

org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnect ionProvider.java:74) DbConnectionProvider: Error while getting connection:

java.sql.SQLException: Created a new connection but it failed its test

at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:217 )

at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)

at java.sql.DriverManager.getConnection(DriverManager.java:525)

at java.sql.DriverManager.getConnection(DriverManager.java:140)

…

What kind of test? Anyone know a workaround for this problem?

Greets

2

See this thread: http://www.igniterealtime.org/community/thread/31389

(not especially the discussion of testSQL and select 1 from dual)

3

GREAT THX

edit openfire.xml

you have to add in <database> node:

<testBeforeUse>false</testBeforeUse>

<testAfterUse>false</testAfterUse>

4

I would recommend the other solution. =) Set both of those back to true, and set