Invalid - user name

[phil88530]

Hi:

I had my config file for netezza setup correctly, which I can connect when test

however, when I run it in jruby on rails, with its setup, its getting:

ActiveRecord::JDBCError: The driver encountered an unknown error: org.netezza.error.NzSQLException: Invalid - user name

[robbkidd]

Hi, @phil88530!

In what way are you connecting "when test"? When running a rails console in your development environment?

What do you mean by "run it in jruby on rails"? Do you mean your production environment? If so, by what means are you running your Rails app in production? With a warbler-packaged JAR file? Trinidad? Torquebox? Something else?

[phil88530]

Dear Rob:

Basically, I didn't run it in production mode, because we have a netezza db for development mode as well.

So I created a new jruby on rails project, putted your activerecord-netezza-adapter into the gemfile, and had my database.yml setup.

Of course, to connect netezza, I've also downloaded my netezza driver which I've run and able to connect to the database using the same db details.

However, when I run in rails, the above error shown up and tells me that I can't connect because of invalid username.

I can now connect to netezza using your bralliant active record-jdbc-adapter though, so I just wanted to report to you that the netezza adapter doesn't work on mine.

Hope I explained it.

Cheers
Phil