Jump to content
We've recently updated our Privacy Statement, available here ×

How do I execute a PreparedStatement for every JDBC Connection


chancelanding

Recommended Posts

For every database connection, the legacy application executes a prepared statement on the JDBC connection, that effectively sets what the connection can read in the database. For every database connection I need to execute a simple script on that connection before executing any additional queries.

How should I go about getting a JDBC connection with this statement executed.  I have looked into creating a DataAdapter that models the Mondian adapter, adding the additional configuration value.  I can do this however I am stuck on how I can get the DataAdapterServiceFactory registered in the ExtensionsRegistry. 

I have solved this in our application by passing the report a JDBC Connection object where I have execute the PreparedStatement ahead of passing the connection to the report.  How do I do the same thing in Jasper Studio/Server, i.e. an external entity?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...