SQL error 1064 when saving with mysql 4.0
Hello there,
Doesn't anyone knows why I am getting this error, I am using the last driver to connect to mysql.(mysql-connector-java-3.1.6-bin).
tks
_________________________________________________________________________
java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'convert, transactionform.cam_custservice_notes as cam_custservice_notes, transac' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1812)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1657)
at cirrus.hibernate.loader.Loader.getResultSet(Loader.java:475)
at cirrus.hibernate.loader.Loader.doFind(Loader.java:146)
at cirrus.hibernate.loader.Loader.find(Loader.java:531)
at cirrus.hibernate.impl.SessionImpl.find(SessionImpl.java:1034)
at cirrus.hibernate.impl.QueryImpl.list(QueryImpl.java:80)
at db.DotHibernate.list(DotHibernate.java:206)
at factories.ReportsFactory.getTransactionsHistory(ReportsFactory.java:247)
at site.ImageRender.service(ImageRender.java:39)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:96)
at com.caucho.server.http.Invocation.service(Invocation.java:311)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:213)
at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:100)
at com.caucho.server.http.QRequestDispatcher.forward(QRequestDispatcher.java:77)
at _global._admin._chart__jsp._jspService(_chart__jsp.java:28)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at filters.AdminLogonFilter.doFilter(AdminLogonFilter.java:111)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at filters.CAMSessionFilter.doFilter(CAMSessionFilter.java:87)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at filters.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:159)
at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java:88)
at com.caucho.server.http.Invocation.service(Invocation.java:311)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:342)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:272)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
query
SELECT transactionform.id as id, transactionform.senders_id as senders_id, transactionform.message as message, transactionform.us_dollars_amount as us_dollars_amount, transactionform.fees_collected as fees_collected, transactionform.exchange_rate as exchange_rate, transactionform.delivery_type as delivery_type, transactionform.reference_id as reference_id, transactionform.status as status, transactionform.status_description as status_description, transactionform.transaction_authorization as transaction_authorization, transactionform.credit_card_city as credit_card_city, transactionform.credit_card_state as credit_card_state, transactionform.credit_card_zip as credit_card_zip, transactionform.credit_card_country as credit_card_country, transactionform.credit_card as credit_card, transactionform.credit_card_exp as credit_card_exp, transactionform.credit_card_type as credit_card_type, transactionform.benificiary_name as benificiary_name, transactionform.benificiary_address as benificiary_address, transactionform.benificiary_address2 as benificiary_address2, transactionform.benificiary_city as benificiary_city, transactionform.benificiary_state as benificiary_state, transactionform.benificiary_country as benificiary_country, transactionform.benificiary_phone as benificiary_phone, transactionform.benificiary_alt_phone as benificiary_alt_phone, transactionform.benificiary_zip as benificiary_zip, transactionform.credit_card_cvc as credit_card_cvc, transactionform.credit_card_address as credit_card_address, transactionform.credit_card_name as credit_card_name, transactionform.credit_card_company_message as credit_card_company_message, transactionform.currency_type as currency_type, transactionform.total_charges as total_charges, transactionform.credit_card_company_authorization_code as credit_card_company_authorization_code, transactionform.credit_card_company_response_message as credit_card_company_response_message, transactionform.credit_card_address2 as credit_card_address2, transactionform.service_fees as service_fees, transactionform.fees as fees, transactionform.date as date, transactionform.tranfer_type as tranfer_type, transactionform.process as process, transactionform.convert as convert, transactionform.cam_custservice_notes as cam_custservice_notes, transactionform.credit_card_company as credit_card_company, transactionform.credit_card_phone as credit_card_phone FROM transactionform transactionform WHERE (date>=? ) ORDER BY date asc