Questions tagged [activejdbc]

ActiveJDBC is a Java ORM modeled on ActiveRecord from Ruby on Rails.

215 questions
0
votes
1 answer

ActiveJdbc update join-table attribute

Good evening, I am trying to update a join-table attribute for existing records. I have two models, one called Records, the other called Shoppingcarts. These are connected by a join table called records_shoppingcarts. I added a relationship…
0
votes
2 answers

ActiveJdbc second connection to same database

I'm using activejdbc for a Java ee project I have to do for school and I really like it. I do however have a recurring problem whenever I need more than one connection to the same database in one HttpServletRequest. The scenario is the following: I…
0
votes
0 answers

ActiveJdbc get parent in JSP

I recently started using activejdbc for a small Java EE project I have to do for school. I'm trying get the value of a foreign key field in an Object table of the DB managed by JDBC in a Servlet. The relations at hand are two tables, one table…
0
votes
1 answer

How do I convert an ISO 8601 date to DateTime type in ActiveJDBC?

The toJson method gives as result a date type with format ISO 8601. With console output, the someEntityInstance.toString() method produces: {Valid=true, Activation_Date=2018-02-11 05:00:00.0, Creation_Date=2018-02-11 05:00:00.0} But with the…
InfZero
  • 2,944
  • 4
  • 24
  • 36
0
votes
1 answer

ActiveJDBC (JavaLite) : Using "activejdbc.properties" does not work for test directory

I recently updated to ActiveJDBC 2.1 in order to use activejdbc.properties for the purpose of externalizing out the database property so we didn't have to check in the database username/password into SVN. Putting the "activejdbc.property" file…
Jeff Moreau
  • 29
  • 1
  • 7
0
votes
1 answer

Different connections for same environment in database.properties

i need access to several databases per environment. Until now i've only seen examples with exactly one database connection config per environment in database.properties. Is it possible to have several connection configs in there for an environment…
valley
  • 157
  • 1
  • 13
0
votes
2 answers

JavaLite / ActiveJDBC: Derive database columns from Getters?

ActiveJDBC is a real "thin" database mapper allowing to query databases and mapping the results to POJOs. I'm using version 2.1-SNAPSHOT. However, when it comes to the properties of a class, it looks like one has to do the hard work manually (or…
Georg S.
  • 23
  • 3
0
votes
1 answer

Where to put the activejdbc.properties file for referencing the database.properties file in ActiveJDBC?

I have created a Jersey project from the Maven archetype jersey-quickstart-webapp on NetBeans. And I'm using ActiveJDBC for data persistence. In its documentation it's possible to reference an external file for database connection properties:…
InfZero
  • 2,944
  • 4
  • 24
  • 36
0
votes
1 answer

Spring application fails to start with ActiveJDBC instrumented classes

I am using Java 8, ActiveJDBC 1.4.13 and Spring Boot 2.0.0.RC1 with Spring 5. On application startup I am getting this error: org.springframework.beans.factory.BeanDefinitionStoreException: Failed to read candidate component class:…
Norbert Bicsi
  • 1,562
  • 2
  • 19
  • 33
0
votes
1 answer

Cannot open a new connection because existing connection is still on current thread - ActiveJDBC

I'm getting this error Cannot open a new connection because existing connection is still on current thread after a while. I think the error is pretty self explanatory. My code is this: String mySQLUrl = "jdbc:postgresql://" +…
JGutierrezC
  • 4,398
  • 5
  • 25
  • 42
0
votes
1 answer

Adjust ActiveJDBC log level

This should be so simple to accomplish that not being able to do so is driving me crazy! I'm using ActiveJDBC (which uses slf4j) along logback, and it seems it is IMPOSSIBLE to adjust the log level on ActiveJDBC so it doesn't print a NOTICE to…
Ox3
  • 451
  • 1
  • 6
  • 22
0
votes
0 answers

retrieve image from database blob data type

Good day sir, I'm having trouble in deploying image from database with a blob datatype. I tried path and it's working good. Now I want to try out Blob but I'm having trouble what code will I use. thanks in advance sir database image value . here's…
Kuya
  • 28
  • 11
0
votes
1 answer

Socket write error with activejdbc

I have a pretty simple commandline app that runs inside of eclipse that connects to an Oracle 12 database and issues a pretty simple query. I'm getting the following exception: Exception in thread "main" org.javalite.activejdbc.InitException:…
Paul
  • 1
0
votes
1 answer

How do I do a CTE query in activejdbc?

I need to do a Common Table Expression (CTE) query, but can't figure out how to do this in activejdbc. DB is postgres 9.5 doing: Model.findbySQL("with cte as (...) select * from cte" gives me the error: java.lang.IllegalArgumentException: query…
dessalines
  • 6,352
  • 5
  • 42
  • 59
0
votes
1 answer

Time Limit When The Server Connection is Timed Out ? Active JDBC

In Active JDBC, is there a functionality that allows us to set Connection Time Out limit ? It works like... whenever the user deletes or (insert, update, etc..) a large number of data and suddenly the server's connection is lost... it will rollback…