search

rossini / starschema-bigquery-jdbc

Automatically exported from code.google.com/p/starschema-bigquery-jdbc
0 stars 0 forks source link

Support SQuirreL SQL #1

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
SQuirreL SQL is an excellent tool for making JDBC connections to any database. 
It would be an excellent milestone if starschema-bigquery-jdbc were able to 
work with SQuirreL SQL.

Currently, it's easy to define a connection using this driver in SQuirreL. It 
seems to connect. But the connection does not provide the JDBC metadata to 
browse tables. More importantly, queries which work in the BigQuery browser 
interface do not function in SQuirreL. It seems that the query executes 
correctly... but the resultset is not returned and displayed.

Original issue reported on code.google.com by matt.dah...@gmail.com on 7 Sep 2012 at 6:12

GoogleCodeExporter commented 8 years ago 
Thanks for reporting this issue, we will try to reproduce it in our environment

Original comment by tfo...@starschema.net on 8 Sep 2012 at 5:49

GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
Matt: Could you send some log files or screenshots regarding your problem? I 
tried the driver with System Account and with Oauth2 and both works fine for me.

Please share more information on the issue

Original comment by tfo...@starschema.net on 10 Sep 2012 at 12:03

Attachments:

GoogleCodeExporter commented 8 years ago 
Hmmm... I guessed it would be easy to reproduce. I guess it's more subtle. I'm 
really glad it's working in SQuirreL for you at least. That's promising.

Here are my details. Hopefully this is enough for you to see what I'm doing 
wrong or what's wrong in the driver. The attached screenshot shows the results 
that I get for [all] queries.

1. I can see that I connect and the query executes. This confirmed looking at 
BigQuery reports online as well as looking at the SQuirreL Log:
2012-09-10 08:52:33,315 [Thread-8] INFO  
net.starschema.clouddb.jdbc.BigQueryApi  - Inserting Query Job: SELECT corpus, 
corpus_date FROM publicdata:samples.shakespeare GROUP BY corpus, corpus_date 
ORDER BY corpus_date DESC LIMIT 10
2012-09-10 08:52:34,559 [Thread-8] INFO  
net.starschema.clouddb.jdbc.BigQueryApi  - Job status: RUNNING ; 
job_bb039ad9f2f446dc8e0ab7245e3d2f81 ; 544
2012-09-10 08:52:35,363 [Thread-8] INFO  
net.starschema.clouddb.jdbc.BigQueryApi  - Job status: DONE ; 
job_bb039ad9f2f446dc8e0ab7245e3d2f81 ; 1348

Therefore I'm assuming my connection info is good, and I'm not including 
details about that.

2. I'm using a later snapshot of SQuirreL. This seems very unlikely to be the 
cause of the problem. But it's certainly possible. I'm using "SQuirreL SQL 
Client Snapshot-20120812_2001".
3. I'm using SQuirreL on Mac OS X. This also seems unlikely to be the cause of 
the problem... but again I suppose it's possible.
4. I'm using Java 1.6. More precisely it's "1.6.0_35-b10-428-10M3811"

I can probably test on a Windows environment, but I cannot do it immediately. 
I'll update this issue if I have more results.

Original comment by matt.dah...@gmail.com on 10 Sep 2012 at 4:03

Attachments:

GoogleCodeExporter commented 8 years ago 
I assume your connection is good, since you couldn't see the sql tab otherwise.

2. Tried with the same version and it works on windows.
3. Also tried it on ubuntu, and it works there too.
   We'll try it on Mac OS X too.

Original comment by guni...@starschema.net on 10 Sep 2012 at 8:31

GoogleCodeExporter commented 8 years ago 
I tried to reproduce the problem on a very similar environment, with no success 
yet. 

SQuirrel Snapshot-20120812-2001
Java 1.6.0_33
Mac 10.7.4
BigQuery JDBC: 0.0.8

Matt: Can you try to show us the console output of SQuirrel? Currently our 
logging mechanism is not ready for public usage, but this way you can help us 
to determinate the problem more easily. 

To do this, you need to start SQuirrel from command line in the following way:
bash /Applications/SQuirreLSQL.app/Contents/MacOS/squirrel-sql.sh

Thanks

Original comment by bor...@starschema.net on 11 Sep 2012 at 10:44

Attachments:

GoogleCodeExporter commented 8 years ago 
Just a note: I use the free version of DbVisualizer and it works great with 
this driver.

Original comment by mark.br...@rightscale.com on 18 Oct 2012 at 7:23

GoogleCodeExporter commented 8 years ago 
Cannot reproduce and reporter was unresponsive

Original comment by tfo...@starschema.net on 30 Nov 2012 at 8:49

GoogleCodeExporter commented 8 years ago

Original comment by tfo...@starschema.net on 30 Nov 2012 at 8:49