Difficulties getting column information in when connecting to Oracle databases about activerecord-jdbc-adapter HOT 6 CLOSED

Also tried version 1.1.3 - no luck.

from activerecord-jdbc-adapter.

I don't know of any problems, but this could certainly be a bug. Can you try running again with the debug flag -d turned on? It should dump a stacktrace of any error at the JDBC level.

from activerecord-jdbc-adapter.

Did that and the output was similar. The error seems to be related to
ALL_USERS being a view instead a table.

I will try with regular tables as well. Even though user$ is a regular
table, it contain a unreadable column. Will take a closer look and let u
know

On Thursday, August 25, 2011, nicksieger <
[email protected]>
wrote:

I don't know of any problems, but this could certainly be a bug. Can you
try running again with the debug flag -d turned on? It should dump a
stacktrace of any error at the JDBC level.

Reply to this email directly or view it on GitHub:

https://github.com/nicksieger/activerecord-jdbc-adapter/issues/93#issuecomment-1900989

from activerecord-jdbc-adapter.

I'm having a similar issues with database views. Seems like the SQL generated from from arjdbc/jdbc/RubyJdbcConnection.java:121:incolumns'` which is a necessary call for almost any ActiveRecord feature to work, explicitly specifies tables.

I'm using the oracle adapter and am not even sure if column information is available for views rather than tables.

from activerecord-jdbc-adapter.

In case anyone else comes across this issue, I've come up with this monkey patch to get activerecord to query an oracle view. https://gist.github.com/1667390

from activerecord-jdbc-adapter.

fixed with 5f2deb4 and tested at d190960 (on master - expect this in 1.3.0) sorry for the delay

from activerecord-jdbc-adapter.