Does anyone have experience connecting a postgres ...
# luceej
jumpmaster
05/13/2022, 10:35 PMDoes anyone have experience connecting a postgres db to lucee running on heroku? All I can access is the connection string as an environment var, but when I try to add the db and run a query I just get
java.lang.NullPointerExceptionjumpmaster
05/13/2022, 10:36 PMApplication.cfc
Copy code
this.datasources["test"] = {
class: 'org.postgresql.Driver',
bundleName: 'org.postgresql.jdbc42',
bundleVersion: '9.4.1212',
connectionString: 'jdbc:' & connectionString
};jumpmaster
05/13/2022, 10:37 PMLucee 5.3.8.206
z
zackster
05/14/2022, 3:26 AMAs a crime scene investigator, the top of the stack trace would be really helpful, plus any caused by at the bottom
š 1
b
bdw429s
05/14/2022, 3:51 AMYep, just the exception class name tells us norhing.
j
jumpmaster
05/14/2022, 3:49 PMb
bdw429s
05/14/2022, 9:20 PM@jumpmaster Sorry So the line the NPE is coming from appears to be
Copy code
stat = dc.getConnection().createStatement();dcgetConnection()bdw429s
05/14/2022, 9:21 PMI would assume the issue itself is in the driver. Did you recently update to a newer version of the driver, or has this never worked for you?
j
jumpmaster
05/14/2022, 9:33 PM@bdw429s It has never worked for me
b
bdw429s
05/14/2022, 9:34 PMOh, interesting. Well, I've used Postgres in Lucee so I know it works in general
bdw429s
05/14/2022, 9:34 PMI can't imagine running in Heroku would make much of a difference
bdw429s
05/14/2022, 9:34 PMAre you just running a normal CFQuery with a select?
bdw429s
05/14/2022, 9:35 PMThat error is happening before the query is even sent to the DB, so I'd think perhaps it's related to the actual connection information.
bdw429s
05/14/2022, 9:36 PMI've seen NPEs before when the connection string was invalid was empty, so I'd check that maybe and see if it's all in the correct place
bdw429s
05/14/2022, 9:37 PMSee this ticket for reference
https://luceeserver.atlassian.net/browse/LDEV-1422
bdw429s
05/14/2022, 9:38 PMI don't know if it's related but it's another place I've seen an NPE come from an invalid connection string
j
jumpmaster
05/14/2022, 9:39 PMRunning postgres locally hasn't been a problem, just connecting to the db on heroku is causing hickups. All queries have been normal cfquery Selects and queryExecute. I doubt the query was the issue, to test the connection I have even just been doing
SELECT 1 + 1;b
bdw429s
05/14/2022, 9:39 PMWhat is the contents of the
connectionStringbdw429s
05/14/2022, 9:40 PMIf it's coming from an env var, it could be empty!
j
jumpmaster
05/14/2022, 9:41 PMjumpmaster
05/14/2022, 9:42 PMits an env var, heroku uses DATABASE_URL by default. Made sure it is not empty
jumpmaster
05/14/2022, 9:47 PMI have also tried parsing the username and password from the string and including them separately, but that did not work
jumpmaster
05/17/2022, 5:33 PM@bdw429s I think I found the issue. Heroku postgres requires an ssl certificate which my localhost did not have, and I had not yet added to the heroku project.
š 1
b
bdw429s
05/17/2022, 6:06 PM@jumpmaster Wow, interesting. So the managed MySQL instances on Heroku explicitly disallow a user/pass authentication?
j
jumpmaster
05/17/2022, 6:35 PM@bdw429s I'm not sure about mysql, but I think that's the case for the heroku specific postgres plugin. Most of this is above my head at the moment, but I'm working on it
b
bdw429s
05/17/2022, 6:41 PMoh sorry, I meant to say Postgres. I cross this thread with another thread about MySQL
3 Views