Messages

Hi,

in server.xml i use this:
        <Context path="/konakart"
                 reloadable="false"
                 docBase="C:\Programme\konakart2.2.4\webapps\konakart"/>

by the reload occurs the exception below:

'Has no functional impact', but where is the problem.

It works for me, the message-resources are refreshed.

Could not load java.net.BindException

regards, rula

INFO: Reloading this Context has started
02.06.2008 11:10:58 org.apache.catalina.loader.WebappClassLoader loadClass
INFO: Illegal access: this web application instance has been stopped already.  Could not load java.net.BindException.  The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1238)
   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)
   at java.lang.ClassLoader.loadClassInternal(Unknown Source)
   at com.mysql.jdbc.SQLError.createLinkFailureMessageBasedOnHeuristics(SQLError.java:1220)
   at com.mysql.jdbc.CommunicationsException.<init>(CommunicationsException.java:51)
   at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
   at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3246)
   at com.mysql.jdbc.MysqlIO.quit(MysqlIO.java:1656)
   at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4261)
   at com.mysql.jdbc.ConnectionImpl.cleanup(ConnectionImpl.java:1248)
   at com.mysql.jdbc.ConnectionImpl.finalize(ConnectionImpl.java:2655)
   at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
   at java.lang.ref.Finalizer.runFinalizer(Unknown Source)
   at java.lang.ref.Finalizer.access$100(Unknown Source)
   at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)
KonaKartPlugin : propertiesPath = konakart.properties
02-Jun 11:11:00 INFO  (?:init:?) Finished Initialising Log4j
02-Jun 11:11:00 INFO  (?:init:?) Initialising Torque with the file : /C:/Programme/konakart2.2.4/webapps/konakart/WEB-INF/classes/konakart.properties
02-Jun 11:11:01 INFO  (?:init:?) Initialising KonaKart-Torque for org.apache.torque.adapter.DBMM
02-Jun 11:11:01 INFO  (?:init:?) Finished Initialising Torque
02-Jun 11:11:01 INFO  (?:init:?) Initialising konakart with the file : konakart.properties
02-Jun 11:11:01 INFO  (?:initKonakart:?) KonaKart V2.2.4.0 built 11:00AM 18-Mar-2008 GMT
02-Jun 11:11:01 INFO  (?:init:?) Finished Initialising konakart
KKAppEngPlugin : propertiesPath = konakart_app.properties
02-Jun 11:11:01 INFO  (?:readPropertiesFile:?) kkAppEng using configuration file: /C:/Programme/konakart2.2.4/webapps/konakart/WEB-INF/classes/konakart_app.properties
02-Jun 11:11:01 INFO  (?:<init>:?) Engine used by application is com.konakart.app.KKEng
02-Jun 11:11:02 INFO  (?:<init>:?) KKGWTService ready and waiting....
02-Jun 11:11:02 INFO  (?:<init>:?) Engine used by application is com.konakart.app.KKEng
02.06.2008 11:11:06 org.apache.catalina.core.ApplicationContext log
INFO: HTMLManager: list: Listing contexts for virtual host 'localhost'

Hi,

i need the reload of message-resources prior for configuration and performance is not so important.
So, i think i should solve this problem in tomcat with the reloadable-attribute of the context-element.

like here in the tomcat-doc:

Set to true if you want Catalina to monitor classes in /WEB-INF/classes/ and /WEB-INF/lib for changes, and automatically reload the web application if a change is detected. This feature is very useful during application development, but it requires significant runtime overhead and is not recommended for use on deployed production applications. That's why the default setting for this attribute is false. You can use the Manager web application, however, to trigger reloads of deployed applications on demand.

First i test to use the tomcat-manager-app!

regards, rula

Hi,

i found many different solutions in the java-ranch-threat.

The last entry by Michael Böckling is my private favourite.

two utility-classes:
- ReloadablePropertyMessageResources.java
- ReloadablePropertyMessageResourcesFactory.java
and one change in struts-config.xml:
<message-resources parameter/>

Have anybody here proved this way?

regards, rula

Hello,

how can I reach a simple update of the the messages-catalog in the client-app?
Only if I stop and start the server, the message-resources are updated.
I think a simple reload is enough, but I can't find a way to reach this.

In admin-app there is no problem, I do the changes and klick only F5 in the browser and the all seems to be okay.

regards, rula

Hi,

it's the same problem as before.

I can follow the code in the AddToCartSubmitAction up to

kkAppEng.getBasketMgr().addToBasket(b, /* refresh */true);

and than i come not further.

Where are the statements generated, have i access to this sources?

What happens in the basketmanager, i don't now and need help.

Exception Cause = org.apache.torque.TorqueException
at org.apache.torque.util.BasePeer.throwTorqueException(Unknown Source)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(Unknown Source)
at org.apache.torque.util.BasePeer.doInsert(Unknown Source)
at com.konakart.bl.BasketMgr.addToBasket(Unknown Source)
at com.konakart.bl.BasketMgr.addToBasket(Unknown Source)
at com.konakart.app.KKEng.addToBasket(Unknown Source)
at com.konakart.al.BasketMgr.addToBasket(Unknown Source)
at com.konakart.actions.AddToCartSubmitAction.execute(Unknown Source)

Regards, rula

Hi,

the insert is ok and i unfortunately have not checked if it works direct after the installing.

Well, i desinstall konakart, drop the database and repeat the setup.

Regards, rula

Hi,

i used the installer for the version2.2.2.0 and received no errors when the sql-scripts runs.y

Who ist the asterix or field-list in the select-statement from the debug-logging?

Here the desc of customers_basket:

mysql> use konakart;
Database changed
mysql> desc customers_basket;
+-----------------------------+---------------+------+-----+---------+----------
------+
| Field                       | Type          | Null | Key | Default | Extra
      |
+-----------------------------+---------------+------+-----+---------+----------
------+
| customers_basket_id         | int(11)       | NO   | PRI | NULL    | auto_incr
ement |
| customers_id                | int(11)       | NO   |     |         |
      |
| products_id                 | tinytext      | NO   |     |         |
      |
| customers_basket_quantity   | int(2)        | NO   |     |         |
      |
| final_price                 | decimal(15,4) | NO   |     |         |
      |
| customers_basket_date_added | char(       | YES  |     | NULL    |
      |
| custom1                     | varchar(128)  | YES  |     | NULL    |
      |
| custom2                     | varchar(128)  | YES  |     | NULL    |
      |
| custom3                     | varchar(128)  | YES  |     | NULL    |
      |
| custom4                     | varchar(128)  | YES  |     | NULL    |
      |
| custom5                     | varchar(128)  | YES  |     | NULL    |
      |
+-----------------------------+---------------+------+-----+---------+----------
------+
11 rows in set (0.00 sec)

mysql>

Regards, rula

Hi,

i don't no where to find api-calls with parameters.

I only have installed konakart and run the compile-build in the custom-folder to test customization.

I have a part of the stack-trace and debug-messages from the logging and hope it helps.

Exception Name = com.konakart.app.KKException
Exception Message = org.apache.torque.TorqueException: java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
Exception Stack Trace =
at com.konakart.app.KKEng.addToBasket(Unknown Source)
at com.konakart.al.BasketMgr.addToBasket(Unknown Source)
at com.konakart.actions.AddToCartSubmitAction.execute(Unknown Source)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)

29-Feb 13:50:18 DEBUG (?:executeQuery:?) SQL: SELECT customers_basket.customers_
basket_id, customers_basket.customers_basket_date_added, customers_basket.custom
ers_basket_quantity, customers_basket.final_price, customers_basket.products_id,
customers_basket.custom1, customers_basket.custom2, customers_basket.custom3, c
ustomers_basket.custom4, customers_basket.custom5 FROM customers_basket WHERE cu
stomers_basket.products_id='27' AND customers_basket.customers_id=-38
29-Feb 13:50:18 DEBUG (?:executeQuery:?) Elapsed time=10 ms
29-Feb 13:50:18 DEBUG (?:insertOrUpdateRecord:?) Save column customers_basket.cu
stomers_id value = -38
29-Feb 13:50:18 DEBUG (?:insertOrUpdateRecord:?) Save column customers_basket.pr
oducts_id value = 27
29-Feb 13:50:18 DEBUG (?:insertOrUpdateRecord:?) Save column customers_basket.cu
stomers_basket_quantity value = 1
29-Feb 13:50:18 DEBUG (?:insertOrUpdateRecord:?) Save column customers_basket.fi
nal_price value = 499.9900
29-Feb 13:50:18 DEBUG (?:insertOrUpdateRecord:?) Save column customers_basket.cu
stomers_basket_date_added value = 20080229
29-Feb 13:50:18 DEBUG (?:insertOrUpdateRecord:?) Save record = {'null','-38','27
','1','499.9900','20080229','null','null','null','null','null'}
29-Feb 13:50:18 WARN  (?:addToBasket:?) Exception adding to Basket: Query detail
s:
Criteria:: customers_basket.customers_basket_quantity<=>customers_basket.custome
rs_basket_quantity=1:  customers_basket.products_id<=>customers_basket.products_
id='27':  customers_basket.customers_id<=>customers_basket.customers_id=-38:  cu
stomers_basket.customers_basket_date_added<=>customers_basket.customers_basket_d
ate_added='20080229':  customers_basket.final_price<=>customers_basket.final_pri
ce=499.9900:
Current Query SQL (may not be complete or applicable): SELECT  FROM customers_ba
sket WHERE customers_basket.customers_basket_quantity=1 AND customers_basket.pro
ducts_id='27' AND customers_basket.customers_id=-38 AND customers_basket.custome
rs_basket_date_added='20080229' AND customers_basket.final_price=499.9900

Regards, rula

Hi,

i can't add items to the basket.
I use konakart2.2.2.0 and mysql5.0.17.

It seems for me that a (dynamic) select-statement ist not correct.
I am a konakart newbie and need a hint to solve this problem.

The details of the malfunction are :
Exception Name = com.konakart.app.KKException
Exception Message = org.apache.torque.TorqueException: java.sql.SQLException: Incorrect arguments to mysql_stmt_execute
Exception Stack Trace =
at com.konakart.app.KKEng.addToBasket(Unknown Source)
at com.konakart.al.BasketMgr.addToBasket(Unknown Source)
at com.konakart.actions.AddToCartFromProdIdAction.execute(Unknown Source)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)

28-Feb 22:49:05 WARN  (?:addToBasket:?) Exception adding to Basket: Query details:
Criteria:: customers_basket.customers_basket_quantity<=>customers_basket.customers_basket_quantity=1:  customers_basket.products_id<=>customers_basket.products_id='1{3}5{4}2':  customers_basket.customers_id<=>customers_basket.customers_id=-9:  customers_basket.customers_basket_date_added<=>customers_basket.customers_basket_date_added='20080228':  customers_basket.final_price<=>customers_basket.final_price=349.9900: 
Current Query SQL (may not be complete or applicable): SELECT  FROM customers_basket WHERE customers_basket.customers_basket_s

Regards, rula

Hi,

i created a project in the ide,
imported the custom-, webapps- and common-folder
and run the ant build with the required targets.

So i can compile and create wars from my customized sources and deploy these.

It's fine, thanks.

Regards, rula

Hi,
first i have to customize the view (images, styles, htmls and jsps) and
later perhaps the src (actions, forms) and than run a ant build all in eclipse.

How to create or import a konakart-project like a struts-project in eclipse for effective work.

Is there a good and fast way to do all this work inside eclipse?