Skip to content

Instantly share code, notes, and snippets.

@jamesgecko
Created April 16, 2012 21:40
Show Gist options
  • Save jamesgecko/2401782 to your computer and use it in GitHub Desktop.
Save jamesgecko/2401782 to your computer and use it in GitHub Desktop.
Sequel::DatabaseError at /customer
NativeException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
file: jdbc.rb location: execute line: 235
BACKTRACE
(condense)
JUMP TO: GET POST COOKIES ENV
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/adapters/jdbc.rb in execute
yield log_yield(sql){stmt.executeQuery(sql)}
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/database/logging.rb in log_yield
return yield if @loggers.empty?
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/adapters/jdbc.rb in execute
yield log_yield(sql){stmt.executeQuery(sql)}
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/adapters/jdbc.rb in statement
yield stmt
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/adapters/jdbc.rb in execute
statement(conn) do |stmt|
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/connection_pool/threaded.rb in hold
yield conn
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/database/connecting.rb in synchronize
@pool.hold(server || :default, &block)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/adapters/jdbc.rb in execute
synchronize(opts[:server]) do |conn|
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/dataset/actions.rb in execute
@db.execute(sql, {:server=>@opts[:server] || :read_only}.merge(opts), &block)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/adapters/jdbc.rb in fetch_rows
execute(sql){|result| process_result_set(result, &block)}
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/dataset/actions.rb in each
fetch_rows(select_sql){|r| yield r}
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/dataset/actions.rb in columns
ds.each{break}
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sequel-3.34.1/lib/sequel/model/base.rb in columns
@columns || set_columns(dataset.naked.columns)
C:/Users/denton/code/portal/sscce.rb in HEAD /customer
a = Email.columns
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in compile!
proc { |a,p| unbound_method.bind(a).call } ]
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in route!
route_eval { block[*args] }
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in route_eval
throw :halt, yield
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in route!
route_eval { block[*args] }
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in process_route
block ? block[self, values] : yield(self, values)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in process_route
catch(:pass) do
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in route!
pass_block = process_route(pattern, keys, conditions) do |*args|
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in route!
routes.each do |pattern, keys, conditions, block|
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in dispatch!
route!
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in call!
invoke { dispatch! }
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in invoke
res = catch(:halt) { yield }
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in invoke
res = catch(:halt) { yield }
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in call!
invoke { dispatch! }
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in call
dup.call!(env)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/rack-protection-1.2.0/lib/rack/protection/xss_header.rb in call
status, headers, body = @app.call(env)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/rack-protection-1.2.0/lib/rack/protection/path_traversal.rb in call
app.call env
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/rack-protection-1.2.0/lib/rack/protection/json_csrf.rb in call
status, headers, body = app.call(env)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/rack-protection-1.2.0/lib/rack/protection/base.rb in call
result or app.call(env)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/rack-protection-1.2.0/lib/rack/protection/xss_header.rb in call
status, headers, body = @app.call(env)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/rack-1.4.1/lib/rack/logger.rb in call
@app.call(env)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/rack-1.4.1/lib/rack/head.rb in call
status, headers, body = @app.call(env)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/rack-1.4.1/lib/rack/methodoverride.rb in call
@app.call(env)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/showexceptions.rb in call
@app.call(env)
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in call
synchronize { prototype.call(env) }
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in synchronize
yield
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/sinatra-1.3.2/lib/sinatra/base.rb in call
synchronize { prototype.call(env) }
c:/dev/jruby-1.6.7/lib/ruby/gems/1.8/gems/rack-1.4.1/lib/rack/handler/webrick.rb in service
status, headers, body = @app.call(env)
c:/dev/jruby-1.6.7/lib/ruby/1.9/webrick/httpserver.rb in service
si.service(req, res)
c:/dev/jruby-1.6.7/lib/ruby/1.9/webrick/httpserver.rb in run
server.service(req, res)
c:/dev/jruby-1.6.7/lib/ruby/1.9/webrick/server.rb in start_thread
block ? block.call(sock) : run(sock)
GET
No GET data.
POST
No POST data.
COOKIES
Variable Value
PHPSESSID
"72cjekgbet5ivq7c2kgj4h5t26"
rack.session
"BAh7ByIPc2Vzc2lvbl9pZCJFN2QxMTExM2MyYTkyOGVlZmZkY2JkYzI5MGMz\nMjNlYjZkNzEwMzBmY2JlYmJlNzgyZTZhOTgyNmY2Yjc4ZWNjYSINdHJhY2tp\nbmd7CCIUSFRUUF9VU0VSX0FHRU5UIi04ZTc3NzAyZTE5ZTA5NWZiYTU4YTJh\nZWZhYThlY2ViZjE5OWQ5OGQwIhlIVFRQX0FDQ0VQVF9FTkNPRElORyItZWQy\nYjNjYTkwYTRlNzIzNDAyMzY3YTFkMTdjOGIyODM5Mjg0MjM5OCIZSFRUUF9B\nQ0NFUFRfTEFOR1VBR0UiLWNjOWY2ZmVjNjUyYTQyNThiYzZkMjkyODcwNTIx\nNzlhYjFlMGQxNDc=\n"
Rack ENV
Variable Value
GATEWAY_INTERFACE
CGI/1.1
HTTP_ACCEPT
text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_CHARSET
ISO-8859-1,utf-8;q=0.7,*;q=0.3
HTTP_ACCEPT_ENCODING
gzip,deflate,sdch
HTTP_ACCEPT_LANGUAGE
en-US,en;q=0.8
HTTP_CACHE_CONTROL
max-age=0
HTTP_CONNECTION
keep-alive
HTTP_COOKIE
PHPSESSID=72cjekgbet5ivq7c2kgj4h5t26; rack.session=BAh7ByIPc2Vzc2lvbl9pZCJFN2QxMTExM2MyYTkyOGVlZmZkY2JkYzI5MGMz%0AMjNlYjZkNzEwMzBmY2JlYmJlNzgyZTZhOTgyNmY2Yjc4ZWNjYSINdHJhY2tp%0Abmd7CCIUSFRUUF9VU0VSX0FHRU5UIi04ZTc3NzAyZTE5ZTA5NWZiYTU4YTJh%0AZWZhYThlY2ViZjE5OWQ5OGQwIhlIVFRQX0FDQ0VQVF9FTkNPRElORyItZWQy%0AYjNjYTkwYTRlNzIzNDAyMzY3YTFkMTdjOGIyODM5Mjg0MjM5OCIZSFRUUF9B%0AQ0NFUFRfTEFOR1VBR0UiLWNjOWY2ZmVjNjUyYTQyNThiYzZkMjkyODcwNTIx%0ANzlhYjFlMGQxNDc%3D%0A
HTTP_HOST
localhost:4567
HTTP_USER_AGENT
Mozilla/5.0 (Windows NT 6.0) AppleWebKit/535.19 (KHTML, like Gecko) Chrome/18.0.1025.152 Safari/535.19
HTTP_VERSION
HTTP/1.1
PATH_INFO
/customer
QUERY_STRING
REMOTE_ADDR
0:0:0:0:0:0:0:1
REMOTE_HOST
0:0:0:0:0:0:0:1
REQUEST_METHOD
GET
REQUEST_PATH
/customer
REQUEST_URI
http://localhost:4567/customer
SCRIPT_NAME
SERVER_NAME
localhost
SERVER_PORT
4567
SERVER_PROTOCOL
HTTP/1.1
SERVER_SOFTWARE
WEBrick/1.3.1 (Ruby/1.9.2/2012-02-22)
rack.errors
#<Object:0xc9d6d3>
rack.input
#<StringIO:0x1a9fa4c>
rack.logger
#<Logger:0x6fa9f9 @logdev=#<Logger::LogDevice:0x1002d1f @shift_age=nil, @filename=nil, @dev=#<IO:fd 2>, @mutex=#<Logger::LogDevice::LogDeviceMutex:0x925e1f @mon_count=0, @mon_mutex=#<Mutex:0x1616864>, @mon_owner=nil>, @shift_size=nil>, @formatter=nil, @progname=nil, @default_formatter=#<Logger::Formatter:0xcb13b @datetime_format=nil>, @level=1>
rack.multiprocess
false
rack.multithread
true
rack.request.cookie_hash
{"PHPSESSID"=>"72cjekgbet5ivq7c2kgj4h5t26", "rack.session"=>"BAh7ByIPc2Vzc2lvbl9pZCJFN2QxMTExM2MyYTkyOGVlZmZkY2JkYzI5MGMz\nMjNlYjZkNzEwMzBmY2JlYmJlNzgyZTZhOTgyNmY2Yjc4ZWNjYSINdHJhY2tp\nbmd7CCIUSFRUUF9VU0VSX0FHRU5UIi04ZTc3NzAyZTE5ZTA5NWZiYTU4YTJh\nZWZhYThlY2ViZjE5OWQ5OGQwIhlIVFRQX0FDQ0VQVF9FTkNPRElORyItZWQy\nYjNjYTkwYTRlNzIzNDAyMzY3YTFkMTdjOGIyODM5Mjg0MjM5OCIZSFRUUF9B\nQ0NFUFRfTEFOR1VBR0UiLWNjOWY2ZmVjNjUyYTQyNThiYzZkMjkyODcwNTIx\nNzlhYjFlMGQxNDc=\n"}
rack.request.cookie_string
PHPSESSID=72cjekgbet5ivq7c2kgj4h5t26; rack.session=BAh7ByIPc2Vzc2lvbl9pZCJFN2QxMTExM2MyYTkyOGVlZmZkY2JkYzI5MGMz%0AMjNlYjZkNzEwMzBmY2JlYmJlNzgyZTZhOTgyNmY2Yjc4ZWNjYSINdHJhY2tp%0Abmd7CCIUSFRUUF9VU0VSX0FHRU5UIi04ZTc3NzAyZTE5ZTA5NWZiYTU4YTJh%0AZWZhYThlY2ViZjE5OWQ5OGQwIhlIVFRQX0FDQ0VQVF9FTkNPRElORyItZWQy%0AYjNjYTkwYTRlNzIzNDAyMzY3YTFkMTdjOGIyODM5Mjg0MjM5OCIZSFRUUF9B%0AQ0NFUFRfTEFOR1VBR0UiLWNjOWY2ZmVjNjUyYTQyNThiYzZkMjkyODcwNTIx%0ANzlhYjFlMGQxNDc%3D%0A
rack.request.query_hash
{}
rack.request.query_string
rack.run_once
false
rack.url_scheme
http
rack.version
[1, 1]
sinatra.error
#<Sequel::DatabaseError: NativeException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.>
You're seeing this error because you have enabled the show_exceptions setting.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment