Hello.
I am using Apache derby database (Client network).
I see that when I create table it is created on an instance APP
(I don't know if instance is the correct word. sorry of my English).
I see that there are other instances (NULLID, SQLJ, SYS, etc).
Can I create an instance of my own in derby database, and how can I do that
?
(One instance may be used for repository, another for Datawarehouse, ...)
Another thing :
If I create several databases for te above reason (repository may be on
another db), how can I join them, when I am connected to database1, and want
to run a query that join both tables from database1 and database2 ?
I think my derby database keeps on getting corrupted ... Every now and then my derby database gets to a stage where I'll get a ...disk full message when I try to insert rows. ... The database will only be around 2megs in size, ... I can't find a repair function... (comp.lang.java.programmer)
Re: Apache Derby : create several instances. ... Can I create an instance of my own in derby database, and how can I do that? ... You can create a new schema using the CREATE SCHEMA statement:... If I create several databases for te above reason (repository may be on another db), how can I join them, when I am connected to database1, and want to run a query that join both tables from database1 and database2? ... (comp.lang.java.databases)
Re: Object serialization ... >>Assuming a relational database and you do not want to store the ... >>the object to store itself using SQL. ... Sorry, I have no idea what a Derby database is, as I said, I assumed ... in which case you'd use sql to store the data. ... (comp.lang.java.programmer)
Re: problem with a DTS "Analysis Services Processing Task" ..."Darren Gosbell" wrote: ...Server A from Server B, then this is not the issue. ...database that you are trying to process. ... Where is your Olap Repository located?... (microsoft.public.sqlserver.olap)
Re: Supporting SP1 and SP2 Databases ... replace both MantisSQLDB_Data.mdf (the database) and MantisSQLDB_Log.ldf files. ... But keep in mind that you are using the same Repository locations for both SPs in your scenario. ... repository is separate from SP1....install component database again with sp2. ... (microsoft.public.windowsxp.embedded)
