Re: user can't access own database after creation

I belive you should enable a greater level of debugging in JPA, otherwise would be difficult to help.

Also, looking your could I can foresee one future problem that is the lack of a connection pool for the cloud environment. Without a pool you would run out of scalability.

Just my 2c.

Regards

Edson Richter

Enviado do meu smartphone Sony Xperia™

---- Nuno Zimas escreveu ----

Hi Dave,

Since you do know quite a bit about Java, could you please tell me if there’s something fishy in the file where the connection to postgresql is defined?

Thank you.

https://github.com/flabser/2next/blob/master/src/com/flabser/dataengine/DatabaseCore.java

Nuno.

> On 2 Dec 2015, at 22:17, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>
> Yes, JDBC is still involved. I'd say there is a mistake in the JPA config
>
> Dave Cramer
>
> davec(at)postgresintl(dot)com <mailto:davec(at)postgresintl(dot)com>
> www.postgresintl.com <http://www.postgresintl.com/>
> On 2 December 2015 at 17:15, Nuno Zimas <nzimas(at)gmail(dot)com <mailto:nzimas(at)gmail(dot)com>> wrote:
> The programmer says that she relies on JPA to establish the connection, but I suppose that JDBC is still involved, otherwise i can’t see how java would talk to postgresql.
> Unless JPA does so directly.
> Like I said, Java really isn’t my thing.
>
>
>
>> On 2 Dec 2015, at 22:05, Nuno Zimas <nzimas(at)gmail(dot)com <mailto:nzimas(at)gmail(dot)com>> wrote:
>>
>>
>> Thanks a lot, everyone (and specially Dave Cramer).
>> Now I know the issue is not JDBC related.
>> Not sure of this is good news for me, though :)
>>
>> I’d think that the application needs to be amended.
>> Still, this does not account for the fact that it works on a local win machine.
>>
>> As you can see, Dave’s little program connects like a charm,
>>
>> 2015-12-02 17:00:22 EST [2408-1] postgres(at)postgres LOG: duration: 16.239 ms parse <unnamed>: SET extra_float_digits = 3
>> 2015-12-02 17:00:22 EST [2408-2] postgres(at)postgres LOG: duration: 0.023 ms bind <unnamed>: SET extra_float_digits = 3
>> 2015-12-02 17:00:22 EST [2408-3] postgres(at)postgres LOG: duration: 0.031 ms execute <unnamed>: SET extra_float_digits = 3
>> 2015-12-02 17:00:22 EST [2408-4] postgres(at)postgres LOG: duration: 0.217 ms parse <unnamed>: select 1
>> 2015-12-02 17:00:22 EST [2408-5] postgres(at)postgres LOG: duration: 0.100 ms bind <unnamed>: select 1
>> 2015-12-02 17:00:22 EST [2408-6] postgres(at)postgres LOG: duration: 0.953 ms execute <unnamed>: select 1
>>
>>
>>
>>> On 2 Dec 2015, at 21:45, Dave Cramer <pg(at)fastcrypt(dot)com <mailto:pg(at)fastcrypt(dot)com>> wrote:
>>>
>>> log_min_duration
>>
>
>