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

22 Comments

  1. Anonymous

    Will the features of dbe merged into IDEA

    1. All features of DBE are available in IDEA.

  2. Anonymous

    Hi!

    Would it be possible to get a portable or zip install for Windows?

    Thanks!

    Dave

    1. Any problems with .exe installer? It should work on all Windows versions.

      Alexander.

      1. Anonymous

        Hi!

        I can't directly download exe files.

        Dave

        1. Thank you, forwarded the question to the project lead.

          Alexander.

  3. Anonymous

    Appears to be identical to my current Intellij IU-135.

    I must of missed the advantages.

    I was hoping to see SQL statement formatting.

    1. A difference in functionality between IDEA and 0xDBE is not necessary to provide higher quality. Any improvement or bugfix in SQL formatting will go to both IDEs, that's cheap.

      SQL formatting is constantly improved fix-by-fix. If you have certain requests, please file them into our bug tracker.

  4. Anonymous

    I've been using this as a part of IDEA and I can't every be without it anymore. A few suggestions:

    1) Auto complete SQL should include JOIN templates. I.e. while typing a Select query it should suggest to automatically add the suggestion to add the JOIN clause for fks on the selected table

    2) Multiple query consoles. Right now I'm stuck with having tons of queries in the query console for quick execution access. Multiple consoles would be great or even better would be to execute an sql statement that's in a file/embedded in code. This turns all files into possible consoles!!!

    Thanks again for the great product especially with the design to have everything integrable into IDEA.

    Regards,

    Very satisfied IDEA Customer (And is likely to be a renewing customer for a ver long time ;) )

    1. 1. Currently the IDE suggests proper table on Ctrl+Space after JOIN, and proper clause on Ctrl+Space after ON. Please file more features into the bug tracker if you need them.

      2. Please follow: https://youtrack.jetbrains.com/issue/DBE-56

  5. Anonymous

    in the future there will be support for informix?

    1. It's possible, but currently there is no certain plans. You can add a comment to https://youtrack.jetbrains.com/issue/DBE-435 to make sure that developers will consider your opinion.

  6. ASR

    Are there any plans to add include functionality like in psql (PostgreSQL) or sqlplus (Oracle)?  For example you can @file.sql in sqlplus and \i file.sql in psql to include a file.  Currently if I want to "run" a .sql file, it cannot process these type of includes even if the dialect is selected.

    Are there any plans to view table statistics, indexes, constraints, partitions, or triggers inside the database navigator?  Will there be functionality to give a GUI for common DBA tasks such as viewing/killing sessions?  Support for PL/SQL/pgPLSql ?  Database storage/quotas ?  Tablespaces in oracle?

    Are there any plans to format "add constraint" sql similar to how the "Create Table" sql is formatting?

    For example:

    alter table t1
    add constraint t1_fk01
    foreign key (t2_id)
    references t2 (t2_id)

    This is an acceptable format instead of lining up t1, t1_fk01, t2_id, and t2.

  7. 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)
    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)

    mysql 5.1

  8. Anonymous

    Hi, as weird as is sounds i'm locked out of my DBE, i have the latest version (12/10) it was working fine until i got prompted to download the latest version (which i already had), but even if i try to delete the one i have (Mac+JRE) and download again i still get the same window telling me my build has expired. Any idea what should i do?

  9. Anonymous

    I have the same problem as the user above. I have Windows 10 on my computer.

  10. Anonymous

    I also have the same problem as the above user

    1. Guys, 0xDBE EAP program has ended, now the product has released as a DataGrip . Please download the latest official release from https://www.jetbrains.com/datagrip/ 

  11. Anonymous

    I am unable to import the setting from previous versions. Can you please help

  12. Good day,

    I was really pleased to use the 0xdbe for 1 year and send error reports to growth tool, but unfortunately I can not use it since today the payment is required this. I would be very happy if JetBrains give all their testers user with a lifetime license "Data Grip" as a thank you.

    If not possible, I applaud them for work.

    ps .: I used google translate to generate the text above. kkk
    ps1 .: I prefer 0xdbe to date Grip.

    Best Regards,

    Enrico Setragni de Alvarenga