Thanks for the welcome, Matthew!
I run OpenBD Desktop on my local machine.
This is where I wrote the sites and embedded the H2 DB, when I create
a WAR and deploy that in Jelastic, it breaks with the error that it
can't find the db (With a local path, not a relative one).
It worked fine locally, no issues.
This may be super simple, I've never used Java, or CFML so this is a
brand new world for me in most parts.
Ok, about the MySQL issue.
On my local box I went into the admin, Data & Services, Datasources,
fill in a name (mysqldb), database type MySQL, Add Datasource, fill in
the info on the next page (URL, username, password, database name,
server port is already set)
I hit Submit and it drops me back to the previous screen just like
when I created the H2's, except with the error at the top.
"Could not verify datasource: Must specify port after ':' in
connection string"
The datasource part of the XML (Which I've never opened before, btw.)
looks like this, with the specifics removed.
<datasource name="mysqldb">
<displayname>mysqldb</displayname>
<connectionretries>0</connectionretries>
<password>PasswordHere</password>
<sqldelete>true</sqldelete>
<sqlupdate>true</sqlupdate>
<username>root</username>
<drivername>com.mysql.jdbc.Driver</drivername>
<sqlstoredprocedures>true</sqlstoredprocedures>
<perrequestconnections>false</perrequestconnections>
<sqlinsert>true</sqlinsert>
<sqlselect>true</sqlselect>
<connectiontimeout>120</connectiontimeout>
<port>3306</port>
<server>http://mysql.darksidemagick.jelastic.servint.net</
server>
<databasename>mysqldb</databasename>
<description></description>
<connectstring></connectstring>
<logintimeout>120</logintimeout>
<initstring></initstring>
<hoststring>jdbc:mysql://http://
mysql.darksidemagick.jelastic.servint.net:3306/mysqldb?
cacheResultSetMetadata=false&autoReconnect=true</hoststring>
<maxconnections>24</maxconnections>
<name>mysqldb</name>
</datasource>
/Marcus
On Dec 21, 6:35 pm, Matthew Woodward <[email protected]> wrote:
> On Wed, Dec 21, 2011 at 4:16 PM, Trenatos <[email protected]> wrote:
> > I'm new to CFML
>
> Welcome! Very glad to have you join the ranks.
>
> > Now I'm looking at deploying a WAR file to Jelastic, everything works
> > fine except for the embedded database. (WAR exported through OpenBD
> > Desktop Server).
>
> Sounds like this may be a separate issue from your real end goal but you're
> saying the WAR with H2 that works locally *doesn't* work when deployed to
> Jelastic? If you're interested in investigating that follow up with some
> details and we'll see what we can figure out.
>
>
>
> > So I'm looking at connecting to a MySQL db on Jelastic, it's set up,
> > but when I try to create a datasource from my dev box, I get this
> > error when I click "Submit", after putting in the details in admin
> > interface: "Could not verify datasource: Must specify port after ':'
> > in connection string"
>
> Can you provide details (dummying out any sensitive information of course)
> with what you're putting in the admin and/or copy the relevant chunk from
> the /WEB-INF/bluedragon/bluedragon.xml file?
>
> I've set things up on CloudBees and MySQL without any issues so I have a
> feeling it'll just be a matter of getting the connection string right for
> Jelastic.
>
> > Hopefully one of you gurus take pity on a lowly CFML beginner?
>
> As much as we possibly can.
>
> Again, welcome to CFML!
> --
> Matthew Woodward
> [email protected]http://blog.mattwoodward.com
> identi.ca / Twitter: @mpwoodward
>
> Please do not send me proprietary file formats such as Word, PowerPoint,
> etc. as attachments.http://www.gnu.org/philosophy/no-word-attachments.html
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en
