I'm a bit further on this.. after trying to use the old version of the
Administrator that for some reason didn't work really...
I simply tried in my test code with a datasource using my OTR_OTRREP
created datasource using the "new" Adminsitrator this datasource actually
works. Just the Administrator that doesn't know that it works... wierd...
Haven't had time to dig into the administrator to see where things go
wrong... but it for sure does.
On Tuesday, November 10, 2015 at 9:21:12 AM UTC+1, Mats Stromberg wrote:
>
> I'm having an Issue with the OpenBD Administrator and setting up a
> Datasource (Oracle 12.1.0.2) Target.
> Just as info.. I'm using the ojdbc7.jar
>
> I'm not sure, or have forgotten, how the <password></password> info is
> stored in the bluedragon.xml Encrypted or in clear text,
>
> Over the Administrator I get the error "Could not verify datasource:
> General Runtime Error"
>
> If I code a Datasource like..below it connects just fine. I'm not sure
> if this is an issue with the new version of the administrator when it comes
> to the ecryption/decryption of the password in bluedragon.xml
> Anyone run into this issue?
>
> <code>
>
> <cfset s = StructNew() />
> <cfset s.hoststring =
> "jdbc:oracle:thin:@bsl90d-9605.lcsys.ch:1530:dbs524" />
> <cfset s.drivername = "oracle.jdbc.OracleDriver" />
> <cfset s.databasename = "dbs524" />
> <cfset s.username = "OTRREP" />
> <cfset s.password = "Admin12345" />
> <cfset s.port = "1530" />
> <cfset s.logintimeout = "15" />
> <cfset s.connectiontimeout = "5" />
> <cfset s.connectionretries = "2" />
> <cfset s.maxconnections = "20" />
>
> <html>
> <head>
> <title>Test Page OpenBD on Glassfish 4.1.1</title>
> </head>
> <body>
>
> <cfif DataSourceIsValid("DBS524temp")>
> <cfset DataSourceDelete("DBS524temp") />
> </cfif>
> <cfif NOT DataSourceIsValid("DBS524temp")>
> <cfset DataSourceCreate( "DBS524temp", s ) />
> </cfif>
> <cftry>
> <cfquery name="qCheck" datasource="DBS524temp">
> select instance_name, version from v$instance
> </cfquery>
> <table border=1">
> <tr>
> <th>Instance</th><th>Version</th>
> </tr>
> <cfoutput query="qCheck"><tr>
> <td>#qCheck.instance_name#</td><td>#qCheck.version#</td>
> </tr></cfoutput>
> </table>
> <cfif DataSourceIsValid("DBS524temp")>
> <cfset DataSourceDelete("DBS524temp") />
> </cfif>
> <cfcatch type="Database">
> <cfoutput>#cfcatch.queryError#</cfoutput><br />
> Blaha
> </cfcatch>
> </cftry>
>
> </body>
> </html>
>
> </code>
>
> /Mats/
>
--
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
