[Logo] Jaikoz- Discussion Forum
  [Search] Search   [Recent Topics] Recent Topics   [Members]  Member Listing   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
java.sql.SQL.Exception: Connections could not be acquired from the underlying database!  XML
Forum Index -> Issues Go to Page: Previous  1, 2, 3 Next 
Author Message
greengeek

Pro
[Avatar]
Joined: 18/09/2007 02:50:48
Messages: 205
Offline

After I sent you the logs, I went back in cleared out my cache, shutdown jaikoz, and deleted the old logs. I went back into jaikoz and tried to load a folder my just selecting it so it would fail. I then exited jaikoz.

I checked the log files and there was no mention of any error or anything in regards to this. Here is the full content of both the new log files:

Code:
 24/01/2012 17.53.29:com.jthink.jaikoz.MainWindow:setupLAF:WARNING: Look and Feel from UserSettings Is:
 24/01/2012 17.53.31:com.jthink.jaikoz.MainWindow:runOnEventThread:SEVERE: Jaikoz has been configured with minimum heap memory of 64 mb, maximum heap memory of 738 mb and maximum permanent memory of 86 mb
 24/01/2012 17.53.31:com.jthink.jaikoz.MainWindow:runOnEventThread:SEVERE: Jaikoz 4.5.4 NGS using Java 1.6.0_29 20.4-b02 32bit on Windows 7 6.1 x86 initialized successfully 
 24/01/2012 17.53.31:com.jthink.jaikoz.MainWindow:runOnEventThread:SEVERE: No of logical cpus:4
 24/01/2012 17.53.46:com.jthink.jaikoz.layout.MainFrame:shutdownJaikoz:WARNING: Jaikoz has exited successfully
 


and

Code:
 Jan 24, 2012 5:53:31 PM: INFO: Jaikoz has been configured with minimum heap memory of 64 mb, maximum heap memory of 738 mb and maximum permanent memory of 86 mb
 Jan 24, 2012 5:53:31 PM: INFO: Jaikoz 4.5.4 NGS using Java 1.6.0_29 20.4-b02 32bit on Windows 7 6.1 x86 initialized successfully 
 Jan 24, 2012 5:53:46 PM: INFO: Jaikoz has exited successfully
 


Don't know if there is anything helpful in there for you.

KevinBluemel.com
New Age musician and composer. Stop by to listen and get free downloads.
[WWW]
greengeek

Pro
[Avatar]
Joined: 18/09/2007 02:50:48
Messages: 205
Offline

So I thought I would try to approach it from a different direction. I uninstalled jaikoz and uninstalled all instances of java. Reinstalled just the 64bit version of java and added it to my path environment, and restarted my system. Went to install jaikoz and it gave me the No Java popup that it wanted Java 1.6.0. Does it need exactly this version? I thought I read else where on the site here that jaikoz just needed 1.6.0 or higher.

I can type path at the cmd line and the first item is:

Code:
 PATH=C:\bin\Java\jdk1.7.0_02\bin;...
 


java -version at the command prompt comes back with:

Code:
 java version "1.7.0_02"
 Java(TM) SE Runtime Environment (build 1.7.0_02-b13)
 Java HotSpot(TM) 64-Bit Server VM (build 22.0-b10, mixed mode)
 


Do I need to install the 32bit version to just install jaikoz?


KevinBluemel.com
New Age musician and composer. Stop by to listen and get free downloads.
[WWW]
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 4211
Online

greengeek wrote:
After I sent you the logs, I went back in cleared out my cache, shutdown jaikoz, and deleted the old logs. I went back into jaikoz and tried to load a folder my just selecting it so it would fail. I then exited jaikoz.

Don't know if there is anything helpful in there for you. 


Hi, sort of done of my debugging showed up which essentially let me know the problem was occurring in the Open Folder Dialog rather than later on although I may upload a alter release to confirm this. I originally thought the problem was due to chanages I made for identifying Base Folder but it doesn't seem it is, but the big problem I have is being unable to reproduce it.

thanks Paul (Administrator)
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 4211
Online

greengeek wrote:
So I thought I would try to approach it from a different direction. I uninstalled jaikoz and uninstalled all instances of java. Reinstalled just the 64bit version of java and added it to my path environment, and restarted my system. Went to install jaikoz and it gave me the No Java popup that it wanted Java 1.6.0. Does it need exactly this version? I thought I read else where on the site here that jaikoz just needed 1.6.0 or higher
 


No, you are correct Java 1.6.0 is just the minimum required. There was a problem whereby the installer wouldn't recognize that only a 64bit Java was installed and require a 32 bit Java for the installer, but that issue was fixed a while ago.

Maybe there is a similar (but new) problem introduced with Java 1.7 , I dont know I havent tried it yet but I will give it a go. In the meantime if you install 32-bit Java I expect install will work, then you can delete it Jaikoz will run on the 64bit Java.

thanks Paul (Administrator)
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 4211
Online

I've managed to replicate it, the problem only occurs for me if you double click into a folder first. So for example if you start in C:\ and single click on Music it will work but if you double click on Music and then single click on a folder within C:\Music it will not work. The bug is due to a change I made to do with Guess Base Folder in that I save changes to options to early on messing up your selected files, I will release Jaikoz 3.5.5 later this morning, sorry for the inconvenience.

thanks Paul (Administrator)
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 4211
Online

Fixed, 4.5.5. now available.

thanks Paul (Administrator)
greengeek

Pro
[Avatar]
Joined: 18/09/2007 02:50:48
Messages: 205
Offline

Installed 1.6 32bit to install jaikoz. I will hold off uninstalling it for now incase the next release requires it to install or upgrade. I just started it up and noticed the same thing. If i stay within the base folder and only single click an album that is already at that level, it will load.

For me, not only double clicking on a folder breaks it, but using the up arrow next to the look in drop down will also break it.

KevinBluemel.com
New Age musician and composer. Stop by to listen and get free downloads.
[WWW]
greengeek

Pro
[Avatar]
Joined: 18/09/2007 02:50:48
Messages: 205
Offline

Wow that was quick! Downloading and trying it now

KevinBluemel.com
New Age musician and composer. Stop by to listen and get free downloads.
[WWW]
greengeek

Pro
[Avatar]
Joined: 18/09/2007 02:50:48
Messages: 205
Offline

Just installed it and folders are loading nice and smoothly. Was able to load both folder within and outside of base as well as groups of folders using the ctrl or shift keys.

Thanks again!

KevinBluemel.com
New Age musician and composer. Stop by to listen and get free downloads.
[WWW]
super12v



Joined: 03/02/2012 23:40:09
Messages: 5
Offline

I've just installed 4.5.6 on a Win7 64bit Home premium installation and getting this error when I launch the desktop short cut.

I had the 32bit java install already.

Code:
C:\Program Files (x86)\Java\jre6\bin>java -version
 java version "1.6.0_29"
 Java(TM) SE Runtime Environment (build 1.6.0_29-b11)
 Java HotSpot(TM) Client VM (build 20.4-b02, mixed mode, sharing)


I followed by installing the 64bit version of java, after the initial loading failure.

Code:
java version "1.6.0_30"
 Java(TM) SE Runtime Environment (build 1.6.0_30-b12)
 Java HotSpot(TM) 64-Bit Server VM (build 20.5-b03, mixed mode)


I've uninstalled Jaikoz and re-installed this, and the below is the contents of the logfile created. Also it is leaving a jaikos.exe *32 process running which I have to end manually.

Code:
04/02/2012 05.07.06:com.jthink.jaikoz.db.Db:printSQLException:SEVERE: Err:Connections could not be acquired from the underlying database!:ErrCode:0:State:null
 04/02/2012 05.07.07:com.jthink.jaikoz.db.Db:printSQLException:SEVERE: Err:Connections could not be acquired from the underlying database!:ErrCode:0:State:null
 04/02/2012 05.07.07:com.jthink.jaikoz.MainWindow:setupWindow:SEVERE: java.sql.SQLException: Connections could not be acquired from the underlying database!
 java.lang.RuntimeException: java.sql.SQLException: Connections could not be acquired from the underlying database!
 	at com.jthink.jaikoz.db.Db.emptyCache(Db.java:702)
 	at com.jthink.jaikoz.db.Db.emptyAndPruneCache(Db.java:616)
 	at com.jthink.jaikoz.MainWindow.setupFirstTimeOrUpgrade(MainWindow.java:398)
 	at com.jthink.jaikoz.MainWindow.setupWindow(MainWindow.java:277)
 	at com.jthink.jaikoz.Start.main(Start.java:117)
 Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!
 	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
 	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
 	at com.jthink.jaikoz.db.Db.createConnection(Db.java:403)
 	at com.jthink.jaikoz.db.Db.emptyCache(Db.java:681)
 	... 4 more
 Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
 	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
 	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
 	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
 	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
 	... 7 more
 


Thanks for the help, this the is the first time I have used this in windows.
super12v



Joined: 03/02/2012 23:40:09
Messages: 5
Offline

I've just run the jaikos.bat from cmd.exe and below is an extract of the beginning, I notice if I ^C from the batch script the process does hang up correctly. The splash is also displayed when launching from the .bat

Code:
C:\Program Files (x86)\Jthink\Jaikoz>jaikoz.bat
 Feb 04, 2012 5:34:12 AM com.jthink.jaikoz.settings.LAF setLAF
 INFO: Now LAF subvals are0:JAVA_1_6:Metal
 Feb 04, 2012 5:34:12 AM com.jthink.jaikoz.settings.LAF setLAF
 INFO: LAF is:26
 debuglogfile is:C:\Users\super12v/Jaikoz/Logs/jaikozdebug%u-%g.log
 Sat Feb 04 05:34:14 GMT 2012 Thread[main,5,main] java.io.FileNotFoundException:
 derby.log (Access is denied)
 Sat Feb 04 05:34:14 GMT 2012 Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#3,5,main] Cleanup action starting
 java.sql.SQLException: Database 'C:\Users\super12v\Jaikoz/jaikozdb' not found.
         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
         at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
         at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
         at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
         at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source)
         at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
         at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
         at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
         at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
         at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
         at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
         at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
         at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
         at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
         at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
         at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
         at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
         at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
 Caused by: java.sql.SQLException: Database 'C:\Users\super12v\Jaikoz/jaikozdb' not found.
         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
         ... 20 more
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 4211
Online

Have you tried just leaving it alone for 10 minutes, it can take a while on first startup to setup the database.

thanks Paul (Administrator)
super12v



Joined: 03/02/2012 23:40:09
Messages: 5
Offline

Hi Paul,

I just relaunched it now and the same error occurs (see attached), do you want the process left running for 10 minutes? if so I will do so.

[Thumb - jaikoz error.jpg]
 Filename jaikoz error.jpg [Disk] Download
 Description
 Filesize 24 Kbytes
 Downloaded:  11 time(s)

super12v



Joined: 03/02/2012 23:40:09
Messages: 5
Offline

just relaunched and the same error
paultaylor

Pro
[Avatar]

Joined: 21/08/2006 09:21:27
Messages: 4211
Online

Hmm. in trying to fix one thing I seem to have broken Jaikoz for brand new installations, I'll get a fixed release out soon.

thanks Paul (Administrator)
 
Forum Index -> Issues Go to Page: Previous  1, 2, 3 Next 
Go to:   
Powered by JForum 2.1.6 © JForum Team