JDBCConsole "The connection URL is null"

Connection test works
Database tables load correctly
However when I open the JDBCConsole, and execute a query I get the message:

"The connection URL is null"

My configuration is using SQLServer driver :(

<![CDATA[
com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://localhost:1433;DatabaseName=mydb
]]>


yielding

<![CDATA[
C:\Java\jdk16\bin\java -Didea.launcher.port=7532 "-Didea.launcher.bin.path=C:\Intellij\IDEA 8.0\bin" -Dfile.encoding=windows-1252 -classpath "C:\Intellij\IDEA 8.0\plugins\PersistenceSupport\lib\jdbc-console.jar;C:\Intellij\IDEA 8.0\lib\util.jar;C:\Intellij\IDEA 8.0\lib\annotations.jar;C:\code\v3\bin\lib\sqljdbc.jar;C:\Intellij\IDEA 8.0\lib\idea_rt.jar" com.intellij.rt.execution.application.AppMain com.intellij.persistence.database.console.JdbcConsoleMain
select getDate()
The connection URL is null.

]]>


I suspect the error may be coming from SQLServer's JDBC Driver, making me wander if they have a nonstandard driver configuration mechanism that the JDBCConsole doesn't account for.

I didn't find anything about this in tracker, so I really hope this is an error on my part, as I've been looking forward to this feature.

Does any one have any suggestions?

2 comments
Comment actions Permalink

Hello Brett,

Connection test works
Database tables load correctly
However when I open the JDBCConsole, and execute a query I get the
message:
"The connection URL is null"


Looks similar to this issue: http://www.jetbrains.net/jira/browse/IDEADEV-32584

It is fixed in the latest EAP: http://www.jetbrains.net/confluence/display/IDEADEV/Diana+EAP

You can check does the fix cover your problem.

Alexander.


0
Comment actions Permalink

Yes, that fixed my problem. Thanks!
B

0

Please sign in to leave a comment.