Null Pointer Exception in Java Application – Need Fixing Programming Software Development by YashSmith My Java application crashes with a NullPointerException when trying to access an … Re: Database Connection Failing in MySQL – Need to Hire Developers in the USA Programming by rproffitt Isn't that a little basic for the Dev Technosys company to not fix themselves? What happened to the coders and developers you had? Buggy career talk :-P Programming by Dani … past is not realizing that you can’t use a MySQL transaction from within a persistent connection. Here’s [when I… lesson](https://www.daniweb.com/programming/web-development/threads/540571/mysql-packets-out-of-order). As far as the single biggest… Re: Which is the best email marketing tool you ever used? Digital Media Digital Marketing by ashleydent4u … is the one that fits your workflow and helps you connect with your audience effectively! Re: Buggy career talk :-P Programming by Reverend Jim The most challenging bug was one I introduced myself. While making a miniscule code change I decided to improve the readability of the following line by inserting a space. In today's code that would not be a problem, however, most of our code (AGC/SCADA) was written in FORTRAN. Those of you who made your bones in the punch card era, or know a … Re: Buggy career talk :-P Programming by pritaeas The one with the most impact was a Firebird library update, which appeared low to no impact. After deploying at a customer, the library soon showed a complete disregard for database transactions. This mangled the client's database completely and caused us to retrace all changes by hand to undo the damage done. Several weeks worth of misery... … Multiple MySQL connections + transactions Programming Databases by Dani … can I write to a database using a MySQL connection in the middle of a transaction with a… different connection? e.g. // Open Connection 1 and connect to Database A // Start transaction with Connection 1 // … some stuff with Connection 1 // Open Connection 2 and connect to Database B // Write some stuff with Connection 2… Re: Multiple MySQL connections + transactions Programming Databases by Reverend Jim As far as I know you can connect to more than one database at a time but you … Re: Multiple MySQL connections + transactions Programming Databases by Dani I am already using multiple MySQL connections throughout the project, as well as select_db() in some other places. My question specifically revolved around if anyone can explain why select_db() implicitly committed the transaction, and then when done again to return back to the initial database, it did a rollback instead of commit. Database Connection Failing in MySQL – Need to Hire Developers in the USA Programming by YashSmith I'm facing a database connection error in my MySQL-based application. The credentials are correct, but I keep getting: … 'admin'@'localhost' Is it a privilege issue, host misconfiguration, or MySQL version mismatch? Seeking expert developers in the USA to resolve… Re: Multiple MySQL connections + transactions Programming Databases by Dani A slightly related question: Is it okay to use PHP's `mysqli::select_db()` function to switch databases in the middle of a transaction? This is what got me into trouble in the first place, when I started a transaction, performed some writes, switched databases, and then wrote to that second database, and then switched back, and performed some … Re: Multiple MySQL connections + transactions Programming Databases by Salem https://www.php.net/manual/en/mysqli.select-db.php I think the key word in all of this is "default". You can probably do what you want, but you have to refer to each DB by it's own handle. Using `select_db` is fine, if you only have one DB and you want to be lazy about referring to it. So you make it the default DB. But as … Re: Multiple MySQL connections + transactions Programming Databases by Reverend Jim In that case I can't suggest anything. I've never had to update multiple databases for any of the systems I set up. Re: Multiple MySQL connections + transactions Programming Databases by toneewa You're not suppose to switch databases with a connection mid-transaction. It's by design to rollback because it considers it a change to the session context. XA Transactions can be done if you use the InnoDB storage engine. Create separate PDO connections for each database. I wonder what kind of results you get with autocommit, serializable … Re: Multiple MySQL connections + transactions Programming Databases by Dani > If the databases are on the same server and use InnoDB, you can use fully qualified table names, and write to multiple databases on a single connection. That's what I ultimately started doing instead! Thank you so much for a definitive answer to my question. Re: How to connect to the Pinterest API using PHP? Programming Web Development by Dani Oh, it looks as if the tutorial was for the old DaniWeb API that no longer exists. The [DaniWeb Connect API](https://www.daniweb.com/connect/developers) is also OAuth-based and has some of its own documentation. Re: How to connect to the Pinterest API using PHP? Programming Web Development by Dani … create one [here](https://developers.pinterest.com/docs/getting-started/connect-app/) as that's the first step. Also, it looks… Excited to Join DaniWeb! 🚀 Community Center Say Hello! by aimodapk … AI innovations in mobile apps with the community. Excited to connect with like-minded tech enthusiasts! What’s the most impressive… Hi, my name is Kevin Community Center Say Hello! by dawsondeandre I'm absolutely delighted to become a part of this amazing forum! It's exciting to connect with like-minded individuals and exchange ideas in such a supportive community. I can't wait to contribute, learn, and be inspired by everyone here! How to connect to the Pinterest API using PHP? Programming Web Development by FarrisFahad I want to post Pins using Pinterest API. I have tried to generate code using ChatGPT but it returns an error. Here is my code so far ... <?php $clientId = "xxx"; // Replace with your App ID $clientSecret = "xxx"; // Replace with your App Secret $redirectUri = "xxx"; // Must match … Re: Contact form does not working Programming Web Development by Biiim … password'; //SMTP password $mail->Port = 587; //TCP port to connect to; use 587 if you have set `SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS… Re: How Can I Hookup My Mobile Phones To My PC Monitor ? Hardware and Software Hardware Mobile and Wearables by Fitmovers If you want to connect your Samsung Galaxy A9 to your Dell E1916HV monitor, you'll need a USB-C to HDMI adapter (if your phone supports HDMI output). Since your phone has only USB ports, check if it supports Samsung DeX or screen mirroring via an MHL adapter. If your monitor only has VGA input, you might also need an HDMI to VGA converter. Re: Hello Everyone, I'm Ray Brad Programming Software Development by elary Salesforce is a great product Re: Hello Everyone, I'm Ray Brad Programming Software Development by Dani > Hi Ray, > can you guide what kind of this error is ? i am getting this on my e-commerce store which is on shopify. I got to know this error from microsoft clarity summary. (Most users encountered JavaScript errors on various product pages, such as "t[n] is not a function" and "Cannot read properties of null (reading '… Re: Theory on the VPN Programming Mobile Development by Mr.M I guess a more research on this has to be made, problem is that it is hard to get the exact people who knows this and has done it before to give straight answers. Re: Excited to Join DaniWeb! 🚀 Community Center Say Hello! by pritaeas Welcome. Re: Excited to Join DaniWeb! 🚀 Community Center Say Hello! by Dani Hi and welcome!! Re: Hi, my name is Kevin Community Center Say Hello! by Reverend Jim Hello and welcome to Daniweb. Re: Hi, my name is Kevin Community Center Say Hello! by Dani Hi and welcome to DaniWeb! Re: Page Speed Issue Digital Media Digital Marketing by bngwebguru ​Optimizing JavaScript performance is a key factor in improving Core Web Vitals. Efficient coding practices, minimizing render-blocking resources, and utilizing CDNs like Cloudflare or Fastly can significantly improve page speed, regardless of backend technology. ​