Topics

Using the XML loader, is it possible to import a product with a name longer than the default validation length?

I have configured the database to have a larger column length and also increased in the CustomValidation.properties but there doesn't seem to be a way to reference the file from the loader

So when I'm trying to import a product with a name longer than 64 but I get a error in com.konakart.importer.xml.ImportXMLData.validateProduct

Is there any way of customising the validation the XML importer uses?

I'm trying to enter a manufacturers name that is longer than the 32 chars.

I changed the MaximumValue for Manufacturer in the Configuration but this didnt affect it.

I had a look at the CustomValidation.properties file an it doesn't have an entry for manufacturer.name, so I tried adding it

Manufacturer.name      = 0;256

I restarted but konakart still doesn't is it not possible to extend the length of the manufacturers name in the application?

Is it possible to have a manufacturer name longer than 32

are there any DTDs available for the XML files used for loading data via the XML_io importer?

I have a spreadsheet with data in it that I'm trying to save as an XML file, so that I can upload the data into the database  and it would be easier to create the XML file if I had the DTD available as an XML map for Excel 2007

How do I add tags to products?

I can't see anyway of adding new tags so that they can be assigned to a product in the administration

I'm looking for some guidance on what I need to remove from the SQL script to set up a shop that does not contain any of the demo data for DVDs etc.

I have to enter products that have titles longer than the 64 length allowed in the variable name.

Can I just update the length of the column in the database or is their some other validation that will restrict entry?

I am most likely to be using the loader to load products so will not be manually entering data

I followed the konakart manual installation instructions and created the wars and deployed them to a tomcat server.

When I try to open the konkartadmin i get the following stacktrace

From my understanding it looks like it can't find the databse but looking at the konakartadmin.properties the database configuration looks correct and is the same as the install which worked correctly

any ideas?

Thanks

Craig

_msg.unknownCauseDetails


Exception Stack Trace =
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.konakartadmin.ws.KKAdminEngineMgr.getKKAdminByName(Unknown Source)
at com.konakartadmin.ws.KKAdminEngineMgr.createKKAdminEngine(Unknown Source)
at com.konakartadmin.server.KKAdminGWTServiceImpl.getEng(Unknown Source)
at com.konakartadmin.server.KKAdminGWTServiceImpl.getStores(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:164)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
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:619)

Exception Cause =
at oracle.sql.CharacterSet1Byte.getInstance(CharacterSet1Byte.java:86)
at oracle.sql.CharacterSetWithConverter.getInstance(CharacterSetWithConverter.java:103)
at oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:123)
at oracle.sql.CharacterSet.make(CharacterSet.java:440)
at oracle.jdbc.driver.DBConversion.(DBConversion.java:145)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:878)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:177)
at org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:132)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.testCPDS(InstanceKeyDataSource.java:749)
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.registerPool(SharedPoolDataSource.java:202)
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:159)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:669)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:653)
at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:749)
at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:727)
at org.apache.torque.Torque.getConnection(Torque.java:274)
at com.konakartadmin.bl.KKAdminBase.initTorque(Unknown Source)
at com.konakartadmin.bl.KKAdminBase.init(Unknown Source)
at com.konakartadmin.bl.KKAdmin.(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.konakartadmin.ws.KKAdminEngineMgr.getKKAdminByName(Unknown Source)
at com.konakartadmin.ws.KKAdminEngineMgr.createKKAdminEngine(Unknown Source)
at com.konakartadmin.server.KKAdminGWTServiceImpl.getEng(Unknown Source)
at com.konakartadmin.server.KKAdminGWTServiceImpl.getStores(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:164)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
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:619)