[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[xmlblaster] setting up jdbc for oracle



I'm having problems setting up xmlblaster's jdbc access to oracle. 

1. I already have an oracle test database running for which I've created a user called 'xmlblaster'. I'm able login using sqlplus as that user just fine. But I'm not sure if anything else needs to be done to the database outside of that because the documentation doesn't state so.

2. The following are jdbc-related settings that I modified in my xmlblaster.properties file (mostly commenting out the hdbsql plugins for the oracle version):

2a. I set up the proper url, user/pwd for my database here:
JdbcStorage[Oracle]=org.xmlBlaster.util.queue.jdbc.JdbcQueueCommonTablePlugin,\
                    url=jdbc:oracle:thin: at continuity:1521:alexis,\
                    user=xmlblaster,\
                    password=secret,\
                    connectionPoolSize=1,\
                    connectionBusyTimeout=90000,\
                    maxWaitingThreads=300,\
                    tableNamePrefix=XB_,\
                    nodesTableName=NODES,\
                    queuesTableName=QUEUES,\
                    entriesTableName=ENTRIES,\
                    dbAdmin=true

2b. 
#StoragePlugin[JDBC][1.0]=${JdbcStorage[HSQLDatabaseEngine]}
#StoragePlugin[JDBC][1.0]=${JdbcStorage[postgres]}
StoragePlugin[JDBC][1.0]=${JdbcStorage[Oracle]}
#StoragePlugin[JDBC][1.0]=${JdbcStorage[MicrosoftSQLServer]}
#StoragePlugin[JDBC][1.0]=${JdbcStorage[ldbc]}
StoragePlugin[RAM][1.0]=org.xmlBlaster.engine.msgstore.ram.MapPlugin
StoragePlugin[CACHE][1.0]=org.xmlBlaster.engine.msgstore.cache.PersistenceCachePlugin,persistentQueue=JDBC,transientQueue=RAM

2c.
#QueuePlugin[JDBC][1.0]=${JdbcStorage[HSQLDatabaseEngine]}
#QueuePlugin[JDBC][1.0]=${JdbcStorage[postgres]}
QueuePlugin[JDBC][1.0]=${JdbcStorage[Oracle]}
#QueuePlugin[JDBC][1.0]=${JdbcStorage[MicrosoftSQLServer]}
#QueuePlugin[JDBC][1.0]=${JdbcStorage[ldbc]}

2d.
JdbcDriver.drivers=org.hsqldb.jdbcDriver:\
                   org.ldbc.jdbc.jdbcDriver:\
                   com.mckoi.JDBCDriver:\
                   sun.jdbc.odbc.JdbcOdbcDriver:\
                   ORG.as220.tinySQL.dbfFileDriver:\
                   oracle.jdbc.driver.OracleDriver:\
                   com.mysql.jdbc.Driver:\
                   org.postgresql.Driver:\
                   de.sag.jdbc.adabasd.ADriver:\
                   com.sybase.jdbc2.jdbc.SybDriver

3. I copied classes12.zip, nls_charset12.zip & ojdbc14.jar into the $XMLBLASTER_HOME/lib directory

4. I modified the manifest.xmlblaster file and added ojdbc14.jar to it

5. Did a clean build on xmlblaster: build clean

6. Started xmlblaster with: 
java -jar lib/xmlblaster.jar -cluster false -cluster.node.id mymom

7. But the jdbc init section shows errors when trying to connect to the db:
[Jun 16, 2004 1:15:47 PM TRACE JdbcConnectionPool] initialize
[Jun 16, 2004 1:15:47 PM TRACE JdbcConnectionPool-jdbc:oracle:thin: at continuity:1521:alexis] initializing DB connection 0 url=jdbc:oracle:thin: at continuity:1521:alexis user=xmlblaster
[Jun 16, 2004 1:15:48 PM ERROR JdbcConnectionPool-jdbc:oracle:thin: at continuity:1521:alexis]  connecting to DB, error code : '0 : SOO10 Invalid argument in JDBC call' DB configuration details follow (check if the DB is running)

-->What does 'SOO10 Invalid argument in JDBC call' mean?
-->Did I miss any steps in the configuration files?