udit.rajput2010
-
Posts
3 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by udit.rajput2010
-
-
I have sort out my problem.
"SELECT USER_NICK_NAME username, PASSWORD, 1 enabled FROM XXCP_USER_LOGIN WHERE USER_NICK_NAME = ?"
-
I am using external database authentication with oracle 12c. How can write "SELECT u.username,u.password,u.enabled FROM jiuser u WHERE u.username = ?" Query In Oracle database.
I have try SELECT USER_NICK_NAME username, PASSWORD, 'true' enabled FROM XXCP_USER_LOGIN WHERE USER_NICK_NAME = 'akhilesh.kumar'
Tools:
Configuration File Name applicationContext-externalAuth-db.xml
<bean id="externalUserDetailsService" class="com.jaspersoft.jasperserver.api.security.externalAuth.db.ExternalJDBCUserDetailsService">
<property name="dataSource" ref="externalDataSource"/>
<property name="usersByUsernameQuery" value="SELECT USER_NICK_NAME username, PASSWORD, 'true' enabled FROM XXCP_USER_LOGIN WHERE USER_NICK_NAME = ?"/>
<property name="authoritiesByUsernameQuery" value="SELECT u.USER_NICK_NAME username, r.ROLE_NAME rolename FROM XXCP_USER_LOGIN u, XXCP_ROLE r WHERE u.ROLE_ID = r.ROLE_ID and u.USER_NICK_NAME = ?"/>
</bean>
Java 8
Oracle 12c
jasper Server 6.3.0 community Edition.
Tomcat 8
Stack trace:
ERROR EncryptionAuthenticationProcessingFilter,http-nio-8080-exec-9:218 - An internal error occurred while trying to authenticate the user.
org.springframework.security.authentication.InternalAuthenticationServiceException: PreparedStatementCallback; uncategorized SQLException for SQL [sELECT USER_NICK_NAME username, PASSWORD, 'T' enabled FROM XXCP_USER_LOGIN WHERE USER_NICK_NAME = ?]; SQL state [99999]; error code [17059]; Fail to convert to internal representation; nested exception is java.sql.SQLException: Fail to convert to internal representationHow can i use boolean datatype in ORACLE.
Please Help me.
How to pass dynamic value in parameter after Scheduling a report?
in Products
Posted
Hi,
I have design a report using two parameter, Calling a procedure(Input 2 values). I have deployed this report on Jasper Report Server, Configuring Both parameter First parameter using single Select Query with dynamic value When I run the report. It is working fine. But When I schedule the report it picks single value That was picked when i was scheduled. Not picking Dynamic Value. Give me the right way. please help me.
Parameter1 Query
SELECT ABC_TEST_REQUEST_S.NEXTVAL Val_Request_id,ABC_TEST_REQUEST_S.CURRVAL Request_id FROM DUAL
jrxml Code
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 -->
<!-- 2017-03-16T17:43:19 -->
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="HelpAge_Donation_Report" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="632e0004-5d14-4ed9-846e-02edb387d8f4">
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="My Simple JDBC"/>
<parameter name="Parameter1" class="java.lang.String"/>
<parameter name="Parameter2" class="java.lang.String"/>
<queryString language="plsql">
<![CDATA[{call xxhi_ext_cust_import_pkg.AR_CUSTOMER_IMPORT($P{Parameter1},$P{Parameter2})}]]>
</queryString>
<field name="Field_1" class="java.lang.String"/>
<field name="Field_2" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="55" splitType="Stretch"/>
</title>
<pageHeader>
<band height="35" splitType="Stretch"/>
</pageHeader>
<columnHeader>
<band splitType="Stretch"/>
</columnHeader>
<detail>
<band height="130" splitType="Stretch"/>
</detail>
<pageFooter>
<band splitType="Stretch"/>
</pageFooter>
<lastPageFooter>
<band height="52"/>
</lastPageFooter>
<summary>
<band splitType="Stretch"/>
</summary>
</jasperReport>
Regards
Udit