BigQuery connectivity from Java Struts

[mdideles]

Is there any reference or docs about the Java Struts and Bigquery?

I was asked how to connect BigQuery from Java Struts applications runs in WAS liberty.

[ms4446 · Accepted solution]

While there aren't specific documents or references dedicated to integrating Java Struts and Google Cloud BigQuery directly, you can still effectively connect BigQuery to your Java Struts application using the available BigQuery Java libraries. Here's how you can do it:

1. Google Cloud BigQuery Java Client Library:

   • This official library is designed for Java applications to interact with BigQuery. It supports various operations, including running queries, managing datasets, loading and exporting data.
   • You can find comprehensive documentation for this library here: Google Cloud BigQuery Java Client Library Documentation.

2. JDBC Driver for Google BigQuery:

   • For those familiar with JDBC, this driver allows your Java application to interact with BigQuery using SQL queries, similar to a traditional relational database.
   • Detailed information about the JDBC driver is available here: JDBC Driver for Google BigQuery Documentation.

3. Integration Steps for Struts Application:

   • Include your chosen library (either the client library or the JDBC driver) in your application's classpath.
   • Configure access to BigQuery, typically using service account credentials.
   • Utilize the library methods or JDBC in your Struts action classes to interact with BigQuery.

4. Additional Resources:

   • For a quick start and practical examples, refer to the BigQuery Java Quickstart.
   • Explore Java samples for BigQuery here: BigQuery Java Samples on GitHub.
   • For insights on connecting to BigQuery from Java Servlets (which can be adapted for Struts), see: Connecting to BigQuery from Java Servlets.

While these resources are not specifically tailored for Struts, the principles of Java development they illustrate are applicable and can be adapted to a Struts framework. It's important to consider the specific requirements of your WAS Liberty environment and verify the compatibility of the libraries with your setup.

While direct Struts-BigQuery integration instructions are scarce, the general Java integration methods provided in these resources can be effectively utilized in a Struts context.

[mdideles]

Thank you very much.  This is very helpful.