Does anyone know how to connect to their mysql db with JDBC? I'm looking for a basic construct of the connection string.
Announcement
Collapse
No announcement yet.
Connect to DB with JDBC
Collapse
X
-
If you google it, you would find a lot of examples. But why do you need it? Do you want to connect to a vB database using Java? Why don't you just call the vB API instead of directly connecting to the vB database?Helpful? Donate. Thanks!
Fast VPS Host for vBulletin:
A2 Hosting & IONOS
- Top
- Translate
- Bottom
-
Why would you prefer that? Accessing the vB database directly outside vBulletin is dangerous and not recommended for the following reasons:- You would have to store and maintain the database credentials outside vBulletin in that extenal application.
- It bypasses the permission checks done by vB before allowing the data to be written or read to and from the database.
- Modifying the database directly may break the database and thus the site.
- When inserting data into the database, it may insert data into multiple tables and trigger other process. For example, saving a post will insert the data into the node table, closure table and other tables. And then read another table for getting the subscibers to the topic and then send them PM/email notifications that a new post was submitted to the topic. You will have to duplicate the same logic/process that's already coded in vBulletin and do the same things in the external application. You're basically reinventing the wheel.
Helpful? Donate. Thanks!
Fast VPS Host for vBulletin:
A2 Hosting & IONOS
- Top
- Translate
- Bottom
Comment
Users Viewing This Page
Collapse
There is 1 user viewing this forum topic.
- Guest
Latest Posts
Collapse
-
Get Affordable and Fast VPS for vBulletin -
Reply to Topic Starter Ribbon for vBCloudby glennrocksvbThanks for reporting. I'll bookmark this post and check the issue.04-22-2024, 06:40 PM
Comment