working on it ...

Filters

Explore Public Snippets

Sort by

Found 8,630 snippets

    public by cwilli34 modified Feb 21, 2017  18  0  1  0

    Set SQL database to single user mode

    Set SQL database to single user mode: database_single_user.sql
    USE master;
    GO
    ALTER DATABASE AdventureWorks2012
    SET SINGLE_USER
    WITH ROLLBACK IMMEDIATE;
    GO
    ALTER DATABASE AdventureWorks2012
    SET READ_ONLY;
    GO
    ALTER DATABASE AdventureWorks2012
    SET MULTI_USER;
    GO
    
    

    public by bobby modified Jan 10, 2017  156936  2  4  0

    Returns Descriptions for all active Magento products

    Returns Descriptions for all active Magento products: Magento-active-product-descriptions.sql
    SELECT 
        e.entity_id,
        e.sku,
        eav.value AS 'description',
        IF(at_status.value_id > 0,
            at_status.value,
            at_status_default.value) AS `status`
    FROM
        catalog_product_entity e
            JOIN
        catalog_product_entity_text eav ON e.entity_id = eav.entity_id
            JOIN
        eav_attribute ea ON eav.attribute_id = ea.attribute_id
            INNER JOIN
        `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`)
            AND (`at_status_default`.`attribute_id` = '89')
            AND `at_status_default`.`store_id` = 0
            LEFT JOIN
        `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`)
            AND (`at_status`.`attribute_id` = '89')
            AND (`at_status`.`store_id` = 1)
    WHERE
        ea.attribute_code = 'description'
            AND IF(at_status.value_id > 0,
            at_status.value,
            at_status_default.value) = 1
    LIMIT 9999
    
                

    public by JulioTrujillo modified Nov 15, 2016  7492  0  4  0

    Anonimous block

    SQL
    cl scr
    set lin 200
    SET SERVEROUTPUT ON
    SET TERMOUT ON
    
    DECLARE 
    
    BEGIN
    
    END;
    /

    public by sjschmalfeld modified Oct 31, 2016  298342  1  4  1

    Kill Connections to a Database SQL Server

    sql
    // KILL CONNECTIONS TO A DATABASE
    
    USE [master]
    GO  
    
    DECLARE @kill varchar(8000) = '';  
    SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
    FROM sys.dm_exec_sessions
    WHERE database_id  = db_id('MyDB')
    
    EXEC(@kill);

    public by TristinDavis modified Aug 16, 2016  865  0  3  0

    SQL Server View missing indexes

    SQL Server View missing indexes: missing_indexes.sql
    -- Credit to https://basitaalishan.com/2013/03/13/find-missing-indexes-using-sql-servers-index-related-dmvs/
    SELECT CAST(SERVERPROPERTY('ServerName') AS [nvarchar](256)) AS [SQLServer]
        ,db.[database_id] AS [DatabaseID]
        ,db.[name] AS [DatabaseName]
        ,id.[object_id] AS [ObjectID]
        ,id.[statement] AS [FullyQualifiedObjectName]
        ,id.[equality_columns] AS [EqualityColumns]
        ,id.[inequality_columns] AS [InEqualityColumns]
        ,id.[included_columns] AS [IncludedColumns]
        ,gs.[unique_compiles] AS [UniqueCompiles]
        ,gs.[user_seeks] AS [UserSeeks]
        ,gs.[user_scans] AS [UserScans]
        ,gs.[last_user_seek] AS [LastUserSeekTime]
        ,gs.[last_user_scan] AS [LastUserScanTime]
        ,gs.[avg_total_user_cost] AS [AvgTotalUserCost]
        ,gs.[avg_user_impact] AS [AvgUserImpact]
        ,gs.[system_seeks] AS [SystemSeeks]
        ,gs.[system_scans] AS [SystemScans]
        ,gs.[last_system_seek] AS [LastSystemSeekTime]
        ,gs.[last_system_scan] AS [LastSystemScanTime]
        ,gs.[avg_total_system_cost] AS [AvgTotalSystemCost]
        ,gs.[avg_system_impact] AS [AvgSystemImpact]
        ,gs.[user_seeks] * gs.[avg_total_user_cost] * (gs.[avg_user_impact] * 0.01) AS [IndexAdvantage]
        ,'CREATE INDEX [Missing_IXNC_' + OBJECT_NAME(id.[object_id], db.[database_id]) + '_' + REPLACE(REPLACE(REPLACE(ISNULL(id.[equality_columns], ''), ', ', '_'), '[', ''), ']', '') + CASE
            WHEN id.[equality_columns] IS NOT NULL
                AND id.[inequality_columns] IS NOT NULL
                THEN '_'
            ELSE ''
            END + REPLACE(REPLACE(REPLACE(ISNULL(id.[inequality_columns], ''), ', ', '_'), '[', ''), ']', '') + '_' + LEFT(CAST(NEWID() AS [nvarchar](64)), 5) + ']' + ' ON ' + id.[statement] + ' (' + ISNULL(id.[equality_columns], '') + CASE
            WHEN id.[equality_columns] IS NOT NULL
                AND id.[inequality_columns] IS NOT NULL
                THEN ','
            ELSE ''
            END + ISNULL(id.[inequality_columns], '') + ')' + ISNULL(' INCLUDE (' + id.[included_columns] + ')', '') AS [ProposedIndex]
        ,CAST(CURRENT_TIMESTAMP AS [smalldatetime]) AS [CollectionDate]
    FROM [sys].[dm_db_missing_index_group_stats] gs WITH (NOLOCK)
    INNER JOIN [sys].[dm_db_missing_index_groups] ig WITH (NOLOCK)
        ON gs.[group_handle] = ig.[index_group_handle]
    INNER JOIN [sys].[dm_db_missing_index_details] id WITH (NOLOCK)
        ON ig.[index_handle] = id.[index_handle]
    INNER JOIN [sys].[databases] db WITH (NOLOCK)
        ON db.[database_id] = id.[database_id]
    WHERE db.[name] LIKE 'ClassOnlineAssessmentDev' -- Remove this to see for entire instance
    ORDER BY [IndexAdvantage] DESC
    OPTION (RECOMPILE);
    
    

    public by bobby modified Apr 5, 2016  419  2  3  0

    Magento - Grab Orphaned Enabled Products

    Magento - Grab Orphaned Enabled Products : magento-orphaned-enabled-products.sql
    SELECT 
        *
    FROM
        catalog_product_entity a
            LEFT JOIN
        catalog_product_entity_int ei ON ei.entity_id = a.entity_id
            LEFT JOIN
        catalog_category_product cp ON cp.`product_id` = a.entity_id
            LEFT JOIN
        catalog_product_relation cpr ON cpr.child_id = a.entity_id
    WHERE
        cp.product_id IS NULL
            AND cpr.parent_id IS NULL
            AND a.type_id != 'configurable'
            AND ei.attribute_id = 89
            AND ei.value = 1
            /*
            AND attribute_id = (SELECT 
                attribute_id
            FROM
                `eav_attribute`
            WHERE
                `attribute_code` LIKE 'status')
            AND `ei`.`value` = 1
            */
    
    

    public by lauhin modified Mar 24, 2016  2515  1  5  0

    Find tables where certain columns exists

    if you need to find all tables where a column name exists, you can search that with this query
    //this query will give you all table names in a database where certain column names exists.
    select distinct table_name
        from information_schema.columns
        where column_name in ('columnA','ColumnB')
            and table_schema = 'YourDatabase';            

    public by cghersi modified Mar 17, 2016  3801  6  7  0

    Check the missing indexes in SQL Server

    This query returns the list of missing indexes for the queries that are currently running on the server
    SELECT 
    	er.session_id,
    	er.blocking_session_id,
    	er.start_time,
    	er.status,
    	dbName = DB_NAME(er.database_id),
    	er.wait_type,
    	er.wait_time,
    	er.last_wait_type,
    	er.granted_query_memory,
    	er.reads,
    	er.logical_reads,
    	er.writes,
    	er.row_count,
    	er.total_elapsed_time,
    	er.cpu_time,
    	er.open_transaction_count,
    	s.text,
    	qp.query_plan,
    	logDate = CONVERT(DATE,GETDATE()),
    	logTime = CONVERT(TIME,GETDATE())
    FROM sys.dm_exec_requests er 
    CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) s
    CROSS APPLY sys.dm_exec_query_plan(er.plan_handle) qp
    WHERE 
    	CONVERT(VARCHAR(MAX), qp.query_plan) LIKE '%<missing%'            

    public by relaxsis modified Mar 1, 2016  3303  2  4  0

    server.log

    sql
    2016-03-01 17:50:05,140 INFO  [org.jboss.modules] (main) JBoss Modules version 1.4.3.Final
    2016-03-01 17:50:05,656 INFO  [org.jboss.msc] (main) JBoss MSC version 1.2.6.Final
    2016-03-01 17:50:05,921 INFO  [org.jboss.as] (MSC service thread 1-1) WFLYSRV0049: WildFly Full 9.0.2.Final (WildFly Core 1.0.2.Final) starting
    2016-03-01 17:50:05,925 DEBUG [org.jboss.as.config] (MSC service thread 1-1) Configured system properties:
    	awt.toolkit = sun.awt.windows.WToolkit
    	file.encoding = Cp1251
    	file.encoding.pkg = sun.io
    	file.separator = \
    	java.awt.graphicsenv = sun.awt.Win32GraphicsEnvironment
    	java.awt.printerjob = sun.awt.windows.WPrinterJob
    	java.class.path = E:\wildfly-9.0.2.Final\jboss-modules.jar
    	java.class.version = 52.0
    	java.endorsed.dirs = C:\Program Files\Java\jdk1.8.0_65\jre\lib\endorsed
    	java.ext.dirs = C:\Program Files\Java\jdk1.8.0_65\jre\lib\ext;C:\Windows\Sun\Java\lib\ext
    	java.home = C:\Program Files\Java\jdk1.8.0_65\jre
    	java.io.tmpdir = C:\Temp\
    	java.library.path = C:\Program Files\Java\jdk1.8.0_65\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\cygwin64\bin;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files (x86)\Heroku\bin;C:\Program Files (x86)\git\cmd;C:\Program Files (x86)\Git\cmd;C:\Program Files (x86)\Git\bin;C:\Program Files (x86)\nodejs\;C:\Program Files\PostgreSQL\9.4\bin;C:\Program Files (x86)\RemObjects Software\Elements\bin;C:\cygwin\bin;;C:\Program Files (x86)\NTP\bin;C:\maven\bin;C:\Program Files (x86)\Windows Kits\8.1\Windows Performance Toolkit\;C:\Program Files\Java\jdk1.8.0_65\bin;C:\Program Files (x86)\Skype\Phone\;C:\Program Files (x86)\GnuWin32\bin;C:\RailsInstaller\Git\cmd;C:\RailsInstaller\Ruby2.1.0\bin;C:\Users\user\AppData\Roaming\npm;C:\Program Files (x86)\Nmap;.
    	java.net.preferIPv4Stack = true
    	java.runtime.name = Java(TM) SE Runtime Environment
    	java.runtime.version = 1.8.0_65-b17
    	java.specification.name = Java Platform API Specification
    	java.specification.vendor = Oracle Corporation
    	java.specification.version = 1.8
    	java.util.logging.manager = org.jboss.logmanager.LogManager
    	java.vendor = Oracle Corporation
    	java.vendor.url = http://java.oracle.com/
    	java.vendor.url.bug = http://bugreport.sun.com/bugreport/
    	java.version = 1.8.0_65
    	java.vm.info = mixed mode
    	java.vm.name = Java HotSpot(TM) 64-Bit Server VM
    	java.vm.specification.name = Java Virtual Machine Specification
    	java.vm.specification.vendor = Oracle Corporation
    	java.vm.specification.version = 1.8
    	java.vm.vendor = Oracle Corporation
    	java.vm.version = 25.65-b01
    	javax.management.builder.initial = org.jboss.as.jmx.PluggableMBeanServerBuilder
    	javax.xml.datatype.DatatypeFactory = __redirected.__DatatypeFactory
    	javax.xml.parsers.DocumentBuilderFactory = __redirected.__DocumentBuilderFactory
    	javax.xml.parsers.SAXParserFactory = __redirected.__SAXParserFactory
    	javax.xml.stream.XMLEventFactory = __redirected.__XMLEventFactory
    	javax.xml.stream.XMLInputFactory = __redirected.__XMLInputFactory
    	javax.xml.stream.XMLOutputFactory = __redirected.__XMLOutputFactory
    	javax.xml.transform.TransformerFactory = __redirected.__TransformerFactory
    	javax.xml.validation.SchemaFactory:http://www.w3.org/2001/XMLSchema = __redirected.__SchemaFactory
    	javax.xml.xpath.XPathFactory:http://java.sun.com/jaxp/xpath/dom = __redirected.__XPathFactory
    	jboss.home.dir = E:\wildfly-9.0.2.Final
    	jboss.host.name = pc
    	jboss.modules.dir = E:\wildfly-9.0.2.Final\modules
    	jboss.modules.system.pkgs = org.jboss.byteman
    	jboss.node.name = pc
    	jboss.qualified.host.name = pc
    	jboss.server.base.dir = E:\wildfly-9.0.2.Final\standalone
    	jboss.server.config.dir = E:\wildfly-9.0.2.Final\standalone\configuration
    	jboss.server.data.dir = E:\wildfly-9.0.2.Final\standalone\data
    	jboss.server.deploy.dir = E:\wildfly-9.0.2.Final\standalone\data\content
    	jboss.server.log.dir = E:\wildfly-9.0.2.Final\standalone\log
    	jboss.server.name = pc
    	jboss.server.persist.config = true
    	jboss.server.temp.dir = E:\wildfly-9.0.2.Final\standalone\tmp
    	line.separator = 
    
    	logging.configuration = file:E:\wildfly-9.0.2.Final\standalone\configuration/logging.properties
    	module.path = E:\wildfly-9.0.2.Final\modules
    	org.jboss.boot.log.file = E:\wildfly-9.0.2.Final\standalone\log\server.log
    	org.jboss.resolver.warning = true
    	org.xml.sax.driver = __redirected.__XMLReaderFactory
    	os.arch = amd64
    	os.name = Windows 8.1
    	os.version = 6.3
    	path.separator = ;
    	program.name = standalone.bat
    	sun.arch.data.model = 64
    	sun.boot.class.path = C:\Program Files\Java\jdk1.8.0_65\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\rt.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\sunrsasign.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_65\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_65\jre\classes
    	sun.boot.library.path = C:\Program Files\Java\jdk1.8.0_65\jre\bin
    	sun.cpu.endian = little
    	sun.cpu.isalist = amd64
    	sun.desktop = windows
    	sun.io.unicode.encoding = UnicodeLittle
    	sun.java.command = E:\wildfly-9.0.2.Final\jboss-modules.jar -mp E:\wildfly-9.0.2.Final\modules org.jboss.as.standalone -Djboss.home.dir=E:\wildfly-9.0.2.Final
    	sun.java.launcher = SUN_STANDARD
    	sun.jnu.encoding = Cp1251
    	sun.management.compiler = HotSpot 64-Bit Tiered Compilers
    	sun.os.patch.level = 
    	user.country = RU
    	user.dir = E:\wildfly-9.0.2.Final\bin
    	user.home = C:\Users\user
    	user.language = ru
    	user.name = user
    	user.script = 
    	user.timezone = Europe/Moscow
    	user.variant = 
    2016-03-01 17:50:05,928 DEBUG [org.jboss.as.config] (MSC service thread 1-1) VM Arguments: -Dprogram.name=standalone.bat -Xms64M -Xmx512M -XX:MaxPermSize=256M -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.jboss.byteman -Dorg.jboss.boot.log.file=E:\wildfly-9.0.2.Final\standalone\log\server.log -Dlogging.configuration=file:E:\wildfly-9.0.2.Final\standalone\configuration/logging.properties 
    2016-03-01 17:50:09,216 INFO  [org.jboss.as.controller.management-deprecated] (ServerService Thread Pool -- 6) WFLYCTL0028: Attribute 'enabled' in the resource at address '/subsystem=datasources/data-source=ExampleDS' is deprecated, and may be removed in future version. See the attribute description in the output of the read-resource-description operation to learn more about the deprecation.
    2016-03-01 17:50:09,220 INFO  [org.jboss.as.controller.management-deprecated] (ServerService Thread Pool -- 6) WFLYCTL0028: Attribute 'enabled' in the resource at address '/subsystem=datasources/data-source=MySqlDS' is deprecated, and may be removed in future version. See the attribute description in the output of the read-resource-description operation to learn more about the deprecation.
    2016-03-01 17:50:09,298 INFO  [org.jboss.as.controller.management-deprecated] (ServerService Thread Pool -- 24) WFLYCTL0028: Attribute 'job-repository-type' in the resource at address '/subsystem=batch' is deprecated, and may be removed in future version. See the attribute description in the output of the read-resource-description operation to learn more about the deprecation.
    2016-03-01 17:50:09,380 INFO  [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http)
    2016-03-01 17:50:09,443 INFO  [org.xnio] (MSC service thread 1-1) XNIO version 3.3.1.Final
    2016-03-01 17:50:09,471 INFO  [org.xnio.nio] (MSC service thread 1-1) XNIO NIO Implementation Version 3.3.1.Final
    2016-03-01 17:50:09,523 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 53) WFLYSEC0002: Activating Security Subsystem
    2016-03-01 17:50:09,520 WARN  [org.jboss.as.txn] (ServerService Thread Pool -- 54) WFLYTX0013: Node identifier property is set to the default value. Please make sure it is unique.
    2016-03-01 17:50:09,582 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 46) WFLYNAM0001: Activating Naming Subsystem
    2016-03-01 17:50:09,584 INFO  [org.jboss.as.webservices] (ServerService Thread Pool -- 56) WFLYWS0002: Activating WebServices Extension
    2016-03-01 17:50:09,600 INFO  [org.jboss.as.jsf] (ServerService Thread Pool -- 44) WFLYJSF0007: Activated the following JSF Implementations: [main]
    2016-03-01 17:50:09,655 INFO  [org.wildfly.extension.io] (ServerService Thread Pool -- 37) WFLYIO001: Worker 'default' has auto-configured to 4 core threads with 32 task threads based on your 2 available processors
    2016-03-01 17:50:09,678 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 38) WFLYCLINF0001: Activating Infinispan subsystem.
    2016-03-01 17:50:09,727 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 55) WFLYUT0003: Undertow 1.2.9.Final starting
    2016-03-01 17:50:09,801 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 33) WFLYJCA0004: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)
    2016-03-01 17:50:09,808 INFO  [org.jboss.as.connector] (MSC service thread 1-2) WFLYJCA0009: Starting JCA Subsystem (IronJacamar 1.2.5.Final)
    2016-03-01 17:50:10,027 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0003: Undertow 1.2.9.Final starting
    2016-03-01 17:50:10,356 INFO  [org.jboss.as.security] (MSC service thread 1-2) WFLYSEC0001: Current PicketBox version=4.9.2.Final
    2016-03-01 17:50:10,417 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 55) WFLYUT0014: Creating file handler for path E:\wildfly-9.0.2.Final/welcome-content
    2016-03-01 17:50:10,664 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) WFLYJCA0018: Started Driver service with driver-name = h2
    2016-03-01 17:50:10,764 INFO  [org.jboss.remoting] (MSC service thread 1-1) JBoss Remoting version 4.0.9.Final
    2016-03-01 17:50:10,780 INFO  [org.jboss.as.naming] (MSC service thread 1-1) WFLYNAM0003: Starting Naming Service
    2016-03-01 17:50:11,056 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-2) WFLYMAIL0001: Bound mail session [java:jboss/mail/Default]
    2016-03-01 17:50:11,124 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0012: Started server default-server.
    2016-03-01 17:50:11,140 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0018: Host default-host starting
    2016-03-01 17:50:12,098 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-2) WFLYUT0006: Undertow HTTP listener default listening on /127.0.0.1:8080
    2016-03-01 17:50:12,553 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) WFLYSRV0027: Starting deployment of "mysql-connector-java-5.1.38-bin.jar" (runtime-name: "mysql-connector-java-5.1.38-bin.jar")
    2016-03-01 17:50:12,590 INFO  [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) WFLYDS0013: Started FileSystemDeploymentService for directory E:\wildfly-9.0.2.Final\standalone\deployments
    2016-03-01 17:50:12,856 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) WFLYJCA0001: Bound data source [java:jboss/datasources/ExampleDS]
    2016-03-01 17:50:13,742 INFO  [org.jboss.ws.common.management] (MSC service thread 1-2) JBWS022052: Starting JBoss Web Services - Stack CXF Server 5.0.0.Final
    2016-03-01 17:50:14,224 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) WFLYJCA0005: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
    2016-03-01 17:50:14,226 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) WFLYJCA0005: Deploying non-JDBC-compliant driver class com.mysql.fabric.jdbc.FabricMySQLDriver (version 5.1)
    2016-03-01 17:50:14,284 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) WFLYJCA0018: Started Driver service with driver-name = mysql-connector-java-5.1.38-bin.jar_com.mysql.jdbc.Driver_5_1
    2016-03-01 17:50:14,285 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-4) WFLYJCA0018: Started Driver service with driver-name = mysql-connector-java-5.1.38-bin.jar_com.mysql.fabric.jdbc.FabricMySQLDriver_5_1
    2016-03-01 17:50:14,375 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) WFLYJCA0001: Bound data source [java:/MySqlDS]
    2016-03-01 17:50:15,031 INFO  [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0010: Deployed "mysql-connector-java-5.1.38-bin.jar" (runtime-name : "mysql-connector-java-5.1.38-bin.jar")
    2016-03-01 17:50:15,686 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0060: Http management interface listening on http://127.0.0.1:9990/management
    2016-03-01 17:50:15,686 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0051: Admin console listening on http://127.0.0.1:9990
    2016-03-01 17:50:15,687 INFO  [org.jboss.as] (Controller Boot Thread) WFLYSRV0025: WildFly Full 9.0.2.Final (WildFly Core 1.0.2.Final) started in 11336ms - Started 246 of 428 services (218 services are lazy, passive or on-demand)
    2016-03-01 17:50:16,782 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-1) WFLYSRV0027: Starting deployment of "MyProject" (runtime-name: "MyProject.war")
    2016-03-01 17:50:17,946 INFO  [org.jboss.as.jpa] (MSC service thread 1-4) WFLYJPA0002: Read persistence.xml for MySqlPU
    2016-03-01 17:50:17,971 WARN  [org.jboss.as.connector] (MSC service thread 1-4) WFLYJCA0091: -ds.xml file deployments are deprecated. Support may be removed in a future version.
    2016-03-01 17:50:18,788 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-1) WFLYJCA0001: Bound data source [java:jboss/datasources/MyProjectDS]
    2016-03-01 17:50:18,842 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 2) WFLYJPA0010: Starting Persistence Unit (phase 1 of 2) Service 'MyProject#MySqlPU'
    2016-03-01 17:50:18,871 INFO  [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 2) HHH000204: Processing PersistenceUnitInfo [
    	name: MySqlPU
    	...]
    2016-03-01 17:50:18,902 INFO  [org.jboss.weld.deployer] (MSC service thread 1-4) WFLYWELD0003: Processing weld deployment MyProject.war
    2016-03-01 17:50:19,694 INFO  [org.hibernate.Version] (ServerService Thread Pool -- 2) HHH000412: Hibernate Core {4.3.10.Final}
    2016-03-01 17:50:19,701 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 2) HHH000206: hibernate.properties not found
    2016-03-01 17:50:19,706 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 2) HHH000021: Bytecode provider name : javassist
    2016-03-01 17:50:19,711 INFO  [org.hibernate.validator.internal.util.Version] (MSC service thread 1-4) HV000001: Hibernate Validator 5.1.3.Final
    2016-03-01 17:50:19,836 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-4) JNDI bindings for session bean named UserManager in deployment unit deployment "MyProject.war" are as follows:
    
    	java:global/MyProject/UserManager!ejb.UserManager
    	java:app/MyProject/UserManager!ejb.UserManager
    	java:module/UserManager!ejb.UserManager
    	java:global/MyProject/UserManager
    	java:app/MyProject/UserManager
    	java:module/UserManager
    
    2016-03-01 17:50:20,455 INFO  [org.jboss.weld.deployer] (MSC service thread 1-1) WFLYWELD0006: Starting Services for CDI deployment: MyProject.war
    2016-03-01 17:50:20,498 INFO  [org.jboss.weld.Version] (MSC service thread 1-1) WELD-000900: 2.2.16 (SP1)
    2016-03-01 17:50:20,534 INFO  [org.jboss.weld.deployer] (MSC service thread 1-3) WFLYWELD0009: Starting weld service for deployment MyProject.war
    2016-03-01 17:50:20,752 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 2) WFLYJPA0010: Starting Persistence Unit (phase 2 of 2) Service 'MyProject#MySqlPU'
    2016-03-01 17:50:20,847 INFO  [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 2) HCANN000001: Hibernate Commons Annotations {4.0.5.Final}
    2016-03-01 17:50:21,256 ERROR [stderr] (ServerService Thread Pool -- 2) Tue Mar 01 17:50:21 MSK 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
    
    2016-03-01 17:50:21,521 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 2) HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect
    2016-03-01 17:50:21,684 INFO  [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (ServerService Thread Pool -- 2) HHH000397: Using ASTQueryTranslatorFactory
    2016-03-01 17:50:22,120 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 2) HHH000227: Running hbm2ddl schema export
    2016-03-01 17:50:22,128 INFO  [stdout] (ServerService Thread Pool -- 2) Hibernate: drop table if exists users
    
    2016-03-01 17:50:22,271 INFO  [stdout] (ServerService Thread Pool -- 2) Hibernate: drop table if exists hibernate_sequence
    
    2016-03-01 17:50:22,354 INFO  [stdout] (ServerService Thread Pool -- 2) Hibernate: create table users (id bigint not null, description varchar(2000), password varchar(256) not null, user_name varchar(64) not null, primary key (id))
    
    2016-03-01 17:50:22,570 INFO  [stdout] (ServerService Thread Pool -- 2) Hibernate: alter table users add constraint UK_k8d0f2n7n88w1a16yhua64onx  unique (user_name)
    
    2016-03-01 17:50:22,815 INFO  [stdout] (ServerService Thread Pool -- 2) Hibernate: create table hibernate_sequence ( next_val bigint )
    
    2016-03-01 17:50:23,039 INFO  [stdout] (ServerService Thread Pool -- 2) Hibernate: insert into hibernate_sequence values ( 1 )
    
    2016-03-01 17:50:23,088 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (ServerService Thread Pool -- 2) HHH000230: Schema export complete
    2016-03-01 17:50:25,383 INFO  [javax.enterprise.resource.webcontainer.jsf.config] (ServerService Thread Pool -- 25) Initializing Mojarra 2.2.12-jbossorg-2 20150729-1131 for context '/MyProject'
    2016-03-01 17:50:27,070 INFO  [javax.enterprise.resource.webcontainer.jsf.config] (ServerService Thread Pool -- 25) Monitoring file:/C:/Users/user/IdeaProjects/MyProject/target/MyProject/WEB-INF/faces-config.xml for modifications
    2016-03-01 17:50:27,169 INFO  [org.primefaces.webapp.PostConstructApplicationEventListener] (ServerService Thread Pool -- 25) Running on PrimeFaces 5.3
    2016-03-01 17:50:27,223 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 25) WFLYUT0021: Registered web context: /MyProject
    2016-03-01 17:50:27,361 INFO  [org.jboss.as.server] (management-handler-thread - 2) WFLYSRV0010: Deployed "MyProject" (runtime-name : "MyProject.war")
    2016-03-01 17:50:37,631 INFO  [stdout] (default task-9) Hibernate: select user0_.id as id1_0_, user0_.description as descript2_0_, user0_.password as password3_0_, user0_.user_name as user_nam4_0_ from users user0_ where user0_.user_name=?
    
    2016-03-01 17:50:37,737 INFO  [stdout] (default task-9) Hibernate: select next_val as id_val from hibernate_sequence for update
    
    2016-03-01 17:50:37,740 INFO  [stdout] (default task-9) Hibernate: update hibernate_sequence set next_val= ? where next_val=?
    
    2016-03-01 17:50:38,164 ERROR [org.jboss.as.ejb3.invocation] (default task-9) WFLYEJB0034: EJB Invocation failed on component UserManager for method public boolean ejb.UserManager.userExist(java.lang.String): javax.ejb.EJBTransactionRolledbackException: WFLYEJB0457: Unexpected Error
    	at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleInCallerTx(CMTTxInterceptor.java:153)
    	at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:256)
    	at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:329)
    	at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:66)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
    	at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:634)
    	at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
    	at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
    	at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:195)
    	at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
    	at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
    	at ejb.UserManager$$$view1.userExist(Unknown Source)
    	at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:497)
    	at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:434)
    	at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
    	at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
    	at org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:67)
    	at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
    	at ejb.UserManager$Proxy$_$$_Weld$EnterpriseProxy$.userExist(Unknown Source)
    	at model.UsernameValidator.isValid(UsernameValidator.java:24)
    	at model.UsernameValidator.isValid(UsernameValidator.java:12)
    	at org.hibernate.validator.internal.engine.constraintvalidation.ConstraintTree.validateSingleConstraint(ConstraintTree.java:283)
    	at org.hibernate.validator.internal.engine.constraintvalidation.ConstraintTree.validateConstraints(ConstraintTree.java:133)
    	at org.hibernate.validator.internal.engine.constraintvalidation.ConstraintTree.validateConstraints(ConstraintTree.java:91)
    	at org.hibernate.validator.internal.metadata.core.MetaConstraint.validateConstraint(MetaConstraint.java:83)
    	at org.hibernate.validator.internal.engine.ValidatorImpl.validateConstraint(ValidatorImpl.java:547)
    	at org.hibernate.validator.internal.engine.ValidatorImpl.validateConstraintsForDefaultGroup(ValidatorImpl.java:487)
    	at org.hibernate.validator.internal.engine.ValidatorImpl.validateConstraintsForCurrentGroup(ValidatorImpl.java:451)
    	at org.hibernate.validator.internal.engine.ValidatorImpl.validateInContext(ValidatorImpl.java:403)
    	at org.hibernate.validator.internal.engine.ValidatorImpl.validate(ValidatorImpl.java:206)
    	at org.hibernate.cfg.beanvalidation.BeanValidationEventListener.validate(BeanValidationEventListener.java:137)
    	at org.hibernate.cfg.beanvalidation.BeanValidationEventListener.onPreInsert(BeanValidationEventListener.java:95)
    	at org.hibernate.action.internal.EntityInsertAction.preInsert(EntityInsertAction.java:218)
    	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:97)
    	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
    	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
    	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
    	at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67)
    	at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1227)
    	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1293)
    	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
    	at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
    	at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495)
    	at ejb.UserManager.userExist(UserManager.java:41)
    	at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:497)
    	at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
    	at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
    	at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
    	at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
    	at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
    	at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
    	at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.NonPooledEJBComponentInstanceAssociatingInterceptor.processInvocation(NonPooledEJBComponentInstanceAssociatingInterceptor.java:59)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:254)
    	at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:329)
    	at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:66)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
    	at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:634)
    	at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
    	at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
    	at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:195)
    	at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
    	at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
    	at ejb.UserManager$$$view1.userExist(Unknown Source)
    	at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:497)
    	at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:434)
    	at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
    	at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
    	at org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:67)
    	at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
    	at ejb.UserManager$Proxy$_$$_Weld$EnterpriseProxy$.userExist(Unknown Source)
    	at model.UsernameValidator.isValid(UsernameValidator.java:24)
    	at model.UsernameValidator.isValid(UsernameValidator.java:12)
    	at org.hibernate.validator.internal.engine.constraintvalidation.ConstraintTree.validateSingleConstraint(ConstraintTree.java:283)
    	at org.hibernate.validator.internal.engine.constraintvalidation.ConstraintTree.validateConstraints(ConstraintTree.java:133)
    	at org.hibernate.validator.internal.engine.constraintvalidation.ConstraintTree.validateConstraints(ConstraintTree.java:91)
    	at org.hibernate.validator.internal.metadata.core.MetaConstraint.validateConstraint(MetaConstraint.java:83)
    	at org.hibernate.validator.internal.engine.ValidatorImpl.validateConstraint(ValidatorImpl.java:547)
    	at org.hibernate.validator.internal.engine.ValidatorImpl.validateConstraintsForDefaultGroup(ValidatorImpl.java:487)
    	at org.hibernate.validator.internal.engine.ValidatorImpl.validateConstraintsForCurrentGroup(ValidatorImpl.java:451)
    	at org.hibernate.validator.internal.engine.ValidatorImpl.validateInContext(ValidatorImpl.java:403)
    	at org.hibernate.validator.internal.engine.ValidatorImpl.validate(ValidatorImpl.java:206)
    	at org.hibernate.cfg.beanvalidation.BeanValidationEventListener.validate(BeanValidationEventListener.java:137)
    	at org.hibernate.cfg.beanvalidation.BeanValidationEventListener.onPreInsert(BeanValidationEventListener.java:95)
    	at org.hibernate.action.internal.EntityInsertAction.preInsert(EntityInsertAction.java:218)
    	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:97)
    	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
    	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
    	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
    	at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67)
    	at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1227)
    	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1293)
    	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
    	at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
    	at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:495)
    	at ejb.UserManager.userExist(UserManager.java:41)
    	at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:497)
    	at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
    	at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.doMethodInterception(Jsr299BindingsInterceptor.java:82)
    	at org.jboss.as.weld.ejb.Jsr299BindingsInterceptor.processInvocation(Jsr299BindingsInterceptor.java:93)
    	at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:437)
    	at org.jboss.weld.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:64)
    	at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:83)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ee.concurrent.ConcurrentContextInterceptor.processInvocation(ConcurrentContextInterceptor.java:45)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
    	at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:52)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.NonPooledEJBComponentInstanceAssociatingInterceptor.processInvocation(NonPooledEJBComponentInstanceAssociatingInterceptor.java:59)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInCallerTx(CMTTxInterceptor.java:254)
    	at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:329)
    	at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:43)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:66)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
    	at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:634)
    	at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356)
    	at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
    	at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:195)
    	at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185)
    	at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340)
    	at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
    	at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
    	at ejb.UserManager$$$view1.userExist(Unknown Source)
    	at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:497)
    	at org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:434)
    	at org.jboss.weld.bean.proxy.EnterpriseBeanProxyMethodHandler.invoke(EnterpriseBeanProxyMethodHandler.java:127)
    	at org.jboss.weld.bean.proxy.EnterpriseTargetBeanInstance.invoke(EnterpriseTargetBeanInstance.java:56)
    	at org.jboss.weld.bean.proxy.InjectionPointPropagatingEnterpriseTargetBeanInstance.invoke(InjectionPointPropagatingEnterpriseTargetBeanInstance.java:67)
    	at org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:100)
    	at ejb.UserManager$Proxy$_$$_Weld$EnterpriseProxy$.userExist(Unknown Source)
    	at model.UsernameValidator.isValid(UsernameValidator.java:24)
    	at model.UsernameValidator.isValid(UsernameValidator.java:12)          

    public by rsrini7 modified Feb 11, 2016  2410  0  3  0

    basic oracle user setup

    basic oracle user setup: oracle_basic_user_setup.sql
    connect system/<password> as sysdba
    
    create user srini identified by srini;
    grant create session to srini;
    grant create table to srini;
    grant unlimited tablespace to srini;
    
    
    
    • Public Snippets
    • Channels Snippets