Show posts
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
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