David, I do something similar and don't have a problem. The only things I see different from your code snippet compared to what I do is two things.
1. the driver I use is "com.mysql.jdbc.Driver" ... but that doesn't mean yours is wrong if that is the correct driver you are using. 2. I specify the port on the hoststring as such: "jdbc:mysql://8.8.8.8:3306/MyDatabase?cacheResultSetMetadata=false&autoReconnect=true&characterEncoding=UTF-8" I guess also a few different parameters, but they shouldn't matter. Hope that helps some. Thanks, Alan Cole (PGP Key ID: 0x82D8E0C7) Begin forwarded message: > From: David Mulder <[email protected]> > Subject: [OpenBD] datasourcecreate isn't working > Date: June 20, 2013 9:09:03 AM EDT > To: [email protected] > Reply-To: [email protected] > > Hi, > > The example for datasourcecreate is > > if ( !DataSourceIsValid("myds") ){ > var ds = { > username : "user1", > password : "password1", > databasename : "MyDatabase", > drivername : "org.gjt.mm.mysql.Driver", > hoststring : > "jdbc:mysql://8.8.8.8/MyDatabase?useUnicode=true&characterEncoding=UTF-8" > }; > DataSourceCreate( "myds", ds ); > } > > which gives a > > You are missing one of the core parameters (hoststring, drivername, > databasename, username, password) > > error. I checked the source of datasourcecreate and everything seems to be > valid and correct. > > Thanks! > > David > > PS. anybody interested can check out pre alpha preview of a openbd/cfml > framework I am working on at https://github.com/GreatS/lBase . It's > pre-alpha, a lot of features are missing still and it still needs quite a bit > of polish, but I am getting there slowly :D . More news will follow once I > will finish a beta release :P for now let is suffice to say that it takes the > good stuff from codeigniter and then adds a whole bunch of extra goodies > (modules, asset support, automatic documentation generation (module), less > support, mustache support, component specific scoping (a component can decide > itself where it wants to be stored), natural mongodb syntax (module), > markdown (module) and more :D ). Especially the modules are unfinished and > lack polish and right now "a lot" of stuff breaks on linux due to the > linebreaks, as I am currently working on a fork which runs on linux I hope to > get this fixed and merged sometime soon. Just thought I would drop a line > like this for anybody interested :P doubt anybody will check it out yet, but > whatever :D . > -- > -- > online documentation: http://openbd.org/manual/ > http://groups.google.com/group/openbd?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Open BlueDragon" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en --- You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
