Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community Forums"Cannot create PoolableConnectionFactory" error in "RUI with Database" tutorial
https://www.eclipse.org/forums/index.php/mv/msg/375341/911578/#msg_911578
Eclipse IDE for EGL Web Developers 0.8.1.v201207181102 epp.package.edt
The final project works in the Preview tab, and in the Debug mode.
However, when I try to run the deployed project ("Run as/Run on Server") in my embedded Tomcat 6 (that has the derbyclient.jar in its lib directory), I get the following error logged by the service's logging function:
Exception: SQLService, getAllPayments, SQLSTATE = , message = Cannot create PoolableConnectionFactory (Password length (0) is outside the range of 1 to 255.): [sqlstate:null][sqlcode:0]
I found no hits on the message on the Eclipse site. The few returns I got on an internet search did not refer to EGL and I did not understand what they were saying. I don't know if this is a Derby, Tomcat, or EDT problem.
I'm looking for insight!
]]>Jeffrey Gardner2012-09-11T22:36:38-00:00Re: "Cannot create PoolableConnectionFactory" error in "RUI with Database" tutor
https://www.eclipse.org/forums/index.php/mv/msg/375341/912059/#msg_912059
I may be completely off target here but I remember reading somewhere that a Derby DB only allows one connection, which includes your IDE. So, if you've got a database connection open in the IDE you probably won't be able to access the same DB again; you'd have to close the IDE server/DB connection first.
Richard]]>Richard Moulton2012-09-12T21:49:32-00:00Re: "Cannot create PoolableConnectionFactory" error in "RUI with Database" tutor
https://www.eclipse.org/forums/index.php/mv/msg/375341/912376/#msg_912376
I started the IDE but did not do the "Start network Derby server" option. I did a "Run on server" and got the same error.
I then did "Start the network Derby server", did the "Run on server" and got the same error.
Is there a way to check whether I really do have some connection under the covers when the server is running?]]>Jeffrey Gardner2012-09-13T13:01:45-00:00Re: "Cannot create PoolableConnectionFactory" error in "RUI with Database" tutor
https://www.eclipse.org/forums/index.php/mv/msg/375341/915710/#msg_915710
I tried the tutorial and received exactly the same problem, I was on the wrong track when I thought it might have been down to having multiple connections to the same db.
It's exactly as the message says, the password to the db is zero length. I'm not sure why this is a problem when run on the server and not from the IDE preview pane but that is the problem.
To solve this you need to provide a password, any password, it doesn't appear to matter what the password is. To do this open up the database development perspective. Then expand up the Database Connections option and you should see your 'Derby' connection profile. Right-click against it and select properties. Then click on the JDBC connection properties and specify a password, I used wibble, are you a fan of Blackadder? I also clicked the save password option and then OK. You'll need to deploy your project again but that should do the trick.
Richard
]]>Richard Moulton2012-09-17T20:23:09-00:00Re: "Cannot create PoolableConnectionFactory" error in "RUI with Database" tutor
https://www.eclipse.org/forums/index.php/mv/msg/375341/915720/#msg_915720
You actually answered two questions for me. I had just started hunting around in EDT for where my connection profile lived to look at the properties when your message came in. Two birds with one stone! Way to go!
(So much for clarity in the error messages. It did say a password length of 0 was unacceptable, but I had no idea what to do about it, and the message did not even hint at a solution.)
Now I might try reformatting the connection to use my iSeries as the database...
Thanks again. -- Jeff G.]]>Jeffrey Gardner2012-09-17T20:57:44-00:00Re: "Cannot create PoolableConnectionFactory" error in "RUI with Database" tutor
https://www.eclipse.org/forums/index.php/mv/msg/375341/916026/#msg_916026
Just wanted to pile on with thx to Richard.
I spent several hours trying to figure out why there was no place to view/maintain the connection. Probably obvious to experienced Eclipse/java techs but..............
Richard had to hit me in the head twice for me to see it.
Thx again,
Nathan Reed]]>Nathan Reed2012-09-18T12:29:12-00:00Re: "Cannot create PoolableConnectionFactory" error in "RUI with Database" tutor
https://www.eclipse.org/forums/index.php/mv/msg/375341/916169/#msg_916169
Richard Moulton wrote on Mon, 17 September 2012 15:23
I used wibble, are you a fan of Blackadder?
Big fan of all-things Rowan Atkinson.
Blackadder: "I've got a plan so cunning, you could stick a tail on it and call it a weasel!"
]]>Dan Darnell2012-09-18T16:40:03-00:00Re: "Cannot create PoolableConnectionFactory" error in "RUI with Database" tutor
https://www.eclipse.org/forums/index.php/mv/msg/375341/916182/#msg_916182
George: "What is your name?"
Blackadder: "Wibble."
George: "What is 2 plus 2?"
Blackadder: "Wibble, Wibble."
Blackadder, trying to prove he is mad, in his bunker, with underpants on his head and a pendil up each nostril
I can just picture him now, it cracks me up every time I see it, good stuff.