JRE_HOME environment variable definition

[Jimmy]

Hi, Dear team,

I have installed Konakart and JRE-6 on my Windows XP successfully.

But when I click the icon of Konakart-Start-and-Launch to try to start the Konakart
server, following message displayed:
" Neither the JAVA_HOME nor the JRE_HOME environment variable is defined,
Waiting for the konaKart server to start"

Could you please tell me where I can define it?

Thanks a lot!

[Brian]

Hi Jimmy,

I'm a bit puzzled about this one...  The Installer should have set your specified java re location inside the \bin\setJavaHome.bat file.   

If it hasn't, can you set it in there and try again.

If it has, and it still doesn't work, please write back.

Brian

[Jimmy]

Hi, Brian,

Thanks for your reply!

I think I should tell you my Java and MySql setting first!

MySql ( server version: 4.0.24-nt ) location:  C:\AppSer\mysql\bin\mysql.exe

Java JRE location:  C:\Program Files\Java\jre1.6.0_03\bin\java

Do you think those are OK?

Jimmy

[Brian]

Hi Jimmy,

Glad you mentioned that because you'll need a more recent MySQL (MySQL 5.0.27+ will be OK), or one of the other supported dbs.

You should be OK with your java version..

Regards,
Brian

[Jimmy]

Hi, Brian,

I have done everything I need now!
But the problem is same!

I have checked the setJavaHome.bat file.
Yes! it is there. Following is the content of this file:

@echo off
rem
rem Set the JRE_HOME for KonaKart here.
rem
rem We unset JAVA_HOME to avoid using the wrong java version.
rem
rem KonaKart needs java 5 at least
rem

set JRE_HOME=
set JAVA_HOME=


rem
rem (c) 2006 DS Data Systems UK Ltd, All rights reserved.
rem
rem DS Data Systems and KonaKart and their respective logos, are
rem trademarks of DS Data Systems UK Ltd. All rights reserved.
rem
rem The information in this document is the proprietary property of
rem DS Data Systems UK Ltd. and is protected by English copyright law,
rem the laws of foreign jurisdictions, and international treaties,
rem as applicable. No part of this document may be reproduced,
rem transmitted, transcribed, transferred, modified, published, or
rem translated into any language, in any form or by any means, for
rem any purpose other than expressly permitted by DS Data Systems UK Ltd.
rem in writing.
rem


Could you please tell me what I should set in this file?

Thanks!

[Brian]

Hi Jimmy,

Normally the installer writes your chosen java runtime location into that file so something must have gone wrong with your installation - did you use the GUI wizard?

Anyway, in your case, your setJavaHome.bat file should look like this:

Code: [Select]

@echo off
rem
rem Set the JRE_HOME for KonaKart here.
rem
rem We unset JAVA_HOME to avoid using the wrong java version.
rem
rem KonaKart needs java 5 at least
rem

set JRE_HOME=C:\Program Files\Java\jre1.6.0_03
set JAVA_HOME=

How did you install KonaKart?  If you didn't use the GUI wizard you may well have more configuration to do that would normally be done for you during the installation.

Regards,
Brian

[Jimmy]

Yeah! It is running now!

But it seems that KonaKart does not support UTF-8 because it will not work when I set
UTF-8 as MySql default character set!

[pete]

Hi Jimmy,

KonaKart runs perfecly well with MySQL with a UTF-8 database.  Indeed it is very good at supporting different languages and character sets.

What do you mean when you say "it does not support it"?

Regards,
Pete

[Jimmy]

Hi, Pete,

When I set UTF-8 or gb2312 as MySql default character set successfully and input a Chinese
 manufacturer name into the manufacturer table, following messages displayed:

java.sql.SQLException: Incorrect string value: '\xC1\xAA\xCF\xEB' for column 'manufacturers_name' at row 1
Exception Stack Trace =
at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:106)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:653)
at org.apache.torque.util.BasePeer.access$000(BasePeer.java:80)
at org.apache.torque.util.BasePeer$4.process(BasePeer.java:1230)
at org.apache.torque.util.BasePeer.processTables(BasePeer.java:1716)
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1225)
at com.konakartadmin.bl.AdminManufacturerMgr.editManufacturer(AdminManufacturerMgr.java:198)
at com.konakartadmin.bl.KKAdmin.editManufacturer(KKAdmin.java:2775)
at com.konakartadmin.server.KKAdminGWTServiceImpl.editManufacturer(KKAdminGWTServiceImpl.java:3436)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:528)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:265)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:187)
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(Unknown Source)

Exception Cause =
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1169)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:693)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1404)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1318)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1303)
at com.workingdogs.village.Record.saveWithUpdate(Record.java:349)
at com.workingdogs.village.Record.save(Record.java:234)
at com.workingdogs.village.Record.save(Record.java:198)
at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:650)
at org.apache.torque.util.BasePeer.access$000(BasePeer.java:80)
at org.apache.torque.util.BasePeer$4.process(BasePeer.java:1230)
at org.apache.torque.util.BasePeer.processTables(BasePeer.java:1716)
at org.apache.torque.util.BasePeer.doUpdate(BasePeer.java:1225)
at com.konakartadmin.bl.AdminManufacturerMgr.editManufacturer(AdminManufacturerMgr.java:198)
at com.konakartadmin.bl.KKAdmin.editManufacturer(KKAdmin.java:2775)
at com.konakartadmin.server.KKAdminGWTServiceImpl.editManufacturer(KKAdminGWTServiceImpl.java:3436)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:528)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:265)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:187)
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(Unknown Source)

This is why I think that Konakart does not support UTF-8 or other double-byte character set!

Can you tell the reason about it?

Thanks in advance!

Jimmy

[pete]

Hi Jimmy,

I've just inserted a manufacturer with Chinese characters without any problems. Other forum members seem to have achieved this also. Are you sure that your database is set up correctly ? Have you managed to insert Chinese characters using MySQL Admin tools ?

Regards,

Pete

[Jimmy]

Hi, Pete,

I use "MySql Server Instance Configuration Wizard" to set the default character set
and I use Konakart Administrator Panel to insert a Chinese character.

Am I right? ( sorry I can not insert a copy of screen here! )

Looking forward to your reply!

Jimmy

[pete]

Hi Jimmy,

First you have to make sure your database is set up correctly.   One simple way to do this is to do as I said in my last post - that is, to verify that you can add Chinese characters using MySQL tools...  eg. use the MySQL Query Browser...

The point is that this step will help you resolve your problem.  Note that other users are using Chinese characters without problems.

Regards,

Pete