database
EPM Registry Initialization Fails
The EPM Registry initialization fails in the BIDomain domain. Oracle Fusion General Ledger and Oracle Fusion Customer Relationship Management (CRM) code running within the FinancialsDomain and CRMDomain domains, respectively, has direct integration with the EPM Registry API and consumes EPM Security Component, which also tightly integrates with the EPM Registry API. When EPM Registry initialization fails, it greatly impacts communication with downstream EPM products in the BI domain.
Complex Queries in CakePHP 2.x
With CakePHP, a MVC-based PHP framework, it is usually very easy to retrieve data from the database table underlying a specific model, as well as in case the tables are connected with each other through their respective model declarations, as these tables are then joined automatically.
However, when one wants to join multiple tables within one query and they are not connected through their models (which occurs quite often), then there nevertheless has to be a way to join the desired tables to get the respective data. The goal is to find a way in CakePHP to accomplish this task.
Use of Database for relating user roles to menues
In our application we used the approach to create it flexible by storing the information in database, bascially it consists of 4 tables
User
UserToRole - Assigns roles to users
MenuItems
ItemToRole - Assigns roles to menuitems
MenuItems may link themselves to upper level items for creating the menu structure. It also contains the ordering of the items. If the menu is built top level items are displayed according to user roles. If the toplevel items have subelements the same check is done again. Each menuItem holds the corresponding links to the jsp pages.
Taggings:
Connect to a Postgresql database and select or edit data through R
I am a R user and want to connect to my postgresql database in order to select data for statistical calculations. Afterwards I would also safe the results into the database. Plain SQL statements would suffice.
I am using R 2.12 and postgresql 9.1
Taggings:
Oracle connection error
When you have just installed a database or client Oracle on a computer and want to connect with the parameters that have defined, it generates the error message: ORA-12154: TNS: Could not resolve the connect identifier specified.
Taggings:
Application.LoadCusomUI + xml description
To implement a custom Ribbon element we have to describe it using an XML file defined by the Microsoft CustomUI schema and load it using the Application.LoadCustomUI() procedure.
The root element of the XML file is customUI. Inside of it there is the element ribbon containing all the tabs, buttons etc.
A code snippet for loading of the xml file:
Dim f As Long
Dim strText As String
Dim strOut As String
f = FreeFile
Open "\customUI.xml" For Input As f
Do While Not EOF(f)
Line Input #f, strText
strOut = strOut & strText
Loop
Application.LoadCustomUI "AppRibbon_1", strOut
Sample XML file:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tabs>
<tab id="Tab1" label="Tab1">
<group id="Group" label="Group">
<button id="MyButton1" label="Button1" imageMso="_1"
onAction="doSomeAction"/>
<button id="MyButton2" label="Button2" imageMso="_2"
onAction="doSomeAction2"/>
</group>
<group id="Group2" label="Group2">
<button id="MyButton3" label="Button3" imageMso="_1"
onAction="doSomeAction3"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
Add a custom Ribbon to a database in Access 2007
Ribbon was introduced in Microsoft Office 2007 as part of its "Fluent User Interface" and has became a well known and quite often used part of graphical user interface of applications (specifically on MS Windows).
In MS Access prior the 2007 version the user interface of an database application was implemented by standard GUI elements such as forms, buttons, menus and context menus. The users of MS Office 2007 are used to work with Ribbon and are familiar with its advantages e.g. its shortcut system, we want to provide them with a custom Ribbon interface of Access 2007 database application.
Access Database 2010 Portability
There is a case with a very small company that has recently operated from a database in Access 2010 made in two layers (database programs and link to another database with the data.)
They would be interested in its portability to the web. The question is:
Given that the number of users are few, up to 5 or 6. Sharepoint, web services, MS Office Comunications Server 2007 ... What technology / platform would be well, to use logic layer (the program) and link the db on the server? (Customer has a Windows 2003 server and fixed IP).
Preventing SQL-Injection in a Java application
Sql-Injection is a technique to inject (or execute) SQL commands within an application (database). It is mainly used to gain access to a databases content for which one has no authorization. The method injects SQL commands by providing input to a SQL statement which contains SQL meta-characters.
Example statement: <strong>select * from user where username='input'</strong>
SQL injected input:<strong>user' OR '1'='1</strong>
The final statement:<strong>select * from user where username='user' OR '1'='1'</strong>
Since 1 always equals 1, this statement would return all the users in the database!
Depending on the SQL command, an attacker could insert, modify, extract and delete data in the database.
Pages
