| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 02/09/2010 08:27:22
|
Rastko
SysAider
Joined: 12/03/2010
Messages: 5
Offline
|
Hi guys,
I currently have sysaid with a derby database. On the local machine I can connect to the derby server. Like I know the default settings for a derby server are that they don't allow remote connections but I would like to have that. I searched a little trough the sysaid config files but I was unable to find where and when the derby server starts. If I could alter the startup parameters that would be like this ""%_JAVACMD%" %DERBY_OPTS% -classpath "%LOCALCLASSPATH%" org.apache.derby.drda.NetworkServerControl start" and add " -h 0.0.0.0" in the end I would be able to connect to the derby server remotely.
Is something like this possible or is the derby startup hardcoded and I am forced to migrate sysaid to another database?
|
|
|
05/09/2010 04:07:16
|
itayH
SysAid Customer Relations
Joined: 23/09/2009
Messages: 1092
Offline
|
Hi Rastko,
What would you like to achieve by entering your Derby DB?
Remember the you are allowed to run only read only queries.
You can read here about how to connect to your Derby DB:
http://www.ilient.com/Sysforums/posts/list/621.page
|
Best Regards,
Itay |
|
|
07/09/2010 02:04:23
|
campbeller
SysAider
Joined: 25/08/2010
Messages: 2
Offline
|
Hi,
Is it possible to connect to the running DERBY database via the command line? SysAid is running so the database is already started. I just want to run SQL statements from the command line; but the only ways I have seen so far on the forums is to use Java JDBC.
I would like to be able to run sql queries and export the data to CSV format. I do not wish to change any data in the tables.
Thanks in advance.
D
|
|
|
07/09/2010 12:49:36
|
itayH
SysAid Customer Relations
Joined: 23/09/2009
Messages: 1092
Offline
|
Hi D,
According to my knowledge what you are asking is not possible and because we are not supporting this I will stop here 
|
Best Regards,
Itay |
|
|
08/09/2010 01:11:10
|
Rastko
SysAider
Joined: 12/03/2010
Messages: 5
Offline
|
Hello, thank you for the presented solution.
My solution of this is was:
1. Copy derby on local computer
2. replace ij.bat file with original
3. create copy live database on local computer every day from backup copy
4. start ij.bat
5. start database server from bin\startnetworkserver.bat
6. connect with reporting program (TalendOpenStudio)
7. creating my own reports for internal solution.
Thank you.
|
|
|
13/09/2010 10:11:12
|
itayH
SysAid Customer Relations
Joined: 23/09/2009
Messages: 1092
Offline
|
Hi Rastko,
Good idea, I forgot to offer you the option of creating copy of the DB and...
Glad you found original way to achieve your goal.
|
Best Regards,
Itay |
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
