Re: [Sqlrelay-discussion] include config files using XML entities?

[David M. <dav...@fi...>]

Hi Cal,

Unfortunately, the ENTITY tag isn't currently supported.  SQL Relay uses 
a fairly simple XML parser from the Rudiments library that doesn't 
support a few things, including entity tags.  It does support "built-in" 
entities like " and ' and n and so forth, but not 
entities defined with the entity tag.

It is on my to-do list.  It's funny, it's is actually one of the older 
tasks in my PM system but it's always been in the "nice-to-have" 
category and I just haven't gotten around to it yet.

If it's is important to you guys, then I'd be happy to implement it for 
you on a contract basis.  Let me know if you're interested.

Dave
dav...@fi...

On 1/7/2014 2:44 PM, Cal Heldenbrand wrote:
> Hi everyone,
>
> Is it possible to create a file hierarchy for the config file using the
> ENTITY tag in DOCTYPE?  Here's what I tried in sqlrelay.conf:
>
> --------------------------------------------------------
> <?xml version="1.0"?>
> <!DOCTYPE instances SYSTEM "sqlrelay.dtd" [
>    <!ENTITY server1 SYSTEM "/opt/sqlrelay/etc/db2/server1.xml">
> ]>
> <instances>
>    &server1;
> </instances>
> --------------------------------------------------------
>
> ----------------  server1.xml  --------------------
> <instance id="server1"
>     ...
>>
>     <connections> ...
> </instance>
> --------------------------------------------------------
>
> But, it seems that on startup, sql relay does not find my "server1"
> instance and it fails, with no error logs or anything useful.
>
> # ./sqlr-start -id server1
> Couldn't find id server1.
>
> Does the XML parser just plain not support doing include files?  Or can
> you spot anything wrong with my syntax?  I'm certainly no XML expert.
>
> Thanks!
>
> --Cal
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>
>
>
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>
>
> _______________________________________________________
> Unlimited Disk, Data Transfer, PHP/MySQL Domain Hosting
>                http://www.doteasy.com
>