You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Emmanuel Dupont <em...@jwaretechnologies.com> on 2003/04/16 08:30:37 UTC

RE : reverse-db and mssql server

MySql doesn't provide the Database schema. You think that can't generate the
Xml with it. 


-----Message d'origine-----
De : luke cassady-dorion [mailto:luke@netraker.com] 
Envoyé : mardi 15 avril 2003 20:02
À : 'OJB Users List'
Objet : reverse-db and mssql server

I am trying to get reverse-db to generate xml for a mssql server db and
feel like I'm banging my head up against a wall. I am able to connect to
the db fine and by leaving both regular expressions blank and able to
read the list of databases and all of their users, but can't seem to see
tables or columns (should I be able to??). 

Also, when I generate XML, all I get is the following connection
descriptor, I can't seem to generate XML for the tables. Any ideas?

<descriptor-repository version="0.9.9">
  <jdbc-connection-descriptor
    jcd-alias="default"
    default-connection="true"
    platform="XXXX"
    jdbc-level="1.0"
    driver="XXX"
    protocol="XXX"
    subprotocol="XXX"
    dbalias="XXX"
    username="XXX"
    password="XXX">
  </jdbc-connection-descriptor>


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

RE: RE : reverse-db and mssql server

Posted by Matthias Roth <ma...@impart.ch>.
Hi,
you can use the OJBPlugin.jar from the eclipse
Plugin to generate classes and repository files
With out eclipse.
http://www.impart.ch/download/

set the properties in the ImpartOJBGenerator.properties
and start the generator with out eclips by calling
the class Main of the OJBPlugin.jar.

(the jdbc driver should by in your classpath)

good luck
Matthias Roth
-----Original Message-----
From: luke cassady-dorion [mailto:luke@netraker.com] 
Sent: Mittwoch, 16. April 2003 16:31
To: 'OJB Users List'
Subject: RE: RE : reverse-db and mssql server

Actually I'm using mssql server, from microsoft

> -----Original Message-----
> From: Emmanuel Dupont [mailto:emmanuel.dupont@jwaretechnologies.com]
> Sent: Tuesday, April 15, 2003 11:31 PM
> To: 'OJB Users List'
> Subject: RE : reverse-db and mssql server
> 
> MySql doesn't provide the Database schema. You think that can't
generate
> the
> Xml with it.
> 
> 
> -----Message d'origine-----
> De : luke cassady-dorion [mailto:luke@netraker.com]
> Envoyé : mardi 15 avril 2003 20:02
> À : 'OJB Users List'
> Objet : reverse-db and mssql server
> 
> I am trying to get reverse-db to generate xml for a mssql server db
and
> feel like I'm banging my head up against a wall. I am able to connect
to
> the db fine and by leaving both regular expressions blank and able to
> read the list of databases and all of their users, but can't seem to
see
> tables or columns (should I be able to??).
> 
> Also, when I generate XML, all I get is the following connection
> descriptor, I can't seem to generate XML for the tables. Any ideas?
> 
> <descriptor-repository version="0.9.9">
>   <jdbc-connection-descriptor
>     jcd-alias="default"
>     default-connection="true"
>     platform="XXXX"
>     jdbc-level="1.0"
>     driver="XXX"
>     protocol="XXX"
>     subprotocol="XXX"
>     dbalias="XXX"
>     username="XXX"
>     password="XXX">
>   </jdbc-connection-descriptor>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

RE: RE : reverse-db and mssql server

Posted by luke cassady-dorion <lu...@netraker.com>.
Actually I'm using mssql server, from microsoft

> -----Original Message-----
> From: Emmanuel Dupont [mailto:emmanuel.dupont@jwaretechnologies.com]
> Sent: Tuesday, April 15, 2003 11:31 PM
> To: 'OJB Users List'
> Subject: RE : reverse-db and mssql server
> 
> MySql doesn't provide the Database schema. You think that can't
generate
> the
> Xml with it.
> 
> 
> -----Message d'origine-----
> De : luke cassady-dorion [mailto:luke@netraker.com]
> Envoyé : mardi 15 avril 2003 20:02
> À : 'OJB Users List'
> Objet : reverse-db and mssql server
> 
> I am trying to get reverse-db to generate xml for a mssql server db
and
> feel like I'm banging my head up against a wall. I am able to connect
to
> the db fine and by leaving both regular expressions blank and able to
> read the list of databases and all of their users, but can't seem to
see
> tables or columns (should I be able to??).
> 
> Also, when I generate XML, all I get is the following connection
> descriptor, I can't seem to generate XML for the tables. Any ideas?
> 
> <descriptor-repository version="0.9.9">
>   <jdbc-connection-descriptor
>     jcd-alias="default"
>     default-connection="true"
>     platform="XXXX"
>     jdbc-level="1.0"
>     driver="XXX"
>     protocol="XXX"
>     subprotocol="XXX"
>     dbalias="XXX"
>     username="XXX"
>     password="XXX">
>   </jdbc-connection-descriptor>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org