FAQ

Search Discussions

1,311 discussions - 4,961 posts

  • Hi, I want to create a table with a generic column, but I don't know how to define the projection. E.g. class MapTable[V](tag: Tag)(implicit vTyped: TypedType[V]) extends Table[(String, V)](tag, ...
    Ivo MihailovicIvo Mihailovic
    Jun 16, 2016 at 11:50 am
    Jun 16, 2016 at 11:50 am
  • Hello! I've been experiencing troubles getting Slick 2.0 to generate efficient SQL when trying to do a LEFT JOIN, COUNT, and GROUP BY when specifically attempting to retrieve more columns than just ...
    Luke KnightLuke Knight
    Jun 6, 2016 at 5:18 am
    Jun 6, 2016 at 5:18 am
  • Posted on StackOverflow, but sharing here as I'm curious whether others have run into this ...
    Gary MaloufGary Malouf
    Jun 1, 2016 at 10:37 pm
    Jun 1, 2016 at 10:37 pm
  • Hello, I'm trying to insert some UTF8 chars in a database, my application is play framework + slick, locally the default configuration is: slick.dbs.default.driver="util.PostgresDriver$" ...
    Alessandro TagliapietraAlessandro Tagliapietra
    May 31, 2016 at 6:17 pm
    May 31, 2016 at 6:46 pm
  • Hi, is it possible to create custom apply method to duplicate column? Instead of: def * = (id.?, col1, col2, col3) < (Caseclass.tupled, Caseclass.unapply) Something like: def * = (id.?, col1, col2, ...
    EdgarsEdgars
    May 30, 2016 at 8:30 am
    May 30, 2016 at 8:30 am
  • I am using the PlayFrameWork with slick and using it in a system that is all I/O database heavy. In my application.Conf file I have this setting play { akka { akka.loggers = ...
    Ignacio HernandezIgnacio Hernandez
    May 28, 2016 at 5:22 am
    May 28, 2016 at 5:22 am
  • I have the following Slick class that includes a date: import java.sql.Date import java.time.LocalDate class ReportDateDB(tag: Tag) extends Table[ReportDateVO](tag, "report_dates") { def reportDate = ...
    Ps3331333Ps3331333
    May 26, 2016 at 1:55 am
    May 26, 2016 at 12:48 pm
  • Hi, I just want to create schemas for my database and I found out that the definition of a table depends on the driver. Is this really correct? package ...
    Marc ZahnMarc Zahn
    May 23, 2016 at 3:20 pm
    May 23, 2016 at 3:20 pm
  • I have a table with a column type date. This column accepts null values, therefore, I declared it as an Option (see field perDate below). When I read the table, I get this exception ...
    Ps3331333Ps3331333
    May 22, 2016 at 2:23 pm
    May 22, 2016 at 2:23 pm
  • I'm really hoping someone can help me with this. I have timestamps in Postgres stored as timestamp without timezone and need to treat them as UTC. I don't really care if I make the column type ...
    Richard RodsethRichard Rodseth
    May 21, 2016 at 5:48 pm
    May 23, 2016 at 4:51 am
  • I have a DAO helper trait that provides common functionality to DAOs. It needs to be able to access the table query, and run actions. I'm having trouble defining or otherwise providing the query type ...
    Michael SlinnMichael Slinn
    May 20, 2016 at 1:46 pm
    May 20, 2016 at 1:46 pm
  • I'm dealing with a legacy postgres table with start/end values of type "timestamp without timezone". These values are intended to be interpreted as UTC. My table mappings use type Timestamp. I'm ...
    Richard RodsethRichard Rodseth
    May 19, 2016 at 12:10 am
    May 21, 2016 at 12:01 am
  • Hi! According to this announcement: http://slick.lightbend.com/news/2016/02/01/slick-extensions-licensing-change.html ,slick support for Oracle will be open sourced with slick. So I was wondering if ...
    JochenJochen
    May 13, 2016 at 10:18 am
    May 13, 2016 at 10:18 am
  • Hello there, I am trying to model a table which has 27 columns. I am using slick 3.1.1. Initially, I did following class Anomaly(tag:Tag) extends Table[(Int, String, Int, Timestamp, Timestamp, Int, ...
    Harit HimanshuHarit Himanshu
    May 12, 2016 at 8:28 pm
    May 18, 2016 at 9:27 pm
  • Hi I started using Play Slick 2.5 and using the examples given in the documentation, but keep getting this error. type current is not a member of object play.api.Play [error] val dbConfig = ...
    Prasad mokkapatiPrasad mokkapati
    May 5, 2016 at 10:57 pm
    May 9, 2016 at 11:26 pm
  • Hi there, I'm trying to do the Slick 3.1 equivalent of the following. UPDATE records SET comment = 'updated content', lastModified = NOW() WHERE id = 123; The tricky bit is working out how to insert ...
    Matt GilbertMatt Gilbert
    Apr 27, 2016 at 11:57 pm
    Apr 27, 2016 at 11:57 pm
  • Hi, I'm using the slick codegen project with a customgenerator and it works fine, however when compiling I have this error across all my model tables : From the error I see that my class CascoDetalle ...
    Raul782Raul782
    Apr 26, 2016 at 3:05 pm
    Apr 29, 2016 at 6:11 am
  • Hello. I've been constructing queries from dynamic (user-supplied) data, where the type of comparison itself is dynamic. E.g., I want to turn a request such as ...
    Richard DallawayRichard Dallaway
    Apr 22, 2016 at 4:32 pm
    Apr 22, 2016 at 4:32 pm
  • I wanted to create a Slick query similar to this SQL, select lots.oid, lots.cat from lots left join bks on (lots.cat = bks.cat and bks.oid=100) where not exists (select 1 from bks_dates bd where ...
    Teck Hooi LimTeck Hooi Lim
    Apr 22, 2016 at 8:06 am
    Apr 22, 2016 at 8:06 am
  • A pattern I often use in database access, similar to upsert, is to insert if the row doesn't exists else return the existing row. Here's an example of my current implementation: I query for the row ...
    Roy PhillipsRoy Phillips
    Apr 17, 2016 at 12:18 pm
    Apr 17, 2016 at 12:18 pm
  • Hi Guys, I am new to Scala and even newer to Slick. I am having a collection of invoices and every invoice has a collection of positions. Persisting single invoice with positions is simple: val ...

    Apr 16, 2016 at 12:39 pm
    Apr 16, 2016 at 12:39 pm
  • I'm new to Slick. I'm creating a test suite for a Java application with Scala, ScalaTest and Slick. I'm using slick to prepare data before the test and to do assertions on the data after the test ...
    Bart KummelBart Kummel
    Apr 15, 2016 at 6:55 am
    Apr 19, 2016 at 12:11 pm
  • Hi, everyone. I would like to ask is there a way to generate random rows into a table, I need ti generate up to 10.000.000 random rows in to my table. is there any example how to do such a thing? -- ...
    M VengalisM Vengalis
    Apr 13, 2016 at 5:17 pm
    Apr 13, 2016 at 5:17 pm
  • Hi Guys, I have a case class which generated form slick codegen case class Workout(id: Long, rideType: Short, calories: Option[Int] = None, duration: Option[Int] = None, distance: Option[Float] = ...
    Elvis LeeElvis Lee
    Apr 13, 2016 at 6:10 am
    Apr 13, 2016 at 6:18 am
  • Hi, I'm having a hard time choosing between H2 and HSQLDB, in embedded mode, for usage in a desktop application. Even more because I don't need the ODBC driver and fulltext search provided by H2 ...
    Karlsanders75Karlsanders75
    Apr 7, 2016 at 10:15 am
    Apr 7, 2016 at 10:15 am
  • YouTube videos of U.S. Congress money laundering hearing of Saudi Billionaire " Maan Al sanea" with *bank of America* and The owner of Saad Hospital and Schools in the Eastern Province in *Saudi ...
    Bader salmeenBader salmeen
    Apr 6, 2016 at 10:29 pm
    Apr 6, 2016 at 10:29 pm
  • down votefavorite <http://stackoverflow.com/questions/36420434/scala-slick-3-1-multiple-joins# I'm trying to perform multiple joins in Slick 3.1.1. The result that I would like to achieve is this ...
    Jelle van EsJelle van Es
    Apr 5, 2016 at 8:33 am
    Apr 5, 2016 at 8:33 am
  • I am getting the following error No implicit view available from *Rep[com.github.nscala_time.time.Imports.DateTime] = slick.lifted.Ordered.* my query is *val query = TableQuery[Connections]* * ...
    Srinu GandikotaSrinu Gandikota
    Apr 3, 2016 at 4:28 pm
    May 26, 2016 at 1:45 am
  • Hi everyone - I have a question which basically stems from some unexplained behavior that I notice for some long running db operations. Say I have a bunch of db operations (that may take some time to ...
    Debasish GhoshDebasish Ghosh
    Mar 30, 2016 at 9:55 am
    Mar 30, 2016 at 11:15 am
  • I am trying to get the result of a query which is executed as a part of a sequence of actions passed as a parameter to DBIO.sequence() method of Slick 3.0. Below is the code snippet for the same. val ...
    Debasish SenaDebasish Sena
    Mar 29, 2016 at 12:46 pm
    Mar 29, 2016 at 1:09 pm
  • Hi all, I'm trying to use Slick 3.1.1 in my current project and I've faced with following problem. I have schema with optional fields: class Foos(tag: Tag) extends Table[Foo](tag, "foos") { def id = ...
    Mike LimanskyMike Limansky
    Mar 28, 2016 at 2:25 pm
    Apr 1, 2016 at 2:26 am
  • Would be good if some people that ran into the deadlock issue could try this branch prior to merging. https://github.com/slick/slick/pull/1461 just clone slick and run sbt publishLocal to create ...
    Christopher VogtChristopher Vogt
    Mar 21, 2016 at 9:46 pm
    Mar 22, 2016 at 8:03 am
  • I'm using Slick to query a database. I pass a Case class to my query method which looks like similar to... case class queryParams(id:Int, age:Option[Int] = None, categoryId:Option[Int] = None) I have ...
    Robert O'ReganRobert O'Regan
    Mar 21, 2016 at 4:55 pm
    Mar 22, 2016 at 12:55 pm
  • Hello, I’d like to draw your attention to the new community process <http://slick.typesafe.com/community/process.html and code of conduct <http://slick.typesafe.com/community/conduct.html for Slick, ...
    Stefan ZeigerStefan Zeiger
    Mar 18, 2016 at 2:55 pm
    Mar 18, 2016 at 2:55 pm
  • How do I update multiple tables transactionally based on parameters passed to a function Say I have a function f(a: Int, b: String, c:Int, ] ..) I have 3 tables and this function need to update ...
    Prasad mokkapatiPrasad mokkapati
    Mar 16, 2016 at 8:41 pm
    Mar 16, 2016 at 8:41 pm
  • First, quick overview on how our tables are constructed. We have a use case where some of the fields on our database tables are populated via triggers. That is, we don't want to be able to ...
    Gary MaloufGary Malouf
    Mar 16, 2016 at 8:23 pm
    Mar 16, 2016 at 8:23 pm
  • I've given up trying to use the type safe queries for all but the simplest cases due to the nesting of tuples and I reverted to using plain sql queries. However I have now run into a similar problem ...
    Toby HobsonToby Hobson
    Mar 16, 2016 at 3:58 pm
    Mar 17, 2016 at 10:05 am
  • Reading the Play Slick docs <https://www.playframework.com/documentation/2.5.x/PlaySlick i see this: "Play Slick module does not bundle any JDBC driver. Hence, you will need to explicitly add the ...
    Toby HobsonToby Hobson
    Mar 12, 2016 at 12:42 am
    Mar 12, 2016 at 12:15 pm
  • Hi, I have the following "Enumeration" (i.e. not a scala.Enumeration, but rather a hand-baked one) like so: sealed trait ChunkState object ChunkState extends CrowdscriberEnum[ChunkState] { override ...
    CraigerCraiger
    Mar 10, 2016 at 10:33 pm
    Mar 15, 2016 at 6:47 pm
  • I am performing some batch updates in Play 2.4 + Slick 3.1 + PostgreSQL 9.4.6-0+deb8u1 application. (The virtual machine uses Debian 8 and Oracle Java 8, has 8 vCPUs and up to ~8GiB RAM. Relevant ...
    Vít ŠestákVít Šesták
    Mar 9, 2016 at 12:20 pm
    Mar 13, 2016 at 10:09 pm
  • Hi! Slick's default is to set HikariCP's maxConnections to 5 times numThreads (see here ...
    Nadav SametNadav Samet
    Mar 3, 2016 at 7:53 pm
    Mar 4, 2016 at 11:38 am
  • Hi, I'm having a hard time trying to find the right way to create an update query that would include some CASE/WHEN/THEN (Case/If/Then) statements. Is that allowed ? would anyone have an example ...
    Alexandre RusselAlexandre Russel
    Mar 1, 2016 at 11:47 am
    Mar 1, 2016 at 11:47 am
  • If I have a table relationship of customers - customer_things , where a single customer has multiple customer things, is it possible via 1 DB request to get back a sequence of tuples: (Customer, ...
    RanUserRanUser
    Feb 26, 2016 at 8:26 pm
    Mar 13, 2016 at 2:41 pm
  • Hello, I'm using slick 2.1 in a little project and I am encountering strange issues that do not seem very common according to my Google searches. I have some moderately complicated queries, involving ...
    Régis BlancRégis Blanc
    Feb 25, 2016 at 11:01 pm
    Feb 25, 2016 at 11:01 pm
  • Hello, I would like to ask if someone can point me to some documentation related to working db cursors in Postgres. I searched here in the group, in the Slick docs, StackOverflow... no info ...
    Alexander ZafirovAlexander Zafirov
    Feb 23, 2016 at 11:54 am
    Feb 23, 2016 at 11:54 am
  • We use Slick (2.1.0) with Spray-io (1.3.3). Currently we are facing an issue because we use the same execution context for both the Spray HTTP API part and background running jobs accessing the same ...
    Christian MoserChristian Moser
    Feb 22, 2016 at 8:54 am
    Feb 22, 2016 at 8:54 am
  • Hi, I'm using Slick 3.1.1 and I wish to use joda time api instead of java.sql. Currently I have this mapping code: trait ColumnTypeMappings { import slick.driver.MySQLDriver.api._ import ...
    KrilleKrille
    Feb 16, 2016 at 1:38 pm
    Feb 18, 2016 at 1:01 pm
  • I have the below code which returns Future[Option[Password]] db.run(passwords.filter { x = x.providerID === loginInfo.providerID && x.providerKey === loginInfo.providerKey }.result.headOption) What I ...
    Priya RPriya R
    Feb 12, 2016 at 4:13 pm
    Feb 12, 2016 at 4:40 pm
  • I'm writing an Akka streams app using Slick 3, and getting the following error. org.postgresql.util.PSQLException: ERROR: canceling statement due to user request I believe I have dialed down the ...
    Richard RodsethRichard Rodseth
    Feb 11, 2016 at 4:48 am
    Feb 11, 2016 at 4:48 am
  • A have the following scenario: A Department has a manager. A manager may have many tasks. class Department(tag: Tag) extends Table[Category](tag, "DEPARTMENT") { ... def managerId = ...
    Toby HobsonToby Hobson
    Feb 10, 2016 at 2:26 pm
    Feb 17, 2016 at 3:13 pm
Group Navigation
period‹ prev | Latest | first ›
Group Overview
groupscalaquery @
categoriesscala
discussions1,311
posts4,961
users820
websitescalaquery.org
irc#scala

Top users

Christopher Vogt: 563 posts Stefan Zeiger: 397 posts Virtualeyes: 243 posts Nafg: 199 posts Pedro Furlanetto: 106 posts Andrew Gaydenko: 98 posts Michael Slinn: 66 posts Ijuma: 60 posts Adam Mackler: 54 posts Matan Safriel: 50 posts Ricardo Franco: 41 posts Clint Gilbert: 39 posts Daniel Dietrich: 36 posts Jacobus: 35 posts Dave: 34 posts Marc Siegel: 28 posts Matthew Pocock: 28 posts Mirco Dotta: 27 posts Randall Schulz: 26 posts Jochen: 25 posts
show more