Configuring 2.2.6 with a separate JNDI Resource

[jarrazolo]

Hello All,

I am having problems problems configuring an external Oracle 10G DataSource through JINDI in Konakart 2.2.6.  I get the following Exception:
10-Jun 14:58:45 ERROR (?:executeQuery:?) Exception was caught Name OracleWMSDS is not bound in this Context
I will appreciate any of you sharing or any feedback.

Thanks

Here is my konakart.properties file
# -----------------------------------------------------------------------------------
#
#  K O N A K A R T   P R O P E R T I E S
#
#  For help on changing these parameters check the FAQs on http://www.konakart.com
# -----------------------------------------------------------------------------------

# -----------------------------------------------------------------------------------
#  D A T A B A S E   P R O P E R T I E S
#  Database Connection Parameters Set by Installer on  2-Feb-2009
# -----------------------------------------------------------------------------------

torque.applicationRoot = .

torque.database.default                         = oscommerce

#MS SQL Server Konakart Database MSSQL Driver.
torque.database.oscommerce.adapter              = mssql
torque.dsfactory.oscommerce.connection.driver   = net.sourceforge.jtds.jdbc.Driver
torque.dsfactory.oscommerce.connection.url      = jdbc:jtds:sqlserver://FBVDBSQLP15:10435/WMC;SelectMethod=cursor
torque.dsfactory.oscommerce.connection.user     = WMCUser
torque.dsfactory.oscommerce.connection.password = WmcU$3r

#Oracle Server WMC Database
torque.database.oraclewmsds.adapter             = oracle
torque.dsfactory.oraclewmsds.factory          = org.apache.torque.dsfactory.JndiDataSourceFactory
torque.dsfactory.oraclewmsds.connection.driver  = oracle.jdbc.OracleDriver
torque.dsfactory.oraclewmsds.connection.url     = jdbc:oracle:thin:@max2006:1521:m2prod
torque.dsfactory.oraclewmsds.connection.user    = mwm_store
torque.dsfactory.oraclewmsds.connection.password= mwm_store4003


# -----------------------------------------------------------------------------------
#  C O N N E C T I O N   P O O L   P R O P E R T I E S
# -----------------------------------------------------------------------------------
# You can leave the defaults
# -----------------------------------------------------------------------------------

# Using commons-dbcp

torque.dsfactory.oscommerce.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.oraclewmsds.factory= org.apache.torque.dsfactory.SharedPoolDataSourceFactory

# The maximum number of active connections that can be allocated from this pool at
# the same time, or zero for no limit.

torque.dsfactory.oscommerce.pool.maxActive=0
torque.dsfactory.oraclewmsds.pool.maxActive=0

# The maximum number of active connections that can remain idle in the pool, without
# extra ones being released, or zero for no limit.

torque.dsfactory.oscommerce.pool.maxIdle=10
torque.dsfactory.oraclewmsds.pool.maxIdle=10

# The maximum number of milliseconds that the pool will wait (when there are no
# available connections) for a connection to be returned before throwing an exception,
# or -1 to wait indefinitely.

torque.dsfactory.oscommerce.pool.maxWait=-1
torque.dsfactory.oraclewmsds.pool.maxWait=-1

# The indication of whether objects will be validated before being borrowed from the
# pool. If the object fails to validate, it will be dropped from the pool, and we will
# attempt to borrow another.

torque.dsfactory.oscommerce.pool.testOnBorrow=true
torque.dsfactory.oraclewmsds.pool.testOnBorrow=true

# The SQL query that will be used to validate connections from this pool before
# returning them to the caller. If specified, this query MUST be an SQL SELECT
# statement that returns at least one row.
# Recommended settings:
# for MySQL/PostgreSQL/MS SQL use: SELECT 1
# for Oracle                  use: SELECT 1 from dual
# for DB2                     use: SELECT 1 FROM sysibm.sysdummy1

torque.dsfactory.oscommerce.pool.validationQuery=SELECT 1
torque.dsfactory.oraclewmsds.pool.validationQuery=SELECT 1

#Register this DataSource with the JNDI service and set its cache time-out
torque.dsfactory.oraclewmsds.jndi.path=jdbc/OracleWMSDS
torque.dsfactory.oraclewmsds.jndi.ttl=60000
torque.dsfactory.oraclewmsds.jndi.java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory
torque.dsfactory.oraclewmsds.jndi.java.naming.factory.url.pkgs = org.apache.naming

# -----------------------------------------------------------------------------------
#  K O N A K A R T  P R O P E R T I E S
# -----------------------------------------------------------------------------------
# The parameters to configure KonaKart
# -----------------------------------------------------------------------------------

konakart.session.durationMinutes=30

# konakart.delete_reviews - set to TRUE to delete a customer's reviews when a
#                           customer is deleted
# konakart.delete_reviews - set to FALSE to leave a customer's reviews when a
#                           customer is deleted (default)
#                           (in this default case the customerID on the review
#                           records is set to null)
konakart.delete_reviews = FALSE

# -----------------------------------------------------------------------------------
# Velocity parameters

# Full path and name of log file for error, warning, and informational messages. The location,
# if not absolute, is relative to the 'current directory'.

konakart.velocity.logfile = E:\Konakart_2.2.6.0\logs\konakart.log

# -----------------------------------------------------------------------------------
# KonaKart database owner (only used by MS SQL Server currently)

konakart.database.owner = dbo

# -----------------------------------------------------------------------------------
# KonaKart engine class used by the web services
# For the default engine use:   com.konakart.app.KKEng
# For the custom engine use:    com.konakart.app.KKCustomEng

konakart.app.ws.engine.classname = com.konakart.app.KKEng

# -----------------------------------------------------------------------------------
# KonaKart Version Information

konakart.version    = 2.2.6.0
konakart.build.date = 8:31PM 27-May-2008 BST

[Brian]

Not sure what you're trying to acheive here.

Why are you trying to use JNDI when at the same time you put all the database connection parameters in konakart.properties?

We never do this in KonaKart.


If you want to create an independent database connection defined by JNDI I would do that outside the KonaKart properties files.

BTW... "not bound in this Context"  exceptions are typically due to your JNDI definitions. There are lots of examples on the web for setting up db connections like this... but it's not something we do in KonaKart.