Schema « Schema « Java Database Q&A

1. Is it possible to upgrade the DB schema with EJB?    stackoverflow.com

lets say I have an EJB application wich defines some entities and relations among them. I figured the DB schema can easily be created from the entities. So now the app ...

2. Changing Database schemas & unit tests    stackoverflow.com

     Before we start I know a fair few people consider tests that hit the database not "unit tests". Maybe "integration tests" would be a better name. Either way developer tests ...

3. Pattern for creating a database schema using JDBC    stackoverflow.com

I have a Java-application that loads data from a legacy file format into an SQLite-Database using JDBC. If the database file specified does not exist, it is supposed to create a ...

4. Java library for reading database schema    stackoverflow.com

I'm looking for a lightweight, open source, more or less cross-database Java library that would allow me to read off metainformation on columns, tables and integrity constraints given a DataSource.

5. H2 database and functions in separate schemas    stackoverflow.com

I'm trying to create a test database (with H2 database). I'm using Oracle in production, and it seems nice to have oracle compatibility mode in h2. However I've got a problem with ...

6. Multi-Tenant application - How to achieve Shared database separate schema implementation?    stackoverflow.com

I have to make a web application multi-tenant enabled using Shared database separate schema approach. Application is built using Java/J2EE and Oracle10g. I need to have one single appserver using a ...

7. Is there a Java API for comparing Database Schemas    stackoverflow.com

I'd like to compare if

• tables
• columns including datatypes and length/precision.
• indexes and their columns
• constraints

8. iBatis schemas not working in Visual Studio 2010    stackoverflow.com

iBatis comes with three schema files that provide intellisense to VS.Net. According to the iBatis help docs, the location should be this:

C:\Program Files\Microsoft Visual Studio 10.0\Common7\Packages\schemas\xml

9. Database schema for getting started with a Content Management System    stackoverflow.com

Hi I'm starting development of a small content management system but struggling to figure out how to get started. Does any one know where I can get a database schema or ...

10. Generating Apache AXIS2 WebServices from a (my)SQL schema?    stackoverflow.com

Is there any tool that could be used to generate some code for apache Axis2 from a (my)sql schema. For example, the following schema:

desc name;
+-------+------------------+------+-----+---------+-------+
| Field | Type   ...

11. How do you change the schema in an OO database such as DB4O?    stackoverflow.com

Just getting started with DB4O object oriented database. I'm very familiar with SQL, if I upgrade the app and add a new field I just go into a SQL manager, change the ...

12. What possible schema can I use to store words combinations?    stackoverflow.com

I'm making a simple program in Java. Given a set of letters it'll list all the words (with more than 2 letters) that match the combinations of the letters.
For example:
...

13. Setting Schema for MyBatis (iBatis)    stackoverflow.com

I am calling SqlSession.openSession(Connection) in MyBatis. The Connection is to a MySQL database and does not have a schema specified in the URL (e.g. jdbc:mysql://localhost). I'd like to set a "default ...

14. Lossless schema mapping from XML records to relations    stackoverflow.com

I have a problem of dealing with close to 100000 xml records. The problem is to construct a schema mapping from xml schema of these records to relations Any ideas in ...

15. JDBC uses my username as Schema    stackoverflow.com

I've been trying to connect my application with a derby DB, containing the table ITEMS inside. The problem is when I try to insert an element in this table. When I ...

16. Java DB Schema 'TEST' does not exist    stackoverflow.com

Hy!!! I want to make a small DB Demo. My Error is: Schema 'TEST' does not exist Picture:

17. get schema name    stackoverflow.com

can some one pls tell me how to get the 'schema name' for a particular 'sequence' using jdbc

18. Migrating fields in JDO    stackoverflow.com

We are using JDO in one of our projects. This has been running for quite a while and naturally we need to change the model a bit. What is the best practice ...

19. Working with multiple database schemas    stackoverflow.com

There is a third-party application, which database is accessed by my application. It's database schema had been changed several times, so, there are about four different database schemas right now (different ...

20. Migrating Data accross different DB Schema    stackoverflow.com

I want to migrate my data from one DB to other using Java. Both DBs have different schema structure. I might also need to define some mapping / validation rule. Can ...

21. Is it possible to generate class domain from existing database schema?    forum.springsource.org

I have tried this plugin on 2.0.0 RC3. Any pointers will be helpful.. Set the configuration etc in Config.groovy and running the 'grails db-reverse-engineer', I get the following error: log4j:WARN No ...

22. Generate Entity Classes from Database - other schemas    forums.netbeans.org

so, in databases like Oracle we have multiple schemas, and the user that is connected will have privileges to multiple schemas. i just noticed that the interface for reverse engineering the ...

23. How to change the name of schema for SQL database ?    forums.netbeans.org

Hi, after i've created the table. In Service windows when i expand the database/master: public is hilghted but my table is in dbo. How is it possible to have the dbo ...

24. NetBeans is not able to retrive only part of the database schema    forums.netbeans.org

Hello, If I try to create a new 'Entity Class from database' in NB 6.9 for JPA application, I have to enter Database Connection f.e. jdbc:oracle:thin:@161.14.22.66:1565:TESTDB OK! It 's not a problem. It is also not a problem if an Oracle-shema has only a couple of tables(10-20 perhaps). NB queried them all in 2 secodns. The trouble comes if my Oracle-shema ...

25. Application regeneration after database schema recapture    forums.netbeans.org

I've been seeking, without success, a function to regenerate an existing project's application code to recognize a change in a database it's using, e.g. addition of a new column; after performing a "Recapture Schema from Database." The only solution I can see is to re-perform the steps as documented in the "Creating the Application" section of the "Building a Java Desktop ...

26. using database schemas    forums.netbeans.org

i'm using netbeans 6.9 and i wanted to create a database by clicking on the Java DB node in the services palette but after doing the appropriate steps i found many shemas of databases (APP, SQLJ,,) i want to remove those schemas because when i try to bind a Jtable with the database i find NO tables all i want to ...

27. what can i use a captured database schema file for ?    forums.netbeans.org

28. What's new between 2.0 vs 1.8 with db schema?    forums.terracotta.org

29. Database Schema    coderanch.com

30. eCommerce / shopping basket schema?    coderanch.com

has anybody seen any example applications on the web or in a book cdrom somewhere as part of a tutorial or a discussion, where an ecommerce application database schema is shown? i'm looking for a typical example for a proposal - i mean, i can think up a few tables already: order, order items, articles, users etc etc. i'm hoping out ...

31. Schema for Flat file    coderanch.com

32. getTables schema question    coderanch.com

Hi, hope you can help me out. I have written a tool which can connect to different databases via JDBC or ODBC, it has been working perfectly till now. The problem I am having is retrieving tables for a specific schema/view. Up to now I have been using the userid (which the user connects to the db with) as the schema ...

33. Can't find the special schema.    coderanch.com

34. Using JDO with an existing DB schema    coderanch.com

JDO has two forms of identity: datastore and application. Application identity is similar to primary keys in a relational database and all the JDO relational implementations support this. With an existing relational schema, you are not likely to have inheritance represented in your tables, so you would typically not have inheritance in your classes. Your foreign keys in the relational schema ...

35. Mapping different XML documents to a single database schema?    coderanch.com

So, I have a request processing system which receives slightly different XML messages from different sources (client applications). The requirement is that every request needs to be logged into a database. Now, the question remains, how should I design the database schema for storing these log entries when one complex element in the incoming requests varies? Of course I could have ...

36. Schema Name and Database Name    coderanch.com

37. Making schema changes to an Application    coderanch.com

G'Day all, Thought I'd make a post to see what other people think of something I just started to think about.. I'm developing a swing based App, at the moment during development i'm switching between using mySql & hsqldb as my database for the app(Just because I find the gui's available for mysql easier to use, but the final version will ...

38. Multiple schemas    coderanch.com

Hi! I was wondering what might be the pros & cons of separating one app's data in multiple schemas (based on years for example)? The other solution might be to keep it all in one schema and have a naming convention. This is necessary because the data types and length in one (or various) table(s) might vary from year to year. ...

39. Schema extraction    coderanch.com

40. schema comparison/mangement tools.    coderanch.com

Hi Jeanne, Thanks for your reply. So you just write scripts, and then apply them to your local machine and then apply it to the production server? That makes plenty of sense, I guess that I just need to be better organized. After I make a schema change, I invariably have to map it in hibernate (perhaps redo if I have ...

41. db desgin question: how to improve the relationship in this schema    coderanch.com

Try putting some cardinalities on those arrows. Put them on in the format 0..1 or 1..n. See whether you get any arrows which might have more than one at both ends. Any >1 to >1 cardinalities must be got rid of, but I think you probably don't have any. You haven't underlined or otherwise marked your keys. Some of the fields ...

42. How to access current schema?    coderanch.com

43. Schema and Database    coderanch.com

Hi, a database can have multiple logical partitions called Schemas and you can manage the size,access,creation and deletion of schemas without effecting the other parts of the Database. each schemas can be mapped to one or more DB Files and can be associated with a user. Database should contain at least one schema and one or more schemas contribute to a ...

44. Current Schema doesnt work for procedure access    coderanch.com

45. Comparing database schemas    coderanch.com

Hi, I have two Oracle instances which need to be identical. One is built from an old base schema and a number of patch scripts. The other one is built from a new schema file which should be the same as the fully patched database. Is there any way to easily compare two databases using something like db-unit? I will need ...

46. Importing data into a database with a complex schema using Java    coderanch.com

I am making a utility to read a database and generate SQL INSERT statements for each row in every table. I want to be able to move data with a script from one DB to a DB at another job site. I am currently using MS SQL 2000. Problem is...the schema has foreign key (FK) constraints. I get the meta data ...

47. Regading terminology Schema & User    coderanch.com

Barring the case of enterprise users, where users are defined outside the database and then multiple users can be assigned to a particular schema, the relationship between users and schemas is 1:1. A schema is the set of objects owned by a database user. A single database user, by definition, cannot own objects in different schemas.

48. java, xml schema and relation db    coderanch.com

I am beginning a project that will require java, xml schema and relational db interaction. I'm hoping for some expert opinion on tools and/or approaches to use. The project will be saving data from a web service in a db schema that should 'match' the xml schema of the web service. So, question one: is there a tool that will generate ...

49. Transform database schema from one db to another    coderanch.com

50. use a database schema from java using jdbc    coderanch.com

51. Using Jenny with Postgres...is there a mechanism to set the schema being used?    coderanch.com

Hello! I am new to this site, and came to it by looking for a code generator for ODBC table accessors. I am testing Jenny out to see if it suits my needs. I have run into an issue with using a Postgres DB. When using the Jenny generated method for getting a row from a table, the generated SQL statement ...

52. Fetching Current Schema value    coderanch.com

53. Schema Comparison    coderanch.com

Hello, I need to compare 2 mysql database schemas (tables, columns, used data types, keys, constraints) and would like to have the differences displayed. Is there any free tool that can be run from the command line and which generates a report? Or is there a nice Java API which I can use? I know, there is some useful stuff in ...

54. Choosing technology for application: Relational database versus XML Schema.    coderanch.com

Hi I want to make application for studying boardgame (chess). Idea is to make collection of positions where I made poor move. I want to be able to add from many possible themes to a position and search collection by different themes to practice those types of positions. I cant make up my mind wether to simply make relational database schema ...

55. jdbc to get schema user information    coderanch.com

56. difference between instance and schema in dbms    coderanch.com

No. A schema is a group of tables owned by the same user. For example I could have "vinod" schema and "jeanne" schemas in the same database instance. Each could have a "test" table because the schema gives a different namespace. Like a package does in Java. A database instance is even higher level. Kind of like a separate database except ...

57. Keeping two schema in sink    java-forums.org

58. problem with getting alll schema names from database    java-forums.org

import java.sql.*; public class ListSchemas { public static void main(String [] args) { Connection con = null; try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost","root","ssahmsb97"); DatabaseMetaData meta = con.getMetaData(); ResultSet res = meta.getSchemas(); System.out.println("List of schemas: "); while (res.next()) { System.out.println( " "+res.getString("TABLE_SCHEM") + ", "+res.getString("TABLE_CATALOG")); } res.close(); con.close(); } catch (java.lang.ClassNotFoundException e) { System.err.println("ClassNotFoundException: " +e.getMessage()); } catch (SQLException e) { System.err.println("SQLException: ...

59. create database schema on the fly using java    forums.oracle.com

Your question is still too general, but I'll take a shot answering. One option would be to execute DDL statements using JDBC. Another one would be by using the JPA features. In any case, you have to provide your application the database account that have DBA privileges which is not such a good idea from the security point of view. Hope ...