Skip to content

ODBC driver support

Using the PostgreSQL ODBC driver Rocto reports the following error. It would be nice to initially no-op this query to make ODBC work so that an ODBC-JDBC bridge isn't necessary (and even then I think we'd have the same issue).

[ INFO] /home/vehu/octo/src/rocto.c:91 2019-04-03 12:31:01 : Client connected
[TRACE] /home/vehu/octo/src/rocto/send_message.c:31 2019-04-03 12:31:01 : Entering send_message
[TRACE] /home/vehu/octo/src/rocto/send_message.c:34 2019-04-03 12:31:01 : Sending message of type R and length 12
[TRACE] /home/vehu/octo/src/rocto/send_message.c:31 2019-04-03 12:31:01 : Entering send_message
[TRACE] /home/vehu/octo/src/rocto/send_message.c:34 2019-04-03 12:31:01 : Sending message of type R and length 8
session length: 16
[TRACE] /home/vehu/octo/src/rocto/rocto_main_loop.c:47 2019-04-03 12:31:01 : Entering rocto_main_loop
[TRACE] /home/vehu/octo/src/rocto/send_message.c:31 2019-04-03 12:31:01 : Entering send_message
[TRACE] /home/vehu/octo/src/rocto/send_message.c:34 2019-04-03 12:31:01 : Sending message of type Z and length 5
[TRACE] /home/vehu/octo/src/rocto/rocto_main_loop.c:82 2019-04-03 12:31:01 : Read message of type Q and length 80
[ INFO] /home/vehu/octo/src/run_query.c:77 2019-04-03 12:31:01 : Generating SQL for cursor 12394
[ INFO] /home/vehu/octo/src/run_query.c:79 2019-04-03 12:31:01 : Parsing SQL command SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation
[ERROR] /home/vehu/octo/src/parse_line.c:53 2019-04-03 12:31:01 : Error parsing statement: SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation
[ INFO] /home/vehu/octo/src/run_query.c:81 2019-04-03 12:31:01 : Done!
[ INFO] /home/vehu/octo/src/run_query.c:87 2019-04-03 12:31:01 : Returning failure from run_query
Result: 0Making error Error with syntax near (line 1, column 0):
SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation
^^^
syntax error, unexpected SET
[TRACE] /home/vehu/octo/src/rocto/send_message.c:31 2019-04-03 12:31:01 : Entering send_message
[TRACE] /home/vehu/octo/src/rocto/send_message.c:34 2019-04-03 12:31:01 : Sending message of type E and length 173
[ INFO] /home/vehu/octo/src/run_query.c:77 2019-04-03 12:31:01 : Generating SQL for cursor 12395
[ INFO] /home/vehu/octo/src/run_query.c:79 2019-04-03 12:31:01 : Parsing SQL command SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation
[TRACE] /home/vehu/octo/src/find_table.c:29 2019-04-03 12:31:01 : Searching for table ET
[ERROR] /home/vehu/octo/build/parser.y:634 2019-04-03 12:31:01 : Unknown table: ET
[ERROR] /home/vehu/octo/src/parse_line.c:53 2019-04-03 12:31:01 : Error parsing statement: SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation
[ INFO] /home/vehu/octo/src/run_query.c:81 2019-04-03 12:31:01 : Done!
[ INFO] /home/vehu/octo/src/run_query.c:87 2019-04-03 12:31:01 : Returning failure from run_query
Making error
SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation
^^
[TRACE] /home/vehu/octo/src/rocto/send_message.c:31 2019-04-03 12:31:01 : Entering send_message
[TRACE] /home/vehu/octo/src/rocto/send_message.c:34 2019-04-03 12:31:01 : Sending message of type E and length 101
[ INFO] /home/vehu/octo/src/run_query.c:77 2019-04-03 12:31:01 : Generating SQL for cursor 12396
[ INFO] /home/vehu/octo/src/run_query.c:79 2019-04-03 12:31:01 : Parsing SQL command SET DateStyle = 'ISO';SET extra_float_digits = 2;show transaction_isolation
[TRACE] /home/vehu/octo/src/find_table.c:29 2019-04-03 12:31:01 : Searching for table how
[ERROR] /home/vehu/octo/build/parser.y:634 2019-04-03 12:31:01 : Unknown table: how