search

RocketSoftware / multivalue-lab

Demo code from Rocket's MV Servers Lab for UniVerse/UniData/D3 and associated clients, APIs & tools
MIT License
72 stars 83 forks source link

JDBC ConnectonPool with Trial version #82

Open fcortesr opened 5 years ago

fcortesr commented 5 years ago

Hi am working with a trial version of UNIDATA i would like to know if jdbc connectionpool datasource is supported with this trial version.

when I tried my code or the examples provided i get an error thrown not very descriptive of the issue that caused it

mrajkowski commented 5 years ago

You would need to have available connection pooling licenses. The easiest way to check is the LISTUSER comand.

`:LISTUSER

Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total

(  32 + 2 ) / 34                         1       0             0           0               1

UDTNO USRNBR UID USRNAME USRTYPE TTY IP-ADDRESS TIME DATE 1 8816 305727 mrajkowsk udt pts/1 Console 11:13:12 Mar 15 2019`

Note that the command shows how many licenses you have in this case 32 udt licenses and 2 Connection pooling licenses ( 32 + 2 ), and we see that none are in use. As for the error, if you try to use CP and there are no licenses, the connection will fail. Does the test of JDBC work if you do not use connection pooling?