JDBC Connection with OS externally identified user.

Posted on December 10, 2013 at 6:30am

Hello everybody!

I have to use Jaspersoft ETL to load data to an Oracle Database; the JDBC user must be the same OS user which launches the java etl program.

To do so I created an Oracle user with the clause : IDENTIFIED EXTERNALLY and I can test the connection directly via OS.

I leave blank values for username and password, but when I run Jasper ETL, I receive the following error and cannot connect:

java.sql.SQLException:ORA-01017: invalid username/password; logon denied

Does anyone knows how to create a JDBC connection with an OS user?

 

Thanks!

Jaspersoft® ETL
gbdenaro's picture
gbdenaro
54
Joined: Mar 7 2011 - 1:05pm
Last seen: 1 year 1 month ago

hi

i have same issu 

i have install ireport 5.5.0 on my PC with window xp sp3 and i have copy ojdbc14.jar in 

C:\Program Files\JasperSoft\iReport-5.5.0\platform9\lib

and also in

C:\Program Files\JasperSoft\iReport-5.5.0\platform9\modules

when wana create connection it gives an error

 

 
Message:
    java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
Level:
    SEVERE
Stack Trace:
oracle.jdbc.driver.OracleDriver
    com.jaspersoft.ireport.designer.connection.JDBCConnection.loadDriver(JDBCConnection.java:63)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:126)
    com.jaspersoft.ireport.designer.data.fieldsproviders.SQLFieldsProvider.getFields(SQLFieldsProvider.java:114)
    com.jaspersoft.ireport.designer.connection.JDBCConnection.readFields(JDBCConnection.java:472)
    com.jaspersoft.ireport.designer.wizards.ConnectionSelectionWizardPanel.validate(ConnectionSelectionWizardPanel.java:146)
    org.openide.WizardDescriptor$7.run(WizardDescriptor.java:1357)
    org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
    org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
any one help me??
thanks
asgharali.ntu - 9 years 2 months ago

You do not have the same problem. You're missing the ORACLE Driver.

djohnson53 - 8 years 7 months ago
add comment

3 Answers:

Posted on August 28, 2014 at 3:57pm

I don't believe that the IDENTIFIED EXTERNALLY created users are compatible with JDBC.

djohnson53's picture
djohnson53
162754
Joined: May 25 2012 - 11:10am
Last seen: 1 year 1 month ago
Posted on May 15, 2015 at 11:54am

Does this mean that I cannot use Jaspersoft ETL with such databases setups where OS Authentication is used? 

I was evaluating Jaspersoft ETL for my team and we use OS Authentication for all our databases. 

also 

 http://docs.oracle.com/cd/B28359_01/java.111/b31224/clntsec.htm says that it can be done (or is my understanding incorrect?): look for 

JDBC Code Using OS Authentication

Thanks 

Arya 

 

arya.chatterjee's picture
arya.chatterjee
34
Joined: May 15 2015 - 11:46am
Last seen: 7 years 10 months ago
Posted on May 19, 2015 at 4:48am

Hello,

yes, you can use ETL with OS authentication and jdbc. For Oracle you can use either OCI or Thin drivers.

Note that you can modify the database parameter REMOTE_OS_AUTHENT = TRUE

This parameter is obsolete starting from version 11g R2 (ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance – expected – can be ignored.) so it is better to use strong authentication as explained in the link you provided.

Cheers

gb

gbdenaro's picture
gbdenaro
54
Joined: Mar 7 2011 - 1:05pm
Last seen: 1 year 1 month ago
Feedback
randomness