Re: [OpenBD] datasource credentials override

[Alan Holden]

Are you running OpenBD under Tomcat? I ask because I wonder if this is related to another thread we had recently - in which some of us had to restart Tomcat in order for some settings changes made via the administrator (like email server, datasource values) to actually take place. I'm not sure if it will help your issue, but I'm curious if your xml is being read into OpenBD on startup - and from that point on the settings are immutable - no matter what you change via the admin - until you restart the J2EE container. Al Holden On 6/7/2013 10:51 AM, reece.garr...@gmail.com wrote: Since upgrading from OpenBD 2.0 to OpenBD 3.0 the username and password in cfquery no longer override the username and password set in bluedragon.xml. Is this a bug or do I need to alter my configuration in some way? Below are my datasource and query (scrubbed for security). In 2.0 the query runs as "anotheruser" but in 3.0 it runs as "testuser". My datasource config: <datasource name="foo">       <displayname>foo</displayname>       <password>bar</password>       <connectionretries>0</connectionretries>       <sqldelete>true</sqldelete>       <sqlupdate>true</sqlupdate>       <username>testuser</username>       <drivername>com.sybase.jdbc4.jdbc.SybDataSource</drivername>       <sqlstoredprocedures>true</sqlstoredprocedures>       <perrequestconnections>false</perrequestconnections>       <sqlinsert>true</sqlinsert>       <sqlselect>true</sqlselect>       <connectiontimeout>120</connectiontimeout>       <port></port>       <server></server>       <databasename></databasename>       <description></description>       <connectstring></connectstring>       <verificationquery>select srvname from sysservers</verificationquery>       <logintimeout>120</logintimeout>       <initstring></initstring>       <hoststring>jdbc:sybase:Tds:server.my.domain:5000/master?APPLICATIONNAME=OpenBlueDragon</hoststring>       <maxconnections>24</maxconnections>       <name>foo</name>     </datasource> My query: <cfquery name="Authenticate"  DATASOURCE="foo" username="anotheruser" password="password123" > select * from foo_table </cfquery> -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en   --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.     -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en   --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to openbd+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.