examples-orms
examples-orms copied to clipboard
cockroachdb
Sample uses of CockroachDB with popular ORMs
I think this repo is awesome for providing code samples! However I think it should also aspire to show how to do things The Right Way (tm). Especially given that...
Fixes for documentation and hibernate when I checked out the latest its complete broken.
WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:524) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:470) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:429) at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:245)...
CREATE DATABASE IF NOT EXISTS company_{language}_{ORM}; It uses the database company_hibernate.. Sep 21, 2017 4:40:15 PM org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC...
Example should work against 1.0 CockroachDB node starting at 2017-09-21 14:26:59.087913381 -0500 CDT build: CCL v1.0.5 @ 2017/08/24 17:43:46 (go1.8.3) admin: http://jackburton:2800 sql: postgresql://root@jackburton:26257?sslmode=disable logs: /home/wdroste/tmp/cockroach-data/logs store[0]: path=/home/wdroste/tmp/cockroach-data status: initialized...
There needs to a common after the DECIMAL declaration. root@:26257/company_java_hibernate> CREATE TABLE IF NOT EXISTS orders ( -> id SERIAL PRIMARY KEY, -> subtotal DECIMAL(18,2) -> customer_id INT REFERENCES customers(id),...