Databases
StackOverflow2013
Postsdbo
POColdFusion JDBC Connection String Issue
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POColdFusion JDBC Connection String Issue
    primarykey
    data
    text
    <p>I'm trying to setup a 3rd party JDBC driver as a datasource, but it appears to not matter what I put in the Connection String field in CFAdmin, it doesn't seem to use it at all.</p> <pre><code>User=user@account.com;Password=!password; </code></pre> <p>Errors out with <code>Login failed: You must provide a user and password to login.</code></p> <p>I tried putting random text into the Connection String field expecting it to error out, but nothing happened either.</p> <p>I was wondering if I was entering the data wrong (I also tried the entire connection string with the jdbc:, but that did not work either) or if there was some way to verify the entire connection string that ColdFusion was trying to use.</p> <p>I'm not trying anything special inside of my cfquery tag: <code>&lt;cfquery name="output" datasource="mySource"&gt;</code> so that should not be the issue. I can get around the user/password issue by hard-coding these values in the cfquery tag, but there is a 3rd key that I need to provide as a connection value as well.</p> <p>The issue shouldn't be with my connection string, because the following worked with pure Java:</p> <p><code>conn = DriverManager.getConnection("jdbc:mydriver:User=user;Password=password;AccessToken=accessToken;");</code></p> <p>.</p> <p>An interesting addition...ColdFusion appears to not care at ALL what is at the end of my URL as long as the beginning is correct...</p> <p><code>jdbc:mydriverrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr:</code></p> <p>gives the username/password error. Whereas:</p> <p><code>jdbc:mydriveer:</code></p> <p>gives me an "unable to find driver" error.</p> <p>.</p> <p>edit: I also experience this issue in CF9, so it isn't just an issue with CF10</p> <p>.</p> <p>edit: I'm able to set the username/password inside of the CF datasource settings, but it still appears to be ignoring anything I put at the end of the URL or in the connection strings (AccessToken is still needed).</p> <p>.</p> <p>edit: I tried a DSNless connection: <a href="http://www.hostmysite.com/support/cfusion/dsnless/" rel="nofollow">http://www.hostmysite.com/support/cfusion/dsnless/</a> but it behaves similarly to CFAdmin, whereas it is ignoring the connection string portion.</p> <p><code>Login failed: You must provide a user and password to login.</code></p> <p>..</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USdoyler
    1. USdoyler
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload