DB password on scripted JDBC adapter

I am evaluating IDM 7.0 and tried to make a scripted JDBC Resource adapter

based on the simple table example. I succeeded in testing the DB connection

(Oracle 10.1 on Linux), but when I try to add the resource to an account, I get

[codeThere was an error while attempting to check the dictionary for the new password. Failure : com.waveset.util.WavesetException: XPRESS <invoke> exception ==> com.waveset.util.WavesetException: Can't call method queryString on class com.waveset.util.JdbcUtil ==> com.waveset.util.WavesetException: ==> java.sql.SQLException: ORA-01017: invalid username/password; logon denied ][/code]

which implies that the db user name (or password) is not right. But it should

be, since the connection test succeeded ?!

[809 byte] By [ArtoVa] at [2007-11-26 21:03:21]

«« SUN JAVA STUDIO & GWT & AJAX
»» Serialization - wasn't using serialVersionUID.....

# 1

The scripted JDBC Resource adapter was just introduced in the 7.0 release. It could still be buggy...

JimBearda at 2007-7-10 2:35:49 >

top of Java-index,Web & Directory Servers,Directory Servers...

# 2

I tried the same with MySQL 4.1; same problem: connection checkedsucceeded, but when I added the resource to an account, db user/passwordare wrong.

ArtoVa at 2007-7-10 2:35:49 >

# 3

Hi,

the error mentiones "Dictionary". You can define DB based dictionaries for password policies. If you defined such a policy and the dictionary could not be connected to for whatever reason the error you get is what i would expect to happen whenever a resourceaccount for which the policy applies is about to be created.

Regards,

Patrick

Patrick.Wehingera at 2007-7-10 2:35:49 >

# 4

Yes, you are right, there was problems with dictionary password. I had

set the password dictionary , since it was dropped for some reason.

Now the resource works; well actually not. I get error

Account 'base' not found in Resource 'Oracle JDBC'.

But, I am trying to add the resource to existing account. The Linux resource

creates the account if it does not exist, so how can I do this on scripted JDBC?

BTW where is the password dictionary documented? I had to trace

Oracle to see what name the table is and then guess the attribute name

and type. I found a file dictionary.txt which describes the DDL, but not for

what it is (i.e. password list is not mentioned).

ArtoVa at 2007-7-10 2:35:49 >

# 5

Ones more: Modification works, if the account was already there. But howcan I add new accounts? I guess it is defined somehow on the resourceattributes, but they seem similar to Redhat resource's.

ArtoVa at 2007-7-10 2:35:49 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

DB password on scripted JDBC adapter

Web & Directory Servers New Topic

Web & Directory Servers Hot Topic

Web & Directory Servers

All Classified