Buonasera, sono nuovo del forum java e sopratutto sono assolutamente ignorante in materia: sto testando un crm java-based che viene installato su win insieme ad apache tomcat. La configurazione è ok sembra tutto funzionare però nell'eseguire una certa funzione di importazione ottengo un errore dal server tomcat che vi riporto qui sotto:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Execution failed.
xsharp.servlet.Execute.service(Execute.java:279)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)

root cause

xsharp.lang.RuntimeError: Failed to execute query "select xrm_account.name,xrm_account.addr_addresstypecode, xrm_account.revenue,xrm_account.addr_city,xrm_acco unt.addr_country,t1.full_name as created_by,xrm_account.created_on,xrm_account.cred itlimit,xrm_account.creditonhold,t1.full_name as currency,xrm_account.duns,xrm_account.description, xrm_account.nobulkemail,xrm_account.noemail,xrm_ac count.nofax,xrm_account.nosendmm,xrm_account.nopho ne,xrm_account.nopostalmail,xrm_account.emailaddre ss1,xrm_account.fax,t1.full_name as folder,xrm_account.addr_freightterm,xrm_account.in active,xrm_account.industry,xrm_account.lastcpuse, xrm_account.telephone1,t1.full_name as masterid,t1.full_name as changed_by,xrm_account.changed_on,xrm_account.addr _name,xrm_account.empno,xrm_account.notes,xrm_acco unt.number_of_locations,t1.full_name as origlead,xrm_account.emailaddress2,xrm_account.tel ephone2,t1.full_name as owner,xrm_account.ownership,t1.full_name as parentaccountid,xrm_account.payterms,xrm_account.p refmethod,xrm_account.prefday,t1.full_name as prefequip,t1.full_name as preferredserviceid,xrm_account.preftime,t1.full_na me as prefuser,t1.full_name as defaultpricelistid,t1.full_name as primarycontactid,xrm_account.rating,xrm_account.cu stomertype,xrm_account.sic,xrm_account.sla,xrm_acc ount.sla_expiration_date,xrm_account.sla_serial,t1 .full_name as addr_shipmth,xrm_account.addr_state,xrm_account.ad dr_line1,xrm_account.addr_line2,xrm_account.addr_l ine3,t1.full_name as territory,xrm_account.tickersymbol,xrm_account.ups ell_opportunity,xrm_account.websiteurl,xrm_account .addr_zip from xrm_account left join xrm_user as t1 on (t1.xid=xrm_account.created_by) left join xrm_currency as t2 on (t2.xid=xrm_account.currency) left join xrm_account as t3 on (t3.xid=xrm_account.masterid) left join xrm_user as t4 on (t4.xid=xrm_account.changed_by) left join xrm_lead as t5 on (t5.xid=xrm_account.origlead) left join xrm_user as t6 on (t6.xid=xrm_account.owner) left join xrm_account as t7 on (t7.xid=xrm_account.parentaccountid) left join xrm_equipment as t8 on (t8.xid=xrm_account.prefequip) left join xrm_user as t9 on (t9.xid=xrm_account.prefuser) left join xrm_pricelist as t10 on (t10.xid=xrm_account.defaultpricelistid) left join xrm_contact as t11 on (t11.xid=xrm_account.primarycontactid) left join xrm_shippingprovider as t12 on (t12.xid=xrm_account.shipmth) left join xrm_territory as t13 on (t13.xid=xrm_account.territory) where xrm_account.folder is null".
xsharp.io.sql.client.SqlClient.executeQuery(SqlCli ent.java:172)
xsharp.io.sql.client.SqlClient.execute(SqlClient.j ava:73)
xsp.xsp4gcx5ga9xkytv.execute(xsp4gcx5ga9xkytv.java :82)
xsp.xspg7l3jga9xmvoq$pi0.execute(xspg7l3jga9xmvoq. java:404)
xsp.xsp2flq6ga9xmy07.execute(xsp2flq6ga9xmy07.java :49)
xsharp.servlet.Execute.service(Execute.java:157)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)

root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown column 'xrm_account.shipmth' in 'on clause'
sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Source)
java.lang.reflect.Constructor.newInstance(Unknown Source)
com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1030)
com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:956)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3515)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3447)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 51)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2101)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2554)
com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1761)
com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1912)
org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:93 )
xsharp.io.sql.client.SqlClient.executeQuery(SqlCli ent.java:162)
xsharp.io.sql.client.SqlClient.execute(SqlClient.j ava:73)
xsp.xsp4gcx5ga9xkytv.execute(xsp4gcx5ga9xkytv.java :82)
xsp.xspg7l3jga9xmvoq$pi0.execute(xspg7l3jga9xmvoq. java:404)
xsp.xsp2flq6ga9xmy07.execute(xsp2flq6ga9xmy07.java :49)
xsharp.servlet.Execute.service(Execute.java:157)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
Apache Tomcat/6.0.18


--------------------------------------------------------------------

Penso di aver trovato l'errore ( è indicato qui: root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown column 'xrm_account.shipmth' in 'on clause') infatti se mi collego al db mysql utilizzato dal server il nome della colonna corretto è: 'xrm_account.addr_shipmth' e non ''xrm_account.shipmth'.

Detto ciò mi chiedevo di capire qual è il file che determina questa query e una volta trovato vorrei correggere la chiamata a quella colonna.

Dato che sono ignorante in materia pensavo fosse semplice trovare il file (un pò come funziona con il php-mysql) ma non so veramente dove sbattere la testa, sembra che questa query sia nascosta. Qualcuno sa darmi un'indicazione su come procedere per capire quali file vanno modificato?

Grazie in anticipo