Messages

hey ,
I think i m doing some kind of mistake...
so which driver should i put in the class path . the same one which is inside... konakart / lib ..

thats what you are saying

regards

this solution will not work for ms sql 2005 driver....

hey ,
I am getting this problem for 1 week....
I have posted for this before.. but.. no solution..

Actually I installed Konakart with ms sql server 2005 ,.
But main problem is that we can see or retrive the new data from
Konakart tables but when ever we tried to enter new record from front end it creates probelm
If tried to enter New data at the Data base level then it is doing it,.

from front end when ever 1 try to enter new record
I alwaya get this error
org.apache.torque.TorqueException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

Hey one more thing when i was entering the record at Db level into the customer table.
The customer Id jump from 1 to 9 then 12
so its like i got the info that there are 3 records in Db
but cant see  them
regards
Chirantan 

hey trevor .
I have tried all the things but it still not working in my case
I am using developer edition of Sql server 05 right . do u think
that can be a problem

regards
Chirantan

hey trevor ,

Thanx for replying so fast.
Actully we are trying to use Konakart for our company's website.. so  i need to check all the details of it.

Below is the properties file.
which konakart create at the time of installation (No changes made by me) .
one more thing on inserting the data i got this error.

org.apache.torque.TorqueException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.

# -----------------------------------------------------------------------------------
#
#  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 25-Sep-2007
# -----------------------------------------------------------------------------------

torque.applicationRoot = .

torque.database.default                         = oscommerce

torque.database.oscommerce.adapter              = mssql
torque.dsfactory.oscommerce.connection.driver   = com.microsoft.jdbc.sqlserver.SQLServerDriver
torque.dsfactory.oscommerce.connection.url      = jdbc:sqlserver://Server1:1433;DatabaseName=Sequence
torque.dsfactory.oscommerce.connection.user     = sa
torque.dsfactory.oscommerce.connection.password = Admin05

# Examples:

#torque.database.oscommerce.adapter             = mysql
#torque.dsfactory.oscommerce.connection.driver  = com.mysql.jdbc.Driver
#torque.dsfactory.oscommerce.connection.url     = jdbc:mysql://localhost:3306/dbname?zeroDateTimeBehavior=convertToNull
#torque.dsfactory.oscommerce.connection.user    = root
#torque.dsfactory.oscommerce.connection.password=

#torque.database.oscommerce.adapter             = postgresql
#torque.dsfactory.oscommerce.connection.driver  = org.postgresql.Driver
#torque.dsfactory.oscommerce.connection.url     = jdbc:postgresql://127.0.0.1:5432/konakart
#torque.dsfactory.oscommerce.connection.user    = root
#torque.dsfactory.oscommerce.connection.password=

#torque.database.oscommerce.adapter             = oracle
#torque.dsfactory.oscommerce.connection.driver  = oracle.jdbc.OracleDriver
#torque.dsfactory.oscommerce.connection.url     = jdbc:oracle:thin:@dbhost:1521:dbname
#torque.dsfactory.oscommerce.connection.user    = dbuser
#torque.dsfactory.oscommerce.connection.password= dbpassword

#torque.database.oscommerce.adapter             = db2net
#torque.dsfactory.oscommerce.connection.driver  = com.ibm.db2.jcc.DB2Driver
#torque.dsfactory.oscommerce.connection.url     = jdbc:db2://leedsutd:50000/konakart
#torque.dsfactory.oscommerce.connection.user    = dbuser
#torque.dsfactory.oscommerce.connection.password= dbpassword

#torque.database.oscommerce.adapter             = mssql
#torque.dsfactory.oscommerce.connection.driver  = com.microsoft.jdbc.sqlserver.SQLServerDriver
#torque.dsfactory.oscommerce.connection.url     = jdbc:microsoft:sqlserver://norwich:1597;SelectMethod=cursor;DatabaseName=konakart
#torque.dsfactory.oscommerce.connection.user    = dbuser
#torque.dsfactory.oscommerce.connection.password= dbpassword

# -----------------------------------------------------------------------------------
#  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

# 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

# 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

# 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

# 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

# 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 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

# -----------------------------------------------------------------------------------
#  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

# -----------------------------------------------------------------------------------
# Modules available to this konakart system
#
# You have to add the name for the module in the right property, separate these
# with ";".  You also have to supply the class in the appropriate location - and
# these classes must implement the appropriate KonakartModuleInterface interface....
# These are:
#     KonakartPaymentInterface    - payment modules
#     KonakartShippingInterface   - shipping modules
#     KonakartOrderTotalInterface - order total modules

konakart.modules.payment = Cod;IPayment;MoneyOrder;NoChex;PayPal;Pm2Checkout;PsiGate;SecPay;Authorizenet
konakart.modules.shipping = Flat;Item;Table;Ups;Usps;Zones
konakart.modules.order_total = LowOrderFee;Shipping;SubTotal;Tax;Total

# -----------------------------------------------------------------------------------
# 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 =

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

konakart.database.owner = dbo

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

konakart.version    = 2.2.0.6
konakart.build.date = 12:30PM 6-Sep-2007 BST

Hi ,
I am new to this konakart .
I need one urgent help.
I just downloaded Konakart v2.2.0.6
and tried to use it with sqlser2005
but as soon as i try to insert something to Db from cart
I got cloned connection error .
So i after some research i found out that . Driver which i am having and which is inside of
konakart are different one
Like there path for driver is com.microsoft.jdbc.sqlserver.SQLServerDriver
what we have in to aceess our db is  com.microsoft.sqlserver.jdbc.SQLServerDriver

i tried to make change in the properties file and tried to replace the sqlerver jar but no
success
Can any body help on this.
regards
Thanx in advance
Chirantan