--
You received this message because you are subscribed to the Google Groups "play-framework" group.
To post to this group, send email to play-fr...@googlegroups.com.
To unsubscribe from this group, send email to play-framewor...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/play-framework?hl=en.
> go to http://localhost:9000/@db
>
> This is H2 console and there, you can see what's in your DB!
Thanks ! But this console is very basic, all operations must be made
by SQL request, including browsing tables contents ...
Is there other solutions, more friendly ?
I tryied to use DbVisualizer, but impossible to connect to the H2 file
database : any idea ?
Thanks,
Xavier
> Connect to H2 using MYSQL dialect because H2 is embedded in MYSQL mode in
> Play! so it mimics MYSQL
In Dbvisualizer ? Which Databse driver will I choose ? "MuSQL" ? If
so, then, it want to connect to a TCP MySQL server (port 3306), but I
have only the H2 database file (on this machine).
Or do I have to initialy choose "JDBC/ODBC Bridge" for driver ? And
then, which "Database type", "Driver (JDBS)" and which format for URL
? "jdbc:h2:D:\Users\cc\myplay\db\h2\play;MODE=MYSQL" ?
Thanks,
Xavier
Thank you for your answer.
I had already done some research, before posting my question, but
nothing found to connect to a file database.
I have solved my problem adding a H2 JDBC driver in DbVisualizer,
pointing to the JAR file provided with Play, and then creating a DB
connection of type JDBC with H2 driver and URL like
"jdbc:h2:D:\Users\cc\myplay\db\h2\play".
Xavier