Home
Search results “Stack trace oracle error”
6. Always log error (and backtrace) before re-raising the exception.
 
02:28
When you re-raise an exception, you will reset the backtrace (the track back to the line on which the error was raised) and might change the error code (if you raise a different exception to propagate the exception "upwards"). So it is extremely important to call you error logging subprogram (see previous Good to Know) before you re-raise an exception. Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2016/03/nine-good-to-knows-about-plsql-error.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
How to Handle Exceptions Properly - Part 3
 
07:21
In this third video in the series, Steven switches gears to talk about to properly handle exceptions: build or find a single reusable logging procedure and call that. Only pass it variables from your current application state that cannot be obtained via built-in calls, like DBMS_UTILITY.FORMAT_ERROR_BACKTRACE. Related LiveSQL Script: https://livesql.oracle.com/apex/livesql/file/content_EHHFC36YW2834RB7Z9OE846C6.html Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2017/02/now-not-to-handle-exceptions.html To download the Logger utility, visit github.com/oraopensource/logger ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
PL/SQL - Visual Stack Trace Analysis!!! (Funny and efficient)
 
03:52
Stack trace analysis could not be more fun than this!!! Visual Stack Trace Analysis using UMLCode for PL/SQL. Tool from http://www.umlcode.com .
Views: 25 UMLCode for PL/SQL
PL/SQL Tutorial : FORALL with SAVE EXCEPTION
 
09:02
PL/SQL Tutorial : FORALL with SAVE EXCEPTION SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 1565 TechLake
Unfortunately App Has Stopped - How to Fix - ONLY FOR PROGRAMMERS - Android Studio Tutorial
 
06:13
If your Android app crashes, then because of an uncaught RuntimeException like a NullPointerException. In this video we will learn, how to read the Logcat stack trace to find out what exception caused our app to crash and where it happened in our code, so we can provide more specific information when we ask for help. Java RuntimeException documentation: https://docs.oracle.com/javase/7/docs/api/java/lang/RuntimeException.html ____________________ Subscribe to my channel: https://www.youtube.com/c/codinginflow?sub_confirmation=1 Want more Android tutorials? Check my playlist section: https://www.youtube.com/c/codinginflow/playlists Follow me on social media: Facebook: https://www.facebook.com/codinginflow Instagram: https://www.instagram.com/codinginflow Twitter: https://twitter.com/codinginflow Blog: https://codinginflow.com/
Views: 22939 Coding in Flow
How To Configure Oracle on XAMPP for Windows - OCI8
 
16:24
With the default installation of XAMPP for Windows, we don’t get PHP Oracle connectivity enabled. This can be enabled easily. PHP has got the OCI8 extension, which provides Oracle connectivity to PHP application, and OCI8 uses Oracle Instant Client Package to get Oracle specific functions. Download the “Instant Client Package – Basic” for Windows from the OTN Instant Client page. URL: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Download the actual Thread Safe OCI-DLLs from: http://pecl.php.net/package/oci8/2.0.8/windows
Views: 35584 Sahil Bhutna
#4- ERROR:ORA-12560: TNS:protocol adapter error
 
01:53
ORA-12560: TNS: protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete. If you are running Oracle on Windows, you may fi the ORA-12560 by running the oradim utility to create a service for the listener. ORA-01031: insufficient privileges While trying / as sysdba https://www.youtube.com/watch?v=vWvZmWJYrik
Views: 307 Houssine Formation
How to resolve SP2-0110: Cannot create save file "afiedt.buf"" Error?
 
02:50
In this tutorial, you'll learn how to overcome SP2-0110: Cannot create save file "afiedt.buf"". PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation.
Views: 3878 radhikaravikumar
VirtualBox  Kernel Panic - not syncing ERROR Fix !!
 
07:31
Music Nocopyright :https://www.youtube.com/watch?v=K7DPiBfyYi8
Views: 1714 Worldie Gaming
Fix Kernel Panic Not Syncing After Upgrade
 
06:34
How to Fix Kernel Panic Not Syncing After Upgrade on Ubuntu Original Video in Hausa: https://youtu.be/tQbFLRTLuFo
Fatal error Call to undefined function mysql connect()
 
03:01
Fatal error Call to undefined function mysql_connect()
Views: 66477 Cỏ
Top Nine Coding Guidelines for Oracle PL/SQL
 
08:00
My take, as of November 2015, of some of the most helpful guidelines to follow when writing PL/SQL code: 1. MAXSQL - maximize use of SQL first and foremost 2. SPOD - single point of definition 3. TRACE - production-available application-level tracing 4. LOG - consistent, encapsulated error logging 5. BULK - avoid row by row 6. OBVIOUS - make your code tell its own story, comment when it can't 7. NESTPROG - use nested subprograms 8. DECLARE - use declarative features of language 9. WARN - use compile-time warnings Accompanying blog post: http://stevenfeuersteinonplsql.blogspot.com/2015/10/your-ideas-for-more-important-plsql.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Solved : Simple Solution for SSRS Report Deployment Fatal Error | GenerateRdlTask" | image size err
 
04:51
Error description and solution is as below. I am able to deploy all the reports from visual studio except Project invoice report. When I am deploying the Project invoice report from visual studio.Error description and solution is as below. I am able to deploy all the reports from visual studio except Project invoice report. When I am deploying the Project invoice report from visual studio.showing and error as Error 1:Unable to connect to the AOS specified in the AX Client Configuration. The configuration could be missing, invalid, or the AOS is not running. To connect to the AOS, check the network connection between the client and the AOS, verify that a valid configuration exists, and that the AOS service is running on the server. C:\Program Files (x86)\MSBuild\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.Reporting.Modeling Error2: The "GenerateRdlTask" task failed unexpectedly. Microsoft.Dynamics.Framework.BusinessConnector.Session.Exceptions.NoKernelSessionException: Unable to connect to the AOS specified in the AX Client Configuration. The configuration could be missing, invalid, or the AOS is not running. To connect to the AOS, check the network connection between the client and the AOS, verify that a valid configuration exists, and that the AOS service is running on the server. --- Microsoft.VisualStudio.Modeling.ModelingException: Unable to connect to the AOS specified in the AX Client Configuration. The configuration could be missing, invalid, or the AOS is not running. To connect to the AOS, check the network connection between the client and the AOS, verify that a valid configuration exists, and that the AOS service is running on the server. --- Microsoft.Dynamics.Framework.BusinessConnector.Session.Exceptions.NoKernelSessionException: No .NET Business Connector session could be found. at Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsAdapter.GetObject(String objectName) at Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsAdapter.Microsoft.Dynamics.Framework.BusinessConnector.Adapter.IAxaptaAdapter.GetObject(String objectName) at Microsoft.Dynamics.Framework.BusinessConnector.Proxy.ProxyObjectBase..ctor(IAxaptaAdapter axaptaAdapter, ProxyClassName className) at Microsoft.Dynamics.Framework.BusinessConnector.OperationExecuter.HandleError(IAxaptaAdapter adapter, Exception businessConnectorException, Collection`1 messages) at Microsoft.Dynamics.Framework.BusinessConnector.OperationExecuter.Execute[T](Collection`1 messages, Func`1 nodeAction) at Microsoft.Dynamics.Framework.Design.Modeling.Interop.TreeNodeOperationExecuter.Execute[T](ITaskLogger logger, Func`1 nodeAction) --- End of inner exception stack trace --- --- End of inner exception stack trace --- at Microsoft.Dynamics.Framework.Design.Modeling.Interop.TreeNodeOperationExecuter.Execute[T](ITaskLogger logger, Func`1 nodeAction) at Microsoft.Dynamics.Framework.Design.Modeling.Interop.TreeNodeOperationExecuter.Execute(ITaskLogger logger, Action nodeAction) at Microsoft.Dynamics.Framework.Deployment.Reports.GenerateRdlTask.SaveReport(ReportDefinition report, TreeNode reportNode, ReportAdapter reportAdapter, Dictionary`2 designRdlMap) at Microsoft.Dynamics.Framework.Deployment.Reports.GenerateRdlTask.Execute() at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute() at Microsoft.Build.BackEnd.TaskBuilder.ExecuteInstantiatedTaskd__20.MoveNext() C:\Program Files (x86)\MSBuild\Microsoft\DynamicsTools\Microsoft.Dynamics.Framework.Design.Reporting.Modeling.targets Investigated whole day to resolve this error Solution: 1- Delete all embedded image in the PSAProjectInvoice report: 2- Save and deploy your Report 3- Create all embedded image and put it in your report 4- Deploy your report.
ERROR MGMT IN PLSQL 5
 
42:11
PLSQL || SQL || DYNAMIC SQL || GOOD PROGRAMMING SKILLS ERROR MANAGEMENT IN PLSQL
Views: 51 Steven Ferusten
How NOT to Handle Exceptions - Part 1
 
06:43
In which Steven Feuerstein takes a look at several ways you should never handle an exception in your PL/SQL block. To summarize: 1. Don't swallow up or hide errors. 2. Don't simply display error information on the screen through a call to DBMS_OUTPUT.PUT_LINE. 3. Don't handle and re-raise without adding value (logging or doing *something*). Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2017/02/now-not-to-handle-exceptions.html Related LiveSQL script: https://livesql.oracle.com/apex/livesql/file/content_EHHFC36YW2834RB7Z9OE846C6.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Andrei Pangin - JVM crash dump analysis
 
43:42
Java Virtual Machine can handle a wide range of coding errors by throwing an exception with a readable stack trace. But what to do if JVM crashes on its own? What is hs_err.log, the only postmortem message with mysterious contents? This talk will shed light on the information encoded in crash dumps. We will see how this data is useful in problem investigation. The live demo will review the real cases of JVM crash and postmortem analysis.
Views: 1405 Riga Dev Days
PL/SQL (Solve Compilation Errors)
 
06:01
PL/SQL (Solve Compilation Errors)
ORAchk - Health Checks for the Oracle Stack
 
07:06
Clique no link abaixo para receber toda documentação utilizada neste video. http://www.dbaocm.com
Views: 483 DBAOCM .com
8. Use LOG ERRORS to suppress SQL errors at the row level.
 
06:23
The impact of a non-query DML statement is usually "all or nothing". If my update statement identifies 100 rows to change, then either all 100 rows are changed or none are. And none might be the outcome if, say, an error occurs on just one of the rows (value too large to fit in column, NULL value for non-NULL column, etc.). But if you have a situation in which you would really like to "preserve" as many of those row-level changes as possible, you can add the LOG ERRORS clause to your DML statement. Then, if any row changes raise an error, that information is written to your error log table, and processing continues. IMPORTANT: if you use LOG ERRORS, you must must must check that error log table immediately after the DML statement completes. You should also enhance the default error log table. Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2016/03/nine-good-to-knows-about-plsql-error.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Debugging PL/SQL with Oracle SQL Developer
 
34:43
Quick overview of our PL/SQL debugger - required privs, setup, and a demo of stepping through a PL/SQL function. Breakpoints, watches, and call stacks, oh my!
org.springframework.web.util.NestedServletException
 
04:41
HTTP Status 500 - Internal Server Error type Exception report messageInternal Server Error descriptionThe server encountered an internal error that prevented it from fulfilling this request. exception org.springframework.web.util.NestedServletException: Request processing failed; nested exception is java.lang.IllegalArgumentException: setAttribute: Non-serializable attribute with name sessionUser root cause java.lang.IllegalArgumentException: setAttribute: Non-serializable attribute with name sessionUser note The full stack traces of the exception and its root causes are available in the GlassFish Server Open Source Edition 4.1 logs. GlassFish Server Open Source Edition 4.1 --------------------------------------------- Spring mvc framework & Glassfish 4 What happen with my code ?
Views: 2874 Sarunyoo Keawsopa
Fatal error: Call to undefined function mysql_connect() in in xampp php school
 
01:18
Fatal error: Call to undefined function mysql_connect() in php school
Views: 34998 Rocking Support
CTS interview questions on Oracle SQL and PLSQL
 
06:45
Here are the CTS interview questions on SQL and PLSQL. PL/SQL: What are the activities are you doing daily in your project? Tell me ratio's of sql, pl/sql & Unix? Diff b/w primary key & unique key + not null? What is the use of views? If table dropped, then what happen view? What is index? types of indexes? Which functions are not supported to index? What is save point? What is ora-1555? What are the data types available in pl/sql, not in sql? What is the main use of %type,%rowtype? What is cursor? Types of cursors? Diff b/w explicit cursor & for loop cursor? What is exception? Types of exceptions? What is raise_application_error? How many LONG columns are allowed in a table? What cursor type do you use to retrieve multiple record sets? What is normalization ? What is an index and types of indexes. How many number of indexes can be used per table ? how can we find the select statement is indexed or not? What are wait events. Describe the wait event tables. How do u count no of rows in a table? When do we create bitmap indexes sql query to get zero records from a table having n no of records function can return multiple value? how give give sample coding Difference between NVL, NVL2 and NULLIF Name Salary Abc 50000 Abc 50000 xyz 20000, find the max salary using aggregate function? What are the Diff B/W Cursor and REF Cursor What is pragma_exception_init? Diff b/w triggers & procedures? Can you call procedure in select statement? Restrictions in functions? What is the use of packages? How to drop package body only? Can use pragma_autonamous_tranctions in packages? What is bulk collect? What is nullif()? What is mutating error?  What are the module's , you are working Which will fire default first statement level or row level trigger? What is bulk collect? And any restrictions in bulk collect? What is the use of limit clause in bulk collect? How to debug your code? How to trace error handling? How to find which line error was raised? What are the methods there in save exceptions? What is functional based index? Write syntax? In my next video i will be providing you the answers for each on of this questions. For HCL interview question : https://youtu.be/Pf0lRerwF5U For Global Analytics interview questions : https://youtu.be/joRTF8ZhVwg Please subscribe to my channel here for more videos on recent interview questions of MNC companies. https://www.youtube.com/channel/UCofhGV_j_4cVGa9R08MsuXQ thanks to my subscribers !!
Views: 12587 Oracle PL/SQL
Event 10053 Tracing the CBO
 
01:04:20
SQL Master Training Class Carlos Sierra - Using Oracle's 10053 Trace file (CBO)
Views: 1736 NoCOUG Channel
Debugging sql server stored procedures
 
15:11
debugging in ssms debugging t-sql code t sql debug stored procedure sql server management studio debug stored procedure how to debug t sql debug in sql server management studio In this video we will discuss how to debug stored procedures in SQL Server. Setting up the Debugger in SSMS : If you have connected to SQL Server using (local) or . (period), and when you start the debugger you will get the following error Unable to start T-SQL Debugging. Could not connect to computer. To fix this error, use the computer name to connect to the SQL Server instead of using (local) or . For the examples in this video we will be using the following stored procedure. Create procedure spPrintEvenNumbers @Target int as Begin Declare @StartNumber int Set @StartNumber = 1 while(@StartNumber [ @Target) Begin If(@StartNumber%2 = 0) Begin Print @StartNumber End Set @StartNumber = @StartNumber + 1 End Print 'Finished printing even numbers till ' + RTRIM(@Target) End Connect to SQL Server using your computer name, and then execute the above code to create the stored procedure. At this point, open a New Query window. Copy and paste the following T-SQL code to execute the stored procedure. DECLARE @TargetNumber INT SET @TargetNumber = 10 EXECUTE spPrintEvenNumbers @TargetNumber Print 'Done' Starting the Debugger in SSMS : There are 2 ways to start the debugger 1. In SSMS, click on the Debug Menu and select Start Debugging 2. Use the keyboard shortcut ALT + F5 At this point you should have the debugger running. The line that is about to be executed is marked with an yellow arrow Step Over, Step into and Step Out in SSMS : You can find the keyboard shortcuts in the Debug menu in SSMS. Let us understand what Step Over, Step into and Step Out does when debugging the following piece of code 1. There is no difference when you STEP INTO (F11) or STEP OVER (F10) the code on LINE 2 2. On LINE 3, we are calling a Stored Procedure. On this statement if we press F10 (STEP OVER), it won't give us the opportunity to debug the stored procedure code. To be able to debug the stored procedure code you will have to STEP INTO it by pressing F11. 3. If the debugger is in the stored procedure, and you don't want to debug line by line with in that stored procedure, you can STEP OUT of it by pressing SHIFT + F11. When you do this, the debugger completes the execution of the stored procedure and waits on the next line in the main query, i.e on LINE 4 in this example. To stop debugging : There are 2 ways to stop debugging 1. In SSMS, click on the Debug Menu and select Stop Debugging 2. Use the keyboard shortcut SHIFT + F5 Show Next Statement shows the next statement that the debugger is about to execute. Run to Cursor command executes all the statements in a batch up to the current cursor position Locals Window in SSMS : Displays the current values of variables and parameters If you cannot see the locals window or if you have closed it and if you want to open it, you can do so using the following menu option. Locals window is only available if you are in DEBUG mode. Watch Window in SSMS : Just like Locals window, Watch window is used to watch the values of variables. You can add and remove variables from the watch window. To add a variable to the Watch Window, right click on the variable and select "Add Watch" option from the context menu. Call Stack Window in SSMS : Allows you to navigate up and down the call stack to see what values your application is storing at different levels. It's an invaluable tool for determining why your code is doing what it's doing. Immediate Window in SSMS : Very helpful during debugging to evaluate expressions, and print variable values. To clear immediate window type ]cls and press enter. Breakpoints in SSMS : There are 2 ways to set a breakpoint in SSMS. 1. By clicking on the grey margin on the left hand side in SSMS (to remove click again) 2. By pressing F9 (to remove press F9 again) Enable, Disable or Delete all breakpoints : There are 2 ways to Enable, Disable or Delete all breakpoints 1. From the Debug menu 2. From the Breakpoints window. To view Breakpoints window select Debug =] Windows =] Breakpoints or use the keyboard shortcut ALT + CTRL + B Conditional Breakpoint : Conditional Breakpoints are hit only when the specified condition is met. These are extremely useful when you have some kind of a loop and you want to break, only when the loop variable has a specific value (For example loop varible = 100). How to set a conditional break point in SSMS : 1. Right click on the Breakpoint and select Condition from the context menu 2. In the Breakpoint window specify the condition Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures_28.html
Views: 95991 kudvenkat
Java Programming - java.lang.NullPointerException
 
07:37
Java Programming - java.lang.NullPointerException troubleshooting. Reference article & Java source: http://javaeesupportpatterns.blogspot.com/2012/01/javalangnullpointerexception-how-to.html
Hibernate Tutorial #8 - Test the JDBC Connection
 
06:20
FULL COURSE: Spring MVC and Hibernate (200+ videos) - http://www.luv2code.com/full-spring ---- This Hibernate tutorial series will help you quickly get up to speed with Hibernate. ---- DOWNLOAD SOURCE CODE for Hibernate tutorial. http://www.luv2code.com/hibernate-tutorial/ ---- View more videos on the playlist, Hibernate Tutorial: https://goo.gl/UKAdaq ---- Follow luv2code for more Hibernate tutorials: Website: http://www.luv2code.com YouTube: http://goo.gl/EV6Kwv Twitter: http://goo.gl/ALMzLG Facebook: http://goo.gl/8pDRdA --- If you liked my Hibernate tutorial, then join my mailing list: Get exclusive access to new Java tutorials. - http://www.luv2code.com/joinlist --- Questions or problems about this Hibernate tutorial? Post them in the comments section below. --- Want to suggest a video for my Hibernate tutorial? Leave a comment below. I'm always looking for new video ideas. Let me know what video you'd like for me to create for this Hibernate tutorial. --- Hibernate Tutorial Transcript In this video, we're going to test our JDBC connection. In the previous video, we did a lot of work with downloading JAR files. What I want to do hear is just do a very simple test to make sure that our JDBC connection works just fine. What we're going to do is create a very simple JDBC program, just to test everything out, just to make sure everything works out okay. What I would like to do, is move into this hibernate tutorial under the source. I'll create a new package. Right click, I'll say New Package. The actual name of the package, I'll call it com.luv2code.jdbc. Once you're happy with that package name, go ahead and click on finish. Now what I would like to do is actually create a new class. Again, right click on that package name. I'll say New Class. The actual name that I'll use for this class, I'll call it Testjdbc. Just very simple, and to the point. I'll also check the low item here for public static void, just so I can have a main method for this program. Then again, hit on Finish. All right, great. We have a very basic program here and let's go ahead and dig in. Let's start writing some code. I have a very simple try catch block. I have catch exception EXC. I'll do the EXC.print stack trace in case something goes wrong. Hopefully not. What I'll do is I'll just set up some variables here for my database connection information. First off, I'll set up my JDBC URL. I'll call it JDBC:mysequel:localhost3306/ I give the name of my database scheme, which is hbstudenttracker. Here I'll say use SSL=false. Just so that I don't get that pesky SSL warning that my sequel introduced recently, which is really annoying. Anyway, use SSL will make that go away. All right, so that's how JDBC URL, our user ID that we created, and we did all this stuff in previous slides here. Our user is HBStudent. We have this very secure system where our password is the same as our username. Only for training purposes, right? Okay, good. All right, so our URL, user ID, and password, great. We can use this information to actually give us a connection to a database. All right. Here, I'm just mentioning again that use SSL as equals false as to get rid of that pesky my sequel SSL warnings. All right, great. Let's go ahead and write some code here. I'm going to make use of my driver manager to get a connection. I'll also do some system out print lines here to tell myself what's going on here. All right, so I'll say system out print line, connecting to database. I'll just drop in that JDBC URL. Then I'll attempt to get a connection. Here I'll say connectionmycon=, and then I say driver manager.getconnection. I pass in my JDBC URL, my user ID, and my password. If that works out fine, then we have a successful connection. I can print a statement here saying connection successful. Yah-hoo. I like to have fun with this stuff. All right, so that's the piece there. Now, we need to fix some of our imports here. I can just click on this red X. We need to do that import on java.sql, so choose the second option here. Import Connection, and java.sql. Select that item. Yeah, that takes care of the item then. We should be good to go here. All right, so just some very basic code here to test out our database connection. Let's go ahead and run this application. I just do a right click, Run As, Java Application. Then it's going to fire up, and say connection successful. Let me expand this window here, so you can see everything. Connecting to database, connection successful. This is great. This is just a confirmation that we have the correct URL, user ID, and password. Also, more importantly, is that JDBC driver that we have on our lib directory, is associated with our class path. Know that we can get a valid connection. [Snip] for complete transcript, select More ... Transcript This is the end of the Hibernate tutorial transcript.
Views: 13325 luv2code
50 Ways to Inject Your SQL
 
03:36
A parody of Paul Simon's "50 Ways to Leave Your Lover," but for software security nerds. Lyrics: I see your input's not validated properly You have to check it at all tiers: 1, 2 and 3 Give me a browser and quite soon you will agree. There must be 50 ways to inject your SQL You see it really is my business to intrude The CTO wants to see this web app broke into Turn on my proxy and all doubt will be removed. There must be 50 ways to inject your SQL 50 ways to inject your SQL Try a quick hack, Jack Add a new row, Joe Try an insert, Kurt Change their SQL query Evade the regex, Rex Encode it all in hex Unbalance the quotes, Vinod And change the query Break the syntax, Max Use a backslash, Cash Try command shell, Mel, And change the query Use "one equals one," son, Unhandled exception! Read the stack trace, ace and change the query He said our application is secure against your kind There are no simple vulnerabilities to find I said your coders write their code like they are blind, there must be 50 ways to inject your SQL He said our logs show unexpected funds were sent Its probably time we started using Prepared-Statements I said I'm glad you're seeing what I meant, there were 50 ways to inject your SQL 50 ways to inject your SQL Break the syntax, Max Use a backslash, Cash Try command shell, Mel, And change the query Use "one equals one," son, Unhandled exception! Read the stack trace, ace and change the query Try a quick hack, Jack Add a new row, Joe Try an insert, Kurt Change their SQL query Evade the regex, Rex Encode it all in hex Unbalance the quotes, Vinod And change the query
Tracing Exceptions With AQtime
 
05:33
All AQtime profilers launching the application to be profiled can trace exceptions within the application. They monitor the application execution and post information about exceptions that occur to the Event View panel. This video demonstrates how you can use a special Trace Exception profiler to quickly trace exceptions that occur during the application execution. From this video, you will learn how to: - Enable logging exceptions to the Event View panel. - Distinguish between the exceptions occurring in unmanaged code and the exceptions occurring in managed code. - View the hierarchy of function calls that led to an exception. - View the source code of call stack routines. - Command AQtime to generate dumps on exceptions. - Filter exceptions.
Views: 306 AutomatedQA
Process Monitor: Processes, Threads and Thread Stacks
 
09:57
LoveMyTool.com blog video the shows how to explore processes and thread operation with procmon.
Views: 5454 Paul Offord
Top 30 PLSQL interview questions and answers
 
10:08
Most frequently asked questions: How to get distinct entries from the database? How to get results of any query which is sorted in any order? What is a mutating table error and how can you get around it? Describe the use of %ROWTYPE and %TYPE in PL/SQL What packages (if any) has Oracle provided for use by developers?Describe the use of PL/SQL tables When is a declare statement needed ? In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why? What are SQLCODE and SQLERRM and why are they important for PL/SQL developers? How can you find within a PL/SQL block, if a cursor is open? How can you generate debugging output from PL/SQL? What are the types of triggers? What are two parts of package ? what is the difference between to_char and to_date functions? How do you optimize SQL queries ? What are nested triggers ? What is a bitmap index? What is the usage of NVL? write a query for finding the length of the sting. please explain database architecture. How to get employee name from employee table which is the fifth highest salary of the table? Write a query to generate target column. Can we use out parameter in function? What will be the output for the below Query Select 'High' from dual where null = null; what is the difference between stored procedure and packaged procedure What are the steps you take to tune(performance tuning) the code in plsql? what is self join and how it works?? Can you alter procedure with in package? What is substr()&instr()? Difference between case and decode? Can you use sysdate in check constraints? If no, why? Difference between column level constraints & table level constraints? What is optimizer? What is nested_loop join? What is pivot operator? Tell me some oracle 10g features? What is m_view? What is master & detail tables? What is sqlcode and sqlerrm? Diff b/w procedure & packages? What are the dis_adv of packages? How to retrieve top 3 salaries from each departments? Can you update complex view? If no, why? When should rebuild one an index? Tell me some errors? Tell me some restrictions on cursor variables? What is context switching? What is bulk collect? What is nullif()? What is mutating error? What are the module's , you are working? Which will fire default first statement level or row level trigger? What is bulkcollect? And any restrictions in bulkcollect? What is the use of limit clause in bulkcollect? How to debugg your code? How to trace error handling? How to find which line error was raised? What are the methods there in save exceptions? What is functional based index? Write syntax? How to update complex view? Subscribe here : https://www.youtube.com/channel/UCofhGV_j_4cVGa9R08MsuXQ
Views: 8007 Oracle PL/SQL
Microsoft Full Path Disclosure Vulnerability
 
01:48
Simple Full path disclosure in Stack Trace!
How NOT to Handle Exceptions Part 2
 
07:53
In this second video, Steven warns against converting exceptions into status codes and placing INSERTs into your error log table directly into your exception section. Related LiveSQL script: https://livesql.oracle.com/apex/livesql/file/content_EHHFC36YW2834RB7Z9OE846C6.html Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2017/02/now-not-to-handle-exceptions.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Process Cloud Service (PCS) Error Exception Handling
 
02:23
Dan Atwood (Avio Consulting) shares a tip on exception handling in Oracle Process Cloud Service.
exception handling in web api2 -part 1
 
11:55
In this exception handling I taken example of HttpResponseException class and HttpResponseMessage. For Source code please visit My Youtube gears: Headphone with Mic : http://amzn.to/2kUXHSq Best USB Micro phone : http://amzn.to/2gogjsR Another option(cheap) asUSB microphone : http://amzn.to/2yrOsME Microphone with mic under 500: http://amzn.to/2gogV1D Antivirus under 500 : http://amzn.to/2ieKPFV Flipkart Headphone with mic : http://fkrt.it/TVSKWTuuuN Another Option Headphone with mic : http://fkrt.it/!Rt50!NNNN Bluetooth Speakers : http://fkrt.it/Tg4nuTuuuN Flipkart Headphone with mic : http://fkrt.it/TVSKWTuuuN Another Option Headphone with mic : http://fkrt.it/!Rt50!NNNN Bluetooth Speakers : http://fkrt.it/Tg4nuTuuuN Flipkart Headphone with mic : http://fkrt.it/TVSKWTuuuN Another Option Headphone with mic : http://fkrt.it/!Rt50!NNNN Bluetooth Speakers : http://fkrt.it/Tg4nuTuuuN What's app group for latest technologies and trends : https://chat.whatsapp.com/AtlkVqbxOrp1vyewFDOg4x Facebook Page Url : https://www.facebook.com/yogeshdotnetblogs/ Yogeshdotnet also provides online training on the front-end technologies(MEAN Stack, Web Designing - HTML5, JS, Jquery, Bootstrap, NodeJS, Express, Angular 6 with typescript etc. and backend technologies like(ASP.NET MVC, ASP.NET Web API, ASP.NET Core ,SQL Server , ORACLE ,REST and python), Data analysis(Big Data Hadoop development, PIG, Scala, Oozie) etc. For more details visit our website https://www.yogeshdotnet.com or call at 09887575540. Our training programs covered basics and advanced concept and real-time project scenarios. I designed various case studies and assignment which may help candidates to explore himself in learning technologies. I take alternate days classes and problem-solving classes also where we solve problems individually by desktop sharing. The student will get the all recorded sessions with lifetime access to all training sessions and study material. Our quality training programs are not more expensive. We provide training in Hindi & English language, depends on learner interest and comfort.
Views: 5439 Yogesh Sharma
How to solve Source not found error during debug in Eclipse : javavids
 
01:37
If you run your web application using embedded Java EE server in Maven (like Tomcat or Jetty) and try to run it in debug mode, once you hit some breakpoint, you will encounter this error: "Source not found". Part of Java online video tutorials: http://www.javavids.com
Views: 49167 Jiri Pinkas
Destiny 2 Forsaken: How To Get An Offering To The Oracle
 
02:02
Destiny 2 Review | ► Subscribe - http://www.youtube.com/subscription_center?add_user=benwca ► Twitch - http://www.twitch.tv/professorbroman ► Twitter - http://www.twitter.com/professorbroman ► Insta - https://www.instagram.com/professorbroman/ ► FB - https://www.facebook.com/ProfessorBroman ► PodCast - https://goo.gl/j6tWBi ► Delicious Coffee https://www.kingscoastcoffee.com/ ► Merch - dbh.la/broman CHECK IT! https://scufgaming.com/ 5% Off With Code Broman Mine Bitcoin with your spare computer power! https://honeyminer.com/referred/58qck THE STORY OF DESTINY 2 Humanity’s last safe city has fallen to an overwhelming invasion force, led by Ghaul, the imposing commander of the brutal Red Legion. He has stripped the city’s Guardians of their power, and forced the survivors to flee. You will venture to mysterious, unexplored worlds of our solar system to discover an arsenal of weapons and devastating new combat abilities. To defeat the Red Legion and confront Ghaul, you must reunite humanity’s scattered heroes, stand together, and fight back to reclaim our home.
Views: 59877 Ben Broman
Java Tutorial - Exception Handling(Part 1)
 
01:29:51
References: java.lang package tree https://docs.oracle.com/javase/8/docs/api/java/lang/package-tree.html throwable class https://docs.oracle.com/javase/7/docs/api/java/lang/Throwable.html Chapters: 00:00 Introduction(Definition of Errors and Exceptions) 03:55 Viewing throwable class hierarchy 05:36 difference between compile time error and compile time exception 15:00 difference between runtime error and runtime exception 18:15 java Error Class 19:15 Example of error that Error class can handle(StackOverFlowError) 20:30 what causes StackOverFlowError? 23:40 Why is it advisable to fix the error instead of catching it? 24:00 handling exceptions 24:13 handling exception using try-catch block 26:15 using the Exception class and | operator in catch parameter 29:50 multiple catch block 31:09 "Exception(name) has already been caught" error in multiple catch block 35:34 putting the Exception class in the last catch block in multiple catch block(multiple catch block ideal ordering) 40:11 nested try-catch 54:24 finally block 1:11:38 when to use finally block 1:15:37 circumstances where finally block won't execute 1:18:20 try-with resources 1:26:20 key points to remember when using try-with resources
Views: 25 Brainy Ghosts
Error could not find driver - PDO EXCEPTION XAMPP
 
01:47
How to fix Error could not find driver -PDO EXCEPTION XAMPP. The above tutorial show you how to fix Error could not find driver -PDO EXCEPTION.You can also try it for wampp. Just enable php_pdo_mysql.dll extension in php.ini to get rid of this error. Error could not find driver -PDO EXCEPTION is generally caused in earlier version of xampp If you Like this video, please Subscribe my channel for more updates.
Views: 10801 Pro Gamers
Working with the Trace File Analyzer Collector
 
28:22
The Trace File Analyzer (TFA) Collector Tool is a utility for collecting first failure diagnostics when creating Service Requests with Oracle Support. Using TFA Collector to make diagnostic collections removes questions about what files to collect and upload. TFA knows about all the well known Oracle and operating system diagnostic locations and collects only files that have been modified proximate to problem time specified from any of those well known locations. Larger files are also pruned proximate to problem time specified to reduce the size of the upload. If the system is a clustered environment TFA collects relevant diagnostics from the remote nodes as well. All of this can be accomplished with one simple command. Key features of TFA Collector include: RAC and single instance non-RAC support Time-based collection of relevant files OS Clusterware ASM DB OSW and CHMOS etc Large file pruning Cluster-wide time-relevant collections Analytics for key files DB alert logs Clusterware alert logs ASM alert logs system messages OSWatcher top and slabinfo data Flexible command-line interface Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
PL/SQL: Without using Length function
 
06:22
In this tutorial, you'll learn how to get the length of a string PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 2010 radhikaravikumar
[RESOLVIDO] Fatal error Call to undefined function mysql_connect()
 
03:31
Vídeo detalhado sobre como conectar o banco de dados do wamp, sem "fatal error".
Views: 47609 Bruno Mendes
Let's visualize your spring boot applications
 
28:03
Recorded at SpringOne Platform 2016. Speaker: Shin Tanimoto Slides: http://www.slideshare.net/SpringCentral/lets-visualize-your-spring-boot-applications In the microservice era, working with tens of hundreds of services leads to difficulties getting a grasp of the application health such as error frequency, server resources, response times and throughput. It is said visualization tools can help us command a view of the whole system and detect problems in the early stages or prevent them from occurring, but the important thing is to choose proper tools and create dashboards the right way. This session offers techniques for visualizing microservices built by Spring Boot applications using Elasticsearch, Kibana and Spring Cloud Sleuth. Besides visualizing server resources and access logs, service dependencies and performance bottlenecks, and business statuses such as conversion rate are also visualized. Let's have fun diving into visualizing your applications.
Views: 10587 SpringDeveloper
JavaScript Animated. How To Deal With Fatal Error: Uncaught Exception UnexpectedValueExceptiont
 
01:47
This video tutorial is going to show you how to deal with "Fatal error : Uncaught exception 'UnexpectedValueException' with message 'RecursiveDirectoryIterator::__construct(elements/sass): failed to open dir: No such file or directory" error. Premium JavaScript Website Themes you may find here: http://www.templatemonster.com/completely-javascript-website-templates/?utm_source=youtube&utm_medium=link&utm_campaign=cjstuts115 And also HTML 5 plus JavaScript Templates: http://www.templatemonster.com/html-javascript-website-templates/?utm_source=youtube&utm_medium=link&utm_campaign=jshtuts115 More JS Animated Video Tutorials: https://www.youtube.com/playlist?list=PLhQIfRNfwAodiduqV1Q7WbM0CI8woqFOp Subscribe Our Channel: https://www.youtube.com/user/TemplateMonsterCo/ Follow us: Facebook https://www.facebook.com/TemplateMonster/ Twitter https://twitter.com/templatemonster Instagram @template_monster Pinterest https://www.pinterest.com/templatemonster/ Dribbble https://dribbble.com/TemplateMonster LinkedIn http://www.linkedin.com/company/templatemonster-com
Views: 419 TemplateMonster
Query Tuning 101 How to Run Autotrace in SQL Developer
 
02:21
This video shows how to run autotrace reports using Oracle SQL Developer to analyze query performance. It also discusses the privileges you need to enable database users to run autotrace. ============================ The Magic of SQL with Chris Saxon Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 16971 The Magic of SQL
Cognos 10.2.1 Connection Create a MySQL Database Connection
 
17:39
Cognos Connect to MySQL Database Support Us: PayPal: https://www.paypal.me/vlemonn Patreon: https://www.patreon.com/vlemonn In this video, we are going to learn about how to create a MySQL Database connection to use it in Cognos. While creating a new database connection in database type MySQL option is not available so we are going to create use ODBC connection. To use ODBC Connection we need to download ODBC drivers for this you need to visit below URL https://go.vlemonn.net/Rm67uq70gd We also face an issue while trying to connect MySQL Database using ODBC. Below is error details QE-DEF-0285 The logon failed. QE-DEF-0325 The logon failed for the following reason: RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceConnection UDA-SQL-0031 Unable to access the "testDataSourceConnection" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the sign on information, such as a password, to connect to the database. UDA-SQL-0107 A general exception has occurred during the operation "attach". [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application BME-EX-0144 Trace back: BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction QFSSession.cpp(1153): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest() QFSSession.cpp(1151): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest() QFSSession.cpp(2034): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection() Source/QE_RsApi.cpp(2070): QFException: CCL_RETHROW: QE Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE Script Stack Trace Action No=1 Action Name=TestDataSourceConnection For resolving this issue we need to change IBM Cognos Services Log on the account. We know this video is too long for a simple database connection but covered everything we did to connect MySql database. Useful URL: Our Website: https://vlemonn.com Facebook: https://www.facebook.com/vLemonn Twitter: https://www.facebook.com/vLemonn Google Plus: https://plus.google.com/+MayankSanghvivlemonn Youtube: https://www.youtube.com/c/mayanksanghvi Whats App: 8818882120 (Only for Registered and verified Users)
Views: 281 Mayank Sanghvi
Introducing the Oracle Data Provider for .NET Core : Build 2018
 
19:15
Meet members of the .NET teams at Oracle and Microsoft to learn about Oracle’s new ADO.NET provider for .NET Core (currently in beta), discuss future plans for Oracle support on EF Core, and more. We will have demos and answer questions from the audience.
Views: 1700 Microsoft Developer
How To Fix -Application Blocked By Java Security Error  In Java 8?
 
05:35
If you guys want high-quality, and more FREE tech content, You can Support me on Patreon and get some great rewards! https://www.patreon.com/TreeAcademy How To Fix -Application Blocked By Java security error ? 1. If you are running Java 8 than you have to uninstall Java 8 By going to Control panel as there is no way to select Medium security in Java 8. 2. Go to http://google.com and do a search for "Java 7 download" and go to Site and Download Java 7 . 3. Install Java 7 in your computer . 4. Add Your Application list URL to the exception site list and you will be able to run your Application easily . Hope This fixes your issue. Thanks for watching,if you like this tutorial ,please like and share . ============================================== Facebook: https://www.facebook.com/GoTreeAcademy Google+ : https://goo.gl/zAAXK6 Twitter: https://twitter.com/gotreeacademy
Views: 183261 Tree Academy