Database Table Editor

I was excited to see that JetBrains added a new Database Table Editor into the application.  Though, it's odd that it is such a hidden feature as the only way I have seen to get to it is by selecting a table and pressing F4 (I couldn't find anything other than the help file that even mentions this functionality).  It isn't on a context menu, nor the toolbar.  But, that isn't my problem...

The issue I am having is that I cannot update any data via the tool.  If I attempt to modify data I get the following error:

[2010-12-10 12:00:45] [17091] Warning: Unable to create resultset at the requested type and/or concurrency level: ORA-00936: missing expression

[2010-12-10 12:00:45] [17076] Invalid operation for read only resultset: updateObject


I'm using Oracle for persistence (10g express), using the thin driver (version 10.2.0.4.0).  What might I be doing wrong?  Does this driver not support this?

Briggs.
3 comments
Comment actions Permalink

Hello Marc,

Try using Oracle 11.x.x.x.x drivers instead of 10.x.x.x.x.
When it comes to editing every JDBC driver starts to behave in a different way.

Regards,
Gregory Shrago

On 10.12.2010 20:03, Marc Miller wrote:

I was excited to see that JetBrains added a new Database Table Editor into the application.  Though, it's odd that it is such
a hidden feature as the only way I have seen to get to it is by selecting a table and pressing F4 (I couldn't find anything
other than the help file that even mentions this functionality).  It isn't on a context menu, nor the toolbar.  But, that
isn't my problem...

>

The issue I am having is that I cannot update any data via the tool.  If I attempt to modify data I get the following error:

>

Warning: Unable to create resultset at the requested type and/or concurrency level: ORA-00936:
missing expression

>

Invalid operation for read only resultset: updateObject

>

I'm using Oracle for persistence (10g express), using the thin driver (version 10.2.0.4.0).  What might I be doing wrong?
Does this driver not support this?

>

Briggs.

>

--- Original message URL: http://devnet.jetbrains.net/message/5280395#5280395


0
Comment actions Permalink

No luck.  I set up my datasource using the ojdbc-11.2.0.1.0 jar and get the same error.  Has this been tested with Oracle?  

I'd also like to mention that the SQuirrel SQL tool has been handling this functionality for years without database driver issues.  I'm curious to know what the actual issue is and if it has actually worked for anyone.

0
Comment actions Permalink

http://youtrack.jetbrains.net/issue/IDEA-63145

On 15.12.2010 18:22, Marc Miller wrote:

No luck.  I set up my datasource using the ojdbc-11.2.0.1.0 jar and get the same error.  Has this been tested with Oracle?

>

--- Original message URL: http://devnet.jetbrains.net/message/5280887#5280887


0

Please sign in to leave a comment.