cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC connection to remote databases

nanda_kumar21
Active Contributor
0 Kudos

Hi,

We are considering buying JDBC license to connect to SQL server databases in our landscape. We have a requirement to schedule stored procedures directly in the databases

We have M33.104 build on NW7.31 - Windows/SQL server.

  1. What is the estimated cost of one JDBC connection license?
  2. I had a colleague argue that JDBC is a low level connection and doesn't provide enough control, and hence how does the handoff happen? In other words, how does Redwood know that SQL activity has completed once started?
  3. What the drawbacks you have faced?
  4. What are the alternates of not buying the JDBC license? Can we utilise the *.bat scripts to perform the same. Does it provide enough control, meaning that, can Redwood know when the SQL job started and ended and successful or not?

Any experience would be helpful here.

Thanks

Nanda

Accepted Solutions (1)

Accepted Solutions (1)

gmblom
Active Contributor
0 Kudos

Hello Nanda,

1) please contact your Redwood account manager

2) the connector executes the stored procedure or query that you try to run, this automatically makes it wait for it to finish and catch the output and potential exceptions

3) None really

4) Using a JDBC process server gets around two issues you face with the MSSQL command line tooling, and there is an additional benifit.

     a) the JDBC process server keeps checking the connection to the database, if the database is not there, the process server goes red and jobs will hold up until the database is available again. With command line script, they will just all fail and you will have to figure out which one you have to restart and make the process catch up again

     b) the MSSQL command line tooling does not wait for stored procedures or MSSQL jobs to finish, so you have to customize additional controls around it

     c) additional benefit is that you can directly interact with the remote database through RedwoodScript using a Credential to connect. This way it is even easier to do some smart dynamic processing

Regards Gerben

Answers (0)