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.
