It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Has anyone successfully connected to DB2 database using Bobswift SQL for Confluence?

Hi,

I'm trying to connect to a DB2 database from Confluence to allow us to display table informations from the database onto Confluence. However, I'm having some trouble even though I have network connectivity and no firewall blocking. I just want to know if anyone has successfully used bobswift on DB2 and if so what jdbc driver they used.

The error I get is:

[jcc][t4][2034][11148][4.26.14] Execution failed due to a distribution protocol error that caused deallocation of the conversation. A DRDA Data Stream Syntax Error was detected. Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009

https://www.ibm.com/support/pages/faq-jdbc-driver-data-stream-syntax-error

Cheers.

Gaj

1 answer

0 votes

Hi,

not with that addon, but we use PocketQuery to connect to a DB2 datasource:

https://help.livelyapps.com/documentation/display/PQDOC/Datasources

Best

JP

Hi JP,

Thanks for that. I've never tried PocketQuery but will definitely add it to our POC and check it out. 

Cheers.

Gaj

@JP _AC Bielefeld Leader_  can I ask if you use SSL to connect and if you had to do anything special on the Confluence side apart from having the certificate there and mentioning the certificate on the JDBC URL. 

Hi,

sorry, we don't use SSL on this connection as we have a separate VLAN for these types of access.

Best

JP

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

8,411 views 6 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you