SQL error 1064 when saving with mysql 4.0
Posted by: Julien Craan
Date: February 08, 2005 10:14PM

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

Options: ReplyQuote


Subject
Written By
Posted
SQL error 1064 when saving with mysql 4.0
February 08, 2005 10:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.