• [Getting Started]
 
Skip to end of metadata
Go to start of metadata

FAQ is removed here.

  • No labels

63 Comments

  1. Anonymous

    Will there be support for ER digarams?

    1. Anonymous

      I too am interested in this feature.

  2. Anonymous

    I use MySQL. I faced two problems:
    1. how can I get rid of "scheme" name in queries? could I some how make one of schemes default?

    2. when I tried to write condition "where name like 'fred'", IDE did not suggest me LIKE as a keyword.

    1. Really would love to have feature 1 too :) Had the same problem today after doing a mysql dump without shema info.

    2. 1. Please check the data source properties. The URL should end with your default schema like: jdbc:mysql://your-host:3306/your-schema
      Also check Schemas and Tables tab, and set "Resolve unqualified references" where necessary.

      2. Was it an .sql file? Make sure it had proper dialect.

  3. Anonymous

    How to use 0xDBE to build an ER diagram? The site shows it should be easily achievable with a few mouse clicks, but I didn't manage to get that. Is it because it is a trial version?

      1. Anonymous

        Hi Alexander,

        Thanks for the info. If it matters, it would be nice to have the diagram in the form similar to what DBSchema tool has. Obviously 0xDBE is much more feature-rich, so having this feature will make it really cool IDE to use.

  4. Anonymous

    What are the system requirements for this IDE?

    Kurt

    1. They are not yet published at the moment. However, in terms of system requirements 0xDBE should be very similar to IntelliJ IDEA.
      E.g. you can check IDEA page like: http://www.jetbrains.com/idea/download/ , "System requirements" link.
      Just a correction: 0xDBE caches take much less than 1G. For my test projects they are about 30MB. I think 100-200MB should be enough for the start.

      1. Thank you for the update, glad to see the project moving forward.

  5. Anonymous

    Hello.

    We are interested on a visual queries and views designer like those in MS Access or SQL Server Studio. And the killer feature would by to load already existing queries/views into the designer.

    Will be there something like this? 

    Greetings

    Aleksander

    1. Hello.

      Currently we have just a feature request: http://youtrack.jetbrains.com/issue/DBE-268. No certain promises at the moment.

      I've not yet investigated how much MySQL Workbench functionality (referred in DBE-268) matches MS Access. However, since currently we have no any, all detailed requests can be made after making the first prototype.

      Regards,
      Alexander.

  6. Anonymous

    Will there be better support for Oracle Spacial data types (SDO_Geometry)?

    1. Maybe in the future. At the moment there is a request: http://youtrack.jetbrains.com/issue/DBE-431

  7. Anonymous

    I work on Ibm i Aka As400 on db2 udb dialect, is it possible to link this server and sql too.?

    You can see this jdbc driver open source : http://jt400.sourceforge.net/

    1. You can define new driver in Data Sources and Drivers dialog. If JDBC driver is provided then basic functions should be available.

      Regards,
      Alexander.

  8. Anonymous

    Are all features of 0xDBE will be available in other products? Like PHPStorm? If not all, which ones?

    Thx.

    1. All features are available, if Database support and SQL support plugins (recently merged into one in 138.n builds) are included. It's the code of those plugins.

      Regards,
      Alexander.

      1. Anonymous

        Great news :D

        Thx.

  9. Anonymous

    Hello 0xDBE team,

    I am trying to install the product on a pc at on my organisation's network ("closed" network - no internet connection).

    I am trying to work with Oracle DB. I saw that to work with Oracle there's a need to download ojdbc6-11.2.0.4.jar, so I downloaded it and placed it placed it in the folders --- \lib, \lib\src, \jre\jre\lib\ext, \jre\jre\lib (under C:\Program Files (x86)\JetBrains\0xDBE 138.1400.3).

    Unfortunately — it still won't work. It says that the driver is missing but when I press download 0xDBE tries to download only this ojdbc jar file.

    Is there maybe a list of files I should download or maybe I'm not placing the .jar file at the right location? 

    Thanks,

    Ilya

  10. Hello 0xDBE team,

    I am trying to install the product on a pc at on my organisation's network ("closed" network - no internet connection).

    I am trying to work with Oracle DB. I saw that to work with Oracle there's a need to download ojdbc6-11.2.0.4.jar, so I downloaded it and placed it placed it in the folders --- \lib, \lib\src, \jre\jre\lib\ext, \jre\jre\lib (under C:\Program Files (x86)\JetBrains\0xDBE 138.1400.3).

    Unfortunately — it still won't work. It says that the driver is missing but when I press download 0xDBE tries to download only this ojdbc jar file.

    Is there maybe a list of files I should download or maybe I'm not placing the .jar file at the right location? 

    Thanks,

    Ilya

    1. Hello.

      To add files from local drive please use "Add" button ("green plus" icon) in the "Driver files" section of the dialog.

      Regards,
      Alexander.

  11. Anonymous

    The features page lists Perforce support, though I don't see any Perforce plugins available in the 0xDBE plugin repositories. How do I enable Perforce? Is it through one of the generic source control plugins?

    1. Hello,

      Unfortunately the Perforce plugin was not provided with last EAP so we have no Perforce support for now. Maybe it will be supported in future.

      Sorry for disinformation and thank your for your question, list of Features will be edited.

      Regards,
      Maria.

  12. Anonymous

    Hi - what's the difference between 0xDBE and the database query tool in PyCharm? 

    1. Hello.

      If with "database query tool" you mean a functionality provided by JetBrains (not any third party plugin) then basically the same code works in 0xDBE and PyCharm. The GUI of 0xDBE is just refined to cover only database-related actions.

      Regards,
      Alexander.

  13. Anonymous

    Hi,

    I really love 0xDBE! And I've a question. Is there a possibility to assign values to parameters inside the console? If I paste a query in the console it detects all parameters, but I have all assignments in the clipboard to...

    Example:

  14. Greetings

    Is there any way to repair broken MySQL dBs with this program?

    I have a colleague who has a backup of a database in a folder structure and something isn't synced right.

    Thank you for a great product.

    Kurt

  15. Anonymous

    Unknown table 'parameters' in information_schema
    Unknown table 'parameters' in information_schema
    The SQL statement:
    select specific_name,parameter_name,parameter_mode,dtd_identifier from information_schema.parameters where specific_schema = ? and ordinal_position > 0 order by specific_name, ordinal_position
      at org.jetbrains.jdba.jdbc.BaseExceptionRecognizer.recognizeException(BaseExceptionRecognizer.java:48)
      at org.jetbrains.jdba.jdbc.JdbcIntermediateSession.recognizeException(JdbcIntermediateSession.java:263)
      at org.jetbrains.jdba.jdbc.JdbcIntermediateSeance.execute(JdbcIntermediateSeance.java:163)
      in RemoteSeanceImpl.execute(RemoteSeanceImpl.java:24)
      in RemoteUtil.access$100(RemoteUtil.java:36)
      in RemoteUtil$RemoteInvocationHandler.invoke(RemoteUtil.java:229)
      at com.sun.proxy.$Proxy110.execute(Unknown Source)
      at org.jetbrains.jdba.intermediate.AdaptIntermediateSeance.execute(AdaptIntermediateSeance.java:28)
      at org.jetbrains.jdba.core.BaseQueryRunner.run(BaseQueryRunner.java:66)
      in MysqlIntrospector$SchemaRetriever.d(MysqlIntrospector.java:339)
    Caused by: org.jetbrains.jdba.exceptions.StrippedSQLException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'parameters' in information_schema
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
      at com.mysql.jdbc.Util.getInstance(Util.java:386)
      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)
      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)
      at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)
      at org.jetbrains.jdba.jdbc.JdbcIntermediateSeance.execute(JdbcIntermediateSeance.java:149)
      in RemoteSeanceImpl.execute(RemoteSeanceImpl.java:24)
    today 0xdbe 142.2675.6 connect mysql 5.1

    Unknown table 'parameters' in information_schema

    Unknown table 'parameters' in information_schema

    The SQL statement:

    select specific_name,parameter_name,parameter_mode,dtd_identifier from information_schema.parameters where specific_schema = ? and ordinal_position > 0 order by specific_name, ordinal_position

      at org.jetbrains.jdba.jdbc.BaseExceptionRecognizer.recognizeException(BaseExceptionRecognizer.java:48)

      at org.jetbrains.jdba.jdbc.JdbcIntermediateSession.recognizeException(JdbcIntermediateSession.java:263)

      at org.jetbrains.jdba.jdbc.JdbcIntermediateSeance.execute(JdbcIntermediateSeance.java:163)

      in RemoteSeanceImpl.execute(RemoteSeanceImpl.java:24)

      in RemoteUtil.access$100(RemoteUtil.java:36)

      in RemoteUtil$RemoteInvocationHandler.invoke(RemoteUtil.java:229)

      at com.sun.proxy.$Proxy110.execute(Unknown Source)

      at org.jetbrains.jdba.intermediate.AdaptIntermediateSeance.execute(AdaptIntermediateSeance.java:28)

      at org.jetbrains.jdba.core.BaseQueryRunner.run(BaseQueryRunner.java:66)

      in MysqlIntrospector$SchemaRetriever.d(MysqlIntrospector.java:339)

    Caused by: org.jetbrains.jdba.exceptions.StrippedSQLException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'parameters' in information_schema

      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

      at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

      at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

      at com.mysql.jdbc.Util.getInstance(Util.java:386)

      at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)

      at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)

      at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)

      at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)

      at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)

      at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)

      at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1379)

      at org.jetbrains.jdba.jdbc.JdbcIntermediateSeance.execute(JdbcIntermediateSeance.java:149)

      in RemoteSeanceImpl.execute(RemoteSeanceImpl.java:24)

  16. Anonymous

    How do I install this on ubuntu? I cant find a .deb file.

  17. Anonymous

    Hi, have you offline documentation?

    1. Help | Help Topics, or simply F1 should work.

  18. Anonymous

    Hi,

    Is it possible to write plugins for oxDBE?

    I would like to carry out some additonal actions when I do a re-factor rename and also when I build a project.

    Is it extensible in this way?

    Thanks!

  19. Anonymous

    How can I install it on Ubuntu?

    1. Extract the .tar.gz file, and run bin/0xdbe.sh. Before running 0xDBE make sure you have a JRE 1.6+ installed on your machine.

  20. Anonymous

    any plans for HP Vertica support  ?

    1. There's currently no plans to add more dialects.

      We plan to open-source a small 3rd-party DB/SQL support plugin (as an example) when it's ready sometime after 0xDBE release.

  21. Anonymous

    My trial has expired, is it intended? The error message tells me to download a new build, but I already installed the latest one.

    1. Could you please tell your current build number (version).

  22. Anonymous

    My trial has expired (0xdbe-143.1301.4 - downloaded 2015-12-10).

    The error message tells me to download a new build, but 0xdbe-143.1301.4 its the latest.

    1. EAP is over. Download the official public version from  https://www.jetbrains.com/datagrip/download.

  23. Anonymous

    I participated in the EAP program. Is there some sort of promotional pricing available ? I am an occasional user  - just for the occasional project that comes up which requires db tasks and sql queries. -

     

    Victor

    1. Hi, Victor! Can you please provide some coordinates? =) Your e-mail, for instance (smile) 

       

      1. Anonymous

        Hi Maxim: any update on getting the promotional pricing on the license? My trial just expired. ..... Victor

  24. Anonymous

    Maxim : my email is va1985 at aol.com.  Thxxx!

    1. Check your e-mail please.

      1. Anonymous

        Got it. thx ...

         

        1. Anonymous

          btw - how do I cleanly uninstall 0xDBE ?

  25. Anonymous

    How to use version control e.g. Git with DataGrip?

  26. Can I create a Postgres connection that shows all databases in a given host?  I did this before by accident in 0xDBE, but now I can't figure out how to make it happen intentionally.  This would be really useful for some of our environments with several databases on a server, not to have to create multiple connections for every single one.

    1. Now for PostgreSQL is One connection — One database. We know, it is not the best way, please, follow this: https://youtrack.jetbrains.com/issue/DBE-2287

  27. Anonymous

    Hi. I have been using a earler build and ugrading to ver. 1.0 prompts me to install legacy java 6 support library.

    Will future versions be converted to non-legacy java libraries?

    1. Please, try the latest version.

  28. Hi,

    I've been using DBeaver for a while and thought I'd try DataGrip. I have two (relatively trivial) issues:

    1. When I copy-paste results from the Output window, it copies the column names automatically. I paste data into a sheet which already has the column names and it adds a step in my copy-pasting process. Is there a way I can turn this off?
    2. Numeric values in the Output window are not grouped, and it becomes difficult to read long numbers if I'm doing spot checks on the data for quality issues.

    While it is possible that there is a way to get things working the way I'd like, I haven't yet come across any solution yet. Please let me know if this can be done currently, or if this can be a feature request in a future version. Thanks!

     

      1. I posted that question on SO when I discovered there were a few questions about DataGrip on there (smile)

        One question got answered, but the other one still needs to be (smile)

         

        1. Yeah, I created a ticket and answered there.

          1. I just saw it. Thank you! (smile)

            Also, is there a way to display a timer for the query that is currently executing? A spinning circle is misleading especially since I've noticed that the query would've finished executing (I use the AWS Redshift Queries dashboard to keep track for long running queries), but the circle keeps spinning, having ostensibly disconnected or something. A running counter might be better? Please consider this.